DragonRaja PServer Setup

Lowfyr · 09/09/2005, 11:41

Server Files:

Made by Thralas

-----------------------------------------
Dragon Raja 1.4 Unofficial server manual
Made for Windows XP Professional
-----------------------------------------

I. Requirements
Make sure you have 'server.rar' (12.956.430)
MD5: f4938b88d74128b27750c28cb97e0022
Unrar it somewhere.

Download and install Microsoft SQL Server 2000 (Use Windows Auth as the authentication method).
An evaluation version is available for download at

II. Setting up the database
Start MS SQL's Enterprise Manager and create three databases.
(Select the server and then rightclick on Databases > New database)

- ChrLogDB
- DragonRajaDB
- TotalDB

Now rightclick DragonRajaDB and select (All tasks > Restore Database).
Select "From file" and browse to the dir that contains "DragonRajaDB". Select it.
Hit Ok twice and go to the Options tab.
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).
Press Ok to restore DragonRajaDB using the supplied backup file.

Now you'll have to set up some Data Source Names.
Hit start and click run, enter "odbcad32.exe" and click Ok.
Go to the "System DSN" tab, click add, and select "SQL Server".
Press next and fill in the fields.

Name: ChrLogDB
Description: Character Log DB (Whatever)
Server: (select your SQL server)

Hit next again, next, and select "ChrLogDB" as the default database.
Next, finish.

Repeat these steps for DragonRajaDB and TotalDB, the only difference is name & default database.

III. Starting the server
Browse to the directory where you unrarred server.rar. Go to /dragon server/dr51-user/Billing and start the Billing server.
Then go to /dragon server/dr51-user/DBdemon1 and run the DBdemon.

-----------------------------------------
Well, that's as far you can currently get. Enjoy.

Stored Procedures

Code:

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_accessory&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_accessory&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_armor&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_armor&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_cook&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_cook&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_disposable&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_disposable&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_etc&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_etc&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_herb&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_herb&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_mineral&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_mineral&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_plant&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_plant&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_potion&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_potion&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_tool&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_tool&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_item_weapon&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_item_weapon&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_map_info&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_map_info&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_noid&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_noid&#93;
GO

if exists &#40;select * from dbo.sysobjects where id = object_id&#40;N'&#91;dbo&#93;.&#91;up_get_skill_main&#93;'&#41; and OBJECTPROPERTY&#40;id, N'IsProcedure'&#41; = 1&#41;
drop procedure &#91;dbo&#93;.&#91;up_get_skill_main&#93;
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_accessory&#93; AS
SELECT * FROM Item_Accessory;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_armor&#93; AS
SELECT * FROM Item_Armor;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_cook&#93; AS
SELECT * FROM Item_Cook;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_disposable&#93; AS
SELECT * FROM Item_Disposable;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_etc&#93; AS
SELECT * FROM Item_Etc;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_herb&#93; AS
SELECT * FROM Item_Herb;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_mineral&#93; AS
SELECT * FROM Item_Mineral;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_plant&#93; AS
SELECT * FROM Item_Plant
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_potion&#93; AS
SELECT * FROM Item_Potion;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_tool&#93; AS
SELECT * FROM Item_Tool;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_item_weapon&#93; AS
SELECT * FROM Item_Weapon;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_map_info&#93; AS
SELECT * FROM map_info;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_noid&#93; AS
SELECT * FROM noid;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE &#91;dbo&#93;.&#91;up_get_skill_main&#93; AS
SELECT * FROM Skillmain;
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

Yes there are useless system stored procedures, and yes the syntax is incorrect

hipudel · 10/18/2008, 14:40

Server Files sind down
bitte neu hochladen

zhengzhichu1982 · 10/30/2008, 22:25

Damodar13 · 11/19/2008, 22:35

link server files are down, can you make a new link please ?

hambal · 11/19/2008, 23:58

make vid its easier

kliab · 11/11/2010, 22:46

I need the server files
and client

Soiken · 11/12/2010, 13:09

Quote:

09-09-2005, 11:41

This is the date when Lowfyr made the thread.

Quote:

11-19-2008 23:58

And this is the date of last post next to You.

Why the hell do You people dig 5 years old threads?
I bet that those files don't work anymore...