Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
FrostFire UberNuker
Darkfire Unlimited The Serenity Initiative
0
|
Posted - 2017.03.24 06:07:31 -
[1] - Quote
Hiya,
Ive spent hours pouring over the documentation on the SDE, and all over the place I see references to the Sql Data Dump that contains static data I need in order to interpret the data in the YAML files. But I cannot find that SQL dump anywhere. It is not, as the documentation says, in the SDE file. Neither are the referenced SQLite DB files (tho I do not need the data in those).
So... first question is, where is this SQL Dump File?
Second... maybe I am looking in the wrong place, so let me explain what data I want and someone might be able to point me in the right direction. Essentially I want the information on all blueprints in the game. I assume that the Blueprints.yaml file contains that information, but of course that file is not complete. It contains IDs that need to be cross referenced somehow to find out what it produces and what the input materials are, etc. How are those lookups done without the static data dump? Can that be done via API somehow? If so I cannot find it in any of the documentation.
Any help is greatly appreciated!
Frosty |
Althalus Stenory
Flying Blacksmiths
110
|
Posted - 2017.03.24 09:49:11 -
[2] - Quote
1. https://www.fuzzwork.co.uk/dump/
2. with the SDE conversion (see 1.) you have multiple tables that contains all the blueprints data : - industryActivity : contains the job time, per activity, per blueprint - industryActivityMaterials : contains the materials required for a given blueprint / activity - industryActivityProbabilities : contains the probabilities for a given blueprint and activity (only invention now actually) - industryActivityProducts : contains the result products for each activity and blueprints - industryActivitySkills : contains the required skill per activity/blueprint - industryBlueprints : contains the max run per blueprint (for bpc)
After you can link everything together to get the data you need, and with the invTypes table to get item names, etc etc.
Hope it helps :)
EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6580
|
Posted - 2017.03.24 18:55:19 -
[3] - Quote
CCP stopped providing an SQL dump file a fair time ago, going through a couple of iterations of how it was provided, before finally getting the whole thing into yaml. Believe it or not, it made converting it to other database formats a _lot_ easier. automating the conversion was somewhat troublesome before. Now it's really easy.
The link in the post above is my conversion. https://github.com/fuzzysteve/yamlloader is how it's created.
While I don't really advertise it, I do have an api for blueprint data.
https://www.fuzzwork.co.uk/blueprint/api/blueprint.php?typeid=587
The typeid is the typeid of the product. invTypes contains a list of products.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |