aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorteacher <none@none>2010-07-06 13:46:39 +0200
committerteacher <none@none>2010-07-06 13:46:39 +0200
commitc04b03cae982d5983163838eb75f2b9d9da34e35 (patch)
tree571a3cc8d6d4eba2ed99dc33b600f7c62fac9173
parent9ba91d50d0b9b86cf0c4a09bf7a0593f0b095d4f (diff)
Fix to make the Argent Defender trigger the visuals (by amki).
--HG-- branch : trunk
-rw-r--r--sql/base/world_database.sql1
-rw-r--r--sql/updates/8836_world_spell_linked_spell.sql3
2 files changed, 4 insertions, 0 deletions
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');