open All Channels
seplocked EVE Technology Lab
blankseplocked Invention Source <-> Result information missing from Eve Database Dump
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Roshcar
Caldari
Kydance Radiant Industries
Posted - 2011.07.22 13:58:00 - [1]
 

I'm currently working on an Eve related project and am at a point where I need the Source <-> Result link and I'm unable to find that in the published Eve Database dump.

Am I overlooking it? Is it missing accidentally? Has it been left out intentionally? I'm leaning towards, and hoping, that I'm simply overlooking that information.

Can anyone point me in the right direction? Or if this data really is missing point me at a location I can get it from OR CCP dump it for us? :P

Lutz Major
Posted - 2011.07.22 14:59:00 - [2]
 

IIRC the info is in the invMetaTypes table.

Or at.least something with meta.;)
There you have the relationship between T2 and the parent T1 invType

Ruziel
Minmatar
Twilight Military Industrial Complex
Posted - 2011.07.22 16:23:00 - [3]
 

Correct, the T1 -> T2 is in the invMetaTypes table.

SELECT parentTypeID AS T1, typeID AS T2
FROM invMetaTypes
WHERE metaGroupID = 2

Note, these are for the actual items, if you want to deal with blueprints, then you have to map the items in this table to the blueprints with the invBlueprintTypes.productTypeID

Roshcar
Caldari
Kydance Radiant Industries
Posted - 2011.07.22 18:15:00 - [4]
 

Awesome, got it, thanks guys.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only