Need some help

09/17/2009 22:45 drew666#1
Ok i have a server it up and running and database is connected in SQL. But how do i make a account. that one part i cant figure out. If you have a answer please add me to msn [Only registered and activated users can see links. Click Here To Register...]. Or post it here.

We are also lookign for a Staff to help run our server
09/08/2010 20:48 Gorgon09#2
You can manually add an account into the database.

Under the PS_UserData>Tables>dbo.Users_Master
Right-click and click on Open Table.
Enter your info and exit the table to save.

Don't ask me how u make a normal account, I haven't figured that out yet :).
09/13/2010 07:17 FeatherDust#3
Ok, to make a new account, you must have two tables open. First one to open: PS_UserData > Tables > dbo.Users_Master
When in that table, it'll look something like this:
RowID UserUID UserID Pw JoinDate Admin AdminLevel UseQueue Status Leave LeaveDate UserType UserIp ModiIp ModiDate Point Enpassword Birth

Your going to leave RowID alone each time. For UserUID, you put the next number in line. For UserID, it's the username you want to sign in with. Password is quite obvious. xD For the joindate, put the same date for each one. It's just easier for you. But make sure it's a date either that exact or in the past. Admin is to be True if it's an admin account, False if it isn't. AdminLevel is going to be set at 255 if your an admin, 0 if your a regular player. UseQueue is always false. Status is 16 for admins, 4 for regular players. Leave is always 0. LeaveDate is just any day in the future. I usually do 50 yrs later. UserType is A for admin, N for normal player. UserIP, ModiIP, ModiDate are all Nulls all the time. Point is how much AP (or whatever you call it) a player has. Enpassword & Birth are also always Null.

Now for 2 examples. Admin first, then regular player. Realize these are just examples, and not true logins:

3 Kikyo random 6/25/2010 True 255 False 16 0 6/25/2050 A NULL NULL NULL 9999999 NULL NULL

16 Toxic ohyea1 6/25/2010 False 0 False 4 0 6/25/2050 N NULL NULL NULL 10000 NULL NULL


Now for your next table. Open OMG_GameWEB > Table > dbo.GameAccountTBL. The rows should be as marked: UserUID GameAccount OneTimePassword OTPExpireDate DelCharPWD CreateDate

UserUID is the same as the number you put in the other table. GameAccount, OneTimePassword and OTPExpireDate are also the same as in the other table. DelCharPWD is always going to be 1. CreateDate is also the same from the other table. Examples below:

3 Kikyo random 6/25/2050 1 6/25/2010

16 Toxic ohyea1 6/25/2050 1 6/25/2010


Hope that cleared it up a bit more for you. Good luck!