From 4d3dbe9e9c03f9a02438cf7cd4c6786e43c427f8 Mon Sep 17 00:00:00 2001
From: Greymane <Greymane@trinitycore.contrib>
Date: Sun, 11 Sep 2011 19:38:37 +0100
Subject: DB/Spells: Fix an issue where a player could have both Valkyr Essence
 auras in TOGC.

Thanks Gildor.
Closes #534.
---
 sql/updates/world/2011_09_11_04_world_spell_linked_spell.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 sql/updates/world/2011_09_11_04_world_spell_linked_spell.sql

(limited to 'sql/updates')

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');
-- 
cgit v1.2.3