Missing updated file added for last commit.

How about me saving the damn file before committing first...

--HG--
branch : trunk

1 files changed, 433 insertions, 479 deletions

diff --git a/sql/world.sql b/sql/world.sql
index 2dc073f0b74..57fad9c75f3 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -876,479 +876,433 @@ LOCK TABLES `creature_ai_texts` WRITE;
 /*!40000 ALTER TABLE `creature_ai_texts` ENABLE KEYS */;
 UNLOCK TABLES;
 
+--
 -- Table structure for table `creature_classlevelstats`
+--
 
 DROP TABLE IF EXISTS `creature_classlevelstats`;
-
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `creature_classlevelstats` (
-  `exp` tinyint(1) NOT NULL,
-  `class` tinyint(1) NOT NULL,
   `level` tinyint(1) NOT NULL,
-  `basehp` smallint(2) NOT NULL,
-  `basemana` smallint(2) NOT NULL
+  `class` tinyint(1) NOT NULL,
+  `basehp0` smallint(2) NOT NULL,
+  `basehp1` smallint(2) NOT NULL,  
+  `basehp2` smallint(2) NOT NULL,  
+  `basemana` smallint(2) NOT NULL,
+  `basearmor` smallint(2) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
 
-INSERT INTO `creature_classlevelstats` (`exp`,`class`,`level`,`basehp`,`basemana`) VALUES
-(0,1,1,42,0),
-(0,1,2,55,0),
-(0,1,3,71,0),
-(0,1,4,86,0),
-(0,1,5,102,0),
-(0,1,6,120,0),
-(0,1,7,137,0),
-(0,1,8,156,0),
-(0,1,9,176,0),
-(0,1,10,198,0),
-(0,1,11,222,0),
-(0,1,12,247,0),
-(0,1,13,273,0),
-(0,1,14,300,0),
-(0,1,15,328,0),
-(0,1,16,356,0),
-(0,1,17,386,0),
-(0,1,18,417,0),
-(0,1,19,449,0),
-(0,1,20,484,0),
-(0,1,21,521,0),
-(0,1,22,562,0),
-(0,1,23,605,0),
-(0,1,24,651,0),
-(0,1,25,699,0),
-(0,1,26,750,0),
-(0,1,27,800,0),
-(0,1,28,853,0),
-(0,1,29,905,0),
-(0,1,30,955,0),
-(0,1,31,1006,0),
-(0,1,32,1057,0),
-(0,1,33,1110,0),
-(0,1,34,1163,0),
-(0,1,35,1220,0),
-(0,1,36,1277,0),
-(0,1,37,1336,0),
-(0,1,38,1395,0),
-(0,1,39,1459,0),
-(0,1,40,1524,0),
-(0,1,41,1585,0),
-(0,1,42,1651,0),
-(0,1,43,1716,0),
-(0,1,44,1782,0),
-(0,1,45,1848,0),
-(0,1,46,1919,0),
-(0,1,47,1990,0),
-(0,1,48,2061,0),
-(0,1,49,2138,0),
-(0,1,50,2215,0),
-(0,1,51,2292,0),
-(0,1,52,2371,0),
-(0,1,53,2453,0),
-(0,1,54,2533,0),
-(0,1,55,2614,0),
-(0,1,56,2699,0),
-(0,1,57,2784,0),
-(0,1,58,2871,0),
-(0,1,59,2961,0),
-(0,1,60,3052,0),
-(0,1,61,3144,0),
-(0,1,62,3237,0),
-(0,1,63,3331,0),
-(0,1,64,1,0), -- TODO
-(0,1,65,3524,0),
-(0,1,66,3624,0),
-(0,1,67,3728,0),
-(0,1,68,3834,0),
-(0,1,69,1,0), -- TODO
-(0,1,70,4050,0),
-(0,1,71,4163,0),
-(0,1,72,4278,0),
-(0,1,73,1,0), -- TODO
-(0,1,74,4524,0),
-(0,1,75,4652,0),
-(0,1,76,4781,0),
-(0,1,77,4916,0),
-(0,1,78,5052,0),
-(0,1,79,5194,0),
-(0,1,80,5342,0),
-(0,1,81,5496,0),
-(0,1,82,5647,0),
-(0,1,83,5808,0),
-(1,1,58,3989,0),
-(1,1,59,4142,0),
-(1,1,60,4979,0),
-(1,1,61,5158,0),
-(1,1,62,5341,0),
-(1,1,63,5527,0),
-(1,1,64,5715,0),
-(1,1,65,5914,0),
-(1,1,66,6116,0),
-(1,1,67,6326,0),
-(1,1,68,6542,0),
-(1,1,69,6761,0),
-(1,1,70,6986,0),
-(1,1,71,7181,0),
-(1,1,72,7380,0),
-(1,1,73,7580,0),
-(2,1,68,6986,0),
-(2,1,69,7984,0),
-(2,1,70,8982,0),
-(2,1,71,9291,0),
-(2,1,72,9610,0),
-(2,1,73,9940,0),
-(2,1,74,10282,0),
-(2,1,75,10635,0),
-(2,1,76,11001,0),
-(2,1,77,11379,0),
-(2,1,78,11770,0),
-(2,1,79,12175,0),
-(2,1,80,12600,0),
-(2,1,81,13033,0),
-(2,1,82,13481,0),
-(2,1,83,13945,0),
-(0,2,1,41,60),
-(0,2,2,54,69),
-(0,2,3,69,79),
-(0,2,4,83,104),
-(0,2,5,98,115),
-(0,2,6,115,126),
-(0,2,7,131,138),
-(0,2,8,148,165),
-(0,2,9,166,178),
-(0,2,10,186,191),
-(0,2,11,208,205),
-(0,2,12,230,249),
-(0,2,13,253,264),
-(0,2,14,276,295),
-(0,2,15,301,326),
-(0,2,16,325,357),
-(0,2,17,350,390),
-(0,2,18,377,408),
-(0,2,19,404,456),
-(0,2,20,433,490),
-(0,2,21,464,510),
-(0,2,22,498,544),
-(0,2,23,533,581), 
-(0,2,24,571,618),
-(0,2,25,610,655),
-(0,2,26,651,693),
-(0,2,27,690,732),
-(0,2,28,732,756),
-(0,2,29,773,811),
-(0,2,30,811,852),
-(0,2,31,850,878),
-(0,2,32,888,935),
-(0,2,33,928,963),
-(0,2,34,967,1007),
-(0,2,35,1009,1067),
-(0,2,36,1050,1097),
-(0,2,37,1093,1142),
-(0,2,38,1135,1186),
-(0,2,39,1180,1236),
-(0,2,40,1226,1283),
-(0,2,41,1268,1332),
-(0,2,42,1321,1381),
-(0,2,43,1373,1432),
-(0,2,44,1426,1483),
-(0,2,45,1478,1534),
-(0,2,46,1535,1587),
-(0,2,47,1592,1640),
-(0,2,48,1650,1695),
-(0,2,49,1710,1750),
-(0,2,50,1772,1807),
-(0,2,51,1834,1864),
-(0,2,52,1897,1923),
-(0,2,53,1962,1982),
-(0,2,54,2026,2041),
-(0,2,55,2091,2117),
-(0,2,56,2159,2163),
-(0,2,57,2227,2241),
-(0,2,58,2297,2289),
-(0,2,59,2369,2369),
-(0,2,60,2442,2434),
-(0,2,61,2515,2486),
-(0,2,62,2590,2568),
-(0,2,63,2665,2620),
-(0,2,64,1,2705), -- TODO
-(0,2,65,2819,2790),
-(0,2,66,2899,2846),
-(0,2,67,2982,2933),
-(0,2,68,3067,2991),
-(0,2,69,1,3080), -- TODO
-(0,2,70,3240,3155),
-(0,2,71,3330,3231),
-(0,2,72,3422,3309),
-(0,2,73,1,3387), -- TODO
-(0,2,74,3619,3466),
-(0,2,75,3722,3561),
-(0,2,76,3825,3643),
-(0,2,77,3933,3725),
-(0,2,78,4042,3809),
-(0,2,79,4155,3893),
-(0,2,80,4274,3994),
-(0,2,81,4394,4081),
-(0,2,82,4518,4169),
-(0,2,83,4646,4258),
-(1,2,58,3191,2289),
-(1,2,59,3314,2369),
-(1,2,60,3984,2434),
-(1,2,61,4126,2486),
-(1,2,62,4274,2568),
-(1,2,63,4422,2620),
-(1,2,64,4572,2705),
-(1,2,65,4731,2790),
-(1,2,66,4892,2846),
-(1,2,67,5060,2933),
-(1,2,68,5233,2991),
-(1,2,69,5409,3080),
-(1,2,70,5589,3155),
-(1,2,71,5744,3231),
-(1,2,72,5900,3309),
-(1,2,73,6070,3387),
-(2,2,68,6986,2991),
-(2,2,69,7984,3080),
-(2,2,70,8982,3155),
-(2,2,71,9291,3231),
-(2,2,72,9610,3309),
-(2,2,73,9940,3387),
-(2,2,74,10282,3466),
-(2,2,75,10635,3561),
-(2,2,76,11001,3643),
-(2,2,77,11379,3725),
-(2,2,78,11770,3809),
-(2,2,79,12175,3893),
-(2,2,80,12600,3994),
-(2,2,81,13033,4081),
-(2,2,82,13481,4169),
-(2,2,83,13945,4258),
-(0,4,1,42,0),
-(0,4,2,55,0),
-(0,4,3,71,0),
-(0,4,4,86,0),
-(0,4,5,102,0),
-(0,4,6,120,0),
-(0,4,7,137,0),
-(0,4,8,156,0),
-(0,4,9,176,0),
-(0,4,10,198,0),
-(0,4,11,222,0),
-(0,4,12,247,0),
-(0,4,13,273,0),
-(0,4,14,300,0),
-(0,4,15,328,0),
-(0,4,16,356,0),
-(0,4,17,386,0),
-(0,4,18,417,0),
-(0,4,19,449,0),
-(0,4,20,484,0),
-(0,4,21,521,0),
-(0,4,22,562,0),
-(0,4,23,605,0),
-(0,4,24,651,0),
-(0,4,25,699,0),
-(0,4,26,750,0),
-(0,4,27,800,0),
-(0,4,28,853,0),
-(0,4,29,905,0),
-(0,4,30,955,0),
-(0,4,31,1006,0),
-(0,4,32,1057,0),
-(0,4,33,1110,0),
-(0,4,34,1163,0),
-(0,4,35,1220,0),
-(0,4,36,1277,0),
-(0,4,37,1336,0),
-(0,4,38,1395,0),
-(0,4,39,1459,0),
-(0,4,40,1524,0),
-(0,4,41,1585,0),
-(0,4,42,1651,0),
-(0,4,43,1716,0),
-(0,4,44,1782,0),
-(0,4,45,1848,0),
-(0,4,46,1919,0),
-(0,4,47,1990,0),
-(0,4,48,2061,0),
-(0,4,49,2138,0),
-(0,4,50,2215,0),
-(0,4,51,2292,0),
-(0,4,52,2371,0),
-(0,4,53,2453,0),
-(0,4,54,2533,0),
-(0,4,55,2614,0),
-(0,4,56,2699,0),
-(0,4,57,2784,0),
-(0,4,58,2871,0),
-(0,4,59,2961,0),
-(0,4,60,3052,0),
-(0,4,61,3144,0),
-(0,4,62,3237,0),
-(0,4,63,3331,0),
-(0,4,64,1,0), -- TODO
-(0,4,65,3524,0),
-(0,4,66,3624,0),
-(0,4,67,3728,0),
-(0,4,68,3834,0),
-(0,4,69,1,0), -- TODO
-(0,4,70,4050,0),
-(0,4,71,4163,0),
-(0,4,72,4278,0),
-(0,4,73,1,0), -- TODO
-(0,4,74,4524,0),
-(0,4,75,4652,0),
-(0,4,76,4781,0),
-(0,4,77,4916,0),
-(0,4,78,5052,0),
-(0,4,79,5194,0),
-(0,4,80,5342,0),
-(0,4,81,5496,0),
-(0,4,82,5647,0),
-(0,4,83,5808,0),
-(1,4,58,3989,0),
-(1,4,59,4142,0),
-(1,4,60,4979,0),
-(1,4,61,5158,0),
-(1,4,62,5341,0),
-(1,4,63,5527,0),
-(1,4,64,5715,0),
-(1,4,65,5914,0),
-(1,4,66,6116,0),
-(1,4,67,6326,0),
-(1,4,68,6542,0),
-(1,4,69,6761,0),
-(1,4,70,6986,0),
-(1,4,71,7181,0),
-(1,4,72,7380,0),
-(1,4,73,7580,0),
-(2,4,68,6986,0),
-(2,4,69,7984,0),
-(2,4,70,8982,0),
-(2,4,71,9291,0),
-(2,4,72,9610,0),
-(2,4,73,9940,0),
-(2,4,74,10282,0),
-(2,4,75,10635,0),
-(2,4,76,11001,0),
-(2,4,77,11379,0),
-(2,4,78,11770,0),
-(2,4,79,12175,0),
-(2,4,80,12600,0),
-(2,4,81,13033,0),
-(2,4,82,13481,0),
-(2,4,83,13945,0),
-(0,8,1,40,120),
-(0,8,2,52,0),
-(0,8,3,67,174),
-(0,8,4,81,202),
-(0,8,5,95,230),
-(0,8,6,111,259),
-(0,8,7,126,289),
-(0,8,8,143,319),
-(0,8,9,160,350),
-(0,8,10,178,382),
-(0,8,11,199,459),
-(0,8,12,219,537),
-(0,8,13,241,601),
-(0,8,14,263,710),
-(0,8,15,285,790),
-(0,8,16,307,856),
-(0,8,17,330,938),
-(0,8,18,354,1020),
-(0,8,19,379,1118),
-(0,8,20,405,1202),
-(0,8,21,432,1272),
-(0,8,22,463,1357),
-(0,8,23,494,1443),
-(0,8,24,528,1545),
-(0,8,25,562,1633),
-(0,8,26,598,1707),
-(0,8,27,633,1812),
-(0,8,28,669,1977),
-(0,8,29,704,2068),
-(0,8,30,737,2175),
-(0,8,31,770,2253),
-(0,8,32,802,2362),
-(0,8,33,835,2457),
-(0,8,34,867,2553),
-(0,8,35,902,2680),
-(0,8,36,935,2763),
-(0,8,37,970,2861),
-(0,8,38,1004,2975),
-(0,8,39,1040,3075),
-(0,8,40,1077,3191),
-(0,8,41,1110,3293),
-(0,8,42,1156,3471),
-(0,8,43,1201,3575),
-(0,8,44,1247,3680),
-(0,8,45,1294,3801),
-(0,8,46,1343,3923),
-(0,8,47,1393,4031),
-(0,8,48,1443,4140),
-(0,8,49,1497,4281),
-(0,8,50,1551,4393),
-(0,8,51,1604,4506),
-(0,8,52,1660,4650),
-(0,8,53,1717,4765),
-(0,8,54,1773,4896),
-(0,8,55,1830,5013),
-(0,8,56,1889,5206),
-(0,8,57,1949,5340),
-(0,8,58,2010,5461),
-(0,8,59,2073,5598),
-(0,8,60,2136,5751),
-(0,8,61,2201,5875),
-(0,8,62,2266,6015),
-(0,8,63,2332,6156),
-(0,8,64,1,6229), -- TODO
-(0,8,65,2467,6443),
-(0,8,66,2552,6588),
-(0,8,67,2610,6749),
-(0,8,68,2684,6882),
-(0,8,69,1,7031), -- TODO
-(0,8,70,2835,7196),
-(0,8,71,2914,7332),
-(0,8,72,2995,7500),
-(0,8,73,1,7654), -- TODO
-(0,8,74,3186,7809),
-(0,8,75,3256,7981),
-(0,8,76,3367,8139),
-(0,8,77,3462,8313),
-(0,8,78,3558,8459),
-(0,8,79,3658,8636),
-(0,8,80,3739,8814),
-(0,8,81,3870,8979),
-(0,8,82,3977,9160),
-(0,8,83,4090,9325),
-(1,8,58,2793,5461),
-(1,8,59,2899,5598),
-(1,8,60,3484,5751),
-(1,8,61,3611,5875),
-(1,8,62,3739,6015),
-(1,8,63,3870,6156),
-(1,8,64,4000,6229),
-(1,8,65,4140,6443),
-(1,8,66,4281,6588),
-(1,8,67,4429,6749),
-(1,8,68,4580,6882),
-(1,8,69,4733,7031),
-(1,8,70,4890,7196),
-(1,8,71,5027,7332),
-(1,8,72,5166,7500),
-(1,8,73,5311,7654),
-(2,8,68,5588,6882),
-(2,8,69,6387,7031),
-(2,8,70,7185,7196),
-(2,8,71,7432,7332),
-(2,8,72,7688,7500),
-(2,8,73,7952,7654),
-(2,8,74,8225,7809),
-(2,8,75,8508,7981),
-(2,8,76,8800,8139),
-(2,8,77,9103,8313),
-(2,8,78,9416,8459),
-(2,8,79,9740,8636),
-(2,8,80,10080,8814),
-(2,8,81,10486,8979),
-(2,8,82,10784,9160),
-(2,8,83,11156,9325);
+--
+-- Dumping data for table `creature_classlevelstats`;
+--
+
+LOCK TABLES `creature_classlevelstats` WRITE;
+/*!40000 ALTER TABLE `creature_classlevelstats` DISABLE KEYS */;
+INSERT INTO `creature_classlevelstats` (`class`,`level`,`basehp0`,`basehp1`,`basehp2`,`basemana`,`basearmor`) VALUES
+(1,1,42,1,1,0,8),
+(1,2,55,1,1,0,20),
+(1,3,71,1,1,0,33),
+(1,4,86,1,1,0,68),
+(1,5,102,1,1,0,111),
+(1,6,120,1,1,0,165),
+(1,7,137,1,1,0,230),
+(1,8,156,1,1,0,306),
+(1,9,176,1,1,0,387),
+(1,10,198,1,1,0,463),
+(1,11,222,1,1,0,528),
+(1,12,247,1,1,0,562),
+(1,13,273,1,1,0,596),
+(1,14,300,1,1,0,630),
+(1,15,328,1,1,0,665),
+(1,16,356,1,1,0,700),
+(1,17,386,1,1,0,734),
+(1,18,417,1,1,0,768),
+(1,19,449,1,1,0,802),
+(1,20,484,1,1,0,836),
+(1,21,521,1,1,0,872),
+(1,22,562,1,1,0,906),
+(1,23,605,1,1,0,940),
+(1,24,651,1,1,0,975),
+(1,25,699,1,1,0,1008),
+(1,26,750,1,1,0,1043),
+(1,27,800,1,1,0,1078),
+(1,28,853,1,1,0,1111),
+(1,29,905,1,1,0,1145),
+(1,30,955,1,1,0,1179),
+(1,31,1006,1,1,0,1213),
+(1,32,1057,1,1,0,1249),
+(1,33,1110,1,1,0,1281),
+(1,34,1163,1,1,0,1317),
+(1,35,1220,1,1,0,1349),
+(1,36,1277,1,1,0,1456),
+(1,37,1336,1,1,0,1568),
+(1,38,1395,1,1,0,1684),
+(1,39,1459,1,1,0,1808),
+(1,40,1524,1,1,0,1938),
+(1,41,1585,1,1,0,2074),
+(1,42,1651,1,1,0,2218),
+(1,43,1716,1,1,0,2369),
+(1,44,1782,1,1,0,2528),
+(1,45,1848,1,1,0,2695),
+(1,46,1919,1,1,0,2750),
+(1,47,1990,1,1,0,2804),
+(1,48,2062,1,1,0,2857),
+(1,49,2138,1,1,0,2912),
+(1,50,2215,1,1,0,2966),
+(1,51,2292,1,1,0,3018),
+(1,52,2371,1,1,0,3060),
+(1,53,2453,1,1,0,3128),
+(1,54,2533,1,1,0,3180),
+(1,55,2614,1,1,0,3234),
+(1,56,2699,1,1,0,3289),
+(1,57,2784,1,1,0,3342),
+(1,58,2871,3989,1,0,3396),
+(1,59,2961,4142,1,0,3449),
+(1,60,3052,4979,1,0,3750),
+(1,61,3144,5158,1,0,4047),
+(1,62,3237,5341,1,0,4344),
+(1,63,3331,5527,1,0,4641),
+(1,64,3427,5715,1,0,4937),
+(1,65,3524,5914,1,0,5234),
+(1,66,3624,6116,1,0,5531),
+(1,67,3728,6326,1,0,5829),
+(1,68,3834,6542,6986,0,6126),
+(1,69,3942,6761,7984,0,6423),
+(1,70,4050,6986,8982,0,6719),
+(1,71,4163,7181,9291,0,7018),
+(1,72,4278,7380,9610,0,7318),
+(1,73,4399,7588,9940,0,7618),
+(1,74,4524,7804,10282,0,7918),
+(1,75,4652,8025,10635,0,8219),
+(1,76,4781,8247,11001,0,8520),
+(1,77,4916,8480,11379,0,8822),
+(1,78,5052,0,11770,0,9124),
+(1,79,5194,0,12175,0,9426),
+(1,80,5342,9215,12600,0,9729),
+(1,81,5496,1,13033,0,10033),
+(1,82,5647,1,13481,0,10356),
+(1,83,5808,1,13945,0,10673),
+(1,84,1,1,1,0,1),
+(1,85,1,1,1,0,1),
+(1,86,1,1,1,0,1),
+(1,87,1,1,1,0,1),
+(1,88,1,1,1,0,1),
+(1,89,1,1,1,0,1),
+(1,90,1,1,1,0,1),
+(1,91,1,1,1,0,1),
+(1,92,1,1,1,0,1),
+(1,93,1,1,1,0,1),
+(1,94,1,1,1,0,1),
+(1,95,1,1,1,0,1),
+(1,96,1,1,1,0,1),
+(1,97,1,1,1,0,1),
+(1,98,1,1,1,0,1),
+(1,99,1,1,1,0,1),
+(1,100,1,1,1,0,1),
+(2,1,41,1,1,60,7),
+(2,2,54,1,1,69,19),
+(2,3,69,1,1,79,33),
+(2,4,83,1,1,104,66),
+(2,5,98,1,1,115,109),
+(2,6,115,1,1,126,163),
+(2,7,131,1,1,138,208),
+(2,8,148,1,1,165,303),
+(2,9,166,1,1,178,369),
+(2,10,186,1,1,191,460),
+(2,11,208,1,1,205,526),
+(2,12,230,1,1,249,560),
+(2,13,253,1,1,264,596),
+(2,14,276,1,1,295,630),
+(2,15,301,1,1,326,665),
+(2,16,325,1,1,357,700),
+(2,17,350,1,1,390,734),
+(2,18,377,1,1,408,768),
+(2,19,404,1,1,456,802),
+(2,20,433,1,1,490,836),
+(2,21,464,1,1,510,872),
+(2,22,498,1,1,545,906),
+(2,23,533,1,1,581,940),
+(2,24,571,1,1,618,975),
+(2,25,610,1,1,655,1008),
+(2,26,651,1,1,693,1042),
+(2,27,690,1,1,732,1078),
+(2,28,732,1,1,756,1110),
+(2,29,773,1,1,811,1145),
+(2,30,811,1,1,852,1178),
+(2,31,850,1,1,878,1213),
+(2,32,888,1,1,935,1248),
+(2,33,928,1,1,963,1281),
+(2,34,967,1,1,1007,1316),
+(2,35,1009,1,1,1067,1349),
+(2,36,1050,1,1,1097,1455),
+(2,37,1093,1,1,1142,1567),
+(2,38,1135,1,1,1189,1683),
+(2,39,1180,1,1,1236,1807),
+(2,40,1226,1,1,1283,1937),
+(2,41,1268,1,1,1332,2072),
+(2,42,1321,1,1,1381,2216),
+(2,43,1373,1,1,1432,2367),
+(2,44,1426,1,1,1483,2527),
+(2,45,1478,1,1,1534,2692),
+(2,46,1535,1,1,1587,2749),
+(2,47,1592,1,1,1640,2802),
+(2,48,1650,1,1,1695,2855),
+(2,49,1710,1,1,1750,2910),
+(2,50,1772,1,1,1807,2964),
+(2,51,1834,1,1,1864,3017),
+(2,52,1897,1,1,1923,3072),
+(2,53,1962,1,1,1982,3126),
+(2,54,2026,1,1,2041,3178),
+(2,55,2091,1,1,2117,3232),
+(2,56,2159,1,1,2163,3287),
+(2,57,2227,1,1,2241,3340),
+(2,58,2297,3191,1,2289,3394),
+(2,59,2369,3314,1,2369,3447),
+(2,60,2442,3984,1,2434,3748),
+(2,61,2515,4126,1,2486,4044),
+(2,62,2590,4274,1,2568,4340),
+(2,63,2665,4422,1,2620,4637),
+(2,64,2740,4572,1,2705,4933),
+(2,65,2819,4731,1,2790,5228),
+(2,66,2899,4892,6116,2846,5523),
+(2,67,2982,5060,1,2933,5821),
+(2,68,3067,5233,6986,2991,6116),
+(2,69,3153,5409,7984,3080,6412),
+(2,70,3240,5589,8982,3155,6708),
+(2,71,3330,5744,9291,3231,7007),
+(2,72,3422,5903,9610,3309,7305),
+(2,73,3519,6070,9940,3387,7604),
+(2,74,3619,1,10282,3466,7903),
+(2,75,3722,6420,10635,3561,8204),
+(2,76,3825,1,11001,3643,8503),
+(2,77,3933,1,11379,3725,8803),
+(2,78,4042,1,11770,3809,9104),
+(2,79,4155,1,12175,3893,9405),
+(2,80,4274,1,12600,3994,9706),
+(2,81,4394,1,13033,4081,10007),
+(2,82,4518,1,13481,4169,10253),
+(2,83,4646,1,13945,4258,10573),
+(2,84,1,1,1,1,1),
+(2,85,1,1,1,1,1),
+(2,86,1,1,1,1,1),
+(2,87,1,1,1,1,1),
+(2,88,1,1,1,1,1),
+(2,89,1,1,1,1,1),
+(2,90,1,1,1,1,1),
+(2,91,1,1,1,1,1),
+(2,92,1,1,1,1,1),
+(2,93,1,1,1,1,1),
+(2,94,1,1,1,1,1),
+(2,95,1,1,1,1,1),
+(2,96,1,1,1,1,1),
+(2,97,1,1,1,1,1),
+(2,98,1,1,1,1,1),
+(2,99,1,1,1,1,1),
+(2,100,1,1,1,1,1),
+(4,1,42,1,1,0,6),
+(4,2,55,1,1,0,18),
+(4,3,71,1,1,0,31),
+(4,4,86,1,1,0,63),
+(4,5,102,1,1,0,102),
+(4,6,120,1,1,0,152),
+(4,7,137,1,1,0,212),
+(4,8,156,1,1,0,286),
+(4,9,176,1,1,0,363),
+(4,10,198,1,1,0,443),
+(4,11,222,1,1,0,488),
+(4,12,247,1,1,0,519),
+(4,13,273,1,1,0,553),
+(4,14,300,1,1,0,577),
+(4,15,328,1,1,0,612),
+(4,16,356,1,1,0,645),
+(4,17,386,1,1,0,676),
+(4,18,417,1,1,0,706),
+(4,19,449,1,1,0,738),
+(4,20,484,1,1,0,769),
+(4,21,521,1,1,0,801),
+(4,22,562,1,1,0,833),
+(4,23,605,1,1,0,863),
+(4,24,651,1,1,0,895),
+(4,25,699,1,1,0,926),
+(4,26,750,1,1,0,957),
+(4,27,800,1,1,0,989),
+(4,28,853,1,1,0,1020),
+(4,29,905,1,1,0,1051),
+(4,30,955,1,1,0,1082),
+(4,31,1006,1,1,0,1113),
+(4,32,1057,1,1,0,1146),
+(4,33,1110,1,1,0,1173),
+(4,34,1163,1,1,0,1208),
+(4,35,1220,1,1,0,1237),
+(4,36,1277,1,1,0,1349),
+(4,37,1336,1,1,0,1434),
+(4,38,1395,1,1,0,1538),
+(4,39,1459,1,1,0,1649),
+(4,40,1524,1,1,0,1764),
+(4,41,1585,1,1,0,1886),
+(4,42,1651,1,1,0,2015),
+(4,43,1716,1,1,0,2148),
+(4,44,1782,1,1,0,2303),
+(4,45,1848,1,1,0,2436),
+(4,46,1919,1,1,0,2485),
+(4,47,1990,1,1,0,2535),
+(4,48,2062,1,1,0,2582),
+(4,49,2138,1,1,0,2631),
+(4,50,2215,1,1,0,2680),
+(4,51,2292,1,1,0,2728),
+(4,52,2371,1,1,0,2778),
+(4,53,2453,1,1,0,2826),
+(4,54,2533,1,1,0,2874),
+(4,55,2614,1,1,0,2922),
+(4,56,2699,1,1,0,2972),
+(4,57,2784,1,1,0,3020),
+(4,58,2871,3989,1,0,3068),
+(4,59,2961,4142,1,0,3117),
+(4,60,3052,4979,1,0,3388),
+(4,61,3144,5158,1,0,3655),
+(4,62,3237,5341,1,0,3922),
+(4,63,3331,5527,1,0,4189),
+(4,64,3427,5715,1,0,4457),
+(4,65,3524,5914,1,0,4724),
+(4,66,3624,6116,1,0,5104),
+(4,67,3728,6326,1,0,5326),
+(4,68,3834,6542,6986,0,5527),
+(4,69,3942,6761,7984,0,5795),
+(4,70,4050,6986,8982,0,6062),
+(4,71,4163,7181,9291,0,6332),
+(4,72,4278,7380,9610,0,6602),
+(4,73,4399,7580,9940,0,6872),
+(4,74,4524,1,10282,0,7143),
+(4,75,4652,1,10635,0,7415),
+(4,76,4781,1,11001,0,7686),
+(4,77,4916,1,11379,0,7958),
+(4,78,5052,1,11770,0,8230),
+(4,79,5194,1,12175,0,8503),
+(4,80,5342,1,12600,0,8776),
+(4,81,5496,1,13033,0,9068),
+(4,82,5647,1,13481,0,9348),
+(4,83,5808,1,13945,0,9589),
+(4,84,1,1,1,0,1),
+(4,85,1,1,1,0,1),
+(4,86,1,1,1,0,1),
+(4,87,1,1,1,0,1),
+(4,88,1,1,1,0,1),
+(4,89,1,1,1,0,1),
+(4,90,1,1,1,0,1),
+(4,91,1,1,1,0,1),
+(4,92,1,1,1,0,1),
+(4,93,1,1,1,0,1),
+(4,94,1,1,1,0,1),
+(4,95,1,1,1,0,1),
+(4,96,1,1,1,0,1),
+(4,97,1,1,1,0,1),
+(4,98,1,1,1,0,1),
+(4,99,1,1,1,0,1),
+(4,100,1,1,1,0,1),
+(8,1,40,1,1,120,5),
+(8,2,52,1,1,147,16),
+(8,3,67,1,1,174,28),
+(8,4,81,1,1,202,57),
+(8,5,95,1,1,230,93),
+(8,6,111,1,1,259,139),
+(8,7,126,1,1,289,194),
+(8,8,143,1,1,319,265),
+(8,9,160,1,1,350,339),
+(8,10,178,1,1,382,423),
+(8,11,199,1,1,459,447),
+(8,12,219,1,1,537,475),
+(8,13,241,1,1,601,509),
+(8,14,263,1,1,710,523),
+(8,15,285,1,1,790,559),
+(8,16,307,1,1,856,589),
+(8,17,330,1,1,938,617),
+(8,18,354,1,1,1020,643),
+(8,19,379,1,1,1118,674),
+(8,20,405,1,1,1202,701),
+(8,21,432,1,1,1272,729),
+(8,22,463,1,1,1357,759),
+(8,23,494,1,1,1443,786),
+(8,24,528,1,1,1545,815),
+(8,25,562,1,1,1633,843),
+(8,26,598,1,1,1707,871),
+(8,27,633,1,1,1812,900),
+(8,28,669,1,1,1977,928),
+(8,29,704,1,1,2068,957),
+(8,30,737,1,1,2175,984),
+(8,31,770,1,1,2253,1012),
+(8,32,802,1,1,2362,1042),
+(8,33,835,1,1,2457,1065),
+(8,34,867,1,1,2553,1098),
+(8,35,902,1,1,2680,1124),
+(8,36,935,1,1,2763,1241),
+(8,37,970,1,1,2861,1300),
+(8,38,1004,1,1,2975,1391),
+(8,39,1040,1,1,3075,1489),
+(8,40,1077,1,1,3191,1590),
+(8,41,1110,1,1,3293,1697),
+(8,42,1156,1,1,3471,1811),
+(8,43,1201,1,1,3575,1926),
+(8,44,1247,1,1,3680,2078),
+(8,45,1294,1,1,3801,2177),
+(8,46,1343,1,1,3923,2220),
+(8,47,1393,1,1,4031,2265),
+(8,48,1443,1,1,4140,2307),
+(8,49,1497,1,1,4281,2349),
+(8,50,1551,1,1,4393,2393),
+(8,51,1604,1,1,4506,2437),
+(8,52,1660,1,1,4650,2481),
+(8,53,1717,1,1,4765,2524),
+(8,54,1773,1,1,4896,2567),
+(8,55,1830,1,1,5013,2609),
+(8,56,1889,1,1,5206,2654),
+(8,57,1949,1,1,5340,2698),
+(8,58,2010,2793,1,5461,2740),
+(8,59,2073,2899,1,5598,2784),
+(8,60,2136,3484,1,5751,3025),
+(8,61,2201,3611,1,5875,3263),
+(8,62,2266,3739,1,6015,3500),
+(8,63,2332,3870,1,6156,3736),
+(8,64,2399,4000,1,6229,3977),
+(8,65,2467,4140,4731,6443,4214),
+(8,66,2552,4281,4892,6588,4460),
+(8,67,2610,4429,1,6749,4710),
+(8,68,2684,4580,5588,6882,4928),
+(8,69,2759,4733,6387,7031,5167),
+(8,70,2835,4890,7185,7196,5404),
+(8,71,2914,5027,7432,7332,5645),
+(8,72,2995,5166,7688,7500,5886),
+(8,73,3098,5311,7952,7654,6126),
+(8,74,3186,1,8225,7809,6368),
+(8,75,3256,5617,8508,7981,6610),
+(8,76,3367,1,8800,8139,6851),
+(8,77,3462,1,9103,8313,7094),
+(8,78,3558,1,9416,8459,7335),
+(8,79,3658,1,9740,8636,7579),
+(8,80,3739,1,10080,8814,7822),
+(8,81,3870,1,10486,8979,8102),
+(8,82,3977,1,10784,9160,8340),
+(8,83,4090,1,11156,9325,8505),
+(8,84,1,1,1,1,1),
+(8,85,1,1,1,1,1),
+(8,86,1,1,1,1,1),
+(8,87,1,1,1,1,1),
+(8,88,1,1,1,1,1),
+(8,89,1,1,1,1,1),
+(8,90,1,1,1,1,1),
+(8,91,1,1,1,1,1),
+(8,92,1,1,1,1,1),
+(8,93,1,1,1,1,1),
+(8,94,1,1,1,1,1),
+(8,95,1,1,1,1,1),
+(8,96,1,1,1,1,1),
+(8,97,1,1,1,1,1),
+(8,98,1,1,1,1,1),
+(8,99,1,1,1,1,1),
+(8,100,1,1,1,1,1);
+/*!40000 ALTER TABLE `creature_classlevelstats` ENABLE KEYS */;
+UNLOCK TABLES;
 
 --
 -- Table structure for table `creature_equip_template`
@@ -1608,7 +1562,6 @@ CREATE TABLE `creature_template` (
   `minlevel` tinyint(3) unsigned NOT NULL DEFAULT '1',
   `maxlevel` tinyint(3) unsigned NOT NULL DEFAULT '1',
   `exp` smallint(2) NOT NULL DEFAULT '0',
-  `armor` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `faction_A` smallint(5) unsigned NOT NULL DEFAULT '0',
   `faction_H` smallint(5) unsigned NOT NULL DEFAULT '0',
   `npcflag` int(10) unsigned NOT NULL DEFAULT '0',
@@ -1659,8 +1612,9 @@ CREATE TABLE `creature_template` (
   `AIName` char(64) NOT NULL DEFAULT '',
   `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3',
-  `unk16` float NOT NULL DEFAULT '1',
-  `unk17` float NOT NULL DEFAULT '1',
+  `Health_mod` float NOT NULL DEFAULT '1',
+  `Mana_mod` float NOT NULL DEFAULT '1',
+  `Armor_mod` float NOT NULL DEFAULT '1',
   `RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `questItem1` int(11) unsigned NOT NULL DEFAULT '0',
   `questItem2` int(11) unsigned NOT NULL DEFAULT '0',
@@ -2786,10 +2740,10 @@ CREATE TABLE `item_template` (
   `name` varchar(255) NOT NULL DEFAULT '',
   `displayid` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `Flags` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(10) signed NOT NULL DEFAULT '0',
   `Faction` int(11) unsigned NOT NULL DEFAULT '0',
   `BuyCount` tinyint(3) unsigned NOT NULL DEFAULT '1',
-  `BuyPrice` int(10) unsigned NOT NULL DEFAULT '0',
+  `BuyPrice` int(10) signed NOT NULL DEFAULT '0',
   `SellPrice` int(10) unsigned NOT NULL DEFAULT '0',
   `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `AllowableClass` int(11) NOT NULL,
@@ -2803,8 +2757,8 @@ CREATE TABLE `item_template` (
   `RequiredCityRank` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RequiredReputationFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RequiredReputationRank` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `maxcount` smallint(5) NOT NULL DEFAULT '-1',
-  `stackable` int(11) DEFAULT NULL,
+  `maxcount` int(11) signed NOT NULL DEFAULT '-1',
+  `stackable` int(11) signed NOT NULL DEFAULT '1',
   `ContainerSlots` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `StatsCount` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `stat_type1` tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -2845,35 +2799,35 @@ CREATE TABLE `item_template` (
   `delay` smallint(5) unsigned NOT NULL DEFAULT '1000',
   `ammo_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `RangedModRange` float NOT NULL DEFAULT '0',
-  `spellid_1` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `spellid_1` mediumint(8) signed NOT NULL DEFAULT '0',
   `spelltrigger_1` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `spellcharges_1` tinyint(4) NOT NULL DEFAULT '0',
   `spellppmRate_1` float NOT NULL DEFAULT '0',
   `spellcooldown_1` int(11) NOT NULL DEFAULT '-1',
   `spellcategory_1` smallint(5) unsigned NOT NULL DEFAULT '0',
   `spellcategorycooldown_1` int(11) NOT NULL DEFAULT '-1',
-  `spellid_2` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `spellid_2` mediumint(8) signed NOT NULL DEFAULT '0',
   `spelltrigger_2` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `spellcharges_2` tinyint(4) NOT NULL DEFAULT '0',
   `spellppmRate_2` float NOT NULL DEFAULT '0',
   `spellcooldown_2` int(11) NOT NULL DEFAULT '-1',
   `spellcategory_2` smallint(5) unsigned NOT NULL DEFAULT '0',
   `spellcategorycooldown_2` int(11) NOT NULL DEFAULT '-1',
-  `spellid_3` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `spellid_3` mediumint(8) signed NOT NULL DEFAULT '0',
   `spelltrigger_3` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `spellcharges_3` tinyint(4) NOT NULL DEFAULT '0',
   `spellppmRate_3` float NOT NULL DEFAULT '0',
   `spellcooldown_3` int(11) NOT NULL DEFAULT '-1',
   `spellcategory_3` smallint(5) unsigned NOT NULL DEFAULT '0',
   `spellcategorycooldown_3` int(11) NOT NULL DEFAULT '-1',
-  `spellid_4` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `spellid_4` mediumint(8) signed NOT NULL DEFAULT '0',
   `spelltrigger_4` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `spellcharges_4` tinyint(4) NOT NULL DEFAULT '0',
   `spellppmRate_4` float NOT NULL DEFAULT '0',
   `spellcooldown_4` int(11) NOT NULL DEFAULT '-1',
   `spellcategory_4` smallint(5) unsigned NOT NULL DEFAULT '0',
   `spellcategorycooldown_4` int(11) NOT NULL DEFAULT '-1',
-  `spellid_5` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `spellid_5` mediumint(8) signed NOT NULL DEFAULT '0',
   `spelltrigger_5` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `spellcharges_5` tinyint(4) NOT NULL DEFAULT '0',
   `spellppmRate_5` float NOT NULL DEFAULT '0',
@@ -2889,7 +2843,7 @@ CREATE TABLE `item_template` (
   `lockid` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `Material` tinyint(4) NOT NULL DEFAULT '0',
   `sheath` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `RandomProperty` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `RandomProperty` mediumint(8) signed NOT NULL DEFAULT '0',
   `RandomSuffix` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `block` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `itemset` mediumint(8) unsigned NOT NULL DEFAULT '0',