diff options
| author | offl <offl@users.noreply.github.com> | 2020-07-04 02:17:10 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-21 18:35:40 +0100 |
| commit | e54e883af19f8f3d6ec7130b591b0fa19785fd36 (patch) | |
| tree | c77c1752c3693e82e97ce5587d799845be7db03d /sql | |
| parent | b0834c9ab591cb831fb9b48871320f908d26fd99 (diff) | |
DB/Creature: Standardize and adjust creature respawn time, remove wrong spawns part 2
Closes #24880
(cherry picked from commit 8754e3ab879f2e2a6fafd0c996c3ad46cec6187e)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_21_11_world_2020_07_03_04_world.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_21_11_world_2020_07_03_04_world.sql b/sql/updates/world/master/2022_01_21_11_world_2020_07_03_04_world.sql new file mode 100644 index 00000000000..3fc9b67dec9 --- /dev/null +++ b/sql/updates/world/master/2022_01_21_11_world_2020_07_03_04_world.sql @@ -0,0 +1,20 @@ +-- +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` IN (190,200,360,400,425,430,444,450,490,498,500,534,543,570,588,700,720,1250,1272,1290,1416,1434,3540,5400); +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (22024,20552,10204,10942); + +-- Won't touch 8 min respawn time of Son of Hodir and Frostworg, at least for now +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` = 480 AND `map` != 571; +-- Won't touch 4 (and 2) min respawn time of Risen Zombie, at least for now +UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` = 240 AND `map` != 595; +-- Bosses +UPDATE `creature` SET `spawntimesecs` = 604800 WHERE `spawntimesecs` = 6380; + +-- Loque'nahak, one of most-wanted rare tamable creature in whole game respawns in 8 min, really? +UPDATE `creature` SET `spawntimesecs` = 21600 WHERE `id` = 32517; -- From wiki +-- Okrek, Outland rare +UPDATE `creature` SET `spawntimesecs` = 28800 WHERE `id` = 18685; -- From 18684 +-- High Tinker Mekkatorque +UPDATE `creature` SET `spawntimesecs` = 600 WHERE `id` = 7937; -- From Wowhead + +-- Wrong spawns, summoned or spawns only after specific events +DELETE FROM `creature` WHERE `id` IN (14350,18381,20436,20792,18297); |