| Author |
Thread Statistics | Show CCP posts - 6 post(s) |
|
CCP Creber Cattus
C C P
C C P Alliance
7
   |
Posted - 2013.11.15 13:10:00 -
[1] - Quote
You can get it here
Noticeable changes are:
The database dump is now exported from SQL Server 2012, so it can't be imported directly into SQL Server 2008 databases.
tables that have to do with certificates have been removed from the database dump.
certificates.yaml file has been added that contains data about the new certificates.
[*] ship types (in the typesIDs.yaml file) now have a attribute called "masteries" that list all certificates needed for each mastery level. |
|
|
CCP Prism X
C C P
C C P Alliance
1328
|
Posted - 2013.11.15 13:13:00 -
[2] - Quote
Why do you guys still do your dumps in MSSQL?! Nobody uses that bleep except you! Come join the NoSQL Revolution already! 
@CCP_PrismX
EVE Database Developer and Expert Ranter
Member of a Different Team, every day. |
|
|
CCP Prism X
C C P
C C P Alliance
1328
|
Posted - 2013.11.15 13:15:00 -
[3] - Quote
Also, you only have four likes!
Noob!
@CCP_PrismX
EVE Database Developer and Expert Ranter
Member of a Different Team, every day. |
|
|
CCP Creber Cattus
C C P
C C P Alliance
21
|
Posted - 2013.11.29 16:30:00 -
[4] - Quote
Updated version of the SDE is now available. Rubicon 1.0.4
Get it here |
|
|
CCP Creber Cattus
C C P
C C P Alliance
21
|
Posted - 2013.11.30 01:54:00 -
[5] - Quote
Rob Crowley wrote:
Cool. CCP Creber Cattus best Cattus! Btw, did you misspell Creeper Cactus?
No, correctly spelled... it's actually Latin 
Captain Thunk wrote:Haven't checked V1.04 but V1.0 didn't have extra dgmAttribute data concerning the mobile siphons - things like the ranges.
I'm at home now... might remember to check for you after the weekend if it is stored in dgmAttributes or if it is somewhere else. No promises though as I might forget. |
|
|
CCP Creber Cattus
C C P
C C P Alliance
25
|
Posted - 2014.01.30 11:28:00 -
[6] - Quote
Desmont McCallock wrote:Captain Thunk wrote:Rob Crowley wrote:Desmont McCallock wrote:The description for the values can be found in the 'dgmAttributeTypes' table, column "displayName" (ship bonuses are with categoryID = 7) although some lack a proper 'displayName' (e.g. eliteBonusHeavyInterdictors1, eliteBonusElectronicAttackShip1, eliteBonusBlackOps1 etc.) The vast majority of ship bonuses in dgmTypeAttributes have generic attributes from category 7 or 9 that don't have a display name and don't reference the type of bonus at all. What would be required would be a displayName for the ship bonus effect in dgmTypeEffects. And there's also the problem of linking the bonus values in dgmTypeAttributes with the appropriate entries in dgmTypeEffects. E.g. for a Merlin we have "shipBonusCF = -4" and "shipBonusCF2 = 5", but in dgmTypeEffects there's "shipShield*ResistanceCF2" and "shipHybridDamageBonusCF2". So I don't really see a way to link the right numbers to the corresponding effects. Kid Delicious wrote:Using the Nestor as an example I grepped Steve's dump for "Amarr Battleship bonuses" which appears in the traits tab for that ship and got nothing. Well, the "Amarr Battleship" part is apparently coded as "AB" which would still be somewhat usable, what I'm missing more is the text description of the bonus' effect. The data is incomplete, the static DB released by CCP is missing a key table, called dgmExpressions iirc. This table contains the necessary information to link the Attributes and Effects. It also uses python executable code which makes it difficult to work with unless your app is also in python. To get this table you need Entity's Reverence and a script to extract it from the client. Ah yes, you are describing the perfect solution, scrubbing the bulk data from EVE cache folder. P.S. I'm not mocking you Captain Thunk, merely CCP for an incomplete SDE.
I have not checked if we changed anything in Rubicon 1.1.2 that we ship with the SDE (except adding the traits), but I THINK not.. :p |
|
| |
|