[Request] how to add new accounts to DB..

01/16/2011 19:32 Javi01#1
sorry i keep searching but can't find... idk maybe i'm searching wrong.. sorry guys.. if you can help great
01/16/2011 22:42 AriezOMG#2
01/17/2011 00:01 Javi01#3
haha yeah i found this randomly searching on google, thanks ariez
01/18/2011 01:53 Bаne#4
It was the "for dummies" that helped me understand :D
01/24/2011 08:44 Sinful858#5
Lol @ the "dummies" part. Making accounts is probably one of the simplest things to do in the DB (in my opinion)

Start with OMG_GameWEB\Tables\dbo.GameAccountTBL\Open Table
When you open it, there is always 1 account or 2 in there for Admin's so it is pretty much fill in the blanks following the row above it. Always make sure once you have made the account, to execute the SQL "!" It's that Red Exclamation point. Also remember the UserUID number for that account in which you made since you will be needing that when you go into Users_Master

After you did that, you need to go to PS_UserData\Tables\Users_Master\Open Table
Here you will do just about the same thing as you did in the OMG_GameWEB, except fill in the correct columns that determine whether or not they are going to be a GM toon or just a standard toon.

First start off by entering the UserUID number in which you created in the OMG_GameWeb, then enter the same UserID & Password (PW).**If these UserID & PW don't match the user won't be able to log in!** So double check spelling ^^ The next few columns are important so make sure you know what to enter for Admin & Standard.

If the account is going to be an GM account (Admin) then you would enter the following for these columns:

Admin: True
AdminLevel: 255
UseQueue: False
Status: 16 (This can be set to another status if you are trying to limit how much power this account has I.E /amove, /asummon etc. but not /getitem /mmake etc etc.)
The rest will mostly be "NULL" since you are manually making this.
Point: (W.e you want it to be.) Point is OS terms Aeria Points aka AP. so for GM's put any amount there you like, but I would suggest no more then 999999 or you will get a error.

Now if you are making a regular account then the following will be entered as such:

Admin: False
AdminLevel: 0
UseQueue: False
Status: 0
Point: 0 (You can always change this after they have donated)

Once you have done that press the "!" Red Execution button to finish your data.
So yea, pretty simple. :)
07/04/2011 02:45 CaSTieL.URieL#6
Sorry if i answer afer months but i'm trying to do that but i don't have OMG_GameWEB in database or i can't find it..I use mssql 2008 rc...In italian language...So i have a lot of folders wiht lot of file in database but don't know what to do with them...Anyway i don't have OMG_GameWEB...Where can i donwload one?
07/04/2011 03:39 [Admin]Snuggle#7
You don't need GameWEB.
It's useless. Only need to go into PS_UserData then Users_Master
07/04/2011 10:38 CaSTieL.URieL#8
Yeah Yeah i've seen :) Ty But i still have a problem! xD
Now that i know username and password..I tryed to log in Select server and..Connection with server has been disconnected..Error 0...Tryed different ps clients and different exe..Always the same..Seems like i can Run ep4 but no ep 5 T.T
07/04/2011 16:45 CaSTieL.URieL#9
I don't know how but my ep 5 server now work *__*
07/27/2011 18:23 Shaiya98#10
lol you forgot the Commands Login 01 right click commands than /vchkoff
and Game right click commands than /nprotectoff thats fix youre problem
07/28/2011 02:35 Javi01#11
look at the date this was posted.. stop bringing up extremely old posts..