Not sure if this is the right place to ask, but I have downloaded the latest SQL dump of the Eve Online database and am trying to figure out how to determine if a specific item is manufacturable or not.
I can get a list of all Tech I items with;
select typename, metaGroupName FROM invMetaTypes,invTypes,invMetaGroups WHERE invTypes.typeID = invMetaTypes.typeID AND invMetaTypes.metaGroupID = 1 AND invMetaGroups.metaGroupID = invMetaTypes.metaGroupID
I am now looking for a way to limit this list to only show Tech I items that can be manufactured via a blueprint.
Any help would be greatly appreciated!