| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Korben Bada
Dread Empire
0
   |
Posted - 2015.10.02 12:20:48 -
[1] - Quote
I'm looking for a copy of all the ships and modules in game along with their stats, fitting and attributes, like what apps such as EFT and PYFA use. I checked out the static dump but it only appears to contain icons and other things.
Can someone please point me in the right direction? |
Liquid Shock
Quantum Shenanigans
5
|
Posted - 2015.10.02 13:20:30 -
[2] - Quote
The SDE contains all the data you need, but it takes a while to make sense of it all.
I am in the process of creating an EVE companion app for Android, and I created a custom SQLite database based on the SDE to make things easier. It only contains the data for what I need to implement in the app (fitting tool, skill planner and item database mostly), and I created a number of views in the database which provide relevant data.
First, we have the following major views
EN_Categories - query for categories in categoryIDs.yaml
EN_Groups - groups in groupIDs.yaml
EN_Types - types in typeIDs.yaml
EN_TypeAttributes - for querying attributes for any item with a typeID.
Then I further broke it down into separate chunks. The names should be self explanatory.
EN_Charges, EN_ChargeAttributes AND EN_ChargeEffects
EN_Drones, EN_DroneAttributes and EN_DroneEffects
EN_Implants, EN_ImplantAttributes AND EN_ImplantEffects
EN_Modules, EN_ModuleAttributes AND EN_ModuleEffects
EN_Ships, EN_ShipAttributes and EN_ShipEffects
EN_Skills, EN_SkillAttributes and EN_SkillEffects
EN_Subsystems, EN_SubsystemAttributes AND EN_SubsystemEffects
I'm still studying the SDE to find out how to filter whether a particular module is a ship rig or not. It's probably in one of the attributes, and there are over 500 unique attributes to check, but I'll get to it at some point.
Note that there's a TranslatedContent table which contains the translations for the languages provided in the .yaml files, so it's possible to build views for other supported languages, if you'd like. You can use a tool like SQLiteStudio to examine the view queries to understand how the table JOINs work.
You can download the custom SQLite database which is based on the Vanguard SDE at https://www.dropbox.com/s/ld2j4snduc31m39/sde.zip?dl=0.
Hope this helps. |
Korben Bada
Dread Empire
0
|
Posted - 2015.10.03 10:05:18 -
[3] - Quote
Liquid Shock wrote:The SDE contains all the data you need, but it takes a while to make sense of it all.
Thanks for confirming it's the right place and breaking it down a bit. Like you I'll have to sit down and look closer at it.
Shame this isn't documented better somewhere that we can just pick it up and run with it.
|
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
5601
|
Posted - 2015.10.03 19:31:57 -
[4] - Quote
The slot a module needs is in dgmTypeEffects (dgmEffects defines which is which)
Woo! CSM X!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |