Here you go:
Code:
Use account;
Go
DECLARE @UserNO varchar(16), @AccountID varchar(16), @Password varchar(32), @Email varchar(50), @SecretA varchar(22), @SecretQ varchar(22)
SET @UserNO= '09101410275532'
SET @AccountID = 'Account ID'
SET @Password = 'Account Password'
SET @Email = 'E-Mail'
SET @SecretA = 'Secret Answer'
SET @SecretQ = 'Secret Question'
NOTE: 09101410275532 must be changed atleast 1 digit per account.
NOTE2: You must add an hashed password in 'Account Password' .. :
Code:
Use character;
Go
Update [user_character] Set character_name= '[GM]NAME' Where character_name= 'NAME'
Use google next time, it took me 2secs to find these querys.
