diff options
| author | offl <offl@users.noreply.github.com> | 2020-07-04 02:23:01 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-21 18:36:55 +0100 |
| commit | d161c928e3e6a77558a6729a398e1ead77e84144 (patch) | |
| tree | cd941ab52d28a4041550af4313532cba9410bb14 | |
| parent | 0ba774858394b79dcecfee6882a8280e71a971f2 (diff) | |
DB/Creature: Standardize and adjust creature respawn time part 4
Closes #24882
(cherry picked from commit 710cad3c59e1b28b26c680b1eab6224c007091dd)
| -rw-r--r-- | sql/updates/world/master/2022_01_21_13_world_2020_07_03_06_world.sql | 13 |
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; |