diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2015-09-21 22:22:27 +0200 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2015-09-21 22:22:27 +0200 |
| commit | e49d4632611a360acc08a0adbc86e96caabdf9eb (patch) | |
| tree | ed56677519675c182dae864bf5fa1b2c11c455ca | |
| parent | 57fabc78e42ad7b511ae66d12fbb824d2c8e75ee (diff) | |
DB/Creature: Fix some formations
By Malcrom.
| -rw-r--r-- | sql/updates/world/2015_09_21_08_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2015_09_21_08_world.sql b/sql/updates/world/2015_09_21_08_world.sql new file mode 100644 index 00000000000..d56b962ad8f --- /dev/null +++ b/sql/updates/world/2015_09_21_08_world.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); |