From 8822ec69b897567acee6d42965eebab69ec61243 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Mon, 21 Sep 2015 22:22:27 +0200 Subject: DB/Creature: Fix some formations By Malcrom. (cherry picked from commit e49d4632611a360acc08a0adbc86e96caabdf9eb) --- sql/updates/world/2015_10_30_29_world_2015_09_21_08.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/2015_10_30_29_world_2015_09_21_08.sql (limited to 'sql') diff --git a/sql/updates/world/2015_10_30_29_world_2015_09_21_08.sql b/sql/updates/world/2015_10_30_29_world_2015_09_21_08.sql new file mode 100644 index 00000000000..d56b962ad8f --- /dev/null +++ b/sql/updates/world/2015_10_30_29_world_2015_09_21_08.sql @@ -0,0 +1,10 @@ +-- Update formation points +UPDATE `creature_formations` SET `point_1`=1, `point_2`=19 WHERE `leaderGUID`=127045 AND `memberGUID`=127058; +UPDATE `creature_formations` SET `point_1`=4, `point_2`=8 WHERE `leaderGUID`=201706 AND `memberGUID`=201764; +UPDATE `creature_formations` SET `angle`=270,`point_1`=4, `point_2`=7 WHERE `leaderGUID`=201713 AND `memberGUID`=201735; +UPDATE `creature_formations` SET `angle`=260, `point_1`=4, `point_2`=8 WHERE `leaderGUID`=202628 AND `memberGUID` IN (202680); +UPDATE `creature_formations` SET `angle`=100, `point_1`=4, `point_2`=8 WHERE `leaderGUID`=202628 AND `memberGUID` IN (202682); +UPDATE `creature_formations` SET `point_1`=2, `point_2`=7 WHERE `leaderGUID`=202629 AND `memberGUID` IN (202681,202684); +UPDATE `creature_formations` SET `point_1`=1, `point_2`=10 WHERE `leaderGUID`=202692 AND `memberGUID` IN (202695,202696); +UPDATE `creature_formations` SET `point_1`=2, `point_2`=7 WHERE `leaderGUID`=202814 AND `memberGUID` IN (202803,202804); +UPDATE `creature_formations` SET `point_1`=3, `point_2`=6 WHERE `leaderGUID`=202815 AND `memberGUID` IN (202805,202806); -- cgit v1.2.3