diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/8052_world_creature.sql | 3 | ||||
| -rw-r--r-- | sql/updates/8052_world_creature_template.sql | 2 | ||||
| -rw-r--r-- | sql/updates/8052_world_script_texts.sql | 5 | ||||
| -rw-r--r-- | sql/updates/8052_world_script_waypoint.sql | 29 |
4 files changed, 39 insertions, 0 deletions
diff --git a/sql/updates/8052_world_creature.sql b/sql/updates/8052_world_creature.sql new file mode 100644 index 00000000000..0cad6812abf --- /dev/null +++ b/sql/updates/8052_world_creature.sql @@ -0,0 +1,3 @@ +DELETE FROM `creature` WHERE `id`=29434;
+INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
+(29434, 571, 1, 1, 0, 254, 6629.44, -1251.64, 395.942, 5.38386, 25, 0, 0, 9416, 0, 0, 2);
diff --git a/sql/updates/8052_world_creature_template.sql b/sql/updates/8052_world_creature_template.sql new file mode 100644 index 00000000000..7ffb0f4717b --- /dev/null +++ b/sql/updates/8052_world_creature_template.sql @@ -0,0 +1,2 @@ +UPDATE `creature_template` SET `MovementType` = '2', `ScriptName` = 'npc_injured_goblin' WHERE `creature_template`.`entry`=29434;
+
diff --git a/sql/updates/8052_world_script_texts.sql b/sql/updates/8052_world_script_texts.sql new file mode 100644 index 00000000000..879e4218e91 --- /dev/null +++ b/sql/updates/8052_world_script_texts.sql @@ -0,0 +1,5 @@ +DELETE FROM `script_texts` WHERE `npc_entry`= 29434;
+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
+('29434', '-1800042', 'Let me know when you''re ready. I''d prefer sooner than later... what with the slowly dying from poison and all. ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', 'injured goblin SAY_QUEST_START'),
+('29434', '-1800043', 'I''m going to bring the venom sack to Ricket... and then... you know... collapse. Thank you for helping me! ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', 'injured goblin SAY_END_WP_REACHED');
+
diff --git a/sql/updates/8052_world_script_waypoint.sql b/sql/updates/8052_world_script_waypoint.sql new file mode 100644 index 00000000000..3c2d016102c --- /dev/null +++ b/sql/updates/8052_world_script_waypoint.sql @@ -0,0 +1,29 @@ +DELETE FROM `script_waypoint` WHERE `entry` =29434;
+INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES
+(29434, 1, 6645.47, -1263.66, 396.938, 0, 0),
+(29434, 2, 6662.06, -1274.13, 397.319, 0, 0),
+(29434, 3, 6666.29, -1254.59, 396.11, 0, 0),
+(29434, 4, 6669.33, -1240.06, 397.789, 0, 0),
+(29434, 5, 6654.31, -1205.01, 399.823, 0, 0),
+(29434, 6, 6657.03, -1170.15, 398.755, 0, 0),
+(29434, 7, 6667.33, -1146.28, 399.014, 0, 0),
+(29434, 8, 6670.9, -1138.68, 397.125, 0, 0),
+(29434, 9, 6685.09, -1103.95, 396.828, 0, 0),
+(29434, 10, 6688.71, -1094.32, 395.019, 0, 0),
+(29434, 11, 6684.75, -1084.31, 396.916, 0, 0),
+(29434, 12, 6679.3, -1074.4, 404.284, 0, 0),
+(29434, 13, 6691.91, -1051.96, 407.983, 0, 0),
+(29434, 14, 6696.28, -1016.54, 414.823, 0, 0),
+(29434, 15, 6675.32, -1005.06, 414.844, 0, 0),
+(29434, 16, 6661.01, -1007.41, 414.946, 0, 0),
+(29434, 17, 6643.75, -1010.24, 420.508, 0, 0),
+(29434, 18, 6620.76, -1012.59, 424.378, 0, 0),
+(29434, 19, 6610.33, -996.992, 428.116, 0, 0),
+(29434, 20, 6581.3, -1005.9, 434.257, 0, 0),
+(29434, 21, 6570.74, -1013, 434.076, 0, 0),
+(29434, 22, 6551.68, -1012.38, 433.218, 0, 0),
+(29434, 23, 6530.83, -1024.99, 433.04, 0, 0),
+(29434, 24, 6510.05, -1031.23, 435.824, 0, 0),
+(29434, 25, 6491.5, -1032.46, 434.226, 0, 0),
+(29434, 26, 6475.58, -1023.13, 434.759, 0, 0),
+(29434, 27, 6451.81, -1025.43, 431.502, 10000, 0);
\ No newline at end of file |