EQEmulator Forums - Spell research

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Development (https://www.eqemulator.org/forums/forumdisplay.php?f=590)

- - Spell research (https://www.eqemulator.org/forums/showthread.php?t=43510)

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).

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

Code:

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.