dbo.tbl_useraccount or devaccount missing columns

Newbie Spellweaver
Joined
Oct 9, 2012
Messages
18
Reaction score
0
Hi!

Whenever I add an account some of the columns are not present in useraccount or devaccount. Should I add manually the columns? But the problem is im not sure of what type it should be. For example the field "class". Please help...
 
i think you should include what is your server...
it will be much better so we can know how to help,
and i think you can ask in your first threat, why bother create a new one???
if you use kaswynn server,
that query won't work at all...
that'll useless even you create a new table or change it to devaccount table...

if you really have much problem about registering a new account,
try to use this files....
View attachment register.rar
if it doesn't work,
then run this query :
normal account
Code:
INSERT INTO exgame.dbo.x2o_user (UserId,Password,UserName,email) VALUES ((CONVERT (binary(12),'username')),(CONVERT (binary(12),'password')),'username','email')

INSERT INTO exgame.dbo.x2o_user1 (UserId,Password,UserName,email) VALUES ('username','password','username','email')

INSERT INTO rfweb.dbo.userlogin (userid,password) VALUES ('username','password')
note : change username, password, and email after word "VALUES" to your ID information

GM account
Code:
INSERT INTO exgame.dbo.x2o_user (UserId,Password,UserName,email) VALUES ((CONVERT (binary(12),'username')),(CONVERT (binary(12),'password')),'username','email')

INSERT INTO exgame.dbo.x2o_user1 (UserId,Password,UserName,email) VALUES ('username','password','username','email')

INSERT INTO rfweb.dbo.userlogin (userid,password) VALUES ('username','password')

INSERT INTO rf_account.dbo.tbl_UserAccount (id,grade,subgrade) VALUES ((CONVERT (binary(12),'%username%')),'2','4')
note : change username, password, and email after word "VALUES" to your ID information

actually, i've shared that query on this forum, but, i don't know if you are that lazy to search...
if you really2 don't know how to use that query,
this is the sql file :
View attachment create.rar
 
Upvote 0
Back