DB/Spells: Fix an issue where a player could have both Valkyr Essence auras in TOGC.

Thanks Gildor.
Closes #534.

1 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/world/2011_09_11_04_world_spell_linked_spell.sql b/sql/updates/world/2011_09_11_04_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..120378bd3e2
--- /dev/null
+++ b/sql/updates/world/2011_09_11_04_world_spell_linked_spell.sql
@@ -0,0 +1,10 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger`IN (65686, 65684, 67222, 67176, 67223, 67177, 67224, 67178);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES 
+(65686, -65684, 2, 'Remove Dark Essence 10M'), 
+(65684, -65686, 2, 'Remove Light Essence 10M'),
+(67222, -67176, 2, 'Remove Dark essence 10M H'),
+(67176, -67222, 2, 'Remove Light essence 10M H'),
+(67223, -67177, 2, 'Remove Dark essence 25M'),
+(67177, -67223, 2, 'Remove Light essence 25M'),
+(67224, -67178, 2, 'Remove Dark essence 25M H'),
+(67178, -67224, 2, 'Remove Light essence 25M H');