diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_05_06_00_world.sql | 82 |
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); |