Hey!
I'm mainly a flyff developer so i need some FlyFF website help from html coders or whatever it's coded with :pimp:, Well the thing i need help with is connecting my database to the website, i can log in succsessfully and i can also see the rankings on the server with the characters etc, but i can't register a account, since it says in the top left corner Es besteht derzeit keine Datenbankverbindung. ( There is currently no database connection). i use the Sapphire website can some one help me with this via teamviewer or just msg me i would appreciate it alot! :handsdown::handsdown:
Have a nice day!
Regards Laitila
Link to website [Only registered and activated users can see links. Click Here To Register...] idk if it works 24/7 atm
Edit: I have database connection now but i can't still register correctly i think it's beacuse i can't execute this
usp_createAccount, ACCOUNT_TBL & ACCOUNT_TBL_DETAIL
usp_createAccount
Error : Msg 207, Level 16, State 1, Procedure usp_createAccount, Line 22
Invalid column name 'OldPassword'.
ACCOUNT_TBL
Error : Msg 4901, Level 16, State 1, Line 2
ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'votepoints' cannot be added to non-empty table 'ACCOUNT_TBL' because it does not satisfy these conditions.
Msg 1752, Level 16, State 0, Line 2
Column 'votepoints' in table 'ACCOUNT_TBL' is invalid for creating a default constraint.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
ACCOUNT_TBL_DETAIL
ERROR: Msg 2705, Level 16, State 4, Line 2
Column names in each table must be unique. Column name 'secretquestion' in table 'dbo.ACCOUNT_TBL_DETAIL' is specified more than once.
That's it thanks for reading and i hope i get some help with this :)
I'm mainly a flyff developer so i need some FlyFF website help from html coders or whatever it's coded with :pimp:, Well the thing i need help with is connecting my database to the website, i can log in succsessfully and i can also see the rankings on the server with the characters etc, but i can't register a account, since it says in the top left corner Es besteht derzeit keine Datenbankverbindung. ( There is currently no database connection). i use the Sapphire website can some one help me with this via teamviewer or just msg me i would appreciate it alot! :handsdown::handsdown:
Have a nice day!
Regards Laitila
Link to website [Only registered and activated users can see links. Click Here To Register...] idk if it works 24/7 atm
Edit: I have database connection now but i can't still register correctly i think it's beacuse i can't execute this
usp_createAccount, ACCOUNT_TBL & ACCOUNT_TBL_DETAIL
usp_createAccount
Error : Msg 207, Level 16, State 1, Procedure usp_createAccount, Line 22
Invalid column name 'OldPassword'.
ACCOUNT_TBL
Error : Msg 4901, Level 16, State 1, Line 2
ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'votepoints' cannot be added to non-empty table 'ACCOUNT_TBL' because it does not satisfy these conditions.
Msg 1752, Level 16, State 0, Line 2
Column 'votepoints' in table 'ACCOUNT_TBL' is invalid for creating a default constraint.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
ACCOUNT_TBL_DETAIL
ERROR: Msg 2705, Level 16, State 4, Line 2
Column names in each table must be unique. Column name 'secretquestion' in table 'dbo.ACCOUNT_TBL_DETAIL' is specified more than once.
That's it thanks for reading and i hope i get some help with this :)