The quest "Root Samples" (Quest ID 866) activates the collection of "Root Sample" (Item ID 5056) from specific game objects introduced just for this quest. Right now within the database of Zero, One and Two this is set to the loot templates of the standard rather than the specific game objects. (e.g. game objects Silverleaf ID 1617 vs. Silverleaf ID 3725)
Since the game objects are placed within the Barrens correctly, this can easily be fixed by removing the item from the currect gameobject_loot_templates and adding it to the loot templates of the quest specific game objects:
-- Remove wrong loot template associations (gameobjects not in Barrens) DELETE FROM `gameobject_loot_template` WHERE `item` = 5056; -- Add new loot template associations for Barrens gameobjects INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `groupid`, `mincountOrRef`, `maxcount`, `condition_id`) VALUES (2511, 5056, -40, 0, 1, 1, 0), (2512, 5056, -40, 0, 1, 1, 0), (2513, 5056, -40, 0, 1, 1, 0), (2514, 5056, -40, 0, 1, 1, 0), (2515, 5056, -40, 0, 1, 1, 0), (2516, 5056, -40, 0, 1, 1, 0);
If deleting everything with Item ID 5056 is too drastic, you might want to add the entries 1414, 1416, 1417 and 1418 to the WHERE-clause, but IMHO the item shouldn't appear anywhere else, so wiping all entries would be the clean solution.
This might be pretty similar for Three, but since I don't do Three, I can't tell.
Recommended Comments