Edited by: Steve Ronuken on 19/07/2011 15:20:59https://www.fuzzysteve.co.uk/eve/salvage/
Threw it together a few days ago.
Just takes the one, and tells you the rest. Try it from the IGB for the links to do something.
The core of it is:
select itemname(invTypeMaterials.typeID) what ,bpid,invTypes.typeName name,quantity,invTypeMaterials.typeID topitem,invTypeMaterials.materialTypeID mainitem from invTypes,invTypeMaterials,bplookup where invTypeMaterials.materialTypeID=invTypes.typeID and invTypeMaterials.TypeID in (select distinct invTypeMaterials.typeID from invTypeMaterials where materialTypeID =? and itemname(invTypeMaterials.typeID) like ?) and bplookup.itemid=invTypeMaterials.TypeID
input parameters are:
With a custom function to simplify the lookup of itemnames, and a table to link items to their blueprints. I couldn't find the latter, so I built it myself. Doing it on the fly took too long.