Shaiya Account Register Problem

[musmuss2]

Hello,when I want to create an Account at my Shaiya Server comes Account doesnt exsist when I try to enable (Allow Nulls) At RowID at dboUser Master
I get an Error "Allow Nulls property cannot be set on columm `RowID` because it is an identity columm"


sry for my bad english I'm German

pls Help Me !

[.Mamamia.]

Originally Posted by musmuss2

Hello,when I want to create an Account at my Shaiya Server comes Account doesnt exsist when I try to enable (Allow Nulls) At RowID at dboUser Master
I get an Error "Allow Nulls property cannot be set on columm `RowID` because it is an identity columm"


sry for my bad english I'm German

pls Help Me !

RowID is useless, just delete this column from the table.

[MajinNick]

I have a bit of useless question... how do I register a [GM] and a normal Player Account into my server? I cant figure it out by myself >.<

[nubness]

A GM account has
Admin = True, AdminLevel = 255, Status = 16/32, UserType = 'A'
A normal account has
Admin = False, AdminLevel = 0, Status = 0, UserType = 'N'

[MajinNick]

And where do I do this? I cant seem to find how and where to register that... <.< maybe I should make a tutorial if I know how to do this...

[nubness]

The game accounts are located in the PS_UserData.dbo.Users_Master table.

[MajinNick]

(First of all: Thanks for your support )

Ok seems logical... umm I rightclicked it and it showed me something like:

COLUMN NAME | DATA TYPE | ALLOW NULLS

RowID............| Int............|(Box)
UserUID............| Int............|(Box)
UserID............| varchar(18)............|(Box)
Pw............| varchar(12)............|(Box)

And so on. I'm not sure what to do with these files. If I just click the dbo.Users_Master it expands and in there are files like "Columns", "Keys", "Constraints" etc.

[nubness]

The letters of your name can make the word Nicki Minaj, which is why I assume you're unable of figuring the easiest stuff on your own. Give up on having a Shaiya server before it's too late.

[MajinNick]

Umm nope. I created this account years ago when this "girl" wasnt even famous. I just am not that talented at beginning. I crashed SQL for like 10 times without coming with a question. That's the only thing, I can't figure out by myself.

[Autrux]

#moved

[olinou2]

Originally Posted by MajinNick

(First of all: Thanks for your support )

Ok seems logical... umm I rightclicked it and it showed me something like:

COLUMN NAME | DATA TYPE | ALLOW NULLS

RowID............| Int............|(Box)
UserUID............| Int............|(Box)
UserID............| varchar(18)............|(Box)
Pw............| varchar(12)............|(Box)

And so on. I'm not sure what to do with these files. If I just click the dbo.Users_Master it expands and in there are files like "Columns", "Keys", "Constraints" etc.

well this is ... just use your brain.exe lol it says something about identity of RowID column ... cmon ..

what you gotta do is go into design mode for users_master , click on Row ID clomun then look at the botom in column properties , press + to identity specification then (is identity ) = no. You may now let it allow nulls . But you'll have to do the same thing with UserUID , but next to (is identity ) it should be yes and leave the other things under it as default .

If you still cant make it to work there is a script on forrums that can solve the problem , you wanna have to use the search function tho , cauz what i just explained can be found easily

[SpaceCase521]

most of your info for development can be

[FONT=Times New Roman][SIZE=3]dbo.Users_Master value and definition[/SIZE][/FONT]
[SIZE=3][FONT=Times New Roman][RowID] should autofill unless you made acception for Null Value or delete the column[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][UserUID] Autofill only [/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][UserID] Input Username for account (Not toon name)[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][Pw] Input Password for account[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][JoinDate] input current date and time in "yyyy-mm-dd hh:mm:ss" format (time is on a 24hr or military format)[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][Admin] if Staff (I.E. Admin, Dev, GM, GS, or other) value is "True"; if a regular player then value is "False"[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][AdminLevel] if Staff then value is "255" if not then value is "0" [/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][UseQueue] Value is Always False[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][Status] Reg Player value is "0" Admin value is "16" other Staff is 32, 48, 64, or 80. (*1)[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][Leave] Value is either "0" for active account or "1" for account marked for deletion[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][LeaveDate] Current date +30 years (or however long you feel is appropriate) *see "JoinDate" for format [/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][UserType] Regular player value is "N" Staff account value is always "A"[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][UserIp] Either Null or the Players Ip address (not your IP address unless it is your account)[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][ModiIp] Value is Always "Null"[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][ModiDate] Value is Always "Null"[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][Point] Value is always the mall points from the in-game item mall[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][Enpassword] Value is "null" unless you have a GameGuard for your server then value is "True"[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman][Birth] Value is Always "Null"[/FONT][/SIZE]
[FONT=Times New Roman][SIZE=3]*1) How does Status work in dbo.Users_Master?[/SIZE][/FONT]
[SIZE=3][FONT=Times New Roman]Below is a list of known Status numbers and their description:[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-1 - Connection with server has been disconnected.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-2 - Can't connect with the account since it's not selected as free challenger.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-3 - Account doesn't exit.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-4 - ID in process of termination following user's request.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-5 - Your account is blocked now. You can't log into the game.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-6 - Your account is blocked now. You can't log into the game.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-7 - Account still restricted.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-8 - Connection with server has been disconnected.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-9 - Your account is blocked now. You can't log into the game.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-10 - Account still restricted.[/FONT][/SIZE]
[FONT=Times New Roman][SIZE=3]‒-11 - Account still restricted.[/SIZE][/FONT]
[SIZE=3][FONT=Times New Roman]‒-12 - ID in process of termination following user's request.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-13 - Your account is blocked now. You can't log into the game.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-14 - Your account is blocked now. You can't log into the game.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-15 - Account still restricted.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒-16 - ID in process of termination following user's request.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒0 - Normal account[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒1 - Stop (Can't connect to the game following user's request.)[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒2 - Block (Game) (Account doesn't exit.)[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒4 - Block (Web) (Account doesn't exit.)[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒6 - Block (Game + Web) (Your account is blocked now. You can't log into the game.)[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒8 - Block (Character)[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒9 - Account still restricted.[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]16 - GM permissions 1 – GM with full Operator's permissions[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]32 - GM permissions 2 – GM with less permissions than 16[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]48 - GM permissions 3 – GM with less permissions than 32[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]64 - GM permissions 4 – GM with less permissions than 48[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]80 - GM permissions 5 – GM with least Operator powers[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]128 - Withdrawal[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]-256 - Withdrawal (3 days processing)[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]‒512 – Withdrawal 15 days[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]17~81 - GM + stop[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]▪Credits go to ->Angel<-, USD – Shaiya Developer Group, and PROFNERWOSOL[/FONT][/SIZE]

[MajinNick]

Originally Posted by olinou2

...
what you gotta do is go into design mode for users_master
...

That was it. Tried it again and clicked everything there. That worked. I thought this was for something other. Thanks dude

[olinou2]

yw ,but like i said try using the search function man , theres tons of thread about this subject xD

[Autrux]

#closed as request