These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

How can I see what are the manufacturing uses of an item?
Author
Previous Topic Next Topic
Hober Mallov
Enemy of Man
#1 - 2012-10-05 13:59:00 UTC
I have a bunch of stuff in my hangar I'm not sure what they're used for.

Can I do a data pull off the static DB to determine if they're used in any manufacturing process or is there a table/website I can refer to?

Thanks and regards.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-10-05 14:45:17 UTC
select it.typename from invTypes it,invTypeMaterials itm, invTypes it2 where it.typeid=itm.typeid and itm.materialTypeID=it2.typeid and it2.typename='Tritanium'
union
select it.typename from invTypes it,ramTypeRequirements rtr, invTypes it2 where it.typeid=rtr.typeid and rtr.requiredTypeID=it2.typeid and it2.typename='Tritanium'


Smile

That'll pull a list of everything which needs Tritanium, either as a basic material, or as a extra material. It'll also pull anything that has an extra material which is recyclable to tritanium (even if it's not in the blueprint for that first item.) I could strip that out, but it'd complicate the query, and is a minor issue.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2012-10-05 15:36:25 UTC
And now introducing:
http://www.fuzzwork.co.uk/uses/


Don't stick in tritanium, unless you want to be waiting for a while. It's used in most things Blink It'll still report on things which have extra components which contain the thing you're looking for.

And it ties into my blueprint calculator, so you can run the numbers. Smile

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Hober Mallov
Enemy of Man
#4 - 2012-10-05 15:53:14 UTC
You sir, are a star!!!
Louis Vitton
Viziam
Amarr Empire
#5 - 2012-10-06 14:01:29 UTC