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 |
First page | Previous page | Next page | Last page |