Lets take http://www.truewow.org/bugs/view.php?id=3721 as an example.
The problem that I wish to solve is that the boss drops a few items he should not drop on the heroic dificulty. For instance Amani Venom-Axe should not drop from him on heroic.
Deletion:
Looking a bit up on trinity core's page I ended up with this:
Code: Select all
DELETE FROM creature_loot_template WHERE Entry=20521 AND Item=27424 AND LootMode=?;
The problem is with LootMode, which decides the difficulty. I did find out that its value could be 2^x, where x goes from 0 to 14, but I could not find out which value would corespond to say 5 heroic.
Update:
Also I read up on GroupId and from how I understod it, after deleting the 3 additional item I would need to update the chance for the gear items he drops, so that they together make up 100 % chance. Is that right? If so, he should drop 6 possible gear items and the chance should therefore be set to 100 / 6 --> 16.67?
Lets take this one as an example
Code: Select all
UPDATE creature_loot_template SET chance=16.67 WHERE Entry=20521 AND Item=28216;