From b293abf7dfa63423f1848e8686aab9f15b2b45d8 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Sat, 3 Oct 2015 02:41:51 +0200
Subject: DB/Creature: Spirit of Olum

Move the script to the DB
Fix conditions for the teleportation
Add the missing teleportation to the Chamber of Command
Fix gossip text

(cherry picked from commit 774ea0b4bd1e0d469cfce8013f2e557f030c7c97)
---
 .../world/2015_10_16_00_world_2015_10_03_02.sql    | 26 ++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 sql/updates/world/2015_10_16_00_world_2015_10_03_02.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/2015_10_16_00_world_2015_10_03_02.sql b/sql/updates/world/2015_10_16_00_world_2015_10_03_02.sql
new file mode 100644
index 00000000000..28a9dcc0a82
--- /dev/null
+++ b/sql/updates/world/2015_10_16_00_world_2015_10_03_02.sql
@@ -0,0 +1,26 @@
+-- 
+DELETE FROM `gossip_menu` WHERE `entry`=8750 AND `text_id`=11082;
+INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES (8750, 11082);
+
+DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (8750) AND `id`=2;
+INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`, `OptionBroadcastTextID`, `option_id`,`npc_option_npcflag`,`action_menu_id`) VALUES
+(8750,2,0,"I'm ready. Take me to the Chamber of Command.",21879,1,1,0); 
+
+DELETE FROM `spell_target_position` WHERE `id`=41570;
+INSERT INTO `spell_target_position` (`ID`,`MapID`,`PositionX`,`PositionY`,`PositionZ`) VALUES
+(41570, 564, 603.42, 305.982, 271.9);
+
+UPDATE `creature_template` SET `ScriptName`='', `AIName`='SmartAI' WHERE `entry`=23411;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23411) AND `source_type`=0;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(23411,0,0,1,62,0,100,0,8750,1,0,0,85,41566,0,0,0,0,0,7,0,0,0,0,0,0,0,"Spirit of Olum - On gossip select - cast spell"),
+(23411,0,1,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Spirit of Olum - On gossip select - Close gossip"),
+(23411,0,2,3,62,0,100,0,8750,2,0,0,85,41570,0,0,0,0,0,7,0,0,0,0,0,0,0,"Spirit of Olum - On gossip select - cast spell"),
+(23411,0,3,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,"Spirit of Olum - On gossip select - Close gossip");
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (14,15) AND `SourceGroup`=8750;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(15, 8750, 1, 0, 0, 13, 1, 1, 3, 2, 0, 0, 0, '', 'Show options for gossip only if SUPREMUS done'),
+(15, 8750, 2, 0, 0, 13, 1, 7, 3, 2, 0, 0, 0, '', 'Show options for gossip only if COUNCIL done'),
+(14, 8750, 11082, 0, 0, 13, 1, 1, 3, 2, 1, 0, 0, '', 'Show gossip text only if SUPREMUS not done'),
+(14, 8750, 11081, 0, 0, 13, 1, 1, 3, 2, 0, 0, 0, '', 'Show gossip text only if SUPREMUS done');
-- 
cgit v1.2.3