DB/Stormwind: Added a missing path for Darkmoon Faire Mystic Mage

1 files changed, 269 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_08_05_00_world.sql b/sql/updates/world/master/2025_08_05_00_world.sql
new file mode 100644
index 00000000000..23f11f2b4c8
--- /dev/null
+++ b/sql/updates/world/master/2025_08_05_00_world.sql
@@ -0,0 +1,269 @@
+-- Path for Darkmoon Faire Mystic Mage
+SET @MOVERGUID := 314353;
+SET @ENTRY := 54334;
+SET @PATHOFFSET := 0;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x0, NULL, 'Darkmoon Faire Mystic Mage - Cosmetic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -8719.774, 802.79517, 97.47743, NULL, 0),
+(@PATH, 1, -8718.497, 795.90454, 97.214096, NULL, 0),
+(@PATH, 2, -8722.663, 785.625, 97.57916, NULL, 0),
+(@PATH, 3, -8728.694, 778.07294, 97.81004, NULL, 0),
+(@PATH, 4, -8733.151, 768.6302, 98.0085, NULL, 0),
+(@PATH, 5, -8732.594, 761.50867, 98.11391, NULL, 0),
+(@PATH, 6, -8725.719, 749.783, 98.21408, NULL, 0),
+(@PATH, 7, -8719.364, 742.0417, 97.85816, NULL, 0),
+(@PATH, 8, -8716.681, 736.0955, 97.81734, NULL, 0),
+(@PATH, 9, -8722.304, 727.9705, 99.95421, NULL, 0),
+(@PATH, 10, -8730.734, 721.96356, 101.73567, NULL, 0),
+(@PATH, 11, -8738.768, 716.10767, 100.08177, NULL, 0),
+(@PATH, 12, -8746.248, 714.19794, 98.237915, NULL, 0),
+(@PATH, 13, -8752.96, 720.8889, 98.186455, NULL, 0),
+(@PATH, 14, -8758.45, 730.23267, 98.63279, NULL, 0),
+(@PATH, 15, -8764.832, 736.5869, 99.110054, NULL, 0),
+(@PATH, 16, -8775.9795, 741.684, 99.52734, NULL, 0),
+(@PATH, 17, -8792.481, 747.42365, 97.95969, NULL, 0),
+(@PATH, 18, -8806.87, 743.2205, 97.71975, NULL, 0),
+(@PATH, 19, -8828.545, 733.79517, 98.243355, NULL, 0),
+(@PATH, 20, -8839.518, 726.191, 97.68563, NULL, 0),
+(@PATH, 21, -8848.183, 729.4097, 98.71321, NULL, 0),
+(@PATH, 22, -8854.837, 739.1302, 100.78014, NULL, 0),
+(@PATH, 23, -8860.052, 747.90454, 100.05014, NULL, 0),
+(@PATH, 24, -8867.628, 756.9747, 97.57906, NULL, 0),
+(@PATH, 25, -8871.997, 759.6632, 96.854645, NULL, 0),
+(@PATH, 26, -8877.863, 757.3802, 96.47247, NULL, 0),
+(@PATH, 27, -8883.661, 758.3125, 95.523094, NULL, 0),
+(@PATH, 28, -8889.033, 762.55206, 93.928925, NULL, 0),
+(@PATH, 29, -8893.395, 768.5434, 92.16087, NULL, 0),
+(@PATH, 30, -8899.018, 776.2917, 90.267105, NULL, 0),
+(@PATH, 31, -8905.788, 784.11115, 88.55657, NULL, 0),
+(@PATH, 32, -8909.614, 789.10767, 87.66653, NULL, 0),
+(@PATH, 33, -8915.901, 787.1007, 87.34531, NULL, 0),
+(@PATH, 34, -8920.156, 783.51215, 87.44876, NULL, 0),
+(@PATH, 35, -8926.469, 778.6042, 87.588005, NULL, 0),
+(@PATH, 36, -8933.161, 775.2691, 88.82934, NULL, 0),
+(@PATH, 37, -8938.908, 774.26044, 89.49738, NULL, 0),
+(@PATH, 38, -8946.946, 771.1823, 91.06405, NULL, 0),
+(@PATH, 39, -8954.947, 770.8701, 92.9094, NULL, 0),
+(@PATH, 40, -8962.009, 772.1268, 94.43578, NULL, 0),
+(@PATH, 41, -8972.357, 777.54517, 96.47718, NULL, 0),
+(@PATH, 42, -8980.77, 786.6024, 98.84705, NULL, 0),
+(@PATH, 43, -8983.908, 790.875, 99.81322, NULL, 0),
+(@PATH, 44, -8986.252, 795.28906, 101.12416, NULL, 0),
+(@PATH, 45, -8989.761, 802.86285, 102.98389, NULL, 0),
+(@PATH, 46, -8992.529, 810.7049, 103.81305, NULL, 0),
+(@PATH, 47, -8994.774, 818.7292, 104.40303, NULL, 0),
+(@PATH, 48, -8997.4, 825.2168, 105.22429, NULL, 0),
+(@PATH, 49, -8998.149, 827.0799, 105.37602, NULL, 0),
+(@PATH, 50, -8998.873, 828.9453, 105.52703, NULL, 0),
+(@PATH, 51, -8998.959, 829.167, 105.56283, NULL, 0),
+(@PATH, 52, -8999.213, 832.01953, 105.876076, NULL, 0),
+(@PATH, 53, -8999.207, 832.27954, 105.87296, NULL, 0),
+(@PATH, 54, -8999.622, 835.01215, 105.8968, NULL, 0),
+(@PATH, 55, -8993.2, 836.9167, 105.77137, NULL, 0),
+(@PATH, 56, -8988.431, 837.7708, 105.86601, NULL, 0),
+(@PATH, 57, -8983.353, 842.77606, 105.77137, NULL, 0),
+(@PATH, 58, -8980.247, 847.23956, 105.748146, NULL, 0),
+(@PATH, 59, -8976.158, 853.79865, 105.85513, NULL, 0),
+(@PATH, 60, -8975.359, 859.52954, 106.33237, NULL, 0),
+(@PATH, 61, -8975.276, 867.4149, 106.85978, NULL, 0),
+(@PATH, 62, -8976.302, 876.7778, 106.66535, NULL, 0),
+(@PATH, 63, -8985.123, 890.54865, 105.79091, NULL, 0),
+(@PATH, 64, -8993.444, 895.5399, 105.5973, NULL, 0),
+(@PATH, 65, -9001.474, 900.67365, 105.98782, NULL, 0),
+(@PATH, 66, -9013.052, 915.8542, 106.859116, NULL, 0),
+(@PATH, 67, -9014.349, 924.98267, 107.86649, NULL, 0),
+(@PATH, 68, -9013.734, 933.8472, 108.398315, NULL, 0),
+(@PATH, 69, -9012.716, 937.36456, 108.67495, NULL, 0),
+(@PATH, 70, -9009.342, 945.56946, 109.29364, NULL, 0),
+(@PATH, 71, -9006.333, 952.7083, 110.30128, NULL, 0),
+(@PATH, 72, -9000.957, 957.0903, 112.02603, NULL, 0),
+(@PATH, 73, -8995.988, 958.9653, 113.26961, NULL, 0),
+(@PATH, 74, -8985.228, 960.0868, 115.80413, NULL, 0),
+(@PATH, 75, -8975.42, 959.6424, 116.95566, NULL, 0),
+(@PATH, 76, -8970.716, 958.84204, 117.66588, NULL, 0),
+(@PATH, 77, -8955.766, 956.4983, 117.74338, NULL, 0),
+(@PATH, 78, -8946.333, 952.23615, 117.2276, NULL, 0),
+(@PATH, 79, -8932.582, 949.7066, 117.306435, NULL, 0),
+(@PATH, 80, -8917.528, 948.4948, 117.4852, NULL, 0),
+(@PATH, 81, -8912.224, 940.98615, 117.19875, NULL, 0),
+(@PATH, 82, -8908.757, 934.9705, 116.69887, NULL, 0),
+(@PATH, 83, -8903.904, 927.38574, 115.19058, NULL, 0),
+(@PATH, 84, -8897.893, 917.9983, 112.38008, NULL, 0),
+(@PATH, 85, -8894.653, 912.4653, 110.82919, NULL, 0),
+(@PATH, 86, -8890.726, 901.8559, 107.4559, NULL, 0),
+(@PATH, 87, -8889.382, 893.19965, 104.66232, NULL, 0),
+(@PATH, 88, -8892.596, 879.59375, 100.53962, NULL, 0),
+(@PATH, 89, -8899.353, 864.8073, 96.51212, NULL, 0),
+(@PATH, 90, -8904.442, 853.15625, 96.21318, NULL, 0),
+(@PATH, 91, -8907.685, 846.4549, 96.11577, NULL, 0),
+(@PATH, 92, -8904.738, 838.65454, 95.02879, NULL, 0),
+(@PATH, 93, -8898.981, 825.2535, 92.45025, NULL, 0),
+(@PATH, 94, -8901.714, 813.6632, 89.05249, NULL, 0),
+(@PATH, 95, -8900.252, 804.34204, 87.89269, NULL, 0),
+(@PATH, 96, -8902.606, 797.84375, 87.34943, NULL, 0),
+(@PATH, 97, -8906.667, 792.75, 87.53647, NULL, 0),
+(@PATH, 98, -8904.634, 786.2743, 88.3625, NULL, 0),
+(@PATH, 99, -8901.667, 782.4722, 89.16582, NULL, 0),
+(@PATH, 100, -8897.556, 778.7674, 90.0926, NULL, 0),
+(@PATH, 101, -8893.022, 772.7518, 91.43268, NULL, 0),
+(@PATH, 102, -8888.06, 764.80554, 93.63571, NULL, 0),
+(@PATH, 103, -8883.665, 759.5347, 95.25863, NULL, 0),
+(@PATH, 104, -8880.861, 756.6875, 96.15961, NULL, 0),
+(@PATH, 105, -8876.484, 757.36115, 96.60792, NULL, 0),
+(@PATH, 106, -8870.868, 760.5573, 96.79639, NULL, 0),
+(@PATH, 107, -8865.929, 756.06946, 97.920044, NULL, 0),
+(@PATH, 108, -8861.622, 751.2882, 99.40069, NULL, 0),
+(@PATH, 109, -8856.821, 742.0174, 100.73092, NULL, 0),
+(@PATH, 110, -8853.554, 734.9132, 100.3797, NULL, 0),
+(@PATH, 111, -8850.502, 729.79865, 98.99333, NULL, 0),
+(@PATH, 112, -8846.274, 722.9132, 97.42926, NULL, 0),
+(@PATH, 113, -8841.038, 714.01044, 97.65904, NULL, 0),
+(@PATH, 114, -8835.263, 702.1215, 97.628784, NULL, 0),
+(@PATH, 115, -8827.558, 683.9618, 97.18829, NULL, 0),
+(@PATH, 116, -8824.325, 678.3125, 97.66692, NULL, 0),
+(@PATH, 117, -8819.3545, 679.4705, 97.929436, NULL, 0),
+(@PATH, 118, -8806.513, 684.2934, 100.510826, NULL, 0),
+(@PATH, 119, -8794.441, 682.9705, 101.56852, NULL, 0),
+(@PATH, 120, -8788.476, 681.1649, 102.246544, NULL, 0),
+(@PATH, 121, -8781.397, 675.8316, 103.01643, NULL, 0),
+(@PATH, 122, -8775.5625, 669.0625, 103.32521, NULL, 0),
+(@PATH, 123, -8768.098, 659.06946, 103.76924, NULL, 0),
+(@PATH, 124, -8761.507, 647.36633, 103.918335, NULL, 0),
+(@PATH, 125, -8758.833, 638.4809, 103.40195, NULL, 0),
+(@PATH, 126, -8758.619, 628.48047, 102.22868, NULL, 0),
+(@PATH, 127, -8764.109, 615.7257, 98.51982, NULL, 0),
+(@PATH, 128, -8769.306, 609.7743, 97.447426, NULL, 0),
+(@PATH, 129, -8766.63, 604.8403, 97.0215, NULL, 0),
+(@PATH, 130, -8755.308, 593.74304, 97.30838, NULL, 0),
+(@PATH, 131, -8743.567, 581.59375, 97.526764, NULL, 0),
+(@PATH, 132, -8738.884, 575.7899, 97.55916, NULL, 0),
+(@PATH, 133, -8741.701, 569.5643, 97.42569, NULL, 0),
+(@PATH, 134, -8745.554, 563.4722, 97.450714, NULL, 0),
+(@PATH, 135, -8744.415, 555.00696, 98.37792, NULL, 0),
+(@PATH, 136, -8737.558, 547.17017, 100.80291, NULL, 0),
+(@PATH, 137, -8727.223, 535.92365, 100.73588, NULL, 0),
+(@PATH, 138, -8718.007, 524.7708, 98.26837, NULL, 0),
+(@PATH, 139, -8715.286, 519.1719, 97.121956, NULL, 0),
+(@PATH, 140, -8719.566, 515.54865, 96.77778, NULL, 0),
+(@PATH, 141, -8711.601, 498.01215, 95.69655, NULL, 0),
+(@PATH, 142, -8703.52, 489.3212, 95.39444, NULL, 0),
+(@PATH, 143, -8695.45, 477.49652, 95.38501, NULL, 0),
+(@PATH, 144, -8698.224, 470.37326, 95.63808, NULL, 0),
+(@PATH, 145, -8703.306, 465.34723, 96.25411, NULL, 0),
+(@PATH, 146, -8711.466, 457.44098, 97.07352, NULL, 0),
+(@PATH, 147, -8716.997, 449.25, 97.225716, NULL, 0),
+(@PATH, 148, -8720.703, 435.45834, 97.685196, NULL, 0),
+(@PATH, 149, -8722.752, 422.56424, 97.97319, NULL, 0),
+(@PATH, 150, -8728.136, 411.32986, 97.73159, NULL, 0),
+(@PATH, 151, -8737.103, 403.81076, 97.93082, NULL, 0),
+(@PATH, 152, -8745.441, 396.7691, 100.17637, NULL, 0),
+(@PATH, 153, -8751.364, 392.16647, 101.084274, NULL, 0),
+(@PATH, 154, -8753.676, 384.0486, 101.084274, NULL, 0),
+(@PATH, 155, -8756.936, 379.3941, 101.084274, NULL, 0),
+(@PATH, 156, -8762.0625, 375.42188, 100.841034, NULL, 0),
+(@PATH, 157, -8765.304, 366.14932, 100.85254, NULL, 0),
+(@PATH, 158, -8759.279, 357.25, 100.61345, NULL, 0),
+(@PATH, 159, -8745.634, 350.74478, 100.50663, NULL, 0),
+(@PATH, 160, -8737.958, 357.64932, 101.581696, NULL, 0),
+(@PATH, 161, -8737.439, 367.48438, 100.882576, NULL, 0),
+(@PATH, 162, -8740.274, 372.92188, 100.84024, NULL, 0),
+(@PATH, 163, -8745.683, 380.00522, 101.08427, NULL, 0),
+(@PATH, 164, -8749.151, 385.5816, 101.084274, NULL, 0),
+(@PATH, 165, -8750.317, 391.01425, 101.08427, NULL, 0),
+(@PATH, 166, -8744.252, 395.84375, 100.072815, NULL, 0),
+(@PATH, 167, -8736.243, 401.5712, 97.931694, NULL, 0),
+(@PATH, 168, -8723.375, 406.98785, 97.81342, NULL, 0),
+(@PATH, 169, -8710.075, 406.033, 98.88298, NULL, 0),
+(@PATH, 170, -8700.545, 401.75522, 101.11141, NULL, 0),
+(@PATH, 171, -8690.56, 396.92883, 102.03673, NULL, 0),
+(@PATH, 172, -8679.849, 398.6059, 102.920456, NULL, 0),
+(@PATH, 173, -8665.513, 409.4479, 103.30877, NULL, 0),
+(@PATH, 174, -8652.986, 421.9271, 102.08664, NULL, 0),
+(@PATH, 175, -8643.736, 432.9757, 101.37027, NULL, 0),
+(@PATH, 176, -8633.703, 447.71875, 102.479034, NULL, 0),
+(@PATH, 177, -8634.7295, 459.7205, 102.309006, NULL, 0),
+(@PATH, 178, -8637.982, 467.0712, 102.28828, NULL, 0),
+(@PATH, 179, -8643.801, 477.17014, 102.587906, NULL, 0),
+(@PATH, 180, -8639.724, 482.8507, 102.589325, NULL, 0),
+(@PATH, 181, -8626.359, 493.95312, 102.69009, NULL, 0),
+(@PATH, 182, -8611.931, 504.4705, 103.33815, NULL, 0),
+(@PATH, 183, -8610.895, 509.03647, 103.68855, NULL, 0),
+(@PATH, 184, -8611.542, 513.88715, 103.56824, NULL, 0),
+(@PATH, 185, -8606.306, 520.44794, 105.676994, NULL, 0),
+(@PATH, 186, -8593.95, 531.1389, 105.82333, NULL, 0),
+(@PATH, 187, -8584.033, 538.99304, 103.00553, NULL, 0),
+(@PATH, 188, -8580.118, 544.4393, 102.10439, NULL, 0),
+(@PATH, 189, -8584.045, 556.3368, 101.96088, NULL, 0),
+(@PATH, 190, -8588.005, 572.9097, 102.88371, NULL, 0),
+(@PATH, 191, -8583.731, 589.8733, 103.67403, NULL, 0),
+(@PATH, 192, -8573.132, 607.17365, 103.03934, NULL, 0),
+(@PATH, 193, -8566.258, 612.9922, 102.669304, NULL, 0),
+(@PATH, 194, -8555.141, 619.4566, 102.03815, NULL, 0),
+(@PATH, 195, -8538.317, 632.4983, 100.56155, NULL, 0),
+(@PATH, 196, -8525.513, 639.24133, 100.03801, NULL, 0),
+(@PATH, 197, -8513.207, 650.8299, 100.51783, NULL, 0),
+(@PATH, 198, -8513.011, 657.7656, 101.18127, NULL, 0),
+(@PATH, 199, -8522.058, 670.2552, 102.90278, NULL, 0),
+(@PATH, 200, -8529.732, 681.4167, 99.86046, NULL, 0),
+(@PATH, 201, -8534, 687.55206, 97.702705, NULL, 0),
+(@PATH, 202, -8542.149, 686.9028, 97.726456, NULL, 0),
+(@PATH, 203, -8551.475, 681.0664, 97.341095, NULL, 0),
+(@PATH, 204, -8561.061, 674.9809, 97.04618, NULL, 0),
+(@PATH, 205, -8566.429, 679.8108, 97.026855, NULL, 0),
+(@PATH, 206, -8578.413, 694.36456, 97.05377, NULL, 0),
+(@PATH, 207, -8589.87, 708.4601, 96.920074, NULL, 0),
+(@PATH, 208, -8591.8545, 715.375, 96.836044, NULL, 0),
+(@PATH, 209, -8588.828, 726.0573, 96.789696, NULL, 0),
+(@PATH, 210, -8580.585, 735.49304, 96.850204, NULL, 0),
+(@PATH, 211, -8571.083, 747.8924, 96.932785, NULL, 0),
+(@PATH, 212, -8576.785, 756.5382, 96.7876, NULL, 0),
+(@PATH, 213, -8590.031, 758.4028, 96.87665, NULL, 0),
+(@PATH, 214, -8602.107, 758.94965, 96.92761, NULL, 0),
+(@PATH, 215, -8609.919, 760.0278, 97.00215, NULL, 0),
+(@PATH, 216, -8620.877, 751.79865, 96.96823, NULL, 0),
+(@PATH, 217, -8634.45, 740.625, 96.974525, NULL, 0),
+(@PATH, 218, -8642.554, 739.0174, 96.81596, NULL, 0),
+(@PATH, 219, -8652.481, 747.8594, 96.84505, NULL, 0),
+(@PATH, 220, -8661.841, 760.033, 97.06029, NULL, 0),
+(@PATH, 221, -8655.819, 771.684, 96.7471, NULL, 0),
+(@PATH, 222, -8642.431, 780.9375, 97.02266, NULL, 0),
+(@PATH, 223, -8634.226, 786.73267, 97.05513, NULL, 0),
+(@PATH, 224, -8634.061, 797.8333, 96.88832, NULL, 0),
+(@PATH, 225, -8633.611, 814.5, 96.79932, NULL, 0),
+(@PATH, 226, -8627.509, 825.25696, 96.749954, NULL, 0),
+(@PATH, 227, -8608.453, 842.2448, 96.86923, NULL, 0),
+(@PATH, 228, -8590.877, 855.5035, 97.03652, NULL, 0),
+(@PATH, 229, -8574.518, 862.74304, 98.938545, NULL, 0),
+(@PATH, 230, -8571.17, 878.29865, 99.33418, NULL, 0),
+(@PATH, 231, -8584.308, 886.2899, 97.31538, NULL, 0),
+(@PATH, 232, -8597.052, 896.86285, 97.80273, NULL, 0),
+(@PATH, 233, -8608.7295, 907.2083, 98.30627, NULL, 0),
+(@PATH, 234, -8621.558, 914.8472, 99.23853, NULL, 0),
+(@PATH, 235, -8628.078, 929.8333, 99.30535, NULL, 0),
+(@PATH, 236, -8621.042, 943.8333, 99.52959, NULL, 0),
+(@PATH, 237, -8607.488, 956.61115, 99.55832, NULL, 0),
+(@PATH, 238, -8591.363, 968.48267, 98.21163, NULL, 0),
+(@PATH, 239, -8584.939, 979.84894, 97.64515, NULL, 0),
+(@PATH, 240, -8595.497, 981.8264, 97.92367, NULL, 0),
+(@PATH, 241, -8606.278, 973.46704, 98.96188, NULL, 0),
+(@PATH, 242, -8620.134, 957.98956, 99.47615, NULL, 0),
+(@PATH, 243, -8632.904, 946.86285, 98.8155, NULL, 0),
+(@PATH, 244, -8633.439, 935.38367, 98.60818, NULL, 0),
+(@PATH, 245, -8637.335, 923.9653, 98.11321, NULL, 0),
+(@PATH, 246, -8653.118, 905.41144, 97.93225, NULL, 0),
+(@PATH, 247, -8666.764, 891.533, 97.55361, NULL, 0),
+(@PATH, 248, -8680.882, 878.4792, 97.12232, NULL, 0),
+(@PATH, 249, -8707.511, 860.36115, 97.3031, NULL, 0),
+(@PATH, 250, -8723.139, 842.69446, 96.192535, NULL, 0),
+(@PATH, 251, -8727.54, 832.67365, 96.25582, NULL, 0),
+(@PATH, 252, -8727.3125, 815.9149, 97.250824, NULL, 0);
+
+UPDATE `creature` SET `position_x`=-8719.774, `position_y`=802.79517, `position_z`=97.47743, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);