diff options
| author | offl <offl@users.noreply.github.com> | 2020-07-04 02:23:01 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-07-04 02:23:01 +0200 |
| commit | 710cad3c59e1b28b26c680b1eab6224c007091dd (patch) | |
| tree | 6e4b1a24d7903ce1b5ce3ccbebf5f16c5f8f4a35 | |
| parent | 1f5b9089e25c5fda4857eaa391606741e105ed91 (diff) | |
DB/Creature: Standardize and adjust creature respawn time part 4
Closes #24882
| -rw-r--r-- | sql/updates/world/3.3.5/2020_07_03_06_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_07_03_06_world.sql b/sql/updates/world/3.3.5/2020_07_03_06_world.sql new file mode 100644 index 00000000000..739f2333cf0 --- /dev/null +++ b/sql/updates/world/3.3.5/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; |