diff options
| -rw-r--r-- | sql/updates/world/2013_05_26_04_world_waypoints.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/2013_05_26_04_world_waypoints.sql b/sql/updates/world/2013_05_26_04_world_waypoints.sql new file mode 100644 index 00000000000..58f1e50bf23 --- /dev/null +++ b/sql/updates/world/2013_05_26_04_world_waypoints.sql @@ -0,0 +1,27 @@ +-- Pathing for Entry 5934 Heartrazor +SET @NPC := 51821; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5183.809,`position_y`=-1170.219,`position_z`=45.11078 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5183.809,-1170.219,45.11078,0,0,0,100,0), +(@PATH,2,-5181.056,-1184.849,45.97993,0,0,0,100,0), +(@PATH,3,-5169.914,-1200.506,47.15270,0,0,0,100,0), +(@PATH,4,-5159.998,-1216.499,48.38121,0,0,0,100,0), +(@PATH,5,-5173.076,-1229.047,49.04836,0,0,0,100,0), +(@PATH,6,-5194.938,-1230.641,48.47133,0,0,0,100,0), +(@PATH,7,-5207.135,-1229.340,47.92607,0,0,0,100,0), +(@PATH,8,-5215.482,-1216.020,46.70019,0,0,0,100,0), +(@PATH,9,-5207.343,-1200.787,46.16835,0,0,0,100,0), +(@PATH,10,-5184.156,-1170.526,45.12170,0,0,0,100,0), +(@PATH,11,-5183.285,-1153.094,44.87883,0,0,0,100,0), +(@PATH,12,-5183.285,-1153.094,44.87883,0,0,0,100,0), +(@PATH,13,-5177.142,-1130.755,43.77563,0,0,0,100,0), +(@PATH,14,-5164.937,-1121.575,43.77023,0,0,0,100,0), +(@PATH,15,-5145.432,-1115.095,43.74949,0,0,0,100,0), +(@PATH,16,-5138.181,-1109.642,44.04351,0,0,0,100,0), +(@PATH,17,-5154.783,-1119.312,43.67305,0,0,0,100,0), +(@PATH,18,-5176.401,-1127.441,43.71729,0,0,0,100,0), +(@PATH,19,-5183.811,-1149.325,44.34430,0,0,0,100,0); |