From d7df4cfa099286310639915d70aea0b9cd7183a2 Mon Sep 17 00:00:00 2001
From: QAston <none@none>
Date: Wed, 5 Aug 2009 17:00:01 +0200
Subject: *Fix Coyote Spirit Despawn Aura (52172) and Blood Parrot Despawn Aura
 (60244) - inspired by Disassembler's patch.

--HG--
branch : trunk
---
 sql/FULL/world_spell_full.sql | 4 +++-
 sql/updates/4761_world.sql    | 4 ++++
 2 files changed, 7 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/4761_world.sql

(limited to 'sql')

diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index e87f213da92..27c8b8e3d10 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -144,10 +144,12 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm
 -- TARGET
 -- --------
 
-DELETE FROM `spell_script_target` WHERE `entry` IN (58836, 50524, 50515);
+DELETE FROM `spell_script_target` WHERE `entry` IN (58836, 50524, 50515, 52173, 60243);
 INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
 (58836, 3, 31216), -- Mirror Image
 (50524, 3, 27829), -- Runic Power Feed
+(52173, 3, 28267), -- Coyote Spirit Despawn
+(60243, 3, 11236), -- Blood Parrot Despawn
 (50515, 3, 27829); -- Dismiss Gargoyle
 
 -- zulaman
diff --git a/sql/updates/4761_world.sql b/sql/updates/4761_world.sql
new file mode 100644
index 00000000000..40adb87ea6c
--- /dev/null
+++ b/sql/updates/4761_world.sql
@@ -0,0 +1,4 @@
+DELETE FROM `spell_script_target` WHERE `entry` IN (52173, 60243);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(52173, 3, 28267),
+(60243, 3, 11236);
\ No newline at end of file
-- 
cgit v1.2.3