|
Author |
Thread Statistics | Show CCP posts - 10 post(s) |
|
CCP FoxFour
C C P C C P Alliance
14120
|
Posted - 2013.12.10 10:30:00 -
[1] - Quote
Anyone who has been part of the EVE community for an extended period of time might be familiar with some of the amazing tools developed by the community. Tools such as EVE Fitting Tool, Pyfa, EVE HQ, and one of the hundreds of other applications come from third party developers. One of the core things that powers those tools is what is commonly referred to as the EVE Static Data Export, or the SDE. Basically the SDE contains lots of information that doesn't change between patches. Information such as a ships hit points, the number of slots a ship has, how much damage a weapon does, and many other things.
One of the problems with DUST getting an SDE is that it stores data in a completely different way and unlike EVE we cannot just dump all of that data. We have to go through and select which bits should get dumped. Over the last few months I have been working away in my spare time to try and get something similar to the EVE SDE for DUST ready. This has meant trying to figure out the best format for it, put together an automated build setup so that it's always current, and trying to make sure everything you guys need is there.
Today I finally get the pleasure of announcing to you guys that we have something ready for release. Before we get into it though I want to be very clear. This SDE is being released with no support. Like with EVE, how the data works will be up to you guys to figure out. I also really want to point you all to an object that exists within New Eden: Magic Crystal Ball. This is especially important as since this data export has required whitelisting attributes, some may have been missed.
I will do my very best to try and update the DUST SDE where necessary, to answer questions here, and all those fun things. For now however, here is a link to the DUST SDE for Uprising 1.7: DUST SDE Download
As stated above DUST stores it's information in a much different format than EVE. This also means that the SDE is going to take a slightly different format than the EVE SDE. Here is a quick list of things to know about the DUST SDE:
- It is an SQLite3 DB file
- There are 3 tables in the DB. CatmaClasses, CatmaTypes, CatmaAttributes
- CatmaTypes contains all of the types with their typeID and typeName
- CatmaClasses contains every type with their typeID and className
- Types can possibly have 2 classes, hence why it's actually a seperate table and possibly has multiple entries per typeID
- CatmaAttributes contains types with typeID, catmaAttributeName, catmaValueInt, catmaValueReal, and catmaValueText
- Generally speaking only one of the three value columns in CatmaAttributes will actually have a value
- I am a game designer who attempted to do something crazy. This has been a big learning experience for me so please hang in there while I attempt to improve this SDE based on your feedback.
MAGIC CRYSTAL BALL! Please don't create threadnaughts about information you find within this SDE. I wouldn't want to have to take it away because of all the fear inducing rage it creates.
Now... where is my DUST fitting tool. :D
CCP FoxFour // Game Designer // Team True Grit
http://twitter.com/regnerba
|
|
|
CCP Cognac
C C P C C P Alliance
155
|
Posted - 2013.12.10 12:49:00 -
[2] - Quote
omg omg omg omg omg |
|
|
CCP Logibro
C C P C C P Alliance
3988
|
Posted - 2013.12.10 12:51:00 -
[3] - Quote
I'm so excited! And I just can't hide it. Also, Fitting tool +1 kthx bai.
CCP Logibro // EVE Universe Community Team // Distributor of Nanites // Patron Saint of Logistics
|
|
|
CCP FoxFour
C C P C C P Alliance
14129
|
Posted - 2013.12.10 13:51:00 -
[4] - Quote
Aikuchi Tomaru wrote:I have no idea what you just said. Have an upvote.
I guess this means more community tools?
Thats the hope! :D
CCP FoxFour // Game Designer // Team True Grit
http://twitter.com/regnerba
|
|
|
CCP FoxFour
C C P C C P Alliance
14141
|
Posted - 2013.12.10 16:22:00 -
[5] - Quote
straya fox wrote:i guess it's not for mac
edit- mac users have feelings to you know, feels bad to be left out.
It's an SQLite3 file. I am sure if you search Google you can find something for browsing SQLite3 files. However if you don't know what an SQLite3 file is, it's probably best just to pretend it doesn't exist and move on.
CCP FoxFour // Game Designer // Team True Grit
http://twitter.com/regnerba
|
|
|
CCP FoxFour
C C P C C P Alliance
14186
|
Posted - 2013.12.11 14:40:00 -
[6] - Quote
Steve Renuken wrote:https://www.fuzzwork.co.uk/catma/
it's a very rough pass. will show you everything in the same super-category (where they share the same parent category. First category up is level, standard, advanced, etc. then you have the type.)
Thats a great start! Please keep us updated with your progress and well done good sir! :D
CCP FoxFour // Game Designer // Team True Grit
http://twitter.com/regnerba
|
|
|
CCP FoxFour
C C P C C P Alliance
14186
|
Posted - 2013.12.11 14:42:00 -
[7] - Quote
G Torq wrote:CCP FoxFour wrote:straya fox wrote:i guess it's not for mac
edit- mac users have feelings to you know, feels bad to be left out. It's an SQLite3 file. I am sure if you search Google you can find something for browsing SQLite3 files. However if you don't know what an SQLite3 file is, it's probably best just to pretend it doesn't exist and move on. He will have SQLite3 command-line tools built into his OS - he should be be just fine...
Shows you what I know of Macs :(
CCP FoxFour // Game Designer // Team True Grit
http://twitter.com/regnerba
|
|
|
CCP FoxFour
C C P C C P Alliance
14186
|
Posted - 2013.12.11 14:47:00 -
[8] - Quote
I am currently aware of a few issues with the SDE. Mainly: * typeID 351320 is missing from it and referenced in vehicles. For now know it's a type for the passenger seat. * Slots on vehicles and dropsuits have a missing attribute known as visibility and this is missing. You will notice some vehicles have more slots in the SDE than they do on TQ. Thats because of this. * Icons for some of the new types in 1.7 are missing from the TQ image server. While not directly SDE related it does affect tools. Shall hopefully have a fix for this soon.
The missing type and attribute will be added in the next version of the SDE and I will try and get a new version generated for Friday or Monday.
Keep the amazing work up guys! You are doing wonderful things with this and I cannot wait to see more.
CCP FoxFour // Game Designer // Team True Grit
http://twitter.com/regnerba
|
|
|
CCP FoxFour
C C P C C P Alliance
14261
|
Posted - 2013.12.18 16:05:00 -
[9] - Quote
This new version was supposed to also include the HMG changes and such, but it appears I may have failed. Give me a few moments to look into this. :)
CCP FoxFour // Game Designer // Team True Grit
http://twitter.com/regnerba
|
|
|
CCP FoxFour
C C P C C P Alliance
14262
|
Posted - 2013.12.18 16:20:00 -
[10] - Quote
Due to a misunderstanding on my part this release still contains data from the December 10th release, just with the added class and attribute. My apologies. New and proper version to follow tomorrow hopefully.
CCP FoxFour // Game Designer // Team True Grit
http://twitter.com/regnerba
|
|
|
|
|
|