-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathScalingStatValues.sql
106 lines (106 loc) · 10.5 KB
/
ScalingStatValues.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
DROP TABLE IF EXISTS `ScalingStatValues`;
CREATE TABLE `ScalingStatValues` ( `ID` INT NOT NULL DEFAULT '0',
`Charlevel` INT NOT NULL DEFAULT '0',
`ShoulderBudget` INT NOT NULL DEFAULT '0',
`TrinketBudget` INT NOT NULL DEFAULT '0',
`WeaponBudget1H` INT NOT NULL DEFAULT '0',
`RangedBudget` INT NOT NULL DEFAULT '0',
`ClothShoulderArmor` INT NOT NULL DEFAULT '0',
`LeatherShoulderArmor` INT NOT NULL DEFAULT '0',
`MailShoulderArmor` INT NOT NULL DEFAULT '0',
`PlateShoulderArmor` INT NOT NULL DEFAULT '0',
`WeaponDPS1H` INT NOT NULL DEFAULT '0',
`WeaponDPS2H` INT NOT NULL DEFAULT '0',
`SpellcasterDPS1H` INT NOT NULL DEFAULT '0',
`SpellcasterDPS2H` INT NOT NULL DEFAULT '0',
`RangedDPS` INT NOT NULL DEFAULT '0',
`WandDPS` INT NOT NULL DEFAULT '0',
`SpellPower` INT NOT NULL DEFAULT '0',
`PrimaryBudget` INT NOT NULL DEFAULT '0',
`TertiaryBudget` INT NOT NULL DEFAULT '0',
`ClothCloakArmor` INT NOT NULL DEFAULT '0',
`ClothChestArmor` INT NOT NULL DEFAULT '0',
`LeatherChestArmor` INT NOT NULL DEFAULT '0',
`MailChestArmor` INT NOT NULL DEFAULT '0',
`PlateChestArmor` INT NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `ScalingStatValues` VALUES (1,1,2,2,1,1,10,32,32,64,6,8,6,8,6,8,1,3,1,7,13,43,43,85);
INSERT INTO `ScalingStatValues` VALUES (2,2,3,3,1,1,12,35,35,70,6,9,6,9,7,9,2,3,2,8,16,47,47,93);
INSERT INTO `ScalingStatValues` VALUES (3,3,3,3,1,1,13,39,39,76,7,9,7,9,7,10,3,4,2,9,17,52,52,101);
INSERT INTO `ScalingStatValues` VALUES (4,4,3,3,1,1,14,42,42,83,7,10,7,10,8,11,3,4,2,9,19,56,56,111);
INSERT INTO `ScalingStatValues` VALUES (5,5,4,4,2,2,16,45,45,89,8,10,8,10,8,12,4,5,3,11,21,60,60,119);
INSERT INTO `ScalingStatValues` VALUES (6,6,4,4,2,2,17,48,48,95,8,11,8,11,9,12,5,5,3,11,23,64,64,127);
INSERT INTO `ScalingStatValues` VALUES (7,7,4,4,3,2,19,51,51,101,9,11,9,11,9,13,6,6,3,13,25,68,68,135);
INSERT INTO `ScalingStatValues` VALUES (8,8,5,5,3,2,20,54,54,107,9,12,9,12,9,14,7,7,4,13,27,72,72,143);
INSERT INTO `ScalingStatValues` VALUES (9,9,5,5,3,2,22,56,56,113,10,13,10,13,10,15,7,7,4,15,29,75,75,151);
INSERT INTO `ScalingStatValues` VALUES (10,10,6,6,3,2,23,57,57,119,10,13,10,13,10,16,8,8,4,15,31,76,76,159);
INSERT INTO `ScalingStatValues` VALUES (81,11,6,6,4,3,24,59,59,125,11,14,11,14,11,16,9,8,5,16,32,79,79,167);
INSERT INTO `ScalingStatValues` VALUES (82,12,7,7,4,3,25,60,60,131,11,15,11,15,12,17,10,9,5,17,33,80,80,175);
INSERT INTO `ScalingStatValues` VALUES (83,13,7,7,4,3,26,61,61,133,12,16,12,16,12,18,10,9,5,17,35,81,81,177);
INSERT INTO `ScalingStatValues` VALUES (84,14,8,8,4,3,27,63,63,136,12,16,12,16,13,19,11,10,6,18,36,84,84,181);
INSERT INTO `ScalingStatValues` VALUES (85,15,8,8,5,3,28,64,64,138,13,17,13,17,13,20,12,11,6,19,37,85,85,184);
INSERT INTO `ScalingStatValues` VALUES (136,16,8,8,5,4,29,65,65,141,14,18,14,18,14,21,13,11,6,19,39,87,87,188);
INSERT INTO `ScalingStatValues` VALUES (137,17,9,9,5,4,30,67,67,143,14,19,14,19,14,22,14,12,7,20,40,89,89,191);
INSERT INTO `ScalingStatValues` VALUES (138,18,9,9,5,4,30,68,68,146,15,19,15,19,15,23,14,12,7,20,40,91,91,195);
INSERT INTO `ScalingStatValues` VALUES (139,19,10,10,6,4,31,69,69,148,15,20,15,20,15,24,15,13,7,21,41,92,92,197);
INSERT INTO `ScalingStatValues` VALUES (61,20,10,10,6,4,32,71,71,151,16,21,16,21,16,25,16,14,8,21,43,95,95,201);
INSERT INTO `ScalingStatValues` VALUES (141,21,11,11,6,5,33,72,72,153,16,21,16,21,16,26,17,14,8,22,44,96,96,204);
INSERT INTO `ScalingStatValues` VALUES (142,22,11,11,6,5,34,73,73,156,17,22,17,22,17,27,18,15,8,23,45,97,97,208);
INSERT INTO `ScalingStatValues` VALUES (143,23,12,12,7,5,34,75,75,158,17,23,17,23,17,28,18,15,9,23,45,100,100,211);
INSERT INTO `ScalingStatValues` VALUES (144,24,12,12,7,5,35,76,76,161,18,23,18,23,18,29,19,16,9,23,47,101,101,215);
INSERT INTO `ScalingStatValues` VALUES (145,25,12,12,7,5,35,77,77,163,19,24,19,24,19,29,20,17,9,23,47,103,103,217);
INSERT INTO `ScalingStatValues` VALUES (146,26,13,13,7,5,36,78,78,166,19,25,19,25,19,30,21,17,10,24,48,104,104,221);
INSERT INTO `ScalingStatValues` VALUES (147,27,13,13,8,6,37,80,80,168,20,26,20,26,20,31,22,18,10,25,49,107,107,224);
INSERT INTO `ScalingStatValues` VALUES (148,28,14,14,8,6,37,81,81,171,21,27,21,27,21,32,22,18,10,25,49,108,108,228);
INSERT INTO `ScalingStatValues` VALUES (149,29,14,14,8,6,38,82,82,173,22,29,22,29,22,32,23,19,11,25,51,109,109,231);
INSERT INTO `ScalingStatValues` VALUES (150,30,15,15,8,6,38,84,84,176,23,30,23,30,22,33,24,20,11,25,51,112,112,235);
INSERT INTO `ScalingStatValues` VALUES (151,31,15,15,9,6,39,85,85,178,24,31,24,31,23,34,25,20,11,26,52,113,113,237);
INSERT INTO `ScalingStatValues` VALUES (152,32,16,16,9,7,40,86,86,181,25,32,25,32,24,34,25,21,12,27,53,115,115,241);
INSERT INTO `ScalingStatValues` VALUES (153,33,16,16,9,7,41,88,88,184,25,33,25,33,25,35,26,21,12,27,55,117,117,245);
INSERT INTO `ScalingStatValues` VALUES (154,34,16,16,9,7,43,90,90,187,26,34,26,34,26,36,27,22,12,29,57,120,120,249);
INSERT INTO `ScalingStatValues` VALUES (155,35,17,17,10,7,44,91,91,190,27,35,27,35,26,37,28,23,13,29,59,121,121,253);
INSERT INTO `ScalingStatValues` VALUES (156,36,17,17,10,7,44,93,93,193,28,36,28,36,27,38,29,23,13,29,59,124,124,257);
INSERT INTO `ScalingStatValues` VALUES (157,37,18,18,10,8,46,95,95,196,28,37,28,37,28,39,29,24,13,31,61,127,127,261);
INSERT INTO `ScalingStatValues` VALUES (158,38,18,18,10,8,47,97,97,199,29,38,29,38,28,40,30,24,14,31,63,129,129,265);
INSERT INTO `ScalingStatValues` VALUES (159,39,19,19,11,8,48,99,99,202,29,38,29,38,29,41,31,25,14,32,64,132,132,269);
INSERT INTO `ScalingStatValues` VALUES (160,40,19,19,11,8,49,100,205,360,30,39,30,39,30,42,32,26,14,33,65,133,273,480);
INSERT INTO `ScalingStatValues` VALUES (161,41,20,20,11,8,50,102,209,368,31,40,31,40,30,43,33,26,15,33,67,136,279,491);
INSERT INTO `ScalingStatValues` VALUES (162,42,20,20,11,8,51,104,213,375,31,41,31,41,31,44,33,27,15,34,68,139,284,500);
INSERT INTO `ScalingStatValues` VALUES (163,43,20,20,12,9,52,106,217,382,32,41,32,41,31,45,34,27,15,35,69,141,289,509);
INSERT INTO `ScalingStatValues` VALUES (164,44,21,21,12,9,53,108,221,389,32,42,32,42,32,47,35,28,16,35,71,144,295,519);
INSERT INTO `ScalingStatValues` VALUES (165,45,21,21,12,9,54,109,225,396,33,43,33,43,33,48,36,28,16,36,72,145,300,528);
INSERT INTO `ScalingStatValues` VALUES (166,46,22,22,12,9,55,111,229,403,34,44,34,44,33,50,37,29,16,37,73,148,305,537);
INSERT INTO `ScalingStatValues` VALUES (167,47,22,22,13,9,56,113,233,410,34,45,34,45,34,51,37,30,17,37,75,151,311,547);
INSERT INTO `ScalingStatValues` VALUES (168,48,23,23,13,10,57,115,238,418,35,45,35,45,34,52,38,30,17,38,76,153,317,557);
INSERT INTO `ScalingStatValues` VALUES (169,49,23,23,13,10,58,117,242,425,35,46,35,46,35,53,39,31,17,39,77,156,323,567);
INSERT INTO `ScalingStatValues` VALUES (170,50,24,24,13,10,59,118,246,433,36,47,36,47,36,54,40,31,18,39,79,157,328,577);
INSERT INTO `ScalingStatValues` VALUES (171,51,24,24,14,10,60,120,250,440,37,48,37,48,36,54,40,32,18,40,80,160,333,587);
INSERT INTO `ScalingStatValues` VALUES (172,52,24,24,14,10,61,122,254,448,37,49,37,49,37,55,41,33,18,41,81,163,339,597);
INSERT INTO `ScalingStatValues` VALUES (173,53,25,25,14,11,62,124,258,455,38,49,38,49,38,57,42,33,19,41,83,165,344,607);
INSERT INTO `ScalingStatValues` VALUES (174,54,25,25,14,11,63,126,262,463,38,50,38,50,38,58,43,34,19,42,84,168,349,617);
INSERT INTO `ScalingStatValues` VALUES (175,55,26,26,15,11,64,127,266,470,39,51,39,51,39,59,44,34,19,43,85,169,355,627);
INSERT INTO `ScalingStatValues` VALUES (176,56,26,26,15,11,65,129,270,478,40,52,40,52,39,61,44,35,20,43,87,172,360,637);
INSERT INTO `ScalingStatValues` VALUES (177,57,27,27,15,11,66,131,274,485,40,53,40,53,40,62,45,36,20,44,88,175,365,647);
INSERT INTO `ScalingStatValues` VALUES (178,58,34,34,19,14,83,159,344,611,50,65,46,60,48,85,46,46,25,55,111,212,459,815);
INSERT INTO `ScalingStatValues` VALUES (179,59,36,36,20,15,86,164,356,633,51,67,47,61,50,88,52,47,27,57,115,219,475,844);
INSERT INTO `ScalingStatValues` VALUES (180,60,37,37,21,16,88,169,368,655,53,68,47,62,51,91,57,49,28,59,117,225,491,873);
INSERT INTO `ScalingStatValues` VALUES (181,61,39,39,22,16,91,174,380,677,54,70,48,63,52,94,63,51,29,61,121,232,507,903);
INSERT INTO `ScalingStatValues` VALUES (182,62,40,40,22,17,94,178,392,699,55,72,49,64,53,97,68,53,30,63,125,237,523,932);
INSERT INTO `ScalingStatValues` VALUES (183,63,41,41,23,17,97,183,404,721,56,73,50,65,54,100,73,54,31,65,129,244,539,961);
INSERT INTO `ScalingStatValues` VALUES (184,64,42,42,24,18,100,187,416,742,58,75,50,66,55,104,80,55,31,67,133,249,555,989);
INSERT INTO `ScalingStatValues` VALUES (185,65,43,43,24,18,102,192,428,764,60,78,52,67,57,109,89,57,32,68,136,256,571,1019);
INSERT INTO `ScalingStatValues` VALUES (186,66,44,44,25,18,105,197,440,786,62,81,53,69,59,113,98,58,33,70,140,263,587,1048);
INSERT INTO `ScalingStatValues` VALUES (187,67,45,45,25,19,108,203,452,808,65,84,54,71,61,117,107,59,34,72,144,271,603,1077);
INSERT INTO `ScalingStatValues` VALUES (188,68,62,62,36,26,157,294,654,1169,91,119,70,91,82,168,220,84,47,105,209,392,872,1559);
INSERT INTO `ScalingStatValues` VALUES (189,69,64,64,37,27,161,303,675,1206,93,121,71,92,84,172,228,87,48,107,215,404,900,1608);
INSERT INTO `ScalingStatValues` VALUES (190,70,67,67,39,28,166,312,695,1242,95,124,72,94,86,175,238,90,50,111,221,416,927,1656);
INSERT INTO `ScalingStatValues` VALUES (191,71,69,69,40,29,171,321,715,1278,97,127,73,95,88,179,246,93,52,114,228,428,953,1704);
INSERT INTO `ScalingStatValues` VALUES (192,72,72,72,42,30,176,331,736,1315,99,129,75,97,90,183,255,97,54,117,235,441,981,1753);
INSERT INTO `ScalingStatValues` VALUES (193,73,75,75,43,32,181,340,756,1351,102,132,76,99,92,187,265,101,56,121,241,453,1008,1801);
INSERT INTO `ScalingStatValues` VALUES (194,74,78,78,45,33,186,349,776,1387,104,135,77,100,94,191,275,104,58,124,248,465,1035,1849);
INSERT INTO `ScalingStatValues` VALUES (195,75,81,81,46,34,191,358,797,1423,106,138,79,102,96,196,285,108,60,127,255,477,1063,1897);
INSERT INTO `ScalingStatValues` VALUES (196,76,84,84,48,35,196,367,817,1460,109,141,80,104,98,200,296,113,63,131,261,489,1089,1947);
INSERT INTO `ScalingStatValues` VALUES (197,77,87,87,50,37,200,376,837,1496,111,145,81,106,101,205,307,117,65,133,267,501,1116,1995);
INSERT INTO `ScalingStatValues` VALUES (198,78,90,90,52,38,205,386,858,1532,114,148,83,108,103,210,319,121,68,137,273,515,1144,2043);
INSERT INTO `ScalingStatValues` VALUES (199,79,94,94,54,40,208,390,868,1551,117,152,85,110,105,215,331,126,71,139,277,520,1157,2068);
INSERT INTO `ScalingStatValues` VALUES (200,80,97,97,56,41,210,395,878,1570,120,156,86,112,108,220,343,131,73,140,280,527,1171,2093);