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.
 

Ships Database - From MySQL?
Author
Previous Topic Next Topic
LifeHatesMe
LifeHatesUsAll
#1 - 2012-04-07 20:48:03 UTC
What's the easiest forward-compatible way to get create a list from MySQL of all ships in Eve? Just curious, and would this automatically include the dev-owned ship types too.. like the polaris? Just curious!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-04-07 22:00:25 UTC
select typename from invTypes,invGroups where invTypes.groupid=invGroups.groupid and invGroups.categoryid=6;


Should do you.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter