forked from LosaDev/ls-2019-source
16 lines
1.0 KiB
Transact-SQL
16 lines
1.0 KiB
Transact-SQL
-- LosaDev 2019 (optional): test accounts and seed rows (run after the schema scripts).
|
|
-- The Indonesia build only accepts IDs of 6-12 letters/digits/-/_, so "test1" is too short: the IDs are tester1 / gmtest1.
|
|
-- Passwords are stored for reference only: with TestMode=1 the billing server does not check them.
|
|
-- gmtest1's nickname GMTest1 is listed in ls_gamesvr\config\sp2_developerID.ini (developer = GM rights).
|
|
-- Any other 6-12 character ID also works: the first login creates the account (game_member_add).
|
|
USE [LosaGame]
|
|
GO
|
|
SET NOCOUNT ON
|
|
DECLARE @ret int
|
|
IF NOT EXISTS (SELECT 1 FROM dbo.userMemberDB WHERE userID = 'tester1')
|
|
EXEC dbo.web_member_add 'tester1', 'Tester1', 'test1234', '', 0, 0, 0, 0, '127.0.0.1', @ret OUTPUT
|
|
IF NOT EXISTS (SELECT 1 FROM dbo.userMemberDB WHERE userID = 'gmtest1')
|
|
EXEC dbo.web_member_add 'gmtest1', 'GMTest1', 'test1234', '', 0, 0, 0, 0, '127.0.0.1', @ret OUTPUT
|
|
SELECT accountIDX, userID, nickName FROM dbo.userMemberDB WHERE userID IN ('tester1', 'gmtest1')
|
|
GO
|