diff options
| author | Kinzcool <kinzzcool@hotmail.com> | 2015-01-10 18:31:41 -0500 |
|---|---|---|
| committer | Kinzcool <kinzzcool@hotmail.com> | 2015-01-10 18:31:41 -0500 |
| commit | 4d033eaa896db856878b4a39ff0f5082960b201b (patch) | |
| tree | 4b0f5ae1b4bafdd872c2a3dfae252ad5fb3bf872 /sql | |
| parent | 82e5d1889377f95109f560a5fc47e03e99dda03e (diff) | |
Core/Entities: Load creature health points from the Gt DBCs
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2015_01_10_07_world.sql | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/sql/updates/world/2015_01_10_07_world.sql b/sql/updates/world/2015_01_10_07_world.sql new file mode 100644 index 00000000000..d35f31f348c --- /dev/null +++ b/sql/updates/world/2015_01_10_07_world.sql @@ -0,0 +1,30 @@ +ALTER TABLE `creature_classlevelstats` + DROP `basehp0`, + DROP `basehp1`, + DROP `basehp2`, + DROP `basehp3`, + DROP `basehp4`, + DROP `basehp5`; + +DELETE FROM `creature_classlevelstats` WHERE `level` BETWEEN 101 AND 105; +INSERT INTO `creature_classlevelstats` (`level`, `class`, `basemana`, `basearmor`, `attackpower`, `rangedattackpower`, `damage_base`, `damage_exp1`, `damage_exp2`, `damage_exp3`, `damage_exp4`, `damage_exp5`, `comment`) VALUES +(101, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(101, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(101, 4, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(101, 8, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(102, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(102, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(102, 4, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(102, 8, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(103, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(103, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(103, 4, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(103, 8, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(104, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(104, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(104, 4, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(104, 8, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(105, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(105, 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(105, 4, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(105, 8, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''); |