diff options
| -rw-r--r-- | sql/updates/world/2013_11_10_04_world_waypoints.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/world/2013_11_10_04_world_waypoints.sql b/sql/updates/world/2013_11_10_04_world_waypoints.sql new file mode 100644 index 00000000000..c854c01ebdf --- /dev/null +++ b/sql/updates/world/2013_11_10_04_world_waypoints.sql @@ -0,0 +1,23 @@ +-- Pathing for Mennu the Betrayer Entry: 17941 +SET @NPC := 79362; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=89.26869,`position_y`=-380.2368,`position_z`=15.0899 WHERE `guid`=@NPC; +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,89.26869,-380.2368,15.0899,0,0,0,0,100,0), +(@PATH,2,121.6363,-380.3765,29.95734,0,1000,0,0,100,0), +(@PATH,3,89.42728,-380.2369,15.12144,0,0,0,0,100,0), +(@PATH,4,49.4763,-380.2191,3.035575,0,0,0,0,100,0); + +-- Pathing for Rokmar the Crackler Entry: 17991 +SET @NPC := 79339; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-34.37422,`position_y`=-458.817,`position_z`=-1.952406 WHERE `guid`=@NPC; +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,-34.37422,-458.817,-1.952406,0,1000,0,0,100,0), +(@PATH,2,-62.09498,-454.9725,-1.592298,0,0,0,0,100,0), +(@PATH,3,-13.55803,-454.8065,2.49773,0,0,0,0,100,0), +(@PATH,4,18.32117,-448.4476,3.055895,0,0,0,0,100,0), +(@PATH,5,-13.55803,-454.8065,2.49773,0,0,0,0,100,0), +(@PATH,6,-62.09498,-454.9725,-1.592298,0,0,0,0,100,0); |