DB/Creature: Add some waypoints to the Barrens

1 files changed, 341 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2018_10_24_00_world_335.sql b/sql/updates/world/3.3.5/2018_10_24_00_world_335.sql
new file mode 100644
index 00000000000..18666646b16
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_24_00_world_335.sql
@@ -0,0 +1,341 @@
+-- 
+UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 15139;
+DELETE FROM `creature_addon` WHERE `guid` = 15139;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(15139,151390,0,0,0,0,"");
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 15139;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(15139,15139,0,0,515,0,0),
+(15139,15137,15,0,515,0,0),
+(15139,15138,12,45,515,0,0),
+(15139,15140,9,315,515,0,0);
+DELETE FROM `waypoint_data` WHERE `id`=151390;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(151390,1,-2998.13,-2012.47,91.7341,0,0,0,0,100,0),
+(151390,2,-3048.21,-1999.61,91.8675,0,0,0,0,100,0),
+(151390,3,-3106.65,-2003.4,98.1789,0,0,0,0,100,0),
+(151390,4,-3143.73,-2004.96,91.6704,0,0,0,0,100,0),
+(151390,5,-3267.98,-2026.34,92.5754,0,0,0,0,100,0),
+(151390,6,-3583.22,-1921.61,94.3068,0,13000,0,0,100,0),
+(151390,7,-3645.08,-1956.1,91.9535,0,0,0,0,100,0),
+(151390,8,-3702.84,-2056.81,93.3177,0,0,0,0,100,0),
+(151390,9,-3724.26,-2202.7,91.7286,0,0,0,0,100,0),
+(151390,10,-3696.85,-2312.4,92.1689,0,0,0,0,100,0),
+(151390,11,-3667.83,-2352.59,91.6668,0,0,0,0,100,0),
+(151390,12,-3657.77,-2356.66,91.6667,0,0,0,0,100,0),
+(151390,13,-3648.58,-2356.08,91.757,0,0,0,0,100,0),
+(151390,14,-3639.44,-2353.15,92.3895,0,0,0,0,100,0),
+(151390,15,-3630.63,-2346.35,92.1355,0,0,0,0,100,0),
+(151390,16,-3597.42,-2300.35,92.6799,0,0,0,0,100,0),
+(151390,17,-3563.12,-2268.77,91.7997,0,0,0,0,100,0),
+(151390,18,-3520.45,-2253.33,92.7574,0,0,0,0,100,0),
+(151390,19,-3488.97,-2234.86,93.676,0,0,0,0,100,0),
+(151390,20,-3387.12,-2196.93,95.1846,0,0,0,0,100,0),
+(151390,21,-3292.87,-2185.51,92.5575,0,14000,0,0,100,0),
+(151390,22,-3206.89,-2075.94,94.7149,0,0,0,0,100,0),
+(151390,23,-3154.15,-2065.12,92.807,0,11000,0,0,100,0),
+(151390,24,-3144.05,-2075.1,91.9836,0,0,0,0,100,0),
+(151390,25,-3125.87,-2101.69,91.6774,0,0,0,0,100,0),
+(151390,26,-3105.69,-2123.68,91.8374,0,0,0,0,100,0),
+(151390,27,-3082.92,-2132.46,91.7132,0,0,0,0,100,0),
+(151390,28,-2983.82,-2114.47,93.6036,0,0,0,0,100,0),
+(151390,29,-2974.75,-2087.39,91.6668,0,0,0,0,100,0),
+(151390,30,-2958.35,-2057.43,96.6284,0,0,0,0,100,0),
+(151390,31,-2973.28,-2017.21,94.3499,0,0,0,0,100,0);
+
+UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 14053;
+DELETE FROM `creature_addon` WHERE `guid` = 14053;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(14053,140530,0,0,0,0,"");
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 14053;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(14053,14053,0,0,515,0,0),
+(14053,14051,5,80,515,0,0),
+(14053,14052,5,40,515,0,0),
+(14053,14050,5,10,515,0,0),
+(14053,14054,5,330,515,0,0),
+(14053,14049,5,290,515,0,0);
+
+DELETE FROM `waypoint_data` WHERE `id`=140530;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(140530, 1, -2572.2, -1858.7, 91.6668, 0, 0, 1, 0, 100, 0),
+(140530, 2, -2528.4, -1825, 94.4881, 0, 0, 1, 0, 100, 0),
+(140530, 3, -2511, -1784.7, 91.668, 0, 0, 1, 0, 100, 0),
+(140530, 4, -2489.6, -1743.3, 91.6669, 0, 0, 1, 0, 100, 0),
+(140530, 5, -2432.9, -1693.4, 95.125, 0, 0, 1, 0, 100, 0),
+(140530, 6, -2415.6, -1738.7, 91.7289, 0, 0, 1, 0, 100, 0),
+(140530, 7, -2480.3, -1739.1, 91.6669, 0, 0, 1, 0, 100, 0),
+(140530, 8, -2512, -1788.7, 91.668, 0, 0, 1, 0, 100, 0),
+(140530, 9, -2523.4, -1825, 94.4881, 0, 0, 1, 0, 100, 0),
+(140530, 10, -2574.2, -1856.7, 91.6668, 0, 0, 1, 0, 100, 0),
+(140530, 11, -2618.6, -1888.6, 94.3189, 0, 0, 1, 0, 100, 0),
+(140530, 12, -2615.4, -1912.8, 97.1135, 0, 0, 1, 0, 100, 0),
+(140530, 13, -2600.1, -1972.3, 91.6669, 0, 0, 1, 0, 100, 0),
+(140530, 14, -2586.3, -2056.7, 91.6676, 0, 0, 1, 0, 100, 0),
+(140530, 15, -2527.6, -2033.1, 93.9145, 0, 0, 1, 0, 100, 0),
+(140530, 16, -2590.9, -1940.2, 93.2829, 0, 0, 1, 0, 100, 0);
+
+UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 14042;
+DELETE FROM `creature_addon` WHERE `guid` = 14042;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(14042,140420,0,0,0,0,"");
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 14042;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(14042,14042,0,0,515,0,0),
+(14042,14046,5,40,515,0,0),
+(14042,14044,5,10,515,0,0),
+(14042,14043,5,350,515,0,0),
+(14042,14045,5,330,515,0,0),
+(14042,14047,5,290,515,0,0);
+
+DELETE FROM `waypoint_data` WHERE `id`=140420;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(140420, 1, -502.767, -1996.189, 94.44725, 0, 1, 0, 100, 0),
+(140420, 2, -511.424, -1989.231, 95.27134, 0, 1, 0, 100, 0),
+(140420, 3, -528.634, -1975.728, 94.07756, 0, 1, 0, 100, 0),
+(140420, 4, -539.648, -1967.086, 92.32050, 0, 1, 0, 100, 0),
+(140420, 5, -547.909, -1960.605, 92.39439, 0, 1, 0, 100, 0),
+(140420, 6, -561.676, -1949.802, 92.49491, 0, 1, 0, 100, 0),
+(140420, 7, -569.937, -1943.321, 92.17023, 0, 1, 0, 100, 0),
+(140420, 8, -587.945, -1932.093, 91.68965, 0, 1, 0, 100, 0),
+(140420, 9, -603.882, -1928.420, 91.66679, 0, 1, 0, 100, 0),
+(140420, 10, -617.756, -1926.557, 92.23322, 0, 1, 0, 100, 0),
+(140420, 11, -652.347, -1921.224, 92.50893, 0, 1, 0, 100, 0),
+(140420, 12, -666.196, -1919.174, 91.92680, 0, 1, 0, 100, 0),
+(140420, 13, -683.527, -1916.777, 93.40912, 0, 1, 0, 100, 0),
+(140420, 14, -696.034, -1915.292, 94.24060, 0, 1, 0, 100, 0),
+(140420, 15, -733.366, -1908.724, 92.87856, 0, 1, 0, 100, 0),
+(140420, 16, -746.061, -1897.383, 92.42220, 0, 1, 0, 100, 0),
+(140420, 17, -755.969, -1877.506, 92.89954, 0, 1, 0, 100, 0),
+(140420, 18, -763.770, -1847.891, 93.26424, 0, 1, 0, 100, 0),
+(140420, 19, -759.489, -1816.846, 91.66767, 0, 1, 0, 100, 0),
+(140420, 20, -745.421, -1800.135, 91.71883, 0, 1, 0, 100, 0),
+(140420, 21, -733.586, -1782.795, 93.31093, 0, 1, 0, 100, 0),
+(140420, 22, -724.476, -1767.853, 94.47924, 0, 1, 0, 100, 0),
+(140420, 23, -707.237, -1737.426, 94.26205, 0, 1, 0, 100, 0),
+(140420, 24, -697.453, -1718.844, 92.69762, 0, 1, 0, 100, 0),
+(140420, 25, -683.673, -1701.884, 91.69395, 0, 1, 0, 100, 0),
+(140420, 26, -671.583, -1690.926, 91.66750, 0, 1, 0, 100, 0),
+(140420, 27, -645.035, -1685.318, 94.03638, 0, 1, 0, 100, 0),
+(140420, 28, -630.107, -1700.087, 92.02236, 0, 1, 0, 100, 0),
+(140420, 29, -608.652, -1723.144, 91.66776, 0, 1, 0, 100, 0),
+(140420, 30, -589.438, -1737.038, 94.52512, 0, 1, 0, 100, 0),
+(140420, 31, -564.186, -1764.753, 93.43532, 0, 1, 0, 100, 0),
+(140420, 32, -552.207, -1782.001, 91.77047, 0, 1, 0, 100, 0),
+(140420, 33, -543.763, -1811.364, 91.66690, 0, 1, 0, 100, 0),
+(140420, 34, -542.709, -1839.344, 91.66690, 0, 1, 0, 100, 0),
+(140420, 35, -536.508, -1865.362, 92.32794, 0, 1, 0, 100, 0),
+(140420, 36, -519.996, -1883.936, 92.16505, 0, 1, 0, 100, 0),
+(140420, 37, -506.060, -1894.521, 93.30782, 0, 1, 0, 100, 0),
+(140420, 38, -493.615, -1914.417, 93.22157, 0, 1, 0, 100, 0),
+(140420, 39, -493.332, -1942.682, 92.88795, 0, 1, 0, 100, 0),
+(140420, 40, -502.587, -1996.840, 94.38247, 0, 1, 0, 100, 0);
+ 
+UPDATE `creature` SET `MovementType` = 0, `spawndist`=0 WHERE `guid` IN (14036,14034,14035,14040,14039,14038,14041,14037); 
+UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 14036;
+DELETE FROM `creature_addon` WHERE `guid` = 14036;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(14036,140360,0,0,0,0,"");
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 14036;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(14036,14036,0,0,515,0,0),
+(14036,14034,5,80,515,0,0),
+(14036,14035,5,60,515,0,0),
+(14036,14040,5,40,515,0,0),
+(14036,14039,5,10,515,0,0),
+(14036,14038,5,350,515,0,0),
+(14036,14041,5,330,515,0,0),
+(14036,14037,5,310,515,0,0);
+
+DELETE FROM `waypoint_data` WHERE `id`=140360;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(140360, 1,  -1298.006, -2130.584, 91.70348, 0, 1, 0, 100, 0),
+(140360, 2,  -1299.714, -2109.654, 91.66797, 0, 1, 0, 100, 0),
+(140360, 3,  -1295.146, -2086.457, 91.85918, 0, 1, 0, 100, 0),
+(140360, 4,  -1283.999, -2060.772, 93.42333, 0, 1, 0, 100, 0),
+(140360, 5,  -1270.371, -2040.697, 93.14427, 0, 1, 0, 100, 0),
+(140360, 6,  -1245.500, -2016.072, 91.75644, 0, 1, 0, 100, 0),
+(140360, 7,  -1220.628, -1991.447, 91.62344, 0, 1, 0, 100, 0),
+(140360, 8,  -1208.947, -1973.621, 87.89656, 0, 1, 0, 100, 0),
+(140360, 9,  -1199.538, -1947.249, 87.94191, 0, 1, 0, 100, 0),
+(140360, 10, -1191.305, -1924.174, 92.49355, 0, 1, 0, 100, 0),
+(140360, 11, -1183.073, -1901.103, 93.03506, 0, 1, 0, 100, 0),
+(140360, 12, -1176.515, -1869.682, 94.73897, 0, 1, 0, 100, 0),
+(140360, 13, -1174.866, -1834.442, 91.97592, 0, 1, 0, 100, 0),
+(140360, 14, -1195.939, -1811.724, 85.80951, 0, 1, 0, 100, 0),
+(140360, 15, -1228.502, -1796.834, 89.13758, 0, 1, 0, 100, 0),
+(140360, 16, -1261.796, -1806.579, 92.69485, 0, 1, 0, 100, 0),
+(140360, 17, -1289.474, -1828.001, 91.69701, 0, 1, 0, 100, 0),
+(140360, 18, -1307.336, -1848.330, 89.26779, 0, 1, 0, 100, 0),
+(140360, 19, -1328.536, -1875.039, 93.06597, 0, 1, 0, 100, 0),
+(140360, 20, -1356.421, -1901.584, 93.28018, 0, 1, 0, 100, 0),
+(140360, 21, -1384.307, -1928.129, 91.62613, 0, 1, 0, 100, 0),
+(140360, 22, -1407.122, -1949.848, 93.23295, 0, 1, 0, 100, 0),
+(140360, 23, -1417.564, -1980.139, 86.20026, 0, 1, 0, 100, 0),
+(140360, 24, -1405.438, -2021.452, 83.46129, 0, 1, 0, 100, 0),
+(140360, 25, -1398.833, -2059.160, 91.91397, 0, 1, 0, 100, 0),
+(140360, 26, -1377.240, -2092.095, 92.58451, 0, 1, 0, 100, 0),
+(140360, 27, -1363.521, -2131.792, 91.14503, 0, 1, 0, 100, 0),
+(140360, 28, -1346.766, -2168.259, 92.27582, 0, 1, 0, 100, 0),
+(140360, 29, -1325.719, -2184.752, 94.49661, 0, 1, 0, 100, 0);
+
+UPDATE `creature` SET `MovementType` = 0, `spawndist`=0 WHERE `guid` IN (14016); 
+UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 14010;
+DELETE FROM `creature_addon` WHERE `guid` = 14010;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(14010,140100,0,0,0,0,"");
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 14010;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(14010,14010,0,0,515,0,0),
+(14010,14013,5,80,515,0,0),
+(14010,14016,5,60,515,0,0),
+(14010,14014,5,40,515,0,0),
+(14010,14015,5,10,515,0,0),
+(14010,14011,5,350,515,0,0),
+(14010,14017,5,330,515,0,0),
+(14010,14012,5,290,515,0,0);
+
+DELETE FROM `waypoint_data` WHERE `id`=140100;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(140100, 1,  -1550.393, -1883.967, 96.60339, 0, 1, 0, 100, 0),
+(140100, 2,  -1517.215, -1872.821, 95.22880, 0, 1, 0, 100, 0),
+(140100, 3,  -1443.222, -1847.962, 95.32825, 0, 1, 0, 100, 0),
+(140100, 4,  -1382.688, -1831.138, 91.67405, 0, 1, 0, 100, 0),
+(140100, 5,  -1339.054, -1844.217, 91.72110, 0, 1, 0, 100, 0),
+(140100, 6,  -1332.940, -1886.737, 93.23933, 0, 1, 0, 100, 0),
+(140100, 7,  -1350.140, -1936.300, 81.32111, 0, 1, 0, 100, 0),
+(140100, 8,  -1361.773, -1976.657, 81.85201, 0, 1, 0, 100, 0),
+(140100, 9,  -1376.314, -2027.103, 91.73393, 0, 1, 0, 100, 0),
+(140100, 10, -1385.853, -2060.195, 93.47976, 0, 1, 0, 100, 0),
+(140100, 11, -1391.669, -2080.374, 92.31205, 0, 1, 0, 100, 0),
+(140100, 12, -1403.302, -2120.730, 92.45555, 0, 1, 0, 100, 0),
+(140100, 13, -1422.211, -2162.516, 92.80484, 0, 1, 0, 100, 0),
+(140100, 14, -1461.432, -2192.844, 90.85652, 0, 1, 0, 100, 0),
+(140100, 15, -1497.022, -2215.145, 92.44991, 0, 1, 0, 100, 0),
+(140100, 16, -1551.552, -2246.399, 91.74455, 0, 1, 0, 100, 0),
+(140100, 17, -1599.031, -2245.918, 94.90424, 0, 1, 0, 100, 0),
+(140100, 18, -1627.320, -2236.638, 82.50639, 0, 1, 0, 100, 0),
+(140100, 19, -1660.165, -2210.382, 87.35378, 0, 1, 0, 100, 0),
+(140100, 20, -1701.114, -2162.531, 91.66515, 0, 1, 0, 100, 0),
+(140100, 21, -1724.209, -2112.115, 91.66515, 0, 1, 0, 100, 0),
+(140100, 22, -1706.966, -2069.076, 91.69984, 0, 1, 0, 100, 0),
+(140100, 23, -1676.143, -2032.397, 93.75797, 0, 1, 0, 100, 0),
+(140100, 24, -1650.090, -1999.476, 91.67224, 0, 1, 0, 100, 0),
+(140100, 25, -1600.074, -1932.018, 91.66682, 0, 1, 0, 100, 0);
+
+UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 14032;
+DELETE FROM `creature_addon` WHERE `guid` = 14032;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(14032,140320,0,0,0,0,"");
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 14032;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(14032,14032,0,0,515,0,0),
+(14032,14024,5,80,515,0,0),
+(14032,14009,5,40,515,0,0),
+(14032,14023,5,10,515,0,0),
+(14032,14025,5,350,515,0,0),
+(14032,14026,5,290,515,0,0);
+
+DELETE FROM `waypoint_data` WHERE `id`=140320;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(140320, 1, -563.877, -2547.295, 92.80662, 0, 1, 0, 100, 0),
+(140320, 2, -554.863, -2516.469, 93.24456, 0, 1, 0, 100, 0),
+(140320, 3, -577.206, -2476.931, 91.71548, 0, 1, 0, 100, 0),
+(140320, 4, -615.504, -2485.227, 92.12007, 0, 1, 0, 100, 0),
+(140320, 5, -676.591, -2511.734, 92.65081, 0, 1, 0, 100, 0),
+(140320, 6, -740.945, -2516.645, 93.96837, 0, 1, 0, 100, 0),
+(140320, 7, -793.045, -2518.073, 93.75392, 0, 1, 0, 100, 0),
+(140320, 8, -809.498, -2452.034, 92.69364, 0, 1, 0, 100, 0),
+(140320, 9, -815.913, -2382.927, 95.12057, 0, 1, 0, 100, 0),
+(140320, 10, -843.412, -2315.514, 93.82954, 0, 1, 0, 100, 0),
+(140320, 11, -895.061, -2298.165, 91.67570, 0, 1, 0, 100, 0),
+(140320, 12, -935.569, -2326.431, 93.64941, 0, 1, 0, 100, 0),
+(140320, 13, -930.281, -2379.330, 91.75207, 0, 1, 0, 100, 0),
+(140320, 14, -894.944, -2431.918, 91.68614, 0, 1, 0, 100, 0),
+(140320, 15, -869.825, -2465.579, 91.83121, 0, 1, 0, 100, 0),
+(140320, 16, -821.030, -2509.637, 94.06260, 0, 1, 0, 100, 0),
+(140320, 17, -746.606, -2546.468, 92.20504, 0, 1, 0, 100, 0),
+(140320, 18, -679.426, -2566.475, 91.74886, 0, 1, 0, 100, 0),
+(140320, 19, -587.280, -2573.443, 93.62878, 0, 1, 0, 100, 0);
+
+UPDATE `creature` SET `position_x` = -2257.303, `position_y` = -2246.7531, `position_z` = 93.419 WHERE `guid` = 14027;
+UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 14029;
+DELETE FROM `creature_addon` WHERE `guid` = 14029;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(14029,140290,0,0,0,0,"");
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 14029;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(14029,14029,0,0,515,0,0),
+(14029,14030,5,80,515,0,0),
+(14029,14028,5,10,515,0,0),
+(14029,14031,5,350,515,0,0),
+(14029,14027,5,290,515,0,0);
+
+DELETE FROM `waypoint_data` WHERE `id`=140290;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(140290, 1, -2253.330, -2241.210, 93.07847, 0, 1, 0, 100, 0),
+(140290, 2, -2217.435, -2251.129, 94.54336, 0, 1, 0, 100, 0),
+(140290, 3, -2142.623, -2284.456, 94.39682, 0, 1, 0, 100, 0),
+(140290, 4, -2082.487, -2314.331, 95.64945, 0, 1, 0, 100, 0),
+(140290, 5, -2042.285, -2356.969, 91.66682, 0, 1, 0, 100, 0),
+(140290, 6, -2022.161, -2417.490, 94.07429, 0, 1, 0, 100, 0),
+(140290, 7, -2013.662, -2477.211, 94.32457, 0, 1, 0, 100, 0),
+(140290, 8, -2017.573, -2541.495, 93.52462, 0, 1, 0, 100, 0),
+(140290, 9, -2040.356, -2595.478, 92.17446, 0, 1, 0, 100, 0),
+(140290, 10, -2084.798, -2629.541, 93.74944, 0, 1, 0, 100, 0),
+(140290, 11, -2140.502, -2634.621, 93.78343, 0, 1, 0, 100, 0),
+(140290, 12, -2170.615, -2595.453, 92.91505, 0, 1, 0, 100, 0),
+(140290, 13, -2203.101, -2524.865, 91.66764, 0, 1, 0, 100, 0),
+(140290, 14, -2222.920, -2487.836, 93.82377, 0, 1, 0, 100, 0),
+(140290, 15, -2262.894, -2455.628, 91.72944, 0, 1, 0, 100, 0),
+(140290, 16, -2302.132, -2440.650, 94.23386, 0, 1, 0, 100, 0),
+(140290, 17, -2343.905, -2418.414, 95.24754, 0, 1, 0, 100, 0),
+(140290, 18, -2375.907, -2379.462, 91.66664, 0, 1, 0, 100, 0),
+(140290, 19, -2351.094, -2341.351, 94.60894, 0, 1, 0, 100, 0),
+(140290, 20, -2288.886, -2277.052, 91.68980, 0, 1, 0, 100, 0);
+
+UPDATE `creature` SET `MovementType` = 0, `spawndist`=0 WHERE `guid` IN (14021,14022,14018,14020,14019); 
+UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 14021;
+DELETE FROM `creature_addon` WHERE `guid` = 14021;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(14021,140210,0,0,0,0,"");
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 14021;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(14021,14021,0,0,515,0,0),
+(14021,14022,5,80,515,0,0),
+(14021,14018,5,10,515,0,0),
+(14021,14020,5,340,515,0,0),
+(14021,14019,5,390,515,0,0);
+
+DELETE FROM `waypoint_data` WHERE `id`=140210;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(140210, 1, 649.215, -1989.051, 94.34850, 0, 0, 0, 100, 0),
+(140210, 2, 670.186, -2030.953, 92.29443, 0, 0, 0, 100, 0),
+(140210, 3, 687.290, -2080.589, 91.71897, 0, 0, 0, 100, 0),
+(140210, 4, 700.974, -2120.297, 91.87732, 0, 0, 0, 100, 0),
+(140210, 5, 713.325, -2186.960, 91.66671, 0, 0, 0, 100, 0),
+(140210, 6, 704.506, -2224.343, 93.43695, 0, 0, 0, 100, 0),
+(140210, 7, 676.314, -2251.328, 91.89948, 0, 0, 0, 100, 0),
+(140210, 8, 642.684, -2222.697, 94.12448, 0, 0, 0, 100, 0),
+(140210, 9, 624.997, -2173.266, 91.66669, 0, 0, 0, 100, 0),
+(140210, 10, 609.828, -2123.073, 92.59200, 0, 0, 0, 100, 0),
+(140210, 11, 597.598, -2061.389, 91.66725, 0, 0, 0, 100, 0),
+(140210, 12, 592.907, -2019.652, 91.66725, 0, 0, 0, 100, 0),
+(140210, 13, 566.752, -1978.395, 91.66765, 0, 0, 0, 100, 0),
+(140210, 14, 528.804, -1977.483, 92.50449, 0, 0, 0, 100, 0),
+(140210, 15, 472.834, -1963.692, 92.52468, 0, 0, 0, 100, 0),
+(140210, 16, 425.936, -1948.794, 91.66793, 0, 0, 0, 100, 0),
+(140210, 17, 385.039, -1939.231, 91.66793, 0, 0, 0, 100, 0),
+(140210, 18, 331.649, -1917.620, 91.75427, 0, 0, 0, 100, 0),
+(140210, 19, 307.525, -1878.016, 91.66726, 0, 0, 0, 100, 0),
+(140210, 20, 309.501, -1835.411, 91.66726, 0, 0, 0, 100, 0),
+(140210, 21, 342.856, -1814.195, 91.66726, 0, 0, 0, 100, 0),
+(140210, 22, 400.768, -1830.260, 91.66726, 0, 0, 0, 100, 0),
+(140210, 23, 439.347, -1846.864, 91.66726, 0, 0, 0, 100, 0),
+(140210, 24, 479.455, -1826.186, 91.66726, 0, 0, 0, 100, 0),
+(140210, 25, 514.558, -1787.147, 91.66726, 0, 0, 0, 100, 0),
+(140210, 26, 552.435, -1771.816, 93.16978, 0, 0, 0, 100, 0),
+(140210, 27, 590.213, -1795.443, 93.98595, 0, 0, 0, 100, 0),
+(140210, 28, 612.256, -1843.677, 91.66778, 0, 0, 0, 100, 0),
+(140210, 29, 623.407, -1894.979, 92.87283, 0, 0, 0, 100, 0),
+(140210, 30, 632.329, -1936.020, 91.66797, 0, 0, 0, 100, 0);