DB/Stormwind: Added missing path for Officer Fairbanks & Elizabeth Birdsong

1 files changed, 219 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_01_04_00_world.sql b/sql/updates/world/master/2025_01_04_00_world.sql
new file mode 100644
index 00000000000..fd4a81ec8f4
--- /dev/null
+++ b/sql/updates/world/master/2025_01_04_00_world.sql
@@ -0,0 +1,219 @@
+-- Path for Officer Fairbanks
+SET @MOVERGUID := 452751;
+SET @ENTRY := 113211;
+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, 'Officer Fairbanks - 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, -8618.585, 962.7448, 99.57952, NULL, 0),
+(@PATH, 1, -8625.276, 954.8507, 99.10933, NULL, 0),
+(@PATH, 2, -8628.217, 946.3993, 99.19649, NULL, 0),
+(@PATH, 3, -8635.774, 933.07294, 98.13914, NULL, 0),
+(@PATH, 4, -8640.802, 928.4583, 97.77138, NULL, 0),
+(@PATH, 5, -8645.576, 927.0382, 97.77137, NULL, 0),
+(@PATH, 6, -8650.058, 929.8733, 96.5779, NULL, 0),
+(@PATH, 7, -8657.165, 937.69446, 91.974495, NULL, 0),
+(@PATH, 8, -8662.377, 941.5955, 91.24571, NULL, 0),
+(@PATH, 9, -8670.27, 944.8455, 91.25174, NULL, 0),
+(@PATH, 10, -8674.669, 945.90625, 91.56824, NULL, 0),
+(@PATH, 11, -8688.942, 946.2274, 85.77137, NULL, 0),
+(@PATH, 12, -8696.868, 946.54865, 85.27152, NULL, 0),
+(@PATH, 13, -8711.122, 947.00867, 85.271515, NULL, 0),
+(@PATH, 14, -8718.9375, 948.0781, 85.27151, NULL, 0),
+(@PATH, 15, -8722.764, 951.533, 85.27151, NULL, 0),
+(@PATH, 16, -8726.823, 956.94617, 85.27168, NULL, 0),
+(@PATH, 17, -8732, 960.07465, 85.271515, NULL, 0),
+(@PATH, 18, -8737.089, 961.78125, 85.271515, NULL, 0),
+(@PATH, 19, -8741.611, 960.7031, 85.271515, NULL, 0),
+(@PATH, 20, -8745.719, 958.1458, 85.27152, NULL, 0),
+(@PATH, 21, -8749.8545, 953.27606, 85.27152, NULL, 0),
+(@PATH, 22, -8752.052, 949.434, 85.27152, NULL, 0),
+(@PATH, 23, -8755.802, 946.76044, 85.271515, NULL, 0),
+(@PATH, 24, -8763.726, 946.5781, 85.27153, NULL, 0),
+(@PATH, 25, -8772.316, 946.7535, 85.271416, NULL, 0),
+(@PATH, 26, -8784.757, 946.7066, 85.77137, NULL, 0),
+(@PATH, 27, -8791.564, 946.75867, 88.496704, NULL, 0),
+(@PATH, 28, -8799.458, 946.184, 91.568245, NULL, 0),
+(@PATH, 29, -8804.696, 942.9601, 91.2407, NULL, 0),
+(@PATH, 30, -8811.002, 935.48956, 91.2407, NULL, 0),
+(@PATH, 31, -8814.192, 927.57465, 91.974495, NULL, 0),
+(@PATH, 32, -8814.79, 920.63715, 94.96031, NULL, 0),
+(@PATH, 33, -8815.231, 910.7552, 98.974495, NULL, 0),
+(@PATH, 34, -8815.741, 903.8559, 98.9745, NULL, 0),
+(@PATH, 35, -8816.776, 892.60767, 98.493004, NULL, 0),
+(@PATH, 36, -8818.526, 878.67535, 98.79655, NULL, 0),
+(@PATH, 37, -8819.752, 863.6893, 99.08533, NULL, 0),
+(@PATH, 38, -8820.42, 849.658, 99.0667, NULL, 0),
+(@PATH, 39, -8821.505, 837.51215, 99.04786, NULL, 0),
+(@PATH, 40, -8823.198, 823.0417, 98.82051, NULL, 0),
+(@PATH, 41, -8824.232, 813.9705, 98.99023, NULL, 0),
+(@PATH, 42, -8824.974, 807.4601, 98.37863, NULL, 0),
+(@PATH, 43, -8825.417, 798.59894, 97.50955, NULL, 0),
+(@PATH, 44, -8827.37, 791.1528, 96.868996, NULL, 0),
+(@PATH, 45, -8831.035, 786.816, 96.535736, NULL, 0),
+(@PATH, 46, -8840.089, 781.11285, 96.22676, NULL, 0),
+(@PATH, 47, -8850.317, 775.0174, 96.02889, NULL, 0),
+(@PATH, 48, -8858.1875, 769.74304, 96.621994, NULL, 3089),
+(@PATH, 49, -8858.1875, 769.74304, 96.621994, NULL, 0),
+(@PATH, 50, -8864.3955, 766.2257, 96.956635, NULL, 0),
+(@PATH, 51, -8868.25, 762.80383, 96.85158, NULL, 0),
+(@PATH, 52, -8867.859, 757.3108, 97.48644, NULL, 0),
+(@PATH, 53, -8862.721, 749.2708, 99.5496, NULL, 0),
+(@PATH, 54, -8855.064, 737.4844, 100.70324, NULL, 0),
+(@PATH, 55, -8848.481, 727.0174, 98.016, NULL, 0),
+(@PATH, 56, -8841.575, 724.184, 97.564285, NULL, 0),
+(@PATH, 57, -8832.9795, 729.86285, 98.11986, NULL, 0),
+(@PATH, 58, -8819.2295, 738.2049, 98.09607, NULL, 0),
+(@PATH, 59, -8808.356, 743.30035, 97.736755, NULL, 0),
+(@PATH, 60, -8795.297, 746.48785, 97.89614, NULL, 0),
+(@PATH, 61, -8783.748, 746.1389, 98.78586, NULL, 0),
+(@PATH, 62, -8774.927, 743.6684, 99.371, NULL, 0),
+(@PATH, 63, -8767.056, 737.3785, 99.238464, NULL, 0),
+(@PATH, 64, -8754.311, 724.05206, 98.24237, NULL, 0),
+(@PATH, 65, -8746.906, 715.23785, 98.139946, NULL, 0),
+(@PATH, 66, -8742.488, 713.84204, 98.44445, NULL, 0),
+(@PATH, 67, -8736.052, 717.8698, 101.26919, NULL, 0),
+(@PATH, 68, -8731.42, 721.5174, 101.75175, NULL, 0),
+(@PATH, 69, -8726.107, 725.86804, 101.07724, NULL, 0),
+(@PATH, 70, -8718.591, 733.4323, 98.134026, NULL, 0),
+(@PATH, 71, -8718.704, 733.31836, 98.25213, NULL, 0),
+(@PATH, 72, -8718.591, 733.4323, 98.134026, NULL, 0),
+(@PATH, 73, -8718.526, 733.743, 98.06222, NULL, 0),
+(@PATH, 74, -8717.709, 734.375, 97.82735, NULL, 0),
+(@PATH, 75, -8717.709, 735.417, 97.83429, NULL, 0),
+(@PATH, 76, -8717.709, 737.5, 97.7979, NULL, 0),
+(@PATH, 77, -8717.649, 737.9583, 97.80494, NULL, 0),
+(@PATH, 78, -8721.645, 744.7465, 97.93552, NULL, 0),
+(@PATH, 79, -8727.123, 752.15454, 98.2005, NULL, 0),
+(@PATH, 80, -8731.018, 761.809, 98.27401, NULL, 0),
+(@PATH, 81, -8731.481, 769.658, 98.15886, NULL, 0),
+(@PATH, 82, -8727.076, 777.16144, 98.0238, NULL, 0),
+(@PATH, 83, -8720.583, 788.61456, 97.436844, NULL, 0),
+(@PATH, 84, -8719.038, 796.0035, 97.17532, NULL, 0),
+(@PATH, 85, -8721.724, 804.3108, 97.393135, NULL, 0),
+(@PATH, 86, -8725.79, 811.4358, 97.36475, NULL, 0),
+(@PATH, 87, -8728.473, 819.75867, 97.02661, NULL, 0),
+(@PATH, 88, -8728.705, 828.16144, 96.51658, NULL, 0),
+(@PATH, 89, -8725.754, 839.1007, 96.15872, NULL, 0),
+(@PATH, 90, -8720.601, 846.7101, 96.48625, NULL, 0),
+(@PATH, 91, -8714.973, 853.2518, 96.98395, NULL, 0),
+(@PATH, 92, -8707.424, 859.8941, 97.28087, NULL, 0),
+(@PATH, 93, -8697.903, 867.2691, 97.18011, NULL, 0),
+(@PATH, 94, -8686.705, 875.5833, 97.04999, NULL, 0),
+(@PATH, 95, -8675.264, 884.49304, 97.14244, NULL, 0),
+(@PATH, 96, -8663.424, 894.7153, 97.62767, NULL, 0),
+(@PATH, 97, -8650.607, 907.30035, 97.94279, NULL, 0),
+(@PATH, 98, -8635.714, 923.6268, 98.35846, NULL, 0),
+(@PATH, 99, -8628.513, 932.4323, 99.22489, NULL, 0),
+(@PATH, 100, -8621.962, 939.6389, 99.61249, NULL, 0),
+(@PATH, 101, -8609.114, 951.6927, 99.580444, NULL, 0),
+(@PATH, 102, -8596.294, 962.691, 98.891235, NULL, 0),
+(@PATH, 103, -8582.216, 974.92706, 97.7479, NULL, 0),
+(@PATH, 104, -8579.186, 982.31946, 97.21208, NULL, 0),
+(@PATH, 105, -8582.252, 986.48615, 97.33541, NULL, 0),
+(@PATH, 106, -8587.694, 986.60767, 97.69992, NULL, 0),
+(@PATH, 107, -8597.21, 981.8802, 97.99365, NULL, 0),
+(@PATH, 108, -8608.132, 972.48267, 99.12246, NULL, 0);
+
+UPDATE `creature` SET `position_x`=-8618.585, `position_y`=962.7448, `position_z`=99.57952, `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);
+
+-- Path for Elizabeth Birdsong
+DELETE FROM `creature_template_gossip` WHERE (`CreatureID`=71526 AND `MenuID`=15723);
+INSERT INTO `creature_template_gossip` (`CreatureID`, `MenuID`, `VerifiedBuild`) VALUES
+(71526, 15723, 58238); -- Elizabeth Birdsong
+
+SET @MOVERGUID := 452769;
+SET @ENTRY := 71526;
+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, 'Elizabeth Birdsong - 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, -8516.545, 663.2899, 102.275116, NULL, 0),
+(@PATH, 1, -8522.491, 671.16144, 102.893814, NULL, 0),
+(@PATH, 2, -8531.931, 684.5677, 98.115364, NULL, 0),
+(@PATH, 3, -8532.875, 685.06757, 97.90278, NULL, 0),
+(@PATH, 4, -8537.5, 687.5, 97.741455, NULL, 0),
+(@PATH, 5, -8552.54, 679.6667, 97.26322, NULL, 0),
+(@PATH, 6, -8563.096, 673.5625, 97.04676, NULL, 0),
+(@PATH, 7, -8569.518, 682.3143, 97.043335, NULL, 0),
+(@PATH, 8, -8581.295, 697.5, 97.06583, NULL, 0),
+(@PATH, 9, -8593.641, 713.2639, 96.85501, NULL, 0),
+(@PATH, 10, -8599.085, 715.0174, 96.835175, NULL, 0),
+(@PATH, 11, -8611.667, 707.65625, 96.722595, NULL, 0),
+(@PATH, 12, -8623.064, 716.8559, 96.765274, NULL, 0),
+(@PATH, 13, -8631.698, 728.2917, 96.83443, NULL, 0),
+(@PATH, 14, -8643.926, 737.1441, 96.7815, NULL, 0),
+(@PATH, 15, -8656.636, 747.908, 96.822845, NULL, 0),
+(@PATH, 16, -8674.806, 734.4219, 97.0416, NULL, 0),
+(@PATH, 17, -8690.364, 721.44965, 97.057106, NULL, 0),
+(@PATH, 18, -8698.208, 715.3785, 97.06707, NULL, 0),
+(@PATH, 19, -8707.785, 725.1719, 97.36392, NULL, 0),
+(@PATH, 20, -8714.944, 734.50867, 97.81765, NULL, 0),
+(@PATH, 21, -8725.861, 725.7552, 101.06279, NULL, 0),
+(@PATH, 22, -8734.694, 719.6059, 101.69485, NULL, 0),
+(@PATH, 23, -8743.922, 712.13196, 98.41209, NULL, 0),
+(@PATH, 24, -8737.984, 700.9549, 98.847336, NULL, 0),
+(@PATH, 25, -8750.118, 690.00696, 100.173615, NULL, 0),
+(@PATH, 26, -8760.389, 681.7083, 101.67505, NULL, 0),
+(@PATH, 27, -8775.219, 668.69446, 103.35047, NULL, 0),
+(@PATH, 28, -8766.045, 655.434, 103.68203, NULL, 0),
+(@PATH, 29, -8758.9795, 641.283, 103.676735, NULL, 0),
+(@PATH, 30, -8758.694, 626.7049, 101.80447, NULL, 0),
+(@PATH, 31, -8768.714, 610.05035, 97.43364, NULL, 0),
+(@PATH, 32, -8758.422, 597.17706, 97.18574, NULL, 0),
+(@PATH, 33, -8748.185, 586.5226, 97.40349, NULL, 0),
+(@PATH, 34, -8736.201, 574.13715, 97.424644, NULL, 0),
+(@PATH, 35, -8747.31, 562.9375, 97.42701, NULL, 0),
+(@PATH, 36, -8755.839, 551.7969, 97.428566, NULL, 0),
+(@PATH, 37, -8766.685, 536.2014, 97.46885, NULL, 0),
+(@PATH, 38, -8780.849, 517.9618, 97.72941, NULL, 0),
+(@PATH, 39, -8797.302, 503.63196, 98.17074, NULL, 0),
+(@PATH, 40, -8801.349, 492.1389, 97.296234, NULL, 0),
+(@PATH, 41, -8798.33, 478.8316, 96.53606, NULL, 0),
+(@PATH, 42, -8793.913, 473.76215, 96.719315, NULL, 0),
+(@PATH, 43, -8784.674, 469.95312, 97.472664, NULL, 0),
+(@PATH, 44, -8769.958, 470.69098, 97.765274, NULL, 0),
+(@PATH, 45, -8758.351, 479.57465, 97.39488, NULL, 0),
+(@PATH, 46, -8745.703, 491.83853, 96.91533, NULL, 0),
+(@PATH, 47, -8734.486, 503.79688, 96.46916, NULL, 0),
+(@PATH, 48, -8723.75, 511.2691, 96.64314, NULL, 0),
+(@PATH, 49, -8716.683, 504.908, 96.14421, NULL, 0),
+(@PATH, 50, -8701.441, 485.0625, 95.37868, NULL, 0),
+(@PATH, 51, -8693.047, 474.44098, 95.37867, NULL, 0),
+(@PATH, 52, -8682.091, 484.41495, 96.813065, NULL, 0),
+(@PATH, 53, -8673.973, 494.158, 99.34901, NULL, 0),
+(@PATH, 54, -8664.192, 497.34027, 100.79942, NULL, 0),
+(@PATH, 55, -8656.606, 491.02777, 101.634865, NULL, 0),
+(@PATH, 56, -8646.893, 479.12326, 102.59833, NULL, 0),
+(@PATH, 57, -8637.598, 484.658, 102.5991, NULL, 0),
+(@PATH, 58, -8625.677, 494.2309, 102.72224, NULL, 0),
+(@PATH, 59, -8610.276, 506.81598, 103.66881, NULL, 0),
+(@PATH, 60, -8611.092, 514.88367, 103.7995, NULL, 0),
+(@PATH, 61, -8605.984, 520.0972, 105.662796, NULL, 0),
+(@PATH, 62, -8598.571, 527.32465, 106.562454, NULL, 0),
+(@PATH, 63, -8590.998, 533.1268, 105.2254, NULL, 0),
+(@PATH, 64, -8580.533, 541.67017, 102.041794, NULL, 0),
+(@PATH, 65, -8584.933, 556.2014, 101.9344, NULL, 0),
+(@PATH, 66, -8587.54, 566.5347, 102.32199, NULL, 0),
+(@PATH, 67, -8586.933, 581.97394, 103.45114, NULL, 0),
+(@PATH, 68, -8578.444, 598.8368, 103.537964, NULL, 0),
+(@PATH, 69, -8565.219, 612.7049, 102.68694, NULL, 0),
+(@PATH, 70, -8545.63, 626.80383, 101.10074, NULL, 0),
+(@PATH, 71, -8527.17, 639.31946, 100.02408, NULL, 0),
+(@PATH, 72, -8510.422, 651.46875, 100.499466, NULL, 0);
+
+UPDATE `creature` SET `position_x`=-8516.545, `position_y`=663.2899, `position_z`=102.275116, `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);