Rappelz server files

[Link404]

Thanks cannon for the correction. I just updated the table. Use the script below.

LevelResource table:

 Spoiler

USE [Arcadia]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_LevelResource_huh1]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LevelResource] DROP CONSTRAINT [DF_LevelResource_huh1]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_LevelResource_huh2]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LevelResource] DROP CONSTRAINT [DF_LevelResource_huh2]
END

GO

USE [Arcadia]
GO

/****** Object: Table [dbo].[LevelResource] Script Date: 05/03/2011 18:40:38 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LevelResource]') AND type in (N'U'))
DROP TABLE [dbo].[LevelResource]
GO

USE [Arcadia]
GO

/****** Object: Table [dbo].[LevelResource] Script Date: 05/03/2011 18:40:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LevelResource](
[level] [int] NOT NULL,
[normal_exp] [bigint] NOT NULL,
[jl1] [bigint] NOT NULL,
[jl2] [bigint] NOT NULL,
[jl3] [int] NOT NULL,
[jl4] [int] NOT NULL,
CONSTRAINT [IX_LevelResource] UNIQUE NONCLUSTERED
(
[level] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[LevelResource] ADD CONSTRAINT [DF_LevelResource_huh1] DEFAULT ((0)) FOR [jl1]
GO

ALTER TABLE [dbo].[LevelResource] ADD CONSTRAINT [DF_LevelResource_huh2] DEFAULT ((0)) FOR [jl2]
GO

INSERT INTO [dbo].[LevelResource]
([level]
,[normal_exp]
,[jl1]
,[jl2]
,[jl3]
,[jl4])

VALUES
(1,0,0,0,0,0),
(2,6,6,0,0,0),
(3,15,21,0,0,0),
(4,32,53,0,0,0),
(5,72,125,0,0,0),
(6,160,285,0,0,0),
(7,320,605,0,0,0),
(8,540,1145,0,0,0),
(9,885,2030,0,0,0),
(10,1332,3362,0,0,0),
(11,1738,5100,0,0,0),
(12,2756,7856,0,0,0),
(13,3930,11786,0,0,0),
(14,5495,17281,0,0,0),
(15,7280,24561,0,0,0),
(16,9315,33876,0,0,0),
(17,11600,45476,0,0,0),
(18,14392,59868,0,0,0),
(19,17703,77571,0,0,0),
(20,21045,98616,0,0,0),
(21,31084,129700,0,0,0),
(22,36792,166492,0,0,0),
(23,42497,208989,0,0,0),
(24,49005,257994,0,0,0),
(25,56068,314062,0,0,0),
(26,64023,378085,0,0,0),
(27,72652,450737,0,0,0),
(28,81606,532343,0,0,0),
(29,91728,624071,0,0,0),
(30,102564,726635,0,0,0),
(31,138580,865215,0,0,0),
(32,153825,1019040,0,0,0),
(33,169818,1188858,0,0,0),
(34,186559,1375417,0,0,0),
(35,205238,1580655,0,0,0),
(36,224536,1805191,0,0,0),
(37,245700,2050891,0,0,0),
(38,266664,2317555,0,0,0),
(39,289562,2607117,0,0,0),
(40,314496,2921613,0,0,0),
(41,411840,3333453,0,0,0),
(42,444600,3778053,0,0,0),
(43,479745,4257798,0,0,0),
(44,514885,4772683,0,0,0),
(45,593640,5366323,0,0,0),
(46,593640,5959963,0,0,0),
(47,624125,6584088,0,0,0),
(48,667603,7251691,0,0,0),
(49,724200,7975891,0,0,0),
(50,770480,8746371,0,0,0),
(51,996660,9743031,0,0,0),
(52,1061208,10804239,0,0,0),
(53,1125246,11929485,0,0,0),
(54,1193998,13123483,0,0,0),
(55,1266597,14390080,0,0,0),
(56,1339182,15729262,0,0,0),
(57,1416250,17145512,0,0,0),
(58,1497390,18642902,0,0,0),
(59,1578520,20221422,0,0,0),
(60,1664397,21885819,0,0,0),
(61,2134826,24020645,0,0,0),
(62,2249000,26269645,0,0,0),
(63,2366617,28636262,0,0,0),
(64,2486356,31122618,0,0,0),
(65,2613240,33735858,0,0,0),
(66,2742336,36478194,0,0,0),
(67,2875094,39353288,0,0,0),
(68,3010800,42364088,0,0,0),
(69,3153381,45517469,0,0,0),
(70,3303038,48820507,0,0,0),
(71,4219400,53039907,0,0,0),
(72,4412826,57452733,0,0,0),
(73,4610332,62063065,0,0,0),
(74,4817127,66880192,0,0,0),
(75,5022888,71903080,0,0,0),
(76,5244470,77147550,0,0,0),
(77,5460480,82608030,0,0,0),
(78,5695488,88303518,0,0,0),
(79,5930400,94233918,0,0,0),
(80,6160784,100394702,0,0,0),
(81,7872111,108266813,0,0,0),
(82,8189110,116455923,0,0,0),
(83,8519406,124975329,0,0,0),
(84,8848395,133823724,0,0,0),
(85,9190901,143014625,0,0,0),
(86,9548496,152563121,0,0,0),
(87,9903460,162466581,0,0,0),
(88,10273791,172740372,0,0,0),
(89,10659909,183400281,0,0,0),
(90,11043256,194443537,0,0,0),
(91,14079872,208523409,0,0,0),
(92,14585548,223108957,0,0,0),
(93,15111621,238220578,0,0,0),
(94,15646560,253867138,0,0,0),
(95,16191876,270059014,0,0,0),
(96,16756980,286815994,0,0,0),
(97,17320296,304136290,0,0,0),
(98,17916443,322052733,0,0,0),
(99,18509227,340561960,0,0,0),
(100,19126008,359687968,0,0,0),
(101,24386615,384074583,0,0,0),
(102,26004100,410078683,0,0,0),
(103,26842578,436921261,0,0,0),
(104,26842578,463763839,0,0,0),
(105,27707050,491470889,0,0,0),
(106,28573125,520044014,0,0,0),
(107,29465570,549509584,0,0,0),
(108,30388736,579898320,0,0,0),
(109,31311686,611210006,0,0,0),
(110,32263932,643473938,0,0,0),
(111,41166756,684640694,0,0,0),
(112,42418640,727059334,0,0,0),
(113,43692834,770752168,0,0,0),
(114,44985232,815737400,0,0,0),
(115,46316868,862054268,0,0,0),
(116,47671680,909725948,0,0,0),
(117,49045340,958771288,0,0,0),
(118,50440164,1009211452,0,0,0),
(119,51875940,1061087392,0,0,0),
(120,53333532,1114420924,0,0,0),
(121,67776081,1182197005,0,0,0),
(122,69333028,1251530033,0,0,0),
(123,70896756,1322426789,0,0,0),
(124,72466905,1394893694,0,0,0),
(125,74076858,1468970552,0,0,0),
(126,75693010,1544663562,0,0,0),
(127,77317668,1621981230,0,0,0),
(128,78979644,1700960874,0,0,0),
(129,80647200,1781608074,0,0,0),
(130,82319958,1863928032,0,0,0),
(131,104727456,1968655488,0,0,0),
(132,106905610,2075561098,0,0,0),
(133,109089760,2184650858,0,0,0),
(134,111322768,2295973626,0,0,0),
(135,113564322,2409537948,0,0,0),
(136,115810964,2525348912,0,0,0),
(137,118068378,2643417290,0,0,0),
(138,120368200,2763785490,0,0,0),
(139,122675264,2886460754,0,0,0),
(140,124989165,3011449919,0,0,0),
(141,130562927,3142012846,0,0,0),
(142,137641588,3279654434,0,0,0),
(143,146560746,3426215180,0,0,0),
(144,157467800,3583682980,0,0,0),
(145,172398688,3756081668,0,0,0),
(146,192204261,3948285929,0,0,0),
(147,224046837,4172332766,0,0,0),
(148,272398022,4444730788,0,0,0),
(149,358817408,4803548196,0,0,0),
(150,509063847,5312612043,0,0,0),
(151,712689385,6025301428,0,0,0),
(152,1004892032,7030193460,0,0,0),
(153,1426946685,8457140145,0,0,0),
(154,2040533759,10497673904,0,0,0),
(155,2938368612,13436042516,0,0,0),
(156,4260634487,17696677003,0,0,0),
(157,6220526351,23917203354,0,0,0),
(158,9144173735,33061377089,0,0,0),
(159,13533377127,46594754216,0,0,0),
(160,20164731919,66759486135,0,0,0),
(161,24197678302,90957164437,0,0,0),
(162,29279190745,120236355182,0,0,0),
(163,35720612708,155956967890,0,0,0),
(164,43936353630,199893321520,0,0,0),
(165,54481078501,254374400021,0,0,0),
(166,68101348126,322475748147,0,0,0),
(167,85807698638,408283446785,0,0,0),
(168,108975777270,517259224055,0,0,0),
(169,139488994905,656748218960,0,0,0),
(170,179940803427,836689022387,0,0,0)
GO

@cannon0011: Look at guide on how to edit all rows.

@Gangxtar1: I would be happy if you can be patient till this weekend. For now, I've absolutely no time to even do my homework or whatever. I'll try to post a guide this Friday so we can work together on fixing bugs.

I just noticed that most of the portals are missing. For example, try to enter the dungeon for relic moonlight (or whatever its name was), haha.

[j0k3r91]

erf Link404 you new LevelResource table no work =(
erreur MSSQL

Msg 8115, Level 16, State 2, Line 2
An arithmetic overflow error occurred while converting expression to data type int.
The statement has been terminated.

[Link404]

Yep, my bad, didn't notice this before. This error message appears because the last numbers, for example "179940803427", those are out of the range of an integer. Let me update it to get it working.

EDIT: Here you are. Use this sql script.

LevelResource table:

 Spoiler

USE [Arcadia]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_LevelResource_huh1]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LevelResource] DROP CONSTRAINT [DF_LevelResource_huh1]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_LevelResource_huh2]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[LevelResource] DROP CONSTRAINT [DF_LevelResource_huh2]
END

GO

USE [Arcadia]
GO

/****** Object: Table [dbo].[LevelResource] Script Date: 05/03/2011 18:40:38 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LevelResource]') AND type in (N'U'))
DROP TABLE [dbo].[LevelResource]
GO

USE [Arcadia]
GO

/****** Object: Table [dbo].[LevelResource] Script Date: 05/03/2011 18:40:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LevelResource](
[level] [int] NOT NULL,
[normal_exp] [bigint] NOT NULL,
[jl1] [bigint] NOT NULL,
[jl2] [bigint] NOT NULL,
[jl3] [int] NOT NULL,
[jl4] [int] NOT NULL,
CONSTRAINT [IX_LevelResource] UNIQUE NONCLUSTERED
(
[level] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[LevelResource] ADD CONSTRAINT [DF_LevelResource_huh1] DEFAULT ((0)) FOR [jl1]
GO

ALTER TABLE [dbo].[LevelResource] ADD CONSTRAINT [DF_LevelResource_huh2] DEFAULT ((0)) FOR [jl2]
GO

INSERT INTO [dbo].[LevelResource]
([level]
,[normal_exp]
,[jl1]
,[jl2]
,[jl3]
,[jl4])

VALUES
(1,0,0,0,0,0),
(2,6,6,0,0,0),
(3,15,21,0,0,0),
(4,32,53,0,0,0),
(5,72,125,0,0,0),
(6,160,285,0,0,0),
(7,320,605,0,0,0),
(8,540,1145,0,0,0),
(9,885,2030,0,0,0),
(10,1332,3362,0,0,0),
(11,1738,5100,0,0,0),
(12,2756,7856,0,0,0),
(13,3930,11786,0,0,0),
(14,5495,17281,0,0,0),
(15,7280,24561,0,0,0),
(16,9315,33876,0,0,0),
(17,11600,45476,0,0,0),
(18,14392,59868,0,0,0),
(19,17703,77571,0,0,0),
(20,21045,98616,0,0,0),
(21,31084,129700,0,0,0),
(22,36792,166492,0,0,0),
(23,42497,208989,0,0,0),
(24,49005,257994,0,0,0),
(25,56068,314062,0,0,0),
(26,64023,378085,0,0,0),
(27,72652,450737,0,0,0),
(28,81606,532343,0,0,0),
(29,91728,624071,0,0,0),
(30,102564,726635,0,0,0),
(31,138580,865215,0,0,0),
(32,153825,1019040,0,0,0),
(33,169818,1188858,0,0,0),
(34,186559,1375417,0,0,0),
(35,205238,1580655,0,0,0),
(36,224536,1805191,0,0,0),
(37,245700,2050891,0,0,0),
(38,266664,2317555,0,0,0),
(39,289562,2607117,0,0,0),
(40,314496,2921613,0,0,0),
(41,411840,3333453,0,0,0),
(42,444600,3778053,0,0,0),
(43,479745,4257798,0,0,0),
(44,514885,4772683,0,0,0),
(45,593640,5366323,0,0,0),
(46,593640,5959963,0,0,0),
(47,624125,6584088,0,0,0),
(48,667603,7251691,0,0,0),
(49,724200,7975891,0,0,0),
(50,770480,8746371,0,0,0),
(51,996660,9743031,0,0,0),
(52,1061208,10804239,0,0,0),
(53,1125246,11929485,0,0,0),
(54,1193998,13123483,0,0,0),
(55,1266597,14390080,0,0,0),
(56,1339182,15729262,0,0,0),
(57,1416250,17145512,0,0,0),
(58,1497390,18642902,0,0,0),
(59,1578520,20221422,0,0,0),
(60,1664397,21885819,0,0,0),
(61,2134826,24020645,0,0,0),
(62,2249000,26269645,0,0,0),
(63,2366617,28636262,0,0,0),
(64,2486356,31122618,0,0,0),
(65,2613240,33735858,0,0,0),
(66,2742336,36478194,0,0,0),
(67,2875094,39353288,0,0,0),
(68,3010800,42364088,0,0,0),
(69,3153381,45517469,0,0,0),
(70,3303038,48820507,0,0,0),
(71,4219400,53039907,0,0,0),
(72,4412826,57452733,0,0,0),
(73,4610332,62063065,0,0,0),
(74,4817127,66880192,0,0,0),
(75,5022888,71903080,0,0,0),
(76,5244470,77147550,0,0,0),
(77,5460480,82608030,0,0,0),
(78,5695488,88303518,0,0,0),
(79,5930400,94233918,0,0,0),
(80,6160784,100394702,0,0,0),
(81,7872111,108266813,0,0,0),
(82,8189110,116455923,0,0,0),
(83,8519406,124975329,0,0,0),
(84,8848395,133823724,0,0,0),
(85,9190901,143014625,0,0,0),
(86,9548496,152563121,0,0,0),
(87,9903460,162466581,0,0,0),
(88,10273791,172740372,0,0,0),
(89,10659909,183400281,0,0,0),
(90,11043256,194443537,0,0,0),
(91,14079872,208523409,0,0,0),
(92,14585548,223108957,0,0,0),
(93,15111621,238220578,0,0,0),
(94,15646560,253867138,0,0,0),
(95,16191876,270059014,0,0,0),
(96,16756980,286815994,0,0,0),
(97,17320296,304136290,0,0,0),
(98,17916443,322052733,0,0,0),
(99,18509227,340561960,0,0,0),
(100,19126008,359687968,0,0,0),
(101,24386615,384074583,0,0,0),
(102,26004100,410078683,0,0,0),
(103,26842578,436921261,0,0,0),
(104,26842578,463763839,0,0,0),
(105,27707050,491470889,0,0,0),
(106,28573125,520044014,0,0,0),
(107,29465570,549509584,0,0,0),
(108,30388736,579898320,0,0,0),
(109,31311686,611210006,0,0,0),
(110,32263932,643473938,0,0,0),
(111,41166756,684640694,0,0,0),
(112,42418640,727059334,0,0,0),
(113,43692834,770752168,0,0,0),
(114,44985232,815737400,0,0,0),
(115,46316868,862054268,0,0,0),
(116,47671680,909725948,0,0,0),
(117,49045340,958771288,0,0,0),
(118,50440164,1009211452,0,0,0),
(119,51875940,1061087392,0,0,0),
(120,53333532,1114420924,0,0,0),
(121,67776081,1182197005,0,0,0),
(122,69333028,1251530033,0,0,0),
(123,70896756,1322426789,0,0,0),
(124,72466905,1394893694,0,0,0),
(125,74076858,1468970552,0,0,0),
(126,75693010,1544663562,0,0,0),
(127,77317668,1621981230,0,0,0),
(128,78979644,1700960874,0,0,0),
(129,80647200,1781608074,0,0,0),
(130,82319958,1863928032,0,0,0),
(131,104727456,1968655488,0,0,0),
(132,106905610,2075561098,0,0,0),
(133,109089760,2184650858,0,0,0),
(134,111322768,2295973626,0,0,0),
(135,113564322,2409537948,0,0,0),
(136,115810964,2525348912,0,0,0),
(137,118068378,2643417290,0,0,0),
(138,120368200,2763785490,0,0,0),
(139,122675264,2886460754,0,0,0),
(140,124989165,3011449919,0,0,0),
(141,130562927,3142012846,0,0,0),
(142,137641588,3279654434,0,0,0),
(143,146560746,3426215180,0,0,0),
(144,157467800,3583682980,0,0,0),
(145,172398688,3756081668,0,0,0),
(146,192204261,3948285929,0,0,0),
(147,224046837,4172332766,0,0,0),
(148,272398022,4444730788,0,0,0),
(149,358817408,4803548196,0,0,0),
(150,509063847,5312612043,0,0,0),
(151,712689385,6025301428,0,0,0),
(152,1004892032,7030193460,0,0,0),
(153,1426946685,8457140145,0,0,0),
(154,2040533759,10497673904,0,0,0),
(155,2938368612,13436042516,0,0,0),
(156,4260634487,17696677003,0,0,0),
(157,6220526351,23917203354,0,0,0),
(158,9144173735,33061377089,0,0,0),
(159,13533377127,46594754216,0,0,0),
(160,20164731919,66759486135,0,0,0),
(161,24197678302,90957164437,0,0,0),
(162,29279190745,120236355182,0,0,0),
(163,35720612708,155956967890,0,0,0),
(164,43936353630,199893321520,0,0,0),
(165,54481078501,254374400021,0,0,0),
(166,68101348126,322475748147,0,0,0),
(167,85807698638,408283446785,0,0,0),
(168,108975777270,517259224055,0,0,0),
(169,139488994905,656748218960,0,0,0),
(170,179940803427,836689022387,0,0,0)
GO

[j0k3r91]

yes no problem thx for work

[j0k3r91]

Erf sorry he work but he crash server to create a perso is possible ?

[jw988]

It will crash if you have 0 exp for lvl 1, also link you have to rows of exp that won't work, the third row shoul be in the 2nd row and the 2nd row data not even in table, then third row is for jlv jp 1-10 then forth jlv jp for 1st job 1-50 then row five is jlv jp for 2 nd job 1-50,

your table was correct in this post link, i dont know why you have changed it


but the problem is the exp from the rappelz wiki site is off to what its ment to be.

and this is all the dungeon portal info but they still dont show.

[demonroro]

I know why now exp is buggy:
EX:
Lvl EXP TO GET from 169 to 170 : 179 940 803 427 (and is actually in DB at 836 687 353 840)
Total EXP FROM LV1 to LV 170 : 836 687 353 840

Need to fix it.

[XavierDeFawks]

Originally Posted by demonroro

I know why now exp is buggy:
EX:
Lvl EXP TO GET from 169 to 170 : 179 940 803 427 (and is actually in DB at 836 687 353 840)
Total EXP FROM LV1 to LV 170 : 836 687 353 840

Need to fix it.

Thats what I said. lol. But seem like no one saw the post O.o.

Btw jw988, how do u add pet cards to ur inventory. I've looked at the dbo.item but it seems to only have to id for the icon of the card and not the actual pet card o.o.

[jw988]

We don't listen lol, if you put the exp you need go each level it bugs on first lvl up, the correct data is the Lvl exp added up from each level exp, that is in there, but the info is off a tiny bit in the higher Lvls hence the -%, anyway you still lvl and there is more important problems to work on.

[Pyrok]

I didn't have much time to work on anything tonight, kid's been sick (she's 18 months old). But I did manage to get pets started. They can be put in formation and summoned but I'm guessing their stats will be messed up too. Another project for another day. Anyways, here's the table changes. You must have at least 1 prefix and 1 postfix or you'll crash the server (Nice divide by 0 check gala...) Ignore the jp in the pic, it's my stat testing character. Also, sid should probably be a unique primary key but I'm tired and wanted to get this out tonight.

Oh yeah, the text_id must match something either in StringResource or StringLocalResource. I just set mine to 27 and 28 to see if it works or not.

 Spoiler

USE [Arcadia]
GO

/****** Object:  Table [dbo].[SummonDefaultNameResource]    Script Date: 05/04/2011 23:05:50 ******/
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: 05/04/2011 23:05:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SummonDefaultNameResource](
	[sid] [int] NOT NULL,
	[is_post_fix] [int] NOT NULL,
	[text_id] [int] NULL
) ON [PRIMARY]

GO

Oh yeah, cannon, add:
order by [field] asc
or
order by [field desc
to the end of your query.

[XavierDeFawks]

I get the divide by zero error when i start the server now

[XavierDeFawks]

btw ive found out how to add gold in the gameserver type #insert_gold(amount goes here , "char name goes here")


EDIT: weird i restored all my dps, executed the updates and it works fine now.

[darkside4125]

pryok, open a server or release what you got so others can help

[XavierDeFawks]

yea can u make a backup plz cuz now i cant open formation

[jw988]

Originally Posted by darkside4125

pryok, open a server or release what you got so others can help

lol read first before you post, this thread has everything to get the server to where we is at and he did release his database few pages ago. also the way hes releasing his updates is fine, so we dont have to overwrite our chars every time there is a change.