diff options
| -rw-r--r-- | sql/updates/world/master/2024_05_16_02_world.sql | 128 |
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 |