DB/MawOfSouls: Added instance spawn groups

1 files changed, 128 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_05_16_02_world.sql b/sql/updates/world/master/2024_05_16_02_world.sql
new file mode 100644
index 00000000000..643d1751442
--- /dev/null
+++ b/sql/updates/world/master/2024_05_16_02_world.sql
@@ -0,0 +1,128 @@
+SET @SPAWNGROUP := 1248;
+
+DELETE FROM `creature` WHERE `guid`=650534; -- Thal'kiel
+
+DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN @SPAWNGROUP+0 AND @SPAWNGROUP+2;
+INSERT INTO `spawn_group_template` (`groupId`, `groupName`, `groupFlags`) VALUES
+(@SPAWNGROUP+0, 'The Maw of Souls - Ymiron, the Fallen King', 4),
+(@SPAWNGROUP+1, 'The Maw of Souls - Harbaron', 4),
+(@SPAWNGROUP+2, 'The Maw of Souls - Helya', 4);
+
+DELETE FROM `spawn_group` WHERE `groupId` BETWEEN @SPAWNGROUP+0 AND @SPAWNGROUP+2;
+INSERT INTO `spawn_group` (`groupId`, `spawnType`, `spawnId`) VALUES
+-- Ymiron
+(@SPAWNGROUP+0, 0, 650507),
+(@SPAWNGROUP+0, 0, 650481),
+(@SPAWNGROUP+0, 0, 650506),
+(@SPAWNGROUP+0, 0, 650499),
+(@SPAWNGROUP+0, 0, 650488),
+(@SPAWNGROUP+0, 0, 650509),
+(@SPAWNGROUP+0, 0, 650515),
+(@SPAWNGROUP+0, 0, 650485),
+(@SPAWNGROUP+0, 0, 650511),
+(@SPAWNGROUP+0, 0, 650471),
+(@SPAWNGROUP+0, 0, 650493),
+(@SPAWNGROUP+0, 0, 650494),
+(@SPAWNGROUP+0, 0, 650477),
+(@SPAWNGROUP+0, 0, 650472),
+(@SPAWNGROUP+0, 0, 650489),
+(@SPAWNGROUP+0, 0, 650497),
+(@SPAWNGROUP+0, 0, 650500),
+(@SPAWNGROUP+0, 0, 650498),
+(@SPAWNGROUP+0, 0, 650470),
+(@SPAWNGROUP+0, 0, 650490),
+(@SPAWNGROUP+0, 0, 650469),
+(@SPAWNGROUP+0, 0, 650473),
+(@SPAWNGROUP+0, 0, 650474),
+(@SPAWNGROUP+0, 0, 650478),
+(@SPAWNGROUP+0, 0, 650479),
+(@SPAWNGROUP+0, 0, 650480),
+(@SPAWNGROUP+0, 0, 650482),
+(@SPAWNGROUP+0, 0, 650483),
+(@SPAWNGROUP+0, 0, 650484),
+(@SPAWNGROUP+0, 0, 650486),
+(@SPAWNGROUP+0, 0, 650487),
+(@SPAWNGROUP+0, 0, 650491),
+(@SPAWNGROUP+0, 0, 650492),
+(@SPAWNGROUP+0, 0, 650496),
+(@SPAWNGROUP+0, 0, 650501),
+(@SPAWNGROUP+0, 0, 650503),
+(@SPAWNGROUP+0, 0, 650504),
+(@SPAWNGROUP+0, 0, 650508),
+(@SPAWNGROUP+0, 0, 650510),
+(@SPAWNGROUP+0, 0, 650512),
+(@SPAWNGROUP+0, 0, 650513),
+(@SPAWNGROUP+0, 0, 650514),
+(@SPAWNGROUP+0, 0, 650552),
+(@SPAWNGROUP+0, 0, 650577),
+(@SPAWNGROUP+0, 0, 650476),
+(@SPAWNGROUP+0, 0, 650502),
+(@SPAWNGROUP+0, 0, 650495),
+-- Harbaron
+(@SPAWNGROUP+1, 0, 650572),
+(@SPAWNGROUP+1, 0, 650576),
+(@SPAWNGROUP+1, 1, 400184),
+(@SPAWNGROUP+1, 1, 400185),
+(@SPAWNGROUP+1, 1, 400182),
+(@SPAWNGROUP+1, 1, 400186),
+(@SPAWNGROUP+1, 0, 650521),
+(@SPAWNGROUP+1, 0, 650525),
+(@SPAWNGROUP+1, 0, 650553),
+(@SPAWNGROUP+1, 0, 650526),
+(@SPAWNGROUP+1, 0, 650516),
+(@SPAWNGROUP+1, 0, 650533),
+(@SPAWNGROUP+1, 0, 650520),
+(@SPAWNGROUP+1, 0, 650536),
+(@SPAWNGROUP+1, 0, 650539),
+(@SPAWNGROUP+1, 0, 650554),
+(@SPAWNGROUP+1, 0, 650532),
+(@SPAWNGROUP+1, 0, 650557),
+(@SPAWNGROUP+1, 0, 650556),
+(@SPAWNGROUP+1, 0, 650550),
+(@SPAWNGROUP+1, 0, 650548),
+(@SPAWNGROUP+1, 0, 650545),
+(@SPAWNGROUP+1, 0, 650531),
+(@SPAWNGROUP+1, 0, 650538),
+(@SPAWNGROUP+1, 0, 650528),
+(@SPAWNGROUP+1, 0, 650558),
+(@SPAWNGROUP+1, 0, 650555),
+(@SPAWNGROUP+1, 0, 650580),
+(@SPAWNGROUP+1, 0, 650579),
+(@SPAWNGROUP+1, 0, 650565),
+(@SPAWNGROUP+1, 0, 650578),
+(@SPAWNGROUP+1, 0, 650547),
+(@SPAWNGROUP+1, 0, 650542),
+(@SPAWNGROUP+1, 0, 650559),
+(@SPAWNGROUP+1, 0, 650574),
+(@SPAWNGROUP+1, 0, 650575),
+(@SPAWNGROUP+1, 0, 650560),
+(@SPAWNGROUP+1, 0, 650562),
+(@SPAWNGROUP+1, 0, 650573),
+(@SPAWNGROUP+1, 0, 650569),
+(@SPAWNGROUP+1, 0, 650563),
+(@SPAWNGROUP+1, 0, 650564),
+(@SPAWNGROUP+1, 0, 650570),
+(@SPAWNGROUP+1, 0, 650567),
+(@SPAWNGROUP+1, 0, 650566),
+-- Helya
+(@SPAWNGROUP+2, 1, 400147),
+(@SPAWNGROUP+2, 1, 400148),
+(@SPAWNGROUP+2, 1, 400150),
+(@SPAWNGROUP+2, 1, 400153),
+(@SPAWNGROUP+2, 1, 400157),
+(@SPAWNGROUP+2, 1, 400155),
+(@SPAWNGROUP+2, 1, 400151),
+(@SPAWNGROUP+2, 1, 400154),
+(@SPAWNGROUP+2, 1, 400149),
+(@SPAWNGROUP+2, 1, 400160),
+(@SPAWNGROUP+2, 1, 400158),
+(@SPAWNGROUP+2, 1, 400161),
+(@SPAWNGROUP+2, 1, 400143),
+(@SPAWNGROUP+2, 1, 400159),
+(@SPAWNGROUP+2, 1, 400170);
+
+DELETE FROM `instance_spawn_groups` WHERE `instanceMapId`=1492;
+INSERT INTO `instance_spawn_groups` (`instanceMapId`, `bossStateId`, `bossStates`, `spawnGroupId`, `flags`) VALUES
+(1492, 0, 23, @SPAWNGROUP+0, 1), -- Ymiron
+(1492, 1, 23, @SPAWNGROUP+1, 1), -- Harbaron
+(1492, 2, 23, @SPAWNGROUP+2, 1); -- Helya