From c04b03cae982d5983163838eb75f2b9d9da34e35 Mon Sep 17 00:00:00 2001
From: teacher <none@none>
Date: Tue, 6 Jul 2010 13:46:39 +0200
Subject: Fix to make the Argent Defender trigger the visuals (by amki).

--HG--
branch : trunk
---
 sql/base/world_database.sql                   | 1 +
 sql/updates/8836_world_spell_linked_spell.sql | 3 +++
 2 files changed, 4 insertions(+)
 create mode 100644 sql/updates/8836_world_spell_linked_spell.sql

(limited to 'sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 8f31a38123e..6bd4a008a8a 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -6104,6 +6104,7 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment
 ( 19263, 67801, 2, 'Deterrence'),
 ( 45524, 55095, 0, 'Chains of Ice - Frost Fever'),
 ( 20066,-61840, 0, 'Repentance'),
+( 66235, 66233, 0, 'Ardent Defender Visuals'),
 -- Quest
 ( 40214, 40216, 2, 'Dragonmaw Illusion'),
 ( 40214, 42016, 2, 'Dragonmaw Illusion'),
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');
-- 
cgit v1.2.3