Rappelz server files

Page 27 of 154

05/03/2011 21:11 khshe#391

Quote:

Originally Posted by tauppe

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

thank you
[Only registered and activated users can see links. Click Here To Register...]

I have a strange sort of a

05/03/2011 23:50 tiger_td#392

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

05/04/2011 00:34 manlive#393

Quote:

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

05/04/2011 00:38 jw988#394

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

05/04/2011 03:03 Pyrok#395

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

05/04/2011 03:50 XavierDeFawks#396

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.

05/04/2011 04:43 tiger_td#397

Quote:

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.

05/04/2011 05:51 jw988#398

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

05/04/2011 06:13 jw988#399

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

05/04/2011 07:31 Pyrok#400

Quote:

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

Code:

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)))

05/04/2011 09:46 jw988#401

Im using this to view the items:

Spoiler

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

Spoiler

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

05/04/2011 12:04 jw988#402

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 +

05/04/2011 17:18 khshe#403

how to add your character stubs etc?

05/04/2011 18:58 zassadgh2#404

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

05/04/2011 21:46 Gangxtar1#405

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

Page 27 of 154

« First

127

Last »