DB/Creature: Standardize creature respawn time, remove wrong spawns part 5

Closes #24936

(cherry picked from commit 49755908248cb7ffb72a9a095736cded6f105323)

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_21_37_world_2020_07_08_05_world.sql b/sql/updates/world/master/2022_01_21_37_world_2020_07_08_05_world.sql
new file mode 100644
index 00000000000..ae65b9565a4
--- /dev/null
+++ b/sql/updates/world/master/2022_01_21_37_world_2020_07_08_05_world.sql
@@ -0,0 +1,11 @@
+--
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` = 180 AND `id` IN (25882,25885,25981,26007,26012,26075,26307,26309,26324,26325,26326,26327,26328,26329,26330,26331,26332,26426,26451,26483,26496,26521,26546,26547,26548,26606,26607,26724,26738,26739,26740,26741,26742,26743,26744,26745,26747,26748,26749,26751,26752,26753,26754,26755,26756,26757,26758,26759,26760,26765);
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` = 120 AND `id` IN (347,349,620,721,857,907,1231,1293,1379,1420,2302,2804,2914,3287,3300,3890,4049,4075,5118,5403,5406,5674,5890,5891,5951,6073,6115,6145,6271,6368,6491,7395,11697,11942,12197,12198,12341,12342,12343,12346,12349,12350,12372,12373,12374,12864,13321,14543,14544,14545,14546,14547,14548,14558,14822,14823,14827,14828,14829,14832,14833,14841,14844,14845,14846,14847,14849,14860,14864,14865,14866,14867,14868,14869,14871,14881,14942,14981,14982,14990,14991,15006,15007,15008,15102,15103,15105,15106,15186,15214,15218,15241,15303,15350,15351,15353,15724,15730,15732,15891,15892,15893,15894,15895,15897,15898,16030,16069,16183,16192,16196,16204,16221,16226,16232,16239,16240,16253,16291,16348,16349,16352,16354,16355,16358,16404,16405,16465,16466,16480,16499,16500,16503,16509,16541,16553,16592,16626,16632,16657,16693,16694,16695,16696,16705,16707,16709,16710,16724,16725,16726,16727,16728,16731,16733,16735,16736,16739,16743,16745,16746,16747,16751,16755,16756,16763,16765,16766,16771,16773,16774,16781,16817,16818,16852,16904,16906,16920,16977,17002,17004,17008,17039,17060,17062,17071,17101,17117,17120,17146,17147,17222,17242,17404,17405,17417,17418,17425,17436,17483,17485,17488,17510,17511,17530,17538,17600,7584,10360,10445,11156,17714,17773,17794,17795,17849,17929,17930,18034,18183,18204,18209,18230,18233,18237,18240,18348,18349,18350,18729,18733,18800,18815,18896,18915,18927,19028,19029,19032,19076,19163,19164,19169,19171,19443,19672,19673,19674,19677,19687,19698,19757,19760,19778,20114,20118,20119,20120,20158,20227,20269,20271,20272,20273,20274,20276,20339,20362,20374,20381,20382,20383,20384,20385,20386,20388,20390,20395,20604,20677,20678,20679,20847,20850,20872,21008,21173,21235,21292,21307,21347,21501,21699,21788,21795,21879,21971,22013,22015,22829,22831,22838,22839,22842,22843,22866,22934,23033,23040,23081,23101,23102,23106,23107,23108,23131,23143,23286,23291,23308,23311,23340,23342,23344,23345,23346,23348,23370,23376,23381,23427,23433,23437,23461,23462,23463,23464,23465,23466,23482,23488,23489,23507,23510,23511,23527,23528,23529,23530,23531,23537,23619,23623,23624,23625,23626,23699,23700,23702,23703,23706,23730,23740,23745,23746,23747,23749,23755,23766,23771,23784,23785,23808,23830,23837,23839,23840,23842,23845,23850,23852,23853,23854,23855,23888,24014,24018,24021,24029,24038,24042,24048,24050,24052,24053,24054,24055,24056,24057,24058,24066,24076,24109,24110,24174,24177,24186,24195,24209,24226,24228,24229,24250,24253,24254,24255,24270,24277,24282,24328,24364,24369,24370,24372,24373,24437,24439,24456,24484,24495,24501);
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` != 300 AND `id` IN (68,332,525,678,679,680,709,710,721,822,871,873,875,877,879,883,1095,1412,1976,2110,2330,2331,2635,2914,3504,4075,4076);
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` != 300 AND `id` IN (27666,27703,27705,27707,27711,27806,27810,27811,27812,27813,27814,27815,27816,27817,27818,27819,27820,28049,28050,28051,28052,28058,28060,28126,28329,28347,28355,28481,28486,28573,29093,29095,29141,29142,29143,29144,29145,29152,29154,29203,29205,29207,29208,29212,29239,29287,29288,29289,29290,29291,29292,29293,29294,29295,29296,29297,29298,29299,29300,29588,29589,29712,29865,29866,29868,29873,30217,30566,30567,30611,30627,30706,30709,30710,30711,30713,30715,30716,30717,30723,30724,30727,30729,30730,30731,30732,30733,30734,31144,32380,32381,32383,32405,32407,32542,32543,32545,32546,32666,32667,32832,32834,33068,33608,33609,33610,33611,33612,33613,33614,33615,33616,33617,33618,33619,33621,33623,33631,33633,33634,33635,33636,33637,33640,33641,33674,33675,33676,33677,33678,33680,33681,33682,33683,33684,33712,33713,33915,33916,33917,33918,33919,33920,33924,33928,33929,33930,33931,33932,33933,33934,33935,33939,33940,33941,33996,34038,34043,34063,34075,34078,34081,34088,34089,34090,34091,34093,34094,34158,34238,34281,34382,34383,34476,34477,34478,34479,34480,34481,34482,34483,34484,34526,34766,34948,34949,34950,34951,35068,35093,35100,35168,35169,35243,35244,35246,35247,35248,35250,35251,35252,35253,35258,35259,35260,35261,35281,35364,35365,35477,36208,36213,36217,36479,36481,36817,37512,37523,37543,37574,37707,37915,37964,37981,40184,40187,40204,40218,40222,40253,40256,40257,40301,40352,40356,40392,40405,40441,40607);
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` != 300 AND `id` IN (23233,23253,23256,23263,23268,23272,23280,23300,23310,23316,23334,23335,23347,23362,23363,23373,23392,23413,23428,23473,23724,23761,23830,23858,23948,23988,24393,24416,24436,24437,24545,24728,24851,24866,24881,24885,24905,24920,24921,24922,24925,24928,24936,24974,24980,24991,25034,25035,25036,25037,25045,25046,25063,25088,25108,25133,25134,25135,25136,25137,25138,25140,25141,25142,25143,25153,25155,25192,25195,25196,25200,25202,25207,25223,25225,25580,25931,25933,25953,25975,25991,25994,26113,26123);
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `spawntimesecs` != 300 AND `id` IN (6491,15351,19227,19169,20086,20431,21180,21505,21725,21727,21743,22014,22026,22097,22098,22101,22237,22266,22270,22271,22819,22823,22836,22922,22940,22995,23110,23112,23120,23560);
+
+-- Wrong spawns, summoned or spawns only after specific events
+DELETE FROM `creature` WHERE `id` IN (15241,17039);
+DELETE FROM `spawn_group` WHERE `spawnId` = 86010 AND `spawnType`=0;