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.
 

Most current Bill of Materials SQL

First post
Author
Previous Topic Next Topic
GrayLensman
Galactic Protectorate
#1 - 2015-12-22 21:04:58 UTC
Can someone share the most recent SQL that allows developers to construct a bill of materials for a Blueprint. Lots of dated SQL examples out there and could sure use the help. Thanks!

Gray
Louis Vitton
Viziam
Amarr Empire
#2 - 2015-12-23 01:19:19 UTC
Quote:

SELECT typeName,materialTypeID,quantity
FROM industryActivityMaterials
INNER JOIN invTypes
ON invTypes.typeID = materialTypeID
WHERE activityID = 1 and industryActivityMaterials.typeID = ?

Where the ? is you need to put the blueprint typeID.
Please note you also need to do the required math to get the required amounts, this will only provide base amounts for production.
In short me 0
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2015-12-23 13:01:38 UTC
The sql above is assuming that you are using the export available from my site :D

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
GrayLensman
Galactic Protectorate
#4 - 2015-12-23 15:51:24 UTC
Thanks, but if developers are using the SDE directly what would that SQL look like?
Desmont McCallock
#5 - 2015-12-23 16:47:38 UTC
If you use EVESDEToSQL

SELECT typeName,requiredTypeID,quantity
FROM ramTypeRequirements 
INNER JOIN invTypes
ON invTypes.typeID = requiredTypeID
WHERE activityID = 1 and ramTypeRequirements.typeID = ?
Zifrian
The Frog Pond
Ribbit.
#6 - 2015-12-23 20:43:11 UTC
GrayLensman wrote:
Thanks, but if developers are using the SDE directly what would that SQL look like?

The required tables aren't in the SDE until you import the yaml file with the blueprint data. Steve and Desmont have posted their versions above since they use different schema for the tables. CCP has no official schema for the tables, hence the differences. I think Desmont uses the classic structures that relate to the older documentation out there but Steves isn't hard to figure out.

I don't know of anyone else that has the SDE for you to look at so these are your two best bets unless you make your own.

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder