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.
 

CCP Community Toolkit - database dump

First post
Author
Previous Topic Next Topic
Commander John Snow
The Scope
Gallente Federation
#1 - 2015-09-06 11:39:34 UTC
hello,
im pooking around in mssql and sqlite databases and cannot find any information about ships Sad

- i exported mssql database as sql dump file (around 500MB of raw SQL) and search for word 'Armageddon' in there and didnt find anything ...
- sqlite db contains only map-related stuff so i didnt search in there ...
- i found couple instances of word 'Armageddon' in typeIDs.yaml, skins.yaml and graphicIDs.yaml but i dont want how ship looks just its name, tech level, id and race ... (and dont know how to read that anyway)

ideally like first 4 collumns in this table: http://wiki.eveuniversity.org/Alphabetical_Ship_List


I know nothing
Aineko Macx
#2 - 2015-09-06 13:59:27 UTC  |  Edited by: Aineko Macx
Check out Steves SDE conversions.
They re-add the DB tables that were replaced by YAML files by CCP.

With one of these DBs, you can look in the invTypes table, which lists all items. To filter down to ships existing in game you can use the following SQL query:
SELECT ig.groupName, it.* FROM invTypes as it
JOIN invGroups as ig ON ig.groupID = it.groupID
WHERE categoryID = 6
AND marketGroupID IS NOT NULL;


EDIT: Some more bits
SELECT it.typeName, it.typeID, ig.groupName, cr.raceName, coalesce(dga.valueInt, dga.valueFloat) as metaLevel
FROM invTypes as it
JOIN invGroups as ig ON ig.groupID = it.groupID
JOIN chrRaces as cr ON cr.raceID = it.raceID
JOIN dgmTypeAttributes as dga ON dga.typeID = it.typeID
WHERE categoryID = 6
AND marketGroupID IS NOT NULL
AND dga.attributeID = 633;

iveeCore 3.0: The PHP engine for industrial activities and CREST library
Commander John Snow
The Scope
Gallente Federation
#3 - 2015-09-06 16:20:39 UTC
wow .. i didnt expect SQL response .... thanks :)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2015-09-06 16:34:46 UTC
There's a bunch of other useful information in the dgm tables, but pulling them out in a single row is a touch difficult (well, annoying more than difficult.)

easiest way is to pull them, then pivot it in excel.

join in dgmAttributeTypes on attributeid, then you can get the display name for it.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Commander John Snow
The Scope
Gallente Federation
#5 - 2015-09-08 15:34:34 UTC
i wanna extract some information about ships (and some other stuff) into smaller SQLite database so in my perspective one GIANT sql select is less annoying and easiest than figuring out how to do same in excel :)