diff options
| author | Malcrom <malcromdev@gmail.com> | 2013-01-05 20:18:19 -0330 |
|---|---|---|
| committer | Malcrom <malcromdev@gmail.com> | 2013-01-05 20:18:19 -0330 |
| commit | 289ae9a8105770c253b7f40709efe49784ac246f (patch) | |
| tree | b22214564947f36934d6187af18c2ebf3b89b5f1 | |
| parent | ed83397a67106a545d5e6cd6fdfd5c0557515bdd (diff) | |
DB/waypoints: Update Harrison Jones waypoints.
| -rw-r--r-- | sql/updates/world/2013_01_05_00_world_waypoints.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_05_00_world_waypoints.sql b/sql/updates/world/2013_01_05_00_world_waypoints.sql new file mode 100644 index 00000000000..4a2d273c552 --- /dev/null +++ b/sql/updates/world/2013_01_05_00_world_waypoints.sql @@ -0,0 +1,10 @@ +-- Pathing for Harrison Jones Entry: 24358 +SET @NPC := 86177; +SET @PATH := @NPC * 10; +DELETE FROM `waypoint_data` WHERE `id`IN (@PATH,@PATH+1,@PATH+2); +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,131.8243,1644.853,42.0216,0,0,0,100,0), +(@PATH+1,1,121.897,1639.106,42.19081,0,0,0,100,0), +(@PATH+1,2,120.8522,1637.931,42.37172,0,0,0,100,0), +(@PATH+1,3,120.7898,1609.063,43.49005,0,0,0,100,0), +(@PATH+2,1,120.6967,1603.713,43.4503,0,0,0,100,0); |