DB/Creature: Standardize creature respawn time part 10

Closes #25075

(cherry picked from commit 5b863acf9285d675a61819d939f38297f49d5c92)

1 files changed, 8 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_24_23_world_2020_07_31_25_world.sql b/sql/updates/world/master/2022_01_24_23_world_2020_07_31_25_world.sql
new file mode 100644
index 00000000000..22bd6e518d9
--- /dev/null
+++ b/sql/updates/world/master/2022_01_24_23_world_2020_07_31_25_world.sql
@@ -0,0 +1,8 @@
+--
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (29915,29937,29939,29942,29944,29945,29947,29951,29974,29975,30007,30009,30053,30058,30066,30078,30098,30102,30120,30135,30136,30144,30156,30177,30187,30193,30235,30242,30246,30247,30268,30273,30281,30291,30292,30298,30302,30322,30325,30337,30361,30395,30400,30407,30446,30450,30454,30469,30472,30488,30489,30499,30500,30669,30685,30696,30704,30719,30739,30740,30842,30845,30846,30847,30848,30849,30869,30870,30872,30875,30876,30877,30894,30920,31004,31015,31040,31077,31226,31237,31254,31294,31314,31320,31321,31323,31324,31325,31326,31327,31400,31401,31402,31428,31435,31646,31648,31691,31693,31721,31754,31768,31769,31773,31780,31863,31864,31865,31898,31899,32195,32196,32197,32199,32241,32263,32274,32294,32296,32317,32414,32427,32430,32442,32444,32525,32526,32533,32569,32616,32617,32618,32619,32620,32621,32622,32623,32624,32625,32734,32735,32737,32800,33007,33008,33018,33019,33025,33026,33027,33222,33223,33225,33229,33243,33272,33285,33291,33303,33306,33307,33309,33310,33312,33315,33335,33382,33383,33384,33417,33422,33434,33435,33447,33459,33460,33462,33463,33465,33467,33468,33469,33473,33474,33476,33477,33479,33480,33481,33498,33499,33513,33518,33522,33537,33538,33539,33540,33541,33542,33543,33544,33545,33546,33547,33548,33549,33553,33554,33555,33556,33557,33558,33559,33560,33561,33562,33564,33565,33566,33580,33581,33583,33586,33587,33588,33589,33590,33591,33592,33593,33594,33595,33596,33597,33598,33625,33643,33646,33647,33648,33649,33650,33652,33653,33654,33655,33656,33657,33738,33739,33740,33743,33744,33745,33746,33747,33748,33749,33759,33762,33763,33769,33770,33771,33778,33787,33788,33790,33791,33792,33793,33794,33795,33796,33798,33799,33800,33842,33843,33849,33853,33865,33868,33869,33870,33921,33922,33923,33925,33926,33927,33936,33937,33938,33963,33964,33970,33971,33972,33973,33974,34087,34092,34095,34180,34210,34244,34252,34319,34330,34365,34381,34386,34387,34489,34490,34519,34520,34716,34728,34734,34735,34771,34772,34788,34794,34808,34810,34838,34839,34852,34880,34881,34882,34885,34907,34912,34947,34952,34953,34956,34984,35009,35070,35079,35080,35083,35084,35089,35090,35092,35094,35097,35098,35102,35104,35105,35106,35113,35117,35131,35132,35133,35135,35254,35256,35290,35291,35292,35293,35318,35319,35324,35344,35462,35467,35471,35472,35475,35483,35494,35495,35496,35497,35498,35499,35500,35501,35507,35508,35573,35574,35575,35576,35577,35578,35579,35580,35594,35607,35608,35790,35808,35826,36069,36101,36102,36155,36209,36223,36506,36624,36642,36656,36657,36669,36670,36774,36776,37742,37826,37827,37832,37852,37878,37894,37965,37967,37968,38294,38751,39172,39173,40160) AND `map` = 571;
+-- 631 Icecrown Citadel
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (30298,32780,36171,36659,36848,36934,37231,37528,37702,37744,37824,37947,37948,38317,38319,38569,38879,39010) AND `map` = 631;
+UPDATE `creature` SET `spawntimesecs` = 604800 WHERE `id` IN (36612,36626,36627,36678,36855,37025,37217,37533,37534,37955) AND `map` = 631;
+-- 668 Halls of Reflection
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (36736,37704,37906) AND `map` = 668;
+UPDATE `creature` SET `spawntimesecs` = 86400 WHERE `id` IN (36723,38112,38113) AND `map` = 668;