diff options
| author | megamage <none@none> | 2009-07-30 11:02:07 +0800 |
|---|---|---|
| committer | megamage <none@none> | 2009-07-30 11:02:07 +0800 |
| commit | a94cccbf4d900fd3e184239ce981a7dfbb6dc467 (patch) | |
| tree | 6b5b98b3464a6c0ec3eef7484cf3910260239286 /sql | |
| parent | 7f6926dd3b1e2596e9cfa697b72afc7828f4e321 (diff) | |
[8237] Apply attack power multiplier to creature bonus attackpower. Author: Lynx3d
Note: mindmg/maxdmg in creature_template expected including attackpower part in its.
attackpower field only show part of attackpower not affected by AP multiplier.
Thanks also to Seizer for take part in reseach and patch review.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mangos.sql | 2 | ||||
| -rw-r--r-- | sql/updates/4643_world_8237_creature_template.sql | 4 |
2 files changed, 5 insertions, 1 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index 731ff4e7e22..5453a09ba83 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, `creature_ai_version` varchar(120) default NULL, - `required_8227_01_mangos_spell_proc_event` bit(1) default NULL + `required_8237_01_mangos_creature_template` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- diff --git a/sql/updates/4643_world_8237_creature_template.sql b/sql/updates/4643_world_8237_creature_template.sql new file mode 100644 index 00000000000..8a199e4d9b7 --- /dev/null +++ b/sql/updates/4643_world_8237_creature_template.sql @@ -0,0 +1,4 @@ +-- ALTER TABLE db_version CHANGE COLUMN required_8227_01_mangos_spell_proc_event required_8237_01_mangos_creature_template bit; + +UPDATE creature_template + SET mindmg = ROUND(mindmg + attackpower), maxdmg=ROUND(maxdmg+attackpower);
\ No newline at end of file |