From f16b93d8d8ded579fbf7b560afa3bb6475816c02 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Wed, 26 Aug 2009 22:56:20 -0500
Subject: *Update flame levi script. Fix the bug that it often gets stuck.

--HG--
branch : trunk
---
 sql/updates/5403_world_scripts_ulduar.sql | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 sql/updates/5403_world_scripts_ulduar.sql

(limited to 'sql/updates')

diff --git a/sql/updates/5403_world_scripts_ulduar.sql b/sql/updates/5403_world_scripts_ulduar.sql
new file mode 100644
index 00000000000..f9fa49f5941
--- /dev/null
+++ b/sql/updates/5403_world_scripts_ulduar.sql
@@ -0,0 +1,18 @@
+INSERT INTO creature_template (entry, vehicleid) VALUES
+(32930, 312), # Kologarn
+(33214, 348) # Mechanolift 304-A
+ON DUPLICATE KEY UPDATE
+vehicleid = VALUES(vehicleid);
+
+UPDATE creature_template SET InhabitType = 4 WHERE entry = 33214;
+
+update creature_template set spell1=62395, AIName = 'TurretAI', scriptname='' where entry = 33139;
+update creature_template set spell1=62402 where entry = 33142;
+update creature_template set ScriptName = 'boss_kologarn' where entry = 32930;
+
+DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (-62475,62427);
+INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
+(-62475,-62399, 0, 'System Shutdown - Overload Circuit'),
+(-62475,-62375, 0, 'System Shutdown - Gathering Speed'),
+(-62475, 62472, 0, 'System Shutdown'), #inform, not correct spell
+( 62427, 62340, 2, 'Load into Catapult - Passenger Loaded');
-- 
cgit v1.2.3