These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

List of T2 Rigs
Author
Previous Topic Next Topic
Timcanpy Yvormes
Center for Advanced Studies
Gallente Federation
#1 - 2015-03-31 22:08:40 UTC
I'm trying to get a list of all the T2 rigs, i think i got all the Rigs from the Invtype Fuzzwork provide in his datadump, but now get the T2 is a problem

I'm getting my list via the group ID, and i get all rigs, seperate them is a big problem :S

How can i get only the T2? does any one know or could provide me one?

I also accept if u want to teach me and would apreciate that more than the list

I'm using google docs to do my spreadsheet

Kind Regards
Tim.
Tau Cabalander
Retirement Retreat
Working Stiffs
#2 - 2015-04-01 00:11:24 UTC
The EVE Technology lab forum is where API and data-dump experts hangout.
Raphael Celestine
Celestine Inc.
#3 - 2015-04-01 03:59:50 UTC
You can check the tech level of an item in invMetaTypes - T2 has metaGroupID = 2

If you can handle an SQL query, this should pull everything in invTypes for the items you want:

SELECT * FROM invTypes JOIN invMetaTypes
ON invTypes.typeID = invMetaTypes.typeID
WHERE (groupID = 773 OR groupID = 774 OR groupID = 775 OR groupID = 776
OR groupID = 777 OR groupID = 778 OR groupID = 779 OR groupID = 781 OR groupID =782
OR groupID = 786)
AND metaGroupID = 2
Selaria Unbertable
Bellator in Capsulam
#4 - 2015-04-01 11:36:35 UTC
Raphael Celestine wrote:
You can check the tech level of an item in invMetaTypes - T2 has metaGroupID = 2

If you can handle an SQL query, this should pull everything in invTypes for the items you want:

SELECT * FROM invTypes JOIN invMetaTypes
ON invTypes.typeID = invMetaTypes.typeID
WHERE (groupID = 773 OR groupID = 774 OR groupID = 775 OR groupID = 776
OR groupID = 777 OR groupID = 778 OR groupID = 779 OR groupID = 781 OR groupID =782
OR groupID = 786)
AND metaGroupID = 2


Or shorter:
SELECT * FROM invTypes JOIN invMetaTypes ON invTypes.typeID = invMetaTypes.typeID
WHERE groupID IN(773, 774, 775, 776, 777, 778, 779, 781, 782, 786) AND metaGroupID = 2

I'd also use an INNER JOIN with USING(typeID) instead of ON. Eliminates duplicate column names. But basically this...
Timcanpy Yvormes
Center for Advanced Studies
Gallente Federation
#5 - 2015-04-01 22:26:13 UTC
Thank you all for the aswer, it helped me alot
Soldarius
Dreddit
Test Alliance Please Ignore
#6 - 2015-04-03 14:10:41 UTC  |  Edited by: Soldarius
The way I do it is to maintain an external spreadsheet with every item in eve. Then link to it using a fairly simple importRange and VLookup function that uses an array of names for its input.

In this way, I can use the same technique for all my spreadsheets just by passing only a set of names into the function.

EX:
=ArrayFormula(vlookup(A2:A91,ImportRange("https://docs.google.com/spreadsheets/d/[spreadsheetKey]","itemTypes!A1:B"),2,0))


will fetch the itemType for every item in the column array at a2:a91.

If you ever intend to expand from just T2 rigs, you should consider something like this. It saves me a metric crap-tonne of extra work every time CCP changes an itemType.

http://youtu.be/YVkUvmDQ3HY