diff options
| -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'); |