From 0add9dcfc5cb28e078f797b8efef0e393e7b9ec8 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 24 Sep 2015 14:49:31 +0200 Subject: DB/Creature: Some formations fixes By Malcrom (cherry picked from commit e649ec97701041c7cc26a97101a30782256562b7) --- .../world/2015_10_31_10_world_2015_09_24_03.sql | 24 ++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 sql/updates/world/2015_10_31_10_world_2015_09_24_03.sql (limited to 'sql') 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); -- cgit v1.2.3