azerothcore / azerothcore-wotlk

Complete Open Source and Modular solution for MMO
http://www.azerothcore.org
GNU Affero General Public License v3.0
6.56k stars 2.63k forks source link

Mark of Illidari drop #17651

Open Tereneckla opened 1 year ago

Tereneckla commented 1 year ago

Current Behaviour

Mark of Illidari drop rates seem rather low Mark of Illidari drop is missing entirely from Serpentshrine Cavern

Expected Blizzlike Behaviour

Mark of Illidari drop rates in SSC are around 10% Mark of Illidari drop rates in TK, MH, BT and SWP seem around 20%

Source

https://www.wowhead.com/wotlk/item=32897/mark-of-the-illidari#dropped-by

Steps to reproduce the problem

DB

Extra Notes

https://wowgaming.altervista.org/aowow/?item=32897#dropped-by

AC rev. hash/commit

https://github.com/azerothcore/azerothcore-wotlk/commit/f417a166bc8c626981da612fc5372acb15e19593

Operating system

Windows 10

Custom changes or Modules

No response

elthehablo commented 12 months ago

Some queries to check this out per map:

-- SSC 0 results rn
SELECT * 
FROM `creature_loot_template` AS clt
INNER JOIN `creature` AS ct
ON clt.Entry = ct.id1
WHERE `Item` = 32897 AND `map` = 548;

-- The Eye 7 to 10% ish
SELECT * 
FROM `creature_loot_template` AS clt
INNER JOIN `creature` AS ct
ON clt.Entry = ct.id1
WHERE `Item` = 32897 AND `map` = 550;

-- BT 9 to 13.5% ish
SELECT * 
FROM `creature_loot_template` AS clt
INNER JOIN `creature` AS ct
ON clt.Entry = ct.id1
WHERE `Item` = 32897 AND `map` = 564;

-- Sunwell 15% on all creatures 
SELECT * 
FROM `creature_loot_template` AS clt
INNER JOIN `creature` AS ct
ON clt.Entry = ct.id1
WHERE `Item` = 32897 AND `map` = 580;