DB/Deepholm: Added waypoints for Feldspar the Eternal

+ remove duplicate spawns

1 files changed, 62 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_03_29_01_world.sql b/sql/updates/world/master/2023_03_29_01_world.sql
new file mode 100644
index 00000000000..746d8917ee5
--- /dev/null
+++ b/sql/updates/world/master/2023_03_29_01_world.sql
@@ -0,0 +1,62 @@
+-- Feldspar the Eternal
+SET @CGUID := 350185;
+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`, `move_type`) VALUES
+(@PATH, 0, 1243.53, 263.372, -74.25827, NULL, 0, 1),
+(@PATH, 1, 1220.32, 262.689, -69.61972, NULL, 0, 1),
+(@PATH, 2, 1193.25, 236.24, -69.26616, NULL, 0, 1),
+(@PATH, 3, 1164.77, 210.352, -65.36299, NULL, 0, 1),
+(@PATH, 4, 1125.91, 187.878, -67.1371, NULL, 0, 1),
+(@PATH, 5, 1101.496, 193.25, -65.40419, NULL, 0, 1),
+(@PATH, 6, 1082.47, 212.625, -66.75912, NULL, 0, 1),
+(@PATH, 7, 1050.63, 230.035, -70.10471, NULL, 0, 1),
+(@PATH, 8, 1023.52, 257.398, -69.83702, NULL, 0, 1),
+(@PATH, 9, 1050.63, 230.035, -70.10471, NULL, 0, 1),
+(@PATH, 10, 1082.47, 212.625, -66.75912, NULL, 0, 1),
+(@PATH, 11, 1101.35, 193.278, -65.39589, NULL, 0, 1),
+(@PATH, 12, 1125.91, 187.878, -67.1371, NULL, 0, 1),
+(@PATH, 13, 1164.77, 210.352, -65.36299, NULL, 0, 1),
+(@PATH, 14, 1193.25, 236.24, -69.26616, NULL, 0, 1),
+(@PATH, 15, 1220.32, 262.689, -69.61972, NULL, 0, 1),
+(@PATH, 16, 1243.53, 263.372, -74.25827, NULL, 0, 1),
+(@PATH, 17, 1262.88, 236.476, -67.68735, NULL, 0, 1),
+(@PATH, 18, 1247.95, 197.351, -63.00996, NULL, 0, 1),
+(@PATH, 19, 1214.82, 175.523, -60.87872, NULL, 0, 1),
+(@PATH, 20, 1181.92, 164.278, -63.54764, NULL, 0, 1),
+(@PATH, 21, 1141.95, 150.441, -61.43375, NULL, 0, 1),
+(@PATH, 22, 1114.15, 141.549, -62.078, NULL, 0, 1),
+(@PATH, 23, 1088.51, 146.736, -62.35545, NULL, 0, 1),
+(@PATH, 24, 1064.49, 143.299, -65.41209, NULL, 0, 1),
+(@PATH, 25, 1037.34, 154.333, -63.09934, NULL, 0, 1),
+(@PATH, 26, 1022.32, 168.988, -62.71132, NULL, 0, 1),
+(@PATH, 27, 1006.41, 189.477, -67.32887, NULL, 0, 1),
+(@PATH, 28, 968.264, 212.802, -65.91911, NULL, 0, 1),
+(@PATH, 29, 940.106, 234.611, -69.23222, NULL, 0, 1),
+(@PATH, 30, 924.648, 269.307, -70.11552, NULL, 0, 1),
+(@PATH, 31, 909.826, 299.918, -70.28886, NULL, 0, 1),
+(@PATH, 32, 885.616, 327.104, -71.8467, NULL, 0, 1),
+(@PATH, 33, 909.826, 299.918, -70.28886, NULL, 0, 1),
+(@PATH, 34, 924.648, 269.307, -70.11552, NULL, 0, 1),
+(@PATH, 35, 940.106, 234.611, -69.23222, NULL, 0, 1),
+(@PATH, 36, 968.264, 212.802, -65.91911, NULL, 0, 1),
+(@PATH, 37, 1006.41, 189.477, -67.32887, NULL, 0, 1),
+(@PATH, 38, 1022.32, 168.988, -62.71132, NULL, 0, 1),
+(@PATH, 39, 1037.34, 154.333, -63.09934, NULL, 0, 1),
+(@PATH, 40, 1064.49, 143.299, -65.41209, NULL, 0, 1),
+(@PATH, 41, 1088.51, 146.736, -62.35545, NULL, 0, 1),
+(@PATH, 42, 1114.15, 141.549, -62.078, NULL, 0, 1),
+(@PATH, 43, 1141.95, 150.441, -61.43375, NULL, 0, 1),
+(@PATH, 44, 1181.92, 164.278, -63.54764, NULL, 0, 1),
+(@PATH, 45, 1214.82, 175.523, -60.87872, NULL, 0, 1),
+(@PATH, 46, 1247.95, 197.351, -63.00996, NULL, 0, 1),
+(@PATH, 47, 1262.88, 236.476, -67.68735, NULL, 0, 1);
+
+UPDATE `creature` SET `position_x`= 1243.53, `position_y`= 263.372, `position_z`= -74.25827, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `SheathState`, `visibilityDistanceType`) VALUES
+(@CGUID, @PATH, 1, 3);
+
+-- Delete duplicate spawns
+DELETE FROM `creature` WHERE `guid` IN (354254, 356410);
+DELETE FROM `creature_addon` WHERE `guid` IN (354254, 356410);