WHo can made it's up so this server so have many system
Refill system <<< this system i can't fix and another
ps.this aplication use activeperl ?
Printable View
WHo can made it's up so this server so have many system
Refill system <<< this system i can't fix and another
ps.this aplication use activeperl ?
??? Don't get the first part of the post, and I don't belive it uses active perl but i may be wrong.
he's asking for a guide to setup the server :)
oh...that is what I thought but the post made me think otherwise. If only I had saved the guide....
Yeah, i need the guide too to make my server...who knows someone that have it??
Well I duno who has it, I think Painter wrote/got it. I know how to do it but me writing a guide wouldn't help cause my guides arent very helpful.
so i think when i ran a bat file drrun it's ask for a perl.exe to run a *.pl file i don't sure who can relieve this suspicion
Help me
to denzer can example a guide first of part when we installed the sql2000pro and then how set it's to make it's work ?
Umm...I will give it a try.
Start up SQL Enterprise Manager. Create 3 Databases named ChrLogDB, DragonRajaDB, and TotalDB. Then goto control pannel > Administrative Tools > Data Sources (ODBC). Then Goto the USer DSN tab. Click Add and select SQL Server. Type ChrLogDB under name. Then type the resepective info under Description. Under server select the computer you are running it on. Click next. Then depending on how you setup SQL server type in the password. Or just leave in on windows Auth. Click next. The click the box that says "Change the default database to:" and select ChrLogDB. Click next and then click finish. Do the same thing for the other 2 databases changing the names of the DBs appropriatly.
Go Back to the enterprise manager. Right click on the DragonRajaDB the goto All Tasks > Restore Database. Click the bubble "From Devices" and click "Select Device". The click Add then browse to where the DragonRajaDB is stored (attached) - Another option is to run the Query Analyzer and run the script named Dragonraja_with_stored_procedures (also in the attached zip)
After this you should have all the data restored in the other DBs. Let me re-read all the stuff to see what I missed. But this stuff should keep you busy for a while.
::ADDED::
OK so now I will talk bout how to start the server. Goto DR directory/dragon server/dr51-user/Billing and run "drdbserver" -BTW to close all the windows it will open run "drclosebilling". Ok then goto DR directory/dragon server/dr51-user/DBDemon1 and run "DBDemon104p....." and that I belive is just bout as far as most have gotten. You will get an error complaining about not having a proxy server and I know how to think there is one. I will post it a bit later.
::Added::
Ok so the attachments didn't work, they were to big. So I will copy and paste the script to run in query manager.
So I hope that helps. Post your problems here or in the forums and I will see if I can help. I also need to work on progressing so...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
Wouldn't it be smarter to do this when -everything- is in order? It's kinda useless posting about it now. Sure, post the -progress- but don't post incomplete server guides or ask for them. "Plz help me set up a raja server plzzz" or more formal, "Help me set up a Raja server please, need help" I don't care how you put it, the files are not complete either way. So just wait before you ask for one. Thanks.
So why post progress if the server files are incomplete I ask you? Why work on the server files if they are incomplete? I am working on the so that when we get more and more parts of the server files I will know what to do. And I will be that much closer to completion. and as it stands we can get reasonbly far with what we have. So I guess it is kinda rude what you are saying. They just want help to get as far as possible with what they have. and I don't belive they are asking for to much. PLus if the files are incomplete I ask you why do we even have a DR section? The files are incomplete, not unusable.
sorry for more you disturb. how i got a dragonrajaDB For restore ?
so i have to do query manager
ya, you need to copy and paste the above code into query manager. and select DragonRajaDB and run the script and you should be set.
oh sorry it's promblem of me i forget selcet a db ^^"
now will next process to make my server work
ehh i check in dragonrajadb and not have a newer Table so it's mean i run script it's working yet ?
so in file mental upload it's include a folder of db_sql_set and i saw a creat.sql file and i don't know how i query for where DB ?
sorry for blur message. so i weak in english
Edit [dont even tripple post again]
Quote:
Originally Posted by prdgroup
prdgroup you chinese ? or brazilian ?
So true , the only think i see that might be missing would be the maps.Quote:
Originally Posted by Denzer
I'll try it this weekend since i forgot to bring my Cds with sql , ( this is what happens when someone stays without internet for 5 months :P )
about perl , have you tried cygwin ?