diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/146_world.sql | 2 | ||||
| -rw-r--r-- | sql/updates/163_world.sql | 12 |
2 files changed, 10 insertions, 4 deletions
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 |