DB/Creature: Update Mirelow waypoints

closes #31076
by CraftedRO

1 files changed, 93 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2025_07_28_02_world.sql b/sql/updates/world/3.3.5/2025_07_28_02_world.sql
new file mode 100644
index 00000000000..67762d9b8fa
--- /dev/null
+++ b/sql/updates/world/3.3.5/2025_07_28_02_world.sql
@@ -0,0 +1,93 @@
+-- 
+SET @NPC=14424;
+SET @GUID=91113;
+SET @PATH=@GUID * 10;
+UPDATE `creature` SET `orientation`=3.34791 WHERE `id`=@NPC AND `guid`=@GUID;
+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),
+(@PATH,45,-3184.6921,-1435.9547,6.2125344,NULL,0,0,0,100,0),
+(@PATH,46,-3176.052,-1410.8157,6.2125344,NULL,0,0,0,100,0),
+(@PATH,47,-3156.5852,-1393.152,6.2125444,NULL,0,0,0,100,0),
+(@PATH,48,-3135.3235,-1368.5166,6.2125444,NULL,0,0,0,100,0),
+(@PATH,49,-3129.7153,-1336.1788,6.2125444,NULL,0,0,0,100,0),
+(@PATH,50,-3140.0647,-1310.3094,6.2125597,NULL,0,0,0,100,0),
+(@PATH,51,-3127.4268,-1279.7166,6.2125597,NULL,0,0,0,100,0),
+(@PATH,52,-3110.9539,-1251.6007,5.657193,NULL,0,0,0,100,0),
+(@PATH,53,-3084.6208,-1262.775,6.2125497,NULL,0,0,0,100,0),
+(@PATH,54,-3058.1658,-1243.8303,6.385656,NULL,0,0,0,100,0),
+(@PATH,55,-3033.5713,-1223.1588,3.6263075,NULL,0,0,0,100,0),
+(@PATH,56,-3008.991,-1189.4165,6.3375306,NULL,0,0,0,100,0),
+(@PATH,57,-2981.483,-1160.7555,6.2125306,NULL,0,0,0,100,0),
+(@PATH,58,-2948.263,-1141.3658,6.581269,NULL,0,0,0,100,0),
+(@PATH,59,-2924.4268,-1129.007,6.262104,NULL,0,0,0,100,0),
+(@PATH,60,-2906.6707,-1130.346,6.3375435,NULL,0,0,0,100,0),
+(@PATH,61,-2913.718,-1156.6484,6.380024,NULL,0,0,0,100,0),
+(@PATH,62,-2913.8281,-1184.6484,6.2125435,NULL,0,0,0,100,0),
+(@PATH,63,-2927.3582,-1214.3258,6.276264,NULL,0,0,0,100,0),
+(@PATH,64,-2940.9849,-1235.0204,6.212534,NULL,0,0,0,100,0),
+(@PATH,65,-2946.3533,-1262.2607,6.212534,NULL,0,0,0,100,0),
+(@PATH,66,-2959.098,-1289.4697,6.212534,NULL,0,0,0,100,0),
+(@PATH,67,-2972.429,-1315.0929,6.212561,NULL,0,0,0,100,0),
+(@PATH,68,-2976.297,-1355.0217,6.1414337,NULL,0,0,0,100,0),
+(@PATH,69,-2982.6704,-1384.7448,6.2125444,NULL,0,0,0,100,0),
+(@PATH,70,-2992.2075,-1423.2106,6.2125444,NULL,0,0,0,100,0),
+(@PATH,71,-3013.2668,-1444.2893,6.2125444,NULL,0,0,0,100,0),
+(@PATH,72,-3037.5547,-1465.8003,6.2125444,NULL,0,0,0,100,0),
+(@PATH,73,-3045.1477,-1488.9481,6.1078167,NULL,0,0,0,100,0),
+(@PATH,74,-3048.722,-1507.4395,2.3030105,NULL,0,0,0,100,0),
+(@PATH,75,-3068.037,-1529.0762,4.6693797,NULL,0,0,0,100,0),
+(@PATH,76,-3050.034,-1538.9908,2.2948234,NULL,0,0,0,100,0),
+(@PATH,77,-3030.377,-1531.1482,1.8713083,NULL,0,0,0,100,0),
+(@PATH,78,-3007.2742,-1519.1643,6.1943064,NULL,0,0,0,100,0),
+(@PATH,79,-2979.6265,-1493.0153,6.2125106,NULL,0,0,0,100,0),
+(@PATH,80,-2948.1558,-1477.9122,6.2125034,NULL,0,0,0,100,0),
+(@PATH,81,-2915.9563,-1455.4119,6.2125106,NULL,0,0,0,100,0),
+(@PATH,82,-2888.584,-1418.0055,6.2125034,NULL,0,0,0,100,0),
+(@PATH,83,-2868.5942,-1383.6816,6.2125034,NULL,0,0,0,100,0),
+(@PATH,84,-2841.5269,-1356.3691,6.2124963,NULL,0,0,0,100,0),
+(@PATH,85,-2802.5144,-1327.2316,6.2124987,NULL,0,0,0,100,0),
+(@PATH,86,-2779.3325,-1318.1886,6.212498,NULL,0,0,0,100,0);