DB/Loot: Remove remaining herbs and ore with low chance to drop pt 4

Closes #24614

1 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2020_05_13_03_world.sql b/sql/updates/world/3.3.5/2020_05_13_03_world.sql
new file mode 100644
index 00000000000..9a4f7b0b000
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_13_03_world.sql
@@ -0,0 +1,10 @@
+-- 
+DELETE FROM `creature_loot_template` WHERE `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND `Entry` IN (300,448,574,616,711,763,813,814,818,947,1696,1753,1837,1839,1843,1910,1936,1961,1972,2090,2184,2186,2192,2283,2420,2421,2422,2423,2431,2452,2453,2476,2541,2603,2604,2605,2781,2793,2931,2932,2944,3203,3398,3435,3438,3773,5343,5346,5347,5786,5799,5808,5823,5824,5826,5833,5834,5837,5841,5859,5916,5932,5933,5935,6113,6124,6585,6648,6649,7016,7017,7073,7290,7319,7665,7666,7667,7668,7728,8210,8212,8213,8282,8283,8298,8299,8977,9602,9681,10197,10202,10356,10357,10644,10647,10663,10664,10806,10817,10827,11714,12037,12046,12159,12207,12339,12431,12432,12433,12900,12902,12918,12940,13139,13419,14221,14225,14227,14231,14266,14268,14269,14273,14277,14279,14339,14340,14342,14343,14427,14428,14429,14430,14431,14445,14446,14475,14487,14535,14536,15205);
+DELETE FROM `creature_loot_template` WHERE `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND `Entry` IN (11374,6391,6392,6407,580,2054,3763,10601,10602,25709,27254,25707,23691,23750,23029,20774,21251);
+DELETE FROM `creature_loot_template` WHERE `Chance` < 0.11 AND `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND `Entry` IN (5849,4844,4846,4849,4113,4116,4416,3727,2976,2978,2989,3578,2305,2269,1727,824,674,624,623,598,475,4020,4021,5881,6218,6219,12223);
+DELETE FROM `creature_loot_template` WHERE `Chance` < 0.20 AND `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND `Entry` IN (4541);
+DELETE FROM `creature_loot_template` WHERE `Chance` < 0.3 AND `Item` IN (765,785,2447,2449,2450,2452,2453,2770,2771,2772,2775,2776,2835,2836,2838,3355,3356,3357,3358,3369,3470,3478,3486,3818,3819,3820,3821,3857,3858,4625,7911,7912,7966,8153,8831,8836,8838,8839,8845,8846,10620,11370,12365,12644,12809,13463,13464,13465,13466,13467,13468,19726,19727,22202,22203,22710,22785,22786,22787,22788,22789,22790,22791,22792,22793,22794,22797,23424,23425,23426,23427,35128,36901,36902,36903,36904,36905,36906,36907,36908,36909,36910,36912,37921) AND `Entry` IN (4499);
+DELETE FROM `creature_loot_template` WHERE `Entry` = 1813 AND `Item` = 12365;
+DELETE FROM `creature_loot_template` WHERE `Entry` = 1040 AND `Item` IN (2770,2835,3357);
+DELETE FROM `creature_loot_template` WHERE `Entry` = 8981 AND `Item` IN (8838,13463);
+DELETE FROM `creature_loot_template` WHERE `Entry` = 7137 AND `Item` IN (8846,8836,13463,13466);