DB/Creature: Add formations & correct waypoints for creatures from Mana-Tombs

(cherry picked from commit 88801630ad56f4db90d689805784a9d1f91b608b)

1 files changed, 95 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_02_27_01_world_2020_09_18_04_world.sql b/sql/updates/world/master/2022_02_27_01_world_2020_09_18_04_world.sql
new file mode 100644
index 00000000000..a0d409a4083
--- /dev/null
+++ b/sql/updates/world/master/2022_02_27_01_world_2020_09_18_04_world.sql
@@ -0,0 +1,95 @@
+-- Waypoints for some creatures are still missing, formations requires adjustments
+-- Creatures: 83315, 83344, 83329, 91202
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (83301,83320,91215,91240,91172);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(83301,83301,0,0,515,0,0),
+(83301,83302,3,270,515,7,12),
+(83320,83320,0,0,515,0,0),
+(83320,83315,4,270,515,0,0),
+(91215,91215,0,0,515,0,0),
+(91215,91216,5,270,515,3,6),
+(91240,91240,0,0,515,0,0),
+(91240,91241,5,270,515,2,4),
+(91172,91172,0,0,515,0,0),
+(91172,91173,3,270,515,0,0);
+
+UPDATE `creature` SET `position_x` = -72.43526, `position_y` = -17.8413, `position_z` = -0.87099, `orientation` = 0.80285 WHERE `guid` = 83301;
+UPDATE `creature` SET `position_x` = -67.27693, `position_y` = -18.9735, `position_z` = -0.871, `orientation` = 2.72743 WHERE `guid` = 83302;
+UPDATE `creature` SET `position_x` = -204.871, `position_y` = -214.858, `position_z` = 0.2629 WHERE `guid` = 83346;
+UPDATE `creature` SET `position_x` = -260.558, `position_y` = -185.374, `position_z` = -0.62035 WHERE `guid` = 91185;
+UPDATE `creature` SET `position_x` = -374.752, `position_y` = -176.951, `position_z` = -0.95391 WHERE `guid` = 91172;
+-- Only random movement
+UPDATE `creature` SET `wander_distance` = 5, `MovementType` = 1 WHERE `guid` = 91235;
+DELETE FROM `creature_addon` WHERE `guid` = 91235;
+
+DELETE FROM `waypoint_data` WHERE `id` IN (833010,912150,912400,911600,833460,911850,911720,912350,912340,912010,911940);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`) VALUES
+(833010,1,-67.99796,-31.6907,-0.9516085),
+(833010,2,-67.722946,-23.282206,-0.952602),
+(833010,3,-65.677895,-14.919224,-0.9472823),
+(833010,4,-60.18082,-8.535985,-0.9498009),
+(833010,5,-53.91151,-2.550814,-0.9489453),
+(833010,6,-46.68223,0.860986,-0.954333),
+(833010,7,-36.528965,1.502573,-0.95433265),
+(833010,8,-46.68223,0.860986,-0.954333),
+(833010,9,-53.91151,-2.550814,-0.9489453),
+(833010,10,-60.18082,-8.535985,-0.9498009),
+(833010,11,-65.677895,-14.919224,-0.9472823),
+(833010,12,-67.722946,-23.282206,-0.952602),
+(912150,1,-118.24131,-209.97723,-0.6744513),
+(912150,2,-136.36037,-214.06665,-0.4485481),
+(912150,3,-143.3705,-220.97308,-0.53293836),
+(912150,4,-136.36037,-214.06665,-0.4485481),
+(912150,5,-118.24131,-209.97723,-0.6744513),
+(912150,6,-111.1761,-219.2728,-0.15511769),
+(912400,1,-49.952377,-221.03786,-0.06442847),
+(912400,2,-73.87033,-218.72505,-0.17712471),
+(912400,3,-49.952377,-221.03786,-0.06442847),
+(912400,4,-32.762417,-223.56038,-0.17517339),
+(911600,1,-106.17904,-213.0709,-1.1736038),
+(911600,2,-98.29801,-220.66646,-1.0128464),
+(911600,3,-90.19468,-229.46202,0.22722928),
+(911600,4,-81.76385,-235.159,-0.0013113776),
+(911600,5,-90.19468,-229.46202,0.22722928),
+(911600,6,-98.29801,-220.66646,-1.0128464),
+(911600,7,-106.17904,-213.0709,-1.1736038),
+(911600,8,-115.79944,-204.35925,-1.289422),
+(833460,1,-203.31392,-226.93602,-0.9557935),
+(833460,2,-204.53967,-238.08087,-0.9558625),
+(833460,3,-212.76714,-245.90474,-0.9559642),
+(833460,4,-204.53967,-238.08087,-0.9558625),
+(833460,5,-203.31392,-226.93602,-0.9557935),
+(833460,6,-204.87102,-214.85806,0.26295376),
+(911850,1,-267.18024,-183.95139,-0.61404943),
+(911850,2,-272.5438,-177.76714,-1.0101689),
+(911850,3,-275.6246,-167.48929,-2.2277827),
+(911850,4,-271.68774,-159.06718,-2.3313134),
+(911850,5,-275.6246,-167.48929,-2.2277827),
+(911850,6,-272.5438,-177.76714,-1.0101689),
+(911850,7,-267.18024,-183.95139,-0.61404943),
+(911850,8,-260.55893,-185.37411,-0.6203554),
+(911720,1,-365.67285,-175.00563,-0.95876896),
+(911720,2,-360.13977,-165.7273,-0.99950916),
+(911720,3,-363.37717,-158.51936,-0.95876485),
+(911720,4,-370.46817,-152.6236,-0.9587616),
+(911720,5,-378.27777,-155.3499,-0.9587638),
+(911720,6,-383.9432,-171.95404,-0.9587667),
+(911720,7,-374.7526,-176.95155,-0.95391774),
+(912340,1,-374.06653,-56.737812,-0.98709744),
+(912340,2,-380.67374,-61.6305,-0.9587699),
+(912340,3,-384.3248,-69.727554,-0.95876795),
+(912340,4,-380.67374,-61.6305,-0.9587699),
+(912340,5,-374.06653,-56.737812,-0.98709744),
+(912340,6,-365.25406,-58.696316,-0.9375797),
+(912340,7,-360.66693,-67.70981,-0.9587661),
+(912340,8,-365.2416,-58.720757,-0.95876634),
+(912010,1,-286.58047,2.692342,16.787771),
+(912010,2,-286.7902,15.48573,18.410303),
+(912010,3,-275.94824,25.733856,22.140972),
+(912010,4,-286.72964,15.542957,18.451094),
+(912010,5,-286.58047,2.692342,16.787771),
+(912010,6,-283.24155,-4.0018206,16.685318),
+(911940,1,-231.31323,9.442994,16.808558),
+(911940,2,-214.384,9.683906,16.860193),
+(911940,3,-231.31323,9.442994,16.808558),
+(911940,4,-246.6945,9.225361,16.794338);