From 3683de3f8032a05eb584964c044b9f2d3857706e Mon Sep 17 00:00:00 2001
From: click <none@none>
Date: Sat, 1 May 2010 22:17:48 +0200
Subject: Add support for quest 12688 (Engineering a Disaster) - patch by
 supabad Closes issue #982

--HG--
branch : trunk
---
 sql/updates/8062_world_creature_template.sql |  1 +
 sql/updates/8062_world_script_texts.sql      |  9 +++++++++
 sql/updates/8062_world_script_waypoint.sql   | 16 ++++++++++++++++
 3 files changed, 26 insertions(+)
 create mode 100644 sql/updates/8062_world_creature_template.sql
 create mode 100644 sql/updates/8062_world_script_texts.sql
 create mode 100644 sql/updates/8062_world_script_waypoint.sql

(limited to 'sql')

diff --git a/sql/updates/8062_world_creature_template.sql b/sql/updates/8062_world_creature_template.sql
new file mode 100644
index 00000000000..a08d1c10c79
--- /dev/null
+++ b/sql/updates/8062_world_creature_template.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `MovementType` = '2', `ScriptName` = 'npc_engineer_helice' WHERE `creature_template`.`entry` = 28787;
diff --git a/sql/updates/8062_world_script_texts.sql b/sql/updates/8062_world_script_texts.sql
new file mode 100644
index 00000000000..e9c90834a61
--- /dev/null
+++ b/sql/updates/8062_world_script_texts.sql
@@ -0,0 +1,9 @@
+DELETE FROM `script_texts` WHERE `npc_entry`=28787;
+INSERT INTO `script_texts` (`npc_entry`, `entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
+(28787, -1800047, 'Let''s get the hell out of here', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
+(28787, -1800048, 'Listen up, Venture Company goons! Rule #1: Never keep the prisoner near the explosives.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
+(28787, -1800049, 'Or THIS is what you get. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
+(28787, -1800050, 'It''s getting a little hot over here. Shall we move on? ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
+(28787, -1800051, 'Oh, look, it''s another cartload of explosives! Let''s help them dispose of it. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
+(28787, -1800052, 'You really shouldn''t play with this stuff. Someone could get hurt.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
+(28787, -1800053, 'We made it! Thank you for getting me out of that hell hole. Tell Hemet to expect me! ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL);
diff --git a/sql/updates/8062_world_script_waypoint.sql b/sql/updates/8062_world_script_waypoint.sql
new file mode 100644
index 00000000000..3381af774cf
--- /dev/null
+++ b/sql/updates/8062_world_script_waypoint.sql
@@ -0,0 +1,16 @@
+DELETE FROM `script_waypoint` WHERE `entry` =28787;
+INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
+(28787, 0, 5919.43, 5374.88, -98.8816, 5000, '0'),
+(28787, 1, 5919.43, 5374.88, -98.8816, 5000, '0'),
+(28787, 2, 5925.17, 5372.37, -98.8815, 0, '0'),
+(28787, 3, 5928.32, 5377, -99.0266, 0, '0'),
+(28787, 4, 5917.24, 5383.36, -106.31, 0, '0'),
+(28787, 5, 5907.49, 5389.62, -106.31, 0, '0'),
+(28787, 6, 5899.66, 5405.25, -96.5535, 0, '0'),
+(28787, 7, 5890.27, 5395.42, -95.5519, 0, '0'),
+(28787, 8, 5887.57, 5384.4, -95.4326, 5000, '0'),
+(28787, 9, 5878.52, 5384.61, -93.3333, 0, '0'),
+(28787, 10, 5873.17, 5360.43, -98.4124, 0, '0'),
+(28787, 11, 5859.23, 5353.29, -98.8777, 0, '0'),
+(28787, 12, 5841.27, 5334.14, -100.446, 0, '0'),
+(28787, 13, 5819.81, 5300.27, -96.8567, 0, '0');
-- 
cgit v1.2.3