From d95e9c1027380f93b045e2fdea400256a0214860 Mon Sep 17 00:00:00 2001
From: QAston <none@none>
Date: Tue, 4 Aug 2009 19:28:31 +0200
Subject: *Fix Gargoyle feeding behaviour - original patch by thenecromancer.
 *Add SPELL_TARGET_TYPE_CONTROLLED for spell_script_target table for fast
 search of units(grid search skipped) and to prevent applying effects to not
 owned summons

--HG--
branch : trunk
---
 sql/FULL/world_spell_full.sql | 13 ++++++++-----
 sql/updates/4753_world.sql    |  5 +++++
 2 files changed, 13 insertions(+), 5 deletions(-)
 create mode 100644 sql/updates/4753_world.sql

(limited to 'sql')

diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index 21f94c29f42..e041f9763d4 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -143,9 +143,13 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm
 -- --------
 -- TARGET
 -- --------
--- Mirror Image
-DELETE FROM `spell_script_target` WHERE `entry` IN (58836);
-INSERT INTO `spell_script_target` VALUES (58836, 1, 31216);
+
+DELETE FROM `spell_script_target` WHERE `entry` IN (58836, 50524, 50515);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(58836, 3, 31216), -- Mirror Image
+(50524, 3, 27829), -- Runic Power Feed
+(50515, 3, 27829); -- Dismiss Gargoyle
+
 -- zulaman
 DELETE FROM `spell_script_target` WHERE `entry` IN
 (42577,42471,43734,42631);
@@ -1953,8 +1957,7 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
 (52479, 1, 28822),
 (52576, 1, 28834), -- Electro-magnetic Pulse
 (52576, 1, 28886),
-(53110, 1, 28940), -- Devour Humanoid
-(48743, 1, 26125); -- Death pact
+(53110, 1, 28940); -- Devour Humanoid
 
 -- Eye of Acherus
 DELETE FROM `spell_target_position` WHERE `id`=51852;
diff --git a/sql/updates/4753_world.sql b/sql/updates/4753_world.sql
new file mode 100644
index 00000000000..059a6427b9b
--- /dev/null
+++ b/sql/updates/4753_world.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_script_target` WHERE `entry` IN (58836, 48743, 50524, 50515);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(58836, 3, 31216),
+(50524, 3, 27829),
+(50515, 3, 27829);
-- 
cgit v1.2.3