From 43910434c5eb2240dc4b4585ccbb5f95fa399d53 Mon Sep 17 00:00:00 2001 From: megamage Date: Thu, 6 Nov 2008 10:27:58 -0600 Subject: [svn] Rewrite canSeeOrDetect function. Minor change on trigger creatures. Remove some unused hacks in scripts. --HG-- branch : trunk --- sql/updates/146_world.sql | 2 -- sql/updates/163_world.sql | 12 ++++++++++-- 2 files changed, 10 insertions(+), 4 deletions(-) (limited to 'sql') diff --git a/sql/updates/146_world.sql b/sql/updates/146_world.sql index 9bfdb2f9be3..5685d9e3fc2 100644 --- a/sql/updates/146_world.sql +++ b/sql/updates/146_world.sql @@ -1,5 +1,3 @@ -update creature_template set spell1 = 40836, flags_extra = 128, scriptname = '' where entry = 23336; - DROP TABLE IF EXISTS `spell_linked_spell`; CREATE TABLE `spell_linked_spell` ( `spell_trigger` int(10) NOT NULL, diff --git a/sql/updates/163_world.sql b/sql/updates/163_world.sql index 00c33703363..37c1b838f7b 100644 --- a/sql/updates/163_world.sql +++ b/sql/updates/163_world.sql @@ -1,7 +1,15 @@ -DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (39992, 39835, 42052, -41914, 41126); +DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (39992, 39835, 42052, -41914, 41126, 41376); -- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39992, 39835, 1, 'Needle Spine'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39835, 39968, 1, 'Needle Spine'); +INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41376, 41377, 0, 'Spite'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41914, 41915, 0, 'Summon Parasitic Shadowfiend'); INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (41126, 41131, 1, 'Flame Crash'); -UPDATE creature_template SET flags_extra = 128, speed = 1.0 WHERE entry = 23095; \ No newline at end of file +-- molten_flame +UPDATE creature_template SET flags_extra = 128, speed = 1.0 WHERE entry = 23095; +-- volcano +UPDATE creature_template SET spell1 = 40117, flags_extra = 128, scriptname = '' WHERE entry = 23085; +-- flame crash +update creature_template set spell1 = 40836, flags_extra = 128, scriptname = '' where entry = 23336; +-- blaze +update creature_template set spell1 = 40610, flags_extra = 128, scriptname = '' where entry = 23259; \ No newline at end of file -- cgit v1.2.3