diff options
| author | Killyana <morphone1@gmail.com> | 2019-04-19 02:04:40 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-11-30 23:28:41 +0100 |
| commit | bade67e74b49be98ab8847201864ef7c4e548026 (patch) | |
| tree | 06831909f3af3a1004f211bc3920a8acf91258ab | |
| parent | dad95d16b263b9c1cb8df6edac8043138fb4da9e (diff) | |
DB: Respawn The Underbog
(cherry picked from commit 5262d760ffc73cee61bb6cdd151df1364e9b41f3)
| -rw-r--r-- | sql/updates/world/master/2021_11_30_15_world_2019_04_19_00_world.sql | 1211 |
1 files changed, 1211 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_30_15_world_2019_04_19_00_world.sql b/sql/updates/world/master/2021_11_30_15_world_2019_04_19_00_world.sql new file mode 100644 index 00000000000..de8e7686951 --- /dev/null +++ b/sql/updates/world/master/2021_11_30_15_world_2019_04_19_00_world.sql @@ -0,0 +1,1211 @@ +DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `map` IN (546)); +DELETE FROM `waypoint_data` WHERE `id` IN (542100,542460,542470,543890,543940,544200,544210,561120,561420,561430,565510,568680); +DELETE FROM `creature` WHERE `map` IN (546); +DELETE FROM `linked_respawn` WHERE `guid` IN (54187, 54189, 54191, 54203, 54210, 54211, 54212, 54213, 54214, 54215, 54216, 54217, 54218, 54246, 54247, 54389, 54394, 54396, 54397, 54399, 54401, 54403, 54405, 54406, 54407, 54408, 54409, 54410, 54411, 54412, 54420, 54421, 54424, 54427, 54615, 54622, 54637, 54700, 54701, 54703, 54799, 55068, 55102, 55106, 55391, 55536, 55552, 55553, 55903, 56109, 56112, 56142, 56143, 56144, 56145, 56164, 56168, 56316, 56328, 56868, 57013, 57015); +DELETE FROM `creature` WHERE `guid` IN (54187, 54189, 54191, 54203, 54210, 54211, 54212, 54213, 54214, 54215, 54216, 54217, 54218, 54246, 54247, 54248, 54249, 54250, 54337, 54339, 54381, 54383, 54385, 54387, 54389, 54392, 54394, 54396, 54397, 54399, 54401, 54403, 54405, 54406, 54407, 54408, 54409, 54410, 54411, 54412, 54420, 54421, 54424, 54427, 54615, 54622, 54637, 54700, 54701, 54703, 54799, 55068, 55102, 55106, 55391, 55536, 55552, 55553, 55903, 56109, 56111, 56112, 56142, 56143, 56144, 56145, 56164, 56168, 56316, 56328, 56551, 56862, 56868, 57012, 57013, 57015, 86372, 100861, 100862, 100863, 100879, 100880, 100881, 100882, 101018, 101048, 101049, 101050, 101052, 101331, 101332, 101333, 101334, 101335, 101336, 101337, 101338, 101339, 101340, 101341, 101342, 101343, 101526, 101589, 101599, 101626, 101638, 101639, 101686, 101722, 101724, 101725, 101727, 101733, 101734, 101735, 101736, 101737, 101738, 101741, 101748, 101749, 101750, 101752, 101756, 101757, 101758, 101759, 101760, 101763, 101770, 101771, 101772, 101777, 101779, 101780, 102317, 102342, 102343, 102344, 102401, 102402, 102403, 102404, 102405, 102406, 102407, 102408, 102409, 102410, 102411, 102412, 102414, 102415, 102470, 102595, 102626, 102645, 102648, 102649, 102650, 102651, 102652, 102661, 102662, 102663, 102664, 102665, 102666, 102777, 102881, 102985, 102986, 103220, 103233, 103236, 103239, 103245, 103246, 103291, 103292, 103293, 103294, 103299, 103300, 103321, 103322, 103323, 103363, 103393, 103395, 103404, 103412, 103414, 103423, 103424, 103431, 103432, 103444, 103462, 103466, 103467, 103468, 103470, 103471, 103473, 103474, 103475, 103476, 103479, 103543, 103580, 103581, 103589, 103590, 103605, 103616, 103617, 103638,103639,103640); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +( 54187, 17725, 546, 3716, 0, '1,2', 0, 0, 0, 53.30517, -115.721, -2.657704, 1.06197, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) (Auras: 34161 - 34161) (possible waypoints or random movement) +( 54189, 17725, 546, 3716, 0, '1,2', 0, 0, 0, -7.220898, -102.7497, -4.450541, 4.782202, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) +( 54191, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 50.72073, -44.14409, -2.728981, 5.592258, 7200, 2, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +( 54203, 17725, 546, 3716, 0, '1,2', 0, 0, 0, -18.02261, -205.5488, -4.45156, 1.762783, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54210, 17871, 546, 3716, 0, '1,2', 0, 0, 0, -4.952149, -115.8789, -4.450285, 1.37881, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17871 (Area: 0 - Difficulty: 0) +( 54211, 17871, 546, 3716, 0, '1,2', 0, 0, 0, 59.85622, -97.73518, -2.668301, 3.122032, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17871 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54212, 1420, 546, 3716, 0, '1,2', 0, 0, 0, -2.362334, -103.548, -4.450447, 4.206244, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 1420 (Area: 0 - Difficulty: 0) +( 54213, 1420, 546, 3716, 0, '1,2', 0, 0, 0, 36.05366, -28.07838, -2.666564, 4.13643, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 1420 (Area: 0 - Difficulty: 0) +( 54214, 18409, 546, 3716, 0, '1,2', 0, 0, 0, -79.51646, -129.9326, 6.231276, 6.161012, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 18409 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54215, 18409, 546, 3716, 0, '1,2', 0, 0, 0, 131.5264, -183.1788, 32.36647, 5.044002, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 18409 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54216, 17725, 546, 3716, 0, '1,2', 0, 0, 0, 44.16768, -106.8701, -3.188545, 5.84033, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) (Auras: 34161 - 34161) (possible waypoints or random movement) +( 54217, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 69.06821, -81.12038, -2.714396, 4.127217, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +( 54218, 17725, 546, 3716, 0, '1,2', 0, 0, 0, 58.36132, -155.6037, -2.655583, 5.394274, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) (Auras: 34161 - 34161) (possible waypoints or random movement) +( 54246, 17871, 546, 3716, 0, '1,2', 0, 0, 0, 6.079409, -176.5668, -4.450377, 4.312232, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17871 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54247, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 3.169437, -188.7437, -4.45057, 5.358161, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 18409 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54248, 17725, 546, 3716, 0, '1,2', 0, 0, 0, 4.394465, -104.6041, -4.450368, 0.4537856, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) +( 54249, 17871, 546, 3716, 0, '1,2', 0, 0, 0, -4.819636, -183.5013, -4.450739, 0.4242623, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17871 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54250, 17992, 546, 3716, 0, '1,2', 0, 0, 0, 85.16418, -19.98816, 44.31943, 5.654867, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17992 (Area: 0 - Difficulty: 0) +( 54337, 17882, 546, 3716, 0, '1,2', 0, 0, 0, 143.4318, 9.125844, 27.64584, 4.223697, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17882 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +( 54339, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 130.1618, 1.715451, 27.40961, 0.3839724, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +( 54381, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 123.7957, 14.59499, 27.22918, 2.583087, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +( 54383, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 38.80242, -236.2365, -4.449885, 4.101524, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 18409 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54385, 17725, 546, 3716, 0, '1,2', 0, 0, 0, -16.00559, -238.1238, -4.451491, 0.4712389, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54387, 17871, 546, 3716, 0, '1,2', 0, 0, 0, 63.91523, -237.5912, -4.387962, 4.834562, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17871 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54389, 17725, 546, 3716, 0, '1,2', 0, 0, 0, 60.53387, -252.4813, -4.449885, 3.193953, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54392, 18409, 546, 3716, 0, '1,2', 0, 0, 0, 58.87116, -257.5614, -4.449887, 4.782202, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 18409 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54394, 18409, 546, 3716, 0, '1,2', 0, 0, 0, 97.35211, -228.6476, 60.44425, 1.092118, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 18409 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54396, 17734, 546, 3716, 0, '1,2', 0, 0, 0, 161.1251, -70.36053, 27.06263, 3.67151, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17734 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +( 54397, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -17.99925, -117.8123, -4.533901, 1.869505, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54399, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 50.04602, -163.945, -2.884503, 2.502735, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +( 54401, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 58.0593, -164.8913, -2.936661, 2.651667, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +( 54403, 17725, 546, 3716, 0, '1,2', 0, 0, 0, -51.87671, -246.5942, -4.453375, 0.4712389, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) +( 54405, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -3.541236, -173.8364, -4.534256, 2.008565, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54406, 17725, 546, 3716, 0, '1,2', 0, 0, 0, -55.94983, -257.5185, -4.453442, 5.916666, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) +( 54407, 17871, 546, 3716, 0, '1,2', 0, 0, 0, -61.20591, -239.9195, -4.453648, 0.9773844, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17871 (Area: 0 - Difficulty: 0) +( 54408, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 10.30395, -186.1457, -4.533591, 0.8720987, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54409, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 7.886029, -189.896, -4.533734, 1.165784, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54410, 18409, 546, 3716, 0, '1,2', 0, 0, 0, 99.96253, -268.8299, 56.41412, 2.070496, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 18409 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54411, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -8.65226, -205.3566, -4.534616, 5.045, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54412, 17723, 546, 3716, 0, '1,2', 0, 0, 0, 10.63608, -206.855, -4.449889, 1.204277, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17723 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +( 54420, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 40.12823, -230.5958, -4.473591, 5.444836, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54421, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -16.80874, -194.3225, -4.534508, 2.589608, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54424, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 27.69204, -196.1834, -4.303112, 1.5685, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54427, 3300, 546, 3716, 0, '1,2', 0, 0, 0, 65.68274, -242.8761, -4.399827, 3.682645, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 3300 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54615, 17724, 546, 3716, 0, '1,2', 0, 0, 0, 69.98894, -247.8628, -4.453533, 3.711753, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54622, 1420, 546, 3716, 0, '1,2', 0, 0, 0, -11.94217, -216.013, -4.451433, 2.303835, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 1420 (Area: 0 - Difficulty: 0) +( 54637, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -38.29655, -225.3147, -4.53623, 2.891853, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54700, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -20.98602, -245.6544, -4.535102, 5.033271, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54701, 18409, 546, 3716, 0, '1,2', 0, 0, 0, -74.26942, -332.6557, 8.657014, 2.631587, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 18409 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54703, 17871, 546, 3716, 0, '1,2', 0, 0, 0, -145.0263, -251.3121, -4.149929, 1.372653, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17871 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 54799, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 29.57334, -270.1697, -21.57846, 6.195919, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +( 55068, 17725, 546, 3716, 0, '1,2', 0, 0, 0, -143.6363, -244.7762, -4.05871, 1.392769, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17725 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 55102, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 2.402601, -285.5155, -21.66179, 1.364895, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +( 55106, 17723, 546, 3716, 0, '1,2', 0, 0, 0, -59.19425, -289.6774, -4.534918, 4.024751, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17723 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 55391, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -68.25427, -270.9585, -3.527724, 0.6218942, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 55536, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 7.209689, -299.3465, -21.66179, 1.918371, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +( 55552, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 34.93061, -284.7387, -21.66179, 1.855358, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +( 55553, 17723, 546, 3716, 0, '1,2', 0, 0, 0, -96.71855, -227.7162, -4.376232, 3.099106, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17723 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 55903, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -90.97534, -285.3087, 0.806814, 3.465749, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 56109, 3300, 546, 3716, 0, '1,2', 0, 0, 0, -132.7502, -222.0896, -3.846002, 1.518436, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 3300 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 56111, 17770, 546, 3716, 0, '1,2', 0, 0, 0, -121.3438, -388.6259, 36.86593, 1.396263, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17770 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +( 56112, 20465, 546, 3716, 0, '1,2', 0, 0, 0, -44.28526, -306.5944, -21.27985, 4.18879, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +( 56142, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -90.97534, -285.3087, 0.806814, 3.465749, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 56143, 20465, 546, 3716, 0, '1,2', 0, 0, 0, -17.97761, -317.2511, -21.12615, 5.72468, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +( 56144, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -143.2497, -229.5731, -3.914454, 1.455715, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 56145, 20465, 546, 3716, 0, '1,2', 0, 0, 0, -32.06527, -316.2247, -21.36319, 0.8287687, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +( 56164, 20465, 546, 3716, 0, '1,2', 0, 0, 0, -63.37798, -325.4705, -21.36319, 0.03244695, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +( 56168, 17723, 546, 3716, 0, '1,2', 0, 0, 0, -21.11057, -342.8836, 30.82128, 3.865455, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17723 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 56316, 20465, 546, 3716, 0, '1,2', 0, 0, 0, -52.37688, -346.8098, -21.3405, 2.248388, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +( 56328, 17723, 546, 3716, 0, '1,2', 0, 0, 0, 42.47691, -293.7711, 32.69077, 0.5731232, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17723 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 56551, 1420, 546, 3716, 0, '1,2', 0, 0, 0, -3.225208, -331.1055, 31.36477, 0.5235988, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 1420 (Area: 0 - Difficulty: 0) +( 56862, 17723, 546, 3716, 0, '1,2', 0, 0, 0, -97.88883, -348.7764, 32.95102, 1.658063, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17723 (Area: 0 - Difficulty: 0) (Auras: 8599 - 8599) +( 56868, 17723, 546, 3716, 0, '1,2', 0, 0, 0, -129.9212, -342.1138, 33.34631, 0.9948376, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17723 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +( 57012, 1420, 546, 3716, 0, '1,2', 0, 0, 0, -117.1206, -359.3285, 34.65013, 1.518436, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 1420 (Area: 0 - Difficulty: 0) +( 57013, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -21.26414, -359.0132, 29.98346, 0.5539733, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 57015, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -21.26414, -359.0132, 29.98346, 0.5539733, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +( 86372, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -12.38057, -316.9037, 30.45172, 3.058418, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100861, 17724, 546, 3716, 0, '1,2', 0, 0, 0, -35.23372, -328.6559, 31.12738, 4.257082, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17724 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100862, 20465, 546, 3716, 0, '1,2', 0, 0, 0, -57.85358, -396.0295, -20.11692, 2.96706, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(100863, 20465, 546, 3716, 0, '1,2', 0, 0, 0, -76.62703, -424.3471, -29.84891, 4.730265, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(100879, 17723, 546, 3716, 0, '1,2', 0, 0, 0, 3.947948, -385.2096, 32.2602, 6.195919, 7200, 5, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17723 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100880, 20465, 546, 3716, 0, '1,2', 0, 0, 0, -19.41886, -404.3788, -27.83541, 6.05558, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(100881, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 19.10996, -383.7289, -20.26596, 0.1578955, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(100882, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 14.57356, -425.7657, -22.39791, 3.447365, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101018, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 41.88461, -395.9853, -22.00207, 4.027682, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101048, 17723, 546, 3716, 0, '1,2', 0, 0, 0, 74.67423, -383.971, 33.71605, 0.9250245, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17723 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(101049, 3300, 546, 3716, 0, '1,2', 0, 0, 0, 83.4207, -291.0659, 32.17554, 4.13643, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 3300 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(101050, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 110.7203, -278.4279, -18.89096, 5.288348, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101052, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 128.3659, -271.0517, -18.09601, 5.044002, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101331, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 115.2291, -346.7375, -18.09929, 3.700098, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101332, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 110.4429, -302.9094, -18.89096, 2.75762, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101333, 17726, 546, 3716, 0, '1,2', 0, 0, 0, 117.0054, -401.9983, 42.50909, 5.851573, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17726 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(101334, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 143.2567, -347.1, -18.18263, 1.432916, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101335, 17726, 546, 3716, 0, '1,2', 0, 0, 0, 115.9606, -404.2694, 42.52244, 5.851578, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17726 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(101336, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 141.7265, -299.0849, -18.18263, 2.286241, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101337, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 82.4612, -399.6071, -20.07825, 2.122275, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101338, 17771, 546, 3716, 0, '1,2', 0, 0, 0, 171.2823, -402.4821, 72.31525, 5.916666, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17771 (Area: 0 - Difficulty: 0) +(101339, 17729, 546, 3716, 0, '1,2', 0, 0, 0, 183.8088, -387.5832, 48.15574, 5.689773, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17729 (Area: 0 - Difficulty: 0) +(101340, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 128.9057, -390.2778, -18.18263, 3.710228, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101341, 17726, 546, 3716, 0, '1,2', 0, 0, 0, 165.5912, -417.708, 48.10725, 3.9843, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17726 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(101342, 17727, 546, 3716, 0, '1,2', 0, 0, 0, 148.124, -424.8145, 48.62396, 2.792527, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17727 (Area: 0 - Difficulty: 0) (Auras: 18950 - 18950) (possible waypoints or random movement) +(101343, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 182.3005, -390.5899, 48.17153, 5.393067, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) +(101526, 17730, 546, 3716, 0, '1,2', 0, 0, 0, 179.034, -391.3381, 48.15665, 5.183628, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17730 (Area: 0 - Difficulty: 0) +(101589, 17727, 546, 3716, 0, '1,2', 0, 0, 0, 150.9607, -417.711, 48.614, 2.932153, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17727 (Area: 0 - Difficulty: 0) (Auras: 18950 - 18950) (possible waypoints or random movement) +(101599, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 161.4782, -439.5381, 48.20968, 2.042035, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(101626, 17726, 546, 3716, 0, '1,2', 0, 0, 0, 165.4774, -428.3253, 48.12585, 4.416763, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17726 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(101638, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 163.5769, -435.3001, 72.45844, 5.986479, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) +(101639, 17771, 546, 3716, 0, '1,2', 0, 0, 0, 162.6187, -424.8423, 72.40461, 0.8901179, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17771 (Area: 0 - Difficulty: 0) +(101686, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 166.5553, -438.5267, 48.28257, 2.042035, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(101722, 18105, 546, 3716, 0, '1,2', 0, 0, 0, 276.9245, -457.9421, 37.05632, 1.646427, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 18105 (Area: 0 - Difficulty: 0) (Auras: 8876 - 8876) (possible waypoints or random movement) +(101724, 17771, 546, 3716, 0, '1,2', 0, 0, 0, 158.7716, -429.5756, 72.34808, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17771 (Area: 0 - Difficulty: 0) +(101725, 17771, 546, 3716, 0, '1,2', 0, 0, 0, 177.1148, -412.503, 48.25968, 2.670354, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17771 (Area: 0 - Difficulty: 0) +(101727, 17735, 546, 3716, 0, '1,2', 0, 0, 0, 163.8997, -429.2021, 72.44372, 0.06981317, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17735 (Area: 0 - Difficulty: 0) +(101733, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 172.6644, -407.3786, 72.38916, 5.707227, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) +(101734, 17729, 546, 3716, 0, '1,2', 0, 0, 0, 158.1902, -444.1273, 48.18988, 1.64061, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17729 (Area: 0 - Difficulty: 0) (Auras: ) +(101735, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 117.0053, -430.773, -26.33541, 0.6656758, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101736, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 181.5612, -410.9746, 48.28504, 2.897247, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) +(101737, 17735, 546, 3716, 0, '1,2', 0, 0, 0, 162.697, -444.8836, 48.26812, 2.356194, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17735 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(101738, 17726, 546, 3716, 0, '1,2', 0, 0, 0, 161.7652, -451.5547, 72.42375, 4.47234, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17726 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(101741, 17771, 546, 3716, 0, '1,2', 0, 0, 0, 176.2656, -399.8407, 72.35859, 0.122173, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17771 (Area: 0 - Difficulty: 0) +(101748, 17735, 546, 3716, 0, '1,2', 0, 0, 0, 177.4339, -404.1742, 72.42442, 6.161012, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17735 (Area: 0 - Difficulty: 0) +(101749, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 194.4791, -417.1634, 36.70906, 1.745329, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943) (possible waypoints or random movement) +(101750, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 175.8059, -416.5865, 48.26939, 2.9147, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) +(101752, 17771, 546, 3716, 0, '1,2', 0, 0, 0, 209.1749, -379.4501, 48.14782, 6.171502, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17771 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(101756, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 209.6352, -379.5696, 48.1512, 6.186557, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(101757, 17735, 546, 3716, 0, '1,2', 0, 0, 0, 214.0971, -380.0021, 48.14805, 6.168838, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17735 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(101758, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 202.2552, -389.2308, 72.51597, 5.88176, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) +(101759, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 199.5615, -418.2614, 36.70906, 2.164501, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(101760, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 186.2828, -466.198, 25.216, 3.368485, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943) (possible waypoints or random movement) +(101763, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 195.613, -422.9581, 3.000725, 3.368485, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943) (possible waypoints or random movement) +(101770, 17771, 546, 3716, 0, '1,2', 0, 0, 0, 211.9668, -379.6976, 48.16463, 6.141215, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17771 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(101771, 17771, 546, 3716, 0, '1,2', 0, 0, 0, 201.3456, -384.036, 72.42652, 5.969026, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17771 (Area: 0 - Difficulty: 0) +(101772, 17726, 546, 3716, 0, '1,2', 0, 0, 0, 167.5814, -440.4111, 72.47586, 1.330749, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17726 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(101777, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 208.8107, -440.5094, 36.70906, 5.794493, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943) (possible waypoints or random movement) +(101779, 17730, 546, 3716, 0, '1,2', 0, 0, 0, 197.1618, -389.322, 72.4649, 5.096361, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17730 (Area: 0 - Difficulty: 0) +(101780, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 211.9163, -437.4629, 3.48419, 4.321147, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102317, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 214.9197, -415.2824, 36.70906, 2.307468, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102342, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 189.5446, -472.3213, 9.114759, 5.768517, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102343, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 225.7521, -411.6602, 3.484192, 6.002326, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102344, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 233.8672, -437.1182, 22.29686, 1.692969, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943) (possible waypoints or random movement) +(102401, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 225.2188, -448.0663, 3.611238, 4.809144, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102402, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 222.7104, -447.2278, 40.25183, 5.188642, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102403, 15384, 546, 3716, 0, '1,2', 0, 0, 0, 241.8576, -450.6032, 26.66725, 5.323254, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 15384 (Area: 0 - Difficulty: 0) +(102404, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 214.8713, -470.975, 3.48419, 0.03891297, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102405, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 234.7334, -440.0353, 27.45263, 5.248818, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102406, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 226.0756, -387.7996, 2.319601, 6.232756, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102407, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 243.4514, -460.4575, 27.79128, 2.041499, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102408, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 234.3204, -431.9809, 32.92886, 0.4144117, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102409, 17735, 546, 3716, 0, '1,2', 0, 0, 0, 256.6105, -374.5453, 72.26968, 2.842869, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17735 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(102410, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 235.6858, -377.2372, -7.777852, 6.004404, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102411, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 281.8633, -396.969, 43.93818, 2.466483, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102412, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 271.0754, -372.5634, 72.40002, 0.296706, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) +(102414, 17730, 546, 3716, 0, '1,2', 0, 0, 0, 259.4254, -367.6755, 72.38194, 1.22173, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17730 (Area: 0 - Difficulty: 0) +(102415, 17728, 546, 3716, 0, '1,2', 0, 0, 0, 260.3474, -382.585, 72.61395, 4.049164, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17728 (Area: 0 - Difficulty: 0) +(102470, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 282.2472, -427.1982, 18.77156, 3.316126, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943) (possible waypoints or random movement) +(102595, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 274.7035, -388.8533, -7.777852, 5.81178, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102626, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 211.0068, -316.5333, -28.01179, 5.581476, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102645, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 259.1389, -446.795, 3.000724, 4.328416, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943) (possible waypoints or random movement) +(102648, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 290.5881, -411.4368, 26.84795, 4.362783, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102649, 17732, 546, 3716, 0, '1,2', 0, 18722, 0, 276.8408, -289.8254, 21.84543, 2.482409, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17732 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(102650, 17732, 546, 3716, 0, '1,2', 0, 18722, 0, 275.0034, -292.1969, 21.16567, 2.482411, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17732 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(102651, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 300.3515, -315.1825, 19.94298, 3.159046, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(102652, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 268.3176, -461.9151, 26.84795, 0.3073693, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102661, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 246.0445, -503.8543, 34.93822, 6.195919, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943) (possible waypoints or random movement) +(102662, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 262.4225, -490.0611, 34.93822, 3.523672, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102663, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 215.2454, -484.3615, 3.528299, 2.941062, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102664, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 264.166, -465.0034, 25.6448, 2.417188, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102665, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 225.5597, -515.9789, 34.93822, 0.2837423, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102666, 20465, 546, 3716, 0, '1,2', 0, 0, 0, 240.2113, -502.6047, 3.48419, 0.07167748, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20465 (Area: 0 - Difficulty: 0) (Auras: 18943 - 18943, 18950 - 18950) (possible waypoints or random movement) +(102777, 3300, 546, 3716, 0, '1,2', 0, 0, 0, 362.1898, -447.9113, 31.97647, 2.059489, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 3300 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(102881, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 323.2391, -338.6123, 25.18758, 2.495097, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(102985, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 316.9334, -331.7904, 21.54243, 2.598775, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(102986, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 306.5542, -312.8967, 18.87682, 1.157422, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103220, 16030, 546, 3716, 0, '1,2', 0, 0, 0, 307.5977, -311.8829, 18.71728, 3.176499, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 14545), -- 16030 (Area: 0 - Difficulty: 0) +(103233, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 302.8495, -298.6646, 20.67287, 5.949665, 7200, 3, 0, 0, 0, 1, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103236, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 323.5782, -330.1841, 21.19097, 5.659471, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103239, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 262.1201, -270.9468, 24.49393, 6.143559, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103245, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 269.4341, -271.4952, 25.82761, 4.014257, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103246, 17826, 546, 3716, 0, '1,2', 0, 0, 0, 281.5271, -120.3684, 29.75141, 2.937197, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17826 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103291, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 265.9181, -263.1397, 25.70213, 5.876039, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103292, 16030, 546, 3716, 0, '1,2', 0, 0, 0, 270.3728, -263.1617, 26.51717, 5.334435, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 14545), -- 16030 (Area: 0 - Difficulty: 0) +(103293, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 270.6582, -211.7811, 29.07705, 4.18879, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103294, 17732, 546, 3716, 0, '1,2', 0, 18722, 0, 266.1115, -217.9775, 28.86627, 4.031711, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17732 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103299, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 273.3487, -222.7411, 29.43033, 3.909538, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103300, 19632, 546, 3716, 0, '1,2', 0, 19367, 0, 276.6519, -188.8499, 28.75227, 3.996804, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 19632 (Area: 0 - Difficulty: 0) (Auras: ) +(103321, 16030, 546, 3716, 0, '1,2', 0, 0, 0, 267.3251, -230.2211, 28.09329, 5.849432, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 14545), -- 16030 (Area: 0 - Difficulty: 0) +(103322, 16030, 546, 3716, 0, '1,2', 0, 0, 0, 275.3625, -201.3559, 29.26292, 0.08737221, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 14545), -- 16030 (Area: 0 - Difficulty: 0) +(103323, 19632, 546, 3716, 0, '1,2', 0, 19367, 0, 272.37381, -289.203278, 22.130516, 1.729358, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 19632 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103363, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 272.9767, -184.7347, 28.97069, 3.647738, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: ) +(103393, 17732, 546, 3716, 0, '1,2', 0, 18722, 0, 253.9569, -183.7056, 28.18596, 5.51524, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17732 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103395, 17732, 546, 3716, 0, '1,2', 0, 18722, 0, 265.4161, -195.6269, 28.48796, 5.09993, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17732 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103404, 17732, 546, 3716, 0, '1,2', 0, 18722, 0, 269.1184, -194.1127, 28.5438, 5.099929, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17732 (Area: 0 - Difficulty: 0) (Auras: 8599 - 8599) (possible waypoints or random movement) +(103412, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 245.4671, -183.9176, 26.89462, 5.532694, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(103414, 19632, 546, 3716, 0, '1,2', 0, 19367, 0, 261.7127, -197.1385, 28.43213, 5.099928, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 19632 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(103423, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 247.907, -176.7446, 27.55006, 4.560362, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(103424, 16030, 546, 3716, 0, '1,2', 0, 0, 0, 248.0885, -169.5479, 27.89926, 1.624346, 7200, 8, 0, 0, 0, 1, 0, 0, 0, 14545), -- 16030 (Area: 0 - Difficulty: 0) +(103431, 17827, 546, 3716, 0, '1,2', 0, 0, 0, 289.2553, -129.7001, 29.82101, 2.495821, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17827 (Area: 0 - Difficulty: 0) +(103432, 17734, 546, 3716, 0, '1,2', 0, 0, 0, 158.53, -167.4191, 32.28274, 4.377234, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17734 (Area: 0 - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(103444, 1420, 546, 3716, 0, '1,2', 0, 0, 0, 161.1617, -125.5614, 26.00058, 1.151917, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 1420 (Area: 0 - Difficulty: 0) +(103462, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 220.4242, -33.27042, 27.64584, 5.8294, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +(103466, 17992, 546, 3716, 0, '1,2', 0, 0, 0, 154.5647, -120.8689, 93.15466, 4.363323, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17992 (Area: 0 - Difficulty: 0) +(103467, 17992, 546, 3716, 0, '1,2', 0, 0, 0, 166.4526, -66.93163, 79.71866, 0.2268928, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17992 (Area: 0 - Difficulty: 0) +(103468, 17992, 546, 3716, 0, '1,2', 0, 0, 0, 188.7344, -50.33648, 78.24084, 2.024582, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17992 (Area: 0 - Difficulty: 0) +(103470, 17992, 546, 3716, 0, '1,2', 0, 0, 0, 125.894, -161.7246, 74.32575, 1.256637, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17992 (Area: 0 - Difficulty: 0) +(103471, 17992, 546, 3716, 0, '1,2', 0, 0, 0, 209.5252, -35.40108, 67.54169, 1.204277, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17992 (Area: 0 - Difficulty: 0) +(103473, 17992, 546, 3716, 0, '1,2', 0, 0, 0, 141.1752, -3.968777, 51.25695, 6.265732, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17992 (Area: 0 - Difficulty: 0) +(103474, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 146.4813, -4.129868, 27.15961, 4.677482, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +(103475, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 203.2825, -7.221702, 27.64585, 4.468043, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +(103476, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 178.9776, 0.429707, 26.87488, 4.904375, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +(103479, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 200.3221, 31.84094, 27.64584, 0.9250245, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +(103543, 3300, 546, 3716, 0, '1,2', 0, 0, 0, 182.0832, 14.3301, 27.64584, 4.310963, 7200, 10, 0, 0, 0, 1, 0, 0, 0, 14545), -- 3300 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(103580, 17992, 546, 3716, 0, '1,2', 0, 0, 0, 172.5348, 11.44622, 46.77779, 1.58825, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17992 (Area: 0 - Difficulty: 0) +(103581, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 209.0404, 28.1186, 27.64584, 2.373648, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +(103589, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 159.3975, 28.01763, 27.0675, 1.902409, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +(103590, 17992, 546, 3716, 0, '1,2', 0, 0, 0, 220.7916, -8.578307, 56.90279, 5.864306, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17992 (Area: 0 - Difficulty: 0) +(103605, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 200.2293, 37.38313, 27.64584, 4.502949, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +(103616, 17992, 546, 3716, 0, '1,2', 0, 0, 0, 146.315, 34.87498, 50.6389, 2.146755, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 17992 (Area: 0 - Difficulty: 0) +(103617, 17731, 546, 3716, 0, '1,2', 0, 0, 0, 138.0029, 39.86865, 27.05139, 3.874631, 7200, 0, 0, 0, 0, 0, 0, 33555264, 0, 14545), -- 17731 (Area: 0 - Difficulty: 0) (Auras: 31261 - 31261) +(103638, 17885, 546, 3716, 0, '1,2', 0, 0, 1, 296.697, -362.373, 50.1506, 5.5676, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 80216, +(103639, 18409, 546, 3716, 0, '1,2', 0, 0, 0, 54.5179, -230.67, 14.3503, 5.5676, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), +(103640, 18409, 546, 3716, 0, '1,2', 0, 0, 0, 24.9916, -372.869, 69.4133, 5.5676, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545); + +UPDATE `smart_scripts` SET `action_param2`=103431 WHERE `entryorguid`=17826 AND `source_type`=0 AND `id`=13; +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (18409,20170,17992); +INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`) VALUES +(18409, 1, 1, 2, 0),(20170, 1, 1, 2, 0),(17992, 0, 0, 1, 0); +UPDATE `creature_template` SET `unit_flags`= 32832 WHERE `entry` IN (20465,21943); +UPDATE `creature` SET `spawndist`=8, `MovementType`=1 WHERE `id` IN (20465); + +DELETE FROM `creature_addon` WHERE `guid` IN (54187, 54189, 54191, 54203, 54210, 54211, 54212, 54213, 54214, 54215, 54216, 54217, 54218, 54246, 54247, 54248, 54249, 54250, 54337, 54339, 54381, 54383, 54385, 54387, 54389, 54392, 54394, 54396, 54397, 54399, 54401, 54403, 54405, 54406, 54407, 54408, 54409, 54410, 54411, 54412, 54420, 54421, 54424, 54427, 54615, 54622, 54637, 54700, 54701, 54703, 54799, 55068, 55102, 55106, 55391, 55536, 55552, 55553, 55903, 56109, 56111, 56112, 56142, 56143, 56144, 56145, 56164, 56168, 56316, 56328, 56551, 56862, 56868, 57012, 57013, 57015, 86372, 100861, 100862, 100863, 100879, 100880, 100881, 100882, 101018, 101048, 101049, 101050, 101052, 101331, 101332, 101333, 101334, 101335, 101336, 101337, 101338, 101339, 101340, 101341, 101342, 101343, 101526, 101589, 101599, 101626, 101638, 101639, 101686, 101722, 101724, 101725, 101727, 101733, 101734, 101735, 101736, 101737, 101738, 101741, 101748, 101749, 101750, 101752, 101756, 101757, 101758, 101759, 101760, 101763, 101770, 101771, 101772, 101777, 101779, 101780, 102317, 102342, 102343, 102344, 102401, 102402, 102403, 102404, 102405, 102406, 102407, 102408, 102409, 102410, 102411, 102412, 102414, 102415, 102470, 102595, 102626, 102645, 102648, 102649, 102650, 102651, 102652, 102661, 102662, 102663, 102664, 102665, 102666, 102777, 102881, 102985, 102986, 103220, 103233, 103236, 103239, 103245, 103246, 103291, 103292, 103293, 103294, 103299, 103300, 103321, 103322, 103323, 103363, 103393, 103395, 103404, 103412, 103414, 103423, 103424, 103431, 103432, 103444, 103462, 103466, 103467, 103468, 103470, 103471, 103473, 103474, 103475, 103476, 103479, 103543, 103580, 103581, 103589, 103590, 103605, 103616, 103617, 103639, 103640); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(54187, 0, 0, 0, 1, 0, ''), -- 17725 - 34161 - 34161 +(54189, 0, 0, 0, 1, 0, ''), -- 17725 +(54191, 541910, 0, 0, 1, 0, ''), -- 17724 +(54203, 0, 0, 0, 1, 0, ''), -- 17725 +(54210, 0, 0, 0, 1, 0, ''), -- 17871 +(54211, 0, 0, 0, 1, 0, ''), -- 17871 +(54212, 0, 0, 0, 1, 0, ''), -- 1420 +(54213, 0, 0, 0, 1, 0, ''), -- 1420 +(54214, 542140, 0, 0, 1, 0, ''), -- 18409 +(54215, 542150, 0, 0, 1, 0, ''), -- 18409 +(54216, 0, 0, 0, 1, 0, ''), -- 17725 - 34161 - 34161 +(54217, 542170, 0, 0, 1, 0, ''), -- 17724 +(54218, 0, 0, 0, 1, 0, ''), -- 17725 - 34161 - 34161 +(54246, 0, 0, 0, 1, 0, ''), -- 17871 +(54247, 542470, 0, 0, 1, 0, ''), -- 18409 +(54248, 0, 0, 0, 1, 0, ''), -- 17725 +(54249, 0, 0, 0, 1, 0, ''), -- 17871 +(54250, 0, 0, 0, 1, 0, ''), -- 17992 +(54337, 543370, 0, 0, 1, 0, ''), -- 17882 +(54339, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(54381, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(54383, 0, 0, 0, 1, 0, ''), -- 18409 +(54385, 0, 0, 0, 1, 0, ''), -- 17725 +(54387, 0, 0, 0, 1, 0, ''), -- 17871 +(54389, 0, 0, 0, 1, 0, ''), -- 17725 +(54392, 543920, 0, 0, 1, 0, ''), -- 18409 +(54394, 543940, 0, 0, 1, 0, ''), -- 18409 +(54396, 543960, 0, 0, 1, 0, ''), -- 17734 +(54397, 543970, 0, 0, 1, 0, ''), -- 17724 +(54399, 0, 0, 0, 1, 0, ''), -- 17724 +(54401, 0, 0, 0, 1, 0, ''), -- 17724 +(54403, 0, 0, 0, 1, 0, ''), -- 17725 +(54405, 0, 0, 0, 1, 0, ''), -- 17724 +(54406, 0, 0, 0, 1, 0, ''), -- 17725 +(54407, 0, 0, 0, 1, 0, ''), -- 17871 +(54408, 0, 0, 0, 1, 0, ''), -- 17724 +(54409, 0, 0, 0, 1, 0, ''), -- 17724 +(54410, 544100, 0, 0, 1, 0, ''), -- 18409 +(54411, 0, 0, 0, 1, 0, ''), -- 17724 +(54412, 0, 0, 0, 1, 0, ''), -- 17723 +(54420, 0, 0, 0, 1, 0, ''), -- 17724 +(54421, 544210, 0, 0, 1, 0, ''), -- 17724 +(54424, 544240, 0, 0, 1, 0, ''), -- 17724 +(54427, 0, 0, 0, 1, 0, ''), -- 3300 +(54615, 0, 0, 0, 1, 0, ''), -- 17724 +(54622, 0, 0, 0, 1, 0, ''), -- 1420 +(54637, 0, 0, 0, 1, 0, ''), -- 17724 +(54700, 547000, 0, 0, 1, 0, ''), -- 17724 +(54701, 547010, 0, 0, 1, 0, ''), -- 18409 +(54703, 0, 0, 0, 1, 0, ''), -- 17871 +(54799, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(55068, 0, 0, 0, 1, 0, ''), -- 17725 +(55102, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(55106, 551060, 0, 0, 1, 0, ''), -- 17723 +(55391, 553910, 0, 0, 1, 0, ''), -- 17724 +(55536, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(55552, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(55553, 555530, 0, 0, 1, 0, ''), -- 17723 +(55903, 0, 0, 0, 1, 0, ''), -- 17724 +(56109, 0, 0, 0, 1, 0, ''), -- 3300 +(56111, 0, 0, 0, 1, 0, ''), -- 17770 +(56112, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(56142, 0, 0, 0, 1, 0, ''), -- 17724 +(56143, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(56144, 0, 0, 0, 1, 0, ''), -- 17724 +(56145, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(56164, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(56168, 561680, 0, 0, 1, 0, ''), -- 17723 +(56316, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(56328, 563280, 0, 0, 1, 0, ''), -- 17723 +(56551, 0, 0, 0, 1, 0, ''), -- 1420 +(56862, 0, 0, 0, 1, 0, ''), -- 17723 - 8599 - 8599 +(56868, 0, 0, 0, 1, 0, ''), -- 17723 +(57012, 0, 0, 0, 1, 0, ''), -- 1420 +(57013, 0, 0, 0, 1, 0, ''), -- 17724 +(57015, 570150, 0, 0, 1, 0, ''), -- 17724 +(86372, 0, 0, 0, 1, 0, ''), -- 17724 +(100861, 0, 0, 0, 1, 0, ''), -- 17724 +(100862, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(100863, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(100879, 0, 0, 0, 1, 0, ''), -- 17723 +(100880, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(100881, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(100882, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101018, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101048, 1010480, 0, 0, 1, 0, ''), -- 17723 +(101049, 0, 0, 0, 1, 0, ''), -- 3300 +(101050, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101052, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101331, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101332, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101333, 0, 0, 0, 1, 0, ''), -- 17726 +(101334, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101335, 1013350, 0, 0, 1, 0, ''), -- 17726 +(101336, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101337, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101338, 0, 0, 0, 1, 0, ''), -- 17771 +(101339, 0, 0, 0, 1, 0, ''), -- 17729 +(101340, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101341, 0, 0, 0, 1, 0, ''), -- 17726 +(101342, 0, 0, 0, 1, 0, '18950'), -- 17727 - 18950 - 18950 +(101343, 0, 0, 0, 1, 0, ''), -- 17728 +(101526, 0, 0, 0, 1, 0, ''), -- 17730 +(101589, 0, 0, 0, 1, 0, '18950'), -- 17727 - 18950 - 18950 +(101599, 0, 0, 0, 1, 0, ''), -- 17728 +(101626, 1016260, 0, 0, 1, 0, ''), -- 17726 +(101638, 0, 0, 0, 1, 0, ''), -- 17728 +(101639, 0, 0, 0, 1, 0, ''), -- 17771 +(101686, 0, 0, 0, 1, 0, ''), -- 17728 +(101722, 1017220, 0, 0, 1, 0, '8876'), -- 18105 - 8876 - 8876 +(101724, 0, 0, 0, 1, 0, ''), -- 17771 +(101725, 0, 0, 0, 1, 0, ''), -- 17771 +(101727, 0, 0, 0, 1, 0, ''), -- 17735 +(101733, 0, 0, 0, 1, 0, ''), -- 17728 +(101734, 0, 0, 0, 1, 0, ''), -- 17729 +(101735, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101736, 0, 0, 0, 1, 0, ''), -- 17728 +(101737, 0, 0, 0, 1, 0, ''), -- 17735 +(101738, 0, 0, 0, 1, 0, ''), -- 17726 +(101741, 0, 0, 0, 1, 0, ''), -- 17771 +(101748, 0, 0, 0, 1, 0, ''), -- 17735 +(101749, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943 +(101750, 0, 0, 0, 1, 0, ''), -- 17728 +(101752, 0, 0, 0, 1, 0, ''), -- 17771 +(101756, 0, 0, 0, 1, 0, ''), -- 17728 +(101757, 1017570, 0, 0, 1, 0, ''), -- 17735 +(101758, 0, 0, 0, 1, 0, ''), -- 17728 +(101759, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(101760, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943 +(101763, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943 +(101770, 0, 0, 0, 1, 0, ''), -- 17771 +(101771, 0, 0, 0, 1, 0, ''), -- 17771 +(101772, 1017720, 0, 0, 1, 0, ''), -- 17726 +(101777, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943 +(101779, 0, 0, 0, 1, 0, ''), -- 17730 +(101780, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102317, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102342, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102343, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102344, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943 +(102401, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102402, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102403, 0, 0, 0, 1, 0, ''), -- 15384 +(102404, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102405, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102406, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102407, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102408, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102409, 1024090, 0, 0, 1, 0, ''), -- 17735 +(102410, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102411, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102412, 0, 0, 0, 1, 173, ''), -- 17728 +(102414, 0, 0, 8, 1, 0, ''), -- 17730 +(102415, 0, 0, 0, 1, 173, ''), -- 17728 +(102470, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943 +(102595, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102626, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102645, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943 +(102648, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102649, 0, 0, 0, 1, 0, ''), -- 17732 +(102650, 0, 0, 0, 1, 0, ''), -- 17732 +(102651, 0, 0, 0, 1, 0, ''), -- 17731 +(102652, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102661, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943 +(102662, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102663, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102664, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102665, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102666, 0, 0, 0, 1, 0, '18943 18950'), -- 20465 - 18943 - 18943, 18950 - 18950 +(102777, 0, 0, 0, 1, 0, ''), -- 3300 +(102881, 1028810, 0, 0, 1, 0, ''), -- 17731 +(102985, 0, 0, 0, 1, 0, ''), -- 17731 +(102986, 0, 0, 0, 1, 0, ''), -- 17731 +(103220, 0, 0, 0, 1, 0, ''), -- 16030 +(103233, 0, 0, 0, 1, 0, ''), -- 17731 +(103236, 0, 0, 0, 1, 0, ''), -- 17731 +(103239, 0, 0, 0, 1, 0, ''), -- 17731 +(103245, 0, 0, 0, 1, 0, ''), -- 17731 +(103246, 1032460, 0, 0, 1, 0, ''), -- 17826 +(103291, 0, 0, 0, 1, 0, ''), -- 17731 +(103292, 0, 0, 0, 1, 0, ''), -- 16030 +(103293, 0, 0, 0, 1, 0, ''), -- 17731 +(103294, 0, 0, 0, 1, 0, ''), -- 17732 +(103299, 0, 0, 0, 1, 0, ''), -- 17731 +(103300, 0, 0, 0, 1, 0, ''), -- 19632 +(103321, 0, 0, 0, 1, 0, ''), -- 16030 +(103322, 0, 0, 0, 1, 0, ''), -- 16030 +(103323, 1033230, 0, 0, 1, 0, ''), -- 19632 +(103363, 0, 0, 0, 1, 0, ''), -- 17731 +(103393, 0, 0, 0, 1, 0, ''), -- 17732 +(103395, 1033950, 0, 0, 1, 0, ''), -- 17732 +(103404, 0, 0, 0, 1, 0, ''), -- 17732 - 8599 - 8599 +(103412, 0, 0, 0, 1, 0, ''), -- 17731 +(103414, 0, 0, 0, 1, 0, ''), -- 19632 +(103423, 0, 0, 0, 1, 0, ''), -- 17731 +(103424, 0, 0, 0, 1, 0, ''), -- 16030 +(103431, 0, 0, 0, 1, 0, ''), -- 17827 +(103432, 1034320, 0, 0, 1, 0, ''), -- 17734 +(103444, 0, 0, 0, 1, 0, ''), -- 1420 +(103462, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(103466, 0, 0, 0, 1, 0, ''), -- 17992 +(103467, 0, 0, 0, 1, 0, ''), -- 17992 +(103468, 0, 0, 0, 1, 0, ''), -- 17992 +(103470, 0, 0, 0, 1, 0, ''), -- 17992 +(103471, 0, 0, 0, 1, 0, ''), -- 17992 +(103473, 0, 0, 0, 1, 0, ''), -- 17992 +(103474, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(103475, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(103476, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(103479, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(103543, 0, 0, 0, 1, 0, ''), -- 3300 +(103580, 0, 0, 0, 1, 0, ''), -- 17992 +(103581, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(103589, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(103590, 0, 0, 0, 1, 0, ''), -- 17992 +(103605, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(103616, 0, 0, 0, 1, 0, ''), -- 17992 +(103617, 0, 0, 0, 1, 0, '31261'), -- 17731 - 31261 - 31261 +(103639, 1036390, 0, 0, 1, 0, ''), +(103640, 1036400, 0, 0, 1, 0, ''); + +UPDATE `creature_template_addon` SET `auras`='' WHERE `entry`=17725; +UPDATE `creature_template_addon` SET `auras`='8876' WHERE `entry`=18105; +UPDATE `creature_template_addon` SET `auras`='8876' WHERE `entry`=18105; +DELETE FROM `creature_template_addon` WHERE `entry` IN (17727, 20465); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(17727, 0, 0, 0, 1, 0, '18950'), -- 17727 - 18950 +(20465, 0, 0, 0, 1, 0, '18943 18950'); -- 20465 - 18943, 18950 + +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (54421,54700,54637,54411,54397,54405,54424,54420,54383,54247,54408,54409,55391,56142,55903,57015, 57013, 100861, 86372,101335,101333,101626, 101341,101757, 101770, 101756, 101752,101772, 101738,102881, 102985, 103236, 103323, 102649, 102650, 103395, 103414, 103404) AND `memberGUID` IN(54421,54700,54637,54411,54397,54405,54424,54420,54383,54247,54408,54409,55391,56142,55903,57015, 57013, 100861, 86372,101335,101333,101626, 101341,101757, 101770, 101756, 101752,101772, 101738,102881, 102985, 103236, 103323, 102649, 102650, 103395, 103414, 103404); +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(54421, 54421, 0, 0, 515, 0, 0), +(54421, 54411, 4, 0, 515, 0, 0), +(54700, 54700, 0, 0, 515, 0, 0), +(54700, 54637, 4, 0, 515, 0, 0), +(54397, 54397, 0, 0, 515, 0, 0), +(54397, 54405, 4, 0, 515, 0, 0), +(54424, 54424, 0, 0, 515, 1, 4), +(54424, 54420, 4, 45, 515, 1, 4), +(54424, 54383, 4, 315, 515, 1, 4), +(54247, 54247, 0, 0, 515, 0, 0), +(54247, 54408, 4, 45, 515, 0, 0), +(54247, 54409, 4, 315, 515, 0, 0), +(55391, 55391, 0, 0, 515, 9, 1), +(55391, 56142, 4, 45, 515, 9, 1), +(55391, 55903, 4, 315, 515, 9, 1), +(57015, 57015, 0, 0, 515, 0, 0), +(57015, 57013, 4, 45, 515, 0, 0), +(57015, 100861, 4, 315, 515, 0, 0), +(57015, 86372, 7, 0, 515, 0, 0), +(101335, 101335, 0, 0, 515, 1, 4), +(101335, 101333, 3, 270, 515, 1, 4), +(101626, 101626, 0, 0, 515, 1, 4), +(101626, 101341, 3, 270, 515, 1, 4), +(101757, 101757, 0, 0, 515, 1, 4), +(101757, 101770, 4, 45, 515, 1, 4), +(101757, 101756, 4, 315, 515, 1, 4), +(101757, 101752, 7, 0, 515, 1, 4), +(101772, 101772, 0, 0, 515, 1, 3), +(101772, 101738, 3, 270, 515, 1, 3), +(102881, 102881, 0, 0, 515, 1, 5), +(102881, 102985, 4, 45, 515, 1, 5), +(102881, 103236, 4, 315, 515, 1, 5), +(103323, 103323, 0, 0, 515, 1, 5), +(103323, 102649, 4, 45, 515, 1, 5), +(103323, 102650, 4, 315, 515, 1, 5), +(103395, 103395, 0, 0, 515, 1, 5), +(103395, 103414, 4, 45, 515, 5, 14), +(103395, 103404, 4, 315, 515, 5, 14); + +SET @NPC := 56328; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, 87.7378, -291.7757, 32.1056, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 69.6682, -288.8158, 32.2100, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 43.3150, -293.6601, 32.7044, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 13.9614, -314.4955, 31.6271, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 43.3150, -293.6601, 32.7044, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 69.6682, -288.8158, 32.2100, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 87.7378, -291.7757, 32.1056, 0, 0, 0, 0, 100, 0); + +SET @NPC := 56168; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, -17.629, -361.23, 29.8011, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -15.8119, -337.979, 30.8115, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -0.144584, -321.99, 31.0481, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -14.2938, -335.512, 30.9407, 0, 0, 0, 0, 100, 0); + +SET @NPC := 101048; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, 74.6742, -383.971, 33.716, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 89.5624, -363.165, 33.261, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 100.412, -335.382, 32.947, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 89.5555, -296.284, 32.082, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 100.412, -335.382, 32.947, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 89.5624, -363.165, 33.261, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 74.6742, -383.971, 33.716, 0, 0, 0, 0, 100, 0); + + +SET @NPC := 55106; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, -38.07647, -263.434, -4.535, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -49.05260, -278.210, -4.535, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -59.19419, -289.677, -4.534, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -78.34389, -296.625, -4.535, 0, 0, 0, 0, 100, 0), +(@PATH, 5, -97.43962, -303.149, -4.545, 0, 0, 0, 0, 100, 0), +(@PATH, 6, -119.1565, -305.540, -4.629, 0, 0, 0, 0, 100, 0), +(@PATH, 7, -97.43962, -303.149, -4.545, 0, 0, 0, 0, 100, 0), +(@PATH, 8, -78.34389, -296.625, -4.535, 0, 0, 0, 0, 100, 0), +(@PATH, 9, -59.19419, -289.677, -4.534, 0, 0, 0, 0, 100, 0), +(@PATH, 10, -49.05260, -278.210, -4.535, 0, 0, 0, 0, 100, 0), +(@PATH, 11, -38.07647, -263.434, -4.535, 0, 0, 0, 0, 100, 0); + + +SET @NPC := 55553; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, -40.48534, -224.0206, -4.5355, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -60.81554, -225.8456, -4.5355, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -74.79388, -226.6241, -4.5369, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -95.76139, -227.7918, -4.4007, 0, 0, 0, 0, 100, 0), +(@PATH, 5, -115.2360, -224.7614, -4.2676, 0, 0, 0, 0, 100, 0), +(@PATH, 6, -134.7250, -227.5776, -4.0449, 0, 0, 0, 0, 100, 0), +(@PATH, 7, -115.2360, -224.7614, -4.2676, 0, 0, 0, 0, 100, 0), +(@PATH, 8, -95.76139, -227.7918, -4.4007, 0, 0, 0, 0, 100, 0), +(@PATH, 9, -74.79388, -226.6241, -4.5369, 0, 0, 0, 0, 100, 0), +(@PATH, 10, -60.81554, -225.8456, -4.5355, 0, 0, 0, 0, 100, 0), +(@PATH, 11, -40.48534, -224.0206, -4.5355, 0, 0, 0, 0, 100, 0); + +SET @NPC := 54247; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, 3.16944, -188.744, -4.450, 5.35816,0,1,0,100,0), +(@PATH,2, -5.5922, -198.985, -4.533, 5.31100,0,1,0,100,0), +(@PATH,3, -3.9203, -219.919, -4.533, 2.43644,0,1,0,100,0), +(@PATH,4, 9.34354, -227.932, -4.533, 5.68799,0,1,0,100,0), +(@PATH,5, 21.6390, -223.360, -4.533, 0.45331,0,1,0,100,0), +(@PATH,6, 26.8378, -199.975, -4.381, 3.02941,0,1,0,100,0); + +-- Pathing for Underbat Entry: 17724 'TDB FORMAT' +SET @NPC := 54191; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=64.93866,`position_y`=-57.06677,`position_z`=-2.748975 WHERE `guid`=@NPC; +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,64.93866,-57.06677,-2.748975,0,0,1,0,100,0), +(@PATH,2,51.44242,-44.74086,-2.744618,0,0,1,0,100,0); +-- 0xF130453C000048BD .go xyz 64.93866 -57.06677 -2.748975 + +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=54217; +DELETE FROM `waypoint_data` WHERE `id`=542170; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(542170, 1, 57.5315, -46.9562, -2.75265, 0, 0, 1, 0, 100, 0), +(542170, 2, 73.8134, -55.5425, -2.75589, 0, 0, 1, 0, 100, 0), +(542170, 3, 66.6688, -79.5821, -2.75113, 0, 0, 1, 0, 100, 0); + +-- Pathing for Underbat Entry: 17724 'TDB FORMAT' +SET @NPC := 54397; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-17.99925,`position_y`=-117.8123,`position_z`=-4.533901 WHERE `guid`=@NPC; +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,-17.99925,-117.8123,-4.533901,0,0,1,0,100,0), +(@PATH,2,-11.84967,-150.0517,-4.533893,0,0,1,0,100,0), +(@PATH,3,2.884122,-185.097,-4.533973,0,0,1,0,100,0), +(@PATH,4,17.48416,-192.4459,-4.426555,0,0,1,0,100,0), +(@PATH,5,35.6097,-185.9939,-4.075933,0,0,1,0,100,0), +(@PATH,6,53.33583,-171.1975,-3.304403,0,0,1,0,100,0), +(@PATH,7,35.6097,-185.9939,-4.075933,0,0,1,0,100,0), +(@PATH,8,17.48416,-192.4459,-4.426555,0,0,1,0,100,0), +(@PATH,9,2.884122,-185.097,-4.533973,0,0,1,0,100,0), +(@PATH,10,-11.84967,-150.0517,-4.533893,0,0,1,0,100,0); +-- 0xF130453C00004946 .go xyz -17.99925 -117.8123 -4.533901 + +-- Pathing for Underbat Entry: 17724 'TDB FORMAT' +SET @NPC := 54421; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-25.22402,`position_y`=-210.4845,`position_z`=-4.535309 WHERE `guid`=@NPC; +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,-25.22402,-210.4845,-4.535309,0,0,1,0,100,0), +(@PATH,2,-16.93509,-214.414,-4.535187,0,0,1,0,100,0), +(@PATH,3,-8.694112,-208.1724,-4.534595,0,0,1,0,100,0), +(@PATH,4,-9.591006,-198.7675,-4.534464,0,0,1,0,100,0), +(@PATH,5,-16.80874,-194.3225,-4.534508,0,0,1,0,100,0), +(@PATH,6,-23.5645,-196.4073,-4.534851,0,0,1,0,100,0), +(@PATH,7,-27.64475,-202.517,-4.535086,0,0,1,0,100,0); +-- 0xF130453C000048B2 .go xyz -25.22402 -210.4845 -4.535309 + +-- Pathing for Underbat Entry: 17724 'TDB FORMAT' +SET @NPC := 54700; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-5.987698,`position_y`=-240.3305,`position_z`=-4.534287 WHERE `guid`=@NPC; +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,-5.987698,-240.3305,-4.534287,0,0,1,0,100,0), +(@PATH,2,-9.433245,-231.5204,-4.534451,0,0,1,0,100,0), +(@PATH,3,-17.98914,-229.6456,-4.53509,0,0,1,0,100,0), +(@PATH,4,-24.06727,-236.3839,-4.53546,0,0,1,0,100,0), +(@PATH,5,-20.98602,-245.6544,-4.535102,0,0,1,0,100,0), +(@PATH,6,-12.22975,-247.2373,-4.534539,0,0,1,0,100,0); +-- 0xF130453C00004953 .go xyz -5.987698 -240.3305 -4.534287 + +-- Pathing for Underbat Entry: 17724 'TDB FORMAT' +SET @NPC := 54424; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=27.69204,`position_y`=-196.1834,`position_z`=-4.303112 WHERE `guid`=@NPC; +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,27.69204,-196.1834,-4.303112,0,0,1,0,100,0), +(@PATH,2,27.64838,-215.196,-4.533221,0,0,1,0,100,0), +(@PATH,3,34.72726,-231.4422,-4.483186,0,0,1,0,100,0), +(@PATH,4,52.00689,-241.2077,-4.471239,0,0,1,0,100,0), +(@PATH,5,34.72726,-231.4422,-4.483186,0,0,1,0,100,0), +(@PATH,6,27.64838,-215.196,-4.533221,0,0,1,0,100,0); +-- 0xF130453C00004955 .go xyz 27.69204 -196.1834 -4.303112 + +SET @NPC := 55391; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, -68.2543, -270.958, -3.527, 0.621894,0,1,0,100,0), +(@PATH,2, -77.4809, -277.698, -1.476, 3.714916,0,1,0,100,0), +(@PATH,3, -86.0878, -282.792, -0.240, 3.549983,0,1,0,100,0), +(@PATH,4, -100.564, -287.160, 1.7504, 3.259385,0,1,0,100,0), +(@PATH,5, -113.991, -284.276, 5.1831, 2.913810,0,1,0,100,0), +(@PATH,6, -121.515, -280.782, 6.6289, 1.346940,0,1,0,100,0), +(@PATH,7, -115.870, -268.775, 11.893, 1.056343,0,1,0,100,0), +(@PATH,8, -110.063, -261.311, 18.271, 0.765745,0,1,0,100,0), +(@PATH,9, -103.371, -255.783, 24.115, 0.620446,0,1,0,100,0), +(@PATH,10, -110.063, -261.311, 18.271, 0.765745,0,1,0,100,0), +(@PATH,11, -115.870, -268.775, 11.893, 1.056343,0,1,0,100,0), +(@PATH,12, -121.515, -280.782, 6.6289, 1.346940,0,1,0,100,0), +(@PATH,13, -113.991, -284.276, 5.1831, 2.913810,0,1,0,100,0), +(@PATH,14, -100.564, -287.160, 1.7504, 3.259385,0,1,0,100,0), +(@PATH,15, -86.0878, -282.792, -0.240, 3.549983,0,1,0,100,0), +(@PATH,16, -77.4809, -277.698, -1.476, 3.714916,0,1,0,100,0); + +-- Pathing for Underbat Entry: 17724 'TDB FORMAT' +SET @NPC := 57015; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-39.69285,`position_y`=-330.9163,`position_z`=31.3254 WHERE `guid`=@NPC; +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,-39.69285,-330.9163,31.3254,0,0,1,0,100,0), +(@PATH,2,-40.69899,-345.8572,31.7995,0,0,1,0,100,0), +(@PATH,3,-35.31212,-360.4018,31.43062,0,0,1,0,100,0), +(@PATH,4,-27.32051,-380.549,32.00453,0,0,1,0,100,0), +(@PATH,5,-9.648621,-377.5021,28.13209,0,0,1,0,100,0), +(@PATH,6,-5.809507,-359.7889,28.12628,0,0,1,0,100,0), +(@PATH,7,12.88393,-352.9817,27.42694,0,0,1,0,100,0), +(@PATH,8,26.5498,-365.976,27.2501,0,0,1,0,100,0), +(@PATH,9,25.29614,-387.6926,27.5686,0,0,1,0,100,0), +(@PATH,10,13.07229,-403.4628,27.36914,0,0,1,0,100,0), +(@PATH,11,-11.01642,-392.6919,27.87536,0,0,1,0,100,0), +(@PATH,12,-19.35899,-359.8112,29.86074,0,0,1,0,100,0), +(@PATH,13,6.839859,-341.6284,29.91924,0,0,1,0,100,0), +(@PATH,14,5.573694,-326.4384,30.71428,0,0,1,0,100,0), +(@PATH,15,-4.692727,-317.5446,30.68154,0,0,1,0,100,0), +(@PATH,16,-20.20268,-316.2516,30.48794,0,0,1,0,100,0), +(@PATH,17,-31.77262,-320.1931,30.77406,0,0,1,0,100,0); +-- 0xF130453C0000490E .go xyz -39.69285 -330.9163 31.3254 + +SET @NPC := 54701; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, -73.3967, -333.144, 8.65701, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -74.2694, -332.656, 8.65701, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -82.5158, -343.964, 6.29591, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -88.7316, -358.207, 6.29591, 0, 0, 0, 0, 100, 0), +(@PATH, 5, -101.602, -406.876, 8.68479, 0, 0, 0, 0, 100, 0), +(@PATH, 6, -86.4032, -426.207, 8.68479, 0, 0, 0, 0, 100, 0), +(@PATH, 7, -51.8075, -425.376, 14.6848, 0, 0, 0, 0, 100, 0), +(@PATH, 8, -45.9738, -390.017, 8.68479, 0, 0, 0, 0, 100, 0), +(@PATH, 9, -57.0105, -348.513, 6.21258, 0, 0, 0, 0, 100, 0), +(@PATH, 10, -47.5763, -338.499, 11.3237, 0, 0, 0, 0, 100, 0), +(@PATH, 11, -21.7957, -345.619, 8.29591, 0, 0, 0, 0, 100, 0), +(@PATH, 12, 6.31468, -377.248, 5.12925, 0, 0, 0, 0, 100, 0), +(@PATH, 13, 39.8706, -384.494, 8.68479, 0, 0, 0, 0, 100, 0), +(@PATH, 14, 80.9759, -377.99, 8.68479, 0, 0, 0, 0, 100, 0), +(@PATH, 15, 116.241, -371.477, 8.68479, 0, 0, 0, 0, 100, 0), +(@PATH, 16, 93.8944, -398.702, 8.68479, 0, 0, 0, 0, 100, 0), +(@PATH, 17, 83.2156, -406.508, 8.68479, 0, 0, 0, 0, 100, 0), +(@PATH, 18, 48.2402, -426.582, 8.68479, 0, 0, 0, 0, 100, 0), +(@PATH, 19, 3.37404, -419.86, 8.68479, 0, 0, 0, 0, 100, 0), +(@PATH, 20, -39.2932, -400.842, 6.6848, 0, 0, 0, 0, 100, 0), +(@PATH, 21, -52.1263, -388.486, 6.6848, 0, 0, 0, 0, 100, 0), +(@PATH, 22, -58.3059, -375.518, 6.6848, 0, 0, 0, 0, 100, 0), +(@PATH, 23, -58.2668, -360.031, 6.6848, 0, 0, 0, 0, 100, 0), +(@PATH, 24, -63.308, -338.787, 6.6848, 0, 0, 0, 0, 100, 0), +(@PATH, 25, -74.2694, -332.656, 8.65701, 0, 0, 0, 0, 100, 0), +(@PATH, 26, -74.2694, -332.656, 8.65701, 0, 0, 0, 0, 100, 0); + +SET @NPC := 54394; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, 53.4076, -234.283, 68.268, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 54.4076, -234.289, 68.268, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 68.1294, -231.366, 63.9903, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 114.731, -215.095, 52.9903, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 140.067, -226.139, 52.9903, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 142.078, -249.241, 52.9903, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 127.696, -262.717, 52.9903, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 107.365, -250.37, 52.9903, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 86.7962, -205.808, 52.9903, 0, 0, 0, 0, 100, 0), +(@PATH, 10, 58.5172, -183.434, 52.9903, 0, 0, 0, 0, 100, 0), +(@PATH, 11, 31.7153, -188.835, 58.4626, 0, 0, 0, 0, 100, 0), +(@PATH, 12, 33.0427, -217.37, 58.4626, 0, 0, 0, 0, 100, 0), +(@PATH, 13, 56.2392, -223.582, 63.4903, 0, 0, 0, 0, 100, 0), +(@PATH, 14, 100.354, -204.943, 63.4903, 0, 0, 0, 0, 100, 0), +(@PATH, 15, 66.1067, -176.697, 63.4903, 0, 0, 0, 0, 100, 0), +(@PATH, 16, 33.7945, -182.078, 71.3515, 0, 0, 0, 0, 100, 0), +(@PATH, 17, 11.3902, -203.766, 71.3515, 0, 0, 0, 0, 100, 0), +(@PATH, 18, 22.1798, -234.092, 71.3515, 0, 0, 0, 0, 100, 0), +(@PATH, 19, 54.4076, -234.289, 68.268, 0, 0, 0, 0, 100, 0), +(@PATH, 20, 54.4076, -234.289, 68.268, 0, 0, 0, 0, 100, 0); + +SET @NPC := 54410; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, 44.3799, -380.227, 72.9974, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 45.1365, -379.573, 72.9974, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 107.827, -362.012, 57.3163, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 152.87, -346.165, 54.0385, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 165.888, -317.331, 54.0385, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 133.133, -307.998, 54.0385, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 101.74, -314.874, 63.3996, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 99.8516, -358.961, 61.9829, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 138.873, -379.853, 84.9974, 0, 0, 0, 0, 100, 0), +(@PATH, 10, 156.863, -364.716, 88.9419, 0, 0, 0, 0, 100, 0), +(@PATH, 11, 181.043, -332.848, 88.9419, 0, 0, 0, 0, 100, 0), +(@PATH, 12, 174.562, -305.774, 80.7197, 0, 0, 0, 0, 100, 0), +(@PATH, 13, 151.286, -281.981, 60.5252, 0, 0, 0, 0, 100, 0), +(@PATH, 14, 103.941, -273.874, 57.8863, 0, 0, 0, 0, 100, 0), +(@PATH, 15, 97.9417, -235.904, 47.9696, 0, 0, 0, 0, 100, 0), +(@PATH, 16, 122.32, -200.218, 47.9696, 0, 0, 0, 0, 100, 0), +(@PATH, 17, 143.66, -241.383, 47.9696, 0, 0, 0, 0, 100, 0), +(@PATH, 18, 146.228, -286.853, 32.2752, 0, 0, 0, 0, 100, 0), +(@PATH, 19, 165.58, -321.683, 32.2752, 0, 0, 0, 0, 100, 0), +(@PATH, 20, 184.81, -345.767, 32.2752, 0, 0, 0, 0, 100, 0), +(@PATH, 21, 197.674, -324.915, 29.4141, 0, 0, 0, 0, 100, 0), +(@PATH, 22, 180.508, -311.228, 22.8029, 0, 0, 0, 0, 100, 0), +(@PATH, 23, 158.909, -324.952, 22.8029, 0, 0, 0, 0, 100, 0), +(@PATH, 24, 149.563, -357.379, 22.8029, 0, 0, 0, 0, 100, 0), +(@PATH, 25, 141.265, -399.116, 22.8029, 0, 0, 0, 0, 100, 0), +(@PATH, 26, 108.32, -409.52, 22.8029, 0, 0, 0, 0, 100, 0), +(@PATH, 27, 111.489, -374.056, 22.8029, 0, 0, 0, 0, 100, 0), +(@PATH, 28, 138.264, -340.134, 22.8029, 0, 0, 0, 0, 100, 0), +(@PATH, 29, 133.496, -322.411, 29.6363, 0, 0, 0, 0, 100, 0), +(@PATH, 30, 135.935, -307.533, 32.303, 0, 0, 0, 0, 100, 0), +(@PATH, 31, 112.506, -303.201, 56.5252, 0, 0, 0, 0, 100, 0), +(@PATH, 32, 100.185, -326.3, 56.5252, 0, 0, 0, 0, 100, 0), +(@PATH, 33, 83.2513, -363.055, 56.5252, 0, 0, 0, 0, 100, 0), +(@PATH, 34, 67.2153, -395.466, 56.5252, 0, 0, 0, 0, 100, 0), +(@PATH, 35, 69.961, -411.287, 56.5252, 0, 0, 0, 0, 100, 0), +(@PATH, 36, 112.863, -404.805, 72.9974, 0, 0, 0, 0, 100, 0), +(@PATH, 37, 82.9177, -387.299, 72.9974, 0, 0, 0, 0, 100, 0), +(@PATH, 38, 39.0596, -399.753, 72.9974, 0, 0, 0, 0, 100, 0), +(@PATH, 39, 20.0949, -401.216, 72.9974, 0, 0, 0, 0, 100, 0), +(@PATH, 40, 45.1366, -379.573, 72.9974, 0, 0, 0, 0, 100, 0), +(@PATH, 41, 45.1366, -379.573, 72.9974, 0, 0, 0, 0, 100, 0); + + +SET @NPC := 54215; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, 96.911, -189.611, 57.5907, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 97.9108, -189.592, 57.5907, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 108.061, -198.742, 50.1184, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 100.055, -228.35, 44.8128, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 60.7907, -227.57, 44.8128, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 34.2998, -212.097, 44.8128, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 36.4155, -191.979, 44.8128, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 55.4309, -192.466, 44.8128, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 80.9624, -187.033, 44.8128, 0, 0, 0, 0, 100, 0), +(@PATH, 10, 96.5026, -206.563, 44.8128, 0, 0, 0, 0, 100, 0), +(@PATH, 11, 95.1273, -238.221, 47.3406, 0, 0, 0, 0, 100, 0), +(@PATH, 12, 123.91, -264.368, 47.3406, 0, 0, 0, 0, 100, 0), +(@PATH, 13, 148.943, -247.735, 47.3406, 0, 0, 0, 0, 100, 0), +(@PATH, 14, 130.244, -205.766, 47.3406, 0, 0, 0, 0, 100, 0), +(@PATH, 15, 99.2827, -204.807, 47.3406, 0, 0, 0, 0, 100, 0), +(@PATH, 16, 59.0211, -226.759, 47.3406, 0, 0, 0, 0, 100, 0), +(@PATH, 17, 26.4373, -212.867, 47.3406, 0, 0, 0, 0, 100, 0), +(@PATH, 18, 30.3025, -191.835, 47.3406, 0, 0, 0, 0, 100, 0), +(@PATH, 19, 62.2487, -190.255, 57.5907, 0, 0, 0, 0, 100, 0), +(@PATH, 20, 97.9108, -189.592, 57.5907, 0, 0, 0, 0, 100, 0), +(@PATH, 21, 97.9108, -189.592, 57.5907, 0, 0, 0, 0, 100, 0); + +SET @NPC := 54214; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, -75.8109, -114.988, 68.5672, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -76.807, -115.076, 68.5672, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -45.3322, -107.14, 52.1645, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -20.5121, -95.2334, 51.0931, 0, 0, 0, 0, 100, 0), +(@PATH, 5, -25.8699, -76.0942, 50.4264, 0, 0, 0, 0, 100, 0), +(@PATH, 6, -43.695, -41.8846, 52.7598, 0, 0, 0, 0, 100, 0), +(@PATH, 7, -59.0242, -52.8621, 38.982, 0, 0, 0, 0, 100, 0), +(@PATH, 8, -64.5703, -79.9865, 40.2875, 0, 0, 0, 0, 100, 0), +(@PATH, 9, -37.5214, -90.8207, 39.5653, 0, 0, 0, 0, 100, 0), +(@PATH, 10, -57.5956, -107.234, 54.6487, 0, 0, 0, 0, 100, 0), +(@PATH, 11, -37.6212, -128.131, 57.4264, 0, 0, 0, 0, 100, 0), +(@PATH, 12, -15.7986, -140.483, 46.3987, 0, 0, 0, 0, 100, 0), +(@PATH, 13, -4.58555, -145.596, 46.27, 0, 0, 0, 0, 100, 0), +(@PATH, 14, -9.12464, -176.698, 50.6589, 0, 0, 0, 0, 100, 0), +(@PATH, 15, -39.5875, -182.261, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 16, -46.3938, -155.372, 53.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 17, -22.2005, -113.485, 51.1866, 0, 0, 0, 0, 100, 0), +(@PATH, 18, -15.7128, -67.5216, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 19, -37.9554, -31.7953, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 20, -58.6084, -46.5266, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 21, -76.6704, -80.3909, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 22, -69.5675, -106.508, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 23, -24.1649, -102.904, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 24, 23.3523, -93.9222, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 25, 29.3695, -121.539, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 26, -16.4984, -126.523, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 27, -58.092, -130.192, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 28, -70.2595, -145.455, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 29, -62.4515, -157.462, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 30, -36.5855, -135.96, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 31, -24.8665, -124.549, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 32, -45.3821, -118.63, 47.1589, 0, 0, 0, 0, 100, 0), +(@PATH, 33, -51.9431, -112.88, 51.1034, 0, 0, 0, 0, 100, 0), +(@PATH, 34, -51.9431, -112.88, 51.1034, 0, 0, 0, 0, 100, 0); + +SET @NPC := 54392; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, 134.615, -283.078, 65.7715, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 134.07, -283.916, 65.7715, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 102.534, -283.142, 60.0492, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 93.3766, -247.073, 60.0492, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 100.192, -223.769, 60.0492, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 121.082, -203.347, 54.2437, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 143.84, -211.642, 61.8826, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 148.723, -258.201, 60.0492, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 118.94, -275.295, 60.0492, 0, 0, 0, 0, 100, 0), +(@PATH, 10, 89.1275, -263.733, 60.0492, 0, 0, 0, 0, 100, 0), +(@PATH, 11, 95.0911, -219.002, 68.7437, 0, 0, 0, 0, 100, 0), +(@PATH, 12, 107.905, -197, 67.5215, 0, 0, 0, 0, 100, 0), +(@PATH, 13, 97.5486, -189.33, 61.5214, 0, 0, 0, 0, 100, 0), +(@PATH, 14, 67.0509, -183.163, 63.6603, 0, 0, 0, 0, 100, 0), +(@PATH, 15, 53.4086, -196.791, 46.9104, 0, 0, 0, 0, 100, 0), +(@PATH, 16, 65.691, -231.174, 55.1326, 0, 0, 0, 0, 100, 0), +(@PATH, 17, 97.3061, -269.739, 60.9937, 0, 0, 0, 0, 100, 0), +(@PATH, 18, 130.483, -291.47, 59.2715, 0, 0, 0, 0, 100, 0), +(@PATH, 19, 162.477, -267.022, 54.4381, 0, 0, 0, 0, 100, 0), +(@PATH, 20, 188.081, -234.175, 60.9937, 0, 0, 0, 0, 100, 0), +(@PATH, 21, 203.084, -190.293, 60.9937, 0, 0, 0, 0, 100, 0), +(@PATH, 22, 191.972, -176.278, 66.2159, 0, 0, 0, 0, 100, 0), +(@PATH, 23, 179.026, -145.182, 58.2714, 0, 0, 0, 0, 100, 0), +(@PATH, 24, 147.887, -172.183, 60.9937, 0, 0, 0, 0, 100, 0), +(@PATH, 25, 117.321, -194.103, 63.7159, 0, 0, 0, 0, 100, 0), +(@PATH, 26, 91.9793, -216.792, 63.7159, 0, 0, 0, 0, 100, 0), +(@PATH, 27, 51.4137, -238.564, 63.7159, 0, 0, 0, 0, 100, 0), +(@PATH, 28, 25.9058, -224.837, 63.7159, 0, 0, 0, 0, 100, 0), +(@PATH, 29, 35.4956, -191.903, 59.6326, 0, 0, 0, 0, 100, 0), +(@PATH, 30, 69.7864, -186.756, 59.6326, 0, 0, 0, 0, 100, 0), +(@PATH, 31, 117.992, -193.823, 59.6326, 0, 0, 0, 0, 100, 0), +(@PATH, 32, 151.685, -222.148, 59.6326, 0, 0, 0, 0, 100, 0), +(@PATH, 33, 149.061, -260.87, 59.6326, 0, 0, 0, 0, 100, 0), +(@PATH, 34, 134.07, -283.916, 65.7715, 0, 0, 0, 0, 100, 0), +(@PATH, 35, 134.07, -283.916, 65.7715, 0, 0, 0, 0, 100, 0); + +SET @NPC := 103639; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, 24.9916, -372.869, 69.4133, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -7.39693, -326.532, 60.3266, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -23.0091, -313.942, 59.6321, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -31.2532, -269.306, 47.7744, 0, 0, 0, 0, 100, 0), +(@PATH, 5, -10.6348, -247.241, 46.1077, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 4.61475, -252.064, 51.4411, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 19.5989, -265.072, 54.3855, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 43.779, -287.224, 57.0522, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 86.0451, -291.15, 69.4133, 0, 0, 0, 0, 100, 0), +(@PATH, 10, 91.2144, -338.525, 69.4133, 0, 0, 0, 0, 100, 0), +(@PATH, 11, 72.4278, -374.753, 69.4133, 0, 0, 0, 0, 100, 0), +(@PATH, 12, 24.9916, -372.869, 69.4133, 0, 0, 0, 0, 100, 0), +(@PATH, 13, -7.39693, -326.532, 60.3266, 0, 0, 0, 0, 100, 0), +(@PATH, 14, -23.0091, -313.942, 59.6321, 0, 0, 0, 0, 100, 0); + +SET @NPC := 103640; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, 54.5179, -230.67, 14.3503, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 54.453, -231.668, 14.3503, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 42.9604, -290.664, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 67.7574, -300.491, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 92.0997, -315.506, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 104.024, -341.875, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 83.7507, -366.586, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 50.5451, -381.238, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 82.1083, -411.11, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 10, 109.532, -372.485, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 11, 132.299, -346.04, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 12, 150.612, -333.086, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 13, 171.819, -345.58, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 14, 199.425, -334.026, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 15, 192.086, -306.531, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 16, 169.341, -310.263, 12.2948, 0, 0, 0, 0, 100, 0), +(@PATH, 17, 161.003, -326.56, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 18, 151.135, -329.132, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 19, 135.216, -369.767, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 20, 108.374, -348.457, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 21, 113.349, -329.858, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 22, 125.524, -322.706, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 23, 136.607, -328.518, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 24, 134.744, -352.997, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 25, 102.712, -329.513, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 26, 80.1246, -312.516, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 27, 52.3241, -287.949, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 28, 56.9767, -281.741, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 29, 63.3066, -253.373, 19.017, 0, 0, 0, 0, 100, 0), +(@PATH, 30, 84.6819, -246.277, 13.1281, 0, 0, 0, 0, 100, 0), +(@PATH, 31, 105.854, -249.207, 13.1281, 0, 0, 0, 0, 100, 0), +(@PATH, 32, 114.097, -215.575, 13.1281, 0, 0, 0, 0, 100, 0), +(@PATH, 33, 97.6293, -180.025, 13.1281, 0, 0, 0, 0, 100, 0), +(@PATH, 34, 63.1234, -173.664, 13.1281, 0, 0, 0, 0, 100, 0), +(@PATH, 35, 56.3654, -202.276, 13.1281, 0, 0, 0, 0, 100, 0), +(@PATH, 36, 54.453, -231.668, 14.3503, 0, 0, 0, 0, 100, 0), +(@PATH, 37, 54.453, -231.668, 14.3503, 0, 0, 0, 0, 100, 0); + +-- Pathing for Wrathfin Myrmidon Entry: 17726 'TDB FORMAT' +SET @NPC := 101335; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=141.5793,`position_y`=-416.6288,`position_z`=48.60109 WHERE `guid`=@NPC; +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,141.5793,-416.6288,48.60109,0,0,0,0,100,0), +(@PATH,2,115.9606,-404.2694,42.52244,0,0,0,0,100,0), +(@PATH,3,99.41526,-396.6491,36.55694,0,0,0,0,100,0), +(@PATH,4,90.52101,-391.7673,34.238,0,0,0,0,100,0), +(@PATH,5,99.41526,-396.6491,36.55694,0,0,0,0,100,0), +(@PATH,6,115.9606,-404.2694,42.52244,0,0,0,0,100,0); +-- 0xF130453E0000490C .go xyz 141.5793 -416.6288 48.60109 + +-- Pathing for Wrathfin Myrmidon Entry: 17726 'TDB FORMAT' +SET @NPC := 101626; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=161.0618,`position_y`=-432.5178,`position_z`=48.08834 WHERE `guid`=@NPC; +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,161.0618,-432.5178,48.08834,0,0,0,0,100,0), +(@PATH,2,165.5912,-417.708,48.10725,0,0,0,0,100,0), +(@PATH,3,188.9406,-391.5165,48.1333,0,0,0,0,100,0), +(@PATH,4,202.6417,-380.7892,48.12334,0,0,0,0,100,0), +(@PATH,5,188.9406,-391.5165,48.1333,0,0,0,0,100,0), +(@PATH,6,165.5912,-417.708,48.10725,0,0,0,0,100,0); +-- 0xF130453E000048D6 .go xyz 161.0618 -432.5178 48.08834 + +-- Pathing for Wrathfin Warrior Entry: 17735 'TDB FORMAT' +SET @NPC := 101757; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=204.4147,`position_y`=-378.89,`position_z`=48.11809 WHERE `guid`=@NPC; +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,204.4147,-378.89,48.11809,0,5000,0,0,100,0), +(@PATH,2,214.0971,-380.0021,48.14805,0,0,0,0,100,0), +(@PATH,3,227.2372,-378.5456,48.18998,0,0,0,0,100,0), +(@PATH,4,237.1281,-373.9269,48.17849,0,5000,0,0,100,0), +(@PATH,5,227.2372,-378.5456,48.18998,0,0,0,0,100,0), +(@PATH,6,214.0971,-380.0021,48.14805,0,0,0,0,100,0); +-- 0xF1304547000048CF .go xyz 204.4147 -378.89 48.11809 + +-- Pathing for Wrathfin Myrmidon Entry: 17726 'TDB FORMAT' +SET @NPC := 101772; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=188.4798,`position_y`=-404.165,`position_z`=72.50478 WHERE `guid`=@NPC; +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,188.4798,-404.165,72.50478,0,0,0,0,100,0), +(@PATH,2,171.5415,-424.232,72.47367,0,0,0,0,100,0), +(@PATH,3,164.6792,-452.268,72.48774,0,0,0,0,100,0), +(@PATH,4,171.5415,-424.232,72.47367,0,0,0,0,100,0); +-- 0xF130453E00004958 .go xyz 188.4798 -404.165 72.50478 + +-- Pathing for Wrathfin Warrior Entry: 17735 'TDB FORMAT' +SET @NPC := 102409; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=250.059,`position_y`=-367.1678,`position_z`=72.1729 WHERE `guid`=@NPC; +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,250.059,-367.1678,72.1729,0,0,0,0,100,0), +(@PATH,2,256.6105,-374.5453,72.26968,0,0,0,0,100,0), +(@PATH,3,264.9766,-377.1216,72.15923,0,0,0,0,100,0), +(@PATH,4,272.0811,-381.0451,72.14804,0,0,0,0,100,0), +(@PATH,5,264.9766,-377.1216,72.15923,0,0,0,0,100,0), +(@PATH,6,256.6105,-374.5453,72.26968,0,0,0,0,100,0); +-- 0xF1304547000048CE .go xyz 250.059 -367.1678 72.1729 + +SET @NPC := 101722; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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, 276.924, -457.942, 42.05630, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 271.351, -442.822, 42.05630, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 257.913, -423.944, 42.05630, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 241.084, -420.804, 42.05630, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 215.919, -428.708, 42.05630, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 201.520, -444.047, 42.05630, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 216.208, -451.139, 42.05630, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 233.904, -460.240, 42.05630, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 228.164, -474.326, 45.56947, 0, 0, 0, 0, 100, 0), +(@PATH, 10, 211.227, -480.183, 54.09188, 0, 0, 0, 0, 100, 0), +(@PATH, 11, 185.112, -486.135, 64.50655, 0, 0, 0, 0, 100, 0), +(@PATH, 12, 164.371, -476.988, 73.69150, 0, 0, 0, 0, 100, 0), +(@PATH, 13, 165.565, -464.516, 74.90005, 0, 0, 0, 0, 100, 0), +(@PATH, 14, 190.789, -470.005, 77.66721, 0, 0, 0, 0, 100, 0), +(@PATH, 15, 211.936, -474.744, 80.54121, 0, 0, 0, 0, 100, 0), +(@PATH, 16, 226.105, -472.916, 81.36376, 0, 0, 0, 0, 100, 0), +(@PATH, 17, 251.232, -461.927, 81.37197, 3.522506, 20000, 0, 0, 100, 0), +(@PATH, 18, 226.105, -472.916, 81.36376, 0, 0, 0, 0, 100, 0), +(@PATH, 19, 211.936, -474.744, 80.54121, 0, 0, 0, 0, 100, 0), +(@PATH, 20, 190.789, -470.005, 77.66721, 0, 0, 0, 0, 100, 0), +(@PATH, 21, 165.565, -464.516, 74.90005, 0, 0, 0, 0, 100, 0), +(@PATH, 22, 164.371, -476.988, 73.69150, 0, 0, 0, 0, 100, 0), +(@PATH, 23, 185.112, -486.135, 64.50655, 0, 0, 0, 0, 100, 0), +(@PATH, 24, 211.227, -480.183, 54.09188, 0, 0, 0, 0, 100, 0), +(@PATH, 25, 228.164, -474.326, 45.56947, 0, 0, 0, 0, 100, 0), +(@PATH, 26, 233.904, -460.240, 42.56947, 0, 0, 0, 0, 100, 0), +(@PATH, 27, 216.208, -451.139, 42.56947, 0, 0, 0, 0, 100, 0), +(@PATH, 28, 201.520, -444.047, 42.56947, 0, 0, 0, 0, 100, 0), +(@PATH, 29, 215.919, -428.708, 42.56947, 0, 0, 0, 0, 100, 0), +(@PATH, 30, 241.084, -420.804, 42.56947, 0, 0, 0, 0, 100, 0), +(@PATH, 31, 257.913, -423.944, 42.56947, 0, 0, 0, 0, 100, 0), +(@PATH, 32, 271.351, -442.822, 42.56947, 0, 0, 0, 0, 100, 0), +(@PATH, 33, 276.924, -457.942, 42.56947, 0, 0, 0, 0, 100, 0); + +-- Pathing for Fen Ray Entry: 17731 'TDB FORMAT' +SET @NPC := 102881; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=342.6261,`position_y`=-356.8263,`position_z`=32.39003 WHERE `guid`=@NPC; +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,342.6261,-356.8263,32.39003,0,1,0,0,100,0), +(@PATH,2,337.6255,-357.8204,33.04043,0,1,0,0,100,0), +(@PATH,3,326.7678,-341.2754,26.27718,0,1,0,0,100,0), +(@PATH,4,303.3087,-323.571,20.69065,0,1,0,0,100,0), +(@PATH,5,300.4555,-314.2503,19.71717,0,1,0,0,100,0), +(@PATH,6,310.3461,-320.6632,19.90794,0,1,0,0,100,0), +(@PATH,7,326.8262,-332.5211,22.32234,0,1,0,0,100,0), +(@PATH,8,340.7248,-345.9094,28.6518,0,1,0,0,100,0); +-- 0xF130454300004922 .go xyz 342.6261 -356.8263 32.39003 + +-- Pathing for Lykul Wasp Entry: 17732 'TDB FORMAT' +SET @NPC := 103323; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=266.3294,`position_y`=-220.2783,`position_z`=28.77758 WHERE `guid`=@NPC; +UPDATE `creature` SET `position_x`=266.3294,`position_y`=-220.2783,`position_z`=28.77758 WHERE `guid`=102649; +UPDATE `creature` SET `position_x`=266.3294,`position_y`=-220.2783,`position_z`=28.77758 WHERE `guid`=102650; +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,266.3294,-220.2783,28.77758,0,0,0,0,100,0), +(@PATH,2,269.6321,-240.9324,27.48778,0,0,0,0,100,0), +(@PATH,3,265.9687,-271.0043,24.54027,0,0,0,0,100,0), +(@PATH,4,276.8408,-289.8254,21.84543,0,0,0,0,100,0), +(@PATH,5,303.279,-310.3096,18.87312,0,0,0,0,100,0), +(@PATH,6,276.8408,-289.8254,21.84543,0,0,0,0,100,0), +(@PATH,7,265.9687,-271.0043,24.54027,0,0,0,0,100,0), +(@PATH,8,269.6321,-240.9324,27.48778,0,0,0,0,100,0); +-- 0xF130454400004919 .go xyz 266.3294 -220.2783 28.77758 + +-- Pathing for Lykul Stinger Entry: 19632 'TDB FORMAT' +SET @NPC := 103395; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=262.6488,`position_y`=-209.1258,`position_z`=28.48095 WHERE `guid`=@NPC; +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,262.6488,-209.1258,28.48095,0,0,0,0,100,0), +(@PATH,2,263.5199,-218.522,28.58328,0,0,0,0,100,0), +(@PATH,3,264.4472,-228.5507,27.84685,0,0,0,0,100,0), +(@PATH,4,264.6787,-231.051,27.64712,0,0,0,0,100,0), +(@PATH,5,264.6787,-231.051,27.64712,0,0,0,0,100,0), +(@PATH,6,263.4647,-217.9383,28.56117,0,0,0,0,100,0), +(@PATH,7,262.5647,-208.2181,28.47557,0,0,0,0,100,0), +(@PATH,8,261.6653,-198.5033,28.4243,0,0,0,0,100,0), +(@PATH,9,258.9749,-190.4312,28.43222,0,0,0,0,100,0), +(@PATH,10,255.2904,-181.4047,28.47332,0,0,0,0,100,0), +(@PATH,11,251.6037,-172.3728,28.3456,0,0,0,0,100,0), +(@PATH,12,247.9473,-163.4149,28.1487,0,0,0,0,100,0), +(@PATH,13,247.9473,-163.4149,28.1487,0,0,0,0,100,0), +(@PATH,14,247.9476,-163.4158,28.14872,0,0,0,0,100,0), +(@PATH,15,252.9346,-175.6332,28.35347,0,0,0,0,100,0), +(@PATH,16,256.6252,-184.6748,28.50601,0,0,0,0,100,0), +(@PATH,17,260.3071,-193.6951,28.43218,0,0,0,0,100,0); +-- 0xF1304CB000004917 .go xyz 262.6488 -209.1258 28.48095 + +-- Pathing for Underbog Lord Entry: 17734 'TDB FORMAT' +SET @NPC := 54396; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=153.0262,`position_y`=-93.89476,`position_z`=26.35261 WHERE `guid`=@NPC; +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,153.0262,-93.89476,26.35261,0,0,0,0,100,0), +(@PATH,2,161.1251,-70.36053,27.06263,0,0,0,0,100,0), +(@PATH,3,176.592,-61.29988,26.51584,0,0,0,0,100,0), +(@PATH,4,161.1251,-70.36053,27.06263,0,0,0,0,100,0); +-- 0xF13045460000491E .go xyz 153.0262 -93.89476 26.35261 + +-- Pathing for Swamplord Musel'ek Entry: 17826 'TDB FORMAT' +SET @NPC := 103246; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=274.0677,`position_y`=-122.0538,`position_z`=29.80962 WHERE `guid`=@NPC; +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,274.0677,-122.0538,29.80962,0,0,0,0,100,0), +(@PATH,2,281.5271,-120.3684,29.75141,0,0,0,0,100,0), +(@PATH,3,288.5823,-121.8309,29.70329,0,0,0,0,100,0), +(@PATH,4,281.5271,-120.3684,29.75141,0,0,0,0,100,0); +-- 0xF13045A20000492C .go xyz 274.0677 -122.0538 29.80962 + +-- Pathing for The Black Stalker Entry: 17882 'TDB FORMAT' +SET @NPC := 54337; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=143.1293,`position_y`=24.53014,`position_z`=26.79155 WHERE `guid`=@NPC; +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,143.1293, 24.53014, 26.79155,0,0,0,0,100,0), +(@PATH,2,141.6592, 32.41973, 26.83109,0,15000,0,5753900,100,0), -- +(@PATH,3,163.5016, 11.74524, 26.72663,0,0,0,0,100,0), +(@PATH,4,168.9888, 8.392987, 26.64813,0,15000,0,5753900,100,0), -- +(@PATH,5,147.6577, 5.377345, 26.79155,0,0,0,0,100,0), +(@PATH,6,137.5493, 3.156878, 26.79155,0,15000,0,5753900,100,0), -- +(@PATH,7,147.9013, 15.37733, 26.79647,0,0,0,0,100,0), +(@PATH,8,151.3846, 20.67051, 26.85765,0,0,0,0,100,0); +-- 0xF13045DA0000493E .go xyz 143.1293 24.53014 26.79155 + +SET @NPC := 103432; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2 WHERE `guid`=@NPC; +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,109.82523, -204.67242, 32.28563,0,0,0,0,100,0), +(@PATH,2,134.99781, -186.47384, 32.28563,0,0,0,0,100,0), +(@PATH,3,158.52999, -167.41900, 32.28270,0,0,0,0,100,0), +(@PATH,4,163.56314, -132.83432, 27.79438,0,0,0,0,100,0), +(@PATH,5,158.52999, -167.41900, 32.28270,0,0,0,0,100,0), +(@PATH,6,134.99781, -186.47384, 32.28563,0,0,0,0,100,0), +(@PATH,7,109.82523, -204.67242, 32.28563,0,0,0,0,100,0); |