aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-05-12 19:51:42 +0200
committerKillyana <morphone1@gmail.com>2018-05-12 19:51:42 +0200
commit8391119aa6e56fa29416135e08c728a308db04a9 (patch)
tree426af5bd18a26e534d2b0506f4fe5162eadaf7f2
parent1fdcb2fc586489c594d331d1ea0d87d7f505540e (diff)
DB: Missing formations
-rw-r--r--sql/updates/world/master/2018_05_12_03_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_05_12_03_world.sql b/sql/updates/world/master/2018_05_12_03_world.sql
new file mode 100644
index 00000000000..f3281027b6b
--- /dev/null
+++ b/sql/updates/world/master/2018_05_12_03_world.sql
@@ -0,0 +1,11 @@
+--
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (120830,120831,120833,120832,120836,123124,120835,120834);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(120830, 120830, 0, 0, 515, 0, 0),
+(120830, 120831, 10, 215, 515, 0, 0),
+(120832, 120832, 0, 0, 515, 0, 0),
+(120832, 120833, 10, 215, 515, 0, 0),
+(120834, 120834, 0, 0, 515, 0, 0),
+(120834, 120835, 10, 215, 515, 0, 0),
+(120836, 120836, 0, 0, 515, 0, 0),
+(120836, 123124, 10, 215, 515, 0, 0);