diff options
author | offl <offl@users.noreply.github.com> | 2020-05-10 16:53:24 +0200 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2022-01-04 00:47:11 +0100 |
commit | 148b534eba2d80fe77ebcbe05d284524e02177bd (patch) | |
tree | 0ee4097a0cd696e51061ff5b4a5bfae075880220 | |
parent | 0faed2df989f9d43a9fc4e55caa5bae3476ab175 (diff) |
DB/Loot: Remove remaining herbs and ore with low chance to drop pt 3
Closes #24591
(cherry picked from commit b518457604a534162508bd4c7a192e995e88ec38)
-rw-r--r-- | sql/updates/world/master/2022_01_04_01_world_2020_05_10_03_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_04_01_world_2020_05_10_03_world.sql b/sql/updates/world/master/2022_01_04_01_world_2020_05_10_03_world.sql new file mode 100644 index 00000000000..84b0a46f99e --- /dev/null +++ b/sql/updates/world/master/2022_01_04_01_world_2020_05_10_03_world.sql @@ -0,0 +1,6 @@ +-- Enraged Foulweald shouldn't have loot table +DELETE FROM `creature_loot_template` WHERE `Entry` = 12921; +UPDATE `creature_template` SET `lootid` = 0 WHERE `entry` = 12921; + +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 (11458,11459,11461,11464,11465,13021,13196,13197,13285,14303,15637,9601); +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 (678,679,680,709,710,2564,2573,2574,2719,2720,3056,3058,3068,3655,4131,4132,4625,4645); |