From a5045b76849f095929358248d8b51ed8a4fb89bc Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Mon, 3 Nov 2008 20:44:32 -0600
Subject: [svn] Update black temple boss 1, 2 script.

--HG--
branch : trunk
---
 sql/updates/146_world.sql | 20 --------------------
 sql/updates/163_world.sql |  7 +++++++
 2 files changed, 7 insertions(+), 20 deletions(-)
 create mode 100644 sql/updates/163_world.sql

(limited to 'sql')

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
@@ -14,26 +14,6 @@ INSERT INTO spell_linked_spell
 VALUES
    (44008, 45265, 1, 'Static Disruption Visual');
 
-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
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
-- 
cgit v1.2.3