Add support for quest 12688 (Engineering a Disaster) - patch by supabad

Closes issue #982

--HG--
branch : trunk

3 files changed, 26 insertions, 0 deletions

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');