From d161c928e3e6a77558a6729a398e1ead77e84144 Mon Sep 17 00:00:00 2001 From: offl Date: Sat, 4 Jul 2020 02:23:01 +0200 Subject: DB/Creature: Standardize and adjust creature respawn time part 4 Closes #24882 (cherry picked from commit 710cad3c59e1b28b26c680b1eab6224c007091dd) --- .../master/2022_01_21_13_world_2020_07_03_06_world.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/master/2022_01_21_13_world_2020_07_03_06_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2022_01_21_13_world_2020_07_03_06_world.sql b/sql/updates/world/master/2022_01_21_13_world_2020_07_03_06_world.sql new file mode 100644 index 00000000000..739f2333cf0 --- /dev/null +++ b/sql/updates/world/master/2022_01_21_13_world_2020_07_03_06_world.sql @@ -0,0 +1,13 @@ +-- +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` = 540 AND `id` NOT IN (1061,5186); +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` = 550 AND `id` NOT IN (5760,4686,4687); +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` = 644; +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` = 180 AND `id` NOT IN (18558,23188) AND `id` < 23689; +-- Grik'nir the Cold +UPDATE `creature` SET `spawntimesecs` = 100 WHERE `id` = 808; -- https://www.wowhead.com/npc=808/griknir-the-cold#comments:id=148734 +-- Old Icebeard +UPDATE `creature` SET `spawntimesecs` = 90 WHERE `id` = 1271; -- https://www.wowhead.com/npc=1271/old-icebeard#comments:id=551613 +-- Mangeclaw +UPDATE `creature` SET `spawntimesecs` = 60 WHERE `id` = 1961; -- Wowhead +-- Lakka +UPDATE `creature` SET `spawntimesecs` = 86400 WHERE `id` = 18956; -- cgit v1.2.3