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.
 

Association between T1 blueprints and T2 invention counterparts from the data dump?
Author
Previous Topic Next Topic
Illuminocity
University of Caille
Gallente Federation
#1 - 2012-01-23 14:46:41 UTC  |  Edited by: Illuminocity
Hi,

I'm unable to find any relationship between T1 blueprints and the corresponding T2 blueprints obtainable through invention. I'm using the latest Crucible data dump.

In a nutshell what I'm trying to achieve is get a list of T2 blueprints which can be invented from any specific T1 blueprint (copy)
Example: For Moa Blueprint I'd expect the following result: Eagle Blueprint and Onyx Blueprint since those are both in fact invented from the same blueprint.

By looking at the invBlueprintTypes table a logical place for this information seems to be the parentBlueprintTypeID column. However that column does not seem to be populated with the expected data.

I tried to tackle this by just looking for the product of the T1 blueprint in the list of components for manufacturing any T2 blueprints (with the above example, I would look for the typeID of a Moa from the ramTypeRequirements table and find it is needed to manufacture both the Onyx and the Eagle). While this works for the above example, it will not for a myriad of other items (since the T1 product may be used for a lot of faction BPC-s too for example - which however are not obtainable through invention).

Any tips?
Desmont McCallock
#2 - 2012-01-23 15:17:41 UTC
Your search logic should be:

T1 blueprint -> T1 Produced Item -> T2 Variation Item -> T2 blueprint

T2 Variation of T1 items can be found in invMetaTypes table.
Illuminocity
University of Caille
Gallente Federation
#3 - 2012-01-24 09:32:23 UTC
Hah! Not sure how I missed that. Case closed..
Thanks!
Aineko Macx
#4 - 2012-02-09 07:18:52 UTC  |  Edited by: Aineko Macx
To get people started:

SELECT t1.typeId as t1ID, t1.typeName as t1Name, t1bpt.typeId as t1BpID, t1bpt.typeName as t1BpName, t2.typeId as t2ID, t2.typeName as t2Name, t2bpt.typeId as t2BpID, t2bpt.typeName as t2BpName
FROM `invMetaTypes` as iMT
JOIN invTypes as t1 ON t1.typeID = iMT.parentTypeID
JOIN invTypes as t2 ON t2.typeID = iMT.typeID
JOIN invBlueprintTypes as t1bp ON t1bp.productTypeID = t1.typeID
JOIN invTypes as t1bpt ON t1bpt.typeID = t1bp.blueprintTypeID
JOIN invBlueprintTypes as t2bp ON t2bp.productTypeID = t2.typeID
JOIN invTypes as t2bpt ON t2bpt.typeID = t2bp.blueprintTypeID
WHERE iMT.metaGroupID = 2
AND t1.published = 1;

iveeCore 3.0: The PHP engine for industrial activities and CREST library