diff options
| -rw-r--r-- | sql/mangos.sql | 17 | ||||
| -rw-r--r-- | sql/updates/8247_01_mangos_spell_bonus_data.sql.tbd | 18 |
2 files changed, 34 insertions, 1 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index 5453a09ba83..bd2e0838d65 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_8237_01_mangos_creature_template` bit(1) default NULL + `required_8247_01_mangos_spell_bonus_data` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -17695,6 +17695,21 @@ CREATE TABLE `spell_bonus_data` ( LOCK TABLES `spell_bonus_data` WRITE; /*!40000 ALTER TABLE `spell_bonus_data` DISABLE KEYS */; INSERT INTO `spell_bonus_data` VALUES +('49941', '0', '0', '0.04', 'Death Knight - Blood Boil'), +('55078', '0', '0', '0.055', 'Death Knight - Blood Plague Dummy Proc'), +('50444', '0', '0', '0.105', 'Death Knight - Corpse Explosion Triggered'), +('52212', '0', '0', '0.0475', 'Death Knight - Death and Decay Triggered'), +('47632', '0', '0', '0.15', 'Death Knight - Death Coil Damage'), +('47633', '0', '0', '0.15', 'Death Knight - Death Coil Heal'), +('55095', '0', '0', '0.055', 'Death Knight - Frost Fever'), +('49184', '0', '0', '0.1', 'Death Knight - Howling Blast'), +('45477', '0', '0', '0.1', 'Death Knight - Icy Touch'), +('50842', '0', '0', '0.04', 'Death Knight - Pestilence'), +('47476', '0', '0', '0.06', 'Death Knight - Strangulate'), +('50536', '0', '0', '0.013', 'Death Knight - Unholy Blight Triggered'), +('50401', '0', '0', '0', 'Death Knight - Razor Frost'), +('56903', '0', '0', '0', 'Death Knight - Lichflame'), + ('5185', '1.6104', '0', '0', 'Druid - Healing Touch'), ('33763', '0', '0.09518', '0', 'Druid - Lifebloom'), ('774', '0', '0.37604', '0', 'Druid - Rejuvenation'), diff --git a/sql/updates/8247_01_mangos_spell_bonus_data.sql.tbd b/sql/updates/8247_01_mangos_spell_bonus_data.sql.tbd new file mode 100644 index 00000000000..9af02b45d51 --- /dev/null +++ b/sql/updates/8247_01_mangos_spell_bonus_data.sql.tbd @@ -0,0 +1,18 @@ +ALTER TABLE db_version CHANGE COLUMN required_8237_01_mangos_creature_template required_8247_01_mangos_spell_bonus_data bit; + +DELETE FROM `spell_bonus_data` where entry in (49941, 55078, 50444, 52212, 47632, 47633, 55095, 49184, 45477, 45477, 50842, 47476, 50536, 50401, 56903); +INSERT INTO `spell_bonus_data`(`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES +(49941, 0, 0, 0.04, "Death Knight - Blood Boil"), +(55078, 0, 0, 0.055, "Death Knight - Blood Plague Dummy Proc"), +(50444, 0, 0, 0.105, "Death Knight - Corpse Explosion Triggered"), +(52212, 0, 0, 0.0475, "Death Knight - Death and Decay Triggered"), +(47632, 0, 0, 0.15, "Death Knight - Death Coil Damage"), +(47633, 0, 0, 0.15, "Death Knight - Death Coil Heal"), +(55095, 0, 0, 0.055, "Death Knight - Frost Fever"), +(49184, 0, 0, 0.1, "Death Knight - Howling Blast"), +(45477, 0, 0, 0.1, "Death Knight - Icy Touch"), +(50842, 0, 0, 0.04, "Death Knight - Pestilence"), +(47476, 0, 0, 0.06, "Death Knight - Strangulate"), +(50536, 0, 0, 0.013, "Death Knight - Unholy Blight Triggered"), +(50401, 0, 0, 0, "Death Knight - Razor Frost"), +(56903, 0, 0, 0, "Death Knight - Lichflame"); |