DB/DarkmoonFaire: Added Waypoints for Silas Darkmoon

1 files changed, 61 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_12_10_02_world.sql b/sql/updates/world/master/2022_12_10_02_world.sql
new file mode 100644
index 00000000000..35f0742fc82
--- /dev/null
+++ b/sql/updates/world/master/2022_12_10_02_world.sql
@@ -0,0 +1,61 @@
+-- Silas Darkmoon
+SET @CGUID := 290772;
+SET @PATH := (@CGUID) * 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, -4039.335, 6289.607, 10.1855, NULL, 0),
+(@PATH, 1, -4052.212, 6301.694, 10.11833, NULL, 0),
+(@PATH, 2, -4063.542, 6312.986, 10.11833, NULL, 0),
+(@PATH, 3, -4080.451, 6328.855, 9.825958, NULL, 0),
+(@PATH, 4, -4096.42, 6336.471, 9.825955, NULL, 0),
+(@PATH, 5, -4116.934, 6347.939, 9.825955, NULL, 0),
+(@PATH, 6, -4138.082, 6351.953, 9.825917, NULL, 0),
+(@PATH, 7, -4164.543, 6353.951, 9.825917, NULL, 0),
+(@PATH, 8, -4187.503, 6351.134, 9.825955, NULL, 0),
+(@PATH, 9, -4218.802, 6346.977, 9.825955, NULL, 0),
+(@PATH, 10, -4247.597, 6341.32, 9.825955, NULL, 0),
+(@PATH, 11, -4264.741, 6343.163, 10.1929, NULL, 0),
+(@PATH, 12, -4282.766, 6344.669, 9.996053, NULL, 0),
+(@PATH, 13, -4300.082, 6346.167, 9.901448, NULL, 0),
+(@PATH, 14, -4315.285, 6345.894, 9.746053, NULL, 0),
+(@PATH, 15, -4330.168, 6344.745, 9.939168, NULL, 0),
+(@PATH, 16, -4347.693, 6343.939, 9.871053, NULL, 0),
+(@PATH, 17, -4364.318, 6340.635, 10.84054, NULL, 0),
+(@PATH, 18, -4378.733, 6336.581, 11.6141, NULL, 0),
+(@PATH, 19, -4364.318, 6340.635, 10.84054, NULL, 0),
+(@PATH, 20, -4347.693, 6343.939, 9.871053, NULL, 0),
+(@PATH, 21, -4330.168, 6344.745, 9.939168, NULL, 0),
+(@PATH, 22, -4315.285, 6345.894, 9.746053, NULL, 0),
+(@PATH, 23, -4300.082, 6346.167, 9.901448, NULL, 0),
+(@PATH, 24, -4282.766, 6344.669, 9.996053, NULL, 0),
+(@PATH, 25, -4264.741, 6343.163, 10.1929, NULL, 0),
+(@PATH, 26, -4247.597, 6341.32, 9.825955, NULL, 0),
+(@PATH, 27, -4218.802, 6346.977, 9.825955, NULL, 0),
+(@PATH, 28, -4187.503, 6351.134, 9.825955, NULL, 0),
+(@PATH, 29, -4164.543, 6353.951, 9.825917, NULL, 0),
+(@PATH, 30, -4138.082, 6351.953, 9.825917, NULL, 0),
+(@PATH, 31, -4116.934, 6347.939, 9.825955, NULL, 0),
+(@PATH, 32, -4096.42, 6336.471, 9.825955, NULL, 0),
+(@PATH, 33, -4080.451, 6328.855, 9.825958, NULL, 0),
+(@PATH, 34, -4063.542, 6312.986, 10.11833, NULL, 0),
+(@PATH, 35, -4052.212, 6301.694, 10.11833, NULL, 0),
+(@PATH, 36, -4039.335, 6289.607, 10.1855, NULL, 0),
+(@PATH, 37, -4029.083, 6276.619, 10.18344, NULL, 0),
+(@PATH, 38, -4017.953, 6266.069, 10.1855, NULL, 0),
+(@PATH, 39, -4002.981, 6253.635, 10.18684, NULL, 0),
+(@PATH, 40, -3991.868, 6243.412, 11.03603, NULL, 0),
+(@PATH, 41, -3983.865, 6235.367, 12.72988, NULL, 0),
+(@PATH, 42, -3991.868, 6243.412, 11.03603, NULL, 0),
+(@PATH, 43, -4002.981, 6253.635, 10.18684, NULL, 0),
+(@PATH, 44, -4017.953, 6266.069, 10.1855, NULL, 0),
+(@PATH, 45, -4029.083, 6276.619, 10.18344, NULL, 0);
+
+UPDATE `creature` SET `position_x`= -4039.335, `position_y`= 6289.607, `position_z`= 10.1855, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes2`) VALUES
+(@CGUID, @PATH, 78112, 1);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 290772;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(290772, 290772, 0, 0, 512, 0, 0),
+(290772, 290771, 5, 0, 512, 0, 0);