DB/Creature: Some formations fixes

By Malcrom
(cherry picked from commit e649ec97701041c7cc26a97101a30782256562b7)

1 files changed, 24 insertions, 0 deletions

diff --git a/sql/updates/world/2015_10_31_10_world_2015_09_24_03.sql b/sql/updates/world/2015_10_31_10_world_2015_09_24_03.sql
new file mode 100644
index 00000000000..ea71a59cf1e
--- /dev/null
+++ b/sql/updates/world/2015_10_31_10_world_2015_09_24_03.sql
@@ -0,0 +1,24 @@
+--
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (127649);
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES
+(127649,127649,0,0,2,0,0),
+(127649,127701,3,360,2,9,19),
+(127649,127702,3,40,2,9,19),
+(127649,127670,3,320,2,9,19),
+(127649,127671,3,260,2,9,19);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (127645);
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES
+(127645,127645,0,0,2,0,0),
+(127645,127691,3,360,2,7,15),
+(127645,127692,3,40,2,7,15),
+(127645,127664,3,320,2,7,15),
+(127645,127665,3,260,2,7,15);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (127640);
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES
+(127640,127640,0,0,2,0,0),
+(127640,127685,3,360,2,8,17),
+(127640,127686,3,40,2,8,17),
+(127640,127656,3,320,2,8,17),
+(127640,127657,3,260,2,8,17);