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 to differentiate t1 from t2 in invtypes
Author
Previous Topic Next Topic
Frikkin Genius
The Scope
Gallente Federation
#1 - 2017-02-14 01:06:36 UTC
I just got back into my production tool i developed in MS Access and discovered that 'techlevel' in invBlueprintTypes is now null.

Can some one suggest an sql query to select all t1 ships vice t2 ships? Thanks, friends!
Althalus Stenory
Flying Blacksmiths
#2 - 2017-02-14 09:56:55 UTC  |  Edited by: Althalus Stenory
Frikkin Genius wrote:
I just got back into my production tool i developed in MS Access and discovered that 'techlevel' in invBlueprintTypes is now null.

Can some one suggest an sql query to select all t1 ships vice t2 ships? Thanks, friends!

I don't know if that's enough but seems to work.

For T2
select * 
from invTypes i 
join invMetaTypes imt 
       on imt.typeID = i.typeID and imt.metaGroupID = 2

If you look in invMetaGroup, you have all meta there (1: t1, 2: t2, 3: storyline etc)

This value is also in dgmTypeAttribute, and you can have the same with this request (in MySQL)
select * from dgmTypeAttributes d 
join invTypes i 
       on i.typeID = d.typeID 
where d.attributeID = 633 
      and ifnull(d.valueInt, d.valueFloat) = 5

where "5" is the meta number for t2, so <5 is all t1 items and meta, and above are storyline, factions etc.

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI