Thanks cannon for the correction. I just updated the table. Use the script below.
LevelResource table:
@cannon0011: Look at [Only registered and activated users can see links. Click Here To Register...] 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. :)
LevelResource table:
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
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 [Only registered and activated users can see links. Click Here To Register...] 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. :)
