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.
 

Need Ship Statistics spreadsheet or csv

Author
Previous Topic Next Topic
She Who Waits
Mercantile Club Accounting Services
#1 - 2011-09-26 21:41:05 UTC
Does anyone have a spreadsheet with all of the ship statistics in it? I had an ancient one I scraped from a website but its lost. This would have stuff like the shield HP, resists, sensor strength, number of high slots, etc. etc.

I don't need to know what skills are required.

Maybe someone could export this information from your databases for me please?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2011-09-27 17:40:21 UTC
Something like

http://dl.eve-files.com/media/1109/shipinfo.zip ?


excel makes pivoting this out of the DB easier.





if anyone is interested:

select typename,attributeName,COALESCE(valueInt,valueFloat) value from invTypes it,dgmTypeAttributes ta ,dgmAttributeTypes at where ta.attributeID=at.attributeID and ta.typeid=it.typeid and it.groupid=25 order by typename

pulls the unpivoted data for frigates. just use an in list with groupid to pull other ship types. you're looking for the details in invGroups where categoryID=6

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter