Jump to content
  • Root Samples (Quest ID 866)


    Almost Night
    • Status: Completed
      Main Category: Quests
      Sub-Category: Looting
      Version: 21.14 Milestone: Unset Priority: New
      Implemented Version: 22.xx (Current Master Branch)

    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.


    User Feedback

    Recommended Comments



    Guest
    This is now closed for further comments

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use