DB/Schema: Change basehp/mana/armor in creature_classlevelstatus to unsigned mediumint

There's no reason to be cheap...

2 files changed, 9 insertions, 3 deletions

diff --git a/sql/updates/world/2012_08_06_01_world_classlevelstats.sql b/sql/updates/world/2012_08_06_01_world_classlevelstats.sql
new file mode 100644
index 00000000000..6fe7ad67994
--- /dev/null
+++ b/sql/updates/world/2012_08_06_01_world_classlevelstats.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `creature_classlevelstats` CHANGE `basehp0` `basehp0` mediumint(8) unsigned NOT NULL DEFAULT '1';
+ALTER TABLE `creature_classlevelstats` CHANGE `basehp1` `basehp1` mediumint(8) unsigned NOT NULL DEFAULT '1';
+ALTER TABLE `creature_classlevelstats` CHANGE `basehp2` `basehp2` mediumint(8) unsigned NOT NULL DEFAULT '1';
+ALTER TABLE `creature_classlevelstats` CHANGE `basehp3` `basehp3` mediumint(8) unsigned NOT NULL DEFAULT '1';
+ALTER TABLE `creature_classlevelstats` CHANGE `basemana` `basemana` mediumint(8) unsigned NOT NULL DEFAULT '1';
+ALTER TABLE `creature_classlevelstats` CHANGE `basearmor` `basearmor` mediumint(8) unsigned NOT NULL DEFAULT '1';
diff --git a/src/server/game/Globals/ObjectMgr.cpp b/src/server/game/Globals/ObjectMgr.cpp
index 2bb0b509e93..24e307482ff 100755
--- a/src/server/game/Globals/ObjectMgr.cpp
+++ b/src/server/game/Globals/ObjectMgr.cpp
@@ -8509,10 +8509,10 @@ void ObjectMgr::LoadCreatureClassLevelStats()
         CreatureBaseStats stats;
 
         for (uint8 i = 0; i < MAX_CREATURE_BASE_HP; ++i)
-            stats.BaseHealth[i] = fields[i + 2].GetInt16();
+            stats.BaseHealth[i] = fields[i + 2].GetUInt32();
 
-        stats.BaseMana = fields[5].GetInt16();
-        stats.BaseArmor = fields[6].GetInt16();
+        stats.BaseMana = fields[5].GetUInt32();
+        stats.BaseArmor = fields[6].GetUInt32();
 
         if (!Class || ((1 << (Class - 1)) & CLASSMASK_ALL_CREATURES) == 0)
             sLog->outErrorDb("Creature base stats for level %u has invalid class %u", Level, Class);