sql/updates/2008_12_22_11_mangos_player_classlevelstats.sql

   1 ALTER TABLE db_version CHANGE COLUMN required_2008_12_22_10_mangos_string required_2008_12_22_11_mangos_player_classlevelstats bit;
   2
   3 DELETE FROM `player_classlevelstats` WHERE  class = 6 OR level > 70;
   4 INSERT INTO `player_classlevelstats` VALUES
   5 (1,71,4720,0),
   6 (1,72,5013,0),
   7 (1,73,5325,0),
   8 (1,74,5656,0),
   9 (1,75,6008,0),
  10 (1,76,6381,0),
  11 (1,77,6778,0),
  12 (1,78,7198,0),
  13 (1,79,7646,0),
  14 (1,80,8121,0),
  15
  16 (2,71,3629,3097),
  17 (2,72,3900,3241),
  18 (2,73,4191,3385),
  19 (2,74,4503,3529),
  20 (2,75,4839,3673),
  21 (2,76,5200,3817),
  22 (2,77,5588,3962),
  23 (2,78,6005,4106),
  24 (2,79,6453,4250),
  25 (2,80,6934,4394),
  26
  27 (3,71,3834,3549),
  28 (3,72,4120,3716),
  29 (3,73,4427,3882),
  30 (3,74,4757,4048),
  31 (3,75,5112,4215),
  32 (3,76,5493,4381),
  33 (3,77,5903,4547),
  34 (3,78,6343,4713),
  35 (3,79,6816,4880),
  36 (3,80,7324,5046),
  37
  38 (4,71,3980,0),
  39 (4,72,4277,0),
  40 (4,73,4596,0),
  41 (4,74,4939,0),
  42 (4,75,5307,0),
  43 (4,76,5703,0),
  44 (4,77,6128,0),
  45 (4,78,6585,0),
  46 (4,79,7076,0),
  47 (4,80,7604,0),
  48
  49 (5,71,3644,2744),
  50 (5,72,3916,2868),
  51 (5,73,4208,2993),
  52 (5,74,4522,3117),
  53 (5,75,4859,3242),
  54 (5,76,5221,3366),
  55 (5,77,5610,3490),
  56 (5,78,6028,3615),
  57 (5,79,6477,3739),
  58 (5,80,6960,3863),
  59
  60 (6,1,22,0),
  61 (6,2,27,0),
  62 (6,3,32,0),
  63 (6,4,37,0),
  64 (6,5,42,0),
  65 (6,6,47,0),
  66 (6,7,52,0),
  67 (6,8,58,0),
  68 (6,9,64,0),
  69 (6,10,70,0),
  70 (6,11,77,0),
  71 (6,12,84,0),
  72 (6,13,92,0),
  73 (6,14,100,0),
  74 (6,15,117,0),
  75 (6,16,127,0),
  76 (6,17,138,0),
  77 (6,18,150,0),
  78 (6,19,163,0),
  79 (6,20,177,0),
  80 (6,21,192,0),
  81 (6,22,208,0),
  82 (6,23,225,0),
  83 (6,24,239,0),
  84 (6,25,258,0),
  85 (6,26,278,0),
  86 (6,27,299,0),
  87 (6,28,321,0),
  88 (6,29,344,0),
  89 (6,30,368,0),
  90 (6,31,393,0),
  91 (6,32,419,0),
  92 (6,33,446,0),
  93 (6,34,474,0),
  94 (6,35,503,0),
  95 (6,36,533,0),
  96 (6,37,564,0),
  97 (6,38,596,0),
  98 (6,39,629,0),
  99 (6,40,698,0),
 100 (6,41,698,0),
 101 (6,42,734,0),
 102 (6,43,771,0),
 103 (6,44,809,0),
 104 (6,45,849,0),
 105 (6,46,891,0),
 106 (6,47,935,0),
 107 (6,48,981,0),
 108 (6,49,1029,0),
 109 (6,50,1079,0),
 110 (6,51,1131,0),
 111 (6,52,1185,0),
 112 (6,53,1241,0),
 113 (6,54,1299,0),
 114 (6,55,1359,0),
 115 (6,56,1421,0),
 116 (6,57,1485,0),
 117 (6,58,1551,0),
 118 (6,59,1619,0),
 119 (6,60,1689,0),
 120 (6,61,1902,0),
 121 (6,62,2129,0),
 122 (6,63,2357,0),
 123 (6,64,2612,0),
 124 (6,65,2883,0),
 125 (6,66,3169,0),
 126 (6,67,3455,0),
 127 (6,68,3774,0),
 128 (6,69,4109,0),
 129 (6,70,4444,0),
 130 (6,71,4720,0),
 131 (6,72,5013,0),
 132 (6,73,5325,0),
 133 (6,74,5656,0),
 134 (6,75,6008,0),
 135 (6,76,6381,0),
 136 (6,77,6778,0),
 137 (6,78,7199,0),
 138 (6,79,7646,0),
 139 (6,80,8121,0),
 140
 141 (7,71,3395,3102),
 142 (7,72,3648,3246),
 143 (7,73,3920,3389),
 144 (7,74,4212,3533),
 145 (7,75,4526,3677),
 146 (7,76,4863,3821),
 147 (7,77,5226,3965),
 148 (7,78,5616,4108),
 149 (7,79,6035,4252),
 150 (7,80,6485,4396),
 151
 152 (8,71,3646,2343),
 153 (8,72,3918,2446),
 154 (8,73,4210,2549),
 155 (8,74,4524,2652),
 156 (8,75,4861,2754),
 157 (8,76,5223,2857),
 158 (8,77,5612,2960),
 159 (8,78,6030,3063),
 160 (8,79,6480,3165),
 161 (8,80,6963,3268),
 162
 163 (9,71,3750,2739),
 164 (9,72,4025,2863),
 165 (9,73,4330,2987),
 166 (9,74,4646,3111),
 167 (9,75,4997,3235),
 168 (9,76,5373,3360),
 169 (9,77,5774,3483),
 170 (9,78,6207,3608),
 171 (9,79,6667,3732),
 172 (9,80,7136,3856),
 173
 174 (11,71,3883,2482),
 175 (11,72,4172,2595),
 176 (11,73,4483,2708),
 177 (11,74,4817,2820),
 178 (11,75,5176,2933),
 179 (11,76,5562,3045),
 180 (11,77,5977,3158),
 181 (11,78,6423,3270),
 182 (11,79,6902,3383),
 183 (11,80,7417,3496);