HOW TO MAKE PRIVATE SERVER Updated 12th June 2006.
Guide of downloads & how to install
This is all you need to get your server up and running, its the v1098 server complete with maps, executables and my old (but good) v1098 database, shortcuts, and updated settings. The Server is set for LOCAL. (10.0.0.1 & 127.0.0.1) youll need to adjust these.
This is Server download link.
http://rapidshare.de/files/22409779/...v1098.rar.html
The newest database is located privatly, ask around were allowing people to register, so they can read our releases, i wont post the location because im not out to steal ragezoners, i still visit here but i wont be contibuting or releasing stuff other than my guides here.
** Now Do the SQL / ODBC **
DOWNLOAD HERE http://download.microsoft.com/download/e/6...973/SQLEVAL.exe
Run SQL Setup Select "SQL Server 2000 Components"
1. Click "Install Database Server"
2. Click Next
3. Click dot in Local Computer and Next
4. Click dot in "Create a new instance of SQL Server, or install Client Tools" & next
5. Put name and company Click Next
6. Click Yes to Agreement
7. Click dot in Server and Client Tools and Next
8. Click dot in Default at top and Click Next
9. Click dot in Typical Click Next
10. Click dot in "Use the same account for each service. Auto start SQL Server
Service"
11. Click dot in "Use the Local System account" Click Next
12. Click dot in "Mixed Mode.” enter password and confirm password remember it, username is ALWAYS "sa" (server admin)
13. Click next and install
14. When installed reboot so server starts.
Restoring Database
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager)
2. Console Root -> Microsoft SQL Servers -> SQL server Group ->
3. Right click (local) (windows) -> Edit SQL server Registration properties
4. Click dot in Use SQL Server authentication -> Login name (that u gave at the install) -> leave pass empty -> click dot in Always prompt for login name and password *then add the login and pass that u gave at the install and go to Databases.
5. Create a new database, name it KN_online
6. After that, right click on KN_online database then click all tasks and
then "Restore Database".
7. Click on "From Device" and then click on "Select Devices".
8. Click Add and then choose the destination of the backups to Restore into
KN_online (this destination needs to lead to your "KN_online" database folder )
9. Press OK 2 times to continue, and then press the Options tab.
10. Click dot in "Force restore over existing database",
11. Make sure the path of the MDF and LDF files is the same of your server files
(KNonline_data and KN_online_log) (make sure they will be in your server folder)
12. Press OK to import the database.
13. Console Root -> Microsoft SQL Servers -> SQL server Group -> [local]
14. Go to Security -> Login -> Right click -> New Login
15. Put name knight -> Click dot in sql server authentication
16. Use knight as password -> Choose KN_online as database
17. Go to tab Database access -> click on database KN_online
18. In permit in database role click on db_owner -> ok
*if u get an error "user knight already existed" then go to KN_online -> users and delete the user "knight" that should be there. And then do 14-18 again
19. IMPORTANT.. Go to databases KN_online -> Right Click -> Properties -> Permission Click all of them on user knight (or it wont save items etc)
20. Disconnect from sql server and relog using the user knight in enterprise manager.
Adding Accounts
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager) and go to Databases
2. Choose KN_online (expand it open)
3. Choose Tables
4. Edit TB_USER by right click -> Open table -> Return all rows. This is were u add USER and PASS so your client can login to Server. Heres a Pic of TB_USER.
System DSN
System DSN
Start Data Sources (ODBC) Located in windows xp at, Start -> Programs -> Administrative Tools -> Data Sources (ODBC), go to System DSN tab then click Add.
If you dont have a Administrative Tools, click start, then right click, properties, then customise, advanced, and in the box start menu items scroll down till you find it and click Display on the all programs menu.
2. Select the SQL Server driver (Its at the bottom) and click Finish. Choose KN_online for Name and your SQL Server "name" for Server. Dont use [local] it doesnt work. To obtain it put your mouse over the server tray icon, right click go into Open SQL Server Service Manager, select the server name, and right click copy. Paste that as your server name.
3. Choose sql server authentication -> connect to sql server to obtain settings
Use knight as user, and knight as password.
4. Change the default database to KN_online and click Next then Finish and OK.
5. Repeat steps 2,3,4 and do the same making knight_Account, knight, GameDB, AccountDB1, AccountDB.
6. ODBC once done should look like this.
All INI files have the correct settings for a local server, youll need to edit the 10.0.0.1and 127.0.0.1 to reflect if your making a Internet accessable server, and your local internal ip.
Starting YOUR Server
1. Start Login Server -> VersionManager.exe
2. Start Aiserver -> Server.exe
3. Start Ebenezer -> Ebenezer.exe
4. Start Aujard -> Aujard.exe
Edit the Server.ini in your client folder, and it should look like this
[Server]
Count=1
ip0=127.0.0.1 (Internal) (or put IP of your friends Server)
Run the option.exe set your resolution and turn off sound etc, drop graphic quality etc
Extras
[Guide How to Make Your Self GM ]
1. Go to Start>Programs>Microsoft SQL Server>Enterprise Manager> Databases> KN_Online> Tables>User data.
2. Now Find Authority Then Change It To:
0 = GM 1 = Normal User 2 = Banned User 255 = Chat Forbidden user
Steps to backup your database file.
Open Enterprise Manager
click SQL Server, >>> SQL Server Group, >>> then your local server
click your database ie KN_online
right click KN_online , >>> all tasks, >> backup database
click remove of any names in destination, if no names present then go add
click the ... and type a name
For Example MYv1098_db_06_backup
click ok
go to options click (tick) verify upon completion
click ok,,, and its backed up
Potion Locations.
 |
