aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2020-07-08 19:44:30 +0200
committerShauren <shauren.trinity@gmail.com>2022-01-22 00:32:22 +0100
commita1de9b0bebce8b2b59e126630f55bd38e31b24f1 (patch)
tree3fe91f50752d2fc9185f40a0a14f35b33d9c8eb2 /sql
parentb0bac6cc59f6eaf0679ec7f1dc16b5da5d962ac5 (diff)
DB/Creature: Adjust some rare creatures respawn time
Closes #24970 (cherry picked from commit e472ef0237ba4d3a7a2ac1374fee9faec1ecdaaf)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_01_21_50_world_2020_07_08_19_world.sql22
1 files changed, 22 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_21_50_world_2020_07_08_19_world.sql b/sql/updates/world/master/2022_01_21_50_world_2020_07_08_19_world.sql
new file mode 100644
index 00000000000..965598599dd
--- /dev/null
+++ b/sql/updates/world/master/2022_01_21_50_world_2020_07_08_19_world.sql
@@ -0,0 +1,22 @@
+-- https://wow.gamepedia.com/Lost_Soul
+UPDATE `creature` SET `spawntimesecs` = 3600 WHERE `id` = 1531;
+-- https://wow.gamepedia.com/Deeb
+UPDATE `creature` SET `spawntimesecs` = 5400 WHERE `id` = 1911;
+-- https://wow.gamepedia.com/Farmer_Solliden
+UPDATE `creature` SET `spawntimesecs` = 3600 WHERE `id` = 1936;
+-- https://wow.gamepedia.com/Bayne
+UPDATE `creature` SET `spawntimesecs` = 3600 WHERE `id` = 10356;
+-- https://wow.gamepedia.com/Ressan_the_Needler
+UPDATE `creature` SET `spawntimesecs` = 5400 WHERE `id` = 10357;
+-- https://wow.gamepedia.com/Fellicent%27s_Shade
+UPDATE `creature` SET `spawntimesecs` = 5400 WHERE `id` = 10358;
+-- https://www.wowhead.com/npc=14231/drogoth-the-roamer#comments:id=358223
+UPDATE `creature` SET `spawntimesecs` = 18000 WHERE `id` = 14231;
+-- https://www.wowhead.com/npc=14236/lord-angler#comments:id=358224
+UPDATE `creature` SET `spawntimesecs` = 75600 WHERE `id` = 14236;
+-- Marticar CMaNGOS
+UPDATE `creature` SET `spawntimesecs` = 82800 WHERE `id` = 18680;
+-- Doomsayer Jurim CMaNGOS
+UPDATE `creature` SET `spawntimesecs` = 21600 WHERE `id` = 18686;
+-- Morcrush CMaNGOS
+UPDATE `creature` SET `spawntimesecs` = 21600 WHERE `id` = 18690;