diff options
| -rw-r--r-- | sql/updates/world/master/2023_11_06_01_world.sql | 143 |
1 files changed, 143 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_06_01_world.sql b/sql/updates/world/master/2023_11_06_01_world.sql new file mode 100644 index 00000000000..4c15c5b057d --- /dev/null +++ b/sql/updates/world/master/2023_11_06_01_world.sql @@ -0,0 +1,143 @@ +DELETE FROM `spawn_group_template` WHERE `groupId` IN (1032, 1033, 1034, 1035, 1036); +INSERT INTO `spawn_group_template` (`groupId`, `groupName`, `groupFlags`) VALUES +(1032, 'The Lost City of the Tol''vir - General Husam', 4), +(1033, 'The Lost City of the Tol''vir - Lockmaw', 4), +(1034, 'The Lost City of the Tol''vir - High Prophet Barim', 4), +(1035, 'The Lost City of the Tol''vir - Siamat', 4), +(1036, 'The Lost City of the Tol''vir - Siamat Wind Tunnel', 4); + +SET @SPAWNGROUP := 1032; +DELETE FROM `spawn_group` WHERE `groupId`= @SPAWNGROUP; +INSERT INTO `spawn_group` (`groupId`, `spawnType`, `spawnId`) VALUES +(@SPAWNGROUP, 0, 277657), +(@SPAWNGROUP, 0, 285203), +(@SPAWNGROUP, 0, 285205), +(@SPAWNGROUP, 0, 285206), +(@SPAWNGROUP, 0, 285208), +(@SPAWNGROUP, 0, 285209), +(@SPAWNGROUP, 0, 285239), +(@SPAWNGROUP, 0, 285630), +(@SPAWNGROUP, 0, 286161), +(@SPAWNGROUP, 0, 295192), +(@SPAWNGROUP, 0, 304174), +(@SPAWNGROUP, 0, 304188), +(@SPAWNGROUP, 0, 304267), +(@SPAWNGROUP, 0, 306828), +(@SPAWNGROUP, 0, 307201), +(@SPAWNGROUP, 0, 313314), +(@SPAWNGROUP, 0, 313318), +(@SPAWNGROUP, 0, 313319), +(@SPAWNGROUP, 0, 313957), +(@SPAWNGROUP, 0, 314559), +(@SPAWNGROUP, 0, 338938), +(@SPAWNGROUP, 0, 339006), +(@SPAWNGROUP, 0, 339007), +(@SPAWNGROUP, 0, 339008), +(@SPAWNGROUP, 0, 339009), +(@SPAWNGROUP, 0, 339010), +(@SPAWNGROUP, 0, 339011), +(@SPAWNGROUP, 0, 339012), +(@SPAWNGROUP, 0, 339013), +(@SPAWNGROUP, 0, 339014), +(@SPAWNGROUP, 0, 339015), +(@SPAWNGROUP, 0, 339018), +(@SPAWNGROUP, 0, 339019), +(@SPAWNGROUP, 0, 339020), +(@SPAWNGROUP, 0, 339021), +(@SPAWNGROUP, 0, 339027), +(@SPAWNGROUP, 0, 339028), +(@SPAWNGROUP, 0, 339029), +(@SPAWNGROUP, 0, 339030); + +SET @SPAWNGROUP := 1033; +DELETE FROM `spawn_group` WHERE `groupId`= @SPAWNGROUP; +INSERT INTO `spawn_group` (`groupId`, `spawnType`, `spawnId`) VALUES +(@SPAWNGROUP, 0, 314811), +(@SPAWNGROUP, 0, 295183), +(@SPAWNGROUP, 0, 314802), +(@SPAWNGROUP, 0, 339547), +(@SPAWNGROUP, 0, 304182), +(@SPAWNGROUP, 0, 339545), +(@SPAWNGROUP, 0, 304186), +(@SPAWNGROUP, 0, 339568); + +SET @SPAWNGROUP := 1034; +DELETE FROM `spawn_group` WHERE `groupId`= @SPAWNGROUP; +INSERT INTO `spawn_group` (`groupId`, `spawnType`, `spawnId`) VALUES +(@SPAWNGROUP, 0, 266659), +(@SPAWNGROUP, 0, 304160), +(@SPAWNGROUP, 0, 304161), +(@SPAWNGROUP, 0, 304162), +(@SPAWNGROUP, 0, 306829), +(@SPAWNGROUP, 0, 339540), +(@SPAWNGROUP, 0, 339541), +(@SPAWNGROUP, 0, 339549), +(@SPAWNGROUP, 0, 339550), +(@SPAWNGROUP, 0, 339553), +(@SPAWNGROUP, 0, 339554), +(@SPAWNGROUP, 0, 339555), +(@SPAWNGROUP, 0, 339556), +(@SPAWNGROUP, 0, 339559), +(@SPAWNGROUP, 0, 339560), +(@SPAWNGROUP, 0, 339564), +(@SPAWNGROUP, 0, 339565), +(@SPAWNGROUP, 0, 339566), +(@SPAWNGROUP, 0, 339590), +(@SPAWNGROUP, 0, 339591), +(@SPAWNGROUP, 0, 339592), +(@SPAWNGROUP, 0, 339593), +(@SPAWNGROUP, 0, 339595), +(@SPAWNGROUP, 0, 339597), +(@SPAWNGROUP, 0, 339598), +(@SPAWNGROUP, 0, 339599), +(@SPAWNGROUP, 0, 339603), +(@SPAWNGROUP, 0, 339604), +(@SPAWNGROUP, 0, 339605), +(@SPAWNGROUP, 0, 339607), +(@SPAWNGROUP, 0, 339608), +(@SPAWNGROUP, 0, 339611), +(@SPAWNGROUP, 0, 339612), +(@SPAWNGROUP, 0, 339613), +(@SPAWNGROUP, 0, 339614), +(@SPAWNGROUP, 0, 339615), +(@SPAWNGROUP, 0, 339616), +(@SPAWNGROUP, 0, 339617), +(@SPAWNGROUP, 0, 339618), +(@SPAWNGROUP, 0, 339628), +(@SPAWNGROUP, 0, 339629), +(@SPAWNGROUP, 0, 339630), +(@SPAWNGROUP, 0, 339631), +(@SPAWNGROUP, 0, 339632), +(@SPAWNGROUP, 0, 339633), +(@SPAWNGROUP, 0, 339634), +(@SPAWNGROUP, 0, 339635), +(@SPAWNGROUP, 0, 339638), +(@SPAWNGROUP, 0, 339639), +(@SPAWNGROUP, 0, 339640), +(@SPAWNGROUP, 0, 339643), +(@SPAWNGROUP, 0, 339644), +(@SPAWNGROUP, 0, 339645), +(@SPAWNGROUP, 0, 339646), +(@SPAWNGROUP, 0, 339649), +(@SPAWNGROUP, 0, 339647), +(@SPAWNGROUP, 0, 339648); + +SET @SPAWNGROUP := 1035; +DELETE FROM `spawn_group` WHERE `groupId`= @SPAWNGROUP; +INSERT INTO `spawn_group` (`groupId`, `spawnType`, `spawnId`) VALUES +(@SPAWNGROUP, 0, 307199); + +SET @SPAWNGROUP := 1036; +DELETE FROM `spawn_group` WHERE `groupId`= @SPAWNGROUP; +INSERT INTO `spawn_group` (`groupId`, `spawnType`, `spawnId`) VALUES +(@SPAWNGROUP, 0, 339654), +(@SPAWNGROUP, 0, 339656), +(@SPAWNGROUP, 0, 339650), +(@SPAWNGROUP, 0, 339653); + +DELETE FROM `instance_spawn_groups` WHERE `instanceMapId`= 755; +INSERT INTO `instance_spawn_groups` (`instanceMapId`, `bossStateId`, `bossStates`, `spawnGroupId`, `flags`) VALUES +(755, 0, 17, 1032, 1), -- Enable group when General Husam is not DONE +(755, 1, 17, 1033, 1), -- Enable group when Lockmaw is not DONE +(755, 2, 17, 1034, 1), -- Enable group when High Prophet Barim is not DONE +(755, 3, 17, 1035, 1); -- Enable group when Siamat is not DONE |