aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/146_world.sql20
-rw-r--r--sql/updates/163_world.sql7
2 files changed, 7 insertions, 20 deletions
diff --git a/sql/updates/146_world.sql b/sql/updates/146_world.sql
index adb426336d6..67de357f841 100644
--- a/sql/updates/146_world.sql
+++ b/sql/updates/146_world.sql
@@ -17,26 +17,6 @@ VALUES
INSERT INTO spell_linked_spell
(`spell_trigger`, `spell_effect`, `type`, `comment`)
VALUES
- (42052, 40118, 0, 'Volcanic Geyser Visual');
-
-INSERT INTO spell_linked_spell
- (`spell_trigger`, `spell_effect`, `type`, `comment`)
-VALUES
- (-41914, 41915, 0, 'Summon Parasitic Shadowfiend\r\n');
-
-INSERT INTO spell_linked_spell
- (`spell_trigger`, `spell_effect`, `type`, `comment`)
-VALUES
- (46021, 44852, 1, 'Spectral Realm Aura');
-
-INSERT INTO spell_linked_spell
- (`spell_trigger`, `spell_effect`, `type`, `comment`)
-VALUES
- (-46021, 44867, 0, 'Spectral Exhaustion');
-
-INSERT INTO spell_linked_spell
- (`spell_trigger`, `spell_effect`, `type`, `comment`)
-VALUES
(-30410, 44032, 0, 'Manticron Cube Mind Exhaustion');
INSERT INTO spell_linked_spell
diff --git a/sql/updates/163_world.sql b/sql/updates/163_world.sql
new file mode 100644
index 00000000000..da0b03c9a04
--- /dev/null
+++ b/sql/updates/163_world.sql
@@ -0,0 +1,7 @@
+DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (39992, 39835, 42052, -41914, 41126);
+--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 (-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