diff options
| author | QAston <none@none> | 2009-08-04 19:28:31 +0200 |
|---|---|---|
| committer | QAston <none@none> | 2009-08-04 19:28:31 +0200 |
| commit | d95e9c1027380f93b045e2fdea400256a0214860 (patch) | |
| tree | 022925343ff003663ff2e93185ce877e9dca007e /sql | |
| parent | 1d7375c545e881a12d12f633e0387695b327c432 (diff) | |
*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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/FULL/world_spell_full.sql | 13 | ||||
| -rw-r--r-- | sql/updates/4753_world.sql | 5 |
2 files changed, 13 insertions, 5 deletions
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); |