DB/Creature: Add waypoints to Mirelow

closes #30672
by CraftedRO

1 files changed, 58 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2025_02_07_01_world.sql b/sql/updates/world/3.3.5/2025_02_07_01_world.sql
new file mode 100644
index 00000000000..135844efac3
--- /dev/null
+++ b/sql/updates/world/3.3.5/2025_02_07_01_world.sql
@@ -0,0 +1,58 @@
+-- Pathing for Mirelow Entry: 14424
+SET @NPC=14424;
+SET @GUID=91113;
+SET @PATH=@GUID * 10;
+DELETE FROM `creature` WHERE `id` = @NPC AND `guid` != (@GUID);
+DELETE FROM `pool_template` WHERE `entry`=@NPC;
+DELETE FROM `pool_members` WHERE `Type`=0 AND `poolSpawnId`=1072;
+UPDATE `creature` SET `position_x`=-2752.9434,`position_y`=-1311.9869,`position_z`=6.144358,`wander_distance`=0,`MovementType`=2 WHERE `id`=@NPC AND `guid`=@GUID;
+UPDATE `creature_template` SET `MovementType`=2,`speed_walk`=1 WHERE `entry`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@GUID;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(@GUID, @PATH, 0, 0, 0, 0, 0, 1, 0, 0, 0, NULL);
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(@PATH, 1, -2752.9434, -1311.9869, 6.144358, NULL, 0, 0, 0, 100, 0),
+(@PATH, 2, -2779.3325, -1318.1886, 6.212498, NULL, 0, 0, 0, 100, 0),
+(@PATH, 3, -2802.5144, -1327.2316, 6.2124987, NULL, 0, 0, 0, 100, 0),
+(@PATH, 4, -2841.5269, -1356.3691, 6.2124963, NULL, 0, 0, 0, 100, 0),
+(@PATH, 5, -2868.5942, -1383.6816, 6.2125034, NULL, 0, 0, 0, 100, 0),
+(@PATH, 6, -2888.584, -1418.0055, 6.2125034, NULL, 0, 0, 0, 100, 0),
+(@PATH, 7, -2915.9563, -1455.4119, 6.2125106, NULL, 0, 0, 0, 100, 0),
+(@PATH, 8, -2948.1558, -1477.9122, 6.2125034, NULL, 0, 0, 0, 100, 0),
+(@PATH, 9, -2979.6265, -1493.0153, 6.2125106, NULL, 0, 0, 0, 100, 0),
+(@PATH, 10, -3007.2742, -1519.1643, 6.1943064, NULL, 0, 0, 0, 100, 0),
+(@PATH, 11, -3030.377, -1531.1482, 1.8713083, NULL, 0, 0, 0, 100, 0),
+(@PATH, 12, -3050.034, -1538.9908, 2.2948234, NULL, 0, 0, 0, 100, 0),
+(@PATH, 13, -3068.111, -1529.2074, 4.6410594, NULL, 0, 0, 0, 100, 0),
+(@PATH, 14, -3048.722, -1507.4395, 2.3030105, NULL, 0, 0, 0, 100, 0),
+(@PATH, 15, -3045.1477, -1488.9481, 6.1078167, NULL, 0, 0, 0, 100, 0),
+(@PATH, 16, -3037.5547, -1465.8003, 6.2125444, NULL, 0, 0, 0, 100, 0),
+(@PATH, 17, -3013.2668, -1444.2893, 6.2125444, NULL, 0, 0, 0, 100, 0),
+(@PATH, 18, -2992.2075, -1423.2106, 6.2125444, NULL, 0, 0, 0, 100, 0),
+(@PATH, 19, -2982.6704, -1384.7448, 6.2125444, NULL, 0, 0, 0, 100, 0),
+(@PATH, 20, -2976.297, -1355.0217, 6.1414337, NULL, 0, 0, 0, 100, 0),
+(@PATH, 21, -2972.429, -1315.0929, 6.212561, NULL, 0, 0, 0, 100, 0),
+(@PATH, 22, -2959.098, -1289.4697, 6.212534, NULL, 0, 0, 0, 100, 0),
+(@PATH, 23, -2946.3533, -1262.2607, 6.212534, NULL, 0, 0, 0, 100, 0),
+(@PATH, 24, -2940.9849, -1235.0204, 6.212534, NULL, 0, 0, 0, 100, 0),
+(@PATH, 25, -2927.3582, -1214.3258, 6.276264, NULL, 0, 0, 0, 100, 0),
+(@PATH, 26, -2913.8328, -1184.8007, 6.2125435, NULL, 0, 0, 0, 100, 0),
+(@PATH, 27, -2913.718, -1156.6484, 6.380024, NULL, 0, 0, 0, 100, 0),
+(@PATH, 28, -2906.6707, -1130.346, 6.3375435, NULL, 0, 0, 0, 100, 0),
+(@PATH, 29, -2924.4268, -1129.007, 6.262104, NULL, 0, 0, 0, 100, 0),
+(@PATH, 30, -2948.263, -1141.3658, 6.581269, NULL, 0, 0, 0, 100, 0),
+(@PATH, 31, -2981.483, -1160.7555, 6.2125306, NULL, 0, 0, 0, 100, 0),
+(@PATH, 32, -3008.991, -1189.4165, 6.3375306, NULL, 0, 0, 0, 100, 0),
+(@PATH, 33, -3033.5713, -1223.1588, 3.6263075, NULL, 0, 0, 0, 100, 0),
+(@PATH, 34, -3058.1658, -1243.8303, 6.385656, NULL, 0, 0, 0, 100, 0),
+(@PATH, 35, -3084.6208, -1262.775, 6.2125497, NULL, 0, 0, 0, 100, 0),
+(@PATH, 36, -3110.9539, -1251.6007, 5.657193, NULL, 0, 0, 0, 100, 0),
+(@PATH, 37, -3127.4268, -1279.7166, 6.2125597, NULL, 0, 0, 0, 100, 0),
+(@PATH, 38, -3140.0647, -1310.3094, 6.2125597, NULL, 0, 0, 0, 100, 0),
+(@PATH, 39, -3129.7153, -1336.1788, 6.2125444, NULL, 0, 0, 0, 100, 0),
+(@PATH, 40, -3135.3235, -1368.5166, 6.2125444, NULL, 0, 0, 0, 100, 0),
+(@PATH, 41, -3156.5852, -1393.152, 6.2125444, NULL, 0, 0, 0, 100, 0),
+(@PATH, 42, -3176.052, -1410.8157, 6.2125344, NULL, 0, 0, 0, 100, 0),
+(@PATH, 43, -3184.6921, -1435.9547, 6.2125344, NULL, 0, 0, 0, 100, 0),
+(@PATH, 44, -3201.1177, -1461.5942, 6.2125344, NULL, 0, 0, 0, 100, 0);