DUST Search - Sticky:DUST Uprising 1.7 Static Data Export (SDE)

All Channels

General Discussions

Sticky:DUST Uprising 1.7 Static Data Export (SDE)

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: [1] 2 3 :: one page

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

Grit Breather Cannonfodder PMC 872	Posted - 2013.12.10 12:50:00 - [3] - Quote Reserved "Why, sometimes I've believed as many as six impossible things before breakfast." GÇò Lewis Carroll, Alice in Wonderland
G Torq ALTA B2O 267	Posted - 2013.12.10 12:50:00 - [4] - Quote In support of this news, I'd like to remind everybody that we have a Dust Development IRC channel on Coldfront.net named #dust-dev (parallel to #eve-dev and #DUST514 channels). Here we have some various people currently engaged in 3rd party FanSites (Myself w/ dust.thang.dk, Heinz Doofenshertz from http://Dust514Stats.com etc), and we will be digging into the SDE and discussing our findings there over the next days and weeks. In parallel, a new website has been created for documenting 3rd party development for EVE:Online, Dust514 and EVE:Valkyrie - http://www.NewEden-Dev.com/ So far it is just a mostly-empty Wiki (MediaWiki), but as we discover things from the Dust-SDE and collect details from the EVE-SDE and EVE-API. End-goal is to create a 1-stop-shop for all the information one would need for developing for anything in the EVE / New Eden universe. Note: We are aware of the efforts already done for the EVE-SDE and EVE-API, and we have reached out to e.g. "Peter Powers" of http://3rdPartyEve.net who has confirmed that 3rd party Dust sites will be welcome there as well. Team Fairy DUST
Mc Ribwich Subdreddit Test Alliance Please Ignore 431	Posted - 2013.12.10 12:50:00 - [5] - Quote YES Dust 514 video maker Subdreddit EU director and co-director of propaganda Twitter
Grit Breather Cannonfodder PMC 872	Posted - 2013.12.10 12:50:00 - [6] - Quote Reserved "Why, sometimes I've believed as many as six impossible things before breakfast." GÇò Lewis Carroll, Alice in Wonderland
Dexter Peabody Goonfeet Top Men. 85	Posted - 2013.12.10 12:51:00 - [7] - Quote Jetpacks?

CCP Logibro C C P C C P Alliance 3988	Posted - 2013.12.10 12:51:00 - [8] - 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

G Torq ALTA B2O 267	Posted - 2013.12.10 12:51:00 - [9] - Quote CCP FoxFour wrote: Now... where is my DUST fitting tool. :D When I'm done integrating it, I'll open up my site.... give me a few hours...days...weeks though Team Fairy DUST
Musta Tornius Turalyon 514 Turalyon Alliance 677	Posted - 2013.12.10 12:58:00 - [10] - Quote Woo, sde!!! Time to see what info I can get. Dust514 Weapon Range & Information

Spectral Clone Dust2Dust. Top Men. 847	Posted - 2013.12.10 13:07:00 - [11] - Quote Epic! Well done CCP FoxFour! KDR > ALL ME > KDR ME > ALL
Vrain Matari ZionTCD Public Disorder. 1339	Posted - 2013.12.10 13:07:00 - [12] - Quote Sweet! Goodness will come of this. +1 ?o?Four. I support SP rollover.
Brush Master HavoK Core RISE of LEGION 993	Posted - 2013.12.10 13:18:00 - [13] - Quote Congrats foxy 514th Wing // Team Fairy DUST // Havok Core [email protected]
Aikuchi Tomaru Subdreddit Test Alliance Please Ignore 1200	Posted - 2013.12.10 13:44:00 - [14] - Quote I have no idea what you just said. Have an upvote. I guess this means more community tools?

CCP FoxFour C C P C C P Alliance 14129	Posted - 2013.12.10 13:51:00 - [15] - 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

SponkSponkSponk The Southern Legion The Umbra Combine 580	Posted - 2013.12.10 13:52:00 - [16] - Quote this..... is massive. "Pulvis et umbra sumus. (We are but dust and shadow.)" GÇò Horace, The Odes of Horace
Robert JD Niewiadomski NULLIMPEX INC 725	Posted - 2013.12.10 13:55:00 - [17] - Quote CCP, Are you willing to zipdump DUST 514 3D models on us someday? There are ppl out there who would apparently like to make DUST version of Clear Skies Or costumes for cosplay at Fanfest... https://forums.eveonline.com/default.aspx?g=posts&m=3935794#post3935794 F.E.A.R. stands for False Expectations Assumed Real
Absolute Idiom II SyNergy Gaming EoN. 915	Posted - 2013.12.10 13:56:00 - [18] - Quote Bravo to FoxFour for doing this in your spare time! However, at the same time it's a little disconcerting that it had to be done in a dev's spare time - given the obvious value of 3rd party tools to building and supporting MMO communities. Fanfest 2012 - Winning Team + MVP - £1100 in prizes Fanfest 2013 - Winning Team - £500 in prizes Fanfest 2014 - ???
dent 308 Subdreddit Test Alliance Please Ignore 2063	Posted - 2013.12.10 14:03:00 - [19] - Quote On this like ugly on an ape. Hail Satan
Abu Stij WaffleDingos 257	Posted - 2013.12.10 14:12:00 - [20] - Quote omg omg omg omg Do You Like Waffles?

Vyzion Eyri The Southern Legion The Umbra Combine 2203	Posted - 2013.12.10 14:17:00 - [21] - Quote Christmas is real! "When nothing is going your way, go out of your way to do nothing."
Samahiel Goonfeet Top Men. 86	Posted - 2013.12.10 15:02:00 - [22] - Quote As someone who's a perpetual pessimist. This is really, really cool.
Maken Tosch DUST University Ivy League 5772	Posted - 2013.12.10 16:04:00 - [23] - Quote Samahiel wrote: As someone who's a perpetual pessimist. This is really, really cool. This message was brought to you by Top Men (tm). OK, CCP. When are knives finally going to be improved?
straya fox Sad Panda Solutions 121	Posted - 2013.12.10 16:10:00 - [24] - Quote i guess it's not for mac edit- mac users have feelings to you know, feels bad to be left out.

CCP FoxFour C C P C C P Alliance 14141	Posted - 2013.12.10 16:22:00 - [25] - 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

Abu Stij WaffleDingos 257	Posted - 2013.12.10 16:30:00 - [26] - Quote 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. Google isn't allowed on Macs. Steve Jobs dying wish. Do You Like Waffles?
THUNDERGROOVE ZionTCD Public Disorder. 383	Posted - 2013.12.10 17:04:00 - [27] - Quote I was trying a write a quick script to dump it all into a text file that more human readable but Dust updated to quick ZionTCD Director & Ammar Loyalist Amarr Sentinel \| Amarr Logi \| *Losematar* Scout What is a signature?
Argo Filch Cannonfodder PMC 66	Posted - 2013.12.10 17:04:00 - [28] - 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. Valentina Studio is free to use after registering and and the most professional feeling tool to query the data from that sqlite file. And there's also a bunch of open source tools too you can use. Google is your friend but i'd really recommend Valentina Studio.
dent 308 Subdreddit Test Alliance Please Ignore 2064	Posted - 2013.12.10 17:05:00 - [29] - 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. MesaSQLIite is open source and will let you browse the data. Hail Satan
Earl Crushinator Subdreddit Test Alliance Please Ignore 192	Posted - 2013.12.10 17:10:00 - [30] - Quote dent 308 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. MesaSQLIite is open source and will let you browse the data. And there's always sqlite3 via the Terminal if you want to start a unix beard.



Pages: [1] 2 3 :: one page
First page \| Previous page \| Next page \| Last page

COPYRIGHT NOTICE
EVE Online/DUST514, the EVE/DUST514 logo, EVE/DUST514 and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to OMG Labs to use EVE Online/DUST514 and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, OMG Labs. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.