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 do I find the bp materials for stuff in the concord lp store?
Author
Previous Topic Next Topic
Shang Ghjuvan
Shang Ghjuvan Corporation
#1 - 2012-05-03 05:31:46 UTC
So far I have

SELECT A.activityName, T1.typeName, T2.typeName as requiredType, AMV.quantity, recycle
FROM ramTypeRequirements AMV
INNER JOIN invTypes T1 on T1.typeID = AMV.typeID
INNER JOIN invTypes T2 on T2.typeID = AMV.requiredTypeID
INNER JOIN ramActivities A on A.activityID = AMV.activityID
WHERE AMV.typeID = 3574 AND AMV.activityID = 1

which gives

activityName typeName requiredType quantity recycle
Manufacturing 6x2500mm Heavy Gallium I Repeating Cannon Blueprin... Industry 1 0
Manufacturing 6x2500mm Heavy Gallium I Repeating Cannon Blueprin... 6x2500mm Repeating Artillery I 1 1
Manufacturing 6x2500mm Heavy Gallium I Repeating Cannon Blueprin... Capital Ship Construction 1 0

which is missing a few of the requirements, where do I get the mission info
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-05-03 10:55:07 UTC
take a look at the invTypeMaterials table. (and remove the materials from anything marked as recyclable in the RamTypeRequirements table from it)


Alternatively:
http://www.fuzzwork.co.uk/blueprints/3573/0/5/0/5

Blink

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter