DB/Loot: Restore incorrectly removed Copper Ore

Ref  #18182

1 files changed, 82 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_05_06_00_world.sql b/sql/updates/world/3.3.5/2020_05_06_00_world.sql
new file mode 100644
index 00000000000..0c3ebd05233
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_06_00_world.sql
@@ -0,0 +1,82 @@
+-- Restore incorrectly removed Copper Ore
+DELETE FROM `creature_loot_template` WHERE `Item` = 2770;
+INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Chance`,`GroupId`,`MinCount`,`MaxCount`) VALUES
+(300,2770,0.02,0,1,1),
+(327,2770,2.7,0,1,1),
+(448,2770,0.02,0,1,1),
+(475,2770,4.98,0,1,1),
+(580,2770,0.32,0,1,1),
+(598,2770,1.26,0,1,5),
+(623,2770,1.16,0,1,1),
+(624,2770,1.77,0,1,1),
+(711,2770,0.6,0,1,1),
+(824,2770,4,0,1,5),
+(1727,2770,3.9,0,3,5),
+(1731,2770,99.32,0,1,1),
+(1753,2770,0.64,0,1,1),
+(1910,2770,0.34,0,1,1),
+(1953,2770,0.04,0,1,1),
+(1956,2770,0.18,0,1,1),
+(1961,2770,0.74,0,1,1),
+(1972,2770,0.68,0,1,1),
+(2090,2770,1.54,0,1,1),
+(2156,2770,0.08,0,1,1),
+(2157,2770,0.04,0,1,1),
+(2283,2770,0.78,0,1,1),
+(2305,2770,0.04,0,1,1),
+(2850,2770,1.15043,0,1,1),
+(2976,2770,4.98,0,1,1),
+(2978,2770,4.82,0,1,1),
+(2989,2770,4.68,0,1,1),
+(3058,2770,0.08,0,1,1),
+(3203,2770,0.76,0,1,1),
+(3398,2770,3.2,0,1,1),
+(3438,2770,0.38,0,1,1),
+(3578,2770,3.02,0,1,1),
+(3715,2770,3.58798,0,1,1),
+(3727,2770,0.02,0,1,1),
+(3733,2770,0.06,0,1,1),
+(3763,2770,2,0,1,1),
+(4020,2770,0.06,0,1,1),
+(4021,2770,0.04,0,1,1),
+(4022,2770,0.02,0,1,1),
+(4023,2770,0.02,0,1,1),
+(4024,2770,0.04,0,1,1),
+(4025,2770,0.02,0,1,1),
+(4026,2770,0.02,0,1,1),
+(4027,2770,0.02,0,1,1),
+(4028,2770,0.02,0,1,1),
+(4029,2770,0.02,0,1,1),
+(4034,2770,0.07,0,1,1),
+(4036,2770,0.12,0,1,1),
+(4037,2770,0.1,0,1,1),
+(4042,2770,0.1,0,1,1),
+(4044,2770,0.02,0,1,1),
+(4095,2770,0.02,0,1,1),
+(4113,2770,0.04,0,1,1),
+(4120,2770,0.02,0,1,1),
+(4416,2770,1.34,0,1,5),
+(4499,2770,0.16,0,1,1),
+(5055,2770,0.1,0,1,1),
+(5761,2770,0.12,0,1,1),
+(5786,2770,0.76,0,1,1),
+(5808,2770,0.36,0,1,1),
+(5824,2770,0.58,0,1,1),
+(5826,2770,0.66,0,1,1),
+(5837,2770,0.12,0,1,1),
+(5932,2770,1.14,0,1,1),
+(5933,2770,0.48,0,1,1),
+(6113,2770,1.06,0,1,1),
+(6124,2770,0.6,0,1,1),
+(6218,2770,0.02,0,1,1),
+(6391,2770,0.2,0,1,1),
+(6392,2770,0.7,0,1,1),
+(6407,2770,0.4,0,1,1),
+(7849,2770,0.48,0,1,1),
+(12431,2770,0.34,0,1,1),
+(12432,2770,0.14,0,1,1),
+(12433,2770,0.14,0,1,1),
+(12902,2770,0.04,0,1,1),
+(14266,2770,1.68,0,1,1),
+(14268,2770,3.92,0,1,1),
+(14269,2770,0.82,0,1,1);