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.
 

Item and corresponding blueprint ID

First post
Author
Previous Topic Next Topic
Delta Shahni
Stardrive Enterprises
#1 - 2016-10-08 13:24:22 UTC
Is there a mapping between the item ID and the relevant blueprint i.e. a Talwar is 32878 and the blueprint is 32979?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2016-10-08 14:45:12 UTC
https://www.fuzzwork.co.uk/dump/latest/industryActivityProducts.csv.bz2 (7zip will uncompress it)

typeid is the blueprint, producttypeid is the thing it makes.

Activityid 1 is manufacturing.

(There's no direct mapping from one to the other which you can do. you have to look it up)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Delta Shahni
Stardrive Enterprises
#3 - 2016-10-09 01:50:03 UTC
Thanks I couldn't find it.

Now I am looking for a map for the T2 and T1 variant, I.e a Crusader is an Executioner, does this exist?

Any help is appreciated, then is back to trying to figure out API pulls for station index, jobs in build, market orders and market pricing if any one has answers to these it would be helpful aswell.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2016-10-09 15:45:34 UTC  |  Edited by: Steve Ronuken
Delta Shahni wrote:
Thanks I couldn't find it.

Now I am looking for a map for the T2 and T1 variant, I.e a Crusader is an Executioner, does this exist?

Any help is appreciated, then is back to trying to figure out API pulls for station index, jobs in build, market orders and market pricing if any one has answers to these it would be helpful aswell.



Couple of ways to do this.

In industryActivityProducts activity id 8 is invention. So you can go from typeid to producttypeid, with activityid 8. That's specifically on the blueprint type ids.




The other way involves going through invMetaTypes. This is with the actual ships/modules typeid.

if you're going from t2 to t1, search for the typeid, getting the parenttypeid.
If you're going from t1 to t2, search for the parenttypeid, getting the typeid.

mysql> select * from invMetaTypes where typeid=11184;
+--------+--------------+-------------+
| typeID | parentTypeID | metaGroupID |
+--------+--------------+-------------+
|  11184 |          589 |           2 |
+--------+--------------+-------------+

select * from invMetaTypes where parenttypeid=589;
+--------+--------------+-------------+
| typeID | parentTypeID | metaGroupID |
+--------+--------------+-------------+
|  11184 |          589 |           2 |
|  11186 |          589 |           2 |
+--------+--------------+-------------+






If you're doing this stuff in google docs, https://github.com/fuzzysteve/eve-googledocs-script may be of interest.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter