Fix to make the Argent Defender trigger the visuals (by amki).

--HG--
branch : trunk

1 files changed, 3 insertions, 0 deletions

diff --git a/sql/updates/8836_world_spell_linked_spell.sql b/sql/updates/8836_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..64c3c66c9e1
--- /dev/null
+++ b/sql/updates/8836_world_spell_linked_spell.sql
@@ -0,0 +1,3 @@
+-- Make the Ardent Defender heal (66235) trigger the visuals (66233)
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=66235;
+INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES (66235,66233,0, 'Ardent Defender Visuals');