TrinityCore/TrinityCore — Issue #4424: [SQL patch] Bladestorm isn't removed when Hand of Protection buff is given.
Author: Kabekiz
Created: 2011-12-21 05:02:26+00:00
State: open

What happens:

When Hand of protection (http://www.wowwiki.com/Hand_of_Protection) is cast on a warrior mid-bladestorm(http://www.wowwiki.com/Bladestorm) they continue to bladestorm even though immune to all effects / disarment.

What should happen:
When Hand of protection is cast bladestorm should be stopped.

Fix:

```MySQL
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (1022, -46924, 1, 'Hand of protection (Rank1) - remove bladestorm');
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (5599, -46924, 1, 'Hand of protection (Rank2) - remove bladestorm');
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (10278, -46924, 1, 'Hand of protection (Rank3) - remove bladestorm');
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (66009, -46924, 1, 'Hand of protection (rank1 dupe) - remove bladestorm');
```