diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/8062_world_creature_template.sql | 1 | ||||
| -rw-r--r-- | sql/updates/8062_world_script_texts.sql | 9 | ||||
| -rw-r--r-- | sql/updates/8062_world_script_waypoint.sql | 16 |
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'); |