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.
 

Blueprint Materials
Author
Previous Topic Next Topic
KillMinusNine
Imperial Shipment
Amarr Empire
#1 - 2012-07-25 15:22:07 UTC
Ok guys, I have been dreading asking this question.... I feel so stupid... bear with me... Oops

Which table are the blueprint material requirements (manufacturing) located in? ie: Tritanium, zydrine, etc...

I have searched ramTypeRequirements, invTypeMaterials, invBlueprintTypes, etc. and I can't seem to find anything (unless I am missing some tables here).

The only thing I have been able to find was in ramTypeRequirements and it was stuff like skills and invention materials.

I am going to re-import the static data dump to see if I am missing anything in the meantime.
Lluerssen
PHUB Corporation
#2 - 2012-07-25 15:26:00 UTC  |  Edited by: Lluerssen
SELECT `itm`.*, `it`.*
FROM `eve`.`invTypeMaterials` AS `itm`
INNER JOIN `eve`.`invTypes` AS `it` ON itm.materialTypeID = it.typeID
WHERE (it.published = 1) AND (itm.typeID = 209)

209 = blueprint's typeID

Sister of EvE: http://SisterOfEvE.ru/ Loot History Analyzer: http://SisterOfEvE.ru/loot_history/
KillMinusNine
Imperial Shipment
Amarr Empire
#3 - 2012-07-25 15:35:52 UTC
Thanks Lluerssen... when I was querying the database I was going by the blueprint ID and not the product ID... Thanks so much for the help! That solved my problem!

Solution: Use productTypeID to look up the materials from invTypeMaterials
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-07-25 15:53:34 UTC
The answer is not /quite/ accurate.

It covers blueprints which are purely basic materials, with no extra materials. Something like a Scorch Bomb isn't there.

Base Materials:
select typeid,name,greatest(0,sum(quantity)) quantity from (select invTypes.typeid typeid,invTypes.typeName name,quantity from invTypes,invTypeMaterials where invTypeMaterials.materialTypeID=invTypes.typeID and invTypeMaterials.TypeID=? union select invTypes.typeid typeid,invTypes.typeName name,invTypeMaterials.quantity*r.quantity*-1 quantity from invTypes,invTypeMaterials,ramTypeRequirements r,invBlueprintTypes bt where invTypeMaterials.materialTypeID=invTypes.typeID and invTypeMaterials.TypeID =r.requiredTypeID and r.typeID = bt.blueprintTypeID AND r.activityID = 1 and bt.productTypeID=? and r.recycle=1) t group by typeid,name

Extra Materials:
SELECT t.typeName tn, r.quantity qn, r.damagePerJob dmg,t.typeID typeid FROM ramTypeRequirements r,invTypes t,invBlueprintTypes bt,invGroups g where r.requiredTypeID = t.typeID and r.typeID = bt.blueprintTypeID AND r.activityID = 1 and bt.productTypeID=? and g.categoryID != 16 and t.groupID = g.groupID

Extra materials aren't affected by ME waste. And only by Production Efficiency waste if, and only if, they appear in the base materials.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter