1 | DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (39992, 39835, 42052, -41914, 41126, 41376); |
---|
2 | -- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39992, 39835, 1, 'Needle Spine'); |
---|
3 | INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39835, 39968, 1, 'Needle Spine'); |
---|
4 | INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41376, 41377, 0, 'Spite'); |
---|
5 | INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41914, 41915, 0, 'Summon Parasitic Shadowfiend'); |
---|
6 | INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (41126, 41131, 1, 'Flame Crash'); |
---|
7 | |
---|
8 | -- molten_flame |
---|
9 | UPDATE creature_template SET flags_extra = 128, speed = 1.0 WHERE entry = 23095; |
---|
10 | -- volcano |
---|
11 | UPDATE creature_template SET spell1 = 40117, flags_extra = 128, scriptname = '' WHERE entry = 23085; |
---|
12 | -- flame crash |
---|
13 | update creature_template set spell1 = 40836, flags_extra = 128, scriptname = '' where entry = 23336; |
---|
14 | -- blaze |
---|
15 | update creature_template set spell1 = 40610, flags_extra = 128, scriptname = '' where entry = 23259; |
---|