Quote:
Originally Posted by ThunderNikk
Whats not working?
What is the error.?
I have to say the character creation SQL script (not PHP) does work. It is something else that is not working.
|
I'm having this error when i'm making an account,
[Only registered and activated users can see links. Click Here To Register...]
,also the code that you shared i used it in SQL and change everything to my account but still not working.
PS: the ID+Pas I'm using now its the same one from this threat owner, so i want to make a new one off my own.
-thnx!
Quote:
Originally Posted by ThunderNikk
Do this part and I will post a SQL insert command in a minute...
We are going to redesign the account table in the database a little bit so you are going to need to make sure that you have design editing turned on because I didn't at first.
[Only registered and activated users can see links. Click Here To Register...]
1. Open your MSSQL server management window and connect to your database.
2. Expand your database folder
3. Expand your auth database
4. Expand you tables folder
5. Right click on your dbo.Account table and select design from the right click context menu
6. Select the row for account_id in the design window
7. In the bottom design pane scroll down to where you see "Identity Specification"
8. Expand that by clicking on the arrow to the left of it
9. Where it says (Is Identity) on the right side of that if you select the area where it says no use the drop down arrow and change it to yes
10. The two fields below it should say Identity Increment 1 and Identity Seed 1
Then last of all in the top design window go to the first row that is empty and add age
age, Int, and check the box to allow nulls
It is in the script and as long as we are making the user enter it we might as well collect that data.
11. Click on the save icon in the tool bar to save the changes you have just made to the dbo.Account table.
|
the code
INSERT INTO [Auth].[dbo].[Account] ([account], [password], [email], [password2], [block], [IP_user], [last_login_server_idx], [Admin], [point], [datePassword], [pk_]) VALUES ('YourAccountNameHere', 'YourPasswordHere', 'YourEmailHere', 'YourPasswordHere', '0', '127.0.0.1', '1', '1', '0', '2017-10-20', '1');
use both passwords with MD5?