aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--sql/updates/world/3.3.5/2018_01_24_01_world.sql47
-rw-r--r--sql/updates/world/3.3.5/2018_01_24_02_world.sql113
2 files changed, 160 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_01_24_01_world.sql b/sql/updates/world/3.3.5/2018_01_24_01_world.sql
new file mode 100644
index 00000000000..cf77e551c19
--- /dev/null
+++ b/sql/updates/world/3.3.5/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/3.3.5/2018_01_24_02_world.sql b/sql/updates/world/3.3.5/2018_01_24_02_world.sql
new file mode 100644
index 00000000000..294df6dbb94
--- /dev/null
+++ b/sql/updates/world/3.3.5/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`;