Rappelz server files

[khshe]

Originally Posted by tauppe

Hello
on my server I don t no monster, some tell me or give me the missing table

thank you

I have a strange sort of a

[tiger_td]

translate sitesinin yapacağı ancak bu kadar olur. resimler herşeyi anlatıyor server'ı kurdum ancak database te yada istemcide problem var çalışan istemciyi değiştirdim bu hale geldi. düzgünce bu işi anlatan bi kaynak yokmu nasıl kurucaz bu serverı?????????????????


Update source/script dropped :S
fixed

[manlive]

Originally Posted by tiger_td

translate sitesinin yapacağı ancak bu kadar olur. resimler herşeyi anlatıyor server'ı kurdum ancak database te yada istemcide problem var çalışan istemciyi değiştirdim bu hale geldi. düzgünce bu işi anlatan bi kaynak yokmu nasıl kurucaz bu serverı?????????????????

english pls

[jw988]

Turkish to English translation(google)
"but this site will be up to translate. I installed everything but it tells the server or client files in the database have a problem trying to replace the client came to this. Do not have this job explaining how to properly source bi kurucaz this server will ?????????????????"

looks like you might be using the wrong client? what one are you using

[Pyrok]

tiger_td, you're using an epic 7 client, use the 6.2 client from aor for now.

[XavierDeFawks]

I have found what is causing the -%.It is because the LevelResource is off. The client and the server aren't agreeing with what the exp requirment is. If you only want to use level 300 give me a minute and ill post the correct exp for it to fix the error for the rest if i have time this weekend ill play with it.

EDIT: For level 300 go to the dbo.charater table and in the exp colum put 313330517047554000
this will correct the % error and set ur % to 100.00% this is for level 300 only.

[tiger_td]

Originally Posted by Pyrok

tiger_td, you're using an epic 7 client, use the 6.2 client from aor for now.

Thank you for your interest. Database or Client-side errors encountered. I tried all the databases, and clients could not get exactly the result. Client (Rappelz_US_100915_3.exe), Database (MSSQL2008 DBS / sourceforge), SFrame (unpacked 8.42 MB)

I used them.RDU to update files?

Age of Rappelz databese link you give, if possible and appropriate. Could not figure out which of the error. same english sory.

[jw988]

The exp info and job info from my spread sheet in a few posts back have the full data from that table from rappelz wiki

[jw988]

ATM all I have done for inserting, added bags to my Ingame Inv then replacing the item Id of the bags in item table with item I wanted, later on when I'm home from work will make a script to insert a new item. or work out gm insert item command,

the problem with the joblevelbonus table is each class has different stats for each jlv up might need a lot of data.

also with my exp table its -71% off at lvl 170 and thats using the rappelz wiki info so gonna see what lvl it starts going off

[Pyrok]

Originally Posted by jw988

ATM all I have done for inserting, added bags to my Ingame Inv then replacing the item Id of the bags in item table with item I wanted, later on when I'm home from work will make a script to insert a new item. or work out gm insert item command,

the problem with the joblevelbonus table is each class has different stats for each jlv up might need a lot of data.

also with my exp table its -71% off at lvl 170 and thats using the rappelz wiki info so gonna see what lvl it starts going off

Actually, each job has exactly 1 row in the joblevelbonus database. I have the 3 initial jobs done, and I'm working on Fighter now. Here's the sql for the table format and the data I have so far. Fighter's data isn't complete or accurate at this point. I just copied the Rogue row over to start with and will tweak it tomorrow along with the rest of the jobs.

The jlvl 1 bonus (10 I think) is hardcoded in the server and doesn't need to be in the db.

Oh yeah, Champion's 3rd job would have been Berzerker.

 Spoiler

USE [Arcadia]
GO
/****** Object:  Table [dbo].[JobLevelBonus]    Script Date: 05/04/2011 00:08:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[JobLevelBonus](
	[job_id] [int] NOT NULL,
	[strength_0] [decimal](10, 3) NOT NULL,
	[vital_0] [decimal](10, 3) NOT NULL,
	[dexterity_0] [decimal](10, 3) NOT NULL,
	[agility_0] [decimal](10, 3) NOT NULL,
	[intelligence_0] [decimal](10, 3) NOT NULL,
	[mentality_0] [decimal](10, 3) NOT NULL,
	[luck_0] [decimal](10, 3) NOT NULL,
	[strength_1] [decimal](10, 3) NOT NULL,
	[vital_1] [decimal](10, 3) NOT NULL,
	[dexterity_1] [decimal](10, 3) NOT NULL,
	[agility_1] [decimal](10, 3) NOT NULL,
	[intelligence_1] [decimal](10, 3) NOT NULL,
	[mentality_1] [decimal](10, 3) NOT NULL,
	[luck_1] [decimal](10, 3) NOT NULL,
	[strength_2] [decimal](10, 3) NOT NULL,
	[vital_2] [decimal](10, 3) NOT NULL,
	[dexterity_2] [decimal](10, 3) NOT NULL,
	[agility_2] [decimal](10, 3) NOT NULL,
	[intelligence_2] [decimal](10, 3) NOT NULL,
	[mentality_2] [decimal](10, 3) NOT NULL,
	[luck_2] [decimal](10, 3) NOT NULL,
	[strength_3] [decimal](10, 3) NOT NULL,
	[vital_3] [decimal](10, 3) NOT NULL,
	[dexterity_3] [decimal](10, 3) NOT NULL,
	[agility_3] [decimal](10, 3) NOT NULL,
	[intelligence_3] [decimal](10, 3) NOT NULL,
	[mentality_3] [decimal](10, 3) NOT NULL,
	[luck_3] [decimal](10, 3) NOT NULL
) ON [PRIMARY]
GO
INSERT [dbo].[JobLevelBonus] ([job_id], [strength_0], [vital_0], [dexterity_0], [agility_0], [intelligence_0], [mentality_0], [luck_0], [strength_1], [vital_1], [dexterity_1], [agility_1], [intelligence_1], [mentality_1], [luck_1], [strength_2], [vital_2], [dexterity_2], [agility_2], [intelligence_2], [mentality_2], [luck_2], [strength_3], [vital_3], [dexterity_3], [agility_3], [intelligence_3], [mentality_3], [luck_3]) VALUES (100, CAST(0.500 AS Decimal(10, 3)), CAST(0.400 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.400 AS Decimal(10, 3)), CAST(0.400 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.200 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)))
INSERT [dbo].[JobLevelBonus] ([job_id], [strength_0], [vital_0], [dexterity_0], [agility_0], [intelligence_0], [mentality_0], [luck_0], [strength_1], [vital_1], [dexterity_1], [agility_1], [intelligence_1], [mentality_1], [luck_1], [strength_2], [vital_2], [dexterity_2], [agility_2], [intelligence_2], [mentality_2], [luck_2], [strength_3], [vital_3], [dexterity_3], [agility_3], [intelligence_3], [mentality_3], [luck_3]) VALUES (200, CAST(0.400 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.400 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.200 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)))
INSERT [dbo].[JobLevelBonus] ([job_id], [strength_0], [vital_0], [dexterity_0], [agility_0], [intelligence_0], [mentality_0], [luck_0], [strength_1], [vital_1], [dexterity_1], [agility_1], [intelligence_1], [mentality_1], [luck_1], [strength_2], [vital_2], [dexterity_2], [agility_2], [intelligence_2], [mentality_2], [luck_2], [strength_3], [vital_3], [dexterity_3], [agility_3], [intelligence_3], [mentality_3], [luck_3]) VALUES (300, CAST(0.400 AS Decimal(10, 3)), CAST(0.400 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.400 AS Decimal(10, 3)), CAST(0.200 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)))
INSERT [dbo].[JobLevelBonus] ([job_id], [strength_0], [vital_0], [dexterity_0], [agility_0], [intelligence_0], [mentality_0], [luck_0], [strength_1], [vital_1], [dexterity_1], [agility_1], [intelligence_1], [mentality_1], [luck_1], [strength_2], [vital_2], [dexterity_2], [agility_2], [intelligence_2], [mentality_2], [luck_2], [strength_3], [vital_3], [dexterity_3], [agility_3], [intelligence_3], [mentality_3], [luck_3]) VALUES (101, CAST(0.500 AS Decimal(10, 3)), CAST(0.400 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.400 AS Decimal(10, 3)), CAST(0.400 AS Decimal(10, 3)), CAST(0.500 AS Decimal(10, 3)), CAST(0.200 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)), CAST(0.000 AS Decimal(10, 3)))

[jw988]

Im using this to view the items:

 Spoiler

/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 10000 [id]
,[name_id]
,[target_min_level]
,[available_period]
,[icon_file_name]

FROM [Arcadia].[dbo].[ItemResource]

This to add the item: (only temp while working on other things)

 Spoiler

USE [Telecaster]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[smp_insert_item]
@IN_SID = 5009, --Change this Per Item
@IN_OWNER_ID = 15, --Char ID
@IN_ACCOUNT_ID = 0,
@IN_SUMMON_ID = 0,
@IN_AUCTION_ID = 0,
@IN_KEEPING_ID = 0,
@IN_CODE = 2010258, --Item Code
@IN_IDX = 100, --Place in Inv (doesnt seem to matter)
@IN_FLAG = 0,
@IN_CNT = 1, --How Many you want
@IN_LEVEL = 1, --Item Level
@IN_ENHANCE = 0, -- Item +
@IN_ENDURANCE = 100,
@IN_GCODE = 1,
@IN_REMAIN_TIME = 0,
@IN_ELEMENTAL_EFFECT_TYPE = 0,
@IN_ELEMENTAL_EFFECT_EXPIRE_TIME = N'1970-01-01 11:00:00.000',
@IN_ELEMENTAL_EFFECT_ATTACK_POINT = 0,
@IN_ELEMENTAL_EFFECT_MAGIC_POINT = 0

SELECT 'Return Value' = @return_value

GO

also one of the first pets in rappelz the Astaroth but was taken out is still in the database:

[jw988]

i think That item number is the made from your item table in telecaster, clear that table and it shows as 1

i noticed all the mobs are in cm even the 150+ ones and the bosses and most of marduka from 115 +

[khshe]

how to add your character stubs etc?

[zassadgh2]

What file is it I should change excatly so it wont connect to cadb.nflavor.com?

[Gangxtar1]

could one of u, who got working server, pls create a guide.
how to install the server.
i tried things but without possitive results.