diff options
author | teacher <none@none> | 2010-07-06 13:46:39 +0200 |
---|---|---|
committer | teacher <none@none> | 2010-07-06 13:46:39 +0200 |
commit | c04b03cae982d5983163838eb75f2b9d9da34e35 (patch) | |
tree | 571a3cc8d6d4eba2ed99dc33b600f7c62fac9173 | |
parent | 9ba91d50d0b9b86cf0c4a09bf7a0593f0b095d4f (diff) |
Fix to make the Argent Defender trigger the visuals (by amki).
--HG--
branch : trunk
-rw-r--r-- | sql/base/world_database.sql | 1 | ||||
-rw-r--r-- | sql/updates/8836_world_spell_linked_spell.sql | 3 |
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'); |