(3.3.5a) How to increase drop rate of all quest items?

Custom Code and Mods Custom Code and Requests
1

Ideally would like to know if there is a way to increase all quest item drop rates to 100%.

But I have been trying to do this individually by examining the loot template tabs and referenced loot templates to try and find the specific quest item. (Using Navicat). However I Can’t seem to find the item when I search for it’s ID (Embalming Ichor, ID:2834) so I have no idea how to modify its drop chance.

Similarly certain mobs I am unable to find in the database which are in game (E.g. Rot Hide Graverobber, ID:1941, which drop the Embalming Ichor needed for the quest)

2

What’s the problem?

[FONT=courier new][world]> SELECT * FROM creature_loot_template WHERE Item = 2834;
±------±-----±----------±-------±--------------±---------±--------±---------±---------±--------+
| Entry | Item | Reference | Chance | QuestRequired | LootMode | GroupId | MinCount | MaxCount | Comment |
±------±-----±----------±-------±--------------±---------±--------±---------±---------±--------+
| 1941 | 2834 | 0 | 40 | 1 | 1 | 0 | 1 | 1 | NULL |
| 1674 | 2834 | 0 | 40 | 1 | 1 | 0 | 1 | 1 | NULL |
±------±-----±----------±-------±--------------±---------±--------±---------±---------±--------+
2 rows in set (0.06 sec)[/FONT]

[FONT=arial]If you want to set all the quest item drop chance to 100% then… [/FONT][FONT=courier new]UPDATE creature_loot_template SET Chance=100 WHERE QuestRequired=1; – do the same for the other loot tables[/FONT]