Rappelz server files

demonroro · 04/07/2011, 00:46

Quote:

Originally Posted by axmadz

please share in mediafire

Go to

=)

Pyrok · 04/07/2011, 01:03

Grrr.. I just killed my db and recreated it using the .sql files I posted. For whatever reason it skipped 4 tables. Here's sql that will create those. They are all in Arcadia. For what it's worth, it took maybe 5 minutes to track the problem tables down in Profiler.

Spoiler

Code:

USE [Arcadia]
GO

/****** Object:  Table [dbo].[RandomPoolResource]    Script Date: 04/06/2011 17:52:35 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RandomPoolResource]') AND type in (N'U'))
DROP TABLE [dbo].[RandomPoolResource]
GO

USE [Arcadia]
GO

/****** Object:  Table [dbo].[RandomPoolResource]    Script Date: 04/06/2011 17:52:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[RandomPoolResource](
	[sid] [int] NULL
) ON [PRIMARY]

GO


/****** Object:  Table [dbo].[GlobalVariable]    Script Date: 04/06/2011 17:52:49 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GlobalVariable]') AND type in (N'U'))
DROP TABLE [dbo].[GlobalVariable]
GO

USE [Arcadia]
GO

/****** Object:  Table [dbo].[GlobalVariable]    Script Date: 04/06/2011 17:52:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[GlobalVariable](
	[sid] [int] NULL
) ON [PRIMARY]

GO


/****** Object:  Table [dbo].[SummonUniqueNameResource]    Script Date: 04/06/2011 17:53:47 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SummonUniqueNameResource]') AND type in (N'U'))
DROP TABLE [dbo].[SummonUniqueNameResource]
GO

USE [Arcadia]
GO

/****** Object:  Table [dbo].[SummonUniqueNameResource]    Script Date: 04/06/2011 17:53:47 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SummonUniqueNameResource](
	[sid] [int] NULL
) ON [PRIMARY]

GO


/****** Object:  Table [dbo].[SummonDefaultNameResource]    Script Date: 04/06/2011 17:54:10 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SummonDefaultNameResource]') AND type in (N'U'))
DROP TABLE [dbo].[SummonDefaultNameResource]
GO

USE [Arcadia]
GO

/****** Object:  Table [dbo].[SummonDefaultNameResource]    Script Date: 04/06/2011 17:54:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SummonDefaultNameResource](
	[sid] [int] NULL
) ON [PRIMARY]

GO

j0k3r91 · 04/07/2011, 01:45

thx man!! nice jobs

XavierDeFawks · 04/07/2011, 04:26

is there a way i can download from

without downloading 1 file at a time?? ive tried tortoisesvn but that didnt work

jw988 · 04/07/2011, 04:29

Thank you very much for info Pyrok. (using sql 2008)

Spoiler

nathanmuntz · 04/07/2011, 07:55

jw988 where did u get your database just wondering?

jw988 · 04/07/2011, 08:39

all the info i used for database was in the updates files that was released a while back and info from this thread.

nathanmuntz · 04/07/2011, 08:47

any way u could send me a bakup of your databases i cant figure out how to set it up

Gangxtar1 · 04/07/2011, 16:51

pyrok ya last post was from the gameserver?
u can enter ya own server now?

demonroro · 04/07/2011, 18:47

Quote:

Originally Posted by xXExiledXx

is there a way i can download from without downloading 1 file at a time?? ive tried tortoisesvn but that didnt work

Sry for the inconvenience, i will make a a repack archive tonight.

demonroro · 04/07/2011, 21:37

@Pyrok Can you give Map folder and TerrainSeamlessWorld.cfg ? mine still crashing ...

Link404 · 04/07/2011, 21:53

Quote:

Originally Posted by Pyrok

Yep. What I did was start at the oldest rdu files, copied them to a folder, then worked my way to the newest, always replacing when asked. It is completely possible that the aor client is "matched" to a different server version.

CaptainHerlockServer - 2,560,000 bytes (2009-10-09)
PrincessAuroraServer - 761,856 (2009-04-30_Epic6)

Those are the ones I'm using. Here's the rdu files I used.

Spoiler

Code:

10/06/2009  08:23 PM             1,063 AuctionCategoryResource.rdu
10/06/2009  09:00 PM             1,436 AutoAuctionResource.rdu
10/09/2009  01:44 PM               600 ChannelResource.rdu
10/06/2009  08:47 PM               152 ChannelUserLimitResource.rdu
10/09/2009  02:23 PM           652,889 CharacterMotion.rdu
10/09/2009  01:07 PM           540,264 DropGroupResource.rdu
10/07/2009  06:55 PM            49,759 DungeonResource.rdu
10/09/2009  01:45 PM            34,221 EffectResource.rdu
10/06/2009  09:20 PM           680,026 EnhanceFX.rdu
10/09/2009  01:07 PM            75,652 EnhanceResource.rdu
10/07/2009  06:55 PM            83,311 FieldPropResource.rdu
10/06/2009  08:23 PM               203 FieldPropSwitchingResource.rdu
10/09/2009  01:46 PM             2,905 GroundMaterialResource.rdu
10/06/2009  09:20 PM             4,560 HuntaholicHealingPropResource.rdu
10/09/2009  01:46 PM             1,178 HuntaholicInstanceResource.rdu
10/06/2009  06:53 PM            10,983 HuntaholicMonsterRespawnResource.rdu
10/06/2009  08:23 PM               419 HuntaholicResource.rdu
10/09/2009  01:12 PM         7,008,962 ItemResource.rdu
10/06/2009  09:22 PM             2,455 JobResource.rdu
10/07/2009  07:01 PM           155,014 MarketResource.rdu
10/09/2009  01:12 PM           461,436 MixResource.rdu
10/09/2009  01:50 PM            47,714 ModelEffectResource.rdu
10/09/2009  01:51 PM           102,372 MonsterMotionSet.rdu
10/09/2009  01:15 PM         4,278,563 MonsterResource.rdu
10/06/2009  06:58 PM           275,597 MotionSet.rdu
10/09/2009  01:15 PM           164,857 NPCResource.rdu
10/06/2009  09:03 PM             6,971 PetResource.rdu
10/09/2009  01:53 PM            13,658 QuestLinkResource.rdu
10/09/2009  02:32 PM            96,820 QuestResource.rdu
10/09/2009  01:54 PM             1,656 RoamingPointResource.rdu
10/09/2009  01:54 PM               795 RoamingResource.rdu
10/06/2009  07:29 PM             3,230 SetItemEffectResource.rdu
10/09/2009  01:54 PM           182,446 SkillJPResource.rdu
10/07/2009  07:06 PM         1,172,004 SkillResource.rdu
10/07/2009  07:06 PM           369,263 SkillStage.rdu
10/09/2009  01:55 PM             6,989 SkillTreeDisplay.rdu
10/07/2009  07:07 PM           257,340 SkillTreeResource.rdu
10/07/2009  07:07 PM           335,323 StateResource.rdu
10/09/2009  01:56 PM            27,143 StatResource.rdu
10/06/2009  09:06 PM         4,724,039 StringResource.rdu
10/06/2009  09:26 PM             4,898 SummonLevelResource.rdu
10/09/2009  02:32 PM            28,433 SummonResource.rdu
10/09/2009  02:33 PM         1,067,229 WorldLocation.rdu

Seriousely: You are AWESOME!
Thanks alot for your great help, I'm gonna check this out later on and report back if it worked.

Gangxtar1 · 04/07/2011, 22:43

demonroro what sql u are using? 2005 or 2008?
cause i cant restore the .bak files
i got 2005

or maybe i do it wrong, pls tell me how i have to do that

i dont have the .mdf files

demonroro · 04/07/2011, 22:48

Quote:

Originally Posted by Gangxtar1

demonroro what sql u are using? 2005 or 2008?
cause i cant restore the .bak files
i got 2005

or maybe i do it wrong, pls tell me how i have to do that

I'm using SQL Server 2005. What's the error msg ?

Gangxtar1 · 04/07/2011, 23:01

its looking for Auth.mdf , but i dont have this one mssql cant find the path.

added the error msg pic to last post