| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155 |
- DROP TABLE IF EXISTS `enchant_skill_groups`;
- CREATE TABLE `enchant_skill_groups` (
- `group_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `level` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `adena` mediumint(6) unsigned NOT NULL DEFAULT '0',
- `exp` mediumint(7) unsigned DEFAULT NULL,
- `sp` mediumint(7) unsigned DEFAULT NULL,
- `success_rate76` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `success_rate77` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `success_rate78` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `success_rate79` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `success_rate80` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `success_rate81` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `success_rate82` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `success_rate83` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `success_rate84` tinyint(2) unsigned NOT NULL DEFAULT '0',
- `success_rate85` tinyint(2) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`group_id`,`level`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- INSERT INTO `enchant_skill_groups` VALUES
- -- 2nd Class Buffs Debuffs Toogle and Summons
- -- group_id level adena exp sp success_rate76 77 78 79 80 81 82 83 84 85
- (1, 1, 74250, 0, 575980, 82,92,97,97,97,97,97,97,97,97),
- (1, 2, 74250, 0, 575980, 80,90,95,95,95,95,95,95,95,95),
- (1, 3, 74250, 0, 575980, 78,88,93,93,93,93,93,93,93,93),
- (1, 4, 112050,0, 604535, 52,76,86,91,91,91,91,91,91,91),
- (1, 5, 112050,0, 604535, 50,74,84,89,89,89,89,89,89,89),
- (1, 6, 112050,0, 604535, 48,72,82,87,87,87,87,87,87,87),
- (1, 7, 150300,0, 634020, 22,46,70,80,85,85,85,85,85,85),
- (1, 8, 150300,0, 634020, 20,44,68,78,83,83,83,83,83,83),
- (1, 9, 150300,0, 634020, 18,42,66,76,81,81,81,81,81,81),
- (1, 10, 189000,0, 680020, 6, 16,40,64,74,79,79,79,79,79),
- (1, 11, 189000,0, 680020, 4, 14,38,62,72,77,77,77,77,77),
- (1, 12, 189000,0, 680020, 2, 12,36,60,70,75,75,75,75,75),
- (1, 13, 228150,0, 711890, 1, 4, 10,34,58,68,73,73,73,73),
- (1, 14, 228150,0, 711890, 1, 3, 8, 32,56,66,71,71,71,71),
- (1, 15, 228150,0, 711890, 1, 2, 6, 30,54,64,69,69,69,69),
- (1, 16, 267750,0, 761540, 1, 1, 2, 4, 28,52,62,67,67,67),
- (1, 17, 267750,0, 761540, 1, 1, 2, 2, 26,50,60,65,65,65),
- (1, 18, 267750,0, 761540, 1, 1, 2, 1, 24,48,58,63,63,63),
- (1, 19, 307800,0, 795890, 1, 1, 1, 1, 4, 22,46,56,61,61),
- (1, 20, 307800,0, 795890, 1, 1, 1, 1, 3, 20,44,54,59,59),
- (1, 21, 307800,0, 795890, 1, 1, 1, 1, 2, 18,42,52,57,57),
- (1, 22, 348300,0, 849330, 1, 1, 1, 1, 2, 6, 16,40,50,55),
- (1, 23, 348300,0, 849330, 1, 1, 1, 1, 1, 4, 14,38,48,53),
- (1, 24, 348300,0, 849330, 0, 1, 1, 1, 1, 2, 12,36,46,51),
- (1, 25, 389250,0, 886255, 0, 1, 1, 1, 1, 1, 4, 10,34,44),
- (1, 26, 389250,0, 886255, 0, 1, 1, 1, 1, 1, 2, 8, 32,42),
- (1, 27, 389250,0, 886255, 0, 0, 1, 1, 1, 1, 1, 6, 30,40),
- (1, 28, 430650,0, 943620, 0, 0, 1, 1, 1, 1, 1, 1, 4, 28),
- (1, 29, 430650,0, 943620, 0, 0, 1, 1, 1, 1, 1, 1, 2, 26),
- (1, 30, 430650,0, 943620, 0, 0, 0, 0, 1, 1, 1, 1, 1, 24),
- -- 2nd Class Cubic and Attack Type Skills
- -- group_id level adena exp sp success_rate76 77 78 79 80 81 82 83 84 85
- (2, 1, 133650,0, 1036764, 82,92,97,97,97,97,97,97,97,97),
- (2, 2, 133650,0, 1036764, 80,90,95,95,95,95,95,95,95,95),
- (2, 3, 133650,0, 1036764, 78,88,93,93,93,93,93,93,93,93),
- (2, 4, 201690,0, 1088163, 52,76,86,91,91,91,91,91,91,91),
- (2, 5, 201690,0, 1088163, 50,74,84,89,89,89,89,89,89,89),
- (2, 6, 201690,0, 1088163, 48,72,82,87,87,87,87,87,87,87),
- (2, 7, 270540,0, 1141236, 22,46,70,80,85,85,85,85,85,85),
- (2, 8, 270540,0, 1141236, 20,44,68,78,83,83,83,83,83,83),
- (2, 9, 270540,0, 1141236, 18,42,66,76,81,81,81,81,81,81),
- (2, 10, 340200,0, 1224036, 6, 16,40,64,74,79,79,79,79,79),
- (2, 11, 340200,0, 1224036, 4, 14,38,62,72,77,77,77,77,77),
- (2, 12, 340200,0, 1224036, 2, 12,36,60,70,75,75,75,75,75),
- (2, 13, 410670,0, 1281402, 1, 4, 10,34,58,68,73,73,73,73),
- (2, 14, 410670,0, 1281402, 1, 3, 8, 32,56,66,71,71,71,71),
- (2, 15, 410670,0, 1281402, 1, 2, 6, 30,54,64,69,69,69,69),
- (2, 16, 481950,0, 1370772, 1, 1, 2, 4, 28,52,62,67,67,67),
- (2, 17, 481950,0, 1370772, 1, 1, 2, 2, 26,50,60,65,65,65),
- (2, 18, 481950,0, 1370772, 1, 1, 2, 1, 24,48,58,63,63,63),
- (2, 19, 554040,0, 1432602, 1, 1, 1, 1, 4, 22,46,56,61,61),
- (2, 20, 554040,0, 1432602, 1, 1, 1, 1, 3, 20,44,54,59,59),
- (2, 21, 554040,0, 1432602, 1, 1, 1, 1, 2, 18,42,52,57,57),
- (2, 22, 626940,0, 1528794, 1, 1, 1, 1, 2, 6, 16,40,50,55),
- (2, 23, 626940,0, 1528794, 1, 1, 1, 1, 1, 4, 14,38,48,53),
- (2, 24, 626940,0, 1528794, 0, 1, 1, 1, 1, 2, 12,36,46,51),
- (2, 25, 700650,0, 1595259, 0, 1, 1, 1, 1, 1, 4, 10,34,44),
- (2, 26, 700650,0, 1595259, 0, 1, 1, 1, 1, 1, 2, 8, 32,42),
- (2, 27, 700650,0, 1595259, 0, 0, 1, 1, 1, 1, 1, 6, 30,40),
- (2, 28, 775170,0, 1698516, 0, 0, 1, 1, 1, 1, 1, 1, 4, 28),
- (2, 29, 775170,0, 1698516, 0, 0, 1, 1, 1, 1, 1, 1, 2, 26),
- (2, 30, 775170,0, 1698516, 0, 0, 0, 0, 1, 1, 1, 1, 1, 24),
- -- 3rd Class Buffs, Debuffs, Toggles
- -- group_id level adena exp sp success_rate76 77 78 79 80 81 82 83 84 85
- (5, 1, 481950,0, 1370772, 18,28,38,48,58,82,92,97,97,97),
- (5, 2, 481950,0, 1370772, 2, 1, 1, 46,56,80,90,95,95,95),
- (5, 3, 481950,0, 1370772, 2, 1, 1, 1, 54,78,88,93,93,93),
- (5, 4, 554040,0, 1432602, 2, 1, 1, 1, 42,52,76,86,91,91),
- (5, 5, 554040,0, 1432602, 1, 1, 1, 1, 1, 50,74,84,89,89),
- (5, 6, 554040,0, 1432602, 1, 1, 1, 1, 1, 48,72,82,87,87),
- (5, 7, 626940,0, 1528794, 0, 1, 1, 1, 1, 1, 46,70,80,85),
- (5, 8, 626940,0, 1528794, 0, 1, 1, 1, 1, 1, 44,68,78,83),
- (5, 9, 626940,0, 1528794, 0, 1, 1, 1, 1, 1, 42,66,76,81),
- (5, 10, 700650,0, 1595259, 0, 0, 1, 1, 1, 1, 1, 40,64,74),
- (5, 11, 700650,0, 1595259, 0, 0, 1, 1, 1, 1, 1, 38,62,72),
- (5, 12, 700650,0, 1595259, 0, 0, 1, 1, 1, 1, 1, 36,60,70),
- (5, 13, 775170,0, 1698516, 0, 0, 0, 1, 1, 1, 1, 1, 34,58),
- (5, 14, 775170,0, 1698516, 0, 0, 0, 1, 1, 1, 1, 1, 32,56),
- (5, 15, 775170,0, 1698516, 0, 0, 0, 1, 1, 1, 1, 1, 30,54),
- -- 3rd Class Attack Type skills
- -- group_id level adena exp sp success_rate76 77 78 79 80 81 82 83 84 85
- (6, 1, 481950,0, 1370772, 18,28,38,48,58,82,92,97,97,97),
- (6, 2, 481950,0, 1370772, 2, 1, 1, 46,56,80,90,95,95,95),
- (6, 3, 481950,0, 1370772, 2, 1, 1, 1, 54,78,88,93,93,93),
- (6, 4, 554040,0, 1432602, 2, 1, 1, 1, 42,52,76,86,91,91),
- (6, 5, 554040,0, 1432602, 1, 1, 1, 1, 1, 50,74,84,89,89),
- (6, 6, 554040,0, 1432602, 1, 1, 1, 1, 1, 48,72,82,87,87),
- (6, 7, 626940,0, 1528794, 0, 1, 1, 1, 1, 1, 46,70,80,85),
- (6, 8, 626940,0, 1528794, 0, 1, 1, 1, 1, 1 ,44,68,78,83),
- (6, 9, 626940,0, 1528794, 0, 1, 1, 1, 1, 1, 42,66,76,81),
- (6, 10, 700650,0, 1595259, 0, 0, 1, 1, 1, 1, 1, 40,64,74),
- (6, 11, 700650,0, 1595259, 0, 0, 1, 1, 1, 1, 1, 38,62,72),
- (6, 12, 700650,0, 1595259, 0, 0, 1, 1, 1, 1, 1, 36,60,70),
- (6, 13, 775170,0, 1698516, 0, 0, 0, 1, 1, 1, 1, 1, 34,58),
- (6, 14, 775170,0, 1698516, 0, 0, 0, 1, 1, 1, 1, 1, 32,56),
- (6, 15, 775170,0, 1698516, 0, 0, 0, 1, 1, 1, 1, 1, 30,54),
- -- old L2J Group
- -- group_id level adena exp sp success_rate76 77 78 79 80 81 82 83 84 85
- (30, 1, 102000,0, 306000, 82,92,97,97,97,97,97,97,97,97),
- (30, 2, 105000,0, 315000, 80,90,95,95,95,95,95,95,95,95),
- (30, 3, 108333,0, 325000, 78,88,93,93,93,93,93,93,93,93),
- (30, 4, 115333,0, 346000, 38,82,91,91,91,91,91,91,91,91),
- (30, 5, 119000,0, 357000, 30,80,89,89,89,89,89,89,89,89),
- (30, 6, 122667,0, 368000, 20,78,78,78,87,87,87,87,87,87),
- (30, 7, 130000,0, 390000, 14,38,70,70,85,85,85,85,85,85),
- (30, 8, 134000,0, 402000, 10,30,68,68,83,83,83,83,83,83),
- (30, 9, 138000,0, 414000, 6, 20,66,66,81,81,81,81,81,81),
- (30, 10, 169000,0, 507000, 6, 14,38,38,74,74,74,74,74,74),
- (30, 11, 174333,0, 523000, 2, 10,30,30,72,72,72,72,72,72),
- (30, 12, 179333,0, 538000, 2, 6, 20,20,70,70,70,70,70,70),
- (30, 13, 219667,0, 659000, 2, 2, 14,14,58,58,58,58,58,58),
- (30, 14, 226667,0, 680000, 1, 2, 10,10,56,56,56,56,56,56),
- (30, 15, 233000,0, 699000, 1, 2, 6, 6, 54,54,54,54,54,54),
- (30, 16, 285667,0, 857000, 1, 1, 2, 2, 28,28,28,28,28,28),
- (30, 17, 294667,0, 884000, 1, 1, 2, 2, 20,20,20,20,20,20),
- (30, 18, 303000,0, 909000, 1, 1, 2, 2, 14,14,14,14,14,14),
- (30, 19, 371333,0, 1114000, 1, 1, 1, 1, 6, 6, 6, 6, 6, 6),
- (30, 20, 383000,0, 1149000, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2),
- (30, 21, 394000,0, 1182000, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2),
- (30, 22, 483667,0, 1448000, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2),
- (30, 23, 498000,0, 1494000, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
- (30, 24, 512333,0, 1537000, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1),
- (30, 25, 627333,0, 1882000, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1),
- (30, 26, 647333,0, 1942000, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1),
- (30, 27, 666000,0, 1998000, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1),
- (30, 28, 815667,0, 2447000, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1),
- (30, 29, 841667,0, 2525000, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1),
- (30, 30, 865667,0, 2597000, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1);
|
