diff options
| -rw-r--r-- | sql/updates/world/2015_04_11_01_world_f335.sql | 1126 |
1 files changed, 1126 insertions, 0 deletions
diff --git a/sql/updates/world/2015_04_11_01_world_f335.sql b/sql/updates/world/2015_04_11_01_world_f335.sql new file mode 100644 index 00000000000..cf227f03976 --- /dev/null +++ b/sql/updates/world/2015_04_11_01_world_f335.sql @@ -0,0 +1,1126 @@ +-- Add Gug +SET @ENTRY := 23144; +SET @GUID := 23428; +DELETE FROM `creature` WHERE `guid`=@GUID; +INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`) VALUES +(@GUID, @ENTRY, 530, -5119.803, 624.7665, 86.82748, 1.256637, 300, 3858); +DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY; +INSERT INTO `creature_template_addon` (`entry`, `bytes2`, `emote`) VALUES (@ENTRY, 4097, 133); + +-- Add spawns +SET @CGUID := 143596; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+297; +INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`) VALUES +(@CGUID+0, 23146, 530, -5143.491, 515.507, 84.50488, 4.834562, 300, 88860), -- Dragonmaw Enforcer +(@CGUID+1, 23146, 530, -5162.25, 534.2803, 82.78862, 5.183628, 300, 88860), +(@CGUID+2, 23146, 530, -5160.024, 561.3785, 82.47646, 0.05235988, 300, 88860), +(@CGUID+3, 23289, 530, -5141.078, 637.8817, 36.18917, 0, 300, 4299), -- 143599 -- Mine Car +(@CGUID+4, 23289, 530, -5158.637, 727.454, 45.57201, 0, 300, 4299), -- 143600 +(@CGUID+5, 23287, 530, -5229.827, 626.3266, 48.93023, 4.223697, 300, 4299), -- 23287 (Area: 3965) -- Murkblood Miner +(@CGUID+6, 23287, 530, -5160.776, 616.7452, 36.24147, 5.044002, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+7, 23287, 530, -5160.416, 658.8326, 38.73607, 3.106686, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+8, 23287, 530, -5163.108, 651.5301, 37.39709, 2.460914, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+9, 23287, 530, -5160.553, 678.9923, 41.02322, 2.792527, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+10, 23287, 530, -5161.212, 668.8508, 40.50122, 3.281219, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+11, 23287, 530, -5152.85, 621.4561, 35.87352, 5.166174, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+12, 23287, 530, -5157.459, 707.9813, 42.97822, 2.75762, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+13, 23287, 530, -5156.376, 687.0754, 41.27747, 2.80998, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+14, 23287, 530, -5138.036, 646.6555, 36.65028, 0.2443461, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+15, 23287, 530, -5144.963, 630.1486, 35.9286, 5.61996, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+16, 23287, 530, -5158.104, 699.1263, 42.52824, 3.473205, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+17, 23287, 530, -5139.44, 637.2499, 36.16368, 5.689773, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+18, 23287, 530, -5131.758, 701.3122, 41.26741, 0.5235988, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+19, 23287, 530, -5156.701, 715.8916, 43.45729, 3.106686, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+20, 23287, 530, -5121.366, 693.678, 38.92881, 1.361357, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+21, 23287, 530, -5097.448, 680.2379, 32.88943, 3.001966, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+22, 23287, 530, -5135.893, 721.6864, 44.35764, 0.08726646, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+23, 23287, 530, -5159.912, 725.4135, 45.55035, 3.333579, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+24, 23287, 530, -5140.923, 729.5199, 45.31025, 0.8726646, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+25, 23287, 530, -5079.597, 669.6569, 33.3003, 3.124139, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+26, 23287, 530, -5133.994, 712.6088, 42.61035, 0.2268928, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+27, 23287, 530, -5063.482, 624.7257, 27.56281, 2.338741, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+28, 23287, 530, -5080.878, 644.967, 32.68097, 2.426008, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+29, 23287, 530, -5100.418, 654.4422, 33.49445, 2.303835, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+30, 23287, 530, -5164.475, 734.2371, 47.03968, 3.438299, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+31, 23287, 530, -5058.134, 647.3507, 29.36781, 2.80998, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+32, 23287, 530, -5219.054, 621.868, 47.97065, 4.310963, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+33, 23287, 530, -5040.079, 627.7264, 19.75634, 2.373648, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+34, 23287, 530, -5018.824, 584.2097, 22.70727, 2.059489, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+35, 23287, 530, -4983.617, 632.3187, 20.58379, 3.054326, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+36, 23287, 530, -5019.396, 638.6277, 23.41907, 3.281219, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+37, 23287, 530, -5043.952, 595.3922, 18.24016, 2.094395, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+38, 23287, 530, -4969.858, 654.9359, 20.92751, 3.420845, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+39, 23287, 530, -4959.944, 591.9269, 12.99098, 1.989675, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+40, 23287, 530, -4968.715, 620.0629, 16.17488, 2.670354, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+41, 23287, 530, -4942.414, 582.1096, 9.914608, 2.129302, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+42, 23287, 530, -4959.944, 591.9269, 12.99098, 1.989675, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+43, 23287, 530, -4944.878, 561.5024, 7.636816, 2.094395, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+44, 23287, 530, -4921.915, 547.6068, 6.501626, 2.042035, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+45, 23287, 530, -4940.023, 535.2883, 7.127902, 1.675516, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+46, 23287, 530, -4904.557, 530.2072, 4.563097, 2.129302, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+47, 23287, 530, -4921.108, 528.4734, 6.568361, 2.042035, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+48, 23287, 530, -4887.938, 531.7214, 0.6247723, 3.054326, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+49, 23287, 530, -4965.987, 483.2187, 4.143906, 0.03490658, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+50, 23287, 530, -4918.072, 502.0591, 2.48006, 1.570796, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+51, 23287, 530, -4926.752, 455.5083, 1.527722, 1.396263, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+52, 23287, 530, -4981.036, 460.0726, 4.207428, 0.1745329, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+53, 23287, 530, -4937.384, 438.7227, 2.34031, 1.291544, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+54, 23287, 530, -4907.827, 475.5659, 0.8901013, 2.042035, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+55, 23287, 530, -4882.042, 472.4888, -3.117535, 3.228859, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+56, 23287, 530, -4941.028, 469.1831, 0.2023413, 1.064651, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+57, 23287, 530, -4950.465, 451.1373, 0.7255403, 0.9424778, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+58, 23287, 530, -4904.538, 420.0294, -5.088545, 2.443461, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+59, 23287, 530, -4959.418, 393.7061, -0.9294897, 4.520403, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+60, 23287, 530, -4956.983, 356.4414, -2.264346, 4.468043, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+61, 23287, 530, -4919.892, 307.3166, -13.13219, 3.403392, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+62, 23287, 530, -4970.338, 322.2038, -2.636889, 3.909538, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+63, 23287, 530, -4969.645, 298.882, -3.503148, 3.420845, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+64, 23287, 530, -4941.545, 294.6626, -8.814796, 3.263766, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+65, 23287, 530, -4994.479, 281.7764, -3.49516, 2.687807, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+66, 23287, 530, -5014.456, 279.3217, 0.06473933, 2.356194, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+67, 23287, 530, -4981.001, 267.0449, -6.299074, 2.565634, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+68, 23287, 530, -4966.653, 279.1325, -5.876964, 2.844887, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+69, 23287, 530, -4991.896, 300.7972, -1.304715, 3.281219, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+70, 23287, 530, -5009.957, 296.281, 2.063254, 2.792527, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+71, 23287, 530, -4973.297, 220.8183, -10.63328, 2.216568, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+72, 23287, 530, -4977.839, 252.8167, -8.2034, 2.408554, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+73, 23287, 530, -5011.099, 222.092, -10.51172, 1.815142, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+74, 23287, 530, -4995.983, 254.4959, -4.699264, 2.216568, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+75, 23287, 530, -5023.841, 241.114, -4.392029, 1.32645, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+76, 23287, 530, -5044.643, 201.4753, -11.86366, 0.8726646, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+77, 23287, 530, -5069.865, 170.6837, -9.401138, 0.8203048, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+78, 23287, 530, -5009.812, 160.8324, -14.7209, 2.75762, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+79, 23287, 530, -5067.464, 192.5109, -8.89424, 0.6457718, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+80, 23287, 530, -5041.76, 179.2009, -14.23692, 0.9599311, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+81, 23287, 530, -5051.51, 155.655, -12.63313, 1.396263, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+82, 23287, 530, -5090.02, 180.6597, -8.299232, 0.3490658, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+83, 23287, 530, -5085.621, 154.5083, -10.88531, 0.9075712, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+84, 23287, 530, -5056.444, 120.8188, -17.15018, 2.059489, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+85, 23287, 530, -5068.56, 141.5665, -13.4759, 1.082104, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+86, 23287, 530, -5115.295, 147.5993, -11.40529, 0.6457718, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+87, 23287, 530, -5109.351, 129.4899, -13.61424, 0.6283185, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+88, 23287, 530, -5107.625, 169.4426, -8.387082, 0.3490658, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+89, 23287, 530, -5118.663, 105.1847, -12.59805, 1.256637, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+90, 23287, 530, -5149.458, 152.029, -12.39146, 6.178465, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+91, 23287, 530, -5174.084, 155.2752, -12.23319, 6.021386, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+92, 23287, 530, -5198.479, 157.0766, -13.41456, 0.4712389, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+93, 23287, 530, -5178.485, 174.8304, -11.48918, 5.340707, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+94, 23287, 530, -5198.593, 202.2049, -13.6357, 5.113815, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+95, 23287, 530, -5189.779, 135.4848, -12.0408, 0.6806784, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+96, 23287, 530, -5229.695, 136.8613, -13.63386, 0.5585054, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+97, 23287, 530, -5218.991, 222.2088, -11.34154, 5.218534, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+98, 23287, 530, -5220.694, 199.7151, -12.80523, 5.951573, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+99, 23287, 530, -5247.149, 212.4612, -13.82043, 5.637414, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+100, 23287, 530, -5241.209, 231.7721, -11.93106, 5.51524, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+101, 23287, 530, -5023.841, 241.114, -4.392029, 1.32645, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+102, 23287, 530, -4937.384, 438.7227, 2.34031, 1.291544, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+103, 23287, 530, -4940.023, 535.2883, 7.127902, 1.675516, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+104, 23287, 530, -4959.944, 591.9269, 12.99098, 1.989675, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+105, 23287, 530, -4950.465, 451.1373, 0.7255403, 0.9424778, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+106, 23287, 530, -4991.896, 300.7972, -1.304715, 3.281219, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+107, 23287, 530, -4970.338, 322.2038, -2.636889, 3.909538, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+108, 23287, 530, -4969.645, 298.882, -3.503148, 3.420845, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+109, 23287, 530, -5069.865, 170.6837, -9.401138, 0.8203048, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+110, 23287, 530, -4959.418, 393.7061, -0.9294897, 4.520403, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+111, 23287, 530, -4926.752, 455.5083, 1.527722, 1.396263, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+112, 23287, 530, -4940.023, 535.2883, 7.127902, 1.675516, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+113, 23287, 530, -4921.108, 528.4734, 6.568361, 2.042035, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+114, 23287, 530, -4904.557, 530.2072, 4.563097, 2.129302, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+115, 23287, 530, -4983.617, 632.3187, 20.58379, 3.054326, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+116, 23287, 530, -4956.983, 356.4414, -2.264346, 4.468043, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+117, 23287, 530, -4965.987, 483.2187, 4.143906, 0.03490658, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+118, 23287, 530, -4941.028, 469.1831, 0.2023413, 1.064651, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+119, 23287, 530, -4940.023, 535.2883, 7.127902, 1.675516, 300, 4299), -- 23287 (Area: 3965) (Auras: 31261 - 31261) +(@CGUID+120, 23287, 530, -5178.181, 642.9128, 39.79438, 1.919862, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+121, 23287, 530, -5187.549, 638.7712, 41.74369, 1.954769, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+122, 23287, 530, -5170.539, 614.4111, 37.59125, 4.921828, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+123, 23287, 530, -5186.184, 617.5848, 42.23409, 4.34587, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+124, 23287, 530, -5219.594, 636.9407, 48.11805, 1.605703, 300, 4299), -- 23287 (Area: 3965 +(@CGUID+125, 23287, 530, -5209.468, 636.0561, 45.94989, 1.780236, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+126, 23287, 530, -5209.135, 619.5105, 46.42957, 4.502949, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+127, 23287, 530, -5197.959, 636.2016, 44.08671, 1.64061, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+128, 23287, 530, -5195.912, 618.5502, 44.35371, 4.555309, 300, 4299), -- 23287 (Area: 3965) +(@CGUID+129, 23169, 530, -5009.558, 687.8375, 18.86654, 1.480325, 300, 4299), -- 23169 (Area: 3965) -- Nethermine Flayer +(@CGUID+130, 23169, 530, -4967.988, 620.9315, 15.97108, 4.676374, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+131, 23169, 530, -4958.076, 598.2208, 13.32545, 5.52459, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+132, 23169, 530, -4979.914, 633.551, 20.30668, 2.572264, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+133, 23169, 530, -5013.305, 639.0559, 23.55437, 1.450203, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+134, 23169, 530, -4966.186, 655.6455, 20.22517, 2.583087, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+135, 23169, 530, -5010.128, 689.9114, 18.92688, 5.894914, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+136, 23169, 530, -4979.914, 633.551, 20.30668, 2.465721, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+137, 23169, 530, -5013.305, 639.0559, 23.55437, 1.212913, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+138, 23169, 530, -4958.076, 598.2208, 13.32545, 5.791277, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+139, 23169, 530, -4979.914, 633.551, 20.30668, 5.372581, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+140, 23169, 530, -5010.128, 689.9114, 18.92688, 6.151822, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+141, 23169, 530, -4966.186, 655.6455, 20.22517, 5.770682, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+142, 23169, 530, -4958.076, 598.2208, 13.32545, 5.80118, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+143, 23169, 530, -5013.305, 639.0559, 23.55437, 1.466077, 300, 4299), -- 23169 (Area: 3965 +(@CGUID+144, 23169, 530, -4919.305, 584.1595, 5.835848, 5.860526, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+145, 23169, 530, -4945.825, 567.2396, 8.357429, 4.963535, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+146, 23169, 530, -4920.444, 554.3483, 6.81108, 1.592739, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+147, 23169, 530, -4885.112, 529.7742, -0.07188316, 3.104875, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+148, 23169, 530, -4905.904, 531.3935, 4.766143, 4.255386, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+149, 23169, 530, -4958.076, 598.2208, 13.32545, 2.345144, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+150, 23169, 530, -4946.532, 565.8182, 8.39564, 2.171958, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+151, 23169, 530, -4971.019, 481.9048, 4.255131, 5.742048, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+152, 23169, 530, -4978.048, 461.4908, 3.580604, 1.284639, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+153, 23169, 530, -4910.448, 466.246, 1.150314, 4.61044, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+154, 23169, 530, -4922.486, 452.6082, 1.741542, 1.848747, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+155, 23169, 530, -4883.248, 474.9959, -2.790574, 0.4947965, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+156, 23169, 530, -4954.734, 439.9607, 2.19193, 0.7067229, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+157, 23169, 530, -4917.937, 430.3383, -1.619577, 5.612211, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+158, 23169, 530, -4958.768, 351.7107, -2.247269, 1.772254, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+159, 23169, 530, -5038.031, 350.875, 2.62308, 3.72062, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+160, 23169, 530, -4973.916, 319.2121, -2.417306, 1.525316, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+161, 23169, 530, -4931.086, 298.9532, -11.71306, 3.185381, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+162, 23169, 530, -5005.922, 290.7715, 0.05161196, 0.369805, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+163, 23169, 530, -5039.163, 319.1835, -3.561619, 3.754901, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+164, 23169, 530, -5010.779, 274.0312, -1.596922, 4.01841, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+165, 23169, 530, -4954.379, 295.0413, -5.898067, 2.82695, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+166, 23169, 530, -4991.504, 250.8047, -5.723885, 4.988063, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+167, 23169, 530, -5062.854, 293.8755, -8.149835, 3.967818, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+168, 23169, 530, -5018.055, 224.3272, -10.22529, 0.6886171, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+169, 23169, 530, -4976.179, 227.3799, -10.6006, 0.5956746, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+170, 23169, 530, -4935.262, 463.8304, 0.3223694, 0.1625037, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+171, 23169, 530, -4922.94, 501.7582, 2.849531, 5.342018, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+172, 23169, 530, -4975.554, 269.0946, -6.799523, 5.499429, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+173, 23169, 530, -4960.398, 355.0888, -1.787407, 5.133213, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+174, 23169, 530, -5016.044, 224.2127, -10.37248, 2.795499, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+175, 23169, 530, -5060.153, 197.7174, -9.609101, 3.258459, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+176, 23169, 530, -5049.03, 166.6831, -12.72408, 2.162152, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+177, 23169, 530, -4991.019, 249.8632, -5.817747, 2.753308, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+178, 23169, 530, -4977.148, 226.7941, -10.30185, 2.419013, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+179, 23169, 530, -5002.327, 291.3423, -0.9251177, 3.278219, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+180, 23169, 530, -5074.881, 159.3353, -10.2591, 1.89717, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+181, 23169, 530, -5094.841, 177.7091, -8.408723, 4.038786, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+182, 23169, 530, -5059.071, 126.2977, -16.5597, 5.170018, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+183, 23169, 530, -5109.454, 127.173, -13.81656, 1.71806, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+184, 23169, 530, -4954.41, 294.5933, -5.898048, 0.8626862, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+185, 23169, 530, -5116.198, 103.0558, -12.65989, 4.638427, 300, 4299), -- 23169 (Area: 3965) (Auras: ) +(@CGUID+186, 23169, 530, -5143.03, 145.8997, -12.47764, 2.741143, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+187, 23169, 530, -5110.538, 154.916, -10.57434, 1.115047, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+188, 23169, 530, -5047.887, 169.4041, -12.75727, 4.620065, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+189, 23169, 530, -5003.257, 159.8983, -14.73863, 0.2256795, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+190, 23169, 530, -5009.199, 275.662, -1.798863, 0.7142927, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+191, 23169, 530, -4975.545, 227.9456, -10.74416, 0.6228198, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+192, 23169, 530, -4991.768, 250.8438, -5.681248, 2.223132, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+193, 23169, 530, -5062.847, 293.5673, -8.190778, 4.098309, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+194, 23169, 530, -5001.911, 292.2764, -0.9095231, 1.151772, 300, 4299), -- 23169 (Area: 3965 +(@CGUID+195, 23169, 530, -4971.963, 318.408, -2.593545, 1.286586, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+196, 23169, 530, -5037.165, 349.7794, 2.602906, 3.60786, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+197, 23169, 530, -4932.7, 299.3089, -11.32172, 1.003917, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+198, 23169, 530, -5040.047, 317.9085, -4.035919, 4.635794, 300, 4299), -- 23169 (Area: 396 +(@CGUID+199, 23169, 530, -4957.847, 405.2784, 0.9240213, 3.046554, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+200, 23169, 530, -4948.438, 460.1876, 0.1027715, 0.9935466, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+201, 23169, 530, -4917.532, 431.2552, -1.466718, 2.644402, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+202, 23169, 530, -4955.563, 438.1111, 2.453238, 3.585394, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+203, 23169, 530, -4924.495, 453.2117, 1.67316, 0.4023848, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+204, 23169, 530, -4978.226, 457.8618, 3.579613, 5.989014, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+205, 23169, 530, -4910.379, 470.4026, 0.8641118, 1.141848, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+206, 23169, 530, -4970.949, 480.7429, 4.06482, 5.434553, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+207, 23169, 530, -4885.628, 472.7194, -2.342252, 6.117043, 300, 4299), -- 23169 (Area: 396 +(@CGUID+208, 23169, 530, -4919.86, 502.4582, 2.580096, 3.676699, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+209, 23169, 530, -4919.363, 552.8414, 6.88634, 6.262745, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+210, 23169, 530, -4946.429, 566.189, 8.320451, 0.8319092, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+211, 23169, 530, -4884.078, 530.2368, -0.2521183, 4.288206, 300, 4299), -- 23169 (Area: 396 +(@CGUID+212, 23169, 530, -4934.582, 535.1161, 6.564591, 4.536118, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+213, 23169, 530, -4906.604, 532.5593, 4.957226, 1.968214, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+214, 23169, 530, -4920.163, 587.0939, 6.468598, 2.24315, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+215, 23169, 530, -4959.686, 596.4736, 13.12449, 5.048675, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+216, 23169, 530, -4978.36, 633.9875, 19.98329, 0.7612703, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+217, 23169, 530, -4962.661, 656.2208, 19.60664, 2.322476, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+218, 23169, 530, -5015.241, 641.3285, 23.3768, 3.365274, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+219, 23169, 530, -5010.128, 689.9114, 18.78944, 2.978981, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+220, 23169, 530, -5077.739, 333.02, 5.179652, 2.509581, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+221, 23169, 530, -5019.065, 222.1603, -10.62667, 4.953171, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+222, 23169, 530, -4979.019, 269.4832, -6.478584, 3.350721, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+223, 23169, 530, -5058.351, 196.9229, -9.941554, 5.702285, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+224, 23169, 530, -5092.194, 181.7484, -8.519144, 6.063996, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+225, 23169, 530, -5071.979, 158.8044, -10.67218, 0.01778779, 300, 4299), -- 23169 (Area: 3965) +(@CGUID+226, 23326, 530, -5001.687, 643.4487, 22.84591, 5.311926, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) -- nethermine ravager +(@CGUID+227, 23326, 530, -5016.762, 689.4977, 18.98941, 4.254198, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+228, 23326, 530, -4948.338, 574.87, 9.780287, 5.182978, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+229, 23326, 530, -4978.119, 622.5638, 18.00215, 2.614223, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+230, 23326, 530, -4967.506, 658.9974, 20.74481, 3.170801, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+231, 23326, 530, -4957.431, 584.6068, 12.20244, 1.852743, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+232, 23326, 530, -5005.486, 644.3996, 22.76456, 1.884956, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+233, 23326, 530, -5015.393, 692.0869, 18.86917, 2.075273, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+234, 23326, 530, -4967.506, 658.9974, 20.74481, 0.5888432, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+235, 23326, 530, -4978.119, 622.5638, 18.00215, 1.621879, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+236, 23326, 530, -5005.486, 644.3996, 22.76456, 1.646531, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+237, 23326, 530, -5015.393, 692.0869, 18.86917, 3.379317, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+238, 23326, 530, -4951.823, 581.4465, 11.22198, 2.676563, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+239, 23326, 530, -4946.557, 579.6539, 10.15224, 1.13619, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+240, 23326, 530, -4928.474, 480.4054, -0.1783632, 0.9677349, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+241, 23326, 530, -4918.411, 483.8331, 0.07626688, 2.36952, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+242, 23326, 530, -4921.181, 439.6729, 0.8384005, 0.5438383, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+243, 23326, 530, -4952.597, 401.4749, -0.3538051, 3.418738, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+244, 23326, 530, -4868.084, 531.6934, -1.683346, 3.018919, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+245, 23326, 530, -4965.881, 349.554, -1.536497, 4.615863, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+246, 23326, 530, -4971.478, 304.6561, -3.048606, 5.414115, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+247, 23326, 530, -4953.476, 284.0535, -6.819366, 4.314682, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+248, 23326, 530, -5014.135, 288.1924, 1.793531, 5.620615, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+249, 23326, 530, -4962.295, 381.2368, -1.744818, 4.602769, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+250, 23326, 530, -4995.37, 236.0123, -7.475551, 5.915942, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+251, 23326, 530, -5046.238, 204.7434, -11.17455, 0.3013434, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+252, 23326, 530, -5015.046, 264.2135, -0.9630037, 4.380797, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+253, 23326, 530, -5054.073, 191.3642, -11.12945, 4.913056, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+254, 23326, 530, -5068.295, 161.4686, -10.65775, 3.185342, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+255, 23326, 530, -5084.805, 170.5898, -8.363562, 2.470629, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+256, 23326, 530, -5118.899, 113.8509, -12.95813, 1.053266, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+257, 23326, 530, -5121.38, 140.2108, -12.24173, 4.717645, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+258, 23326, 530, -5028.928, 162.4327, -14.69674, 4.598915, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+259, 23326, 530, -5013.326, 287.5868, 1.554583, 2.353504, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+260, 23326, 530, -5162.3, 147.2595, -13.68486, 2.213196, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+261, 23326, 530, -5195.16, 185.9774, -12.47411, 2.135337, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+262, 23326, 530, -5185.331, 154.8984, -12.49722, 5.532097, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+263, 23326, 530, -5028.03, 163.2786, -14.87766, 0.7552983, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+264, 23326, 530, -5055.308, 191.3719, -10.81202, 0.5039104, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+265, 23326, 530, -4995.011, 236.3476, -7.462594, 6.063029, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+266, 23326, 530, -5037.676, 207.097, -11.84669, 3.400416, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+267, 23326, 530, -5038.441, 207.0967, -11.75817, 3.849093, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732 +(@CGUID+268, 23326, 530, -4949.182, 294.4462, -6.966339, 0.678574, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+269, 23326, 530, -4973.03, 308.0056, -2.714836, 1.892263, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+270, 23326, 530, -4967.495, 349.8932, -1.395857, 2.333905, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+271, 23326, 530, -4950.731, 403.7043, -0.1075567, 0.8233353, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+272, 23326, 530, -4921.817, 439.4337, 0.8760551, 3.996498, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+273, 23326, 530, -4906.549, 472.265, 0.7405176, 2.369046, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+274, 23326, 530, -4942.342, 455.2948, 0.785726, 3.048413, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+275, 23326, 530, -4927.634, 480.4459, -0.2140773, 3.812036, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+276, 23326, 530, -4917.617, 533.3819, 6.377127, 4.497816, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+277, 23326, 530, -4947.289, 577.6053, 9.956731, 4.047926, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+278, 23326, 530, -4916.31, 586.3352, 5.467452, 0.6311421, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+279, 23326, 530, -4979.853, 626.7228, 18.89969, 2.537099, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+280, 23326, 530, -4968.971, 659.8459, 20.95211, 0.4729249, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+281, 23326, 530, -5002.798, 646.2766, 22.85282, 0.4368325, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+282, 23326, 530, -5084.679, 170.6154, -8.364773, 2.919591, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+283, 23326, 530, -5069.651, 161.7928, -10.45241, 3.358221, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+284, 23326, 530, -5122.319, 139.8094, -12.27753, 4.208749, 300, 3224), -- 23326 (Area: 3965) (Auras: 32732 - 32732) +(@CGUID+285, 23309, 530, -4860.765, 468.7788, -5.74204, 4.24115, 300, 4299), -- 23309 (Area: 3965) -- murkblood overseer +(@CGUID+286, 23324, 530, -5196.179, 166.8186, -12.59387, 4.930552, 300, 4299), -- 23324 (Area: 3965) (Auras: 40743 - 40743) Crazed Murkblood Miner +(@CGUID+287, 23324, 530, -5210.658, 146.5081, -14.06982, 3.909939, 300, 4299), -- 23324 (Area: 3965) (Auras: 40743 - 40743) +(@CGUID+288, 23324, 530, -5178.911, 173.927, -11.54059, 1.130439, 300, 4299), -- 23324 (Area: 3965) (Auras: 40743 - 40743) (possible waypoints or random movement) +(@CGUID+289, 23324, 530, -5192.216, 133.6122, -12.00781, 2.232028, 300, 4299), -- 23324 (Area: 3965) (possible waypoints or random movement) +(@CGUID+290, 23324, 530, -5179.031, 152.351, -12.46348, 4.376995, 300, 4299), -- 23324 (Area: 3965) (possible waypoints or random movement) +(@CGUID+291, 23324, 530, -5236.018, 198.761, -13.93909, 1.100167, 300, 4299), -- 23324 (Area: 3965) (Auras: 40743 - 40743) +(@CGUID+292, 23324, 530, -5210.276, 207.8238, -12.79146, 1.512519, 300, 4299), -- 23324 (Area: 3965) (Auras: 40743 - 40743) (possible waypoints or random movement) +(@CGUID+293, 23324, 530, -5230.436, 213.0719, -12.7647, 4.868175, 300, 4299), -- 23324 (Area: 3965) (Auras: 40743 - 40743) (possible waypoints or random movement) +(@CGUID+294, 23324, 530, -5254.496, 210.4873, -13.75615, 5.228326, 300, 4299), -- 23324 (Area: 3965) (Auras: 40743 - 40743) (possible waypoints or random movement) +(@CGUID+295, 23324, 530, -5224.815, 227.1456, -10.97935, 5.068825, 300, 4299), -- 23324 (Area: 3965) (possible waypoints or random movement) +(@CGUID+296, 23305, 530, -5223.799, 139.1362, -13.6459, 5.91905, 300, 4299), -- 23305 (Area: 3965) (Auras: 40743 - 40743) (possible waypoints or random movement) Crazed Murkblood Foreman +(@CGUID+297, 23305, 530, -5247.993, 226.5564, -12.5696, 3.970754, 300, 4299); -- 23305 (Area: 3965) (Auras: 40743 - 40743) + +-- Remove dubble spawns +DELETE FROM `creature` WHERE `guid` IN (143638, 143631, 143641, 143643, 143642, 143714, 143707, 143701, 143649, 143706, 143656, 143658, 143659, 143665, 48234, 48235, 48236, 48237, 48241, 48240, 48239, 48238, 48242, 48243, 48229, 48232, 48233, 48231, 48230, 48245, 48244, 48251, 48246, 48248, 48247, 48253, 48252, 48256, 48255, 48254, 48249, 48250, 143880, 143820, 143878, 143820, 143776, 143820, 143847, 143860, 143784, 143771, 143862, 143817, 143770, 143774, 143765, 143773, 143772, 143786, 143855, 143758, 143775, 143818, 143761, 143793, 143842, 143791, 143866, 143754, 143867, 143752, 143797, 143868, 143750, 143749, 143803, 143836, 143748, 143747, 143804, 143744, 143807, 143805, 143740, 143741, 143806, 143824, 143873, 143835, 143727, 143738, 143734, 143825, 143831, 143728, 143812, 143835, 143730, 143813, 143826, 143828, 143739, 143814, 143729, 143823, 143829, 143725, 143736, 143815, 143832, 143830, 143732, 143811, 52032, 143792, 143759, 143789, 52021, 52023, 52022, 52020, 52024, 52016, 52017, 52018, 52015, 52014,52019, 48257, 52013, 52011, 52012, 48258, 52030, 52031, 143762, 143846); + +-- update spawn distance +UPDATE `creature` SET `spawndist`=4 WHERE `id` IN (23326, 23169); +UPDATE `creature` SET `MovementType`=1 WHERE `id` IN (23326, 23169); + +-- Change weapons are sheathed for 23376 +SET @ENTRY := 23376; +DELETE FROM `creature_template_addon` WHERE `entry`=@ENTRY; +INSERT INTO `creature_template_addon` (`entry`) VALUES (@ENTRY); + +-- Remove existing mine cars +DELETE FROM `creature` WHERE `guid` IN (370643, 52334, 52335); + +-- Make Murkblood Miner spawn dead +DELETE FROM `creature_template_addon` WHERE `entry`=23287; +INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`, `auras`) VALUES (23287, 0, 1, 31261); + +-- Add aura to nethermine ravager +DELETE FROM `creature_template_addon` WHERE `entry`=23326; +INSERT INTO `creature_template_addon` (`entry`, `bytes1`, `bytes2`, `auras`) VALUES (23326, 0, 0, 32732); + +-- Mine Car SAI +SET @ENTRY := 23289; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,25,0,100,0,0,0,0,0,11,40684,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mine Car - On Reset - Cast 'Mine Cart'"), +(@ENTRY,0,1,0,38,0,100,0,1,1,0,0,103,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Mine Car - On Data Set 1 1 - Set Rooted On"), +(@ENTRY,0,2,0,38,0,100,0,1,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Mine Car - On Data Set 1 0 - Resume Waypoint"); + +-- Dragonmaw Foreman SAI +SET @ENTRY := 23376; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,10,143599,23289,0,0,0,0,0,"Dragonmaw Foreman - In Combat - Set Data 1 1"), +(@ENTRY,0,1,0,25,0,100,0,0,0,0,0,45,1,0,0,0,0,0,10,143599,23289,0,0,0,0,0,"Dragonmaw Foreman - On Reset - Set Data 1 0"), +(@ENTRY,0,2,0,25,0,100,0,0,0,0,0,45,1,0,0,0,0,0,10,143600,23289,0,0,0,0,0,"Dragonmaw Foreman - On Reset - Set Data 1 0"), +(@ENTRY,0,3,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,10,143600,23289,0,0,0,0,0,"Dragonmaw Foreman - In Combat - Set Data 1 1"); + +-- Crazed Murkblood Miner SAI +SET @ENTRY := 23324; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,60000,120000,60000,120000,11,40743,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crazed Murkblood Miner - Out of Combat - Cast 'Frenzy'"); + +-- Crazed Murkblood Foreman SAI +SET @ENTRY := 23305; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,1,0,100,0,60000,120000,60000,120000,11,40743,0,0,0,0,0,1,0,0,0,0,0,0,0,"Crazed Murkblood Foreman - Out of Combat - Cast 'Frenzy'"); + +-- Add creature addon +DELETE FROM `creature_addon` WHERE `guid` IN (143601, 143628, 143720, 143721, 143724, 143719, 143718, 143602, 143607, 143611, 143613, 143610, 143616, 143614, 143622, 143618, 143620, 143626, 143619, 143615, 143612, 143609, 1436058, 143606, 143603, 143604, 143716, 143717, 143723, 143605, 143722); +INSERT INTO `creature_addon` (`guid`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(143601, 0, 1, 233, NULL), +(143628, 0, 1, 233, NULL), +(143720, 0, 1, 233, NULL), +(143721, 0, 1, 233, NULL), +(143724, 0, 1, 233, NULL), +(143719, 0, 1, 233, NULL), +(143718, 0, 1, 233, NULL), +(143602, 0, 1, 233, NULL), +(143607, 0, 1, 233, NULL), +(143611, 0, 1, 233, NULL), +(143613, 0, 1, 233, NULL), +(143610, 0, 1, 233, NULL), +(143616, 0, 1, 233, NULL), +(143614, 0, 1, 233, NULL), +(143622, 0, 1, 233, NULL), +(143618, 0, 1, 233, NULL), +(143620, 0, 1, 233, NULL), +(143626, 0, 1, 233, NULL), +(143619, 0, 1, 233, NULL), +(143615, 0, 1, 233, NULL), +(143612, 0, 1, 233, NULL), +(143609, 0, 1, 233, NULL), +(143605, 0, 1, 233, NULL), +(143606, 0, 1, 233, NULL), +(143603, 0, 1, 233, NULL), +(143604, 0, 1, 233, NULL), +(143716, 0, 1, 233, NULL), +(143717, 0, 1, 233, NULL), +(143723, 0, 1, 233, NULL), +(143722, 0, 1, 233, NULL); + +-- Update position +UPDATE `creature` SET `position_x`=-5165.002, `position_y`=534.0313, `position_z`=82.90166, `orientation`=3.857178 WHERE `guid`=52106; +UPDATE `creature` SET `position_x`=-5146.481, `position_y`=517.6528, `position_z`=85.1688, `orientation`=3.351032 WHERE `guid`=52109; +UPDATE `creature` SET `position_x`=-5166.383, `position_y`=563.9937, `position_z`=80.58907, `orientation`=3.211406 WHERE `guid`=52107; +UPDATE `creature` SET `position_x`=-5128.689, `position_y`=579.8379, `position_z`=85.25567, `orientation`=0.2617994 WHERE `guid`=52112; +UPDATE `creature` SET `position_x`=-5133.728, `position_y`=591.6107, `position_z`=84.34083, `orientation`=0.08726646 WHERE `guid`=52111; +UPDATE `creature` SET `position_x`=-5103.687, `position_y`=585.6875, `position_z`=85.79736, `orientation`=2.111848 WHERE `guid`=52114; +UPDATE `creature` SET `position_x`=-5079.457, `position_y`=538.1425, `position_z`=86.41579, `orientation`=5.5676 WHERE `guid`=52231; +UPDATE `creature` SET `position_x`=-5094.562, `position_y`=596.6859, `position_z`=86.2102, `orientation`=2.617994 WHERE `guid`=52115; +UPDATE `creature` SET `position_x`=-5102.299, `position_y`=623.4721, `position_z`=86.07585, `orientation`=1.413717 WHERE `guid`=52113; +UPDATE `creature` SET `position_x`=-5089.073, `position_y`=616.179, `position_z`=85.79301, `orientation`=1.082104 WHERE `guid`=52230; +UPDATE `creature` SET `position_x`=-5162.11, `position_y`=629.679, `position_z`=79.66261, `orientation`=2.199115 WHERE `guid`=52108; +UPDATE `creature` SET `position_x`=-5146.516, `position_y`=639.3836, `position_z`=81.87501, `orientation`=2.321288 WHERE `guid`=52110; + +-- Update position Ronag the slave driver +UPDATE `creature` SET `position_x`=-5161.059, `position_y`=288.1674, `position_z`=-27.11326, `orientation`=5.078908 WHERE `guid`=40729; + +-- Update mistress of the mine positions +UPDATE `creature` SET `position_x`=-5254.184, `position_y`=628.4734, `position_z`=48.99072, `orientation`=2.617994 WHERE `guid`=88898; + +-- Update toranaku position +UPDATE `creature` SET `position_x`=-5133.719, `position_y`=227.1979, `position_z`=-26.26821, `orientation`=2.059489 WHERE `guid`=40740; + +-- Update murkblood overseer positions +UPDATE `creature` SET `position_x`=-4898.184, `position_y`=411.9311, `position_z`=-5.810406, `orientation`=3.368485 WHERE `guid`=43919; +UPDATE `creature` SET `position_x`=-4907.272, `position_y`=314.5579, `position_z`=-12.17146, `orientation`=1.518436 WHERE `guid`=40742; +UPDATE `creature` SET `position_x`=-4961.051, `position_y`=211.6252, `position_z`=-10.97874, `orientation`=4.031711 WHERE `guid`=42566; +UPDATE `creature` SET `position_x`=-4979.739, `position_y`=161.6144, `position_z`=-15.42497, `orientation`=2.670354 WHERE `guid`=48228; + +-- Add missing mistress of the mine +SET @ENTRY := 23149; +SET @GUID := 23430; +DELETE FROM `creature` WHERE `guid`=@GUID; +INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`) VALUES +(@GUID, @ENTRY, 530, -5165.22, 757.3012, 49.79086, 2.932153, 25, 104790); + +DELETE FROM `creature_addon` WHERE `guid` IN (143846, 143847, 52283, 23144); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=143599; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES +(143599, 143599, 0, 0, 1), +(143599, 52345, 2, 0, 2); + +-- Pathing for Mine Car Entry: 23289 'TDB FORMAT' +SET @NPC := 143599; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5141.078,`position_y`=637.8817,`position_z`=36.18917 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5141.078,637.8817,36.18917,0,0,0,0,100,0), -- 17:08:25 +(@PATH,2,-5140.013,643.7603,36.68985,0,0,0,0,100,0), -- 17:08:26 +(@PATH,3,-5139.763,645.5103,36.93985,0,0,0,0,100,0), -- 17:08:26 +(@PATH,4,-5139.761,650.6669,37.334,0,0,0,0,100,0), -- 17:08:30 +(@PATH,5,-5140.261,653.6669,37.834,0,0,0,0,100,0), -- 17:08:30 +(@PATH,6,-5140.511,657.9169,38.084,0,0,0,0,100,0), -- 17:08:30 +(@PATH,7,-5147.932,667.6057,41.11486,0,0,0,0,100,0), -- 17:08:36 +(@PATH,8,-5151.682,670.6057,41.36486,0,0,0,0,100,0), -- 17:08:36 +(@PATH,9,-5154.71,670.9447,41.20504,0,0,0,0,100,0), -- 17:08:42 +(@PATH,10,-5157.904,664.1409,40.12909,0,0,0,0,100,0), -- 17:08:44 +(@PATH,11,-5157.904,660.6409,39.87909,0,0,0,0,100,0), -- 17:08:44 +(@PATH,12,-5161.058,651.3033,37.78137,0,0,0,0,100,0), -- 17:08:49 +(@PATH,13,-5164.057,648.1979,37.81743,0,0,0,0,100,0), -- 17:08:51 +(@PATH,14,-5165.057,647.4479,37.56743,0,0,0,0,100,0), -- 17:08:51 +(@PATH,15,-5167.557,645.1979,37.81743,0,0,0,0,100,0), -- 17:08:51 +(@PATH,16,-5170.843,644.0839,38.46222,0,0,0,0,100,0), -- 17:08:55 +(@PATH,17,-5172.093,643.3339,38.71222,0,0,0,0,100,0), -- 17:08:55 +(@PATH,18,-5173.593,642.8339,38.96222,0,0,0,0,100,0), -- 17:08:55 +(@PATH,19,-5186.051,637.8183,41.7608,0,0,0,0,100,0), -- 17:09:00 +(@PATH,20,-5189.714,636.5399,42.51512,0,0,0,0,100,0), -- 17:09:04 +(@PATH,21,-5191.214,636.2899,42.76512,0,0,0,0,100,0), -- 17:09:04 +(@PATH,22,-5197.214,634.7899,44.26512,0,0,0,0,100,0), -- 17:09:04 +(@PATH,23,-5203.103,634.7686,45.08968,0,0,0,0,100,0), -- 17:09:09 +(@PATH,24,-5206.103,634.7686,45.58968,0,0,0,0,100,0), -- 17:09:09 +(@PATH,25,-5209.806,634.6367,46.42096,0,0,0,0,100,0), -- 17:09:13 +(@PATH,26,-5213.186,634.7311,46.78786,0,0,0,0,100,0), -- 17:09:16 +(@PATH,27,-5213.186,634.7311,46.78786,3.057303,13000,0,0,100,0), -- 17:09:16 +(@PATH,28,-5220.281,635.3306,48.28771,0,0,0,0,100,0), -- 17:09:23 +(@PATH,29,-5225.046,631.6472,48.62878,0,0,0,0,100,0), -- 17:09:24 +(@PATH,30,-5226.796,630.3972,48.62878,0,0,0,0,100,0), -- 17:09:24 +(@PATH,31,-5228.296,629.1472,48.87878,0,0,0,0,100,0), -- 17:09:24 +(@PATH,32,-5229.272,628.4141,49.11567,0,0,0,0,100,0), -- 17:09:29 +(@PATH,33,-5212.051,622.3498,47.22783,0,0,0,0,100,0), -- 17:09:34 +(@PATH,34,-5206.287,621.1569,46.21485,0,0,0,0,100,0), -- 17:09:39 +(@PATH,35,-5186.77,619.8926,42.72266,0,0,0,0,100,0), -- 17:09:44 +(@PATH,36,-5183.428,619.211,41.72144,0,0,0,0,100,0), -- 17:09:47 +(@PATH,37,-5180.678,618.461,40.97144,0,0,0,0,100,0), -- 17:09:47 +(@PATH,38,-5177.428,617.961,39.97144,0,0,0,0,100,0), -- 17:09:47 +(@PATH,39,-5163.798,617.6891,36.96609,0,0,0,0,100,0), -- 17:09:53 +(@PATH,40,-5157.38,620.9669,36.305,0,0,0,0,100,0), -- 17:09:58 +(@PATH,41,-5155.63,622.2169,36.305,0,0,0,0,100,0), -- 17:09:58 +(@PATH,42,-5151.773,625.8492,36.2674,0,0,0,0,100,0), -- 17:10:02 +(@PATH,43,-5147.023,630.5992,36.0174,0,0,0,0,100,0), -- 17:10:02 +(@PATH,44,-5151.613,626.0107,36.01761,0,0,0,0,100,0), -- 17:10:04 +(@PATH,45,-5151.613,626.0107,36.01761,0.7864318,13000,0,0,100,0), -- 17:10:04 +(@PATH,46,-5147.015,630.6146,36.24972,0,0,0,0,100,0), -- 17:10:12 +(@PATH,47,-5146.276,631.5181,36.09008,0,0,0,0,100,0), -- 17:10:13 +(@PATH,48,-5139.943,643.661,36.66342,0,0,0,0,100,0), -- 17:10:17 +(@PATH,49,-5139.693,645.661,36.91342,0,0,0,0,100,0), -- 17:10:17 +(@PATH,50,-5139.456,647.1063,37.25185,0,0,0,0,100,0), -- 17:10:20 +(@PATH,51,-5139.706,650.6063,37.25185,0,0,0,0,100,0), -- 17:10:20 +(@PATH,52,-5140.206,653.6063,37.75185,0,0,0,0,100,0), -- 17:10:20 +(@PATH,53,-5140.706,657.8563,38.25185,0,0,0,0,100,0), -- 17:10:20 +(@PATH,54,-5148.056,667.8259,41.13531,0,0,0,0,100,0), -- 17:10:26 +(@PATH,55,-5151.806,670.5759,41.38531,0,0,0,0,100,0), -- 17:10:26 +(@PATH,56,-5154.813,670.973,41.23766,0,0,0,0,100,0), -- 17:10:34 +(@PATH,57,-5157.935,667.3557,40.72045,0,0,0,0,100,0), -- 17:10:35 +(@PATH,58,-5157.935,664.1057,40.22045,0,0,0,0,100,0), -- 17:10:35 +(@PATH,59,-5157.935,660.6057,39.72045,0,0,0,0,100,0), -- 17:10:35 +(@PATH,60,-5158.109,661.8198,39.61253,0,0,0,0,100,0), -- 17:10:40 +(@PATH,61,-5158.109,661.8198,39.61253,4.732054,13000,0,0,100,0), -- 17:10:40 +(@PATH,62,-5158.071,660.382,39.43446,0,0,0,0,100,0), -- 17:10:47 +(@PATH,63,-5161.05,651.4003,37.68608,0,0,0,0,100,0), -- 17:10:48 +(@PATH,64,-5164.23,648.3284,37.75933,0,0,0,0,100,0), -- 17:10:51 +(@PATH,65,-5164.98,647.5784,37.75933,0,0,0,0,100,0), -- 17:10:51 +(@PATH,66,-5167.73,645.3284,37.75933,0,0,0,0,100,0), -- 17:10:51 +(@PATH,67,-5170.907,644.0687,38.51237,0,0,0,0,100,0), -- 17:10:54 +(@PATH,68,-5172.157,643.5687,38.76237,0,0,0,0,100,0), -- 17:10:54 +(@PATH,69,-5173.657,642.8187,39.01237,0,0,0,0,100,0), -- 17:10:54 +(@PATH,70,-5186.038,637.9409,41.76183,0,0,0,0,100,0), -- 17:10:58 +(@PATH,71,-5189.85,636.6265,42.57893,0,0,0,0,100,0), -- 17:11:03 +(@PATH,72,-5191.35,636.3765,42.82893,0,0,0,0,100,0), -- 17:11:03 +(@PATH,73,-5197.35,634.8765,44.32893,0,0,0,0,100,0), -- 17:11:03 +(@PATH,74,-5202.985,634.672,45.20214,0,0,0,0,100,0), -- 17:11:07 +(@PATH,75,-5206.235,634.672,45.45214,0,0,0,0,100,0), -- 17:11:07 +(@PATH,76,-5209.681,634.6359,46.49954,0,0,0,0,100,0), -- 17:11:12 +(@PATH,77,-5225.227,631.6835,48.47477,0,0,0,0,100,0), -- 17:11:16 +(@PATH,78,-5226.727,630.4335,48.72477,0,0,0,0,100,0), -- 17:11:16 +(@PATH,79,-5228.477,629.1835,48.97477,0,0,0,0,100,0), -- 17:11:16 +(@PATH,80,-5229.123,628.397,49.13941,0,0,0,0,100,0), -- 17:11:21 +(@PATH,81,-5212.127,622.4219,47.1857,0,0,0,0,100,0), -- 17:11:26 +(@PATH,82,-5206.309,621.397,46.11539,0,0,0,0,100,0), -- 17:11:29 +(@PATH,83,-5200.812,620.8071,45.10049,0,0,0,0,100,0), -- 17:11:34 +(@PATH,84,-5200.812,620.8071,45.10049,6.201494,13000,0,0,100,0), -- 17:11:34 +(@PATH,85,-5196.44,620.4492,44.38279,0,0,0,0,100,0), -- 17:11:42 +(@PATH,86,-5186.816,619.8555,42.8981,0,0,0,0,100,0), -- 17:11:43 +(@PATH,87,-5183.516,619.1785,41.63834,0,0,0,0,100,0), -- 17:11:46 +(@PATH,88,-5180.766,618.4285,40.88834,0,0,0,0,100,0), -- 17:11:46 +(@PATH,89,-5177.516,617.9285,39.88834,0,0,0,0,100,0), -- 17:11:46 +(@PATH,90,-5163.909,617.6057,37.10681,0,0,0,0,100,0), -- 17:11:53 +(@PATH,91,-5157.449,621.0334,36.26365,0,0,0,0,100,0), -- 17:11:57 +(@PATH,92,-5155.699,622.2834,36.26365,0,0,0,0,100,0), -- 17:11:57 +(@PATH,93,-5154.149,623.4669,36.08303,0,0,0,0,100,0), -- 17:12:00 +(@PATH,94,-5152.149,625.7169,36.08303,0,0,0,0,100,0), -- 17:12:00 +(@PATH,95,-5146.899,630.7169,36.08303,0,0,0,0,100,0), -- 17:12:00 +(@PATH,96,-5146.199,631.3462,36.08583,0,0,0,0,100,0), -- 17:12:05 +(@PATH,97,-5139.907,643.7687,36.67455,0,0,0,0,100,0), -- 17:12:08 +(@PATH,98,-5139.657,645.5187,36.92455,0,0,0,0,100,0), -- 17:12:08 +(@PATH,99,-5139.875,650.5488,37.28083,0,0,0,0,100,0), -- 17:12:12 +(@PATH,100,-5140.125,653.5488,37.78083,0,0,0,0,100,0), -- 17:12:12 +(@PATH,101,-5140.625,657.7988,38.28083,0,0,0,0,100,0), -- 17:12:12 +(@PATH,102,-5148.108,667.7523,40.98037,0,0,0,0,100,0), -- 17:12:18 +(@PATH,103,-5151.608,670.7523,41.48037,0,0,0,0,100,0), -- 17:12:18 +(@PATH,104,-5141.205,661.6332,38.87123,0,0,0,0,100,0), -- 17:12:19 +(@PATH,105,-5141.205,661.6332,38.87123,1.692706,13000,0,0,100,0), -- 17:12:19 +(@PATH,106,-5151.783,670.6835,41.29935,0,0,0,0,100,0), -- 17:12:27 +(@PATH,107,-5154.538,671.0463,41.41257,0,0,0,0,100,0), -- 17:12:31 +(@PATH,108,-5157.866,664.149,40.19033,0,0,0,0,100,0), -- 17:12:34 +(@PATH,109,-5157.866,660.649,39.69033,0,0,0,0,100,0), -- 17:12:34 +(@PATH,110,-5159.319,655.634,38.41046,0,0,0,0,100,0), -- 17:12:39 +(@PATH,111,-5161.069,651.384,37.91046,0,0,0,0,100,0), -- 17:12:39 +(@PATH,112,-5164.453,648.3511,37.68428,0,0,0,0,100,0), -- 17:12:42 +(@PATH,113,-5164.953,647.6011,37.68428,0,0,0,0,100,0), -- 17:12:42 +(@PATH,114,-5167.703,645.3511,37.93428,0,0,0,0,100,0), -- 17:12:42 +(@PATH,115,-5171.067,643.7227,38.57786,0,0,0,0,100,0), -- 17:12:46 +(@PATH,116,-5172.317,643.4727,38.57786,0,0,0,0,100,0), -- 17:12:46 +(@PATH,117,-5173.567,642.9727,39.07786,0,0,0,0,100,0), -- 17:12:46 +(@PATH,118,-5186.047,637.7537,41.88425,0,0,0,0,100,0), -- 17:12:50 +(@PATH,119,-5177.467,641.3476,39.69143,0,0,0,0,100,0), -- 17:12:51 +(@PATH,120,-5177.467,641.3476,39.69143,3.542526,13000,0,0,100,0), -- 17:12:51 +(@PATH,121,-5186.172,637.7469,41.72967,0,0,0,0,100,0), -- 17:12:58 +(@PATH,122,-5189.829,636.4236,42.40816,0,0,0,0,100,0), -- 17:13:02 +(@PATH,123,-5191.579,636.1736,42.90816,0,0,0,0,100,0), -- 17:13:02 +(@PATH,124,-5197.329,634.9236,44.40816,0,0,0,0,100,0), -- 17:13:02 +(@PATH,125,-5203.01,634.6678,45.16574,0,0,0,0,100,0), -- 17:13:05 +(@PATH,126,-5206.01,634.6678,45.41574,0,0,0,0,100,0), -- 17:13:05 +(@PATH,127,-5209.636,634.6382,46.55074,0,0,0,0,100,0), -- 17:13:10 +(@PATH,128,-5225.139,631.7184,48.56197,0,0,0,0,100,0), -- 17:13:15 +(@PATH,129,-5226.889,630.4684,48.56197,0,0,0,0,100,0), -- 17:13:15 +(@PATH,130,-5228.389,629.2184,48.81197,0,0,0,0,100,0), -- 17:13:15 +(@PATH,131,-5229.226,628.3779,48.93416,0,0,0,0,100,0), -- 17:13:20 +(@PATH,132,-5212.188,622.4875,47.14201,0,0,0,0,100,0), -- 17:13:25 +(@PATH,133,-5206.112,621.292,46.29193,0,0,0,0,100,0), -- 17:13:28 +(@PATH,134,-5186.827,619.9382,42.81411,0,0,0,0,100,0), -- 17:13:33 +(@PATH,135,-5193.917,620.2497,43.88791,0,0,0,0,100,0), -- 17:13:36 +(@PATH,136,-5193.917,620.2497,43.88791,6.204306,13000,0,0,100,0), -- 17:13:36 +(@PATH,137,-5186.842,619.9473,42.7837,0,0,0,0,100,0), -- 17:13:43 +(@PATH,138,-5183.527,619.1399,41.53972,0,0,0,0,100,0), -- 17:13:46 +(@PATH,139,-5180.777,618.3899,40.78972,0,0,0,0,100,0), -- 17:13:46 +(@PATH,140,-5177.527,617.8899,40.03972,0,0,0,0,100,0), -- 17:13:46 +(@PATH,141,-5163.918,617.7509,36.96921,0,0,0,0,100,0), -- 17:13:51 +(@PATH,142,-5158.669,620.3835,36.38764,0,0,0,0,100,0), -- 17:13:55 +(@PATH,143,-5157.419,621.1335,36.38764,0,0,0,0,100,0), -- 17:13:55 +(@PATH,144,-5155.669,622.3835,36.38764,0,0,0,0,100,0), -- 17:13:55 +(@PATH,145,-5151.717,625.7791,36.29499,0,0,0,0,100,0), -- 17:13:59 +(@PATH,146,-5146.967,630.5291,36.04499,0,0,0,0,100,0), -- 17:13:59 +(@PATH,147,-5146.07,631.4751,36.08121,0,0,0,0,100,0), -- 17:14:04 +(@PATH,148,-5140.069,643.69,36.68766,0,0,0,0,100,0), -- 17:14:07 +(@PATH,149,-5139.569,645.69,36.93766,0,0,0,0,100,0), -- 17:14:07 +(@PATH,150,-5139.775,650.586,37.32704,0,0,0,0,100,0), -- 17:14:11 +(@PATH,151,-5140.275,653.586,37.82704,0,0,0,0,100,0), -- 17:14:11 +(@PATH,152,-5140.525,657.836,38.07704,0,0,0,0,100,0), -- 17:14:11 +(@PATH,153,-5139.893,650.9125,36.97102,0,0,0,0,100,0), -- 17:14:13 +(@PATH,154,-5139.893,650.9125,36.97102,1.692638,13000,0,0,100,0), -- 17:14:13 +(@PATH,155,-5140.585,657.8174,38.23678,0,0,0,0,100,0), -- 17:14:21 +(@PATH,156,-5147.919,667.7463,41.09047,0,0,0,0,100,0), -- 17:14:24 +(@PATH,157,-5151.669,670.7463,41.34047,0,0,0,0,100,0), -- 17:14:24 +(@PATH,158,-5154.635,670.886,41.44817,0,0,0,0,100,0), -- 17:14:30 +(@PATH,159,-5157.795,664.1933,40.14152,0,0,0,0,100,0), -- 17:14:33 +(@PATH,160,-5157.795,660.6933,39.89152,0,0,0,0,100,0), -- 17:14:33 +(@PATH,161,-5161.06,651.3977,37.80369,0,0,0,0,100,0), -- 17:14:38 +(@PATH,162,-5164.019,648.2813,37.58054,0,0,0,0,100,0), -- 17:14:40 +(@PATH,163,-5165.019,647.5313,37.58054,0,0,0,0,100,0), -- 17:14:40 +(@PATH,164,-5167.769,645.2813,37.83054,0,0,0,0,100,0), -- 17:14:40 +(@PATH,165,-5171.026,643.8893,38.4648,0,0,0,0,100,0), -- 17:14:44 +(@PATH,166,-5172.276,643.3893,38.7148,0,0,0,0,100,0), -- 17:14:44 +(@PATH,167,-5173.776,642.8893,38.9648,0,0,0,0,100,0), -- 17:14:44 +(@PATH,168,-5185.981,637.8439,41.74332,0,0,0,0,100,0), -- 17:14:49 +(@PATH,169,-5189.904,636.5654,42.50515,0,0,0,0,100,0), -- 17:14:52 +(@PATH,170,-5191.154,636.3154,42.75515,0,0,0,0,100,0), -- 17:14:52 +(@PATH,171,-5197.154,634.8154,44.50515,0,0,0,0,100,0), -- 17:14:52 +(@PATH,172,-5186.579,637.4847,41.6531,0,0,0,0,100,0), -- 17:14:54 +(@PATH,173,-5186.579,637.4847,41.6531,3.542525,13000,0,0,100,0), -- 17:14:54 +(@PATH,174,-5197.299,634.7244,44.4835,0,0,0,0,100,0), -- 17:15:01 +(@PATH,175,-5203.041,634.7999,45.31844,0,0,0,0,100,0), -- 17:15:04 +(@PATH,176,-5206.041,634.7999,45.56844,0,0,0,0,100,0), -- 17:15:04 +(@PATH,177,-5209.731,634.6368,46.40524,0,0,0,0,100,0), -- 17:15:09 +(@PATH,178,-5225.014,631.6444,48.62695,0,0,0,0,100,0), -- 17:15:13 +(@PATH,179,-5226.764,630.3944,48.62695,0,0,0,0,100,0), -- 17:15:13 +(@PATH,180,-5228.514,629.1444,48.87695,0,0,0,0,100,0), -- 17:15:13 +(@PATH,181,-5229.223,628.2013,49.11297,0,0,0,0,100,0), -- 17:15:18 +(@PATH,182,-5212.107,622.3733,47.2334,0,0,0,0,100,0), -- 17:15:23 +(@PATH,183,-5210.747,621.8912,46.56211,0,0,0,0,100,0), -- 17:15:28 +(@PATH,184,-5210.747,621.8912,46.56211,6.052472,13000,0,0,100,0), -- 17:15:28 +(@PATH,185,-5208.978,621.4757,46.32497,0,0,0,0,100,0), -- 17:15:35 +(@PATH,186,-5206.209,621.2124,46.10388,0,0,0,0,100,0), -- 17:15:36 +(@PATH,187,-5186.642,619.9025,42.74264,0,0,0,0,100,0), -- 17:15:40 +(@PATH,188,-5183.583,619.2233,41.50294,0,0,0,0,100,0), -- 17:15:43 +(@PATH,189,-5180.833,618.4733,41.00294,0,0,0,0,100,0), -- 17:15:43 +(@PATH,190,-5177.333,617.9733,40.00294,0,0,0,0,100,0), -- 17:15:43 +(@PATH,191,-5164.016,617.6649,37.10645,0,0,0,0,100,0), -- 17:15:51 +(@PATH,192,-5157.269,621.1954,36.32607,0,0,0,0,100,0), -- 17:15:54 +(@PATH,193,-5155.769,622.1954,36.32607,0,0,0,0,100,0), -- 17:15:54 +(@PATH,194,-5151.916,625.7462,36.27628,0,0,0,0,100,0), -- 17:15:58 +(@PATH,195,-5146.916,630.4962,36.02628,0,0,0,0,100,0), -- 17:15:58 +(@PATH,196,-5146.043,631.5037,36.0778,0,0,0,0,100,0), -- 17:16:03 +(@PATH,197,-5143.677,634.6373,36.08821,0,0,0,0,100,0), -- 17:16:05 +(@PATH,198,-5143.677,634.6373,36.08821,0.8953364,13000,0,0,100,0); -- 17:16:05 +-- 0x1C09FC424016BE4000001900001FD78F .go -5141.078 637.8817 36.18917 + +DELETE FROM `creature_formations` WHERE `leaderGUID`=143600; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES +(143600, 143600, 0, 0, 1), +(143600, 52344, 2, 0, 2); + +-- Pathing for Mine Car Entry: 23289 'TDB FORMAT' +SET @NPC := 143600; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5158.637,`position_y`=727.454,`position_z`=45.57201 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5158.637,727.454,45.57201,0,0,0,0,100,0), -- 17:09:07 +(@PATH,2,-5155.599,718.3636,44.29898,0,0,0,0,100,0), -- 17:09:09 +(@PATH,3,-5154.974,714.7401,43.48943,0,0,0,0,100,0), -- 17:09:11 +(@PATH,4,-5155.224,712.9901,43.48943,0,0,0,0,100,0), -- 17:09:11 +(@PATH,5,-5155.724,705.7401,43.23943,0,0,0,0,100,0), -- 17:09:11 +(@PATH,6,-5155.974,700.4901,42.98943,0,0,0,0,100,0), -- 17:09:11 +(@PATH,7,-5155.34,696.4957,42.45358,0,0,0,0,100,0), -- 17:09:18 +(@PATH,8,-5154.84,693.2457,42.20358,0,0,0,0,100,0), -- 17:09:18 +(@PATH,9,-5157.657,679.5804,41.46281,0,0,0,0,100,0), -- 17:09:23 +(@PATH,10,-5156.473,678.8619,41.37924,0,0,0,0,100,0), -- 17:09:27 +(@PATH,11,-5153.473,678.8619,41.62924,0,0,0,0,100,0), -- 17:09:27 +(@PATH,12,-5149.723,678.6119,41.37924,0,0,0,0,100,0), -- 17:09:27 +(@PATH,13,-5146.723,678.6119,41.62924,0,0,0,0,100,0), -- 17:09:27 +(@PATH,14,-5142.223,678.3619,41.37924,0,0,0,0,100,0), -- 17:09:27 +(@PATH,15,-5139.723,678.3619,41.37924,0,0,0,0,100,0), -- 17:09:27 +(@PATH,16,-5129.718,680.8803,40.1742,0,0,0,0,100,0), -- 17:09:38 +(@PATH,17,-5123.968,688.6303,39.4242,0,0,0,0,100,0), -- 17:09:38 +(@PATH,18,-5122.718,690.3803,39.4242,0,0,0,0,100,0), -- 17:09:38 +(@PATH,19,-5123.011,691.2361,39.35996,0,0,0,0,100,0), -- 17:09:45 +(@PATH,20,-5124.511,690.9861,39.60996,0,0,0,0,100,0), -- 17:09:45 +(@PATH,21,-5127.261,690.4861,40.35996,0,0,0,0,100,0), -- 17:09:45 +(@PATH,22,-5129.767,692.5929,40.48572,2.039433,13000,0,0,100,0), -- 17:09:50 +(@PATH,23,-5132.671,699.1042,41.48306,0,0,0,0,100,0), -- 17:09:57 +(@PATH,24,-5134.28,703.5355,41.8651,0,0,0,0,100,0), -- 17:10:00 +(@PATH,25,-5134.28,705.0355,42.1151,0,0,0,0,100,0), -- 17:10:00 +(@PATH,26,-5135.78,711.5355,42.6151,0,0,0,0,100,0), -- 17:10:00 +(@PATH,27,-5136.954,718.392,44.09182,0,0,0,0,100,0), -- 17:10:04 +(@PATH,28,-5140.083,725.0063,45.31725,0,0,0,0,100,0), -- 17:10:08 +(@PATH,29,-5146.963,732.4551,46.1476,0,0,0,0,100,0), -- 17:10:12 +(@PATH,30,-5151.213,736.2051,46.3976,0,0,0,0,100,0), -- 17:10:12 +(@PATH,31,-5156.23,735.8439,46.26311,0,0,0,0,100,0), -- 17:10:17 +(@PATH,32,-5159.73,735.3439,46.26311,0,0,0,0,100,0), -- 17:10:17 +(@PATH,33,-5161.024,735.1243,46.05744,3.305536,13000,0,0,100,0), -- 17:10:21 +(@PATH,34,-5162.643,734.8564,46.45791,0,0,0,0,100,0), -- 17:10:29 +(@PATH,35,-5158.645,727.4257,45.9726,0,0,0,0,100,0), -- 17:10:30 +(@PATH,36,-5157.451,725.0515,45.61901,0,0,0,0,100,0), -- 17:10:32 +(@PATH,37,-5156.701,722.0515,44.86901,0,0,0,0,100,0), -- 17:10:32 +(@PATH,38,-5155.451,718.5515,44.36901,0,0,0,0,100,0), -- 17:10:32 +(@PATH,39,-5155.159,714.8245,43.45316,0,0,0,0,100,0), -- 17:10:36 +(@PATH,40,-5155.159,712.8245,43.45316,0,0,0,0,100,0), -- 17:10:36 +(@PATH,41,-5155.659,705.8245,43.20316,0,0,0,0,100,0), -- 17:10:36 +(@PATH,42,-5156.159,700.5745,43.20316,0,0,0,0,100,0), -- 17:10:36 +(@PATH,43,-5155.351,696.5886,42.4476,0,0,0,0,100,0), -- 17:10:43 +(@PATH,44,-5154.851,693.3386,42.1976,0,0,0,0,100,0), -- 17:10:43 +(@PATH,45,-5157.878,679.6798,41.45091,0,0,0,0,100,0), -- 17:10:48 +(@PATH,46,-5156.542,678.974,41.3766,0,0,0,0,100,0), -- 17:10:52 +(@PATH,47,-5153.542,678.724,41.6266,0,0,0,0,100,0), -- 17:10:52 +(@PATH,48,-5150.326,678.3993,41.2695,6.244667,13000,0,0,100,0), -- 17:10:57 +(@PATH,49,-5139.679,678.0468,41.18186,0,0,0,0,100,0), -- 17:11:04 +(@PATH,50,-5129.634,680.8771,40.41336,0,0,0,0,100,0), -- 17:11:10 +(@PATH,51,-5124.134,688.6271,39.66336,0,0,0,0,100,0), -- 17:11:10 +(@PATH,52,-5122.634,690.3771,39.41336,0,0,0,0,100,0), -- 17:11:10 +(@PATH,53,-5123.205,691.313,39.34991,0,0,0,0,100,0), -- 17:11:17 +(@PATH,54,-5124.455,691.063,39.59991,0,0,0,0,100,0), -- 17:11:17 +(@PATH,55,-5127.455,690.563,40.34991,0,0,0,0,100,0), -- 17:11:17 +(@PATH,56,-5132.663,698.9817,41.54927,0,0,0,0,100,0), -- 17:11:20 +(@PATH,57,-5134.165,703.3019,41.89793,0,0,0,0,100,0), -- 17:11:25 +(@PATH,58,-5134.415,705.0519,42.14793,0,0,0,0,100,0), -- 17:11:25 +(@PATH,59,-5135.665,711.5519,42.64793,0,0,0,0,100,0), -- 17:11:25 +(@PATH,60,-5137.015,718.4344,44.11918,0,0,0,0,100,0), -- 17:11:29 +(@PATH,61,-5140.138,725.0566,45.36108,0,0,0,0,100,0), -- 17:11:33 +(@PATH,62,-5146.898,732.4678,46.15642,0,0,0,0,100,0), -- 17:11:37 +(@PATH,63,-5151.148,736.2178,46.40642,0,0,0,0,100,0), -- 17:11:37 +(@PATH,64,-5156.207,735.7999,46.2761,0,0,0,0,100,0), -- 17:11:42 +(@PATH,65,-5159.707,735.2999,46.2761,0,0,0,0,100,0), -- 17:11:42 +(@PATH,66,-5161.614,733.5115,46.41948,0,0,0,0,100,0), -- 17:11:45 +(@PATH,67,-5159.614,729.7615,45.91948,0,0,0,0,100,0), -- 17:11:45 +(@PATH,68,-5158.364,727.2615,45.66948,0,0,0,0,100,0), -- 17:11:45 +(@PATH,69,-5157.527,724.9576,45.59089,0,0,0,0,100,0), -- 17:11:50 +(@PATH,70,-5156.777,721.9576,44.84089,0,0,0,0,100,0), -- 17:11:50 +(@PATH,71,-5155.527,718.4576,44.34089,0,0,0,0,100,0), -- 17:11:50 +(@PATH,72,-5155.046,714.7384,43.62848,0,0,0,0,100,0), -- 17:11:54 +(@PATH,73,-5155.11,713.8632,43.32977,4.644619,13000,0,0,100,0), -- 17:11:56 +(@PATH,74,-5155.853,700.3505,42.94897,0,0,0,0,100,0), -- 17:12:03 +(@PATH,75,-5155.375,696.4696,42.43354,0,0,0,0,100,0), -- 17:12:08 +(@PATH,76,-5154.875,693.2196,42.18354,0,0,0,0,100,0), -- 17:12:08 +(@PATH,77,-5157.808,679.5703,41.4225,0,0,0,0,100,0), -- 17:12:13 +(@PATH,78,-5156.457,678.8987,41.37038,0,0,0,0,100,0), -- 17:12:17 +(@PATH,79,-5153.457,678.8987,41.62038,0,0,0,0,100,0), -- 17:12:17 +(@PATH,80,-5149.707,678.6487,41.37038,0,0,0,0,100,0), -- 17:12:17 +(@PATH,81,-5146.707,678.3987,41.62038,0,0,0,0,100,0), -- 17:12:17 +(@PATH,82,-5142.207,678.3987,41.37038,0,0,0,0,100,0), -- 17:12:17 +(@PATH,83,-5139.707,678.1487,41.37038,0,0,0,0,100,0), -- 17:12:17 +(@PATH,84,-5129.718,680.8611,40.35927,0,0,0,0,100,0), -- 17:12:28 +(@PATH,85,-5123.968,688.6111,39.60927,0,0,0,0,100,0), -- 17:12:28 +(@PATH,86,-5122.117,691.4048,39.21569,0,0,0,0,100,0), -- 17:12:34 +(@PATH,87,-5124.367,691.1548,39.71569,0,0,0,0,100,0), -- 17:12:34 +(@PATH,88,-5127.367,690.6548,40.21569,0,0,0,0,100,0), -- 17:12:34 +(@PATH,89,-5132.795,699.1715,41.39445,0,0,0,0,100,0), -- 17:12:37 +(@PATH,90,-5133.877,703.4885,42.01696,0,0,0,0,100,0), -- 17:12:41 +(@PATH,91,-5134.377,704.7385,42.01696,0,0,0,0,100,0), -- 17:12:41 +(@PATH,92,-5135.627,711.4885,42.76696,0,0,0,0,100,0), -- 17:12:41 +(@PATH,93,-5136.911,716.5974,43.53514,1.753501,13000,0,0,100,0), -- 17:12:50 +(@PATH,94,-5137.376,718.6188,44.1994,0,0,0,0,100,0), -- 17:12:57 +(@PATH,95,-5139.936,725.0667,45.3965,0,0,0,0,100,0), -- 17:12:58 +(@PATH,96,-5145.418,730.9333,45.83433,0,0,0,0,100,0), -- 17:13:01 +(@PATH,97,-5146.918,732.4333,46.08433,0,0,0,0,100,0), -- 17:13:01 +(@PATH,98,-5151.168,736.1833,46.33433,0,0,0,0,100,0), -- 17:13:01 +(@PATH,99,-5156.112,735.9399,46.28493,0,0,0,0,100,0), -- 17:13:06 +(@PATH,100,-5159.612,735.1899,46.28493,0,0,0,0,100,0), -- 17:13:06 +(@PATH,101,-5161.833,733.4753,46.65749,0,0,0,0,100,0), -- 17:13:10 +(@PATH,102,-5159.583,729.7253,45.90749,0,0,0,0,100,0), -- 17:13:10 +(@PATH,103,-5158.583,727.2253,45.65749,0,0,0,0,100,0), -- 17:13:10 +(@PATH,104,-5161.203,732.0187,46.14994,5.182036,13000,0,0,100,0); -- 17:13:31 +-- 0x1C09FC424016BE4000001900009FD78F .go -5158.637 727.454 45.57201 + +-- Pathing for Nethermine Burster Entry: 23285 'TDB FORMAT' +SET @NPC := 52061; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5041.84,`position_y`=389.8085,`position_z`=-12.50461 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5041.84,389.8085,-12.50461,0,0,0,0,100,0), -- 18:10:14 +(@PATH,2,-5030.222,418.1729,-10.5541,0,0,0,0,100,0), -- 18:10:30 +(@PATH,3,-5025.323,437.285,-9.860763,0,0,0,0,100,0), -- 18:10:42 +(@PATH,4,-5018.703,470.1522,-7.756811,0,0,0,0,100,0), -- 18:10:53 +(@PATH,5,-5001.123,509.9958,-5.460767,0,0,0,0,100,0), -- 18:11:05 +(@PATH,6,-4988.681,532.6278,-6.128869,0,0,0,0,100,0), -- 18:11:20 +(@PATH,7,-5005.017,551.2161,-4.296617,0,0,0,0,100,0), -- 18:11:31 +(@PATH,8,-4989.901,535.1989,-5.819852,0,0,0,0,100,0), -- 18:11:45 +(@PATH,9,-4997.614,515.9099,-5.108593,0,0,0,0,100,0), -- 18:11:55 +(@PATH,10,-5015.447,481.5337,-7.364,0,0,0,0,100,0), -- 18:12:06 +(@PATH,11,-5022.034,451.5206,-8.870285,0,0,0,0,100,0), -- 18:12:21 +(@PATH,12,-5027.991,425.6957,-10.12456,0,0,0,0,100,0); -- 18:12:33 +-- 0x1C09FC424016BD4000001A000024139A .go -5041.84 389.8085 -12.50461 + +-- Pathing for Nethermine Burster Entry: 23285 'TDB FORMAT' +SET @NPC := 52086; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5145.625,`position_y`=491.5528,`position_z`=-13.89787 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5145.625,491.5528,-13.89787,0,0,0,0,100,0), -- 18:23:20 +(@PATH,2,-5132.041,468.5541,-13.29704,0,0,0,0,100,0), -- 18:23:25 +(@PATH,3,-5110.197,448.1371,-10.01901,0,0,0,0,100,0), -- 18:23:38 +(@PATH,4,-5126.933,460.5002,-11.57316,0,0,0,0,100,0), -- 18:23:49 +(@PATH,5,-5145.124,490.6877,-13.89787,0,0,0,0,100,0); -- 18:25:03 +-- 0x1C09FC424016BD4000001A00002414A1 .go -5145.625 491.5528 -13.89787 + +-- Pathing for Nethermine Burster Entry: 23285 'TDB FORMAT' +SET @NPC := 52084; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5012.641,`position_y`=527.0723,`position_z`=-4.429356 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5012.641,527.0723,-4.429356,0,0,0,0,100,0), -- 17:53:03 +(@PATH,2,-5013.526,533.334,-4.454225,0,0,0,0,100,0), -- 17:53:03 +(@PATH,3,-5016.438,541.4922,-4.275333,0,0,0,0,100,0), -- 17:53:03 +(@PATH,4,-5017.101,543.3494,-4.186446,0,0,0,0,100,0), -- 17:53:03 +(@PATH,5,-5019.346,549.6407,-3.932599,0,0,0,0,100,0), -- 17:53:03 +(@PATH,6,-5019.346,549.6407,-3.932599,0,0,0,0,100,0), -- 17:53:03 +(@PATH,7,-5013.449,533.623,-4.201852,0,0,0,0,100,0), -- 17:53:08 +(@PATH,8,-5013.044,507.5332,-5.770618,0,0,0,0,100,0), -- 17:53:15 +(@PATH,9,-5013.313,503.3087,-6.890712,0,0,0,0,100,0), -- 17:53:38 +(@PATH,10,-5013.553,499.3347,-7.32141,0,0,0,0,100,0), -- 17:55:36 +(@PATH,11,-5013.988,492.2674,-7.856032,0,0,0,0,100,0), -- 17:55:36 +(@PATH,12,-5014.288,487.3993,-7.717823,0,0,0,0,100,0), -- 17:55:36 +(@PATH,13,-5014.653,481.4716,-7.740697,0,0,0,0,100,0), -- 17:55:36 +(@PATH,14,-5014.934,476.9202,-7.658531,0,0,0,0,100,0); -- 17:55:36 +-- 0x1C09FC424016BD4000001A000024163A .go -5012.641 527.0723 -4.429356 + +-- Pathing for Nethermine Burster Entry: 23285 'TDB FORMAT' +SET @NPC := 52054; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5097.479,`position_y`=383.4904,`position_z`=-13.35386 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5097.479,383.4904,-13.35386,0,0,0,0,100,0), -- 18:09:28 +(@PATH,2,-5105.978,382.3359,-12.87995,0,0,0,0,100,0), -- 18:09:33 +(@PATH,3,-5140.72,361.3568,-18.36172,0,0,0,0,100,0), -- 18:09:39 +(@PATH,4,-5153.877,344.0262,-19.23454,0,0,0,0,100,0), -- 18:09:54 +(@PATH,5,-5146.007,355.4137,-18.91095,0,0,0,0,100,0), -- 18:12:22 +(@PATH,6,-5145.439,356.2371,-18.91095,0,0,0,0,100,0), -- 18:12:22 +(@PATH,7,-5144.646,357.3877,-18.79898,0,0,0,0,100,0), -- 18:12:22 +(@PATH,8,-5143.475,359.0869,-18.80667,0,0,0,0,100,0), -- 18:12:22 +(@PATH,9,-5141.084,360.9994,-18.86554,0,0,0,0,100,0), -- 18:12:22 +(@PATH,10,-5138.581,363.001,-18.69712,0,0,0,0,100,0), -- 18:12:22 +(@PATH,11,-5134.565,366.2131,-17.01051,0,0,0,0,100,0), -- 18:12:22 +(@PATH,12,-5131.742,368.4709,-16.21124,0,0,0,0,100,0), -- 18:12:22 +(@PATH,13,-5130.425,369.5245,-15.74924,0,0,0,0,100,0), -- 18:12:22 +(@PATH,14,-5127.633,371.7576,-15.0621,0,0,0,0,100,0), -- 18:12:22 +(@PATH,15,-5124.102,374.582,-14.24547,0,0,0,0,100,0), -- 18:12:22 +(@PATH,16,-5117.077,380.2002,-12.9527,0,0,0,0,100,0); -- 18:12:22 +-- 0x1C09FC424016BD4000001A0000241848 .go -5097.479 383.4904 -13.35386 + +-- Pathing for Nethermine Burster Entry: 23285 'TDB FORMAT' +SET @NPC := 52083; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5142.954,`position_y`=424.2722,`position_z`=-10.0708 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5142.954,424.2722,-10.0708,0,0,0,0,100,0), -- 18:09:46 +(@PATH,2,-5166.739,417.5524,-10.24546,0,0,0,0,100,0), -- 18:09:57 +(@PATH,3,-5174.002,422.4801,-10.30893,0,0,0,0,100,0), -- 18:10:04 +(@PATH,4,-5170.584,419.3948,-10.41781,0,0,0,0,100,0), -- 18:12:22 +(@PATH,5,-5169.813,418.7582,-10.41781,0,0,0,0,100,0), -- 18:12:22 +(@PATH,6,-5168.172,417.4039,-10.38332,0,0,0,0,100,0), -- 18:12:22 +(@PATH,7,-5167.688,417.0048,-10.36478,0,0,0,0,100,0), -- 18:12:22 +(@PATH,8,-5159.976,420.4402,-10.22841,0,0,0,0,100,0), -- 18:12:22 +(@PATH,9,-5157.938,421.3475,-10.24158,0,0,0,0,100,0), -- 18:12:22 +(@PATH,10,-5154.572,422.8471,-10.04827,0,0,0,0,100,0), -- 18:12:22 +(@PATH,11,-5151.838,424.0645,-10.09287,0,0,0,0,100,0), -- 18:12:22 +(@PATH,12,-5123.059,424.4661,-11.98086,3.589592,6000,0,0,100,0); -- 18:12:39 +-- 0x1C09FC424016BD4000001A0000241877 .go -5142.954 424.2722 -10.0708 + +-- Pathing for Nethermine Burster Entry: 23285 'TDB FORMAT' +SET @NPC := 52086; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5100.122,`position_y`=472.3237,`position_z`=-8.886364 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5100.122,472.3237,-8.886364,0,0,0,0,100,0), -- 18:10:53 +(@PATH,2,-5117.763,467.3499,-11.16238,0,0,0,0,100,0), -- 18:11:04 +(@PATH,3,-5131.067,444.1735,-10.89796,0,0,0,0,100,0), -- 18:11:35 +(@PATH,4,-5132.473,440.0923,-10.73675,0,0,0,0,100,0), -- 18:11:35 +(@PATH,5,-5130.348,437.1649,-10.71613,0,0,0,0,100,0), -- 18:11:35 +(@PATH,6,-5127.024,432.5856,-11.19165,0,0,0,0,100,0), -- 18:11:35 +(@PATH,7,-5118.549,420.9109,-12.51914,0,0,0,0,100,0), -- 18:11:35 +(@PATH,8,-5088.664,403.9553,-12.69664,0,0,0,0,100,0), -- 18:11:36 +(@PATH,9,-5070.439,406.9981,-11.93173,0,0,0,0,100,0), -- 18:11:49 +(@PATH,10,-5062.364,426.8455,-11.17576,0,0,0,0,100,0), -- 18:11:58 +(@PATH,11,-5063.076,458.8389,-11.47571,0,0,0,0,100,0), -- 18:12:09 +(@PATH,12,-5067.343,465.1718,-10.02644,0,0,0,0,100,0), -- 18:12:18 +(@PATH,13,-5100.08,472.3515,-8.843109,0,0,0,0,100,0); -- 18:12:26 +-- 0x1C09FC424016BD4000001A00002418CF .go -5100.122 472.3237 -8.886364 + +-- Pathing for Nethermine Burster Entry: 23285 'TDB FORMAT' +SET @NPC := 52085; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5082.33,`position_y`=474.2946,`position_z`=-7.784039 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5082.33,474.2946,-7.784039,0,0,0,0,100,0), -- 18:09:27 +(@PATH,2,-5091.409,496.4387,-10.14975,0,0,0,0,100,0), -- 18:09:40 +(@PATH,3,-5094.309,513.0909,-11.32626,0,0,0,0,100,0), -- 18:09:50 +(@PATH,4,-5105.632,522.7634,-10.2628,0,0,0,0,100,0), -- 18:09:56 +(@PATH,5,-5107.463,534.7469,-10.20918,0,0,0,0,100,0), -- 18:10:04 +(@PATH,6,-5108.773,528.9429,-10.17007,0,0,0,0,100,0), -- 18:10:10 +(@PATH,7,-5103.452,521.2954,-10.52877,0,0,0,0,100,0), -- 18:10:12 +(@PATH,8,-5093.061,503.7095,-11.10897,0,0,0,0,100,0); -- 18:10:21 +-- 0x1C09FC424016BD4000001A0000241940 .go -5082.33 474.2946 -7.784039 + +-- Pathing for Nethermine Burster Entry: 23285 'TDB FORMAT' +SET @NPC := 52061; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5015.721,`position_y`=393.4803,`position_z`=-13.56352 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5015.721,393.4803,-13.56352,0,0,0,0,100,0), -- 17:55:20 +(@PATH,2,-5014.953,396.891,-13.21174,0,0,0,0,100,0), -- 17:55:20 +(@PATH,3,-5013.08,405.213,-12.17083,0,0,0,0,100,0), -- 17:55:20 +(@PATH,4,-5012.828,406.3322,-11.95596,0,0,0,0,100,0), -- 17:55:20 +(@PATH,5,-5010.532,416.5321,-10.48194,0,0,0,0,100,0), -- 17:55:20 +(@PATH,6,-5008.649,424.8955,-9.222077,0,0,0,0,100,0), -- 17:55:20 +(@PATH,7,-5002.781,442.213,-7.196595,0,0,0,0,100,0), -- 17:55:28 +(@PATH,8,-5001.61,460.2058,-6.495255,0,0,0,0,100,0), -- 17:55:37 +(@PATH,9,-5001.797,445.3661,-6.927022,0,0,0,0,100,0), -- 17:55:47 +(@PATH,10,-5008.122,426.1274,-8.655727,0,0,0,0,100,0), -- 17:55:55 +(@PATH,11,-5014.418,397.9655,-12.76799,0,0,0,0,100,0); -- 17:56:03 +-- 0x1C09FC424016BD4000001A00002419A9 .go -5015.721 393.4803 -13.56352 + +-- Pathing for Nethermine Burster Entry: 23285 'TDB FORMAT' +SET @NPC := 52046; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5153.807,`position_y`=343.9828,`position_z`=-19.23604 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5153.807,343.9828,-19.23604,0,0,0,0,100,0), -- 18:17:49 +(@PATH,2,-5144.604,357.4449,-18.70733,0,0,0,0,100,0), -- 18:17:59 +(@PATH,3,-5116.975,380.3215,-12.69622,0,0,0,0,100,0), -- 18:18:06 +(@PATH,4,-5102.355,382.6835,-13.05555,0,0,0,0,100,0), -- 18:18:21 +(@PATH,5,-5105.978,382.3359,-12.87995,0,0,0,0,100,0), -- 18:18:30 +(@PATH,6,-5140.741,361.2797,-18.35986,0,0,0,0,100,0); -- 18:18:37 +-- 0x1C09FC424016BD4000001A0000241F37 .go -5153.807 343.9828 -19.23604 + +-- Pathing for Nethermine Ravager Entry: 23326 'TDB FORMAT' +SET @NPC := 143827; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4963.239,`position_y`=605.275,`position_z`=15.15399 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-4963.239,605.275,15.15399,0,0,1,0,100,0), -- 17:52:17 +(@PATH,2,-4975.903,623.7806,17.61637,0,0,1,0,100,0), -- 17:52:20 +(@PATH,3,-4992.053,634.3859,22.33038,0,0,1,0,100,0), -- 17:52:23 +(@PATH,4,-5011.415,637.7054,23.62663,0,0,1,0,100,0), -- 17:52:26 +(@PATH,5,-4998.898,635.9115,22.77191,0,0,1,0,100,0), -- 17:52:31 +(@PATH,6,-4979.864,627.016,19.21811,0,0,1,0,100,0), -- 17:52:34 +(@PATH,7,-4965.36,609.7169,16.62768,0,0,1,0,100,0), -- 17:52:37 +(@PATH,8,-4958.603,589.0837,12.97569,0,0,1,0,100,0), -- 17:52:40 +(@PATH,9,-4936.146,573.9352,7.7713,0,0,1,0,100,0), -- 17:52:44 +(@PATH,10,-4913.703,588.2379,5.505109,0,0,1,0,100,0), -- 17:52:48 +(@PATH,11,-4930.457,576.1113,6.944055,0,0,1,0,100,0), -- 17:52:53 +(@PATH,12,-4955.026,583.3227,12.02873,0,0,1,0,100,0); -- 17:52:55 +-- 0x1C09FC424016C78000001A0000241948 .go -4963.239 605.275 15.15399 + +-- Pathing for Nethermine Ravager Entry: 23326 'TDB FORMAT' +SET @NPC := 143837; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4926.302,`position_y`=510.8232,`position_z`=5.912571 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-4926.302,510.8232,5.912571,0,0,1,0,100,0), -- 17:52:59 +(@PATH,2,-4928.601,533.3176,6.820917,0,0,1,0,100,0), -- 17:53:03 +(@PATH,3,-4939.765,552.8948,6.603627,0,0,1,0,100,0), -- 17:53:05 +(@PATH,4,-4955.232,575.6724,11.41519,0,0,1,0,100,0), -- 17:53:09 +(@PATH,5,-4946.245,562.309,8.260891,0,0,1,0,100,0), -- 17:53:14 +(@PATH,6,-4933.914,544.2485,6.190574,0,0,1,0,100,0), -- 17:53:16 +(@PATH,7,-4927.376,523.0281,7.014862,0,0,1,0,100,0), -- 17:53:20 +(@PATH,8,-4926.589,498.706,3.313521,0,0,1,0,100,0), -- 17:53:23 +(@PATH,9,-4907.33,473.4201,1.108172,0,0,1,0,100,0), -- 17:53:27 +(@PATH,10,-4885.657,466.1158,-2.15189,0,0,1,0,100,0), -- 17:53:31 +(@PATH,11,-4898.996,472.0482,0.2873805,0,0,1,0,100,0), -- 17:53:36 +(@PATH,12,-4925.863,491.4807,1.155461,0,0,1,0,100,0); -- 17:53:39 +-- 0x1C09FC424016C78000001A0000241973 .go -4926.302 510.8232 5.912571 + +-- Pathing for Nethermine Ravager Entry: 23326 'TDB FORMAT' +SET @NPC := 143848; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5009.851,`position_y`=293.1676,`position_z`=1.581649 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5009.851,293.1676,1.581649,0,0,1,0,100,0), -- 17:55:04 +(@PATH,2,-4985.909,303.3185,-1.474064,0,0,1,0,100,0), -- 17:55:10 +(@PATH,3,-4977.48,319.7932,-1.799831,0,0,1,0,100,0), -- 17:55:14 +(@PATH,4,-4965.886,351.0247,-1.16063,0,0,1,0,100,0), -- 17:55:16 +(@PATH,5,-4961.489,388.3174,-1.142369,0,0,1,0,100,0), -- 17:55:21 +(@PATH,6,-4955.736,422.718,3.013297,0,0,1,0,100,0), -- 17:55:25 +(@PATH,7,-4943.146,446.6736,1.949694,0,0,1,0,100,0), -- 17:55:32 +(@PATH,8,-4918.688,445.8087,1.470013,0,0,1,0,100,0), -- 17:55:36 +(@PATH,9,-4907.826,422.7741,-4.288939,0,0,1,0,100,0), -- 17:55:39 +(@PATH,10,-4914.044,443.4701,0.7917011,0,0,1,0,100,0), -- 17:55:45 +(@PATH,11,-4940.444,449.0392,1.663293,0,0,1,0,100,0), -- 17:55:48 +(@PATH,12,-4953.445,428.6053,3.195693,0,0,1,0,100,0), -- 17:55:51 +(@PATH,13,-4959.889,397.1684,-0.2070236,0,0,1,0,100,0), -- 17:55:55 +(@PATH,14,-4965.057,353.1042,-1.062231,0,0,1,0,100,0), -- 17:56:01 +(@PATH,15,-4974.901,325.7972,-1.889486,0,0,1,0,100,0), -- 17:56:06 +(@PATH,16,-4983.667,306.4418,-1.94701,0,0,1,0,100,0); -- 17:56:10 +-- 0x1C09FC424016C78000001A00002419DB .go -5009.851 293.1676 1.581649 + +-- Pathing for Nethermine Ravager Entry: 23326 'TDB FORMAT' +SET @NPC := 143840; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4869.946,`position_y`=530.6263,`position_z`=-1.553467 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-4869.946,530.6263,-1.553467,0,0,1,0,100,0), -- 18:06:45 +(@PATH,2,-4893.954,534.9226,2.516688,0,0,1,0,100,0), -- 18:06:50 +(@PATH,3,-4909.314,518.1718,4.493078,0,0,1,0,100,0), -- 18:06:54 +(@PATH,4,-4901.04,531.7859,4.01936,0,0,1,0,100,0), -- 18:06:55 +(@PATH,5,-4909.218,518.321,4.623864,0,0,1,0,100,0), -- 18:07:02 +(@PATH,6,-4915.15,493.46,1.49952,0,0,1,0,100,0), -- 18:07:03 +(@PATH,7,-4928.039,454.6728,1.627107,0,0,1,0,100,0), -- 18:07:07 +(@PATH,8,-4947.842,455.957,0.743868,0,0,1,0,100,0), -- 18:07:13 +(@PATH,9,-4970.903,473.2809,3.325165,0,0,1,0,100,0), -- 18:07:16 +(@PATH,10,-4956.071,459.8573,0.461098,0,0,1,0,100,0), -- 18:07:22 +(@PATH,11,-4930.157,454.3083,1.40765,0,0,1,0,100,0), -- 18:07:25 +(@PATH,12,-4917.665,485.7419,0.5451692,0,0,1,0,100,0), -- 18:07:29 +(@PATH,13,-4910.57,514.0978,4.176438,0,0,1,0,100,0), -- 18:07:34 +(@PATH,14,-4898.185,533.2109,3.269632,0,0,1,0,100,0); -- 18:07:39 +-- 0x1C09FC424016C78000001A0000241B47 .go -4869.946 530.6263 -1.553467 + +-- Pathing for Nethermine Ravager Entry: 23326 'TDB FORMAT' +SET @NPC := 143843; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-4922.489,`position_y`=300.9247,`position_z`=-12.97113 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-4922.489,300.9247,-12.97113,0,0,1,0,100,0), -- 18:05:49 +(@PATH,2,-4940.971,300.3912,-8.783532,0,0,1,0,100,0), -- 18:05:52 +(@PATH,3,-4955.332,289.6572,-5.669093,0,0,1,0,100,0), -- 18:05:55 +(@PATH,4,-4966.683,308.9685,-3.354346,0,0,1,0,100,0), -- 18:05:57 +(@PATH,5,-4964.716,331.7885,-2.618268,0,0,1,0,100,0), -- 18:06:01 +(@PATH,6,-4955.161,358.4415,-2.649262,0,0,1,0,100,0), -- 18:06:04 +(@PATH,7,-4951.747,387.423,-2.672494,0,0,1,0,100,0), -- 18:06:08 +(@PATH,8,-4960.425,414.4815,2.96782,0,0,1,0,100,0), -- 18:06:13 +(@PATH,9,-4964.489,436.2759,3.192766,0,0,1,0,100,0), -- 18:06:16 +(@PATH,10,-4961.489,417.7344,3.296109,0,0,1,0,100,0), -- 18:06:22 +(@PATH,11,-4952.684,397.0981,-0.8431122,0,0,1,0,100,0), -- 18:06:25 +(@PATH,12,-4953.893,364.0373,-2.409762,0,0,1,0,100,0), -- 18:06:28 +(@PATH,13,-4962.485,340.8231,-2.176575,0,0,1,0,100,0), -- 18:06:33 +(@PATH,14,-4966.377,318.3596,-2.773224,0,0,1,0,100,0), -- 18:06:37 +(@PATH,15,-4960.039,292.8176,-4.731999,0,0,1,0,100,0), -- 18:13:52 +(@PATH,16,-4942.955,299.4413,-8.193456,0,0,1,0,100,0); -- 18:13:54 +-- 0x1C09FC424016C78000001A0000241B51 .go -4922.489 300.9247 -12.97113 + +-- Pathing for Nethermine Ravager Entry: 23326 'TDB FORMAT' +SET @NPC := 143850; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5061.087,`position_y`=118.9844,`position_z`=-16.32363 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5061.087,118.9844,-16.32363,0,0,1,0,100,0), -- 18:05:17 +(@PATH,2,-5067.978,134.1589,-14.4941,0,0,1,0,100,0), -- 18:05:24 +(@PATH,3,-5078.728,174.4905,-8.200466,0,0,1,0,100,0), -- 18:05:27 +(@PATH,4,-5070.809,196.4065,-8.396107,0,0,1,0,100,0), -- 18:05:32 +(@PATH,5,-5051.048,203.3381,-10.27266,0,0,1,0,100,0), -- 18:05:36 +(@PATH,6,-5030.57,208.88,-11.94103,0,0,1,0,100,0), -- 18:05:39 +(@PATH,7,-4996.729,232.7692,-7.642292,0,0,1,0,100,0), -- 18:05:43 +(@PATH,8,-4983.488,232.4408,-8.859201,0,0,1,0,100,0), -- 18:05:48 +(@PATH,9,-4990.174,233.7981,-7.773879,0,0,1,0,100,0), -- 18:05:52 +(@PATH,10,-5009.648,220.7942,-10.2113,0,0,1,0,100,0), -- 18:05:55 +(@PATH,11,-5009.046,223.3424,-9.788197,0,0,1,0,100,0), -- 18:05:58 +(@PATH,12,-5018.983,212.046,-11.68377,0,0,1,0,100,0), -- 18:06:06 +(@PATH,13,-5031.654,208.8046,-11.78926,0,0,1,0,100,0), -- 18:06:07 +(@PATH,14,-5076.621,183.3736,-8.145866,0,0,1,0,100,0), -- 18:13:57 +(@PATH,15,-5072.223,144.1562,-12.73046,0,0,1,0,100,0), -- 18:13:58 +(@PATH,16,-5061.066,119.1013,-16.51242,0,0,1,0,100,0); -- 18:14:04 +-- 0x1C09FC424016C78000001A0000241C27 .go -5061.087 118.9844 -16.32363 + +-- Pathing for Nethermine Ravager Entry: 23326 'TDB FORMAT' +SET @NPC := 143859; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5052.252,`position_y`=176.8827,`position_z`=-11.95231 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`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-5052.252,176.8827,-11.95231,0,0,1,0,100,0), -- 18:05:07 +(@PATH,2,-5021.2,157.3062,-14.11822,0,0,1,0,100,0), -- 18:05:11 +(@PATH,3,-5001.049,161.8789,-14.45323,0,0,1,0,100,0), -- 18:05:15 +(@PATH,4,-5016.269,157.2713,-14.45587,0,0,1,0,100,0), -- 18:05:21 +(@PATH,5,-5046.272,166.7962,-12.9523,0,0,1,0,100,0), -- 18:05:23 +(@PATH,6,-5051.284,187.3221,-11.84302,0,0,1,0,100,0), -- 18:05:29 +(@PATH,7,-5035.34,209.7333,-11.41766,0,0,1,0,100,0), -- 18:05:32 +(@PATH,8,-5024.802,236.1987,-6.399595,0,0,1,0,100,0), -- 18:05:35 +(@PATH,9,-5015.809,258.2852,-1.012123,0,0,1,0,100,0), -- 18:05:40 +(@PATH,10,-5023.006,240.032,-4.77902,0,0,1,0,100,0), -- 18:05:45 +(@PATH,11,-5030.113,221.3788,-9.224751,0,0,1,0,100,0), -- 18:05:47 +(@PATH,12,-5049.056,197.9744,-11.1133,0,0,1,0,100,0); -- 18:05:52 +-- 0x1C09FC424016C78000001A0000241C47 .go -5052.252 176.8827 -11.95231 |