diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_01_08_06_world_335.sql | 850 |
1 files changed, 850 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_01_08_06_world_335.sql b/sql/updates/world/3.3.5/2017_01_08_06_world_335.sql new file mode 100644 index 00000000000..13b20229563 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_01_08_06_world_335.sql @@ -0,0 +1,850 @@ +-- +-- ====================================== +-- Mark (Little Boy Playing in Goldshire) -- BACKPORTED FROM UDB 4.3.4 +-- ====================================== +SET @NPC := 80317; +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, -9420.96, 124.563, 59.8458, 1000), +(@PATH, 2, -9423.12, 126.542, 59.7139, 0 ), +(@PATH, 3, -9426.11, 124.454, 59.4378, 2000), +(@PATH, 4, -9426.26, 128.094, 59.4993, 0 ), +(@PATH, 5, -9430.38, 126.905, 59.1153, 0 ), +(@PATH, 6, -9426.7, 123.858, 59.3385, 3000), +(@PATH, 7, -9424.64, 128.364, 59.6065, 1000), +(@PATH, 8, -9421.68, 128.747, 59.7018, 0 ), +(@PATH, 9, -9426.5, 123.373, 59.33, 2000), +(@PATH,10, -9423.79, 122.926, 59.5772, 0 ), +(@PATH,11, -9428.22, 127.108, 59.3322, 1000), +(@PATH,12, -9424.56, 128.755, 59.6109, 2000), +(@PATH,13, -9424.31, 123.686, 59.5732, 1000), +(@PATH,14, -9420.63, 125.306, 59.8588, 1000), +(@PATH,15, -9425.42, 128.223, 59.5551, 0 ), +(@PATH,16, -9428.58, 126.84, 59.286, 3000), +(@PATH,17, -9424.08, 125.797, 59.6477, 1000), +(@PATH,18, -9426.74, 124.292, 59.366, 1000), +(@PATH,19, -9421.64, 122.839, 59.7418, 2000), +(@PATH,20, -9424.62, 129.267, 59.587, 0 ), +(@PATH,21, -9422.75, 125.989, 59.7377, 0 ), +(@PATH,22, -9420.88, 125.561, 59.8468, 1000), +(@PATH,23, -9426.64, 123.639, 59.3308, 3000), +(@PATH,24, -9424.73, 128.911, 59.5986, 1000), +(@PATH,25, -9423.6, 126.373, 59.6798, 2000), +(@PATH,26, -9430.33, 128.017, 59.1519, 2000), +(@PATH,27, -9426.76, 130.4, 59.4002, 3000), +(@PATH,28, -9424.56, 128.844, 59.6066, 0 ), +(@PATH,29, -9424.1, 123.382, 59.5757, 0 ), +(@PATH,30, -9425.4, 128.584, 59.5549, 1000), +(@PATH,31, -9420.94, 125.047, 59.8615, 2000), +(@PATH,32, -9420.75, 123.038, 59.8094, 1000), +(@PATH,33, -9426.46, 124.127, 59.3821, 0 ), +(@PATH,34, -9426, 128.095, 59.5157, 2000); + +-- ======================================== +-- Joshua (Little Boy Playing in Goldshire) -- BACKPORTED FROM UDB 4.3.4 +-- ======================================== +SET @NPC := 80321; +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, -9424.18, 133.026, 59.31, 0 ), +(@PATH, 2, -9424.74, 129.769, 59.5457, 2000), +(@PATH, 3, -9422.62, 129.107, 59.659, 1000), +(@PATH, 4, -9419.67, 127.702, 59.7659, 3000), +(@PATH, 5, -9423.09, 132.216, 59.4136, 0 ), +(@PATH, 6, -9428.96, 127.099, 59.2547, 0 ), +(@PATH, 7, -9424.46, 126.358, 59.6205, 1000), +(@PATH, 8, -9424.12, 132.979, 59.3154, 2000), +(@PATH, 9, -9420.29, 128.358, 59.7417, 1000), +(@PATH,10, -9422.07, 129.241, 59.6694, 0 ), +(@PATH,11, -9424.54, 134.039, 59.1832, 2000), +(@PATH,12, -9429.07, 127.421, 59.253, 1000), +(@PATH,13, -9425.2, 127.744, 59.5677, 0 ), +(@PATH,14, -9419.75, 125.765, 59.8354, 3000), +(@PATH,15, -9420.17, 128.506, 59.7379, 0 ), +(@PATH,16, -9424.06, 132.964, 59.3186, 0 ), +(@PATH,17, -9421.68, 127.921, 59.7327, 3000), +(@PATH,18, -9428.76, 127.246, 59.2798, 1000), +(@PATH,19, -9424.64, 128.394, 59.6061, 0 ), +(@PATH,20, -9424.24, 133.13, 59.2983, 0 ), +(@PATH,21, -9420.69, 127.959, 59.758, 2000), +(@PATH,22, -9421.75, 124.154, 59.7787, 0 ), +(@PATH,23, -9422.04, 128.779, 59.6904, 1000), +(@PATH,24, -9425.89, 130.494, 59.4445, 1000), +(@PATH,25, -9423.9, 133.336, 59.278, 3000), +(@PATH,26, -9422.57, 130.698, 59.5668, 0 ), +(@PATH,27, -9428.65, 127.343, 59.2939, 0 ), +(@PATH,28, -9426.17, 129.545, 59.4809, 2000), +(@PATH,29, -9423.68, 125.27, 59.675, 1000), +(@PATH,30, -9420.22, 128.425, 59.7395, 2000), +(@PATH,31, -9425.93, 128.267, 59.5216, 1000), +(@PATH,32, -9424.47, 133.752, 59.2216, 1000), +(@PATH,33, -9423.79, 129.098, 59.6217, 0 ), +(@PATH,34, -9427.44, 131.702, 59.2805, 3000), +(@PATH,35, -9425.38, 125.101, 59.5504, 0 ); + +-- ======================================= +-- Eastvale Peasant Carrying Wood (Closer) - Has Wood In Hand (Model 89 wood?) -- BACKPORTED FROM UDB 4.3.4 +-- ======================================= + +SET @NPC := 81348; +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`,`orientation`) VALUES +(@PATH, 1, -9485.48, -1290.4, 41.4874, 0, 5.60948), +(@PATH, 2, -9473.27, -1297.85, 43.4461, 0, 5.7546), +(@PATH, 3, -9469.99, -1298.14, 43.2945, 0, 6.17985), +(@PATH, 4, -9466.88, -1296.67, 42.5918, 2000, 0.987918), +(@PATH, 5, -9469.45, -1298.15, 43.2686, 0, 3.53154), +(@PATH, 6, -9472, -1295.49, 42.4992, 0, 2.27154), +(@PATH, 7, -9472.66, -1292.08, 41.5013, 0, 1.67754), +(@PATH, 8, -9471.59, -1289.43, 41.3488, 0, 0.960917), +(@PATH, 9, -9471.11, -1289.39, 41.3604, 5000, 0.074417), +(@PATH, 10, -9471.11, -1289.39, 41.3604, 2000, 0.074417), +(@PATH, 11, -9498.79, -1284.33, 43.074, 0, 2.87679), +(@PATH, 12, -9501.43, -1282.81, 43.6125, 0, 2.54379), +(@PATH, 13, -9515.63, -1283.32, 44.2897, 0, 3.17942), +(@PATH, 14, -9516.87, -1283.11, 44.2498, 0, 2.86892), +(@PATH, 15, -9518.86, -1283.23, 44.1715, 0, 2.95554), +(@PATH, 16, -9520.85, -1284.64, 44.0949, 0, 3.66879), +(@PATH, 17, -9523.96, -1287.38, 43.9469, 0, 3.94217), +(@PATH, 18, -9523.32, -1290.12, 44.0277, 60000,4.86579), +(@PATH, 19, -9524.08, -1287.62, 43.946, 0, 1.14792), +(@PATH, 20, -9521.22, -1284.78, 44.0677, 0, 0.939797), +(@PATH, 21, -9517.13, -1283.46, 44.2479, 0, 0.066797), +(@PATH, 22, -9509.56, -1283.9, 44.0992, 0, 6.12723), +(@PATH, 23, -9501.62, -1282.98, 43.6054, 0, 0.013922); + +-- ========================================= +-- Guard Pathing From Stormwind to Goldshire +-- ========================================= +SET @NPC := 79875; +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`,`orientation`) VALUES +(@PATH, 1, -9179.97, 317.222, 79.7102, 0, 1.29718), +(@PATH, 2, -9177.49, 327.891, 81.5507, 0, 1.33724), +(@PATH, 3, -9170.12, 340.35, 84.9204, 0, 1.03643), +(@PATH, 4, -9163.7, 349.368, 87.4007, 0, 0.996378), +(@PATH, 5, -9152.55, 360.822, 90.043, 0, 0.798457), +(@PATH, 6, -9143.13, 371.63, 90.5833, 0, 0.862075), +(@PATH, 7, -9128.97, 385.17, 90.8127, 0, 0.744265), +(@PATH, 8, -9113.69, 397.208, 92.4592, 0, 0.706566), +(@PATH, 9, -9101.59, 407.083, 92.6166, 0, 0.706566), +(@PATH, 10, -9113.45, 401.771, 92.5626, 0, 3.60312), +(@PATH, 11, -9128.7, 391.832, 91.3942, 0, 3.70914), +(@PATH, 12, -9138.45, 384.035, 90.7592, 0, 3.81596), +(@PATH, 13, -9147.7, 375.849, 90.8194, 0, 3.88193), +(@PATH, 14, -9158.59, 361.835, 89.5405, 0, 4.05315), +(@PATH, 15, -9169.93, 349.923, 86.1751, 0, 3.97304), +(@PATH, 16, -9177.2, 341.151, 84.0438, 0, 4.05315), +(@PATH, 17, -9181.35, 329.61, 81.6662, 0, 4.36731), +(@PATH, 18, -9183.56, 318.146, 79.6914, 0, 4.52517), +(@PATH, 19, -9183.55, 302.751, 78.2169, 0, 4.68461), +(@PATH, 20, -9184.1, 282.914, 76.1375, 0, 4.68461), +(@PATH, 21, -9184.61, 264.469, 74.4066, 0, 4.68461), +(@PATH, 22, -9186.93, 250.9, 73.3399, 0, 4.58015), +(@PATH, 23, -9191.19, 238.413, 72.2797, 0, 4.38302), +(@PATH, 24, -9195.36, 230.379, 71.8332, 0, 4.3406), +(@PATH, 25, -9199.49, 226.12, 71.6102, 0, 3.8568), +(@PATH, 26, -9210.48, 216.954, 70.8167, 0, 3.80339), +(@PATH, 27, -9219.89, 206.892, 69.32, 0, 3.96047), +(@PATH, 28, -9230.13, 194.153, 68.1122, 0, 4.03823), +(@PATH, 29, -9237.65, 182.77, 67.7178, 0, 4.10184), +(@PATH, 30, -9244.54, 172.092, 67.9077, 0, 3.92906), +(@PATH, 31, -9249.81, 166.19, 67.89, 0, 4.04451), +(@PATH, 32, -9257.42, 161.68, 67.6359, 0, 3.72956), +(@PATH, 33, -9270.23, 156.602, 67.1847, 0, 3.51908), +(@PATH, 34, -9285.68, 154.2, 66.8538, 0, 3.29445), +(@PATH, 35, -9305.36, 146.174, 66.0585, 0, 3.52929), +(@PATH, 36, -9323.79, 135.172, 64.4473, 0, 3.65888), +(@PATH, 37, -9340.25, 124.56, 63.5658, 0, 3.71464), +(@PATH, 38, -9353.49, 117.672, 62.4263, 0, 3.59683), +(@PATH, 39, -9363.35, 112.846, 61.4359, 0, 3.59683), +(@PATH, 40, -9374.73, 109.4, 60.6721, 0, 3.46724), +(@PATH, 41, -9391.14, 105.338, 59.4468, 0, 3.40362), +(@PATH, 42, -9403.03, 98.8523, 58.6535, 0, 3.6416), +(@PATH, 43, -9418.19, 87.5846, 57.0221, 0, 3.76177), +(@PATH, 44, -9438.78, 70.9719, 56.0661, 0, 3.83952), +(@PATH, 45, -9428.19, 75.6371, 56.4119, 0, 0.686148), +(@PATH, 46, -9414.9, 85.4725, 57.0368, 0, 0.723847), +(@PATH, 47, -9406.21, 92.3221, 57.9506, 0, 0.643737), +(@PATH, 48, -9390.33, 98.3514, 59.2352, 0, 0.434035), +(@PATH, 49, -9374.89, 103.568, 60.555, 0, 0.407332), +(@PATH, 50, -9363.94, 107.469, 61.2846, 0, 0.327221), +(@PATH, 51, -9348.05, 114.269, 62.5175, 0, 0.404975), +(@PATH, 52, -9331.7, 124.865, 63.5757, 0, 0.564411), +(@PATH, 53, -9315.07, 134.805, 64.8163, 0, 0.513361), +(@PATH, 54, -9302.66, 141.8, 65.6914, 0, 0.513361), +(@PATH, 55, -9291.3, 145.351, 66.3312, 0, 0.302874), +(@PATH, 56, -9275.2, 148.153, 66.9743, 0, 0.171712), +(@PATH, 57, -9262.77, 150.307, 67.5392, 0, 0.171712), +(@PATH, 58, -9253.35, 155.635, 67.9048, 0, 0.564411), +(@PATH, 59, -9243.59, 165.812, 67.9997, 0, 0.747409), +(@PATH, 60, -9231.75, 182.609, 67.8127, 0, 0.958682), +(@PATH, 61, -9219.18, 197.183, 68.7904, 0, 0.840872), +(@PATH, 62, -9208.44, 209.188, 70.3447, 0, 0.840872), +(@PATH, 63, -9197.62, 219.292, 71.5073, 0, 0.785108), +(@PATH, 64, -9190.19, 226.719, 71.9736, 0, 0.785108), +(@PATH, 65, -9184.74, 235.29, 72.4511, 0, 1.00659), +(@PATH, 66, -9179.6, 250.316, 73.7374, 0, 1.24143), +(@PATH, 67, -9177.47, 260.132, 74.495, 0, 1.35924), +(@PATH, 68, -9177.67, 279.13, 75.8201, 0, 1.58543), +(@PATH, 69, -9178.02, 302.941, 78.7782, 0, 1.58543); + +-- ======================================== +-- Catpurse Pathing Just Outside Northshire -- BACKPORTED FROM UDB 4.3.4 +-- ======================================== +SET @NPC := 80268; +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`,`orientation`) VALUES +(@PATH, 1, -9184.54, 84.7674, 77.7139, 0, 2.62971), +(@PATH, 2, -9169.31, 74.9268, 77.7029, 0, 5.73696), +(@PATH, 3, -9152.12, 64.024, 76.9192, 0, 5.69309), +(@PATH, 4, -9168.5, 74.1081, 77.7328, 0, 2.70728); + +-- ================================== +-- Catpurse Pathing at Bandit Hideout -- BACKPORTED FROM UDB 4.3.4 +-- ================================== +SET @NPC := 80396; +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`,`orientation`) VALUES +(@PATH, 1, -9468.33, 487.68, 52.8662, 0, 5.22799), +(@PATH, 2, -9465.34, 481.615, 52.954, 0, 5.04012), +(@PATH, 3, -9445.73, 486.499, 53.3666, 0, 0.262186), +(@PATH, 4, -9465.34, 481.601, 52.9542, 5000, 3.58656), +(@PATH, 5, -9468.45, 487.871, 52.8435, 10000,2.17919), +(@PATH, 6, -9465.3, 481.545, 52.96, 3000, 5.10531), +(@PATH, 7, -9452.44, 484.696, 53.5232, 0, 0.178086), +(@PATH, 8, -9448.46, 469.36, 52.2493, 0, 5.05502), +(@PATH, 9, -9452.48, 484.624, 53.5229, 0, 1.86288), +(@PATH, 10, -9465.08, 481.635, 52.9727, 5000, 3.41313), +(@PATH, 11, -9468.32, 487.67, 52.8668, 0, 2.044), +(@PATH, 12, -9465.31, 481.517, 52.9587, 4000, 4.92063), +(@PATH, 13, -9452.41, 484.67, 53.523, 0, 0.173067), +(@PATH, 14, -9465.29, 481.73, 52.9536, 0, 3.39513); + +-- ===================================================== +-- Stormwind Guard Pathing from Goldshire to East Bridge -- BACKPORTED FROM UDB 4.3.4 +-- ===================================================== +UPDATE `creature` SET `position_x`=-9501.92, `position_y`=39.8931, `position_z`=56.3325 WHERE `guid`=80330; +SET @NPC := 80330; +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`,`orientation`) VALUES +(@PATH, 1, -9501.92, 39.8931, 56.3325, 0, 1.15859), +(@PATH, 2, -9492.54, 65.2342, 55.9748, 15000,1.31609), +(@PATH, 3, -9501.75, 40.1681, 56.3105, 0, 4.18371), +(@PATH, 4, -9513.61, 15.4656, 56.3767, 0, 4.18709), +(@PATH, 5, -9521.94, -0.638619,55.869, 0, 4.43684), +(@PATH, 6, -9539.13, -32.6803, 56.1854, 0, 4.15671), +(@PATH, 7, -9544.37, -47.9858, 56.6857, 0, 4.35584), +(@PATH, 8, -9547.63, -76.3796, 57.4118, 0, 4.62584), +(@PATH, 9, -9548.5, -104.472, 57.371, 0, 4.73384), +(@PATH, 10, -9550.07, -126.108, 57.4909, 0, 4.62584), +(@PATH, 11, -9556.17, -139.196, 57.3438, 0, 4.20734), +(@PATH, 12, -9569.53, -153.462, 57.2555, 0, 3.95984), +(@PATH, 13, -9579.06, -172.686, 57.3367, 0, 4.25234), +(@PATH, 14, -9587.23, -198.001, 57.5353, 0, 4.38284), +(@PATH, 15, -9597.75, -225.199, 57.3033, 0, 4.37609), +(@PATH, 16, -9606.86, -250.508, 57.359, 0, 4.36259), +(@PATH, 17, -9614.67, -277.74, 57.8428, 0, 4.48071), +(@PATH, 18, -9620.47, -303.359, 57.2908, 0, 4.44359), +(@PATH, 19, -9622.31, -322.75, 57.6468, 0, 4.61909), +(@PATH, 20, -9622.88, -361.765, 57.4564, 0, 4.70009), +(@PATH, 21, -9621.45, -390.159, 57.8215, 0, 4.66634), +(@PATH, 22, -9616.53, -415.374, 57.4727, 0, 4.90484), +(@PATH, 23, -9607.89, -438.75, 57.4328, 0, 5.01509), +(@PATH, 24, -9593.96, -460.414, 57.6986, 0, 5.23334), +(@PATH, 25, -9588.99, -480.285, 57.7266, 0, 4.95659), +(@PATH, 26, -9592.14, -498.795, 57.2194, 0, 4.50097), +(@PATH, 27, -9599.93, -514.626, 57.1832, 0, 4.26021), +(@PATH, 28, -9613.11, -535.875, 54.5228, 0, 4.17472), +(@PATH, 29, -9618.27, -548.76, 54.3916, 0, 4.33334), +(@PATH, 30, -9620.08, -577.63, 54.1327, 0, 4.67197), +(@PATH, 31, -9622.69, -607.243, 52.4636, 0, 4.61459), +(@PATH, 32, -9624.64, -627.14, 51.6031, 0, 4.61459), +(@PATH, 33, -9637.96, -652.453, 49.7951, 0, 4.15222), +(@PATH, 34, -9644.35, -665.667, 49.1226, 0, 4.20284), +(@PATH, 35, -9650.54, -692.529, 46.9055, 0, 4.46384), +(@PATH, 36, -9655.74, -713.033, 44.8837, 0, 4.46384), +(@PATH, 37, -9657.12, -737.728, 44.6, 0, 4.70346), +(@PATH, 38, -9655.57, -765.952, 44.3416, 0, 4.77434), +(@PATH, 39, -9654.45, -784.041, 44.4145, 0, 4.77434), +(@PATH, 40, -9647.38, -799.017, 43.5272, 0, 5.15459), +(@PATH, 41, -9635.29, -813.994, 43.7764, 0, 5.37509), +(@PATH, 42, -9611.08, -841.186, 43.7167, 0, 5.51346), +(@PATH, 43, -9598.92, -854.057, 43.3557, 0, 5.36834), +(@PATH, 44, -9585.82, -871.081, 43.7774, 0, 5.36834), +(@PATH, 45, -9581.6, -888.878, 43.6089, 0, 4.94534), +(@PATH, 46, -9584.37, -916.066, 43.7475, 0, 4.64159), +(@PATH, 47, -9594.18, -937.066, 43.7424, 0, 4.27484), +(@PATH, 48, -9606.48, -949.49, 43.8544, 0, 3.90809), +(@PATH, 49, -9617.12, -967.042, 43.6061, 0, 4.17472), +(@PATH, 50, -9622.43, -992.656, 42.6043, 0, 4.49534), +(@PATH, 51, -9620.16, -1018.38, 40.8238, 0, 4.78672), +(@PATH, 52, -9618.79, -1036.8, 39.7798, 8000, 4.78672), +(@PATH, 53, -9619.59, -1019.81, 40.8076, 0, 1.57478), +(@PATH, 54, -9620.43, -986.898, 43.2364, 0, 1.55791), +(@PATH, 55, -9613.58, -967.255, 43.7842, 0, 1.23391), +(@PATH, 56, -9597.48, -948.622, 43.8632, 0, 0.888531), +(@PATH, 57, -9587.78, -936.686, 43.6941, 0, 0.888531), +(@PATH, 58, -9580.45, -920.402, 43.8308, 0, 1.15178), +(@PATH, 59, -9576.91, -901.242, 43.7912, 0, 1.39141), +(@PATH, 60, -9580.43, -882.41, 43.8358, 0, 1.75703), +(@PATH, 61, -9589.09, -866.323, 43.7678, 0, 1.97641), +(@PATH, 62, -9603.8, -849.664, 43.8141, 0, 2.36566), +(@PATH, 63, -9615.57, -834.964, 43.6628, 0, 2.18003), +(@PATH, 64, -9634.8, -813.909, 43.7857, 0, 2.31166), +(@PATH, 65, -9645.51, -802.205, 43.5259, 0, 2.31166), +(@PATH, 66, -9650.64, -794.885, 43.8282, 0, 2.18003), +(@PATH, 67, -9653.46, -783.158, 44.3652, 0, 1.80653), +(@PATH, 68, -9653.81, -758.897, 44.4042, 0, 1.59841), +(@PATH, 69, -9654.47, -735.043, 44.529, 0, 1.59841), +(@PATH, 70, -9651.39, -713.168, 44.8641, 0, 1.42966), +(@PATH, 71, -9644.03, -693.622, 46.9427, 0, 1.19453), +(@PATH, 72, -9641.06, -673.485, 49.064, 0, 1.42403), +(@PATH, 73, -9635.52, -656.951, 49.7812, 0, 1.24178), +(@PATH, 74, -9626.29, -639.068, 51.0711, 0, 1.09328), +(@PATH, 75, -9619.17, -622.757, 52.0303, 0, 1.11016), +(@PATH, 76, -9618.43, -599.589, 53.1208, 12000,1.52303), +(@PATH, 77, -9617.11, -572.047, 54.3578, 0, 1.52303), +(@PATH, 78, -9611.88, -544.082, 54.5526, 0, 1.35766), +(@PATH, 79, -9604.53, -525.87, 55.8037, 0, 1.18553), +(@PATH, 80, -9591.42, -507.123, 57.6714, 0, 0.960531), +(@PATH, 81, -9586.94, -489.823, 57.7559, 0, 1.31828), +(@PATH, 82, -9588.97, -470.979, 57.8152, 0, 1.68053), +(@PATH, 83, -9598.33, -451.518, 57.6787, 0, 2.02478), +(@PATH, 84, -9610.71, -424.299, 57.5071, 0, 1.89991), +(@PATH, 85, -9614.23, -402.038, 57.7855, 0, 1.70416), +(@PATH, 86, -9617.27, -379.352, 57.7117, 0, 1.70416), +(@PATH, 87, -9618.12, -358.547, 57.509, 0, 1.59278), +(@PATH, 88, -9618.73, -330.771, 57.7121, 0, 1.59278), +(@PATH, 89, -9617.06, -308.921, 57.5708, 0, 1.47803), +(@PATH, 90, -9614.05, -283.033, 57.8271, 0, 1.51853), +(@PATH, 91, -9606.65, -259.839, 57.5343, 0, 1.19791), +(@PATH, 92, -9601.67, -240.325, 57.4463, 0, 1.29578), +(@PATH, 93, -9588.56, -211.445, 57.7775, 0, 1.13266), +(@PATH, 94, -9580.52, -185.797, 57.5998, 0, 1.26766), +(@PATH, 95, -9577.01, -174.573, 57.5513, 15000,1.26766), +(@PATH, 96, -9572.17, -159.087, 57.5675, 0, 1.26766), +(@PATH, 97, -9558.3, -146.312, 57.3714, 0, 0.774906), +(@PATH, 98, -9549.2, -127.367, 57.5916, 0, 1.12366), +(@PATH, 99, -9545.86, -106.324, 57.6247, 0, 1.41728), +(@PATH, 100, -9545.97, -76.0384, 57.4913, 0, 1.59953), +(@PATH, 101, -9543.56, -55.5189, 56.7689, 0, 1.45103), +(@PATH, 102, -9538.82, -37.0123, 56.4551, 0, 1.31603), +(@PATH, 103, -9526.92, -10.1427, 55.764, 0, 1.13041), +(@PATH, 104, -9516.44, 9.74464, 56.1816, 0, 1.18553), +(@PATH, 105, -9509.01, 25.2901, 56.4775, 0, 1.11466); + +-- ====================================== +-- Kobold Miner Pathing in Fargodeep Mine -- BACKPORTED FROM UDB 4.3.4 +-- ====================================== +SET @NPC := 80628; +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`,`orientation`) VALUES +(@PATH, 1, -9790.16, 93.7656, 28.7193, 0, 0.439007), +(@PATH, 2, -9784.15, 97.7059, 28.3709, 0, 0.463757), +(@PATH, 3, -9777.43, 101.009, 28.0487, 0, 0.241007), +(@PATH, 4, -9770.98, 103.232, 27.3929, 0, 0.155507), +(@PATH, 5, -9764.74, 106.052, 26.869, 0, 0.511007), +(@PATH, 6, -9758.33, 107.566, 26.1933, 0, 0.232007), +(@PATH, 7, -9752.85, 107.691, 25.8685, 0, 0.070006), +(@PATH, 8, -9744.62, 111.214, 25.4213, 0, 0.518881), +(@PATH, 9, -9735.92, 113.541, 24.2957, 0, 0.372632), +(@PATH, 10, -9742.54, 112.217, 25.2674, 0, 3.31788), +(@PATH, 11, -9750.34, 109.032, 25.6329, 0, 3.52938), +(@PATH, 12, -9758.28, 108.055, 26.3107, 0, 3.26388), +(@PATH, 13, -9766.66, 105.194, 26.9169, 0, 3.47088), +(@PATH, 14, -9770.89, 103.145, 27.3535, 0, 3.59238), +(@PATH, 15, -9778.31, 101.857, 28.092, 0, 3.31338), +(@PATH, 16, -9783.64, 98.912, 28.614, 0, 3.64638), +(@PATH, 17, -9789.64, 94.0598, 28.7856, 0, 3.82188), +(@PATH, 18, -9795.07, 89.6699, 28.7906, 0, 3.82188), +(@PATH, 19, -9795.07, 89.6699, 28.7906, 0, 0.554881), +(@PATH, 20, -9792.67, 91.1524, 28.7246, 0, 0.554881); + +-- ========================================= +-- Bandit Pathing at Brackwell Pumpkin Patch -- BACKPORTED FROM UDB 4.3.4 +-- ========================================= +SET @NPC := 80868; +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`,`orientation`) VALUES +(@PATH, 1, -9817.44, -930.846, 39.6415, 4000, 5.12755), +(@PATH, 2, -9818.43, -920.829, 40.0197, 0, 1.57024), +(@PATH, 3, -9821.16, -912.076, 39.5021, 0, 2.01574), +(@PATH, 4, -9818.48, -920.583, 40.0072, 0, 4.6033), +(@PATH, 5, -9817.31, -930.957, 39.6276, 0, 5.02518), +(@PATH, 6, -9818.41, -920.72, 40.0137, 0, 1.45211), +(@PATH, 7, -9820.88, -912.245, 39.5145, 4000, 1.68161), +(@PATH, 8, -9818.44, -920.552, 40.0082, 0, 5.04205); + +-- ======================================== +-- Eastvale Peasant Carrying Wood (Far One) - Does Not Have Wood In Hand -- BACKPORTED FROM UDB 4.3.4 +-- ======================================== +SET @NPC := 81349; +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`,`orientation`) VALUES +(@PATH, 1, -9535.3, -1304.79, 44.6105, 60000,5.02586), +(@PATH, 2, -9535.3, -1304.79, 44.6105, 0, 4.94486), +(@PATH, 3, -9536.16, -1301.24, 44.4093, 0, 2.06817), +(@PATH, 4, -9532.34, -1293.74, 43.9304, 0, 1.09955), +(@PATH, 5, -9521.17, -1284.78, 44.0708, 0, 0.540423), +(@PATH, 6, -9517.42, -1283.2, 44.2314, 0, 0.380673), +(@PATH, 7, -9501.79, -1282.83, 43.6442, 0, 6.18798), +(@PATH, 8, -9486.02, -1289.91, 41.5058, 0, 5.76498), +(@PATH, 9, -9473.36, -1297.59, 43.3864, 0, 5.52873), +(@PATH, 10, -9470.14, -1298.07, 43.2746, 0, 0.178173), +(@PATH, 11, -9468.22, -1297.9, 43.1293, 0, 0.029673), +(@PATH, 12, -9466.9, -1296.65, 42.5853, 2000, 1.07817), +(@PATH, 13, -9468.1, -1297.79, 43.0815, 0, 3.61392), +(@PATH, 14, -9469.75, -1298.06, 43.2496, 0, 3.30342), +(@PATH, 15, -9471.84, -1295.54, 42.4933, 0, 2.36405), +(@PATH, 16, -9472.6, -1291.94, 41.4566, 0, 1.68005), +(@PATH, 17, -9472.69, -1291.07, 41.3582, 0, 1.68005), +(@PATH, 18, -9471.62, -1289.48, 41.35, 0, 0.897048), +(@PATH, 19, -9471.07, -1289.27, 41.3603, 5000, 0.105048), +(@PATH, 20, -9471.07, -1289.27, 41.3603, 2000, 0.105048), +(@PATH, 21, -9483.12, -1288.78, 41.5416, 0, 3.11892), +(@PATH, 22, -9498.85, -1284.25, 43.0969, 0, 2.97605), +(@PATH, 23, -9501.24, -1282.84, 43.5892, 0, 2.8208), +(@PATH, 24, -9507.15, -1282.59, 44.0966, 0, 3.22017), +(@PATH, 25, -9515.79, -1283.27, 44.2872, 0, 3.22017), +(@PATH, 26, -9519.26, -1282.58, 44.1293, 0, 2.94567), +(@PATH, 27, -9528.26, -1288.32, 43.7139, 0, 3.97167), +(@PATH, 28, -9535.73, -1299.14, 44.2706, 0, 4.66917), +(@PATH, 29, -9536.51, -1300.56, 44.3675, 0, 4.21017); + +-- ==================================================== +-- Servant of Azora Pathing in Circle in Tower of Azora -- BACKPORTED FROM UDB 4.3.4 +-- ==================================================== +SET @NPC := 80927; +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`,`orientation`) VALUES +(@PATH, 1, -9548.12, -726.317, 90.4266, 0, 0.934399), +(@PATH, 2, -9546.5, -721.962, 90.4266, 0, 1.40015), +(@PATH, 3, -9546.33, -717.879, 90.4266, 0, 1.6634), +(@PATH, 4, -9547.54, -713.683, 90.4237, 0, 1.8704), +(@PATH, 5, -9549.95, -709.777, 90.4253, 0, 2.14715), +(@PATH, 6, -9553.19, -707.033, 90.4261, 0, 2.43965), +(@PATH, 7, -9557.33, -705.499, 90.4256, 0, 2.99427), +(@PATH, 8, -9561.48, -704.975, 90.4275, 0, 3.1259), +(@PATH, 9, -9565.76, -706.214, 90.426, 0, 3.4229), +(@PATH, 10, -9569.74, -708.804, 90.424, 0, 3.7604), +(@PATH, 11, -9572.31, -712.185, 90.4222, 0, 4.0619), +(@PATH, 12, -9574.11, -716.444, 90.426, 0, 4.3004), +(@PATH, 13, -9574.26, -720.408, 90.4263, 0, 4.59627), +(@PATH, 14, -9573.14, -724.663, 90.4245, 0, 5.13177), +(@PATH, 15, -9570.96, -728.552, 90.4276, 0, 5.5199), +(@PATH, 16, -9567.29, -731.41, 90.4276, 0, 5.6279), +(@PATH, 17, -9563.35, -732.865, 90.4276, 0, 5.9294), +(@PATH, 18, -9560.25, -734.48, 90.4276, 0, 5.72802), +(@PATH, 19, -9555.31, -734.244, 90.4276, 0, 0.047839), +(@PATH, 20, -9552.15, -732.295, 90.4276, 0, 0.695839), +(@PATH, 21, -9549.66, -730.218, 90.4276, 0, 0.695839); + +-- ========================================================= +-- Murloc and Murloc Steamrunner Pathing Around Crystal Lake -- BACKPORTED FROM UDB 4.3.4 +-- ========================================================= +SET @NPC := 81076; +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`,`orientation`) VALUES +(@PATH, 1, -9526.93, -285.396, 59.5467, 0, 4.89931), +(@PATH, 2, -9527.61, -292.303, 59.1049, 0, 4.65181), +(@PATH, 3, -9530.63, -301.207, 58.3739, 0, 4.32781), +(@PATH, 4, -9531.74, -314.601, 60.6373, 0, 4.62931), +(@PATH, 5, -9533.53, -324.735, 59.2103, 0, 4.53819), +(@PATH, 6, -9535.15, -333.945, 58.3414, 0, 4.53819), +(@PATH, 7, -9533.05, -341.368, 59.5604, 0, 4.98819), +(@PATH, 8, -9530.1, -349.627, 59.598, 0, 5.05569), +(@PATH, 9, -9525.13, -358.166, 59.0207, 0, 5.15469), +(@PATH, 10, -9522.94, -363.136, 58.971, 0, 4.69794), +(@PATH, 11, -9525.12, -367.745, 60.0007, 0, 4.38294), +(@PATH, 12, -9529.59, -373.125, 60.0734, 0, 4.10169), +(@PATH, 13, -9533, -382.533, 58.2308, 0, 4.33231), +(@PATH, 14, -9538.12, -391.038, 58.9703, 0, 4.16356), +(@PATH, 15, -9539.35, -395.911, 59.3127, 0, 4.46506), +(@PATH, 16, -9536.47, -406.153, 60.1629, 0, 4.98706), +(@PATH, 17, -9536.74, -416.201, 60.264, 0, 4.68556), +(@PATH, 18, -9537.87, -429.28, 58.5419, 0, 4.57419), +(@PATH, 19, -9537.82, -432.787, 58.7907, 0, 4.72719), +(@PATH, 20, -9535.28, -435.842, 58.6941, 0, 5.40669), +(@PATH, 21, -9523.99, -441.676, 58.7635, 0, 5.78356), +(@PATH, 22, -9517.93, -448.962, 59.4715, 0, 5.40556), +(@PATH, 23, -9510.8, -452.213, 57.6683, 0, 5.85556), +(@PATH, 24, -9497.28, -460.999, 57.6426, 0, 5.70706), +(@PATH, 25, -9490.2, -468.303, 58.5747, 0, 5.48206), +(@PATH, 26, -9480.62, -476.252, 58.4637, 0, 5.70819), +(@PATH, 27, -9473.07, -481.147, 59.0252, 0, 5.70819), +(@PATH, 28, -9464.45, -476.681, 58.5417, 0, 0.478001), +(@PATH, 29, -9457.22, -470.558, 58.6759, 0, 0.703001), +(@PATH, 30, -9455.04, -465.644, 57.9474, 0, 1.153), +(@PATH, 31, -9445.86, -457.86, 56.658, 0, 0.703001), +(@PATH, 32, -9437.89, -452.973, 57.6314, 0, 0.550001), +(@PATH, 33, -9430.25, -445.79, 58.2607, 0, 0.682751), +(@PATH, 34, -9419.51, -441.484, 58.3789, 0, 0.381251), +(@PATH, 35, -9414.33, -433.69, 58.2152, 0, 0.984251), +(@PATH, 36, -9412.2, -426.436, 58.0708, 0, 1.46463), +(@PATH, 37, -9413.08, -417.396, 58.2457, 0, 1.59738), +(@PATH, 38, -9413.35, -407.874, 59.4805, 0, 1.65588), +(@PATH, 39, -9414.28, -401.303, 58.9778, 0, 1.65925), +(@PATH, 40, -9411.41, -391.67, 58.1261, 0, 1.28125), +(@PATH, 41, -9411.7, -379.985, 58.1249, 0, 1.5985), +(@PATH, 42, -9408.9, -369.836, 58.3438, 0, 1.3015), +(@PATH, 43, -9401.37, -357.998, 57.87, 0, 1.0045), +(@PATH, 44, -9398.53, -343.426, 58.0562, 0, 1.378), +(@PATH, 45, -9400.42, -333.312, 58.4127, 0, 1.756), +(@PATH, 46, -9407.72, -327.094, 58.7075, 0, 2.4355), +(@PATH, 47, -9419.01, -317.461, 58.4034, 0, 2.4355), +(@PATH, 48, -9431.82, -306.537, 57.8234, 0, 2.4355), +(@PATH, 49, -9436.26, -299.673, 59.719, 0, 2.17338), +(@PATH, 50, -9443.15, -289.656, 58.5493, 0, 2.17338), +(@PATH, 51, -9451.89, -287.059, 58.1195, 0, 2.85288), +(@PATH, 52, -9461.37, -287.18, 58.4068, 0, 3.15438), +(@PATH, 53, -9470.27, -274.719, 57.9699, 0, 2.32413), +(@PATH, 54, -9474.7, -268.988, 57.9762, 0, 2.22963), +(@PATH, 55, -9471.8, -257.181, 58.3496, 0, 1.32963), +(@PATH, 56, -9466.18, -247.866, 58.1487, 0, 1.02813), +(@PATH, 57, -9461.47, -243.147, 58.3831, 0, 0.63325), +(@PATH, 58, -9460.29, -241.266, 58.3823, 0, 1.01125), +(@PATH, 59, -9458.73, -232.757, 57.8008, 0, 1.38925), +(@PATH, 60, -9454.74, -225.068, 58.3335, 0, 1.46463), +(@PATH, 61, -9451.38, -222.16, 58.3667, 0, 0.713126), +(@PATH, 62, -9436.67, -219.383, 58.3314, 0, 0.186625), +(@PATH, 63, -9425.75, -218.588, 58.4336, 0, 0.017875), +(@PATH, 64, -9414.45, -211.747, 58.404, 0, 0.544376), +(@PATH, 65, -9407.06, -202.089, 58.3292, 0, 0.917876), +(@PATH, 66, -9401.83, -191.937, 58.3821, 0, 1.06525), +(@PATH, 67, -9398.99, -178.2, 58.2758, 0, 1.36675), +(@PATH, 68, -9397.22, -186.382, 58.8436, 0, 4.82636), +(@PATH, 69, -9400.34, -196.2, 59.1179, 0, 4.48436), +(@PATH, 70, -9406.54, -206.796, 58.9968, 0, 4.18286), +(@PATH, 71, -9411.45, -213.731, 59.5305, 0, 4.07261), +(@PATH, 72, -9418.15, -219.391, 59.623, 0, 3.84311), +(@PATH, 73, -9429.92, -222.801, 59.2838, 0, 3.39311), +(@PATH, 74, -9439.33, -224.396, 59.0535, 0, 3.22549), +(@PATH, 75, -9451.09, -225.385, 59.0377, 0, 3.22549), +(@PATH, 76, -9455.6, -228.535, 58.3439, 0, 3.75199), +(@PATH, 77, -9456.89, -236.085, 58.3142, 0, 4.48436), +(@PATH, 78, -9463.13, -245.874, 58.4287, 0, 4.07149), +(@PATH, 79, -9468.72, -252.04, 58.3867, 0, 4.12548), +(@PATH, 80, -9471.59, -260.817, 58.6599, 0, 4.51811), +(@PATH, 81, -9470.45, -268.813, 58.7031, 0, 5.06036), +(@PATH, 82, -9465.56, -277.23, 58.5089, 0, 5.34049), +(@PATH, 83, -9456.94, -283.661, 59.5827, 0, 5.64198), +(@PATH, 84, -9451.81, -289.061, 57.5824, 0, 5.41586), +(@PATH, 85, -9442.62, -296.304, 58.5089, 0, 5.64198), +(@PATH, 86, -9432.88, -303.577, 58.8105, 0, 5.64198), +(@PATH, 87, -9423.18, -311.948, 57.3591, 0, 5.71961), +(@PATH, 88, -9413.51, -320.507, 59.3467, 0, 5.49348), +(@PATH, 89, -9406.03, -326.823, 59.0337, 0, 5.55198), +(@PATH, 90, -9397.47, -331.361, 59.2249, 0, 5.77811), +(@PATH, 91, -9394.32, -341.237, 58.8416, 0, 5.08398), +(@PATH, 92, -9394.34, -348.601, 58.6107, 0, 4.71048), +(@PATH, 93, -9398.84, -360.024, 58.1032, 0, 4.33699), +(@PATH, 94, -9406.72, -367.451, 58.2864, 0, 3.86111), +(@PATH, 95, -9408.36, -376.665, 58.742, 0, 4.53611), +(@PATH, 96, -9407.05, -387.686, 59.2576, 0, 4.81736), +(@PATH, 97, -9408.76, -397.243, 59.7092, 0, 4.53499), +(@PATH, 98, -9411.24, -411.058, 59.6969, 0, 4.53499), +(@PATH, 99, -9412.9, -420.43, 57.8578, 0, 4.46748), +(@PATH, 100, -9414.58, -428.293, 58.0399, 0, 4.74761), +(@PATH, 101, -9413.27, -433.629, 58.3313, 0, 4.95349), +(@PATH, 102, -9417.09, -441.775, 58.509, 0, 4.27398), +(@PATH, 103, -9431.5, -451.761, 58.9674, 0, 3.74748), +(@PATH, 104, -9440.13, -457.083, 57.646, 0, 3.57873), +(@PATH, 105, -9449.69, -462.903, 57.4956, 0, 3.74748), +(@PATH, 106, -9456.42, -470.864, 58.8739, 0, 4.08498), +(@PATH, 107, -9463.22, -477.555, 58.9884, 0, 3.86223), +(@PATH, 108, -9471.66, -482.116, 59.2805, 0, 3.63723), +(@PATH, 109, -9474.79, -482.487, 59.4486, 0, 3.25923), +(@PATH, 110, -9480.72, -479.911, 59.211, 0, 2.82611), +(@PATH, 111, -9489.82, -471.161, 58.8715, 0, 2.37611), +(@PATH, 112, -9500.81, -463.613, 58.1139, 0, 2.53924), +(@PATH, 113, -9511.98, -455.93, 57.8465, 0, 2.53924), +(@PATH, 114, -9519.15, -449.663, 59.6295, 0, 2.31311), +(@PATH, 115, -9528.37, -442.945, 59.2488, 0, 2.41098), +(@PATH, 116, -9536.69, -437.328, 59.1452, 0, 2.52123), +(@PATH, 117, -9541.11, -432.342, 59.3252, 0, 2.29624), +(@PATH, 118, -9541.02, -424.815, 59.525, 0, 1.67636), +(@PATH, 119, -9538.49, -419.161, 60.1225, 0, 1.14986), +(@PATH, 120, -9537.19, -411.727, 60.8444, 0, 1.35348), +(@PATH, 121, -9538.33, -404.686, 60.4075, 0, 1.73149), +(@PATH, 122, -9541.88, -396.048, 60.1178, 0, 1.94073), +(@PATH, 123, -9540.84, -387.951, 59.9352, 0, 1.50648), +(@PATH, 124, -9535.36, -379.132, 59.4486, 0, 0.88436), +(@PATH, 125, -9529.66, -372.169, 60.4515, 0, 0.88436), +(@PATH, 126, -9526.27, -365.894, 60.7335, 0, 1.07448), +(@PATH, 127, -9526.08, -361.692, 60.2865, 0, 1.52448), +(@PATH, 128, -9529.7, -354.745, 60.4647, 0, 2.05099), +(@PATH, 129, -9532.19, -345.368, 59.8048, 0, 1.83048), +(@PATH, 130, -9535.49, -336.256, 58.836, 0, 1.90473), +(@PATH, 131, -9537.37, -330.84, 58.9244, 0, 1.90473), +(@PATH, 132, -9533.55, -323.214, 59.6467, 0, 1.11161), +(@PATH, 133, -9528.78, -317.071, 59.9019, 0, 0.82811), +(@PATH, 134, -9528.87, -311.109, 59.2594, 0, 1.59086), +(@PATH, 135, -9532.4, -302.701, 58.7929, 0, 1.96886), +(@PATH, 136, -9530.55, -296.177, 58.8768, 0, 1.29386), +(@PATH, 137, -9526.65, -290.204, 59.2711, 0, 0.99236), +(@PATH, 138, -9528.52, -279.496, 59.5445, 0, 1.74386), +(@PATH, 139, -9531.63, -270.045, 59.5306, 0, 1.78773), +(@PATH, 140, -9533.59, -261.138, 59.7819, 0, 1.78773), +(@PATH, 141, -9535.25, -246.891, 59.4823, 0, 1.71236), +(@PATH, 142, -9531.74, -254.945, 59.2799, 0, 5.04917), +(@PATH, 143, -9529.11, -269.769, 59.0871, 0, 4.93554); + + +DELETE FROM `creature_formations` WHERE `leaderGUID`=81076; +INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES +(81076, 81076, 0, 0, 2, 0, 0), +(81076, 81075, 2, 0, 2, 0, 0); + +-- ========================================== +-- Eastvale Lumberjack in Eastvale Lumbermill -- Backported From UDB 4.3.4 +-- ========================================== +SET @NPC := 81257; +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`,`orientation`) VALUES +(@PATH, 1, -9413.04, -1334.53, 51.4692, 0, 5.59541), +(@PATH, 2, -9408.97, -1337.83, 50.0284, 0, 5.59765), +(@PATH, 3, -9405.36, -1337.53, 50.0284, 0, 0.20772), +(@PATH, 4, -9400.8, -1336.89, 50.0284, 15000,0.090721), +(@PATH, 5, -9405.23, -1337.44, 50.0284, 0, 3.22053), +(@PATH, 6, -9408.65, -1337.76, 50.0284, 0, 3.12153), +(@PATH, 7, -9412.68, -1334.55, 51.4713, 0, 2.52303), +(@PATH, 8, -9417.18, -1330.69, 51.4389, 0, 2.26653), +(@PATH, 9, -9421.12, -1326.57, 51.466, 0, 2.45103), +(@PATH, 10, -9426.09, -1324, 51.4634, 15000,2.67941); + +-- ================================================ +-- Eastvale Peasant Carrying Wood (2 on Other Side) - Closer One -- BACKPORTED FROM UDB 4.3.4 +-- ================================================ +SET @NPC := 81252; +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`,`orientation`) VALUES +(@PATH, 1, -9529.38, -1323.66, 45.7876, 75000,2.47916), +(@PATH, 2, -9529.38, -1323.66, 45.7876, 2000, 2.47916), +(@PATH, 3, -9518.05, -1332.69, 45.7966, 0, 5.59322), +(@PATH, 4, -9511.41, -1332.79, 44.736, 0, 6.1546), +(@PATH, 5, -9494.98, -1325.54, 41.6159, 0, 0.415913), +(@PATH, 6, -9482.24, -1314.9, 43.9164, 0, 0.720788), +(@PATH, 7, -9470.2, -1300.35, 44.0556, 0, 0.964913), +(@PATH, 8, -9467.05, -1297.01, 42.7352, 2000, 0.876038), +(@PATH, 9, -9469.95, -1297.39, 43.0062, 0, 3.15754), +(@PATH, 10, -9472.22, -1295.39, 42.4952, 0, 2.41954), +(@PATH, 11, -9472.75, -1291.37, 41.3663, 0, 1.67704), +(@PATH, 12, -9472.1, -1289.87, 41.3434, 0, 1.15954), +(@PATH, 13, -9471.29, -1289.18, 41.3534, 5000, 6.02976), +(@PATH, 14, -9471.29, -1289.18, 41.3534, 2000, 6.02976), +(@PATH, 15, -9475.63, -1294.78, 42.6363, 0, 4.17913), +(@PATH, 16, -9475.33, -1303.75, 44.1475, 0, 4.74951), +(@PATH, 17, -9480.23, -1316.08, 44.0408, 0, 4.23313), +(@PATH, 18, -9485.9, -1324.32, 41.4648, 0, 4.06776), +(@PATH, 19, -9499.39, -1331.18, 42.2869, 0, 3.47375), +(@PATH, 20, -9512.82, -1332.8, 44.9784, 0, 3.09801), +(@PATH, 21, -9521.54, -1330.49, 46.0507, 0, 2.86738); + +-- =================================================== +-- Eastvale Peasant Carrying Wood (Lone One Near Road) - Does Not Have Wood In Hand -- BACKPORTED FROM UDB 4.3.4 +-- =================================================== +SET @NPC := 81250; +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`,`orientation`) VALUES +(@PATH, 1, -9536.28, -1273.01, 43.4519, 30000,2.59007), +(@PATH, 2, -9536.28, -1273.01, 43.4519, 0, 2.59007), +(@PATH, 3, -9521.88, -1275.68, 43.1626, 0, 5.94482), +(@PATH, 4, -9505.93, -1281.29, 44.1637, 0, 5.94482), +(@PATH, 5, -9486.4, -1288.17, 41.6718, 0, 5.94482), +(@PATH, 6, -9476.64, -1292.83, 41.8459, 0, 5.65007), +(@PATH, 7, -9471.79, -1298.24, 43.4567, 0, 5.43745), +(@PATH, 8, -9470.03, -1298.72, 43.5124, 0, 6.01794), +(@PATH, 9, -9466.93, -1297.14, 42.7895, 2000, 0.66626), +(@PATH, 10, -9469.46, -1297.84, 43.1519, 0, 3.41126), +(@PATH, 11, -9472.34, -1294.84, 42.3142, 0, 1.98026), +(@PATH, 12, -9472.87, -1291.52, 41.3679, 0, 1.68438), +(@PATH, 13, -9472.42, -1290.3, 41.3436, 0, 1.22089), +(@PATH, 14, -9472.1, -1289.83, 41.342, 0, 0.968885), +(@PATH, 15, -9471.03, -1289.19, 41.36, 5000, 6.18899), +(@PATH, 16, -9471.03, -1289.19, 41.36, 2000, 6.18899), +(@PATH, 17, -9481.91, -1288.05, 41.493, 0, 2.81843), +(@PATH, 18, -9502.11, -1282.98, 43.6523, 0, 2.96018), +(@PATH, 19, -9516.99, -1277.44, 43.8974, 0, 2.69355), +(@PATH, 20, -9531.08, -1275.8, 42.6205, 0, 3.00968); + +SET @NPC := 81249; +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`,`orientation`) VALUES +(@PATH, 1, -9535.6, -1329.76, 47.2559, 45000,1.69681), +(@PATH, 2, -9535.6, -1329.76, 47.2559, 0, 1.69681), +(@PATH, 3, -9511.59, -1332.84, 44.7722, 0, 6.14216), +(@PATH, 4, -9509.08, -1332.48, 44.2897, 0, 0.024354), +(@PATH, 5, -9482.27, -1313.57, 44.1488, 0, 0.619478), +(@PATH, 6, -9469.35, -1299.53, 43.8193, 0, 0.814103), +(@PATH, 7, -9466.68, -1297.18, 42.7987, 2000, 0.697103), +(@PATH, 8, -9468.2, -1298.11, 43.2133, 0, 3.6941), +(@PATH, 9, -9470.82, -1297.26, 43.0019, 0, 2.8301), +(@PATH, 10, -9473.21, -1294.08, 42.1613, 0, 2.2136), +(@PATH, 11, -9473.17, -1291.22, 41.358, 0, 1.5971), +(@PATH, 12, -9472.45, -1289.84, 41.3334, 0, 1.0886), +(@PATH, 13, -9471.39, -1289.45, 41.3546, 5000, 0.256103), +(@PATH, 14, -9471.39, -1289.45, 41.3546, 2000, 0.256103), +(@PATH, 15, -9475.31, -1296.12, 43.1933, 0, 4.18129), +(@PATH, 16, -9475.11, -1302.58, 44.1457, 0, 4.74379), +(@PATH, 17, -9480.3, -1316.58, 43.9335, 0, 4.30054), +(@PATH, 18, -9490.53, -1328.05, 41.5203, 0, 3.95966), +(@PATH, 19, -9511.08, -1332.95, 44.6851, 0, 3.23179), +(@PATH, 20, -9525.83, -1333.92, 47.0105, 0, 3.15754); + +-- ========================================== +-- Add some Random Movement For Cat Lady Cats +-- ========================================== +UPDATE `creature` SET `SpawnDist`=3, `MovementType`=1 WHERE `guid` IN (79910,79908,79905,79909); +UPDATE `creature` SET `SpawnDist`=8, `MovementType`=1 WHERE `guid` IN (79904,79906,79902,79903,79913,79911,79916,79914,79915); + + +-- ==================================================== +-- Add some Random Movement For 4 KIds At Eastvale Camp +-- ==================================================== +UPDATE `creature` SET `SpawnDist`=8, `MovementType`=1 WHERE `id` IN (798,800,802,801); + +-- =================================== +-- Remove Random Movement For Some NPC +-- =================================== +UPDATE `creature` SET `SpawnDist`=0, `MovementType`=0 WHERE `guid` IN (80534,80535,80536,80518,80519,80520,80521,80512,80513,80514,80499,80500,80501,80506,80507,80508,80523,80525,80526,80518,80519,80520,80521,80747,80748,81151,81152,81153,81122,81131,81133,81141,81142,81143,81144,81117,81118,81119,81120,80393,80394); +UPDATE `creature` SET `SpawnDist`=0, `MovementType`=0 WHERE `guid` IN (79890,79888,79889,81106); + +-- ================================= +-- Generic NPC Movement Improvements +-- ================================= +UPDATE `creature` SET `SpawnDist`=15, `MovementType`=1 WHERE `id` IN (30,113,118,299,524,525,822,1922,883,1933,2442,721,1412) AND `MovementType` IN (0,1); + + +-- ============================== +-- Individual NPC Movement Tweaks +-- ============================== +UPDATE `creature` SET `SpawnDist`=3, `MovementType`=1 WHERE `guid` IN (79918,79919); +UPDATE `creature` SET `SpawnDist`=8, `MovementType`=1 WHERE `guid` IN (86159); + +-- ================================ +-- Fix Spawn Locations For Some NPC +-- ================================ +UPDATE `creature` SET `position_x`= -9244.147461, `position_y`= 235.740646, `position_z`= 71.577263, `orientation`= 3.704285 WHERE `guid`= 79877; +UPDATE `creature` SET `position_x`= -9507.026367, `position_y`= -1275.854614, `position_z`= 44.156189, `orientation`= 5.165133 WHERE `guid`= 86156; +UPDATE `creature` SET `position_x`= -9511.991211, `position_y`= -1272.532349, `position_z`= 43.669014, `orientation`= 5.569613 WHERE `guid`= 86354; +UPDATE `creature` SET `position_x`= -9518.190430, `position_y`= -68.363617, `position_z`= 60.327618, `orientation`= 6.236413 WHERE `guid`= 81089; +UPDATE `creature` SET `position_x`= -9489.018555, `position_y`= -56.696945, `position_z`= 60.645180, `orientation`= 5.346557 WHERE `guid`= 80364; +UPDATE `creature` SET `position_x`= -9163.753906, `position_y`= 63.298267, `position_z`= 77.872536, `orientation`= 3.255852 WHERE `guid`= 80269; +UPDATE `creature` SET `position_x`= -9190.170898, `position_y`= 97.895546, `position_z`= 77.064575, `orientation`= 1.464358 WHERE `guid`= 80275; +UPDATE `creature` SET `position_x`= -9217.673828, `position_y`= 120.188568, `position_z`= 73.578117, `orientation`= 4.784237 WHERE `guid`= 79892; +UPDATE `creature` SET `position_x`= -9188.659180, `position_y`= 161.699066, `position_z`= 72.610321, `orientation`= 4.882412 WHERE `guid`= 79885; +UPDATE `creature` SET `position_x`= -9173.662109, `position_y`= 201.919647, `position_z`= 73.577454, `orientation`= 1.608088 WHERE `guid`= 80279; +UPDATE `creature` SET `position_x`= -9262.652344, `position_y`= 87.340912, `position_z`= 71.936546, `orientation`= 5.754992 WHERE `guid`= 79651; +UPDATE `creature` SET `position_x`= -9223.240234, `position_y`= -3.101168, `position_z`= 75.023117, `orientation`= 4.971950 WHERE `guid`= 80267; +UPDATE `creature` SET `position_x`= -9358.326172, `position_y`= 206.205505, `position_z`= 63.461060, `orientation`= 0.363235 WHERE `guid`= 99848; +UPDATE `creature` SET `position_x`= -9464.598633, `position_y`= 318.269775, `position_z`= 53.496414, `orientation`= 6.192464 WHERE `guid`= 80377; +UPDATE `creature` SET `position_x`= -9930.724609, `position_y`= 649.343994, `position_z`= 33.829231, `orientation`= 3.997278 WHERE `guid`= 99755; +UPDATE `creature` SET `position_x`= -9811.969727, `position_y`= 419.513855, `position_z`= 36.696804, `orientation`= 0.911452 WHERE `guid`= 80550; +UPDATE `creature` SET `position_x`= -9797.250000, `position_y`= 248.595947, `position_z`= 41.859764, `orientation`= 5.535091 WHERE `guid`= 80583; +UPDATE `creature` SET `position_x`= -9704.390625, `position_y`= -751.330322, `position_z`= 43.102699, `orientation`= 3.664274 WHERE `guid`= 80831; +UPDATE `creature` SET `position_x`= -9714.881836, `position_y`= -814.941406, `position_z`= 43.860264, `orientation`= 3.843344 WHERE `guid`= 80840; +UPDATE `creature` SET `position_x`= -9786.593750, `position_y`= -1634.226807, `position_z`= 40.922874, `orientation`= 3.684695 WHERE `guid`= 81429; +UPDATE `creature` SET `position_x`= -9825.492188, `position_y`= -1581.312988, `position_z`= 29.711246, `orientation`= 0.382879 WHERE `guid`= 81426; +UPDATE `creature` SET `position_x`= -9510.461914, `position_y`= -1525.946167, `position_z`= 61.068680, `orientation`= 6.159492 WHERE `guid`= 81402; +UPDATE `creature` SET `position_x`= -9388.416016, `position_y`= -1450.426270, `position_z`= 62.070576, `orientation`= 0.865909 WHERE `guid`= 81399; +UPDATE `creature` SET `position_x`= -9342.079102, `position_y`= -1324.494263, `position_z`= 62.389698, `orientation`= 1.183211 WHERE `guid`= 81261; +UPDATE `creature` SET `position_x`= -9382.169922, `position_y`= -1205.145996, `position_z`= 61.849808, `orientation`= 2.760291 WHERE `guid`= 81258; +UPDATE `creature` SET `position_x`= -8874.002930, `position_y`= -1049.129272, `position_z`= 74.976692, `orientation`= 3.535479 WHERE `guid`= 81334; +UPDATE `creature` SET `position_x`= -8863.762695, `position_y`= -923.313171, `position_z`= 75.733902, `orientation`= 2.185381 WHERE `guid`= 81156; +UPDATE `creature` SET `position_x`= -9320.486328, `position_y`= -280.694031, `position_z`= 69.539604, `orientation`= 2.526242 WHERE `guid`= 81109; +UPDATE `creature` SET `position_x`= -9174.646484, `position_y`= 97.281013, `position_z`= 76.462715, `orientation`= 1.231911 WHERE `guid`= 79887; +UPDATE `creature` SET `position_x`= -9892.141602, `position_y`= 203.173874, `position_z`= 14.096833, `orientation`= 2.141401 WHERE `guid`= 80599; + +-- ============================= +-- General Fix NPC Respawn Times - Existing Times Are Too Short For Almost All NPC +-- ============================= +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 30; -- Forest Spider (30) +UPDATE `creature` SET `spawntimesecs`=360 WHERE `id`= 40; -- Kobold Miner (40) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 43; -- Mine Spider (43) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 46; -- Murloc Forager (46) +UPDATE `creature` SET `spawntimesecs`=360 WHERE `id`= 94; -- Defias Catpurse (94) +UPDATE `creature` SET `spawntimesecs`=360 WHERE `id`= 97; -- Riverpaw Runt (97) +UPDATE `creature` SET `spawntimesecs`=180 WHERE `id`= 113; -- Stonetusk Boar (113) +UPDATE `creature` SET `spawntimesecs`=360 WHERE `id`= 116; -- Defias Bandit (116) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 118; -- Prowler (118) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 285; -- Murloc (285) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 299; -- Young Wolf (299) +UPDATE `creature` SET `spawntimesecs`=360 WHERE `id`= 327; -- Goldtooth (327) +UPDATE `creature` SET `spawntimesecs`=360 WHERE `id`= 448; -- Hogger (448) +UPDATE `creature` SET `spawntimesecs`=360 WHERE `id`= 474; -- Defias Rogue Wizard (474) +UPDATE `creature` SET `spawntimesecs`=360 WHERE `id`= 475; -- Kobold Tunneler (475) +UPDATE `creature` SET `spawntimesecs`=360 WHERE `id`= 476; -- Kobold Geomancer (476) +UPDATE `creature` SET `spawntimesecs`=360 WHERE `id`= 478; -- Riverpaw Outrunner (478) +UPDATE `creature` SET `spawntimesecs`=180 WHERE `id`= 524; -- Rockh`id`e Boar (524) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 525; -- Mangy Wolf (525) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 732; -- Murloc Lurker (732) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 822; -- Young Forest Bear (822) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 1922; -- Grey Forest Wolf (1922) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 6093; -- Dead-Tooth Jack (6093) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 6846; -- Defias Dockmaster (6846) +UPDATE `creature` SET `spawntimesecs`=300 WHERE `id`= 6927; -- Defias Dockworker (6927) |