diff options
| -rw-r--r-- | sql/updates/world/master/2023_04_08_03_world.sql | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_04_08_03_world.sql b/sql/updates/world/master/2023_04_08_03_world.sql new file mode 100644 index 00000000000..50bc3e5baa1 --- /dev/null +++ b/sql/updates/world/master/2023_04_08_03_world.sql @@ -0,0 +1,40 @@ +SET @CGUID := 850720; + +-- Waypoints for CGUID+88 +SET @PATH := (@CGUID+88+1) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, 986.7795, 1240.28, 14.65292, NULL, 0), +(@PATH, 1, 996.2952, 1241.528, 13.73922, NULL, 0), +(@PATH, 2, 1011.471, 1244.149, 12.70725, NULL, 0), +(@PATH, 3, 1021.972, 1250.288, 12.70725, NULL, 0), +(@PATH, 4, 1011.471, 1244.149, 12.70725, NULL, 0), +(@PATH, 5, 996.2952, 1241.528, 13.73922, NULL, 0), +(@PATH, 6, 986.7795, 1240.28, 14.65292, NULL, 0), +(@PATH, 7, 973.2327, 1239.49, 14.65292, NULL, 0), +(@PATH, 8, 963.9566, 1240.326, 14.86794, NULL, 0), +(@PATH, 9, 973.2327, 1239.49, 14.65292, NULL, 0); + +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+88; +INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`) VALUES +(@CGUID+88, @PATH, 1); + +-- Restore overwritten data +DELETE FROM `waypoint_data` WHERE `id`= 8508080; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(8508080, 1, -4461.39, 1320.19, 116.671, 2.07029, 0, 0, 0, 100, 0), +(8508080, 2, -4461.39, 1320.19, 116.671, 2.07029, 6000, 0, 0, 100, 0), +(8508080, 3, -4437.87, 1320.73, 107.994, 0.026686, 0, 0, 0, 100, 0), +(8508080, 4, -4429.75, 1320.01, 102.811, 0.199472, 0, 0, 0, 100, 0), +(8508080, 5, -4391.8, 1322.44, 87.4861, 1.84096, 6000, 0, 0, 100, 0), +(8508080, 6, -4388.37, 1323.54, 86.0792, 0.160202, 0, 0, 0, 100, 0), +(8508080, 7, -4376.18, 1324.69, 86.2675, 0.113078, 0, 0, 0, 100, 0), +(8508080, 8, -4353.49, 1326.68, 83.7979, 0.081662, 0, 0, 0, 100, 0), +(8508080, 9, -4333.21, 1328.34, 79.46, 1.92342, 0, 0, 0, 100, 0), +(8508080, 10, -4343.59, 1327.15, 79.8803, 3.27431, 0, 0, 0, 100, 0), +(8508080, 11, -4353.99, 1325.67, 83.5299, 3.20755, 0, 0, 0, 100, 0), +(8508080, 12, -4376.35, 1325.08, 86.4001, 3.21933, 0, 0, 0, 100, 0), +(8508080, 13, -4385.88, 1324.13, 85.6785, 3.22966, 0, 0, 0, 100, 0), +(8508080, 14, -4395.42, 1322.08, 88.9694, 1.36434, 6000, 0, 0, 100, 0), +(8508080, 15, -4420.52, 1322.59, 99.8929, 3.11971, 0, 0, 0, 100, 0), +(8508080, 16, -4438.77, 1321.67, 108.814, 3.03331, 0, 0, 0, 100, 0); |