Spell research

[Huppy]

This is just a courtesy post. Containers for spell research, (like Book of Dark Bindings), by default are set at bagtype 5. Which is wrong. Set it to 26 and they work fine now. (tested).

[Huppy]

Sorry, need to clarify something (as of a recent issue), that bagtype 26 only applies to the Necro book. See this post here:

http://www.eqemulator.org/forums/showpost.php?p=168752&postcount=3

[EQEmpires]

SELECT DISTINCT
items.id,
items.name,
items.bagtype
FROM
tradeskill_recipe_entries
INNER JOIN tradeskill_recipe ON tradeskill_recipe.id = tradeskill_recipe_entries.recipe_id
INNER JOIN items ON tradeskill_recipe_entries.item_id = items.id
WHERE
tradeskill = 58
AND tradeskill_recipe_entries.iscontainer = 1;


The above query will allow you to select any containers that are part of a Research Combine DB-wide. Maybe it could help some people who may not know how to grab them from DB to do the suggested change.