diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2015-09-21 22:22:27 +0200 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2015-10-30 14:31:52 +0100 |
| commit | 8822ec69b897567acee6d42965eebab69ec61243 (patch) | |
| tree | 4e25f946242bc28f3a30191c8cd43df74af57754 | |
| parent | 19ba85c6263827a0775ec044be451ec82d4761fa (diff) | |
DB/Creature: Fix some formations
By Malcrom.
(cherry picked from commit e49d4632611a360acc08a0adbc86e96caabdf9eb)
| -rw-r--r-- | sql/updates/world/2015_10_30_29_world_2015_09_21_08.sql | 10 |
1 files changed, 10 insertions, 0 deletions
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); |