aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2022_01_21_13_world_2020_07_03_06_world.sql13
1 files changed, 13 insertions, 0 deletions
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;