[sql fix][8247] Death Knight Spells Receiving Spell Power

[nos4r2zod]

What bug does the patch fix?

- Right now, Death Knights are receiving the default amounts of +spell power to their abilities that are counted as spells. These are the spells that have some portion of AP added to them. The easiest fix is just to add the spell_bonus_data entries; it prevents the abilities from going to the default case in the SpellDamageBonus and they need AP added to the abilities anyways.

For which repository revision was the patch created?

- Tested on 7434

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");

Didn't add bloodworms or summon gargoyle, but these will need dummy auras anyways.

Edit: Source was elitist jerks; just checked and it has the same values as the wiki for the entries that the wiki has.

Edit2: Added runeforging procs from Razorice and Lichbane

[Sephiroth1983]

Delete from

This won't work on all systems, use capital letters like DELETE FROM for the statements

anyway, your source is always the well-known wiki, right?

[Elcidbr]

Much needed fix

[False.Genesis]

bump .

[Graftal]

Sweet, please devs test Thank you

[mokanina]

bumping. tested and works fine

[VladimirMangos]

In [8247]. Thank you