-----------------------------------------
CG Y]r.O*
Dragon Raja 1.4 Unofficial server manual
,Qvclu8r
Made for Windows XP Professional
,Qvclu8r
-----------------------------------------
,Qvclu8r
,Qvclu8r
I. Requirements
,Qvclu8r
Make sure you have 'server.rar' (12.956.430)
,Qvclu8r
MD5: f4938b88d74128b27750c28cb97e0022
,Qvclu8r
Unrar it somewhere.
,Qvclu8r
,Qvclu8r
Download and install Microsoft SQL Server 2000 (Use Windows Auth as the authentication method).
,Qvclu8r
An evaluation version is available for download at
,Qvclu8r
http://www.microsoft.com/downloads/...&displaylang=en
,Qvclu8r
,Qvclu8r
II. Setting up the database
,Qvclu8r
Start MS SQL's Enterprise Manager and create three databases.
,Qvclu8r
(Select the server and then rightclick on Databases > New database)
,Qvclu8r
,Qvclu8r
- ChrLogDB
,Qvclu8r
- DragonRajaDB
,Qvclu8r
- TotalDB
,Qvclu8r
,Qvclu8r
Now rightclick DragonRajaDB and select (All tasks > Restore Database).
,Qvclu8r
Select "From file" and browse to the dir that contains "DragonRajaDB_with_stored_procedures". Select it.
,Qvclu8r
Hit Ok twice and go to the Options tab.
,Qvclu8r
Make sure "Force restore over existing database" is checked, and edit the physical paths to point to your MS SQL Data directory. (They might be correct already).
,Qvclu8r
Press Ok to restore DragonRajaDB using the supplied backup file.
,Qvclu8r
,Qvclu8r
,Qvclu8r
Now you'll have to set up some Data Source Names.
,Qvclu8r
Hit start and click run, enter "odbcad32.exe" and click Ok.
,Qvclu8r
Go to the "System DSN" tab, click add, and select "SQL Server".
,Qvclu8r
Press next and fill in the fields.
,Qvclu8r
,Qvclu8r
Name: ChrLogDB
,Qvclu8r
Description: Character Log DB (Whatever)
,Qvclu8r
Server: (select your SQL server)
,Qvclu8r
,Qvclu8r
Hit next again, next, and select "ChrLogDB" as the default database.
,Qvclu8r
Next, finish.
,Qvclu8r
,Qvclu8r
Repeat these steps for DragonRajaDB and TotalDB, the only difference is name & default database.
,Qvclu8r
,Qvclu8r
III. Starting the server
,Qvclu8r
Browse to the directory where you unrarred server.rar. Go to /dragon server/dr51-user/Billing and start the Billing server.
,Qvclu8r
Then go to /dragon server/dr51-user/DBdemon1 and run the DBdemon.
,Qvclu8r
,Qvclu8r
-----------------------------------------
,Qvclu8r
Well, that's as far you can currently get. Enjoy.
,Qvclu8r
,Qvclu8r
- Thralas
,Qvclu8r
,Qvclu8r
,Qvclu8r
,Qvclu8r
No you probably don't have the version with_stored_procedures, then just use the 36MB backup file in the /files dir of the server.rar.
,Qvclu8r
,Qvclu8r
And, seems like they never got backed up, so here are the stored procedures I recreated (attached).
,Qvclu8r
,Qvclu8r
,Qvclu8r
,Qvclu8r
QUOTE
,Qvclu8r
Quote:
,Qvclu8r
-----------------------------------------
,Qvclu8r
Dragon Raja 1.4 Unofficial server manual addition
,Qvclu8r
Made for Windows XP Professional
,Qvclu8r
-----------------------------------------
,Qvclu8r
,Qvclu8r
Seems like my database backup didn't contain any stored procedures either, run stored_procedures.sql on DragonRajaDB using the SQL Query Analyzer (Select DragonRajaDB, Paste it all and click the Play button).