diff options
| author | joschiwald <joschiwald@online.de> | 2014-01-04 18:22:06 +0100 |
|---|---|---|
| committer | joschiwald <joschiwald@online.de> | 2014-01-04 18:22:06 +0100 |
| commit | cd76d3290719161db1c10b4c82de191db1cef7e8 (patch) | |
| tree | 5f2e3c498de123817dda7488dd60a7dade0c36ce /sql/updates/world | |
| parent | ff61e4d79deeae19fe3bcbd3f8ce09b83bf7af4a (diff) | |
Core/Entities: correct creature damage, offhand damage should work too
* todo: some creatures need dmg_multiplier update in creature_template
Diffstat (limited to 'sql/updates/world')
| -rw-r--r-- | sql/updates/world/2014_01_04_00_world_creature_classlevelstats.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2014_01_04_00_world_creature_classlevelstats.sql b/sql/updates/world/2014_01_04_00_world_creature_classlevelstats.sql new file mode 100644 index 00000000000..d55561bbe0e --- /dev/null +++ b/sql/updates/world/2014_01_04_00_world_creature_classlevelstats.sql @@ -0,0 +1,10 @@ +ALTER TABLE `creature_classlevelstats` + CHANGE `level` `level` TINYINT(3) UNSIGNED NOT NULL, + CHANGE `class` `class` TINYINT(3) UNSIGNED NOT NULL, + CHANGE `basehp0` `basehp0` SMALLINT(5) UNSIGNED DEFAULT 1 NOT NULL, + CHANGE `basehp1` `basehp1` SMALLINT(5) UNSIGNED DEFAULT 1 NOT NULL, + CHANGE `basehp2` `basehp2` SMALLINT(5) UNSIGNED DEFAULT 1 NOT NULL, + CHANGE `basemana` `basemana` SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `basearmor` `basearmor` SMALLINT(5) UNSIGNED DEFAULT 1 NOT NULL, + CHANGE `attackpower` `attackpower` SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `rangedattackpower` `rangedattackpower` SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL; |