diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_02_04_world_2020_05_04_04_world.sql | 315 |
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; |