diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_21_12_world_2020_07_03_05_world.sql | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_21_12_world_2020_07_03_05_world.sql b/sql/updates/world/master/2022_01_21_12_world_2020_07_03_05_world.sql new file mode 100644 index 00000000000..44f599040b1 --- /dev/null +++ b/sql/updates/world/master/2022_01_21_12_world_2020_07_03_05_world.sql @@ -0,0 +1,36 @@ +-- 469 Blackwing Lair +UPDATE `creature` SET `spawntimesecs` = 604800 WHERE `spawntimesecs` = 3520 AND `id` = 13996 AND `map` = 469; +-- 509 Ruins of Ahn'Qiraj +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (4076,15384,15426,15475,15476) AND `map` = 509; +UPDATE `creature` SET `spawntimesecs` = 604800 WHERE `id` IN (15339,15340,15341,15348,15369,15370) AND `map` = 509; +-- 531 Ahn'Qiraj Temple +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (4076,15378,15379,15380,15384,15426,15475,15476,15502,15503,15504,15896) AND `map` = 531; +UPDATE `creature` SET `spawntimesecs` = 604800 WHERE `id` IN (15263,15275,15276,15511,15543,15589,15727,15957,15963) AND `map` = 531; + +-- Skipped 532 - 559 + +-- 560 The Escape From Durnholde +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (385,2350,2354,2385,2408,8883,17213,18598,18644,18646,18649,18650,18651,18655,18656,18657,18664,18666,18672,18723,18725,19433,20155,20156,20342,20344,20345,20346,20347,20348,20349,20350,20351,20352,20353,20354,20355,20357,20358,20359,20360,20361,20363,20365,20368,20370,20372,20373,20376,20377,20378,20379,20380,20391,20391,20400,20401,20419,20420,20422,20424,20426,20428,20429,20430,20432,20433,20434,20441,21341,21342,21343,21344,21345) AND `map` = 560; +-- 564 Black Temple +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (1420,2914,14881,22515,22517,22886,22984,23033,23084,23086,23087,23157,23158,23159,23210,23288,23410,23411,23412,23417,23426,23448,23472,23499,23502) AND `map` = 564; +-- 565 Gruul's Lair +UPDATE `creature` SET `spawntimesecs` = 604800 WHERE `id` IN (18832,18834,18835,18836) AND `map` = 565; +-- 568 Zul'Aman +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (1412,14881,21252,22515,22517,23746,23807,23813,23814,23815,23897,24223,24325,24363,24551,25173) AND `map` = 568; +-- 572 Ruins of Lordaeron +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (23193) AND `map` = 572; +-- 574 Utgarde Keep +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (2110,14881,15475,22515,23746) AND `map` = 574; +-- 575 Utgarde Pinnacle +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (2110,14881,15475,19871,22515,23472,27327,28351,30871) AND `map` = 575; +UPDATE `creature` SET `spawntimesecs` = 86400 WHERE `id` IN (27303,27307,27308,27309) AND `map` = 575; +-- 576 The Nexus +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (22515,22517,27048,27837) AND `map` = 576; +UPDATE `creature` SET `spawntimesecs` = 86400 WHERE `id` IN (26796) AND `map` = 576; +-- 578 The Oculus +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (22517,27657,27658,27659) AND `map` = 578; +-- 580 The Sunwell +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (2110,19871,22515,23472,24928,25357,25358,25632,25638,25639,25644,25661,25770,25795,25796,25953,36991,37000,37746,37763,37764,37765,37781,38047,38048,38049,38052,38056) AND `map` = 580 AND `spawntimesecs` != 5; +-- 585 Magister’s Terrace +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (1412,22515,24808,24822,25042,25954,25955,25956,25957,25958,25959,25960,26057,26579) AND `map` = 585; +UPDATE `creature` SET `spawntimesecs` = 86400 WHERE `id` IN (24560,24664,24723,24744) AND `map` = 585; |