Quote:
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 :D
pls Help Me !
well this is ... just use your brain.exe lol it says something about identity of RowID column ... cmon ..Quote:
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.
[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]
That was it. Tried it again and clicked everything there. That worked. I thought this was for something other. Thanks dude ;)Quote:
what you gotta do is go into design mode for users_master
...