DUST Search - SDE - my primer / notes for general consumption

All Channels

General Discussions

SDE - my primer / notes for general consumption

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

Monitor this thread via RSS [?]

Pages: 1 :: [one page]

Author	Thread Statistics \| Show CCP posts - 3 post(s)
G Torq ALTA B2O 270	Posted - 2013.12.10 14:37:00 - [1] - Quote Introduction The following is meant as a primer for the Dust SDE, and how to use it for some basic operations, as being written by myself, and others from the #dust-dev channel. The SDE is provided as a single file, which is an SQLite3 database, that can either be used directly, or trivially converted for use on another platform. For browsing it easily, the program SQLiteSpy can be used. These posts will also contain some sample SQL, that should work directly with SQLite3. Structure of Catma The provided data represents a set of Dust classes (or types of objects/data) used in the game, with each Object belonging to 1 class (with some exceptions). The classes included are: ActiveSkillGainBooster - Active SP Boosters AttributeData - Listing of all Attributes AttributeDescriptor - Display Hints for Attributes DamageType - Damage Types DustHealingActor - Supply depot healing attributes DustModule - Every module/equipment/weapon DustOMSOrbitalStrike - Orbital Strikes DustPawn - Dropsuits ExplosionContent - Explosion types FactionBoosterAmarr - LP Boosters, Amarr FactionBoosterCaldari - LP Boosters, Caldari FactionBoosterGallente - LP Boosters, Gallente FactionBoosterMinmatar - LP Boosters, Minmatar InstallationContent - All installations InventoryCategory - Market Grouping ModifierDeclaration - Various attribute modifiers PassiveSkillGainBooster - Passive SP Boosters ProjectileContent - All Projectiles Tag - Tags TurretWeaponContent - Turret weapons (not turrets) VehicleContent - All vehicles The data is provided in 3 tables, which describes the type and class of the data, and the attributes: CatmaAttributes - Attributes CatmaClasses - The class of every object CatmaTypes - The specific typeName of each object Every object and class in the system is identified by a "typeID" value, a number that uniquely identifies it. CatmaClasses The CatmaClasses table consists of 2 columns: typeID - the typeID for an object className - the name of the class that object belongs to To locate e.g. all suits, you can first get a list of all objects (all typeIDs) of the class "DustPawn" from CatmaClasses, and then retrieve any relevant attributes from CatmaAttributes. CatmaTypes The CatmaTypes table consists of 2 columns: typeID - the typeID of an object typeName - the specific typeName of that object Most, if not all objects and classes in the system have a typeName associated with it, and the typeName is structured such that objects of a given kind have similar typeNames. CatmaAttributes The CatmaAttributes table consists of 5 columns: typeID - typeID of an object catmaAttributeName - name of an attribute catmaValueInt - integer (whole number) value catmaValueFloat - float (decimal number) value catmaValueText - text value Any catmaAttributeName will only use 1 of the three catmaValue* fields, and it cannot immediately be determined from the data which to use. You will basically need to look at your data and see what field to use for any catmaAttributeName. (more when written ...) Team Fairy DUST
G Torq ALTA B2O 270	Posted - 2013.12.10 14:37:00 - [2] - Quote Placeholder! Team Fairy DUST
G Torq ALTA B2O 271	Posted - 2013.12.10 14:38:00 - [3] - Quote Placeholder! Team Fairy DUST
G Torq ALTA B2O 271	Posted - 2013.12.10 14:39:00 - [4] - Quote Placeholder! Team Fairy DUST
G Torq ALTA B2O 274	Posted - 2013.12.11 17:44:00 - [5] - Quote Placeholder! Team Fairy DUST
Viktor Hadah Jr 0uter.Heaven Proficiency V. 1422	Posted - 2013.12.11 17:53:00 - [6] - Quote +1 because it looks smart and i have no clue what it is. For the Empire Dual tanking is a sin Buying Daemon Shotgun
G Torq ALTA B2O 277	Posted - 2013.12.11 18:03:00 - [7] - Quote Viktor Hadah Jr wrote: +1 because it looks smart and i have no clue what it is. It is basically what drives this: http://dust.thang.dk/showgear.php?Display=InfWeapon# Team Fairy DUST

CCP FoxFour C C P C C P Alliance 14252	Posted - 2013.12.12 11:16:00 - [8] - Quote This is great stuff! Thanks for sharing. :) CCP FoxFour // Game Designer // Team True Grit http://twitter.com/regnerba

G Torq ALTA B2O 316	Posted - 2013.12.12 11:20:00 - [9] - Quote CCP FoxFour wrote: This is great stuff! Thanks for sharing. :) Sharing Is Caring - just repaying the favor you did us all by releasing the SDE Team Fairy DUST
Steve Renuken Guardian Solutions DARKSTAR ARMY 36	Posted - 2013.12.12 11:21:00 - [10] - Quote If you're ever unsure of the type you'll be getting back, the following snippet is of use, if you're using the mysql version I provide. The sqlite version doesn't support it, due to a lack of nulls in the DB at present. coalesce(catmaValueInt,catmaValueReal,catmaValueText) value


CCP FoxFour C C P C C P Alliance 14252	Posted - 2013.12.12 11:24:00 - [11] - Quote Steve Renuken wrote: If you're ever unsure of the type you'll be getting back, the following snippet is of use, if you're using the mysql version I provide. The sqlite version doesn't support it, due to a lack of nulls in the DB at present. coalesce(catmaValueInt,catmaValueReal,catmaValueText) value Is that why that doesn't work on the SQLite version. I tried and thought I did some research that said SQLite just doesn't have coalesce. Any idea how to insert null values in SQLite3? I couldn't really find a way but that may be my Google Fuu being terrible. CCP FoxFour // Game Designer // Team True Grit http://twitter.com/regnerba

Absolute Idiom II SyNergy Gaming EoN. 920	Posted - 2013.12.12 12:15:00 - [12] - Quote Maybe you declared the columns as 'NOT NULL' when you created the database? If so, then the table will not accept null values. Fanfest 2012 - Winning Team + MVP - £1100 in prizes Fanfest 2013 - Winning Team - £500 in prizes Fanfest 2014 - ???
Steve Renuken Guardian Solutions DARKSTAR ARMY 36	Posted - 2013.12.12 12:49:00 - [13] - Quote CCP FoxFour wrote: Steve Renuken wrote: If you're ever unsure of the type you'll be getting back, the following snippet is of use, if you're using the mysql version I provide. The sqlite version doesn't support it, due to a lack of nulls in the DB at present. coalesce(catmaValueInt,catmaValueReal,catmaValueText) value Is that why that doesn't work on the SQLite version. I tried and thought I did some research that said SQLite just doesn't have coalesce. Any idea how to insert null values in SQLite3? I couldn't really find a way but that may be my Google Fuu being terrible. Turns out sqlite can support nulls. running: update catmaattributes set catmavalueint=null where catmavalueint='None'; using the sqlite3 command line that's on my linux box works a treat. As for how you'd set them, that's going to be highly dependant on the software you're using to work with the database, I'd suspect.

CCP Nullarbor C C P C C P Alliance 3363	Posted - 2013.12.12 14:42:00 - [14] - Quote Someone should setup a DUST developer wiki CCP Nullarbor // Exotic Dancer // Team True Grit

Musta Tornius Turalyon 514 Turalyon Alliance 781	Posted - 2013.12.12 15:42:00 - [15] - Quote CCP Nullarbor wrote: Someone should setup a DUST developer wiki https://neweden-dev.com/Main_Page Site's up just need to start building up the content, we got several volunteers and a shitton of information already. Everyone just have been so busy playing around with the SDE. Hold your horses and contribute and things will roll along nicely. Don't forget #dust-dev on IRC Coldfront either! Dust514 Weapon Range & Information Team Fairy DUST
Jack Kittinger DUST University Ivy League 67	Posted - 2013.12.12 15:45:00 - [16] - Quote Viktor Hadah Jr wrote: +1 because it looks smart and i have no clue what it is. ditto +1
Aikuchi Tomaru Subdreddit Test Alliance Please Ignore 1262	Posted - 2013.12.12 16:18:00 - [17] - Quote CCP Nullarbor wrote: Someone should setup a DUST developer wiki That's the place where all you devs can anonymously leak what we can expect in future patches!
G Torq ALTA B2O 316	Posted - 2013.12.12 16:38:00 - [18] - Quote CCP Nullarbor wrote: Someone should setup a DUST developer wiki Nullar, I'd like to direct you to this post: https://forums.dust514.com/default.aspx?g=posts&m=1586006#post1586006 It was posted shortly after the SDE was announced, and I think it contains the information you're looking for. Team Fairy DUST
chase rowland The Enclave Syndicate Dark Taboo 121	Posted - 2013.12.12 19:50:00 - [19] - Quote good stuff mate


Pages: 1 :: [one 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.