DB/Creature: Add formations to Cenarion Hold Infantry

Closes #25456

(cherry picked from commit 184174f1f0801a060820159322f406853b5d53da)

1 files changed, 400 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_02_17_00_world_2020_09_16_03_world_335.sql b/sql/updates/world/master/2022_02_17_00_world_2020_09_16_03_world_335.sql
new file mode 100644
index 00000000000..55c5fc783f0
--- /dev/null
+++ b/sql/updates/world/master/2022_02_17_00_world_2020_09_16_03_world_335.sql
@@ -0,0 +1,400 @@
+DELETE c, ca FROM `creature` c LEFT JOIN `creature_addon` ca ON c.guid = ca.guid LEFT JOIN `waypoint_data` wp ON ca.path_id = wp.id WHERE c.id=15184;
+DELETE c, ca FROM `creature` c LEFT JOIN `creature_addon` ca ON c.guid = ca.guid LEFT JOIN `waypoint_data` wp ON ca.path_id = wp.id WHERE c.guid IN (42766,42767,42768,42769,42770,42771,42772,42773,42774,42775,42776,42777,42778,42779,42780,42781,42782,42783,42784,42785,42868,42884,42885,42886,42891,42892,42895,42896,42897,42898);
+
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES
+(42766, 15184, 1, 0, 0, '0', 0, 0, 1, -6869.73, 871.868, 35.9944, 3.59538, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42767, 15184, 1, 0, 0, '0', 0, 0, 1, -6871.2, 879.51, 36.4725, 2.60054, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42768, 15184, 1, 0, 0, '0', 0, 0, 1, -6859.57, 738.389, 55.1345, 5.0091, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42769, 15184, 1, 0, 0, '0', 0, 0, 1, -6825.21, 841.13, 49.5545, 4.83456, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42770, 15184, 1, 0, 0, '0', 0, 0, 1, -6803.39, 723.999, 42.2456, 4.90438, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42771, 15184, 1, 0, 0, '0', 0, 0, 1, -6816.91, 718.773, 40.6206, 5.2709, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42772, 15184, 1, 0, 0, '0', 0, 0, 1, -6878.11, 752.944, 43.133, 0.296706, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42773, 15184, 1, 0, 0, '0', 0, 0, 1, -6853.45, 763.728, 42.6753, 5.44543, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42774, 15184, 1, 0, 0, '0', 0, 0, 1, -6843.99, 749.327, 42.6073, 0.383972, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42775, 15184, 1, 0, 0, '0', 0, 0, 1, -6838.14, 736.773, 42.1073, 0.541052, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42776, 15184, 1, 0, 0, '0', 0, 0, 1, -6877.26, 729.273, 45.7454, 0.418879, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42777, 15184, 1, 0, 0, '0', 0, 0, 1, -6874.96, 722.567, 45.7454, 0.541052, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42778, 15184, 1, 0, 0, '0', 0, 0, 1, -6800.43, 786.834, 51.5129, 2.21657, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42779, 15184, 1, 0, 0, '0', 0, 0, 1, -6785.93, 789.291, 52.547, 1.8326, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42780, 15184, 1, 0, 0, '0', 0, 0, 1, -6754.93, 755.7, 87.7416, 3.36848, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42781, 15184, 1, 0, 0, '0', 0, 0, 1, -6760.2, 768.678, 88.7426, 3.71755, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42782, 15184, 1, 0, 0, '0', 0, 0, 1, -6865.8, 738.326, 55.1345, 5.18363, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42783, 15184, 1, 0, 0, '0', 0, 0, 1, -6876.96, 722.261, 55.1345, 0.593412, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42784, 15184, 1, 0, 0, '0', 0, 0, 1, -6817.11, 776.108, 47.8879, 3.89208, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42785, 15184, 1, 0, 0, '0', 0, 0, 1, -6801.55, 770.92, 64.7629, 2.51327, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42868, 15184, 1, 0, 0, '0', 0, 0, 1, -6806.88, 827.78, 53.68, 2.68781, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42884, 15184, 1, 0, 0, '0', 0, 0, 1, -6798.14, 842.835, 48.2119, 4.06662, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42885, 15184, 1, 0, 0, '0', 0, 0, 1, -6768.65, 825.393, 55.8302, 3.57792, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42886, 15184, 1, 0, 0, '0', 0, 0, 1, -6764.78, 813.07, 55.8302, 3.24631, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42891, 15184, 1, 0, 0, '0', 0, 0, 1, -6828.76, 782.893, 45.6379, 3.9619, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42892, 15184, 1, 0, 0, '0', 0, 0, 1, -6817.96, 790.697, 49.5129, 0.610865, 600, 0, 0, 55888, 0, 0, 0, 0, 0, '', 0),
+(42895, 15184, 1, 0, 0, '0', 0, 0, 1, -6813.65, 726.728, 40.185, 1.99952, 600, 0, 0, 55888, 0, 2, 0, 0, 0, '', 0),
+(42896, 15184, 1, 0, 0, '0', 0, 0, 1, -6811.04, 720.978, 39.6068, 1.99427, 600, 0, 0, 55888, 0, 2, 0, 0, 0, '', 0),
+(42897, 15184, 1, 0, 0, '0', 0, 0, 1, -6765.8, 754.172, 85.1787, 3.87854, 600, 0, 0, 55888, 0, 2, 0, 0, 0, '', 0),
+(42898, 15184, 1, 0, 0, '0', 0, 0, 1, -6761.69, 757.905, 86.3393, 3.87862, 600, 0, 0, 55888, 0, 2, 0, 0, 0, '', 0);
+
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(42766, 0, 0, 0, 4097, 0, 0, '18950'),
+(42767, 0, 0, 0, 4097, 0, 0, '18950'),
+(42768, 0, 0, 0, 4097, 0, 0, '18950'),
+(42769, 0, 0, 0, 4097, 0, 0, '18950'),
+(42770, 0, 0, 0, 4097, 0, 0, '18950'),
+(42771, 0, 0, 0, 4097, 0, 0, '18950'),
+(42772, 0, 0, 0, 4097, 0, 0, '18950'),
+(42773, 0, 0, 0, 4097, 0, 0, '18950'),
+(42774, 0, 0, 0, 4097, 0, 0, '18950'),
+(42775, 0, 0, 0, 4097, 0, 0, '18950'),
+(42776, 0, 0, 0, 4097, 0, 0, '18950'),
+(42777, 0, 0, 0, 4097, 0, 0, '18950'),
+(42778, 0, 0, 0, 4097, 0, 0, '18950'),
+(42779, 0, 0, 0, 4097, 0, 0, '18950'),
+(42780, 0, 0, 0, 4097, 0, 0, '18950'),
+(42781, 0, 0, 0, 4097, 0, 0, '18950'),
+(42782, 0, 0, 0, 4097, 0, 0, '18950'),
+(42783, 0, 0, 0, 4097, 0, 0, '18950'),
+(42784, 0, 0, 0, 4097, 0, 0, '18950'),
+(42785, 0, 0, 0, 4097, 0, 0, '18950'),
+(42868, 0, 0, 0, 4097, 0, 0, '18950'),
+(42884, 0, 0, 0, 4097, 0, 0, '18950'),
+(42885, 0, 0, 0, 4097, 0, 0, '18950'),
+(42886, 0, 0, 0, 4097, 0, 0, '18950'),
+(42891, 0, 0, 0, 4097, 0, 0, '18950'),
+(42892, 0, 0, 0, 4097, 0, 0, '18950'),
+(42895, 428950, 0, 0, 1, 0, 0, NULL),
+(42896, 428960, 0, 0, 1, 0, 0, NULL),
+(42897, 428970, 0, 0, 1, 0, 0, NULL),
+(42898, 428980, 0, 0, 1, 0, 0, NULL);
+
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(428950, 1, -6816.55, 729.914, 40.9409, 0, 0, 0, 0, 100, 0),
+(428950, 2, -6822.69, 739.894, 42.2502, 0, 0, 0, 0, 100, 0),
+(428950, 3, -6826.29, 746.876, 42.5027, 0, 0, 0, 0, 100, 0),
+(428950, 4, -6829.06, 755.359, 42.9041, 0, 0, 0, 0, 100, 0),
+(428950, 5, -6832.45, 765.43, 43.3425, 0, 0, 0, 0, 100, 0),
+(428950, 6, -6836.58, 776.442, 43.4424, 0, 0, 0, 0, 100, 0),
+(428950, 7, -6840.51, 782.555, 43.0982, 0, 0, 0, 0, 100, 0),
+(428950, 8, -6847.25, 792.85, 42.3439, 0, 0, 0, 0, 100, 0),
+(428950, 9, -6852.94, 801.869, 42.297, 0, 0, 0, 0, 100, 0),
+(428950, 10, -6856.21, 807.739, 42.5655, 0, 0, 0, 0, 100, 0),
+(428950, 11, -6859.62, 815.97, 42.5404, 0, 0, 0, 0, 100, 0),
+(428950, 12, -6863.85, 826.987, 40.6358, 0, 0, 0, 0, 100, 0),
+(428950, 13, -6867.7, 836.303, 39.6669, 0, 0, 0, 0, 100, 0),
+(428950, 14, -6872.95, 848.032, 37.8322, 0, 0, 0, 0, 100, 0),
+(428950, 15, -6876.2, 856.409, 36.5263, 0, 0, 0, 0, 100, 0),
+(428950, 16, -6880.83, 868.984, 34.9728, 0, 0, 0, 0, 100, 0),
+(428950, 17, -6883.65, 875.079, 33.9947, 0, 0, 0, 0, 100, 0),
+(428950, 18, -6890, 882.91, 32.1476, 0, 0, 0, 0, 100, 0),
+(428950, 19, -6893.54, 888.548, 30.5268, 0, 0, 0, 0, 100, 0),
+(428950, 20, -6890.1, 884.865, 31.6699, 0, 0, 0, 0, 100, 0),
+(428950, 21, -6884.88, 876.242, 33.7553, 0, 0, 0, 0, 100, 0),
+(428950, 22, -6881.38, 869.917, 34.8594, 0, 0, 0, 0, 100, 0),
+(428950, 23, -6881.38, 869.917, 34.8594, 0, 0, 0, 0, 100, 0),
+(428950, 24, -6873.98, 850.385, 37.5666, 0, 0, 0, 0, 100, 0),
+(428950, 25, -6870.56, 841.846, 38.6296, 0, 0, 0, 0, 100, 0),
+(428950, 26, -6861.9, 822.79, 41.3868, 0, 0, 0, 0, 100, 0),
+(428950, 27, -6859.92, 819.089, 42.159, 0, 0, 0, 0, 100, 0),
+(428950, 28, -6849.83, 800.717, 42.5617, 0, 0, 0, 0, 100, 0),
+(428950, 29, -6840.12, 782.207, 43.1284, 0, 0, 0, 0, 100, 0),
+(428950, 30, -6837.45, 776.041, 43.414, 0, 0, 0, 0, 100, 0),
+(428950, 31, -6827.28, 744.127, 42.2768, 0, 0, 0, 0, 100, 0),
+(428950, 32, -6818.75, 733.749, 41.5749, 0, 0, 0, 0, 100, 0),
+(428950, 33, -6813.08, 724.763, 39.9046, 0, 0, 0, 0, 100, 0),
+(428950, 34, -6809.91, 716.983, 39.1755, 0, 0, 0, 0, 100, 0),
+(428950, 35, -6808.91, 710.891, 38.2362, 0, 0, 0, 0, 100, 0),
+(428950, 36, -6807.16, 698.16, 33.7398, 0, 0, 0, 0, 100, 0),
+(428950, 37, -6805.92, 689.342, 30.7289, 0, 0, 0, 0, 100, 0),
+(428950, 38, -6804.8, 677.087, 25.5514, 0, 0, 0, 0, 100, 0),
+(428950, 39, -6804.4, 665.334, 20.8685, 0, 0, 0, 0, 100, 0),
+(428950, 40, -6804.67, 651.897, 16.6345, 0, 0, 0, 0, 100, 0),
+(428950, 41, -6807.06, 638.119, 12.0988, 0, 0, 0, 0, 100, 0),
+(428950, 42, -6809.5, 624.306, 8.32777, 0, 0, 0, 0, 100, 0),
+(428950, 43, -6810.32, 609.76, 5.05707, 0, 0, 0, 0, 100, 0),
+(428950, 44, -6809.6, 595.245, 2.16877, 0, 0, 0, 0, 100, 0),
+(428950, 45, -6808.45, 583.584, 1.0702, 0, 0, 0, 0, 100, 0),
+(428950, 46, -6806.84, 571.343, 0.231993, 0, 0, 0, 0, 100, 0),
+(428950, 47, -6804.66, 555.829, -0.198168, 0, 0, 0, 0, 100, 0),
+(428950, 48, -6807.19, 572.438, 0.279579, 0, 0, 0, 0, 100, 0),
+(428950, 49, -6808.44, 587.464, 1.43813, 0, 0, 0, 0, 100, 0),
+(428950, 50, -6809.72, 603.623, 3.73783, 0, 0, 0, 0, 100, 0),
+(428950, 51, -6809.72, 603.623, 3.73783, 0, 0, 0, 0, 100, 0),
+(428950, 52, -6807.07, 624.415, 8.18776, 0, 0, 0, 0, 100, 0),
+(428950, 53, -6805.91, 636.961, 11.7855, 0, 0, 0, 0, 100, 0),
+(428950, 54, -6803.38, 657.809, 18.6525, 0, 0, 0, 0, 100, 0),
+(428950, 55, -6802.42, 666.998, 21.7866, 0, 0, 0, 0, 100, 0),
+(428950, 56, -6802.27, 691.57, 31.9207, 0, 0, 0, 0, 100, 0),
+(428950, 57, -6802.27, 691.57, 31.9207, 0, 0, 0, 0, 100, 0),
+(428950, 58, -6808.24, 711.968, 38.4664, 0, 0, 0, 0, 100, 0),
+(428960, 1, -6816.55, 729.914, 40.9409, 0, 0, 0, 0, 100, 0),
+(428960, 2, -6822.69, 739.894, 42.2502, 0, 0, 0, 0, 100, 0),
+(428960, 3, -6826.29, 746.876, 42.5027, 0, 0, 0, 0, 100, 0),
+(428960, 4, -6829.06, 755.359, 42.9041, 0, 0, 0, 0, 100, 0),
+(428960, 5, -6832.45, 765.43, 43.3425, 0, 0, 0, 0, 100, 0),
+(428960, 6, -6836.58, 776.442, 43.4424, 0, 0, 0, 0, 100, 0),
+(428960, 7, -6840.51, 782.555, 43.0982, 0, 0, 0, 0, 100, 0),
+(428960, 8, -6847.25, 792.85, 42.3439, 0, 0, 0, 0, 100, 0),
+(428960, 9, -6852.94, 801.869, 42.297, 0, 0, 0, 0, 100, 0),
+(428960, 10, -6856.21, 807.739, 42.5655, 0, 0, 0, 0, 100, 0),
+(428960, 11, -6859.62, 815.97, 42.5404, 0, 0, 0, 0, 100, 0),
+(428960, 12, -6863.85, 826.987, 40.6358, 0, 0, 0, 0, 100, 0),
+(428960, 13, -6867.7, 836.303, 39.6669, 0, 0, 0, 0, 100, 0),
+(428960, 14, -6872.95, 848.032, 37.8322, 0, 0, 0, 0, 100, 0),
+(428960, 15, -6876.2, 856.409, 36.5263, 0, 0, 0, 0, 100, 0),
+(428960, 16, -6880.83, 868.984, 34.9728, 0, 0, 0, 0, 100, 0),
+(428960, 17, -6883.65, 875.079, 33.9947, 0, 0, 0, 0, 100, 0),
+(428960, 18, -6890, 882.91, 32.1476, 0, 0, 0, 0, 100, 0),
+(428960, 19, -6893.54, 888.548, 30.5268, 0, 0, 0, 0, 100, 0),
+(428960, 20, -6890.1, 884.865, 31.6699, 0, 0, 0, 0, 100, 0),
+(428960, 21, -6884.88, 876.242, 33.7553, 0, 0, 0, 0, 100, 0),
+(428960, 22, -6881.38, 869.917, 34.8594, 0, 0, 0, 0, 100, 0),
+(428960, 23, -6881.38, 869.917, 34.8594, 0, 0, 0, 0, 100, 0),
+(428960, 24, -6873.98, 850.385, 37.5666, 0, 0, 0, 0, 100, 0),
+(428960, 25, -6870.56, 841.846, 38.6296, 0, 0, 0, 0, 100, 0),
+(428960, 26, -6861.9, 822.79, 41.3868, 0, 0, 0, 0, 100, 0),
+(428960, 27, -6859.92, 819.089, 42.159, 0, 0, 0, 0, 100, 0),
+(428960, 28, -6849.83, 800.717, 42.5617, 0, 0, 0, 0, 100, 0),
+(428960, 29, -6840.12, 782.207, 43.1284, 0, 0, 0, 0, 100, 0),
+(428960, 30, -6837.45, 776.041, 43.414, 0, 0, 0, 0, 100, 0),
+(428960, 31, -6827.28, 744.127, 42.2768, 0, 0, 0, 0, 100, 0),
+(428960, 32, -6818.75, 733.749, 41.5749, 0, 0, 0, 0, 100, 0),
+(428960, 33, -6813.08, 724.763, 39.9046, 0, 0, 0, 0, 100, 0),
+(428960, 34, -6809.91, 716.983, 39.1755, 0, 0, 0, 0, 100, 0),
+(428960, 35, -6808.91, 710.891, 38.2362, 0, 0, 0, 0, 100, 0),
+(428960, 36, -6807.16, 698.16, 33.7398, 0, 0, 0, 0, 100, 0),
+(428960, 37, -6805.92, 689.342, 30.7289, 0, 0, 0, 0, 100, 0),
+(428960, 38, -6804.8, 677.087, 25.5514, 0, 0, 0, 0, 100, 0),
+(428960, 39, -6804.4, 665.334, 20.8685, 0, 0, 0, 0, 100, 0),
+(428960, 40, -6804.67, 651.897, 16.6345, 0, 0, 0, 0, 100, 0),
+(428960, 41, -6807.06, 638.119, 12.0988, 0, 0, 0, 0, 100, 0),
+(428960, 42, -6809.5, 624.306, 8.32777, 0, 0, 0, 0, 100, 0),
+(428960, 43, -6810.32, 609.76, 5.05707, 0, 0, 0, 0, 100, 0),
+(428960, 44, -6809.6, 595.245, 2.16877, 0, 0, 0, 0, 100, 0),
+(428960, 45, -6808.45, 583.584, 1.0702, 0, 0, 0, 0, 100, 0),
+(428960, 46, -6806.84, 571.343, 0.231993, 0, 0, 0, 0, 100, 0),
+(428960, 47, -6804.66, 555.829, -0.198168, 0, 0, 0, 0, 100, 0),
+(428960, 48, -6807.19, 572.438, 0.279579, 0, 0, 0, 0, 100, 0),
+(428960, 49, -6808.44, 587.464, 1.43813, 0, 0, 0, 0, 100, 0),
+(428960, 50, -6809.72, 603.623, 3.73783, 0, 0, 0, 0, 100, 0),
+(428960, 51, -6809.72, 603.623, 3.73783, 0, 0, 0, 0, 100, 0),
+(428960, 52, -6807.07, 624.415, 8.18776, 0, 0, 0, 0, 100, 0),
+(428960, 53, -6805.91, 636.961, 11.7855, 0, 0, 0, 0, 100, 0),
+(428960, 54, -6803.38, 657.809, 18.6525, 0, 0, 0, 0, 100, 0),
+(428960, 55, -6802.42, 666.998, 21.7866, 0, 0, 0, 0, 100, 0),
+(428960, 56, -6802.27, 691.57, 31.9207, 0, 0, 0, 0, 100, 0),
+(428960, 57, -6802.27, 691.57, 31.9207, 0, 0, 0, 0, 100, 0),
+(428960, 58, -6808.24, 711.968, 38.4664, 0, 0, 0, 0, 100, 0),
+(428970, 1, -6761.96, 758.334, 86.3757, 0, 0, 0, 0, 100, 0),
+(428970, 2, -6757.04, 762.074, 87.2302, 0, 0, 0, 0, 100, 0),
+(428970, 3, -6760.82, 758.734, 86.5752, 0, 0, 0, 0, 100, 0),
+(428970, 4, -6764.45, 755.24, 85.2373, 0, 0, 0, 0, 100, 0),
+(428970, 5, -6768.5, 751.391, 84.9629, 0, 0, 0, 0, 100, 0),
+(428970, 6, -6771.82, 750.88, 83.5743, 0, 0, 0, 0, 100, 0),
+(428970, 7, -6778.51, 751.527, 79.5029, 0, 0, 0, 0, 100, 0),
+(428970, 8, -6781.83, 752.04, 77.7449, 0, 0, 0, 0, 100, 0),
+(428970, 9, -6784.59, 753.956, 76.1443, 0, 0, 0, 0, 100, 0),
+(428970, 10, -6787.25, 756.079, 74.6887, 0, 0, 0, 0, 100, 0),
+(428970, 11, -6790.91, 759.537, 72.8234, 0, 0, 0, 0, 100, 0),
+(428970, 12, -6793.07, 762.843, 70.8489, 0, 0, 0, 0, 100, 0),
+(428970, 13, -6793.07, 765.656, 69.2284, 0, 0, 0, 0, 100, 0),
+(428970, 14, -6792.73, 770.559, 65.6056, 0, 0, 0, 0, 100, 0),
+(428970, 15, -6792.55, 773.914, 62.1568, 0, 0, 0, 0, 100, 0),
+(428970, 16, -6792.15, 778.937, 57.6065, 0, 0, 0, 0, 100, 0),
+(428970, 17, -6792.2, 783.975, 53.9394, 0, 0, 0, 0, 100, 0),
+(428970, 18, -6792.75, 786.735, 52.1274, 0, 0, 0, 0, 100, 0),
+(428970, 19, -6793.97, 789.867, 51.5243, 0, 0, 0, 0, 100, 0),
+(428970, 20, -6798.83, 791.208, 51.1254, 0, 0, 0, 0, 100, 0),
+(428970, 21, -6803.66, 792.624, 50.9383, 0, 0, 0, 0, 100, 0),
+(428970, 22, -6807.93, 798.364, 51.4157, 0, 0, 0, 0, 100, 0),
+(428970, 23, -6810.28, 806.367, 51.3492, 0, 0, 0, 0, 100, 0),
+(428970, 24, -6811.7, 813.493, 50.8492, 0, 0, 0, 0, 100, 0),
+(428970, 25, -6815.13, 819.946, 49.872, 0, 0, 0, 0, 100, 0),
+(428970, 26, -6817.42, 829.18, 49.579, 0, 0, 0, 0, 100, 0),
+(428970, 27, -6815.26, 834.316, 49.6985, 0, 0, 0, 0, 100, 0),
+(428970, 28, -6809.46, 836.249, 49.8308, 0, 0, 0, 0, 100, 0),
+(428970, 29, -6805.05, 837.062, 49.4621, 0, 0, 0, 0, 100, 0),
+(428970, 30, -6799.52, 837.859, 48.2942, 0, 0, 0, 0, 100, 0),
+(428970, 31, -6790.57, 838.747, 46.5847, 0, 0, 0, 0, 100, 0),
+(428970, 32, -6782.24, 839.347, 45.557, 0, 0, 0, 0, 100, 0),
+(428970, 33, -6775.53, 839.798, 44.4548, 0, 0, 0, 0, 100, 0),
+(428970, 34, -6771.13, 840.716, 43.2823, 0, 0, 0, 0, 100, 0),
+(428970, 35, -6768.05, 842.056, 41.8581, 0, 0, 0, 0, 100, 0),
+(428970, 36, -6766.38, 843.528, 40.6364, 0, 0, 0, 0, 100, 0),
+(428970, 37, -6765.16, 846.657, 38.6168, 0, 0, 0, 0, 100, 0),
+(428970, 38, -6764.21, 849.879, 35.4296, 0, 0, 0, 0, 100, 0),
+(428970, 39, -6765.78, 852.846, 33.5119, 0, 0, 0, 0, 100, 0),
+(428970, 40, -6767.6, 855.673, 31.411, 0, 0, 0, 0, 100, 0),
+(428970, 41, -6769.01, 861.072, 27.0275, 0, 0, 0, 0, 100, 0),
+(428970, 42, -6767.13, 863.836, 25.1458, 0, 0, 0, 0, 100, 0),
+(428970, 43, -6761.55, 864.132, 22.8287, 0, 0, 0, 0, 100, 0),
+(428970, 44, -6758.69, 860.717, 21.7311, 0, 0, 0, 0, 100, 0),
+(428970, 45, -6753.13, 854.427, 19.4856, 0, 0, 0, 0, 100, 0),
+(428970, 46, -6747.29, 849.174, 17.2199, 0, 0, 0, 0, 100, 0),
+(428970, 47, -6740.16, 844.732, 15.4339, 0, 0, 0, 0, 100, 0),
+(428970, 48, -6734.72, 843.482, 13.2152, 0, 0, 0, 0, 100, 0),
+(428970, 49, -6729.17, 842.805, 10.25, 0, 0, 0, 0, 100, 0),
+(428970, 50, -6723.71, 841.677, 8.73044, 0, 0, 0, 0, 100, 0),
+(428970, 51, -6717.2, 840.173, 8.19204, 0, 0, 0, 0, 100, 0),
+(428970, 52, -6712.86, 838.998, 7.58918, 0, 0, 0, 0, 100, 0),
+(428970, 53, -6719.45, 837.693, 8.75937, 0, 0, 0, 0, 100, 0),
+(428970, 54, -6726.1, 838.553, 9.86451, 0, 0, 0, 0, 100, 0),
+(428970, 55, -6731.47, 841.519, 11.5452, 0, 0, 0, 0, 100, 0),
+(428970, 56, -6737.33, 844.8, 14.5998, 0, 0, 0, 0, 100, 0),
+(428970, 57, -6742.11, 847.346, 15.8703, 0, 0, 0, 0, 100, 0),
+(428970, 58, -6747.54, 851.241, 17.4242, 0, 0, 0, 0, 100, 0),
+(428970, 59, -6753.36, 855.527, 19.7496, 0, 0, 0, 0, 100, 0),
+(428970, 60, -6757.56, 860.772, 21.4966, 0, 0, 0, 0, 100, 0),
+(428970, 61, -6760.67, 864.736, 22.5304, 0, 0, 0, 0, 100, 0),
+(428970, 62, -6765.94, 866.564, 23.7228, 0, 0, 0, 0, 100, 0),
+(428970, 63, -6771.53, 866.783, 25.0876, 0, 0, 0, 0, 100, 0),
+(428970, 64, -6770.56, 862.444, 26.4167, 0, 0, 0, 0, 100, 0),
+(428970, 65, -6769.5, 858.642, 28.7127, 0, 0, 0, 0, 100, 0),
+(428970, 66, -6768.43, 855.496, 31.7591, 0, 0, 0, 0, 100, 0),
+(428970, 67, -6767.59, 854.038, 32.7564, 0, 0, 0, 0, 100, 0),
+(428970, 68, -6765.23, 849.588, 35.9659, 0, 0, 0, 0, 100, 0),
+(428970, 69, -6763.93, 846.49, 38.5969, 0, 0, 0, 0, 100, 0),
+(428970, 70, -6766.18, 845.896, 39.4059, 0, 0, 0, 0, 100, 0),
+(428970, 71, -6767.49, 842.215, 41.6066, 0, 0, 0, 0, 100, 0),
+(428970, 72, -6770.32, 840.488, 43.1654, 0, 0, 0, 0, 100, 0),
+(428970, 73, -6773.43, 839.341, 44.1801, 0, 0, 0, 0, 100, 0),
+(428970, 74, -6778.46, 839.636, 44.8266, 0, 0, 0, 0, 100, 0),
+(428970, 75, -6786.27, 839.452, 46.2578, 0, 0, 0, 0, 100, 0),
+(428970, 76, -6792.89, 838.279, 46.9812, 0, 0, 0, 0, 100, 0),
+(428970, 77, -6798.45, 837.722, 48.086, 0, 0, 0, 0, 100, 0),
+(428970, 78, -6805.11, 836.895, 49.4885, 0, 0, 0, 0, 100, 0),
+(428970, 79, -6811.16, 835.878, 49.8527, 0, 0, 0, 0, 100, 0),
+(428970, 80, -6815.42, 830.676, 49.5922, 0, 0, 0, 0, 100, 0),
+(428970, 81, -6816.42, 823.49, 49.6628, 0, 0, 0, 0, 100, 0),
+(428970, 82, -6814.17, 817.202, 50.2865, 0, 0, 0, 0, 100, 0),
+(428970, 83, -6811.93, 810.909, 51.0109, 0, 0, 0, 0, 100, 0),
+(428970, 84, -6809.97, 805.452, 51.3904, 0, 0, 0, 0, 100, 0),
+(428970, 85, -6808.48, 801.26, 51.5449, 0, 0, 0, 0, 100, 0),
+(428970, 86, -6806.07, 795.617, 51.1313, 0, 0, 0, 0, 100, 0),
+(428970, 87, -6803.85, 793.1, 50.9734, 0, 0, 0, 0, 100, 0),
+(428970, 88, -6798.27, 790.459, 51.0938, 0, 0, 0, 0, 100, 0),
+(428970, 89, -6793.29, 787.931, 51.6357, 0, 0, 0, 0, 100, 0),
+(428970, 90, -6791.9, 783.93, 54.0268, 0, 0, 0, 0, 100, 0),
+(428970, 91, -6792.4, 779.466, 57.1378, 0, 0, 0, 0, 100, 0),
+(428970, 92, -6793.43, 774.532, 61.5517, 0, 0, 0, 0, 100, 0),
+(428970, 93, -6794.1, 768.904, 66.8198, 0, 0, 0, 0, 100, 0),
+(428970, 94, -6793.67, 765.591, 69.2785, 0, 0, 0, 0, 100, 0),
+(428970, 95, -6792.64, 762.393, 71.0797, 0, 0, 0, 0, 100, 0),
+(428970, 96, -6791.09, 759.408, 72.8651, 0, 0, 0, 0, 100, 0),
+(428970, 97, -6788.81, 756.945, 74.0066, 0, 0, 0, 0, 100, 0),
+(428970, 98, -6786.38, 754.63, 75.4713, 0, 0, 0, 0, 100, 0),
+(428970, 99, -6782.41, 751.516, 77.5131, 0, 0, 0, 0, 100, 0),
+(428970, 100, -6779.36, 750.115, 78.8973, 0, 0, 0, 0, 100, 0),
+(428970, 101, -6774.37, 750.134, 81.6935, 0, 0, 0, 0, 100, 0),
+(428970, 102, -6771.27, 751.438, 83.9032, 0, 0, 0, 0, 100, 0),
+(428970, 103, -6766.89, 753.936, 84.9862, 0, 0, 0, 0, 100, 0),
+(428970, 104, -6763.87, 755.411, 85.2801, 0, 0, 0, 0, 100, 0),
+(428970, 105, -6761.32, 757.602, 86.3268, 0, 0, 0, 0, 100, 0),
+(428980, 1, -6761.96, 758.334, 86.3757, 0, 0, 0, 0, 100, 0),
+(428980, 2, -6757.04, 762.074, 87.2302, 0, 0, 0, 0, 100, 0),
+(428980, 3, -6760.82, 758.734, 86.5752, 0, 0, 0, 0, 100, 0),
+(428980, 4, -6764.45, 755.24, 85.2373, 0, 0, 0, 0, 100, 0),
+(428980, 5, -6768.5, 751.391, 84.9629, 0, 0, 0, 0, 100, 0),
+(428980, 6, -6771.82, 750.88, 83.5743, 0, 0, 0, 0, 100, 0),
+(428980, 7, -6778.51, 751.527, 79.5029, 0, 0, 0, 0, 100, 0),
+(428980, 8, -6781.83, 752.04, 77.7449, 0, 0, 0, 0, 100, 0),
+(428980, 9, -6784.59, 753.956, 76.1443, 0, 0, 0, 0, 100, 0),
+(428980, 10, -6787.25, 756.079, 74.6887, 0, 0, 0, 0, 100, 0),
+(428980, 11, -6790.91, 759.537, 72.8234, 0, 0, 0, 0, 100, 0),
+(428980, 12, -6793.07, 762.843, 70.8489, 0, 0, 0, 0, 100, 0),
+(428980, 13, -6793.07, 765.656, 69.2284, 0, 0, 0, 0, 100, 0),
+(428980, 14, -6792.73, 770.559, 65.6056, 0, 0, 0, 0, 100, 0),
+(428980, 15, -6792.55, 773.914, 62.1568, 0, 0, 0, 0, 100, 0),
+(428980, 16, -6792.15, 778.937, 57.6065, 0, 0, 0, 0, 100, 0),
+(428980, 17, -6792.2, 783.975, 53.9394, 0, 0, 0, 0, 100, 0),
+(428980, 18, -6792.75, 786.735, 52.1274, 0, 0, 0, 0, 100, 0),
+(428980, 19, -6793.97, 789.867, 51.5243, 0, 0, 0, 0, 100, 0),
+(428980, 20, -6798.83, 791.208, 51.1254, 0, 0, 0, 0, 100, 0),
+(428980, 21, -6803.66, 792.624, 50.9383, 0, 0, 0, 0, 100, 0),
+(428980, 22, -6807.93, 798.364, 51.4157, 0, 0, 0, 0, 100, 0),
+(428980, 23, -6810.28, 806.367, 51.3492, 0, 0, 0, 0, 100, 0),
+(428980, 24, -6811.7, 813.493, 50.8492, 0, 0, 0, 0, 100, 0),
+(428980, 25, -6815.13, 819.946, 49.872, 0, 0, 0, 0, 100, 0),
+(428980, 26, -6817.42, 829.18, 49.579, 0, 0, 0, 0, 100, 0),
+(428980, 27, -6815.26, 834.316, 49.6985, 0, 0, 0, 0, 100, 0),
+(428980, 28, -6809.46, 836.249, 49.8308, 0, 0, 0, 0, 100, 0),
+(428980, 29, -6805.05, 837.062, 49.4621, 0, 0, 0, 0, 100, 0),
+(428980, 30, -6799.52, 837.859, 48.2942, 0, 0, 0, 0, 100, 0),
+(428980, 31, -6790.57, 838.747, 46.5847, 0, 0, 0, 0, 100, 0),
+(428980, 32, -6782.24, 839.347, 45.557, 0, 0, 0, 0, 100, 0),
+(428980, 33, -6775.53, 839.798, 44.4548, 0, 0, 0, 0, 100, 0),
+(428980, 34, -6771.13, 840.716, 43.2823, 0, 0, 0, 0, 100, 0),
+(428980, 35, -6768.05, 842.056, 41.8581, 0, 0, 0, 0, 100, 0),
+(428980, 36, -6766.38, 843.528, 40.6364, 0, 0, 0, 0, 100, 0),
+(428980, 37, -6765.16, 846.657, 38.6168, 0, 0, 0, 0, 100, 0),
+(428980, 38, -6764.21, 849.879, 35.4296, 0, 0, 0, 0, 100, 0),
+(428980, 39, -6765.78, 852.846, 33.5119, 0, 0, 0, 0, 100, 0),
+(428980, 40, -6767.6, 855.673, 31.411, 0, 0, 0, 0, 100, 0),
+(428980, 41, -6769.01, 861.072, 27.0275, 0, 0, 0, 0, 100, 0),
+(428980, 42, -6767.13, 863.836, 25.1458, 0, 0, 0, 0, 100, 0),
+(428980, 43, -6761.55, 864.132, 22.8287, 0, 0, 0, 0, 100, 0),
+(428980, 44, -6758.69, 860.717, 21.7311, 0, 0, 0, 0, 100, 0),
+(428980, 45, -6753.13, 854.427, 19.4856, 0, 0, 0, 0, 100, 0),
+(428980, 46, -6747.29, 849.174, 17.2199, 0, 0, 0, 0, 100, 0),
+(428980, 47, -6740.16, 844.732, 15.4339, 0, 0, 0, 0, 100, 0),
+(428980, 48, -6734.72, 843.482, 13.2152, 0, 0, 0, 0, 100, 0),
+(428980, 49, -6729.17, 842.805, 10.25, 0, 0, 0, 0, 100, 0),
+(428980, 50, -6723.71, 841.677, 8.73044, 0, 0, 0, 0, 100, 0),
+(428980, 51, -6717.2, 840.173, 8.19204, 0, 0, 0, 0, 100, 0),
+(428980, 52, -6712.86, 838.998, 7.58918, 0, 0, 0, 0, 100, 0),
+(428980, 53, -6719.45, 837.693, 8.75937, 0, 0, 0, 0, 100, 0),
+(428980, 54, -6726.1, 838.553, 9.86451, 0, 0, 0, 0, 100, 0),
+(428980, 55, -6731.47, 841.519, 11.5452, 0, 0, 0, 0, 100, 0),
+(428980, 56, -6737.33, 844.8, 14.5998, 0, 0, 0, 0, 100, 0),
+(428980, 57, -6742.11, 847.346, 15.8703, 0, 0, 0, 0, 100, 0),
+(428980, 58, -6747.54, 851.241, 17.4242, 0, 0, 0, 0, 100, 0),
+(428980, 59, -6753.36, 855.527, 19.7496, 0, 0, 0, 0, 100, 0),
+(428980, 60, -6757.56, 860.772, 21.4966, 0, 0, 0, 0, 100, 0),
+(428980, 61, -6760.67, 864.736, 22.5304, 0, 0, 0, 0, 100, 0),
+(428980, 62, -6765.94, 866.564, 23.7228, 0, 0, 0, 0, 100, 0),
+(428980, 63, -6771.53, 866.783, 25.0876, 0, 0, 0, 0, 100, 0),
+(428980, 64, -6770.56, 862.444, 26.4167, 0, 0, 0, 0, 100, 0),
+(428980, 65, -6769.5, 858.642, 28.7127, 0, 0, 0, 0, 100, 0),
+(428980, 66, -6768.43, 855.496, 31.7591, 0, 0, 0, 0, 100, 0),
+(428980, 67, -6767.59, 854.038, 32.7564, 0, 0, 0, 0, 100, 0),
+(428980, 68, -6765.23, 849.588, 35.9659, 0, 0, 0, 0, 100, 0),
+(428980, 69, -6763.93, 846.49, 38.5969, 0, 0, 0, 0, 100, 0),
+(428980, 70, -6766.18, 845.896, 39.4059, 0, 0, 0, 0, 100, 0),
+(428980, 71, -6767.49, 842.215, 41.6066, 0, 0, 0, 0, 100, 0),
+(428980, 72, -6770.32, 840.488, 43.1654, 0, 0, 0, 0, 100, 0),
+(428980, 73, -6773.43, 839.341, 44.1801, 0, 0, 0, 0, 100, 0),
+(428980, 74, -6778.46, 839.636, 44.8266, 0, 0, 0, 0, 100, 0),
+(428980, 75, -6786.27, 839.452, 46.2578, 0, 0, 0, 0, 100, 0),
+(428980, 76, -6792.89, 838.279, 46.9812, 0, 0, 0, 0, 100, 0),
+(428980, 77, -6798.45, 837.722, 48.086, 0, 0, 0, 0, 100, 0),
+(428980, 78, -6805.11, 836.895, 49.4885, 0, 0, 0, 0, 100, 0),
+(428980, 79, -6811.16, 835.878, 49.8527, 0, 0, 0, 0, 100, 0),
+(428980, 80, -6815.42, 830.676, 49.5922, 0, 0, 0, 0, 100, 0),
+(428980, 81, -6816.42, 823.49, 49.6628, 0, 0, 0, 0, 100, 0),
+(428980, 82, -6814.17, 817.202, 50.2865, 0, 0, 0, 0, 100, 0),
+(428980, 83, -6811.93, 810.909, 51.0109, 0, 0, 0, 0, 100, 0),
+(428980, 84, -6809.97, 805.452, 51.3904, 0, 0, 0, 0, 100, 0),
+(428980, 85, -6808.48, 801.26, 51.5449, 0, 0, 0, 0, 100, 0),
+(428980, 86, -6806.07, 795.617, 51.1313, 0, 0, 0, 0, 100, 0),
+(428980, 87, -6803.85, 793.1, 50.9734, 0, 0, 0, 0, 100, 0),
+(428980, 88, -6798.27, 790.459, 51.0938, 0, 0, 0, 0, 100, 0),
+(428980, 89, -6793.29, 787.931, 51.6357, 0, 0, 0, 0, 100, 0),
+(428980, 90, -6791.9, 783.93, 54.0268, 0, 0, 0, 0, 100, 0),
+(428980, 91, -6792.4, 779.466, 57.1378, 0, 0, 0, 0, 100, 0),
+(428980, 92, -6793.43, 774.532, 61.5517, 0, 0, 0, 0, 100, 0),
+(428980, 93, -6794.1, 768.904, 66.8198, 0, 0, 0, 0, 100, 0),
+(428980, 94, -6793.67, 765.591, 69.2785, 0, 0, 0, 0, 100, 0),
+(428980, 95, -6792.64, 762.393, 71.0797, 0, 0, 0, 0, 100, 0),
+(428980, 96, -6791.09, 759.408, 72.8651, 0, 0, 0, 0, 100, 0),
+(428980, 97, -6788.81, 756.945, 74.0066, 0, 0, 0, 0, 100, 0),
+(428980, 98, -6786.38, 754.63, 75.4713, 0, 0, 0, 0, 100, 0),
+(428980, 99, -6782.41, 751.516, 77.5131, 0, 0, 0, 0, 100, 0),
+(428980, 100, -6779.36, 750.115, 78.8973, 0, 0, 0, 0, 100, 0),
+(428980, 101, -6774.37, 750.134, 81.6935, 0, 0, 0, 0, 100, 0),
+(428980, 102, -6771.27, 751.438, 83.9032, 0, 0, 0, 0, 100, 0),
+(428980, 103, -6766.89, 753.936, 84.9862, 0, 0, 0, 0, 100, 0),
+(428980, 104, -6763.87, 755.411, 85.2801, 0, 0, 0, 0, 100, 0),
+(428980, 105, -6761.32, 757.602, 86.3268, 0, 0, 0, 0, 100, 0);
+
+--
+DELETE FROM `creature_formations` WHERE `leaderGUID` = 42897;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(42897,42897,0,0,515,0,0),
+(42897,42898,5.5,360,515,0,0);