diff options
| -rw-r--r-- | sql/updates/world/master/2021_06_16_07_world_2018_01_24_01_world.sql | 47 | ||||
| -rw-r--r-- | sql/updates/world/master/2021_06_16_08_world_2018_01_24_02_world.sql | 113 |
2 files changed, 160 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_06_16_07_world_2018_01_24_01_world.sql b/sql/updates/world/master/2021_06_16_07_world_2018_01_24_01_world.sql new file mode 100644 index 00000000000..cf77e551c19 --- /dev/null +++ b/sql/updates/world/master/2021_06_16_07_world_2018_01_24_01_world.sql @@ -0,0 +1,47 @@ +-- SpawnGroupMapper auto-generated SQL for map 624 (Vault of Archavon) + +-- Constant setter section - adjust this +-- spawn_group_template (4 entries) +SET @FIRSTGROUPID := 28; +-- Boss state associations +SET @ARCHAVON := 0; -- boss state that controls group "Archavon" +SET @EMALON := 1; -- boss state that controls group "Emalon" +SET @KORALON := 2; -- boss state that controls group "Koralon" +SET @TORAVON := 3; -- boss state that controls group "Toravon" + +-- DB modification section - you shouldn't need to touch this +-- Insert spawn group templates +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+3; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES + (@FIRSTGROUPID+0, "Vault of Archavon - Archavon", 0x04), + (@FIRSTGROUPID+1, "Vault of Archavon - Emalon", 0x04), + (@FIRSTGROUPID+2, "Vault of Archavon - Koralon", 0x04), + (@FIRSTGROUPID+3, "Vault of Archavon - Toravon", 0x04); + +-- Insert spawn group data +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+3; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES + (@FIRSTGROUPID+2, 0, 202596), + (@FIRSTGROUPID+2, 0, 202598), + (@FIRSTGROUPID+3, 0, 202600), + (@FIRSTGROUPID+0, 0, 202589), + (@FIRSTGROUPID+0, 0, 202591), + (@FIRSTGROUPID+1, 0, 202593), + (@FIRSTGROUPID+1, 0, 202595), + (@FIRSTGROUPID+2, 0, 202597), + (@FIRSTGROUPID+3, 0, 202606), + (@FIRSTGROUPID+0, 0, 202588), + (@FIRSTGROUPID+0, 0, 202590), + (@FIRSTGROUPID+1, 0, 202594), + (@FIRSTGROUPID+3, 0, 202605); + +-- Link information for instance script +DELETE FROM `instance_spawn_groups` WHERE `instanceMapId` = 624; +INSERT INTO `instance_spawn_groups` (`instanceMapId`, `bossStateId`, `bossStates`, `spawnGroupId`, `flags`) VALUES + (624,@ARCHAVON,0x17,@FIRSTGROUPID+0,0x1), -- Spawn Archavon if state is not DONE + (624,@EMALON,0x17,@FIRSTGROUPID+1,0x1), -- Spawn Emalon if state is not DONE + (624,@KORALON,0x17,@FIRSTGROUPID+2,0x1), -- Spawn Koralon if state is not DONE + (624,@TORAVON,0x17,@FIRSTGROUPID+3,0x1); -- Spawn Toravon if state is not DONE + +-- Remove legacy linked_respawn entries +DELETE lr FROM `linked_respawn` lr INNER JOIN `spawn_group` sg ON sg.`groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+3 AND sg.`spawnType` = (lr.linkType >> 1) AND sg.`spawnId`=lr.`guid`; diff --git a/sql/updates/world/master/2021_06_16_08_world_2018_01_24_02_world.sql b/sql/updates/world/master/2021_06_16_08_world_2018_01_24_02_world.sql new file mode 100644 index 00000000000..294df6dbb94 --- /dev/null +++ b/sql/updates/world/master/2021_06_16_08_world_2018_01_24_02_world.sql @@ -0,0 +1,113 @@ +-- SpawnGroupMapper auto-generated SQL for map 604 (Gundrak) + +-- Constant setter section - adjust this +-- spawn_group_template (5 entries) +SET @FIRSTGROUPID := 32; +-- Boss state associations +SET @SLADRAN := 0; -- boss state that controls group "Slad'ran" +SET @DRAKKARICOLOSSUS := 1; -- boss state that controls group "Drakkari Colossus" +SET @MOORABI := 2; -- boss state that controls group "Moorabi" +SET @GALDARAH := 3; -- boss state that controls group "Gal'darah" +SET @ECKTHEFEROCIOUS := 4; -- boss state that controls group "Eck the Ferocious" + +-- DB modification section - you shouldn't need to touch this +-- Insert spawn group templates +DELETE FROM `spawn_group_template` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+4; +INSERT INTO `spawn_group_template` (`groupId`,`groupName`,`groupFlags`) VALUES + (@FIRSTGROUPID+0, "Gundrak - Slad'ran", 0x04), + (@FIRSTGROUPID+1, "Gundrak - Drakkari Colossus", 0x04), + (@FIRSTGROUPID+2, "Gundrak - Moorabi", 0x04), + (@FIRSTGROUPID+3, "Gundrak - Gal'darah", 0x04), + (@FIRSTGROUPID+4, "Gundrak - Eck the Ferocious", 0x04); + +-- Insert spawn group data +DELETE FROM `spawn_group` WHERE `groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+4; +INSERT INTO `spawn_group` (`groupId`,`spawnType`,`spawnId`) VALUES + (@FIRSTGROUPID+0, 0, 127019), + (@FIRSTGROUPID+2, 0, 127051), + (@FIRSTGROUPID+2, 0, 127067), + (@FIRSTGROUPID+0, 0, 127020), + (@FIRSTGROUPID+2, 0, 127052), + (@FIRSTGROUPID+2, 0, 127068), + (@FIRSTGROUPID+0, 0, 127021), + (@FIRSTGROUPID+2, 0, 127053), + (@FIRSTGROUPID+2, 0, 127069), + (@FIRSTGROUPID+0, 0, 127006), + (@FIRSTGROUPID+0, 0, 127022), + (@FIRSTGROUPID+2, 0, 127054), + (@FIRSTGROUPID+2, 0, 127070), + (@FIRSTGROUPID+0, 0, 127007), + (@FIRSTGROUPID+0, 0, 127023), + (@FIRSTGROUPID+2, 0, 127055), + (@FIRSTGROUPID+1, 0, 127071), + (@FIRSTGROUPID+0, 0, 127008), + (@FIRSTGROUPID+0, 0, 127024), + (@FIRSTGROUPID+2, 0, 127056), + (@FIRSTGROUPID+1, 0, 127072), + (@FIRSTGROUPID+0, 0, 127009), + (@FIRSTGROUPID+0, 0, 127025), + (@FIRSTGROUPID+2, 0, 127057), + (@FIRSTGROUPID+1, 0, 127073), + (@FIRSTGROUPID+4, 0, 127201), + (@FIRSTGROUPID+0, 0, 127010), + (@FIRSTGROUPID+0, 0, 127026), + (@FIRSTGROUPID+0, 0, 127042), + (@FIRSTGROUPID+0, 0, 127058), + (@FIRSTGROUPID+1, 0, 127074), + (@FIRSTGROUPID+4, 0, 127202), + (@FIRSTGROUPID+0, 0, 127011), + (@FIRSTGROUPID+0, 0, 127027), + (@FIRSTGROUPID+2, 0, 127043), + (@FIRSTGROUPID+2, 0, 127059), + (@FIRSTGROUPID+1, 0, 127075), + (@FIRSTGROUPID+4, 0, 127203), + (@FIRSTGROUPID+0, 0, 127012), + (@FIRSTGROUPID+0, 0, 127028), + (@FIRSTGROUPID+3, 0, 127044), + (@FIRSTGROUPID+2, 0, 127060), + (@FIRSTGROUPID+1, 0, 127076), + (@FIRSTGROUPID+4, 0, 127204), + (@FIRSTGROUPID+0, 0, 127013), + (@FIRSTGROUPID+0, 0, 127029), + (@FIRSTGROUPID+0, 0, 127045), + (@FIRSTGROUPID+2, 0, 127061), + (@FIRSTGROUPID+1, 0, 127077), + (@FIRSTGROUPID+4, 0, 127205), + (@FIRSTGROUPID+0, 0, 127014), + (@FIRSTGROUPID+1, 0, 127046), + (@FIRSTGROUPID+2, 0, 127062), + (@FIRSTGROUPID+1, 0, 127078), + (@FIRSTGROUPID+3, 0, 127110), + (@FIRSTGROUPID+4, 0, 127206), + (@FIRSTGROUPID+0, 0, 127015), + (@FIRSTGROUPID+2, 0, 127047), + (@FIRSTGROUPID+2, 0, 127063), + (@FIRSTGROUPID+1, 0, 127079), + (@FIRSTGROUPID+3, 0, 127111), + (@FIRSTGROUPID+3, 0, 127207), + (@FIRSTGROUPID+0, 0, 127016), + (@FIRSTGROUPID+2, 0, 127048), + (@FIRSTGROUPID+2, 0, 127064), + (@FIRSTGROUPID+1, 0, 127080), + (@FIRSTGROUPID+3, 0, 127112), + (@FIRSTGROUPID+0, 0, 127017), + (@FIRSTGROUPID+2, 0, 127049), + (@FIRSTGROUPID+2, 0, 127065), + (@FIRSTGROUPID+1, 0, 127081), + (@FIRSTGROUPID+2, 0, 127113), + (@FIRSTGROUPID+0, 0, 127018), + (@FIRSTGROUPID+2, 0, 127050), + (@FIRSTGROUPID+2, 0, 127066), + (@FIRSTGROUPID+1, 0, 127082); + +-- Link information for instance script +DELETE FROM `instance_spawn_groups` WHERE `instanceMapId` = 604; +INSERT INTO `instance_spawn_groups` (`instanceMapId`, `bossStateId`, `bossStates`, `spawnGroupId`, `flags`) VALUES + (604,@SLADRAN,0x17,@FIRSTGROUPID+0,0x1), -- Spawn Slad'ran if state is not DONE + (604,@DRAKKARICOLOSSUS,0x17,@FIRSTGROUPID+1,0x1), -- Spawn Drakkari Colossus if state is not DONE + (604,@MOORABI,0x17,@FIRSTGROUPID+2,0x1), -- Spawn Moorabi if state is not DONE + (604,@GALDARAH,0x17,@FIRSTGROUPID+3,0x1), -- Spawn Gal'darah if state is not DONE + (604,@ECKTHEFEROCIOUS,0x17,@FIRSTGROUPID+4,0x1); -- Spawn Eck the Ferocious if state is not DONE + +-- Remove legacy linked_respawn entries +DELETE lr FROM `linked_respawn` lr INNER JOIN `spawn_group` sg ON sg.`groupId` BETWEEN @FIRSTGROUPID+0 AND @FIRSTGROUPID+4 AND sg.`spawnType` = (lr.linkType >> 1) AND sg.`spawnId`=lr.`guid`; |