All right now, i know A LOT of people have been having trouble making a v15 server, so I've decided to make a more detailed guide with most of the fixes in them.
Downloads!
Repack + Client + Databases
Neuz
Mssql
Resource Hacker
Databases Only
Guide:
The first thing you need to do is install
MSSQL. Just run the setup and go through the installation,
DO NOT forget to make it in mixed mode and enter a good password.
After the installation is done you need to restore the databases. All the databases can be found in the
"DATABASE" folder. For convenience you should copy them to your
MSSQL's backup folder. Now that they are in the backup folder, Start
MSSQL Server Management Studio Express and login using
SQL Auth.
Your username: sa
Your passowrd: the password you chose
Instance:
Yourpcname\SQLEXPRESS
After you've logged in, right click on database and click
"Restore Database". Now a screen should pop up, Put in your databases name. The names should be like this
Code:
[B]ACCOUNT_DBF
CHARACTER_01_DBF
ITEM_DBF
EoCRM_DBF
EoCRm_DBF_R
MANAGE_DBF
RANKING_DBF
LOGGING_01_DBF[/B]
After you put the name of the database in, check
"From Device"
and click on the "..." button next to it and click on add and select your .bak file as i mentioned at the beginning the .bak files should popup after pressing add.
After that click on
"OK"
Below the "From Device" Field will now be your Backup location
Check the
"Restore" column and click on
"Options" and check
"Overwrite existing Database"
in the Field below you need to set your
SQL DATA Folder
Code:
C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\DATA for x64 Systems
or
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA for x86 systems
After all that is done, click OK and the database should be restored, make sure you do this for ALL of them.
Now you need to link the servers on this part.
Add linked server
"RANKING"
Code:
exec sys.sp_addlinkedserver 'RANKING', '', 'SQLNCLI', 'SQL SERVER INSTANZNAME', null, null, 'RANKING_DBF'
exec sys.sp_serveroption @server='RANKING', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='RANKING', @optname='rpc out', @optvalue='true'
Add linked server
"ACCOUNT"
Code:
exec sys.sp_addlinkedserver 'ACCOUNT', '', 'SQLNCLI', 'SQL SERVER INSTANZNAME', null, null, 'ACCOUNT_DBF'
exec sys.sp_serveroption @server='ACCOUNT', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='ACCOUNT', @optname='rpc out', @optvalue='true'
Add linked server
"CHR01"
Code:
exec sys.sp_addlinkedserver 'CHR01', '', 'SQLNCLI', 'SQL SERVER INSTANZNAME', null, null, 'CHARACTER_01_DBF'
exec sys.sp_serveroption @server='CHR01', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='CHR01', @optname='rpc out', @optvalue='true'
DO NOT just copy and paste then run these, you need to edit something in them,
change SERVER INSTANZNAME to your instance name.
Now its ODBC time, open up run.exe and type in odbcad32.exe
and hit run.
Now ODBC should open up, Click on
USER-DSN and press
"ADD".
YOU MUST FOLLOW THIS EXACTLY
First, choose
SQL NATIVE CLIENT and click finish.
You need to create these odbc's in order for everything to work correctly.
Code:
[B]log01
login
character01
ranking
manage[/B]
In the
NAME field, type in the
ODBC name from above. In server name type in your
SQL server instance.
Next choose
SQL Authentication mode and enter your password.
NOTE: This DOES NOT ALWAYS WORK, if you have problems with running the exe's at the end you need to change this to WINDOWS AUTHENTICATION.
In the next window set the default database like this.
Code:
[B]login = ACCOUNT_DBF
Character01 = Character_01_DBF
log01 = logging_01_dbf
ranking = ranking_dbf
manage = manage_dbf[/B]
At the next screen there's nothing much to do
EXCEPT if your OS is in a different language you need to change the default language to
ENGLISH in this screen. Or else you'll have problems.
Thats one ODBC down, now you need to do the rest.
After all this is done you need to go into your Files folder and edit all the ini's. Where it says
YOURIP, enter in 127.0.0.1. And in worldserver.ini and database.ini, make sure you edit the resource path to match your own resource folder path.
Last thing is to run your server files, they are numbered so this part is pretty simple.
If you got errors with the login incorrect in one of the error files. Try and run all Servers in Adminstration mode (RightClick + Run As Administrator) or turn off the UAC this will fix the prob.
and make sure all ODBC's are running on Windows Authentication
Now you should have a 100% working v15 server.
You should now RESHACK your Neuz.exe. Download Reshacker and open neuz.exe in it. Change the port to 15400 and the IP to 127.0.0.1 IF YOUR HOSTING IT ON YOUR PC, If not then change it to YOUR server's IP
Creating An Account
This is how you create an account, the CORRECT way.
Find the dbo.CREATEACCOUNT procedure in the release section, it is posted by Reimniess.
DO NOT USE the dbo.ASP.createaccount OR ANYTHING like that, they DO NOT WORK!
Execute the SQL you get from his post and make sure it is executed in the ACCOUNT_DBF databases.
Then go to the procedure and EXECUTE it.
You should see two fields you need to fill. Put in your USERNAME in the first one. MAKE SURE IT IS ALL LOWERCASE.
Then go to here and in the field put in serusadmin.
Then click the md5 button at the bottom and you should get
Code:
ef9e8ddbf4e00ffef8991065a3fdef8c
copy and paste that and put it into the password field under your username.
Now press EXECUTE and execute the script, now you should have an account with the password "admin" with no "" around it.
Hopefully this will be the LAST time i have to post about making an account since it is VERY VERY easy to make an account.
NOTES: serus is the SALT, you need to use this SALT everytime you create an account, i don't know what a SALT is nor do i really care, all i know is that you MUST use this SALT to make your account work. Or ASK SERUS to remove the salt from the neuz.exe or do it yourself.
PS: The CAPS are used only so that it becomes more clear, I'm neither flaming or yelling XD
To create an account an admin, run this query.
Credits
SerusUriel for the repack and first guide.
Synaptic for the Linked Server queries.
Dell Honne for reshack/fixes/guide.
Treachery for the Database link.
Note: Guide looks like crap i need to fix it up a lot! If i missed something please tell me, also if you still need help feel free to post in this thread, i will try to help you or someone else will be able to.
