Register for your free account! | Forgot your password?

You last visited: Today at 15:32

  • Please register to post and access all features, it's quick, easy and FREE!

 

DragonRaja PServer Setup

Reply
 
Old   #1
 
elite*gold: 209
The Black Market: 135/1/0
Join Date: Jul 2003
Posts: 16,603
Received Thanks: 17,590
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
http://www.microsoft.com/downloads/details...&displaylang=en

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 (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_accessory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_accessory]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_armor]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_armor]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_cook]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_cook]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_disposable]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_disposable]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_etc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_etc]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_herb]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_herb]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_mineral]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_mineral]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_plant]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_plant]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_potion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_potion]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_tool]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_tool]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_item_weapon]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_item_weapon]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_map_info]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_map_info]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_noid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_noid]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_get_skill_main]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[up_get_skill_main]
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE [dbo].[up_get_item_accessory] 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 [dbo].[up_get_item_armor] 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 [dbo].[up_get_item_cook] 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 [dbo].[up_get_item_disposable] 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 [dbo].[up_get_item_etc] 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 [dbo].[up_get_item_herb] 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 [dbo].[up_get_item_mineral] 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 [dbo].[up_get_item_plant] 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 [dbo].[up_get_item_potion] 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 [dbo].[up_get_item_tool] 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 [dbo].[up_get_item_weapon] 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 [dbo].[up_get_map_info] 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 [dbo].[up_get_noid] 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 [dbo].[up_get_skill_main] 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



Lowfyr is offline  
Thanks
2 Users
Old   #2
 
elite*gold: 0
Join Date: Oct 2008
Posts: 30
Received Thanks: 1
Server Files sind down
bitte neu hochladen


hipudel is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
Join Date: Oct 2008
Posts: 1
Received Thanks: 0
??
zhengzhichu1982 is offline  
Old   #4
 
elite*gold: 0
Join Date: Nov 2008
Posts: 6
Received Thanks: 0
link server files are down, can you make a new link please ?


Damodar13 is offline  
Old   #5
 
elite*gold: 20
Join Date: Apr 2008
Posts: 1,840
Received Thanks: 366
make vid its easier
hambal is offline  
Old   #6
 
elite*gold: 0
Join Date: Nov 2010
Posts: 1
Received Thanks: 0
I need the server files
and client
kliab is offline  
Old   #7
 
elite*gold: 0
Join Date: May 2009
Posts: 831
Received Thanks: 239
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...


Soiken is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Metin2 Pserver SQL Setup Help Me
IT:salve, metin2 database e web script, si prega di aiutare con le impostazioni. DE:Guten Tag, metin2 database und web script, bitte helfen Sie mit...
2 Replies - Metin2 PServer - Discussions / Questions
Is there a way to setup your own pserver?
Well, title basically says it all. Is there a way you can make/host your own private server for dekaron, and what would be involved? Such as would...
2 Replies - Dekaron Private Server
WoW pServer setup!
Hey guys. Since I've read this post, I noticed that he's right and there is no english tutorial in here discribing how to set up an 1.8.0 server. ...
2 Replies - WoW PServer Hosting



All times are GMT +1. The time now is 15:32.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.