Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
GrayLensman
Galactic Protectorate
0
|
Posted - 2015.12.22 21:04:58 -
[1] - Quote
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
Mind Games. Suddenly Spaceships.
83
|
Posted - 2015.12.23 01:19:19 -
[2] - Quote
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
5788
|
Posted - 2015.12.23 13:01:38 -
[3] - Quote
The sql above is assuming that you are using the export available from my site :D
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
GrayLensman
Galactic Protectorate
0
|
Posted - 2015.12.23 15:51:24 -
[4] - Quote
Thanks, but if developers are using the SDE directly what would that SQL look like? |
Desmont McCallock
591
|
Posted - 2015.12.23 16:47:38 -
[5] - Quote
If you use EVESDEToSQL
SELECT typeName,requiredTypeID,quantity FROM ramTypeRequirements INNER JOIN invTypes ON invTypes.typeID = requiredTypeID WHERE activityID = 1 and ramTypeRequirements.typeID = ?
|
Zifrian
Licentia Ex Vereor Phoebe Freeport Republic
1689
|
Posted - 2015.12.23 20:43:11 -
[6] - Quote
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.
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |