DB/Loot: Restore incorrectly removed Tin Ore

Closes #24590

1 files changed, 43 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_05_10_02_world.sql b/sql/updates/world/3.3.5/2020_05_10_02_world.sql
new file mode 100644
index 00000000000..53060ee6edd
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_10_02_world.sql
@@ -0,0 +1,43 @@
+--
+DELETE FROM `creature_loot_template` WHERE `Item` = 2771 AND `Entry` IN (300,574,580,598,623,624,674,711,824,1727,1732,1972,2054,2269,2283,2305,2420,2450,3398,3435,3578,4020,4021,4113,4116,4416,4499,4844,4846,4849,5849,5933,6391,6392,6407,7849,12433,12902,14273,14427);
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Chance`,`GroupId`,`MinCount`,`MaxCount`) VALUES
+(300,2771,1.02,0,1,1),
+(574,2771,2.36,0,1,1),
+(580,2771,0.32,0,1,1),
+(598,2771,1.74,0,1,5),
+(623,2771,1.44,0,1,1),
+(624,2771,2.174,0,2,5),
+(674,2771,1.44,0,1,1),
+(711,2771,1.36,0,1,1),
+(824,2771,4.92,0,1,5),
+(1727,2771,5.1,0,1,5),
+(1732,2771,99.345,0,1,1),
+(1972,2771,0.78,0,1,1),
+(2054,2771,99.345,0,1,1),
+(2269,2771,1.7,0,1,1),
+(2283,2771,1.04,0,1,1),
+(2305,2771,0.82,0,1,1),
+(2420,2771,0.04,0,1,1),
+(2450,2771,2.12,0,1,1),
+(3398,2771,0.44,0,1,1),
+(3435,2771,0.4,0,1,1),
+(3578,2771,1.2,0,1,1),
+(4020,2771,0.24,0,1,1),
+(4021,2771,0.3,0,1,1),
+(4113,2771,2.4,0,1,1),
+(4116,2771,2.72,0,1,1),
+(4416,2771,1.72,0,1,5),
+(4499,2771,0.26,0,1,1),
+(4844,2771,1.4,0,1,1),
+(4846,2771,1.34,0,1,1),
+(4849,2771,1,0,3,5),
+(5849,2771,3.18,0,1,1),
+(5933,2771,0.23,0,1,1),
+(6391,2771,0.2,0,1,1),
+(6392,2771,0.7,0,1,1),
+(6407,2771,0.4,0,1,1),
+(7849,2771,0.19,0,1,1),
+(12433,2771,0.58,0,1,1),
+(12902,2771,0.2,0,1,1),
+(14273,2771,1.82,0,1,1),
+(14427,2771,3.68,0,1,1);