open All Channels
seplocked EVE Technology Lab
blankseplocked All EVE Ships Dump
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Lord Tarrn
Posted - 2011.06.08 17:53:00 - [1]
 

Does anyone know where I can get all the ships in any delimited format?

I also have the latest dump in MySQL Form already uploaded, just not sure what the exact query is to get the data I need, "Harbinger, Amarr Shuttle, Drake" etc..

Thanks,

Lutz Major
Posted - 2011.06.08 18:42:00 - [2]
 

Hello Lord Tarrn, you can query the data by executing:
SELECT inv.*
FROM invTypes inv, invGroups grp
WHERE inv.groupID = grp.groupID AND grp.categoryID = 6
AND inv.published = 1 AND grp.published = 1

You can narrow the results further by adding ... AND grp.groupID IN (...)

Trenker
Posted - 2011.06.08 19:15:00 - [3]
 

And if you really just need the ship names, make it inv.typeName as ship:
SELECT inv . typeName AS ship
FROM invTypes inv, invGroups grp
WHERE inv.groupID = grp.groupID
AND grp.categoryID =6
AND inv.published =1
AND grp.published =1

Lord Tarrn
Posted - 2011.06.08 19:16:00 - [4]
 

Fracking Life Saver man. Thanks.

Lord Tarrn
Posted - 2011.06.08 19:19:00 - [5]
 

Edited by: Lord Tarrn on 08/06/2011 19:19:33
Thanks as well Trenker


 

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