From 94992adb64544ab6a813f3e244a2e14cf80823f5 Mon Sep 17 00:00:00 2001
From: QAston <none@none>
Date: Sun, 19 Jul 2009 14:02:52 +0200
Subject: *Fix DK presences and their improved versions - original patch by
 thenecromancer *Port player to homebind if instance cannot be created in
 WorldSession::HandleMoveWorldportAckOpcode.

--HG--
branch : trunk
---
 sql/FULL/world_spell_full.sql                 | 3 ---
 sql/updates/4509_world_spell_linked_spell.sql | 1 +
 2 files changed, 1 insertion(+), 3 deletions(-)
 create mode 100644 sql/updates/4509_world_spell_linked_spell.sql

(limited to 'sql')

diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index c7391c34d35..adc11d4dc82 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -33,9 +33,6 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm
 (-49011, 49009, 0, 'Wyvern Sting'),
 (-49012, 49010, 0, 'Wyvern Sting'),
 ( 47585, 60069, 0, 'Dispersion (transform/regen)'),
-( 48265, 49772, 2, 'Unholy Presence'),
-( 49772, 55222, 2, 'Unholy Presence'),
-( 48263, 61261, 2, 'Frost Presence'),
 ( 61847, 61848, 2, 'Aspect of te dragonhawk'),
 ( 61846, 61848, 2, 'Aspect of te dragonhawk'),
 ( 47988, 54501, 2, 'Consume Shadows - Rank 9'),
diff --git a/sql/updates/4509_world_spell_linked_spell.sql b/sql/updates/4509_world_spell_linked_spell.sql
new file mode 100644
index 00000000000..d672b2a564a
--- /dev/null
+++ b/sql/updates/4509_world_spell_linked_spell.sql
@@ -0,0 +1 @@
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (48265, 49772, 48263);
-- 
cgit v1.2.3