From 61162312231f1722cbb3f1464704bfa74ed30369 Mon Sep 17 00:00:00 2001 From: megamage Date: Thu, 30 Jul 2009 11:15:04 +0800 Subject: [8247] Some data for `spell_bonus_data` for DK spells. Author: nos4r2zod I found TC seems to have these data. In the future *.tbd is used for review. Please do not apply them. --HG-- branch : trunk --- sql/updates/8247_01_mangos_spell_bonus_data.sql.tbd | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/8247_01_mangos_spell_bonus_data.sql.tbd (limited to 'sql/updates') 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"); -- cgit v1.2.3