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/sho...52&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.