diff options
| -rw-r--r-- | sql/updates/world/master/2018_04_29_05_world_2016_12_30_04_world_335.sql | 1571 |
1 files changed, 1571 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_04_29_05_world_2016_12_30_04_world_335.sql b/sql/updates/world/master/2018_04_29_05_world_2016_12_30_04_world_335.sql new file mode 100644 index 00000000000..e24faf7e615 --- /dev/null +++ b/sql/updates/world/master/2018_04_29_05_world_2016_12_30_04_world_335.sql @@ -0,0 +1,1571 @@ +-- +SET @NPC := 101356; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 5720.28, 609.055, 649.084, 0), +(@PATH, 2, 5722.53, 607.305, 649.084, 0), +(@PATH, 3, 5718.13, 600.287, 648.582, 0), +(@PATH, 4, 5722.53, 607.305, 649.084, 0); + +SET @NPC := 71030; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +UPDATE `creature_template_addon` SET `path_id`=710300 WHERE `entry`=19926; +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 2595.36, 2360.95, 109.478, 0), +(@PATH, 2, 2585.52, 2350.45, 110.88, 0), +(@PATH, 3, 2572.13, 2339.45, 115.757, 0), +(@PATH, 4, 2556.54, 2331.52, 115.717, 0), +(@PATH, 5, 2539.46, 2337.63, 120.037, 0), +(@PATH, 6, 2530.99, 2346.85, 123.855, 0), +(@PATH, 7, 2529.02, 2354.55, 126.993, 0), +(@PATH, 8, 2532.37, 2371.51, 128.507, 0), +(@PATH, 9, 2552.36, 2361.93, 128.507, 0), +(@PATH, 10, 2530.93, 2370.83, 128.5, 0), +(@PATH, 11, 2521.53, 2393.35, 130.17, 0), +(@PATH, 12, 2531.54, 2372.36, 128.507, 0), +(@PATH, 13, 2550.23, 2362.89, 128.507, 0), +(@PATH, 14, 2530.34, 2368.33, 128.502, 0), +(@PATH, 15, 2528.97, 2353.74, 126.803, 0), +(@PATH, 16, 2536.33, 2338.61, 120.862, 0), +(@PATH, 17, 2555.73, 2330.77, 115.628, 0), +(@PATH, 18, 2552.54, 2320.33, 116.028, 0), +(@PATH, 19, 2538.15, 2312.96, 115.959, 0), +(@PATH, 20, 2520.64, 2325.98, 116.039, 0), +(@PATH, 21, 2540.44, 2314.78, 115.964, 0), +(@PATH, 22, 2560.87, 2324.05, 115.724, 0), +(@PATH, 23, 2575.51, 2341.01, 115.048, 0), +(@PATH, 24, 2583.17, 2357.63, 109.662, 0), +(@PATH, 25, 2583.03, 2370.96, 109.45, 0), +(@PATH, 26, 2577.38, 2399.34, 109.477, 0), +(@PATH, 27, 2579.98, 2384.7, 109.476, 0), +(@PATH, 28, 2594.19, 2374.24, 109.477, 0); + +SET @NPC := 89532; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -10642.8, 1016.66, 31.5651, 0), +(@PATH, 2, -10620.2, 1000.85, 32.9944, 0), +(@PATH, 3, -10594, 987.937, 36.8771, 0), +(@PATH, 4, -10564.6, 975.733, 40.6344, 0), +(@PATH, 5, -10532.9, 961.984, 40.8852, 0), +(@PATH, 6, -10500.2, 952.64, 39.4598, 0), +(@PATH, 7, -10466.9, 953.813, 35.8982, 0), +(@PATH, 8, -10433.2, 981.964, 34.7575, 0), +(@PATH, 9, -10410.5, 994.716, 32.1643, 0), +(@PATH, 10, -10400.4, 992.543, 31.5791, 0), +(@PATH, 11, -10386.8, 984.074, 31.5979, 0), +(@PATH, 12, -10367.4, 980.618, 31.4729, 0), +(@PATH, 13, -10333.5, 978.783, 31.2549, 0), +(@PATH, 14, -10300.2, 965.637, 31.253, 0), +(@PATH, 15, -10285.6, 964.09, 31.1856, 0), +(@PATH, 16, -10273.9, 970.693, 31.1856, 0), +(@PATH, 17, -10267.6, 983.352, 31.3106, 0), +(@PATH, 18, -10260.9, 989.903, 31.3775, 0), +(@PATH, 19, -10234, 996.264, 31.4918, 0), +(@PATH, 20, -10215.9, 994.502, 32.5031, 0), +(@PATH, 21, -10200.1, 989.352, 32.9333, 0), +(@PATH, 22, -10190, 984.9, 33.7804, 0), +(@PATH, 23, -10166.8, 986.717, 34.0541, 0), +(@PATH, 24, -10133.5, 990.649, 36.0486, 0), +(@PATH, 25, -10116.7, 990.127, 38.2197, 0), +(@PATH, 26, -10100.2, 999.191, 37.4609, 0), +(@PATH, 27, -10116.7, 990.127, 38.2197, 0), +(@PATH, 28, -10133.5, 990.649, 36.0486, 0), +(@PATH, 29, -10166.8, 986.717, 34.0541, 0), +(@PATH, 30, -10190, 984.9, 33.7804, 0), +(@PATH, 31, -10200.1, 989.352, 32.9333, 0), +(@PATH, 32, -10215.9, 994.502, 32.5031, 0), +(@PATH, 33, -10234, 996.264, 31.4918, 0), +(@PATH, 34, -10260.9, 989.903, 31.3775, 0), +(@PATH, 35, -10267.6, 983.352, 31.3106, 0), +(@PATH, 36, -10273.9, 970.693, 31.1856, 0), +(@PATH, 37, -10285.6, 964.09, 31.1856, 0), +(@PATH, 38, -10300.2, 965.637, 31.253, 0), +(@PATH, 39, -10333.5, 978.783, 31.2549, 0), +(@PATH, 40, -10367.4, 980.618, 31.4729, 0), +(@PATH, 41, -10386.8, 984.074, 31.5979, 0), +(@PATH, 42, -10400.4, 992.543, 31.5791, 0), +(@PATH, 43, -10410.5, 994.716, 32.1643, 0), +(@PATH, 44, -10433.2, 981.964, 34.7575, 0), +(@PATH, 45, -10466.9, 953.813, 35.8982, 0), +(@PATH, 46, -10500.2, 952.64, 39.4598, 0), +(@PATH, 47, -10532.9, 961.984, 40.8852, 0), +(@PATH, 48, -10564.6, 975.733, 40.6344, 0), +(@PATH, 49, -10594, 987.937, 36.8771, 0), +(@PATH, 50, -10620.2, 1000.85, 32.9944, 0), +(@PATH, 51, -10642.8, 1016.66, 31.5651, 0), +(@PATH, 52, -10647.5, 1012.37, 31.7765, 0); + +SET @NPC := 10080; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 20, -9245.68, -2167.47, 63.9388, 15000), +(@PATH, 19, -9245.3, -2171.29, 63.9388, 0), +(@PATH, 18, -9212.64, -2174.06, 64.0584, 0), +(@PATH, 17, -9187.23, -2160.7, 64.0584, 0), +(@PATH, 16, -9187.41, -2138.51, 64.0064, 0), +(@PATH, 15, -9212.24, -2135.42, 64.0584, 0), +(@PATH, 14, -9232.15, -2130.65, 64.0584, 0), +(@PATH, 13, -9246.59, -2118.7, 65.591, 0), +(@PATH, 12, -9245.79, -2099.05, 72.1959, 0), +(@PATH, 11, -9235.08, -2087.05, 76.554, 0), +(@PATH, 10, -9189.04, -2094.36, 87.8603, 15000), +(@PATH, 9, -9206.65, -2088.98, 86.1227, 0), +(@PATH, 8, -9220.59, -2089.07, 81.4125, 0), +(@PATH, 7, -9234.09, -2083.62, 76.7928, 0), +(@PATH, 6, -9234.39, -2072.97, 76.5348, 0), +(@PATH, 5, -9239.85, -2075.51, 75.7547, 15000), +(@PATH, 4, -9243.47, -2098.98, 72.6224, 0), +(@PATH, 3, -9246.5, -2115.22, 66.5529, 0), +(@PATH, 2, -9254.05, -2135.93, 63.9399, 0), +(@PATH, 1, -9253.7, -2167.14, 64.0579, 0); + +SET @NPC := 44990; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 2742.71, 785.519, 119.133, 25000), +(@PATH, 2, 2747.48, 789.889, 119.131, 0), +(@PATH, 3, 2749.94, 797.442, 119.108, 0), +(@PATH, 4, 2753.93, 798.877, 119.091, 0), +(@PATH, 5, 2756.69, 798.914, 119.131, 0), +(@PATH, 6, 2763.93, 796.199, 114.367, 0), +(@PATH, 7, 2764.54, 794.093, 114.367, 0), +(@PATH, 8, 2762.54, 791.399, 114.367, 0), +(@PATH, 9, 2758.8, 790.731, 114.367, 0), +(@PATH, 10, 2752.16, 792.589, 114.367, 0), +(@PATH, 11, 2751.12, 799.975, 114.367, 0), +(@PATH, 12, 2752.03, 803.195, 114.245, 15000), +(@PATH, 13, 2748.36, 790.155, 114.367, 0), +(@PATH, 14, 2746.26, 783.31, 114.837, 80000), +(@PATH, 15, 2748.36, 790.155, 114.367, 0), +(@PATH, 16, 2751.12, 799.975, 114.367, 0), +(@PATH, 17, 2752.03, 803.195, 114.245, 15000), +(@PATH, 18, 2752.16, 792.589, 114.367, 0), +(@PATH, 19, 2758.8, 790.731, 114.367, 0), +(@PATH, 20, 2762.54, 791.399, 114.367, 0), +(@PATH, 21, 2764.54, 794.093, 114.367, 0), +(@PATH, 22, 2763.93, 796.199, 114.367, 0), +(@PATH, 23, 2756.69, 798.914, 119.131, 0), +(@PATH, 24, 2753.93, 798.877, 119.091, 0), +(@PATH, 25, 2749.94, 797.442, 119.108, 0), +(@PATH, 26, 2747.48, 789.889, 119.131, 0), +(@PATH, 27, 2742.71, 785.519, 119.133, 0); + +SET @NPC := 37385; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 4516.77, 607.805, 31.7845, 0), +(@PATH, 2, 4519.16, 571.186, 32.5817, 0), +(@PATH, 3, 4506.04, 545.204, 39.1878, 0), +(@PATH, 4, 4484.27, 524.398, 43.4054, 0), +(@PATH, 5, 4475.53, 496.37, 48.935, 0), +(@PATH, 6, 4462.23, 486.497, 50.0938, 0), +(@PATH, 7, 4448, 483.935, 50.4496, 0), +(@PATH, 8, 4414.98, 478.825, 57.0827, 0), +(@PATH, 9, 4375.29, 464.64, 61.9022, 0), +(@PATH, 10, 4351.72, 441.123, 60.2804, 0), +(@PATH, 11, 4346.24, 420.217, 60.9888, 0), +(@PATH, 12, 4339.67, 403.893, 61.593, 0), +(@PATH, 13, 4322.4, 397.517, 62.6931, 0), +(@PATH, 14, 4300.05, 404.118, 62.2459, 0), +(@PATH, 15, 4283.83, 413.06, 60.7891, 0), +(@PATH, 16, 4276.19, 431.525, 61.5429, 0), +(@PATH, 17, 4278.02, 448.285, 60.9137, 0), +(@PATH, 18, 4299.49, 481.952, 60.6362, 0), +(@PATH, 19, 4369.62, 540.487, 59.3641, 0), +(@PATH, 20, 4404.23, 564.665, 48.7928, 0), +(@PATH, 21, 4425.79, 586.472, 42.1827, 0), +(@PATH, 22, 4430.26, 606.587, 39.6061, 0), +(@PATH, 23, 4437.38, 624.615, 36.918, 0), +(@PATH, 24, 4455.5, 639.752, 31.2693, 0), +(@PATH, 25, 4474.88, 666.869, 26.2529, 0), +(@PATH, 26, 4500.03, 694.421, 24.5656, 0), +(@PATH, 27, 4513.71, 706.448, 23.2624, 0), +(@PATH, 28, 4528.3, 704.51, 24.6299, 0), +(@PATH, 29, 4535.2, 690.152, 25.2516, 4000), +(@PATH, 30, 4520.51, 660.629, 24.7118, 0); + +SET @NPC := 37432; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH, 0, 131072, 4097, 0, '30831'); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 6559.83, 310.877, 31.216, 0), +(@PATH, 2, 6561.89, 320.477, 30.9214, 0), +(@PATH, 3, 6568.24, 327.336, 32.3687, 0), +(@PATH, 4, 6570.53, 339.091, 32.3075, 0), +(@PATH, 5, 6572.16, 353.61, 31.2842, 0), +(@PATH, 6, 6593.72, 383.151, 31.5727, 0), +(@PATH, 7, 6599.04, 396.587, 30.7275, 0), +(@PATH, 8, 6602.39, 418.766, 31.1657, 0), +(@PATH, 9, 6606.32, 423.51, 31.1574, 0), +(@PATH, 10, 6616.12, 424.975, 31.0009, 0), +(@PATH, 11, 6636.38, 419.027, 29.0109, 0), +(@PATH, 12, 6657.03, 409.434, 26.5562, 0), +(@PATH, 13, 6675.92, 410.257, 25.5474, 0), +(@PATH, 14, 6695.2, 404.067, 24.8281, 0), +(@PATH, 15, 6695.88, 373.394, 25.1366, 0), +(@PATH, 16, 6689.89, 349.379, 26.4004, 0), +(@PATH, 17, 6691.2, 323.849, 28.1595, 0), +(@PATH, 18, 6681.62, 314.014, 29.6691, 0), +(@PATH, 19, 6667.47, 275.655, 30.2672, 0), +(@PATH, 20, 6668.59, 247.85, 28.5043, 0), +(@PATH, 21, 6676.17, 231.133, 27.7114, 0), +(@PATH, 22, 6689.02, 231.703, 27.7665, 0), +(@PATH, 23, 6702.46, 241.172, 26.8066, 0), +(@PATH, 24, 6726.36, 239.691, 25.1609, 0), +(@PATH, 25, 6753.21, 267.495, 21.4772, 0), +(@PATH, 26, 6756.23, 281.507, 21.4288, 0), +(@PATH, 27, 6764.58, 292.463, 22.9999, 0), +(@PATH, 28, 6787.86, 305.657, 22.1223, 0), +(@PATH, 29, 6806, 323.797, 19.734, 0), +(@PATH, 30, 6804.64, 336.963, 20.647, 0), +(@PATH, 31, 6793.74, 364.937, 21.6829, 0), +(@PATH, 32, 6782.48, 380.527, 23.073, 0), +(@PATH, 33, 6766.45, 391.01, 23.8141, 0), +(@PATH, 34, 6737.81, 392.673, 23.2805, 0), +(@PATH, 35, 6727.03, 379.069, 25.3047, 0), +(@PATH, 36, 6723.54, 370.312, 25.0861, 0), +(@PATH, 37, 6721.03, 359.625, 24.6189, 0), +(@PATH, 38, 6709.47, 368.083, 25.166, 0), +(@PATH, 39, 6694.07, 370.5, 25.0605, 0), +(@PATH, 40, 6680.05, 363.219, 22.9391, 0), +(@PATH, 41, 6659.83, 340.231, 27.4319, 0), +(@PATH, 42, 6635.55, 340.878, 27.8198, 0), +(@PATH, 43, 6616.48, 342.006, 28.6154, 0), +(@PATH, 44, 6600.46, 319.145, 28.7719, 0), +(@PATH, 45, 6587.54, 309.326, 29.0843, 0), +(@PATH, 46, 6574.89, 303.877, 30.9953, 0), +(@PATH, 47, 6566.88, 300.239, 31.3335, 0); + +SET @NPC := 63913; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 664.315, -1027.59, 160.39, 0), +(@PATH, 2, 654.02, -1032.34, 163.127, 0), +(@PATH, 3, 634.638, -1041.36, 163.816, 0), +(@PATH, 4, 622.304, -1055.48, 163.186, 0), +(@PATH, 5, 620.168, -1114.91, 160.186, 0), +(@PATH, 6, 627.218, -1131.61, 159.535, 0), +(@PATH, 7, 631.939, -1149.35, 155.421, 0), +(@PATH, 8, 629.934, -1192.34, 145.181, 0), +(@PATH, 9, 633.981, -1229.12, 136.877, 0), +(@PATH, 10, 634.73, -1271.43, 121.429, 0), +(@PATH, 11, 627.306, -1321.81, 106.197, 0), +(@PATH, 12, 629.422, -1375.57, 93.9589, 0), +(@PATH, 13, 643.925, -1408.88, 87.1831, 0), +(@PATH, 14, 668.443, -1437.6, 81.8552, 0), +(@PATH, 15, 708.689, -1455.94, 81.4619, 0), +(@PATH, 16, 745.689, -1459.7, 80.3421, 0), +(@PATH, 17, 708.769, -1455.86, 81.4599, 0), +(@PATH, 18, 667.903, -1437.37, 81.9153, 0), +(@PATH, 19, 643.733, -1408.63, 87.2146, 0), +(@PATH, 20, 629.19, -1375.19, 94.0446, 0), +(@PATH, 21, 627.374, -1321.59, 106.257, 0), +(@PATH, 22, 634.783, -1271.27, 121.478, 0), +(@PATH, 23, 633.98, -1228.57, 137.007, 0), +(@PATH, 24, 629.947, -1191.76, 145.328, 0), +(@PATH, 25, 631.939, -1148.87, 155.504, 0), +(@PATH, 26, 627.116, -1131.07, 159.662, 0), +(@PATH, 27, 620.092, -1114.7, 160.189, 0), +(@PATH, 28, 622.218, -1054.98, 163.22, 0), +(@PATH, 29, 634.789, -1041.15, 163.826, 0), +(@PATH, 30, 653.802, -1032.34, 163.225, 0); + +SET @NPC := 16063; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -465.079, -1483.15, 91.3678, 0), +(@PATH, 2, -467.233, -1486.83, 90.5257, 0), +(@PATH, 3, -464.421, -1495.3, 91.425, 0), +(@PATH, 4, -454.225, -1500.16, 91.8668, 0), +(@PATH, 5, -446.071, -1499.21, 91.9905, 0), +(@PATH, 6, -442.776, -1497.46, 91.9792, 0), +(@PATH, 7, -440.182, -1493.51, 92.1425, 0), +(@PATH, 8, -436.129, -1488.06, 92.78, 0), +(@PATH, 9, -434.729, -1487.67, 92.8071, 10000), +(@PATH, 10, -432.722, -1478, 91.4113, 0), +(@PATH, 11, -438.389, -1473.16, 92.3992, 0), +(@PATH, 12, -446.335, -1473.44, 93.0333, 0), +(@PATH, 13, -448.837, -1472.8, 92.9958, 0), +(@PATH, 14, -455.776, -1468.62, 90.6475, 0), +(@PATH, 15, -466.101, -1470.41, 89.0591, 0), +(@PATH, 16, -466.279, -1476.68, 90.047, 0); + +SET @NPC := 32043; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -13807.7, 379.781, 94.488, 60000), +(@PATH, 2, -13809.4, 381.717, 94.6764, 0), +(@PATH, 3, -13814.3, 389.438, 89.217, 0), +(@PATH, 4, -13818.9, 396.468, 86.5581, 0), +(@PATH, 5, -13823.5, 402.931, 85.7407, 0), +(@PATH, 6, -13827.6, 409.323, 86.24, 0), +(@PATH, 7, -13832.7, 417.115, 88.7387, 0), +(@PATH, 8, -13836.6, 423.11, 92.1478, 0), +(@PATH, 9, -13838, 425.191, 91.6924, 30000), +(@PATH, 10, -13836.7, 423.38, 92.0456, 0), +(@PATH, 11, -13832.4, 416.564, 88.5122, 0), +(@PATH, 12, -13827.3, 408.334, 86.0611, 0), +(@PATH, 13, -13822.5, 401.616, 85.8104, 0), +(@PATH, 14, -13817.5, 393.823, 87.325, 0), +(@PATH, 15, -13813.2, 387.202, 90.234, 0), +(@PATH, 16, -13809.5, 381.667, 94.651, 0), +(@PATH, 17, -13807.7, 379.781, 94.488, 60000); + +SET @NPC := 1888; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -4686.15, -1255.14, 501.993, 0), +(@PATH, 2, -4675.92, -1244.38, 501.993, 0), +(@PATH, 3, -4667.5, -1245.78, 501.993, 0), +(@PATH, 4, -4661.6, -1250.52, 503.382, 0), +(@PATH, 5, -4661.6, -1250.52, 503.382, 60000), +(@PATH, 6, -4670.11, -1243.08, 501.993, 0), +(@PATH, 7, -4681.15, -1244.8, 501.993, 0), +(@PATH, 8, -4686.53, -1252.01, 501.993, 0), +(@PATH, 9, -4685.42, -1262.68, 501.993, 0), +(@PATH, 10, -4681.39, -1266.61, 503.382, 0), +(@PATH, 11, -4681.39, -1266.61, 503.382, 60000); + +SET @NPC := 20429; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 591.098, -1326.51, 92.2916, 0), +(@PATH, 2, 605.883, -1321.84, 91.7916, 0), +(@PATH, 3, 624.948, -1316.58, 91.7916, 0), +(@PATH, 4, 643.687, -1307.64, 91.7916, 0), +(@PATH, 5, 668.631, -1300.92, 91.7916, 0), +(@PATH, 6, 692.319, -1303.29, 91.7916, 0), +(@PATH, 7, 718.773, -1311.1, 91.8569, 0), +(@PATH, 8, 742.36, -1321.82, 92.6459, 0), +(@PATH, 9, 754.919, -1329.23, 91.7916, 0), +(@PATH, 10, 761.752, -1348.34, 91.7288, 0), +(@PATH, 11, 758.361, -1361.86, 91.7288, 0), +(@PATH, 12, 746.012, -1375.54, 91.7916, 0), +(@PATH, 13, 722.187, -1385.72, 91.7916, 0), +(@PATH, 14, 699.241, -1382.39, 91.7916, 0), +(@PATH, 15, 686.015, -1369.51, 91.7916, 0), +(@PATH, 16, 675.795, -1361.89, 91.7916, 0), +(@PATH, 17, 665.328, -1355.35, 91.7916, 0), +(@PATH, 18, 652.188, -1344.57, 91.7916, 0), +(@PATH, 19, 636.429, -1334.76, 91.7916, 0), +(@PATH, 20, 628.536, -1323.14, 91.7916, 0), +(@PATH, 21, 623.619, -1314.03, 91.7916, 0), +(@PATH, 22, 615.407, -1298.6, 91.7917, 0), +(@PATH, 23, 604.114, -1284.03, 91.7917, 0), +(@PATH, 24, 587.851, -1269.01, 92.0619, 0), +(@PATH, 25, 576.031, -1259.97, 91.7916, 0), +(@PATH, 26, 560.895, -1256.68, 92.0468, 0), +(@PATH, 27, 545.482, -1255.18, 91.8714, 0), +(@PATH, 28, 534.852, -1253.39, 91.7916, 0), +(@PATH, 29, 526.591, -1260.62, 91.7916, 0), +(@PATH, 30, 510.401, -1285.22, 91.7916, 0), +(@PATH, 31, 510.391, -1306.54, 91.7916, 0), +(@PATH, 32, 515.124, -1321.95, 91.7916, 0), +(@PATH, 33, 521.895, -1336.84, 91.7917, 0), +(@PATH, 34, 529.782, -1343.76, 91.7917, 0), +(@PATH, 35, 556.792, -1356.99, 91.7917, 0), +(@PATH, 36, 567.064, -1368.91, 91.7916, 0), +(@PATH, 37, 574.606, -1382.9, 91.7916, 0), +(@PATH, 38, 578.411, -1399.87, 93.3668, 0), +(@PATH, 39, 584.315, -1420.1, 91.7917, 0), +(@PATH, 40, 588.742, -1440.73, 91.7917, 0), +(@PATH, 41, 577.568, -1461.41, 92.6667, 0), +(@PATH, 42, 567.409, -1473.39, 92.4488, 0), +(@PATH, 43, 555.569, -1487.63, 91.7917, 0), +(@PATH, 44, 538.345, -1499.21, 93.1349, 0), +(@PATH, 45, 517.216, -1501.07, 94.5103, 0), +(@PATH, 46, 492.097, -1496.38, 94.3223, 0), +(@PATH, 47, 474.586, -1480.68, 93.079, 0), +(@PATH, 48, 464.53, -1462.18, 91.7917, 0), +(@PATH, 49, 460.698, -1444.19, 91.7917, 0), +(@PATH, 50, 466.94, -1424.12, 91.7917, 0), +(@PATH, 51, 470.694, -1413.05, 91.7917, 0), +(@PATH, 52, 482.416, -1399.12, 91.7917, 0), +(@PATH, 53, 502.072, -1380.88, 91.7917, 0), +(@PATH, 54, 527.991, -1362.11, 91.7917, 0), +(@PATH, 55, 542.13, -1349.18, 91.7917, 0), +(@PATH, 56, 562.347, -1341.45, 91.8798, 0), +(@PATH, 57, 578.54, -1335.66, 92.8374, 0); + +SET @NPC := 51808; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 1061.99, -3086.34, 105.125, 0), +(@PATH, 2, 1061.63, -3082.63, 105.125, 0), +(@PATH, 3, 1060.18, -3079.97, 105.125, 0), +(@PATH, 4, 1058.07, -3075.87, 105.501, 0), +(@PATH, 5, 1054.89, -3071.72, 105.125, 0), +(@PATH, 6, 1051.25, -3069.85, 105.125, 0), +(@PATH, 7, 1047.29, -3069.88, 105.289, 0), +(@PATH, 8, 1043.63, -3072.36, 105.72, 0), +(@PATH, 9, 1038.3, -3076.43, 105.328, 0), +(@PATH, 10, 1033.59, -3075.67, 105.125, 0), +(@PATH, 11, 1031.4, -3070.74, 105.125, 0), +(@PATH, 12, 1030.16, -3066.55, 105.089, 0), +(@PATH, 13, 1031.58, -3060.08, 102.155, 0), +(@PATH, 14, 1032.79, -3056.73, 100.41, 0), +(@PATH, 15, 1035.06, -3054.11, 98.9656, 0), +(@PATH, 16, 1039.28, -3052.89, 98.4566, 0), +(@PATH, 17, 1043.78, -3054.49, 96.88, 0), +(@PATH, 18, 1049.61, -3058.21, 93.9174, 0), +(@PATH, 19, 1053.44, -3062.93, 91.8125, 0), +(@PATH, 20, 1055.31, -3067.91, 91.7175, 0), +(@PATH, 21, 1057.02, -3073.87, 91.7479, 0), +(@PATH, 22, 1058.28, -3077.77, 91.7453, 0), +(@PATH, 23, 1059.49, -3082.52, 91.7453, 0), +(@PATH, 24, 1059.71, -3086.14, 91.7453, 0), +(@PATH, 25, 1054.99, -3091.56, 89.7105, 0), +(@PATH, 26, 1051.96, -3093.6, 87.6199, 0), +(@PATH, 27, 1047.68, -3095.38, 84.8705, 0), +(@PATH, 28, 1043.32, -3097.01, 82.0536, 0), +(@PATH, 29, 1039.55, -3097.98, 80.947, 0), +(@PATH, 30, 1032.46, -3100.74, 80.947, 0), +(@PATH, 31, 1028.6, -3104.47, 80.9988, 0), +(@PATH, 32, 1025.1, -3106.79, 80.9988, 0), +(@PATH, 33, 1021.45, -3109.21, 80.9988, 0), +(@PATH, 34, 1017.71, -3109.38, 80.8207, 0), +(@PATH, 35, 1017.25, -3113.85, 80.9386, 0), +(@PATH, 36, 1015.24, -3116.81, 81.2594, 0), +(@PATH, 37, 1013.11, -3118.45, 81.7116, 0), +(@PATH, 38, 1010.26, -3117.7, 81.9643, 0), +(@PATH, 39, 1009.36, -3115.54, 81.937, 0), +(@PATH, 40, 1009.97, -3111.18, 81.4586, 0), +(@PATH, 41, 1012.35, -3109.55, 80.8596, 0), +(@PATH, 42, 1013.99, -3110.13, 80.9735, 0), +(@PATH, 43, 1019.78, -3109.27, 81.4185, 0), +(@PATH, 44, 1023.76, -3107.68, 80.9988, 0), +(@PATH, 45, 1026.93, -3105.58, 80.9988, 0), +(@PATH, 46, 1036.32, -3099.22, 80.947, 0), +(@PATH, 47, 1043.88, -3096.5, 82.475, 0), +(@PATH, 48, 1048.61, -3095.18, 85.4422, 0), +(@PATH, 49, 1054.6, -3092.41, 89.3336, 0), +(@PATH, 50, 1058.68, -3089.17, 91.7453, 0), +(@PATH, 51, 1060.6, -3083.75, 91.7453, 0), +(@PATH, 52, 1059.44, -3080.28, 91.7453, 0), +(@PATH, 53, 1058.01, -3076.83, 91.7453, 0), +(@PATH, 54, 1055.77, -3074.57, 91.7423, 0), +(@PATH, 55, 1053.49, -3072.35, 91.7432, 0), +(@PATH, 56, 1048.93, -3072.95, 91.7355, 0), +(@PATH, 57, 1041.48, -3075.29, 91.7333, 0), +(@PATH, 58, 1037.06, -3077.86, 91.772, 0), +(@PATH, 59, 1030.98, -3080.97, 91.754, 0), +(@PATH, 60, 1023.38, -3082.19, 91.7347, 0), +(@PATH, 61, 1015.59, -3080.34, 91.7187, 0), +(@PATH, 62, 1016.86, -3076.98, 91.7257, 0), +(@PATH, 63, 1019.51, -3077.52, 91.7313, 0), +(@PATH, 64, 1020.74, -3079.89, 91.7313, 0), +(@PATH, 65, 1023.99, -3081.43, 91.7371, 0), +(@PATH, 66, 1030.16, -3080.52, 91.7526, 0), +(@PATH, 67, 1035.14, -3078.67, 91.7665, 0), +(@PATH, 68, 1039.21, -3076.15, 91.7333, 0), +(@PATH, 69, 1044.73, -3073.75, 91.7319, 0), +(@PATH, 70, 1048.53, -3072.01, 91.7309, 0), +(@PATH, 71, 1052.28, -3069.47, 91.7492, 0), +(@PATH, 72, 1053.24, -3067.04, 91.762, 0), +(@PATH, 73, 1052.29, -3063.9, 91.6417, 0), +(@PATH, 74, 1051.01, -3060.32, 93.14, 0), +(@PATH, 75, 1046.46, -3055.47, 95.4885, 0), +(@PATH, 76, 1043.44, -3054.26, 97.0918, 0), +(@PATH, 77, 1039.26, -3053.32, 98.4449, 0), +(@PATH, 78, 1035.71, -3054.8, 98.9815, 0), +(@PATH, 79, 1033.22, -3056.35, 100.144, 0), +(@PATH, 80, 1030.55, -3058.91, 101.872, 0), +(@PATH, 81, 1029.75, -3062.89, 103.991, 0), +(@PATH, 82, 1028.89, -3066.46, 105.069, 0), +(@PATH, 83, 1027.57, -3071.8, 105.125, 0), +(@PATH, 84, 1026.92, -3074.34, 105.162, 0), +(@PATH, 85, 1029.29, -3078.58, 105.125, 0), +(@PATH, 86, 1031.8, -3080.06, 105.125, 0), +(@PATH, 87, 1034.15, -3084.09, 105.125, 0), +(@PATH, 88, 1035.67, -3087.39, 104.984, 0), +(@PATH, 89, 1037.77, -3091.23, 104.72, 0), +(@PATH, 90, 1040.77, -3093.77, 105.026, 0), +(@PATH, 91, 1044.16, -3096.44, 105.432, 0), +(@PATH, 92, 1048.07, -3097.35, 105.649, 0), +(@PATH, 93, 1055.78, -3094.85, 105.575, 0), +(@PATH, 94, 1059.14, -3093.44, 105.497, 0), +(@PATH, 95, 1060.82, -3089.71, 105.229, 0); + +SET @NPC := 13174; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 265.967, -3050.67, 96.9215, 0), +(@PATH, 2, 263.672, -3047.96, 96.6652, 0), +(@PATH, 3, 260.558, -3038.18, 96.7407, 0), +(@PATH, 4, 262.355, -3036.13, 96.991, 0), +(@PATH, 5, 261.47, -3036.78, 96.9617, 60000), +(@PATH, 6, 259.89, -3038.7, 96.5728, 0), +(@PATH, 7, 265.967, -3050.67, 96.9215, 0), +(@PATH, 8, 265.967, -3050.67, 96.9215, 30000); + +SET @NPC := 30137; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -440.007, 40.4573, -208.528, 0), +(@PATH, 2, -403.428, 48.1517, -208.92, 0), +(@PATH, 3, -393.459, 63.5904, -209.678, 0), +(@PATH, 4, -406.709, 75.8918, -210.99, 0), +(@PATH, 5, -421.506, 82.5705, -210.045, 0), +(@PATH, 6, -428.759, 100.234, -209.626, 0), +(@PATH, 7, -409.098, 109.523, -210.525, 0), +(@PATH, 8, -393.271, 112.121, -209.804, 0), +(@PATH, 9, -380.83, 95.3402, -210.582, 0), +(@PATH, 10, -372.115, 112.371, -209.234, 0), +(@PATH, 11, -372.697, 137.794, -208.769, 0), +(@PATH, 12, -396.703, 139.501, -210.381, 0), +(@PATH, 13, -372.697, 137.794, -208.769, 0), +(@PATH, 14, -396.703, 139.501, -210.381, 0), +(@PATH, 15, -372.697, 137.794, -208.769, 0), +(@PATH, 16, -372.115, 112.371, -209.234, 0), +(@PATH, 17, -380.83, 95.3402, -210.582, 0), +(@PATH, 18, -393.271, 112.121, -209.804, 0), +(@PATH, 19, -409.098, 109.523, -210.525, 0), +(@PATH, 20, -428.759, 100.234, -209.626, 0), +(@PATH, 21, -421.506, 82.5705, -210.045, 0), +(@PATH, 22, -406.709, 75.8918, -210.99, 0), +(@PATH, 23, -393.459, 63.5904, -209.678, 0), +(@PATH, 24, -403.428, 48.1517, -208.92, 0), +(@PATH, 25, -440.007, 40.4573, -208.528, 0), +(@PATH, 26, -471.277, 47.9361, -208.061, 0); + +SET @NPC := 82469; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -517.333, -4054.25, 216.023, 0), +(@PATH, 2, -528.477, -4075.78, 215.853, 0), +(@PATH, 3, -530.916, -4084.3, 215.575, 0), +(@PATH, 4, -547.423, -4085.67, 216.281, 0), +(@PATH, 5, -558.864, -4085.86, 225.49, 0), +(@PATH, 6, -570.652, -4085.87, 234.629, 0), +(@PATH, 7, -578.233, -4085.87, 240.068, 0), +(@PATH, 8, -593.878, -4085.89, 238.362, 0), +(@PATH, 9, -616.638, -4064.5, 238.217, 0), +(@PATH, 10, -616.833, -4047.42, 238.046, 0), +(@PATH, 11, -652.808, -4040.06, 238.274, 0), +(@PATH, 12, -672.615, -4022.63, 238.229, 0), +(@PATH, 13, -676.225, -4016.49, 238.145, 0), +(@PATH, 14, -672.621, -4011.21, 238.248, 0), +(@PATH, 15, -664.151, -4010.24, 238.159, 0), +(@PATH, 16, -655.342, -4029.7, 238.255, 0), +(@PATH, 17, -637.653, -4043.85, 238.07, 0), +(@PATH, 18, -624.501, -4043.49, 238.073, 0), +(@PATH, 19, -617.972, -4032.87, 237.873, 0), +(@PATH, 20, -617.911, -3980.06, 238.482, 0), +(@PATH, 21, -611.216, -3963.89, 238.351, 0), +(@PATH, 22, -570.672, -3938.64, 238.326, 0), +(@PATH, 23, -568.836, -3931.76, 237.925, 0), +(@PATH, 24, -556.458, -3939.03, 237.937, 0), +(@PATH, 25, -537.875, -3940.39, 238.764, 0), +(@PATH, 26, -566.704, -3951.51, 238.427, 0), +(@PATH, 27, -613.806, -3933.84, 238.346, 0), +(@PATH, 28, -620.501, -3938.32, 238.463, 0), +(@PATH, 29, -616.96, -3970.3, 238.351, 0), +(@PATH, 30, -618.1, -4023.04, 237.988, 0), +(@PATH, 31, -617.327, -4059.77, 238.279, 0), +(@PATH, 32, -624.179, -4061.62, 238.351, 0), +(@PATH, 33, -638.711, -4062.04, 247.263, 0), +(@PATH, 34, -618.277, -4063.46, 238.307, 0), +(@PATH, 35, -602.99, -4082.45, 238.351, 0), +(@PATH, 36, -600.118, -4115.69, 238.504, 0), +(@PATH, 37, -610.419, -4140.24, 238.351, 0), +(@PATH, 38, -599.085, -4160.05, 238.431, 0), +(@PATH, 39, -593.493, -4164.29, 238.355, 0), +(@PATH, 40, -587.6, -4160.74, 238.352, 0), +(@PATH, 41, -593.862, -4137.4, 238.387, 0), +(@PATH, 42, -629.492, -4119.94, 238.351, 0), +(@PATH, 43, -642.951, -4106.99, 238.504, 0), +(@PATH, 44, -591.144, -4085.34, 238.368, 0), +(@PATH, 45, -577.325, -4085.64, 239.868, 0), +(@PATH, 46, -564.315, -4085.87, 229.775, 0), +(@PATH, 47, -544.956, -4085.42, 215.861, 0), +(@PATH, 48, -532.116, -4085.08, 215.547, 0), +(@PATH, 49, -529.232, -4073.31, 215.856, 0), +(@PATH, 50, -539.105, -4053.94, 216.756, 0), +(@PATH, 51, -531.195, -4035.23, 215.861, 0), +(@PATH, 52, -505.494, -4008.01, 215.944, 0), +(@PATH, 53, -524.022, -4030.32, 215.86, 0), +(@PATH, 54, -524.191, -4036.51, 215.86, 0); + +SET @NPC := 51892; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 8028.81, -3947.21, 687.148, 0), +(@PATH, 2, 8037.27, -3942.65, 687.148, 0), +(@PATH, 3, 8046.58, -3938.14, 687.148, 0), +(@PATH, 4, 8052.15, -3930.23, 687.148, 0), +(@PATH, 5, 8053.36, -3919.33, 687.148, 0), +(@PATH, 6, 8042.46, -3905.25, 687.148, 0), +(@PATH, 7, 8036.6, -3897.28, 687.148, 0), +(@PATH, 8, 8026.45, -3889.37, 687.148, 0), +(@PATH, 9, 8018.81, -3883.73, 687.148, 0), +(@PATH, 10, 8010.6, -3876.31, 687.148, 0), +(@PATH, 11, 8000.86, -3872.12, 687.148, 0), +(@PATH, 12, 7992.01, -3874.47, 687.148, 0), +(@PATH, 13, 7985.67, -3879.9, 687.148, 0), +(@PATH, 14, 7980.29, -3887.23, 687.148, 0), +(@PATH, 15, 7982.96, -3899.09, 687.148, 0), +(@PATH, 16, 7988.21, -3905.68, 687.148, 0), +(@PATH, 17, 8000.71, -3905.21, 687.148, 0), +(@PATH, 18, 8007.1, -3908.7, 687.148, 0), +(@PATH, 19, 8012.04, -3917.68, 687.148, 0), +(@PATH, 20, 8013.97, -3929.08, 687.148, 0), +(@PATH, 21, 8014.29, -3941.99, 687.148, 0), +(@PATH, 22, 8018.94, -3946.64, 687.148, 0); + +SET @NPC := 51890; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 6019.5, -5040.97, 784.711, 0), +(@PATH, 2, 6064.57, -5021.38, 783.769, 0), +(@PATH, 3, 6110.54, -5029.36, 791.502, 0), +(@PATH, 4, 6143.76, -5048.5, 788.654, 0), +(@PATH, 5, 6182.44, -5064.91, 783.375, 0), +(@PATH, 6, 6224.19, -5048.12, 777.578, 0), +(@PATH, 7, 6255.66, -5044.65, 774.014, 0), +(@PATH, 8, 6295.05, -5045.93, 768.919, 0), +(@PATH, 9, 6333.05, -5046.23, 760.895, 0), +(@PATH, 10, 6378.59, -5045.98, 751.77, 0), +(@PATH, 11, 6408.91, -5042.45, 747.104, 0), +(@PATH, 12, 6438.63, -5018.77, 739.467, 0), +(@PATH, 13, 6466.92, -4989.89, 733.592, 0), +(@PATH, 14, 6484.62, -4964.16, 728.388, 0), +(@PATH, 15, 6500.9, -4934.62, 725.975, 0), +(@PATH, 16, 6510.16, -4904.85, 721.889, 0), +(@PATH, 17, 6535.35, -4877.96, 709.66, 0), +(@PATH, 18, 6559.99, -4860.92, 701.898, 0), +(@PATH, 19, 6560.69, -4846.94, 702.04, 0), +(@PATH, 20, 6551.32, -4819.47, 703.502, 0), +(@PATH, 21, 6550.17, -4785.08, 698.355, 0), +(@PATH, 22, 6574.48, -4751.12, 696.631, 0), +(@PATH, 23, 6583.19, -4721.82, 699.985, 0), +(@PATH, 24, 6580.94, -4680.03, 700.68, 0), +(@PATH, 25, 6568.84, -4646.38, 694.206, 0), +(@PATH, 26, 6559.54, -4618.04, 699.164, 0), +(@PATH, 27, 6552.84, -4585.88, 703.999, 0), +(@PATH, 28, 6525.88, -4563, 713.348, 0), +(@PATH, 29, 6495.58, -4547.87, 716.137, 0), +(@PATH, 30, 6458.24, -4526.25, 723.902, 0), +(@PATH, 31, 6450.27, -4486.06, 733.411, 0), +(@PATH, 32, 6460.92, -4454.01, 729.607, 0), +(@PATH, 33, 6449.63, -4421.93, 723.395, 0), +(@PATH, 34, 6424.51, -4403.56, 722.54, 0), +(@PATH, 35, 6389.61, -4387.15, 731.328, 0), +(@PATH, 36, 6364.21, -4363.73, 738.533, 0), +(@PATH, 37, 6362.86, -4328.88, 726.908, 0), +(@PATH, 38, 6356.48, -4298.46, 720.34, 0), +(@PATH, 39, 6338.97, -4285.14, 725.533, 0), +(@PATH, 40, 6317.18, -4280.97, 733.071, 0), +(@PATH, 41, 6280.01, -4269.13, 735.894, 0), +(@PATH, 42, 6258.96, -4251.5, 735.476, 0), +(@PATH, 43, 6260.61, -4236.57, 734.086, 0), +(@PATH, 44, 6286.39, -4221.5, 724.38, 0), +(@PATH, 45, 6327.71, -4218.92, 721.23, 0), +(@PATH, 46, 6365.36, -4205.96, 711.091, 0), +(@PATH, 47, 6380.78, -4186.57, 705.823, 0), +(@PATH, 48, 6365.36, -4205.96, 711.091, 0), +(@PATH, 49, 6327.71, -4218.92, 721.23, 0), +(@PATH, 50, 6286.39, -4221.5, 724.38, 0), +(@PATH, 51, 6260.61, -4236.57, 734.086, 0), +(@PATH, 52, 6258.96, -4251.5, 735.476, 0), +(@PATH, 53, 6280.01, -4269.13, 735.894, 0), +(@PATH, 54, 6317.18, -4280.97, 733.071, 0), +(@PATH, 55, 6338.89, -4285.09, 725.661, 0), +(@PATH, 56, 6356.4, -4298.41, 720.158, 0), +(@PATH, 57, 6362.86, -4328.88, 726.908, 0), +(@PATH, 58, 6364.21, -4363.73, 738.533, 0), +(@PATH, 59, 6389.61, -4387.15, 731.328, 0), +(@PATH, 60, 6424.51, -4403.56, 722.54, 0), +(@PATH, 61, 6449.63, -4421.93, 723.395, 0), +(@PATH, 62, 6460.92, -4454.01, 729.607, 0), +(@PATH, 63, 6450.27, -4486.06, 733.411, 0), +(@PATH, 64, 6458.24, -4526.25, 723.902, 0), +(@PATH, 65, 6495.58, -4547.87, 716.137, 0), +(@PATH, 66, 6525.88, -4563, 713.348, 0), +(@PATH, 67, 6552.84, -4585.88, 703.999, 0), +(@PATH, 68, 6559.54, -4618.04, 699.164, 0), +(@PATH, 69, 6568.84, -4646.38, 694.206, 0), +(@PATH, 70, 6580.94, -4680.03, 700.68, 0), +(@PATH, 71, 6583.19, -4721.82, 699.985, 0), +(@PATH, 72, 6574.48, -4751.12, 696.631, 0), +(@PATH, 73, 6550.17, -4785.08, 698.355, 0), +(@PATH, 74, 6551.27, -4819.07, 703.502, 0), +(@PATH, 75, 6560.69, -4846.88, 702.222, 0), +(@PATH, 76, 6560, -4860.85, 701.915, 0), +(@PATH, 77, 6535.35, -4877.96, 709.66, 0), +(@PATH, 78, 6510.16, -4904.85, 721.889, 0), +(@PATH, 79, 6500.9, -4934.62, 725.975, 0), +(@PATH, 80, 6484.62, -4964.16, 728.388, 0), +(@PATH, 81, 6466.92, -4989.89, 733.592, 0), +(@PATH, 82, 6438.63, -5018.77, 739.511, 0), +(@PATH, 83, 6408.91, -5042.45, 747.104, 0), +(@PATH, 84, 6378.59, -5045.98, 751.77, 0), +(@PATH, 85, 6333.25, -5046.22, 760.899, 0), +(@PATH, 86, 6295.05, -5045.93, 768.919, 0), +(@PATH, 87, 6255.66, -5044.65, 774.014, 0), +(@PATH, 88, 6224.25, -5048.05, 777.68, 0), +(@PATH, 89, 6182.59, -5064.94, 783.429, 0), +(@PATH, 90, 6143.76, -5048.5, 788.654, 0), +(@PATH, 91, 6110.54, -5029.36, 791.502, 0), +(@PATH, 92, 6064.57, -5021.38, 783.769, 0), +(@PATH, 93, 6019.5, -5040.97, 784.711, 0), +(@PATH, 94, 5977.62, -5059.16, 798.207, 0); + +SET @NPC := 42143; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 2036.66, -353.643, 35.4522, 0), +(@PATH, 2, 2043.96, -354.653, 35.4522, 0), +(@PATH, 3, 2046.38, -360.966, 35.4522, 0), +(@PATH, 4, 2042.16, -387.225, 35.4522, 0), +(@PATH, 5, 2036.03, -407.443, 35.4522, 0), +(@PATH, 6, 2020.62, -414.319, 35.4522, 0), +(@PATH, 7, 1988.4, -419.329, 35.4522, 0), +(@PATH, 8, 1967.26, -416.863, 35.4522, 0), +(@PATH, 9, 1962.46, -408.135, 35.4522, 0), +(@PATH, 10, 1965.09, -379.317, 35.4522, 0), +(@PATH, 11, 1967.55, -353.692, 35.4523, 0), +(@PATH, 12, 1974.3, -347.861, 35.4523, 0), +(@PATH, 13, 2013.4, -354.364, 35.4523, 0); + +SET @NPC := 41758; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 5794.21, -4756.73, 776.631, 0), +(@PATH, 2, 5767.78, -4750.23, 776.266, 0), +(@PATH, 3, 5741.93, -4739.3, 776.337, 0), +(@PATH, 4, 5729.39, -4728.64, 776.861, 0), +(@PATH, 5, 5716.83, -4712.63, 780.549, 0), +(@PATH, 6, 5701.37, -4690.78, 780.221, 0), +(@PATH, 7, 5685.64, -4666.45, 775.247, 0), +(@PATH, 8, 5663.94, -4633.49, 770.941, 0), +(@PATH, 9, 5652.06, -4612.04, 769.91, 0), +(@PATH, 10, 5605.16, -4523.35, 761.301, 0), +(@PATH, 11, 5596.44, -4510.74, 761.037, 0), +(@PATH, 12, 5578.46, -4501.28, 758.607, 0), +(@PATH, 13, 5546.2, -4498.32, 757.152, 0), +(@PATH, 14, 5536.28, -4498.46, 756.273, 0), +(@PATH, 15, 5548.03, -4498.12, 757.283, 0), +(@PATH, 16, 5580.57, -4501.62, 758.791, 0), +(@PATH, 17, 5596.8, -4510.74, 761.013, 0), +(@PATH, 18, 5607.1, -4525.25, 761.14, 0), +(@PATH, 19, 5652.85, -4611.9, 769.809, 0), +(@PATH, 20, 5663.82, -4632.54, 770.918, 0), +(@PATH, 21, 5688.06, -4666.14, 775.173, 0), +(@PATH, 22, 5701.32, -4688.96, 779.968, 0), +(@PATH, 23, 5716.02, -4709.93, 780.711, 0), +(@PATH, 24, 5732.58, -4729.74, 776.94, 0), +(@PATH, 25, 5743.5, -4739.83, 776.143, 0), +(@PATH, 26, 5768.83, -4750.62, 776.265, 0), +(@PATH, 27, 5791.36, -4756.39, 776.534, 0), +(@PATH, 28, 5800.65, -4754.66, 775.339, 0), +(@PATH, 29, 5810.53, -4747.72, 770.679, 0), +(@PATH, 30, 5825.56, -4722.8, 761.2, 0), +(@PATH, 31, 5847.45, -4695.13, 756.06, 0), +(@PATH, 32, 5846.56, -4653.15, 751.855, 0), +(@PATH, 33, 5852.02, -4626.78, 748.715, 0), +(@PATH, 34, 5857.67, -4617.24, 746.566, 0), +(@PATH, 35, 5873.96, -4604.09, 740.28, 0), +(@PATH, 36, 5906.14, -4580.95, 726.465, 0), +(@PATH, 37, 5933.6, -4552.5, 719.467, 0), +(@PATH, 38, 5948.97, -4526.39, 714.178, 0), +(@PATH, 39, 5966, -4490.83, 706.834, 0), +(@PATH, 40, 5983.18, -4454.48, 707.231, 0), +(@PATH, 41, 6004.34, -4417.37, 710.368, 0), +(@PATH, 42, 6043.83, -4367.21, 715.066, 0), +(@PATH, 43, 6083.28, -4327.06, 725.178, 0), +(@PATH, 44, 6120.37, -4306.62, 731.31, 0), +(@PATH, 45, 6166.59, -4284.45, 744.508, 0), +(@PATH, 46, 6191.89, -4270.68, 738.337, 0), +(@PATH, 47, 6245.56, -4242.19, 736.044, 0), +(@PATH, 48, 6307.77, -4218.71, 722.994, 0), +(@PATH, 49, 6355.26, -4200.94, 713.745, 0), +(@PATH, 50, 6392.92, -4182.05, 703.888, 0), +(@PATH, 51, 6357.57, -4201.57, 713.224, 0), +(@PATH, 52, 6311.36, -4220.95, 723.374, 0), +(@PATH, 53, 6246.39, -4244.92, 735.806, 0), +(@PATH, 54, 6192.39, -4270.93, 738.002, 0), +(@PATH, 55, 6168.06, -4284.54, 744.458, 0), +(@PATH, 56, 6124.04, -4304.35, 731.797, 0), +(@PATH, 57, 6081.23, -4327.11, 724.821, 0), +(@PATH, 58, 6044.83, -4366.46, 715.08, 0), +(@PATH, 59, 6007.47, -4413.15, 710.907, 0), +(@PATH, 60, 5983.53, -4455.11, 707.048, 0), +(@PATH, 61, 5965.38, -4490.02, 706.943, 0), +(@PATH, 62, 5948.68, -4526.07, 714.223, 0), +(@PATH, 63, 5934.61, -4551.4, 719.322, 0), +(@PATH, 64, 5907.66, -4580.78, 725.546, 0), +(@PATH, 65, 5873.21, -4606.02, 740.637, 0), +(@PATH, 66, 5862.26, -4614.75, 744.791, 0), +(@PATH, 67, 5853.82, -4625.17, 748.087, 0), +(@PATH, 68, 5845.46, -4654.04, 752.156, 0), +(@PATH, 69, 5844.74, -4689.32, 755.539, 0), +(@PATH, 70, 5824.63, -4722.99, 761.315, 0), +(@PATH, 71, 5809.48, -4746.69, 770.559, 0), +(@PATH, 72, 5799.53, -4755.23, 775.666, 0); + +SET @NPC := 84572; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 16, -7418.69, -947.728, 464.981, 0), +(@PATH, 15, -7443.95, -908.115, 465.328, 0), +(@PATH, 14, -7458.05, -889.8, 465.217, 0), +(@PATH, 13, -7481.39, -906.596, 465.227, 0), +(@PATH, 12, -7507.17, -922.419, 457.856, 0), +(@PATH, 11, -7495.77, -939.653, 457.895, 0), +(@PATH, 10, -7475.22, -969.278, 449.776, 0), +(@PATH, 9, -7483.98, -998.087, 449.079, 0), +(@PATH, 8, -7513.29, -1020.49, 448.906, 0), +(@PATH, 7, -7483.98, -998.087, 449.079, 0), +(@PATH, 6, -7475.22, -969.278, 449.776, 0), +(@PATH, 5, -7495.89, -939.483, 457.856, 0), +(@PATH, 4, -7507.17, -922.419, 457.856, 0), +(@PATH, 3, -7481.37, -906.587, 465.228, 0), +(@PATH, 2, -7458.05, -889.8, 465.217, 0), +(@PATH, 1, -7443.8, -908.338, 465.355, 0); + +SET @NPC := 90511; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 1129.87, -260.801, 33.1925, 0), +(@PATH, 2, 1099.4, -246.603, 33.2646, 0), +(@PATH, 3, 1043.01, -218.998, 32.6469, 0), +(@PATH, 4, 987.828, -183.095, 32.6947, 0), +(@PATH, 5, 944.295, -133.382, 32.326, 0), +(@PATH, 6, 896.154, -88.7433, 32.8252, 0), +(@PATH, 7, 822.507, -69.9838, 32.5853, 0), +(@PATH, 8, 777.692, -43.3707, 33.055, 0), +(@PATH, 9, 724.597, 15.5293, 32.9236, 0), +(@PATH, 10, 681.48, 86.9326, 32.6039, 0), +(@PATH, 11, 614.492, 189.908, 33.3183, 0), +(@PATH, 12, 555.051, 231.309, 33.459, 0), +(@PATH, 13, 517.042, 274.988, 33.0772, 0), +(@PATH, 14, 525.949, 251.626, 33.3941, 0), +(@PATH, 15, 569.713, 221.093, 31.6346, 0), +(@PATH, 16, 632.957, 163.248, 32.4543, 0), +(@PATH, 17, 667.423, 98.5867, 33.6662, 0), +(@PATH, 18, 711.496, 41.1962, 31.6577, 0), +(@PATH, 19, 745.464, -14.5894, 33.0865, 0), +(@PATH, 20, 801.702, -56.7232, 31.9294, 0), +(@PATH, 21, 869.771, -83.0213, 32.9922, 0), +(@PATH, 22, 933.646, -117.308, 31.9558, 0), +(@PATH, 23, 962.605, -156.086, 33.3342, 0), +(@PATH, 24, 1031.77, -216.432, 33.2716, 0), +(@PATH, 25, 1118.48, -252.114, 31.7163, 0), +(@PATH, 26, 1186.55, -265.553, 33.9631, 0), +(@PATH, 27, 1153.34, -262.649, 33.1925, 0); + +SET @NPC := 15973; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 10, -879.45, -1032.25, 30.4729, 0), +(@PATH, 9, -869.37, -999.796, 30.4711, 0), +(@PATH, 8, -879.94, -972.891, 30.4711, 0), +(@PATH, 7, -901.652, -959.997, 30.3695, 0), +(@PATH, 6, -922.421, -948.169, 31.4945, 0), +(@PATH, 5, -943.662, -964.655, 30.4531, 0), +(@PATH, 4, -954.624, -983.011, 30.4729, 0), +(@PATH, 3, -956.185, -1014.9, 30.7775, 0), +(@PATH, 2, -925.451, -1045.89, 30.4729, 0), +(@PATH, 1, -899.749, -1039.66, 30.3725, 0); + +SET @NPC := 57631; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 9665.08, -7073.85, 14.3286, 30000), +(@PATH, 2, 9663.17, -7075.62, 14.3327, 0), +(@PATH, 3, 9662.24, -7078.38, 14.3211, 60000), +(@PATH, 4, 9668.51, -7079.23, 14.3343, 0), +(@PATH, 5, 9668.51, -7079.23, 14.3343, 60000), +(@PATH, 6, 9666.14, -7076.94, 14.3352, 0), +(@PATH, 7, 9665.08, -7073.85, 14.3286, 0), +(@PATH, 8, 9665.08, -7073.85, 14.3286, 30000); + +SET @NPC := 57680; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 9651.68, -7070.56, 14.3104, 15000), +(@PATH, 2, 9650.83, -7073.55, 14.3112, 55000), +(@PATH, 3, 9649.54, -7070.92, 14.3095, 0), +(@PATH, 4, 9648.21, -7071.54, 14.3092, 55000), +(@PATH, 5, 9651.68, -7070.56, 14.3104, 0), +(@PATH, 6, 9651.68, -7070.56, 14.3104, 40000); + +SET @NPC := 135127; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -11148.3, -1914.24, 232.009, 0), +(@PATH, 2, -11149.9, -1919.92, 232.009, 0), +(@PATH, 3, -11153.9, -1921.51, 231.759, 0), +(@PATH, 4, -11154.8, -1924.69, 232.009, 0), +(@PATH, 5, -11157.7, -1924.41, 231.759, 0), +(@PATH, 6, -11160.9, -1927.34, 232.009, 0), +(@PATH, 7, -11161.5, -1925.02, 231.759, 0), +(@PATH, 8, -11166.8, -1927.01, 232.009, 0), +(@PATH, 9, -11172.9, -1925.57, 231.759, 0), +(@PATH, 10, -11173.3, -1925.44, 232.009, 0), +(@PATH, 11, -11177.3, -1922.76, 231.759, 0), +(@PATH, 12, -11178.1, -1922.45, 232.009, 0), +(@PATH, 13, -11178.8, -1916.13, 231.759, 0), +(@PATH, 14, -11180.8, -1915.32, 232.009, 0), +(@PATH, 15, -11179.6, -1914.13, 231.759, 0), +(@PATH, 16, -11181.1, -1909.67, 232.009, 0), +(@PATH, 17, -11179, -1908.98, 231.759, 0), +(@PATH, 18, -11179.1, -1903.99, 232.009, 0), +(@PATH, 19, -11177.8, -1903.89, 231.759, 0), +(@PATH, 20, -11175.6, -1898.68, 232.009, 0), +(@PATH, 21, -11173.8, -1901.71, 231.759, 0), +(@PATH, 22, -11170.1, -1896.42, 232.009, 0), +(@PATH, 23, -11164.4, -1897.42, 231.759, 0), +(@PATH, 24, -11163.8, -1896.4, 232.009, 0), +(@PATH, 25, -11158.9, -1898.43, 231.759, 0), +(@PATH, 26, -11157.4, -1897.88, 232.009, 0), +(@PATH, 27, -11155.7, -1900.88, 231.759, 0), +(@PATH, 28, -11152, -1901.69, 232.009, 0), +(@PATH, 29, -11152.5, -1904.18, 231.759, 0), +(@PATH, 30, -11148.6, -1906.88, 232.009, 0), +(@PATH, 31, -11148.3, -1914.24, 232.009, 0); + +SET @NPC := 62989; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -3378.02, -11918.5, 3.35502, 0), +(@PATH, 2, -3364.13, -11897, 1.79093, 0), +(@PATH, 3, -3352.22, -11887.8, 0.884004, 0), +(@PATH, 4, -3338.67, -11882.7, 1.38813, 0), +(@PATH, 5, -3305.63, -11883.2, 1.41506, 0), +(@PATH, 6, -3263.73, -11885.8, 1.17472, 0), +(@PATH, 7, -3217.82, -11888.1, 1.40486, 0), +(@PATH, 8, -3189.26, -11896.8, 1.29253, 0), +(@PATH, 9, -3155.32, -11909.5, 1.94541, 0), +(@PATH, 10, -3136.6, -11918.9, 1.80227, 0), +(@PATH, 11, -3116.09, -11939.1, 1.79153, 0), +(@PATH, 12, -3135.78, -11919.7, 1.86409, 0), +(@PATH, 13, -3175.88, -11900.5, 1.37822, 0), +(@PATH, 14, -3219.13, -11889, 1.46368, 0), +(@PATH, 15, -3247.34, -11886.3, 0.87759, 0), +(@PATH, 16, -3284.99, -11884.3, 1.18204, 0), +(@PATH, 17, -3323.19, -11881.6, 1.0721, 0), +(@PATH, 18, -3341.64, -11884.6, 1.31528, 0), +(@PATH, 19, -3362.57, -11895.2, 1.58993, 0), +(@PATH, 20, -3371.74, -11907, 2.66572, 0), +(@PATH, 21, -3378.06, -11917.9, 3.24772, 0), +(@PATH, 22, -3385.01, -11923, 3.56976, 0), +(@PATH, 23, -3401.84, -11925.1, 3.55565, 0), +(@PATH, 24, -3435.23, -11911.2, 1.31628, 0), +(@PATH, 25, -3467.63, -11891, 0.611871, 0), +(@PATH, 26, -3487.55, -11884.3, 0.907164, 0), +(@PATH, 27, -3512.39, -11875.5, 1.29932, 0), +(@PATH, 28, -3524.65, -11862.9, 1.37204, 0), +(@PATH, 29, -3529.55, -11851, 0.80154, 0), +(@PATH, 30, -3527.16, -11837.8, 0.298753, 0), +(@PATH, 31, -3529.07, -11853.1, 1.00535, 0), +(@PATH, 32, -3521.42, -11868.3, 1.61523, 0), +(@PATH, 33, -3507.08, -11879.1, 1.48146, 0), +(@PATH, 34, -3477.28, -11887.3, 0.681661, 0), +(@PATH, 35, -3460.58, -11895.2, 0.81699, 0), +(@PATH, 36, -3435.67, -11910.5, 1.26091, 0), +(@PATH, 37, -3392.72, -11924.6, 3.91311, 0); + +SET @NPC := 63004; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -2814.57, -11604.2, 1.48152, 0), +(@PATH, 2, -2813.34, -11569.2, 1.84373, 0), +(@PATH, 3, -2809.57, -11538.9, 2.85442, 0), +(@PATH, 4, -2809.68, -11507.7, 3.70625, 0), +(@PATH, 5, -2815.36, -11462.8, 3.47233, 0), +(@PATH, 6, -2824.25, -11435.3, 4.53325, 0), +(@PATH, 7, -2828.94, -11413.9, 3.7831, 0), +(@PATH, 8, -2830.4, -11381, 2.4203, 0), +(@PATH, 9, -2832.08, -11343.7, 2.53179, 0), +(@PATH, 10, -2824.77, -11286.7, 2.63238, 0), +(@PATH, 11, -2831.14, -11322.5, 2.82903, 0), +(@PATH, 12, -2831.72, -11350.5, 2.4931, 0), +(@PATH, 13, -2830.79, -11389, 2.72528, 0), +(@PATH, 14, -2828.68, -11420.4, 3.83855, 0), +(@PATH, 15, -2823.76, -11439.8, 4.3306, 0), +(@PATH, 16, -2814.89, -11466.9, 3.40746, 0), +(@PATH, 17, -2808.68, -11508.2, 3.71919, 0), +(@PATH, 18, -2809.46, -11540.9, 2.74078, 0), +(@PATH, 19, -2812.99, -11577.2, 1.52412, 0), +(@PATH, 20, -2812.85, -11610.6, 1.64333, 0), +(@PATH, 21, -2809.82, -11634.9, 1.90057, 0), +(@PATH, 22, -2803.9, -11665.7, 1.61544, 0), +(@PATH, 23, -2810.12, -11632.1, 1.95185, 0); + + +SET @NPC := 63448; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -2257.03, -12321.4, 57.2947, 0), +(@PATH, 2, -2216.75, -12321.5, 57.3022, 0); + +SET @NPC := 64956; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 819.3, 7737.21, 23.761, 30000), +(@PATH, 2, 783.834, 7732.42, 23.2434, 0), +(@PATH, 3, 768.138, 7724.52, 22.0622, 30000); + +SET @NPC := 66907; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -3327.78, 4217.31, -12.9577, 2000), +(@PATH, 2, -3326.23, 4201.74, -9.91916, 0), +(@PATH, 3, -3317.02, 4185.02, -7.49581, 0), +(@PATH, 4, -3305.05, 4178.67, -7.55846, 0), +(@PATH, 5, -3287, 4177.99, -8.39443, 0), +(@PATH, 6, -3270.33, 4184.74, -9.3174, 0), +(@PATH, 7, -3244.46, 4194.5, -9.6127, 0), +(@PATH, 8, -3225, 4208.24, -11.6414, 0), +(@PATH, 9, -3212.57, 4220.03, -10.4427, 0), +(@PATH, 10, -3203.5, 4225.33, -16.0323, 0), +(@PATH, 11, -3198.25, 4228.88, -15.9147, 0), +(@PATH, 12, -3188.78, 4228.9, -10.1867, 0), +(@PATH, 13, -3174.5, 4225.05, -10.3182, 0), +(@PATH, 14, -3157.01, 4221.4, -9.12844, 0), +(@PATH, 15, -3136.5, 4219.6, -8.63327, 0), +(@PATH, 16, -3123.31, 4206.28, -7.73802, 0), +(@PATH, 17, -3107.38, 4201.32, -6.7678, 0), +(@PATH, 18, -3091.73, 4203.14, -5.42721, 2000), +(@PATH, 19, -3107.07, 4201.19, -6.74563, 0), +(@PATH, 20, -3122.93, 4205.97, -7.70735, 0), +(@PATH, 21, -3137.18, 4219.95, -8.64952, 0), +(@PATH, 22, -3160.71, 4221.39, -9.38807, 0), +(@PATH, 23, -3175.26, 4225.25, -10.2814, 0), +(@PATH, 24, -3188.33, 4228.68, -10.0172, 0), +(@PATH, 25, -3197.78, 4229.09, -15.6928, 0), +(@PATH, 26, -3203.9, 4224.92, -15.925, 0), +(@PATH, 27, -3212.64, 4219.94, -10.45, 0), +(@PATH, 28, -3224.85, 4208.35, -11.6416, 0), +(@PATH, 29, -3244.95, 4194.08, -9.55214, 0), +(@PATH, 30, -3270.84, 4184.57, -9.31029, 0), +(@PATH, 31, -3287.67, 4177.81, -8.35741, 0), +(@PATH, 32, -3305.46, 4178.7, -7.5413, 0), +(@PATH, 33, -3317.9, 4185.58, -7.51244, 0), +(@PATH, 34, -3326.53, 4202.08, -9.97886, 0); + +SET @NPC := 66999; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -157.366, 2.177, 8.073, 0), +(@PATH, 2, -172.266, -18.28, 8.073, 0), +(@PATH, 3, -171.051, -38.748, 8.073, 0), +(@PATH, 4, -170.718, -59.436, 8.073, 0), +(@PATH, 5, -156.659, -72.118, 8.073, 0), +(@PATH, 6, -142.292, -59.423, 8.073, 0), +(@PATH, 7, -141.779, -38.972, 8.073, 0), +(@PATH, 8, -142.922, -18.95, 8.073, 0), +(@PATH, 9, -157.366, 2.177, 8.073, 0); + + +SET @NPC := 68832; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -220.411, 3101.74, -59.8096, 0), +(@PATH, 2, -234.289, 3093.55, -63.0155, 0), +(@PATH, 3, -247.627, 3080.04, -65.4036, 0), +(@PATH, 4, -233.714, 3095.34, -62.887, 0); + +SET @NPC := 75405; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 3406.09, 7124.06, 189.294, 0), +(@PATH, 2, 3406.94, 7123.54, 189.294, 0), +(@PATH, 3, 3227.07, 7124.38, 198.293, 0), +(@PATH, 4, 3197.35, 7140.33, 198.293, 0), +(@PATH, 5, 3174.6, 7175.17, 198.293, 0), +(@PATH, 6, 3206.27, 7208.28, 193.488, 0), +(@PATH, 7, 3226.79, 7220.99, 193.488, 0), +(@PATH, 8, 3255.19, 7222.58, 193.488, 0), +(@PATH, 9, 3300.44, 7212.05, 189.294, 0), +(@PATH, 10, 3313.93, 7200.43, 189.294, 0), +(@PATH, 11, 3343.27, 7180.31, 189.294, 0), +(@PATH, 12, 3375.99, 7142.72, 189.294, 0), +(@PATH, 13, 3417.93, 7115.4, 189.294, 0), +(@PATH, 14, 3443.3, 7078.94, 189.294, 0), +(@PATH, 15, 3423.43, 7041.69, 183.628, 0), +(@PATH, 16, 3389.92, 7007.88, 183.628, 0), +(@PATH, 17, 3346.99, 6983.5, 183.628, 0), +(@PATH, 18, 3303.02, 6983.78, 183.628, 0), +(@PATH, 19, 3281.57, 7027.43, 186.35, 0), +(@PATH, 20, 3283.78, 7064.68, 186.433, 0), +(@PATH, 21, 3281.75, 7085.84, 187.989, 0), +(@PATH, 22, 3266.41, 7105.88, 192.072, 0), +(@PATH, 23, 3242.7, 7118.66, 196.016, 0), +(@PATH, 24, 3227.07, 7124.38, 198.293, 0), +(@PATH, 25, 3197.35, 7140.33, 198.293, 0); + +SET @NPC := 76716; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -3786.7, 2670.05, 101.234, 0), +(@PATH, 2, -3780.58, 2686.94, 101.002, 0), +(@PATH, 3, -3787.51, 2672.69, 101.089, 0), +(@PATH, 4, -3799, 2670.99, 101.33, 0), +(@PATH, 5, -3805.09, 2676, 100.937, 0), +(@PATH, 6, -3821.13, 2697.37, 101.103, 0), +(@PATH, 7, -3802.29, 2672.35, 101.077, 0), +(@PATH, 8, -3793.76, 2669.05, 101.634, 0), +(@PATH, 9, -3788.45, 2672.2, 101.092, 0), +(@PATH, 10, -3778.92, 2687.8, 101.164, 0), +(@PATH, 11, -3785.84, 2674.82, 100.917, 0), +(@PATH, 12, -3783.46, 2669.85, 101.156, 0), +(@PATH, 13, -3770.29, 2669.09, 100.84, 0), +(@PATH, 14, -3718.1, 2675.63, 105.861, 0), +(@PATH, 15, -3779.27, 2669.86, 101.105, 0); + +SET @NPC := 76770; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,20675,0,4097,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -4387.39, 1382.48, 140.301, 0), +(@PATH, 2, -4424.22, 1374.88, 132.78, 0), +(@PATH, 3, -4457.29, 1361.27, 130.177, 0), +(@PATH, 4, -4484.63, 1338.25, 124.962, 0), +(@PATH, 5, -4486.73, 1324.91, 123.205, 0), +(@PATH, 6, -4477.31, 1313.96, 120.266, 0), +(@PATH, 7, -4456.76, 1313.2, 114.987, 0), +(@PATH, 8, -4436.85, 1315.45, 106.596, 0), +(@PATH, 9, -4427.97, 1319.58, 102.089, 0), +(@PATH, 10, -4406.53, 1320.12, 93.3837, 0), +(@PATH, 11, -4387.4, 1317.01, 85.4427, 0), +(@PATH, 12, -4359.79, 1317.96, 83.7027, 0), +(@PATH, 13, -4339.05, 1319.31, 77.6534, 0), +(@PATH, 14, -4324.66, 1320.65, 75.5907, 0), +(@PATH, 15, -4307.17, 1321.15, 68.5936, 0), +(@PATH, 16, -4298.42, 1321.79, 64.2508, 0), +(@PATH, 17, -4290.35, 1321.94, 62.5389, 0), +(@PATH, 18, -4278.43, 1320.3, 57.4141, 0), +(@PATH, 19, -4260.46, 1310.64, 51.6254, 0), +(@PATH, 20, -4243.24, 1306.61, 54.7569, 0), +(@PATH, 21, -4187.33, 1306.52, 56.0538, 0), +(@PATH, 22, -4135.71, 1300.37, 54.4882, 0), +(@PATH, 23, -4119.53, 1307.08, 53.6594, 0), +(@PATH, 24, -4109.43, 1325.93, 61.5351, 0), +(@PATH, 25, -4108.31, 1359.1, 73.4889, 0), +(@PATH, 26, -4107.86, 1376.82, 79.3237, 0), +(@PATH, 27, -4107.08, 1403.36, 84.9222, 0), +(@PATH, 28, -4110.4, 1373.92, 78.5532, 0), +(@PATH, 29, -4111.96, 1331.68, 63.5064, 0), +(@PATH, 30, -4119.11, 1307.81, 53.8235, 0), +(@PATH, 31, -4132.6, 1299.59, 54.2735, 0), +(@PATH, 32, -4168.78, 1301.77, 56.0267, 0), +(@PATH, 33, -4225.97, 1307.73, 55.9912, 0), +(@PATH, 34, -4258.21, 1311.51, 51.7834, 0), +(@PATH, 35, -4277.71, 1322.23, 57.493, 0), +(@PATH, 36, -4290.46, 1322.64, 62.6576, 0), +(@PATH, 37, -4297.9, 1321.21, 64.1541, 0), +(@PATH, 38, -4315.4, 1321.01, 72.4739, 0), +(@PATH, 39, -4331.96, 1320.65, 77.1841, 0), +(@PATH, 40, -4338.37, 1321.43, 77.673, 0), +(@PATH, 41, -4352.85, 1320.64, 82.2311, 0), +(@PATH, 42, -4378.92, 1317.22, 84.2345, 0), +(@PATH, 43, -4388.29, 1316.86, 85.736, 0), +(@PATH, 44, -4421.44, 1319.99, 99.9963, 0), +(@PATH, 45, -4432.36, 1316.9, 103.918, 0), +(@PATH, 46, -4467.87, 1311.43, 118.284, 0), +(@PATH, 47, -4486.42, 1314.21, 122.085, 0), +(@PATH, 48, -4492.05, 1322.38, 123.065, 0), +(@PATH, 49, -4485, 1341.39, 125.814, 0), +(@PATH, 50, -4462.87, 1356.41, 129.721, 0), +(@PATH, 51, -4425.84, 1375.74, 132.791, 0), +(@PATH, 52, -4412.96, 1381.56, 135.48, 0), +(@PATH, 53, -4385.36, 1383.48, 140.473, 0), +(@PATH, 54, -4335.63, 1389.5, 143.633, 0), +(@PATH, 55, -4302.24, 1383.45, 143.615, 0), +(@PATH, 56, -4260.07, 1398.6, 135.822, 0), +(@PATH, 57, -4239.74, 1402.32, 131.856, 0), +(@PATH, 58, -4279.84, 1392.19, 139.671, 0), +(@PATH, 59, -4309.07, 1382.61, 144.039, 0), +(@PATH, 60, -4327.91, 1386.53, 143.698, 0); + +SET @NPC := 77174; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, -3049.04, 2036.84, 96.7392, 0), +(@PATH, 2, -3058.74, 2037.59, 97.0927, 0), +(@PATH, 3, -3071.71, 2031.49, 97.8157, 0), +(@PATH, 4, -3081.47, 2022.89, 98.1052, 0), +(@PATH, 5, -3080.4, 2018.21, 98.423, 0), +(@PATH, 6, -3068.68, 2011.33, 99.1066, 0), +(@PATH, 7, -3063.36, 2002.53, 99.861, 0), +(@PATH, 8, -3052.37, 1999.89, 99.0744, 0), +(@PATH, 9, -3035, 2000.17, 98.8673, 0), +(@PATH, 10, -3018.3, 2007.63, 96.9703, 0), +(@PATH, 11, -3016.29, 2040.86, 97.3995, 0); + +SET @NPC := 78695; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 3109.83, 6138.61, 136.152, 15000), +(@PATH, 2, 3106.78, 6123.73, 136.396, 0), +(@PATH, 3, 3103.92, 6119.18, 134.98, 0), +(@PATH, 4, 3107.08, 6115.74, 134.479, 0), +(@PATH, 5, 3106.34, 6115.29, 134.444, 20000), +(@PATH, 6, 3100.41, 6119.81, 134.724, 5000), +(@PATH, 7, 3108.07, 6131.54, 136.358, 0); + +SET @NPC := 104236; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,257,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 2885.75, 6374.95, 96.1713, 2000), +(@PATH, 2, 2874.26, 6375.59, 94.969, 2000); + +SET @NPC := 132680; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,1166,0,257,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 2890.05, 5497.71, 55.8601, 0), +(@PATH, 2, 2887.79, 5501.85, 56.2975, 0), +(@PATH, 3, 2885.33, 5536.17, 57.4726, 0), +(@PATH, 4, 2892.9, 5551.65, 56.5137, 0), +(@PATH, 5, 2891.55, 5556.94, 56.6197, 0), +(@PATH, 6, 2885.87, 5564.22, 56.5885, 0), +(@PATH, 7, 2892.29, 5555.69, 56.5451, 0), +(@PATH, 8, 2892.48, 5551.22, 56.5798, 0), +(@PATH, 9, 2885.28, 5537.93, 57.4465, 0), +(@PATH, 10, 2887.79, 5500.02, 56.0182, 0), +(@PATH, 11, 2892.53, 5497.83, 55.6557, 0), +(@PATH, 12, 2909.94, 5498.39, 52.9132, 0), +(@PATH, 13, 2912.57, 5505.34, 52.41, 0), +(@PATH, 14, 2911.46, 5538, 50.7715, 0), +(@PATH, 15, 2921.33, 5561.13, 49.721, 1000), +(@PATH, 16, 2911.81, 5538.54, 50.6613, 0), +(@PATH, 17, 2912.51, 5501.23, 52.7853, 0), +(@PATH, 18, 2908.48, 5498.37, 53.1613, 0); + +SET @NPC := 113838; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 2494, 5909.45, -26.0041, 0), +(@PATH, 2, 2514.95, 5917.51, -26.0044, 0), +(@PATH, 3, 2533.28, 5921.54, -26.0044, 0), +(@PATH, 4, 2535.85, 5931.97, -25.0793, 0), +(@PATH, 5, 2530.36, 5935.48, -23.6146, 0), +(@PATH, 6, 2520.73, 5936.97, -22.4143, 2000), +(@PATH, 7, 2530.35, 5936.18, -23.6339, 0), +(@PATH, 8, 2534.41, 5930.2, -25.3715, 0), +(@PATH, 9, 2534.21, 5923.36, -26.0042, 0), +(@PATH, 10, 2530.96, 5921.14, -26.0042, 0), +(@PATH, 11, 2514.89, 5917.6, -26.0042, 0); + +SET @NPC := 34046; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 2863.06, 5229.63, 10.0378, 0), +(@PATH, 2, 2826.49, 5232.55, 14.1175, 0); + +SET @NPC := 128455; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,2409,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 2182.12, -5810.93, 101.349, 0), +(@PATH, 2, 2176.7, -5817.58, 101.346, 0), +(@PATH, 3, 2177.05, -5823.81, 101.348, 0), +(@PATH, 4, 2189.37, -5833.94, 101.44, 0), +(@PATH, 5, 2190.73, -5840.08, 101.358, 0), +(@PATH, 6, 2186.88, -5854.52, 101.346, 0), +(@PATH, 7, 2189.61, -5860.73, 101.322, 0), +(@PATH, 8, 2197.14, -5864.42, 101.299, 0), +(@PATH, 9, 2206.99, -5866.2, 101.335, 0), +(@PATH, 10, 2223.99, -5864.09, 101.328, 0), +(@PATH, 11, 2236.62, -5857.59, 101.255, 0), +(@PATH, 12, 2245.63, -5845.25, 101.234, 0), +(@PATH, 13, 2248.07, -5836.98, 101.301, 0), +(@PATH, 14, 2246.83, -5830.88, 101.26, 0), +(@PATH, 15, 2244.14, -5827.74, 101.249, 0), +(@PATH, 16, 2239.05, -5825.29, 101.284, 0), +(@PATH, 17, 2227.86, -5823.52, 101.561, 0), +(@PATH, 18, 2219.38, -5817.44, 101.621, 0), +(@PATH, 19, 2209.04, -5804.73, 101.352, 0), +(@PATH, 20, 2204.03, -5803.17, 101.348, 0); + +SET @NPC := 132313; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 812.73, 1391.67, 283.276, 0), +(@PATH, 2, 848.291, 1358.61, 283.276, 0), +(@PATH, 3, 853.923, 1307.91, 283.276, 0), +(@PATH, 4, 847.144, 1265.54, 283.276, 0), +(@PATH, 5, 839.923, 1245.24, 283.276, 0), +(@PATH, 6, 827.346, 1221.82, 283.276, 0), +(@PATH, 7, 803.273, 1203.85, 283.276, 0), +(@PATH, 8, 772.937, 1197.98, 283.276, 0), +(@PATH, 9, 732.114, 1200.65, 283.276, 0), +(@PATH, 10, 693.876, 1217.99, 283.276, 0), +(@PATH, 11, 664.504, 1256.54, 283.276, 0), +(@PATH, 12, 650.15, 1303.48, 283.276, 0), +(@PATH, 13, 662.911, 1350.29, 283.276, 0), +(@PATH, 14, 677.639, 1377.61, 283.276, 0), +(@PATH, 15, 704.82, 1401.16, 283.276, 0), +(@PATH, 16, 755.264, 1417.1, 283.276, 0); + +SET @NPC := 129850; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 1639.78, -6041.07, 149.956, 3000), +(@PATH, 2, 1640.91, -6036.38, 149.956, 0), +(@PATH, 3, 1643.6, -6035.02, 149.956, 0), +(@PATH, 4, 1653.47, -6035.67, 149.956, 0), +(@PATH, 5, 1654.72, -6038.94, 149.956, 0), +(@PATH, 6, 1654.2, -6042.88, 149.956, 3000), +(@PATH, 7, 1654.64, -6037.4, 149.956, 0), +(@PATH, 8, 1653.42, -6035.7, 149.956, 0), +(@PATH, 9, 1641.93, -6034.81, 149.956, 0); + +SET @NPC := 129947; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`, `delay`) VALUES +(@PATH, 1, 1368.39, -5722.43, 136.415, 0), +(@PATH, 2, 1361.03, -5724.37, 136.415, 0), +(@PATH, 3, 1355.26, -5723.52, 136.415, 0), +(@PATH, 4, 1351.62, -5721.32, 136.415, 0), +(@PATH, 5, 1346.5, -5715.25, 136.415, 0), +(@PATH, 6, 1351.87, -5721.74, 136.415, 0), +(@PATH, 7, 1356.59, -5724.55, 136.415, 0), +(@PATH, 8, 1362.26, -5725.54, 136.415, 0), +(@PATH, 9, 1370.14, -5721.54, 136.415, 0), +(@PATH, 10, 1381.61, -5711.69, 136.516, 0); + +-- Position Update +UPDATE `creature` SET `position_x` = -10657.1, `position_y` = 1010.88 , `position_z` = 32.5521 , `orientation` = 0.38323 WHERE `id` = 869; +UPDATE `creature` SET `position_x` = -9245.81, `position_y` = -2167.49 , `position_z` = 64.1168 , `orientation` = 3.58002 WHERE `id` = 936; +UPDATE `creature` SET `position_x` = 2742.71 , `position_y` = 785.519 , `position_z` = 119.133 , `orientation` = 0.453786 WHERE `id` = 1655; +UPDATE `creature` SET `position_x` = 4520.81 , `position_y` = 660.807 , `position_z` = 24.7804 , `orientation` = 4.72302 WHERE `id` = 2172; +UPDATE `creature` SET `position_x` = 6563.79 , `position_y` = 302.533 , `position_z` = 31.4362 , `orientation` = 2.00627 WHERE `id` = 2175; +UPDATE `creature` SET `position_x` = 664.315 , `position_y` = -1027.59 , `position_z` = 160.39 , `orientation` = 5.21757 WHERE `id` = 2258; +UPDATE `creature` SET `position_x` = -465.482, `position_y` = -1476.91 , `position_z` = 90.1814 , `orientation` = 5.11627 WHERE `id` = 2428; +UPDATE `creature` SET `position_x` = -13808.2, `position_y` = 379.781 , `position_z` = 94.5829 , `orientation` = 2.12071 WHERE `id` = 2541; +UPDATE `creature` SET `position_x` = -4681.39, `position_y` = -1266.61 , `position_z` = 503.465 , `orientation` = 1.96398 WHERE `id` = 5637; +UPDATE `creature` SET `position_x` = 578.54 , `position_y` = -1335.66 , `position_z` = 92.8374 , `orientation` = 4.92376 WHERE `id` = 5830; +UPDATE `creature` SET `position_x` = 1060.82 , `position_y` = -3089.71 , `position_z` = 105.229 , `orientation` = 4.64184 WHERE `id` = 5835; +UPDATE `creature` SET `position_x` = 268.899 , `position_y` = -3055.15 , `position_z` = 97.1642 , `orientation` = 5.48952 WHERE `id` = 5907; +UPDATE `creature` SET `position_x` = -471.39 , `position_y` = 48.4756 , `position_z` = -207.954 , `orientation` = 6.03304 WHERE `id` = 7079; +UPDATE `creature` SET `position_x` = -525.307, `position_y` = -4033.5 , `position_z` = 215.861 , `orientation` = 4.73139 WHERE `id` = 8217; +UPDATE `creature` SET `position_x` = 8021.76 , `position_y` = -3946.8 , `position_z` = 687.148 , `orientation` = 6.22522 WHERE `id` = 10200; +UPDATE `creature` SET `position_x` = 5986.52 , `position_y` = -5055.29 , `position_z` = 795.339 , `orientation` = 0.409894 WHERE `id` = 10202; +UPDATE `creature` SET `position_x` = 2013.67 , `position_y` = -353.764 , `position_z` = 35.5772 , `orientation` = 3.17405 WHERE `id` = 10358; +UPDATE `creature` SET `position_x` = 5792.93 , `position_y` = -4757.32 , `position_z` = 776.796 , `orientation` = 3.51011 WHERE `id` = 10807; +UPDATE `creature` SET `position_x` = -7433.38, `position_y` = -923.829 , `position_z` = 465.354 , `orientation` = 2.16294 WHERE `id` = 11983; +UPDATE `creature` SET `position_x` = 1153.34 , `position_y` = -262.649 , `position_z` = 33.1925 , `orientation` = 3.13032 WHERE `id` = 14223; +UPDATE `creature` SET `position_x` = -883.28 , `position_y` = -1036.26 , `position_z` = 30.4945 , `orientation` = 3.34493 WHERE `id` = 14278; +UPDATE `creature` SET `position_x` = 9665.08 , `position_y` = -7073.85 , `position_z` = 14.3286 , `orientation` = 4.86994 WHERE `id` = 16637; +UPDATE `creature` SET `position_x` = 9651.68 , `position_y` = -7070.56 , `position_z` = 14.3104 , `orientation` = 4.01189 WHERE `id` = 16691; +UPDATE `creature` SET `position_x` = -11175.6, `position_y` = -1898.68 , `position_z` = 232.009 , `orientation` = 0.997272 WHERE `id` = 17161; +UPDATE `creature` SET `position_x` = -3390.28, `position_y` = -11925 , `position_z` = 4.13674 , `orientation` = 5.86314 WHERE `id` = 17475; +UPDATE `creature` SET `position_x` = -2810.29, `position_y` = -11631.5 , `position_z` = 2.04978 , `orientation` = 1.84575 WHERE `id` = 17496; +UPDATE `creature` SET `position_x` = -2240.85, `position_y` = -12318.6 , `position_z` = 57.2949 , `orientation` = 4.7298 WHERE `id` = 17701; +UPDATE `creature` SET `position_x` = 767.972 , `position_y` = 7724.44 , `position_z` = 22.0983 , `orientation` = 6.10111 WHERE `id` = 18159; +UPDATE `creature` SET `position_x` = -3326.11, `position_y` = 4201.69 , `position_z` = -9.78603 , `orientation` = 2.05276 WHERE `id` = 18647; +UPDATE `creature` SET `position_x` = -156.764, `position_y` = 20.6869 , `position_z` = 8.07311 , `orientation` = 4.66216 WHERE `id` = 18731; +UPDATE `creature` SET `position_x` = -229.017, `position_y` = 3096.15 , `position_z` = -61.7425 , `orientation` = 0.670469 WHERE `id` = 19264; +UPDATE `creature` SET `position_x` = 2597.55 , `position_y` = 2371.1 , `position_z` = 109.488 , `orientation` = 1.73776 WHERE `id` = 19926; +UPDATE `creature` SET `position_x` = 3178.03 , `position_y` = 7162.76 , `position_z` = 198.649 , `orientation` = 2.094 WHERE `id` = 21497; +UPDATE `creature` SET `position_x` = -3780.32, `position_y` = 2669.17 , `position_z` = 101.36 , `orientation` = 3.25117 WHERE `id` = 21928; +UPDATE `creature` SET `position_x` = -4328.18, `position_y` = 1386.51 , `position_z` = 143.896 , `orientation` = 2.92223 WHERE `id` = 21979; +UPDATE `creature` SET `position_x` = -3023.25, `position_y` = 2044.44 , `position_z` = 96.9412 , `orientation` = 3.63741 WHERE `id` = 22025; +UPDATE `creature` SET `position_x` = 3108.07 , `position_y` = 6131.54 , `position_z` = 136.358 , `orientation` = 1.36031 WHERE `id` = 22386; +UPDATE `creature` SET `position_x` = 2874.85 , `position_y` = 6375.61 , `position_z` = 95.0773 , `orientation` = 3.10723 WHERE `id` = 25437; +UPDATE `creature` SET `position_x` = 2904.37 , `position_y` = 5497.64 , `position_z` = 53.6851 , `orientation` = 3.16112 WHERE `id` = 25440; +UPDATE `creature` SET `position_x` = 2514.29 , `position_y` = 5916.82 , `position_z` = -26.0048 , `orientation` = 3.4872 WHERE `id` = 25789; +UPDATE `creature` SET `position_x` = 2849.36 , `position_y` = 5229.06 , `position_z` = 12.9326 , `orientation` = 2.54208 WHERE `id` = 26252; +UPDATE `creature` SET `position_x` = 2194.4 , `position_y` = -5805.49 , `position_z` = 101.414 , `orientation` = 3.50439 WHERE `id` = 28683; +UPDATE `creature` SET `position_x` = 808.535 , `position_y` = 1213.55 , `position_z` = 295.972 , `orientation` = 3.22503 WHERE `id` = 28859; +UPDATE `creature` SET `position_x` = 1641.03 , `position_y` = -6036.11 , `position_z` = 149.956 , `orientation` = 4.45611 WHERE `id` = 29000; +UPDATE `creature` SET `position_x` = 1371.66 , `position_y` = -5719.72 , `position_z` = 136.504 , `orientation` = 3.88802 WHERE `id` = 29053; +UPDATE `creature` SET `position_x` = 5718.13 , `position_y` = 600.287 , `position_z` = 648.582 , `orientation` = 4.15976 WHERE `id` = 29499; + +DELETE FROM `creature_formations` WHERE `leaderGUID`=76770; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(76770, 76770, 0, 0, 2, 0, 0), +(76770, 70846, 3, 90, 2, 0, 0), +(76770, 70847, 3, 180, 2, 0, 0), +(76770, 70848, 3, 270, 2, 0, 0), +(76770, 70849, 3, 360, 2, 0, 0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=37385; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(37385, 37385, 0, 0, 2, 0, 0), +(37385, 36692, 3, 0, 2, 0, 0); + +UPDATE `creature` SET `spawndist`=0,`MovementType`=0 WHERE `guid` IN (70846, 70847, 70848, 70849, 36692); |