EVE Technology Lab

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » QUERY: Ship attributes table (?)

Topic is locked indefinitely.

QUERY: Ship attributes table (?)
Author

Previous Topic Next Topic

Uber Pie

Likes received: 40

#1 - 2013-11-15 12:24:53 UTC

Hi all,

I'm probably not the first one to have this question but I've done a search on the forum and nothing has come up so here it is:

Is there a table somewhere (Excel/Googledocs) with the different ships in Eve and their attributes (slots, speed, sig, resists etc.):

I'm not much of a DB user/programmer to be able to pull off the dump.

Thanks in advance for the help.

UP

CorporationsUnlimited™ - Providing New Eden with High Faction Standing Corporations since 2010

Steve Ronuken

Fuzzwork Enterprises

Vote Steve Ronuken for CSM

Likes received: 6,759

#2 - 2013-11-15 12:34:10 UTC

You're in luck. Someone asked for this a few weeks back:

http://www.fuzzwork.co.uk/resources/shipattributes.xlsx

Be aware, I don't automatically update this when new updates come out. It's up to date now. After Rubicon comes out, it won't be.

in case it's of interest to people, the sql to create the unpivoted data file, from mysql (change the /tmp/shipattributes.txt to something that mysql can write to):
select invTypes.typeid,typename,attributename,coalesce(valueint,valuefloat) from invTypes join invGroups on (invTypes.groupid=invGroups.groupid and categoryid=6) join dgmTypeAttributes on (dgmTypeAttributes.typeid=invTypes.typeid) join dgmAttributeTypes on (dgmTypeAttributes.attributeid=dgmAttributeTypes.attributeid) where invTypes.published=1 into outfile '/tmp/shipattributes.txt';

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Uber Pie

Likes received: 40

#3 - 2013-11-15 12:35:59 UTC

Steve Ronuken wrote:

thanks Steve, much appreciated.

I use your site regularly but somehow managed to miss this.

any chance of updating this after Rubicon rolls?

CorporationsUnlimited™ - Providing New Eden with High Faction Standing Corporations since 2010


Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#4 - 2013-11-15 12:38:13 UTC Probably missed it, as it's not linked anywhere The resources directory is where I dump 'custom' stuff. What I'd suggest is: poke me after the Rubicon SDE is out. That way I'll actually remember about this. Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter


Uber Pie Likes received: 40	#5 - 2013-11-15 12:45:07 UTC Steve Ronuken wrote: poke me... That way I'll actually remember about this. THAT sounds eerily familiar. You don't have my flat bugged do you??? CorporationsUnlimited™ - Providing New Eden with High Faction Standing Corporations since 2010


Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#6 - 2013-11-15 13:08:36 UTC Uber Pie wrote: Steve Ronuken wrote: poke me... That way I'll actually remember about this. THAT sounds eerily familiar. You don't have my flat bugged do you??? I refuse to confirm or deny the state of electronic surveillance in your domicile. Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter


Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#7 - 2013-11-15 16:56:35 UTC Updated to Rubicon Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter


Uber Pie Likes received: 40	#8 - 2013-11-16 09:43:06 UTC muchas gracias senor !!! CorporationsUnlimited™ - Providing New Eden with High Faction Standing Corporations since 2010