From b191efe8e9f7552e824ae0ef45426d7891dc79f8 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Sat, 31 Dec 2016 09:45:17 +0100
Subject: DB/Waypoints: Klaven Mortwake

Closes #18678
By Rushor
---
 .../world/3.3.5/2016_12_30_13_world_335.sql        | 40 ++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2016_12_30_13_world_335.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2016_12_30_13_world_335.sql b/sql/updates/world/3.3.5/2016_12_30_13_world_335.sql
new file mode 100644
index 00000000000..5f2f38b3c0b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_12_30_13_world_335.sql
@@ -0,0 +1,40 @@
+-- Klaven Mortwake -- http://wotlk.openwow.com/npc=7053
+UPDATE `creature` SET `position_x` = -11124.1, `position_y` = 545.44, `position_z` = 70.4323, `orientation` = 1.72551, `Spawndist` = 0, MovementType = 0 WHERE guid = 66996;
+
+-- Klaven Mortwake SAI 
+SET @ENTRY := 7053;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
+(@ENTRY,0,0,0,64,0,100,0,0,0,0,0,54,20000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Klaven Mortwake - On Gossip Hello - Pause Waypoint"),
+(@ENTRY,0,1,0,25,0,100,0,0,0,0,0,53,0,7053,1,0,0,0,1,0,0,0,0,0,0,0,"Klaven Mortwake - On Reset - Start Waypoint"),
+(@ENTRY,0,2,0,40,0,100,0,1,7053,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Klaven Mortwake - On Waypoint 1 Reached - Run Script");
+
+-- Actionlist SAI
+SET @ENTRY := 705300;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=9;
+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
+(@ENTRY,9,0,0,0,0,100,0,0,0,0,0,54,24000,0,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Pause Waypoint"),
+(@ENTRY,9,1,0,0,0,100,0,1000,1000,0,0,1,0,1000,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Say Line 0"),
+(@ENTRY,9,2,0,0,0,100,0,4000,4000,0,0,1,1,1000,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Say Line 1"),
+(@ENTRY,9,3,0,0,0,100,0,7000,7000,0,0,1,2,1000,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Say Line 2"),
+(@ENTRY,9,4,0,0,0,100,0,2000,2000,0,0,1,3,1000,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Say Line 3"),
+(@ENTRY,9,5,0,0,0,100,0,5000,5000,0,0,1,4,1000,0,0,0,0,1,0,0,0,0,0,0,0,"On Script - Say Line 4");
+
+DELETE FROM `creature_text` WHERE `entry`=7053;
+INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`, `TextRange`) VALUES 
+(7053, 0, 0, '%s wildly flips through the pages of a large tome.', 16, 0, 100, 0, 1000, 0, 3094, 'Klaven Mortwake', 0),
+(7053, 1, 0, 'The sweet irony -- Stormwind forces cut down in defense of their city, only to rise and fight alongside the Brotherhood as instruments of destruction.', 12, 0, 100, 0, 0, 0, 3095, 'Klaven Mortwake', 0),
+(7053, 2, 0, 'And should one die, two shall rise!', 12, 0, 100, 0, 1000, 0, 3093, 'Klaven Mortwake', 0),
+(7053, 3, 0, '%s shuffles through the books.', 16, 0, 100, 0, 1000, 0, 3097, 'Klaven Mortwake', 0),
+(7053, 4, 0, 'Now where did I put the Venture Company formulations?', 12, 0, 100, 0, 1000, 0, 3098, 'Klaven Mortwake', 0);
+
+DELETE FROM `waypoints` WHERE `entry`=7053;
+INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES 
+(7053, 1, -11124.1,545.44,70.4323,  'Klaven Mortwake'),
+(7053, 2, -11128.9,544.692,70.4022, 'Klaven Mortwake'),
+(7053, 3, -11133.4,550.86,70.3957,  'Klaven Mortwake'),
+(7053, 4, -11132.2,539.132,70.3766, 'Klaven Mortwake'),
+(7053, 5, -11133.4,550.86,70.3957,  'Klaven Mortwake'),
+(7053, 6, -11132.2,539.132,70.3766, 'Klaven Mortwake'),
+(7053, 7, -11128.9,544.692,70.4022, 'Klaven Mortwake');
-- 
cgit v1.2.3