DB/Loot: Restore some incorrectly removed references

Closes #24559

(cherry picked from commit 6df0b7acdbfb83df2ba45355f59c648eae8a4213)

1 files changed, 315 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_02_04_world_2020_05_04_04_world.sql b/sql/updates/world/master/2022_01_02_04_world_2020_05_04_04_world.sql
new file mode 100644
index 00000000000..45938d9bbc1
--- /dev/null
+++ b/sql/updates/world/master/2022_01_02_04_world_2020_05_04_04_world.sql
@@ -0,0 +1,315 @@
+--
+UPDATE `creature_loot_template` SET `Item` = 24047 WHERE `Entry` = 1653 AND `Reference` = 24047;
+DELETE FROM `creature_loot_template` WHERE
+(`Reference` = 24016 AND `Entry` IN (1045,1046,1047,1048,1049)) OR
+(`Reference` = 24017 AND `Entry` IN (1045,1046,1047,1048,1049)) OR
+(`Reference` = 24018 AND `Entry` IN (1046,1047,1048,1049)) OR
+(`Reference` = 24019 AND `Entry` IN (1046,1048,1049)) OR
+(`Reference` = 24020 AND `Entry` IN (1048,1049)) OR
+(`Reference` = 24022 AND `Entry` IN (16844,16846,16847,16857,16863,16871,16873,16876,16878,16879,16880,16901,16903,16904,16905,16906,16907,16925,16927,16928,16929,16932,16933,16946,16947,16950,16951,16954,16960,16964,16968,16972,16973,16974,16975,16977,16978,16992,17014,17039,17053,17259,17370,17401,18077,18079,18113,18114,18122,18124,18128,18130,18132,18134,18136,18137,18138,18213,18281,18827,18952,18975,18977,18981,19189,19190,19261,19263,19295,19408,19413,19414,19415,19422,19423,19424,19434,19442,19443,19457,19458,19459,19527,19701,19706,19946,19947,20079,20088,20115,20196,20283,20290,20291,20324,20387)) OR
+(`Reference` = 24023 AND `Entry` IN (16844,16857,16904,16905,16906,16932,18827,16863,16871,16873,16927,16947,16954,16960,16974,16975,17053,18077,18079,18130,18132,18138,18213,18977,19189,19422,19423,19424,19442,19459,20115,20387,16846,16878,16880,16901,16903,16928,16929,16933,16946,16951,16964,16968,16973,16977,16978,17014,17039,18113,18114,18122,18124,18128,18134,18136,18137,18281,19263,19295,19408,19413,19414,19415,19443,19457,19527,19706,19946,19947,20079,20088,20196,20283,20290,20291,20324,20798,16867,16870,16911,16912,16934,16966,16967,17034,18080,18086,18087,18115,18116,18117,18118,18119,18123,18129,18131,18133,18159,18214,18280,18282,18283,18340,19192,19282,19298,19312,19335,19349,19350,19402,19410,19411,19732,20089,20090,20197,20198,20270,20279,20280,20292,20294,20295,20443,20792)) OR
+(`Reference` = 24024 AND `Entry` IN (1049,1494)) OR
+(`Reference` = 24025 AND `Entry` IN (193,1063,1492,1493,1494,1559)) OR
+(`Reference` = 24026 AND `Entry` IN (193,1493,1559)) OR
+(`Reference` = 24027 AND `Entry` IN (193,1493,1494,1559)) OR
+(`Reference` = 24028 AND `Entry` IN (193)) OR
+(`Reference` = 24029 AND `Entry` IN (193,1045,1046,1494,1559)) OR
+(`Reference` = 24030 AND `Entry` IN (193)) OR
+(`Reference` = 24031 AND `Entry` IN (1045,1046,1047,1048,1559)) OR
+(`Reference` = 24033 AND `Entry` IN (1045,1046,1047,1048,1049,1559)) OR
+(`Reference` = 24034 AND `Entry` IN (1046,1047,1048,1049)) OR
+(`Reference` = 24036 AND `Entry` IN (193,1045,1046,1047,1048,1049,1049,1088,1551,1559,1561,1653,2611));
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES
+(1045,24016,24016,1,0,1,1,1,1),
+(1046,24016,24016,1,0,1,1,1,1),
+(1047,24016,24016,1,0,1,1,1,1),
+(1048,24016,24016,1,0,1,1,1,1),
+(1049,24016,24016,1,0,1,1,1,1),
+(1045,24017,24017,0.5,0,1,1,1,1),
+(1046,24017,24017,0.5,0,1,1,1,1),
+(1047,24017,24017,0.5,0,1,1,1,1),
+(1048,24017,24017,0.5,0,1,1,1,1),
+(1049,24017,24017,0.5,0,1,1,1,1),
+(1046,24018,24018,1,0,1,1,1,1),
+(1047,24018,24018,1,0,1,1,1,1),
+(1048,24018,24018,1,0,1,1,1,1),
+(1049,24018,24018,1,0,1,1,1,1),
+(1046,24019,24019,0.5,0,1,1,1,1),
+(1048,24019,24019,0.5,0,1,1,1,1),
+(1049,24019,24019,0.5,0,1,1,1,1),
+(1048,24020,24020,1,0,1,1,1,1),
+(1049,24020,24020,1,0,1,1,1,1),
+(16844,24022,24022,1,0,1,1,1,1),
+(16846,24022,24022,1,0,1,1,1,1),
+(16847,24022,24022,1,0,1,1,1,1),
+(16857,24022,24022,1,0,1,1,1,1),
+(16863,24022,24022,1,0,1,1,1,1),
+(16871,24022,24022,1,0,1,1,1,1),
+(16873,24022,24022,1,0,1,1,1,1),
+(16876,24022,24022,1,0,1,1,1,1),
+(16878,24022,24022,1,0,1,1,1,1),
+(16879,24022,24022,1,0,1,1,1,1),
+(16880,24022,24022,1,0,1,1,1,1),
+(16901,24022,24022,1,0,1,1,1,1),
+(16903,24022,24022,1,0,1,1,1,1),
+(16904,24022,24022,1,0,1,1,1,1),
+(16905,24022,24022,1,0,1,1,1,1),
+(16906,24022,24022,1,0,1,1,1,1),
+(16907,24022,24022,1,0,1,1,1,1),
+(16925,24022,24022,1,0,1,1,1,1),
+(16927,24022,24022,1,0,1,1,1,1),
+(16928,24022,24022,1,0,1,1,1,1),
+(16929,24022,24022,1,0,1,1,1,1),
+(16932,24022,24022,1,0,1,1,1,1),
+(16933,24022,24022,1,0,1,1,1,1),
+(16946,24022,24022,1,0,1,1,1,1),
+(16947,24022,24022,1,0,1,1,1,1),
+(16950,24022,24022,1,0,1,1,1,1),
+(16951,24022,24022,1,0,1,1,1,1),
+(16954,24022,24022,1,0,1,1,1,1),
+(16960,24022,24022,1,0,1,1,1,1),
+(16964,24022,24022,1,0,1,1,1,1),
+(16968,24022,24022,1,0,1,1,1,1),
+(16972,24022,24022,1,0,1,1,1,1),
+(16973,24022,24022,1,0,1,1,1,1),
+(16974,24022,24022,1,0,1,1,1,1),
+(16975,24022,24022,1,0,1,1,1,1),
+(16977,24022,24022,1,0,1,1,1,1),
+(16978,24022,24022,1,0,1,1,1,1),
+(16992,24022,24022,1,0,1,1,1,1),
+(17014,24022,24022,1,0,1,1,1,1),
+(17039,24022,24022,1,0,1,1,1,1),
+(17053,24022,24022,1,0,1,1,1,1),
+(17259,24022,24022,1,0,1,1,1,1),
+(17370,24022,24022,1,0,1,1,1,1),
+(17401,24022,24022,1,0,1,1,1,1),
+(18077,24022,24022,1,0,1,1,1,1),
+(18079,24022,24022,1,0,1,1,1,1),
+(18113,24022,24022,1,0,1,1,1,1),
+(18114,24022,24022,1,0,1,1,1,1),
+(18122,24022,24022,1,0,1,1,1,1),
+(18124,24022,24022,1,0,1,1,1,1),
+(18128,24022,24022,1,0,1,1,1,1),
+(18130,24022,24022,1,0,1,1,1,1),
+(18132,24022,24022,1,0,1,1,1,1),
+(18134,24022,24022,1,0,1,1,1,1),
+(18136,24022,24022,1,0,1,1,1,1),
+(18137,24022,24022,1,0,1,1,1,1),
+(18138,24022,24022,1,0,1,1,1,1),
+(18213,24022,24022,1,0,1,1,1,1),
+(18281,24022,24022,1,0,1,1,1,1),
+(18827,24022,24022,1,0,1,1,1,1),
+(18952,24022,24022,1,0,1,1,1,1),
+(18975,24022,24022,1,0,1,1,1,1),
+(18977,24022,24022,1,0,1,1,1,1),
+(18981,24022,24022,1,0,1,1,1,1),
+(19189,24022,24022,1,0,1,1,1,1),
+(19190,24022,24022,1,0,1,1,1,1),
+(19261,24022,24022,1,0,1,1,1,1),
+(19263,24022,24022,1,0,1,1,1,1),
+(19295,24022,24022,1,0,1,1,1,1),
+(19408,24022,24022,1,0,1,1,1,1),
+(19413,24022,24022,1,0,1,1,1,1),
+(19414,24022,24022,1,0,1,1,1,1),
+(19415,24022,24022,1,0,1,1,1,1),
+(19422,24022,24022,1,0,1,1,1,1),
+(19423,24022,24022,1,0,1,1,1,1),
+(19424,24022,24022,1,0,1,1,1,1),
+(19434,24022,24022,1,0,1,1,1,1),
+(19442,24022,24022,1,0,1,1,1,1),
+(19443,24022,24022,1,0,1,1,1,1),
+(19457,24022,24022,1,0,1,1,1,1),
+(19458,24022,24022,1,0,1,1,1,1),
+(19459,24022,24022,1,0,1,1,1,1),
+(19527,24022,24022,1,0,1,1,1,1),
+(19701,24022,24022,1,0,1,1,1,1),
+(19706,24022,24022,1,0,1,1,1,1),
+(19946,24022,24022,1,0,1,1,1,1),
+(19947,24022,24022,1,0,1,1,1,1),
+(20079,24022,24022,1,0,1,1,1,1),
+(20088,24022,24022,1,0,1,1,1,1),
+(20115,24022,24022,1,0,1,1,1,1),
+(20196,24022,24022,1,0,1,1,1,1),
+(20283,24022,24022,1,0,1,1,1,1),
+(20290,24022,24022,1,0,1,1,1,1),
+(20291,24022,24022,1,0,1,1,1,1),
+(20324,24022,24022,1,0,1,1,1,1),
+(20387,24022,24022,1,0,1,1,1,1),
+(16844,24023,24023,1,0,1,1,1,1),
+(16857,24023,24023,1,0,1,1,1,1),
+(16904,24023,24023,1,0,1,1,1,1),
+(16905,24023,24023,1,0,1,1,1,1),
+(16906,24023,24023,1,0,1,1,1,1),
+(16932,24023,24023,1,0,1,1,1,1),
+(18827,24023,24023,1,0,1,1,1,1),
+(16863,24023,24023,1,0,1,1,1,1),
+(16871,24023,24023,1,0,1,1,1,1),
+(16873,24023,24023,1,0,1,1,1,1),
+(16927,24023,24023,1,0,1,1,1,1),
+(16947,24023,24023,1,0,1,1,1,1),
+(16954,24023,24023,1,0,1,1,1,1),
+(16960,24023,24023,1,0,1,1,1,1),
+(16974,24023,24023,1,0,1,1,1,1),
+(16975,24023,24023,1,0,1,1,1,1),
+(17053,24023,24023,1,0,1,1,1,1),
+(18077,24023,24023,1,0,1,1,1,1),
+(18079,24023,24023,1,0,1,1,1,1),
+(18130,24023,24023,1,0,1,1,1,1),
+(18132,24023,24023,1,0,1,1,1,1),
+(18138,24023,24023,1,0,1,1,1,1),
+(18213,24023,24023,1,0,1,1,1,1),
+(18977,24023,24023,1,0,1,1,1,1),
+(19189,24023,24023,1,0,1,1,1,1),
+(19422,24023,24023,1,0,1,1,1,1),
+(19423,24023,24023,1,0,1,1,1,1),
+(19424,24023,24023,1,0,1,1,1,1),
+(19442,24023,24023,1,0,1,1,1,1),
+(19459,24023,24023,1,0,1,1,1,1),
+(20115,24023,24023,1,0,1,1,1,1),
+(20387,24023,24023,1,0,1,1,1,1),
+(16846,24023,24023,1,0,1,1,1,1),
+(16878,24023,24023,1,0,1,1,1,1),
+(16880,24023,24023,1,0,1,1,1,1),
+(16901,24023,24023,1,0,1,1,1,1),
+(16903,24023,24023,1,0,1,1,1,1),
+(16928,24023,24023,1,0,1,1,1,1),
+(16929,24023,24023,1,0,1,1,1,1),
+(16933,24023,24023,1,0,1,1,1,1),
+(16946,24023,24023,1,0,1,1,1,1),
+(16951,24023,24023,1,0,1,1,1,1),
+(16964,24023,24023,1,0,1,1,1,1),
+(16968,24023,24023,1,0,1,1,1,1),
+(16973,24023,24023,1,0,1,1,1,1),
+(16977,24023,24023,1,0,1,1,1,1),
+(16978,24023,24023,1,0,1,1,1,1),
+(17014,24023,24023,1,0,1,1,1,1),
+(17039,24023,24023,1,0,1,1,1,1),
+(18113,24023,24023,1,0,1,1,1,1),
+(18114,24023,24023,1,0,1,1,1,1),
+(18122,24023,24023,1,0,1,1,1,1),
+(18124,24023,24023,1,0,1,1,1,1),
+(18128,24023,24023,1,0,1,1,1,1),
+(18134,24023,24023,1,0,1,1,1,1),
+(18136,24023,24023,1,0,1,1,1,1),
+(18137,24023,24023,1,0,1,1,1,1),
+(18281,24023,24023,1,0,1,1,1,1),
+(19263,24023,24023,1,0,1,1,1,1),
+(19295,24023,24023,1,0,1,1,1,1),
+(19408,24023,24023,1,0,1,1,1,1),
+(19413,24023,24023,1,0,1,1,1,1),
+(19414,24023,24023,1,0,1,1,1,1),
+(19415,24023,24023,1,0,1,1,1,1),
+(19443,24023,24023,1,0,1,1,1,1),
+(19457,24023,24023,1,0,1,1,1,1),
+(19527,24023,24023,1,0,1,1,1,1),
+(19706,24023,24023,1,0,1,1,1,1),
+(19946,24023,24023,1,0,1,1,1,1),
+(19947,24023,24023,1,0,1,1,1,1),
+(20079,24023,24023,1,0,1,1,1,1),
+(20088,24023,24023,1,0,1,1,1,1),
+(20196,24023,24023,1,0,1,1,1,1),
+(20283,24023,24023,1,0,1,1,1,1),
+(20290,24023,24023,1,0,1,1,1,1),
+(20291,24023,24023,1,0,1,1,1,1),
+(20324,24023,24023,1,0,1,1,1,1),
+(20798,24023,24023,1,0,1,1,1,1),
+(16867,24023,24023,1,0,1,1,1,1),
+(16870,24023,24023,1,0,1,1,1,1),
+(16911,24023,24023,1,0,1,1,1,1),
+(16912,24023,24023,1,0,1,1,1,1),
+(16934,24023,24023,1,0,1,1,1,1),
+(16966,24023,24023,1,0,1,1,1,1),
+(16967,24023,24023,1,0,1,1,1,1),
+(17034,24023,24023,1,0,1,1,1,1),
+(18080,24023,24023,1,0,1,1,1,1),
+(18086,24023,24023,1,0,1,1,1,1),
+(18087,24023,24023,1,0,1,1,1,1),
+(18115,24023,24023,1,0,1,1,1,1),
+(18116,24023,24023,1,0,1,1,1,1),
+(18117,24023,24023,1,0,1,1,1,1),
+(18118,24023,24023,1,0,1,1,1,1),
+(18119,24023,24023,1,0,1,1,1,1),
+(18123,24023,24023,1,0,1,1,1,1),
+(18129,24023,24023,1,0,1,1,1,1),
+(18131,24023,24023,1,0,1,1,1,1),
+(18133,24023,24023,1,0,1,1,1,1),
+(18159,24023,24023,1,0,1,1,1,1),
+(18214,24023,24023,1,0,1,1,1,1),
+(18280,24023,24023,1,0,1,1,1,1),
+(18282,24023,24023,1,0,1,1,1,1),
+(18283,24023,24023,1,0,1,1,1,1),
+(18340,24023,24023,1,0,1,1,1,1),
+(19192,24023,24023,1,0,1,1,1,1),
+(19282,24023,24023,1,0,1,1,1,1),
+(19298,24023,24023,1,0,1,1,1,1),
+(19312,24023,24023,1,0,1,1,1,1),
+(19335,24023,24023,1,0,1,1,1,1),
+(19349,24023,24023,1,0,1,1,1,1),
+(19350,24023,24023,1,0,1,1,1,1),
+(19402,24023,24023,1,0,1,1,1,1),
+(19410,24023,24023,1,0,1,1,1,1),
+(19411,24023,24023,1,0,1,1,1,1),
+(19732,24023,24023,1,0,1,1,1,1),
+(20089,24023,24023,1,0,1,1,1,1),
+(20090,24023,24023,1,0,1,1,1,1),
+(20197,24023,24023,1,0,1,1,1,1),
+(20198,24023,24023,1,0,1,1,1,1),
+(20270,24023,24023,1,0,1,1,1,1),
+(20279,24023,24023,1,0,1,1,1,1),
+(20280,24023,24023,1,0,1,1,1,1),
+(20292,24023,24023,1,0,1,1,1,1),
+(20294,24023,24023,1,0,1,1,1,1),
+(20295,24023,24023,1,0,1,1,1,1),
+(20443,24023,24023,1,0,1,1,1,1),
+(20792,24023,24023,1,0,1,1,1,1),
+(1049,24024,24024,5,0,1,1,1,1),
+(1494,24024,24024,5,0,1,1,1,1),
+(193,24025,24025,1,0,1,1,1,1),
+(1063,24025,24025,1,0,1,1,1,1),
+(1492,24025,24025,1,0,1,1,1,1),
+(1493,24025,24025,1,0,1,1,1,1),
+(1494,24025,24025,1,0,1,1,1,1),
+(1559,24025,24025,1,0,1,1,1,1),
+(193,24026,24026,0.5,0,1,1,1,1),
+(1493,24026,24026,0.5,0,1,1,1,1),
+(1559,24026,24026,0.5,0,1,1,1,1),
+(193,24027,24027,1,0,1,1,1,1),
+(1493,24027,24027,1,0,1,1,1,1),
+(1494,24027,24027,1,0,1,1,1,1),
+(1559,24027,24027,1,0,1,1,1,1),
+(193,24028,24028,0.5,0,1,1,1,1),
+(193,24029,24029,1,0,1,1,1,1),
+(1045,24029,24029,1,0,1,1,1,1),
+(1046,24029,24029,1,0,1,1,1,1),
+(1494,24029,24029,1,0,1,1,1,1),
+(1559,24029,24029,1,0,1,1,1,1),
+(193,24030,24030,0.5,0,1,1,1,1),
+(1045,24031,24031,1,0,1,1,1,1),
+(1046,24031,24031,1,0,1,1,1,1),
+(1047,24031,24031,1,0,1,1,1,1),
+(1048,24031,24031,1,0,1,1,1,1),
+(1559,24031,24031,1,0,1,1,1,1),
+(1045,24033,24033,1,0,1,1,1,1),
+(1046,24033,24033,1,0,1,1,1,1),
+(1047,24033,24033,1,0,1,1,1,1),
+(1048,24033,24033,1,0,1,1,1,1),
+(1049,24033,24033,1,0,1,1,1,1),
+(1559,24033,24033,1,0,1,1,1,1),
+(1046,24034,24034,0.5,0,1,1,1,1),
+(1047,24034,24034,0.5,0,1,1,1,1),
+(1048,24034,24034,0.5,0,1,1,1,1),
+(1049,24034,24034,0.5,0,1,1,1,1),
+(193,24036,24036,5,0,1,1,1,1),
+(1045,24036,24036,5,0,1,1,1,1),
+(1046,24036,24036,5,0,1,1,1,1),
+(1047,24036,24036,5,0,1,1,1,1),
+(1048,24036,24036,5,0,1,1,1,1),
+(1049,24036,24036,5,0,1,1,1,1),
+(1088,24036,24036,5,0,1,1,1,1),
+(1551,24036,24036,5,0,1,1,1,1),
+(1559,24036,24036,5,0,1,1,1,1),
+(1561,24036,24036,5,0,1,1,1,1),
+(1653,24036,24036,5,0,1,1,1,1),
+(2611,24036,24036,5,0,1,1,1,1);
+
+UPDATE `creature_loot_template` SET `Item` = 24023, `Chance` = 1, `GroupId` = 1 WHERE `Reference` = 24023 AND `Item` != `Reference` AND `GroupId` = 0;