aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2013_06_30_00_world_waypoints.sql42
1 files changed, 42 insertions, 0 deletions
diff --git a/sql/updates/world/2013_06_30_00_world_waypoints.sql b/sql/updates/world/2013_06_30_00_world_waypoints.sql
new file mode 100644
index 00000000000..f2a4c58fcf8
--- /dev/null
+++ b/sql/updates/world/2013_06_30_00_world_waypoints.sql
@@ -0,0 +1,42 @@
+-- Pathing for Lord Victor Nefarius Entry: 10162
+SET @PATH := 1379670;
+DELETE FROM `waypoint_data` WHERE `id` IN (@PATH,@PATH+1,@PATH+2);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,168.7847,-444.8676,121.9753,0,0,0,0,100,0),
+(@PATH,2,159.7806,-444.8137,121.9753,0,0,0,0,100,0),
+(@PATH+1,1,163.1683,-444.165,121.9753,0,0,0,0,100,0),
+(@PATH+1,2,163.2364,-443.4956,121.9753,0,0,0,0,100,0),
+(@PATH+1,3,163.3028,-442.0108,122.2531,1.570796,0,0,0,100,0),
+(@PATH+2,1,165.5801,-457.3273,121.9753,0,0,1,0,100,0),
+(@PATH+2,2,165.5504,-465.8904,116.8073,0,0,1,0,100,0),
+(@PATH+2,3,165.3594,-470.635,116.8296,0,0,1,0,100,0),
+(@PATH+2,4,168.4351,-473.7489,116.8424,0,0,1,0,100,0),
+(@PATH+2,5,179.0059,-473.894,116.8424,0,0,1,0,100,0);
+
+-- Pathing for Warchief Rend Blackhand Entry: 10429
+SET @PATH := 1379680;
+DELETE FROM `waypoint_data` WHERE `id` IN (@PATH);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,165.4778,-452.2761,121.9753,0,0,0,0,100,0),
+(@PATH,2,165.5801,-457.3273,121.9753,0,0,0,0,100,0),
+(@PATH,3,165.5504,-465.8904,116.8073,0,0,0,0,100,0),
+(@PATH,4,165.3594,-470.635,116.8296,0,0,0,0,100,0),
+(@PATH,5,168.4351,-473.7489,116.8424,0,0,0,0,100,0),
+(@PATH,6,179.0059,-473.894,116.8424,0,52000,0,0,100,0),
+(@PATH,7,216.6058,-430.4544,110.9169,0,0,0,0,100,0),
+(@PATH,8,216.5664,-412.0932,110.9822,0,0,0,0,100,0),
+(@PATH,9,217.1734,-401.2561,111.0617,0,0,0,0,100,0),
+(@PATH,10,216.5286,-397.7477,111.0883,0,0,0,0,100,0),
+(@PATH,11,214.8428,-395.8612,111.1051,0,0,0,0,100,0),
+(@PATH,12,213.5363,-395.6153,111.1093,0,0,0,0,100,0);
+
+-- Pathing for Gyth Entry: 10339
+SET @PATH := 1379681;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,211.4939,-399.5368,111.0848,0,0,1,0,100,0),
+(@PATH,2,209.2005,-409.7201,110.9367,0,0,1,0,100,0),
+(@PATH,3,201.0632,-420.6352,110.9231,0,0,1,0,100,0),
+(@PATH,4,178.1997,-420.3415,110.4723,0,0,1,0,100,0),
+(@PATH,5,154.2494,-420.948,110.4723,0,0,1,0,100,0),
+(@PATH,6,127.872,-420.4601,110.4723,0,0,1,0,100,0);