From d0d2a1d2bd81e66c973c0a2ae6e522d28427e150 Mon Sep 17 00:00:00 2001 From: offl Date: Mon, 22 Feb 2021 17:14:43 +0200 Subject: DB/Instance/The Eye: Overhaul part 3 (cherry picked from commit d8723fcc15c42a510240da646103242d953b1ac1) --- .../2022_03_06_63_world_2021_02_22_00_world.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/world/master/2022_03_06_63_world_2021_02_22_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_03_06_63_world_2021_02_22_00_world.sql b/sql/updates/world/master/2022_03_06_63_world_2021_02_22_00_world.sql new file mode 100644 index 00000000000..1ae852c56de --- /dev/null +++ b/sql/updates/world/master/2022_03_06_63_world_2021_02_22_00_world.sql @@ -0,0 +1,20 @@ +-- Standardize respawn time +UPDATE `creature` SET `spawntimesecs` = 7200 WHERE `id` BETWEEN 20031 AND 20052 AND `map` = 550; +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (12999,15384,22517) AND `map` = 550; +UPDATE `gameobject` SET `spawntimesecs` = 300 WHERE `id` IN (184069,184324,184325,184326,184327,184328,184329,184596,184597) AND `map` = 550; + +-- Repair linked respawn +UPDATE `spawn_group` SET `groupId` = 46 WHERE `spawnId` IN (12466,12468) AND `spawnType` = 0; +UPDATE `spawn_group` SET `groupId` = 45 WHERE `spawnId` IN (12543,12544) AND `spawnType` = 0; +DELETE FROM `spawn_group` WHERE `spawnId` IN (84484,84444,75558,64992,64991,64988,48255,64990,64989,64993) AND `spawnType` = 0; +INSERT INTO `spawn_group` (`groupId`, `spawnType`, `spawnId`) VALUES +(45,0,84484), +(45,0,84444), +(45,0,75558), +(44,0,64992), +(44,0,64991), +(44,0,64988), +(44,0,48255), +(44,0,64990), +(44,0,64989), +(44,0,64993); -- cgit v1.2.3