diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_06_30_00_world_waypoints.sql | 42 |
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); |
