Quote:
Originally Posted by ZeroSignal
I can open the client executable, and I'm positive that its going to the local Login Server, however I get a Username/Password invalid error.
Just entering a random username, or some valid US version usernames brings up Account does not exist, so it must be at least looking in the table.
I noticed that EncPassword was NULL, does that need to be set? What's wrong with the user account record? Any1 got any ideas?
|
K, here is how i make a new User. (Use SQL Server Enterprise Manager to perform following actions)
1. Go to PS_UserData DB -> Tables -> Users_Master Table -> Right Klick -> Open Table -> Return all rows
Here comes the contents of the table. We need to modify following cells:
RowID - let unchanged (the System will put the number there itself)
UserUID - for each new user use increment number, i started with 1.
UserID - account name to login with (test)
Pw - account password to login with (12345)
JoinDate - paste a date (01.01.1980 or 1980-01-01 depending on ur locale)
Admin - 0 for usual acc, 1 for Admin (im not sure bout it, but u can use only 0 or 1 for this cell, so its my guessing, used 1)
AdminLevel - 0 to 255 (seems to be Admin authority level, 255 for max, not sure though, used 255)
UserQueue - no idea what that is, used 0
Status - no idea what that is, used 0
Leave - no idea what that is, used 0
LeaveDate - leave blank
UserType - no idea what that is, used N (yes, just a letter N)
UserIP - leave blank
ModIP - leave blank
ModDate - leave blank
Point - Cash Shop Points for current user (i still have crash using Cash Shop)
Enpassword - leave blank
Birth - leave blank
After that close this Table and move to another one.
2. Go to OMG_GameWeb DB -> Tables -> GameAccountTBL Table -> Right Klick -> Open Table -> Return all rows
Here comes the contents of the table. We need to modify following cells:
UserUID - use same number as in previous Table (starting from 1 and incrementing)
GameAccount - use same name as in previous Table (test)
OneTimePassword - use same Password as in previous Table (12345)
OTPExpireDate - 01.01.2100 (or 2100-01-01 depending on ur locale)
DelCharPWD - 0
CreateDate - 01.01.2009 (or 2009-01-01 depending on ur locale)
Then close this table and try to log in using "test" as login name and "12345" as password without quotations.
My guessing is that euroshaiya and shaiya eXtreme just use some webtools to access DB and make same actions i described above to make a new user. Need to investigate the website code and scripts they r using, or maybe some of those guys will give us info >
@ZeroSignal: considering GMTool is in update folder im not sure at all
I think we r missing a lot of things in that server setup, like new maps and GMTool to control most actions from this tool and not modifing the DB directly.
I hope yn126 will be so kind and post more files/links to the missing data.