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.
 

extracting materials for items via MYSQL

Author
Previous Topic Next Topic
Pewpew Guns
GG In Space
#1 - 2011-11-02 23:35:23 UTC
Hi,

Noob guy here. I'm trying to extract materials for items (ie, bills of materials for modules, ships. etc) from the data dump via MYSQL query. Being a complete noob with databases, this is currently beyond me. I'm wondering if someone might not have such a query already written kicking around that they might not mind posting.

I know there are sites/tools/calculators that already do this sort of thing. I've got my reasons to want to make my own tool. Anyway, any help on the subject is most appreciated. I've searched extensively, but apparently my google-foo is weak these days.

Thanks!
Lutz Major
Austriae Est Imperare Orbi Universo
#2 - 2011-11-03 07:47:35 UTC
Raw materials can be found the invTypeMaterials table:

SELECT *
FROM invTypeMaterials, invTypes
WHERE invTypeMaterials.materialTypeID = invTypes.typeID
AND invTypeMaterials.typeID = 266 -- itemID


Extra materials can be found in the ramTypeRequirements table:

SELECT *
FROM ramTypeRequirements, invTypes
WHERE ramTypeRequirements.requiredTypeID = invTypes.typeID
AND ramTypeRequirements.typeID = 24472 -- blueprint ID of the item