Pages: 1 [2] 3 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 8 post(s) |
|
CCP FoxFour
C C P C C P Alliance
3759
|
Posted - 2014.12.08 23:30:49 -
[31] - Quote
Daimian Mercer wrote:anybody know how to link the dmgTypeEffects for wormhole effects to an actual system? Trying to figure out new wormholes effects. I know the effects are in the SDE - just never been able to link them to a system without my own custom table.
I don't think those are exported in the SDE. From what I understand they are actually hidden beacons that are spawned in the system, so unless we exported the contents of the system they wouldn't be included. :(
@CCP_FoxFour // Technical Designer // Team Size Matters
Third-party developer? Check out the official developers site for dev blogs, resources, and more.
|
|
|
CCP FoxFour
C C P C C P Alliance
3759
|
Posted - 2014.12.08 23:32:17 -
[32] - Quote
Risingson wrote:Will we get the pretty new ui icons ? .... i hope i did not miss them but did not find them in the icons folders.
I will ask around for them to be included,
@CCP_FoxFour // Technical Designer // Team Size Matters
Third-party developer? Check out the official developers site for dev blogs, resources, and more.
|
|
Daimian Mercer
Deep Core Mining Inc. Caldari State
77
|
Posted - 2014.12.08 23:34:19 -
[33] - Quote
CCP FoxFour wrote:Daimian Mercer wrote:anybody know how to link the dmgTypeEffects for wormhole effects to an actual system? Trying to figure out new wormholes effects. I know the effects are in the SDE - just never been able to link them to a system without my own custom table. I don't think those are exported in the SDE. From what I understand they are actually hidden beacons that are spawned in the system, so unless we exported the contents of the system they wouldn't be included. :(
Ooo, tricky
Creator of Tripwire mapping tool -
EVE-O thread
Twitter | [email protected]
|
Zifrian
Licentia Ex Vereor The Gorgon Spawn
1591
|
Posted - 2014.12.08 23:37:46 -
[34] - Quote
Steve Ronuken wrote:Zifrian wrote:Aineko Macx wrote:ramAssemblyLineTypeDetailPerCategory table is missing data for categoryID=9, again. Thanks for checking this. It's a pretty important table for my facility processing. Also, it seems like there is a record missing for ancient relics here (category = 34) for the experimental lab. There are categories for strategic cruiser and subsystems though? That doesn't make much sense to me since you can't invent from those. Am I reading this table incorrectly? Finally, can someone link me or explain what the new table and field is? I must have missed it. Thanks for the early release FF. dgmExpressions It contains the details for how all the modifers hook together. And a new column on dgmEffects (which overrides the expression, iirc) Thanks, I meant does...not is...so tired today...
Modifiers for what? Skills or is this where we can get bonuses for the ships based on skills too?
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4422
|
Posted - 2014.12.08 23:54:23 -
[35] - Quote
Daimian Mercer wrote:CCP FoxFour wrote:Daimian Mercer wrote:anybody know how to link the dmgTypeEffects for wormhole effects to an actual system? Trying to figure out new wormholes effects. I know the effects are in the SDE - just never been able to link them to a system without my own custom table. I don't think those are exported in the SDE. From what I understand they are actually hidden beacons that are spawned in the system, so unless we exported the contents of the system they wouldn't be included. :( Ooo, tricky
select * from mapDenormalize where typeid=30575;
mapDenormalize for the win.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Daimian Mercer
Deep Core Mining Inc. Caldari State
77
|
Posted - 2014.12.08 23:56:14 -
[36] - Quote
Thanks Steve!
I thought I tried that table every which way from Sunday. Got it working now!
Creator of Tripwire mapping tool -
EVE-O thread
Twitter | [email protected]
|
|
CCP FoxFour
C C P C C P Alliance
3761
|
Posted - 2014.12.09 00:02:30 -
[37] - Quote
Shows you WTF I know...
@CCP_FoxFour // Technical Designer // Team Size Matters
Third-party developer? Check out the official developers site for dev blogs, resources, and more.
|
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4422
|
Posted - 2014.12.09 00:06:28 -
[38] - Quote
Zifrian wrote:Steve Ronuken wrote:Zifrian wrote:Aineko Macx wrote:ramAssemblyLineTypeDetailPerCategory table is missing data for categoryID=9, again. Thanks for checking this. It's a pretty important table for my facility processing. Also, it seems like there is a record missing for ancient relics here (category = 34) for the experimental lab. There are categories for strategic cruiser and subsystems though? That doesn't make much sense to me since you can't invent from those. Am I reading this table incorrectly? Finally, can someone link me or explain what the new table and field is? I must have missed it. Thanks for the early release FF. dgmExpressions It contains the details for how all the modifers hook together. And a new column on dgmEffects (which overrides the expression, iirc) Thanks, I meant does...not is...so tired today... Modifiers for what? Skills or is this where we can get bonuses for the ships based on skills too?
Basically, it's the data that programs like EFT and pyfa require, and currently rip out of the cache. I'm not sure how it all works though.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Sable Blitzmann
Aperture Harmonics No Holes Barred
145
|
Posted - 2014.12.09 02:30:54 -
[39] - Quote
Steve Ronuken wrote:Zifrian wrote:Steve Ronuken wrote:Zifrian wrote:Aineko Macx wrote:ramAssemblyLineTypeDetailPerCategory table is missing data for categoryID=9, again. Thanks for checking this. It's a pretty important table for my facility processing. Also, it seems like there is a record missing for ancient relics here (category = 34) for the experimental lab. There are categories for strategic cruiser and subsystems though? That doesn't make much sense to me since you can't invent from those. Am I reading this table incorrectly? Finally, can someone link me or explain what the new table and field is? I must have missed it. Thanks for the early release FF. dgmExpressions It contains the details for how all the modifers hook together. And a new column on dgmEffects (which overrides the expression, iirc) Thanks, I meant does...not is...so tired today... Modifiers for what? Skills or is this where we can get bonuses for the ships based on skills too? Basically, it's the data that programs like EFT and pyfa require, and currently rip out of the cache. I'm not sure how it all works though.
Neither do I, and I work on pyfa! lol
It'd be great if documentation was available for it somewhere. Basically, though, it expresses the relationship of a modifier towards it's target using attributes from both.
For example, and I'm by no means an expert, Co-Possessor has an effect called "cpuMultiplierPostMulCpuOutputShip". This effect is shown in the dgmEffects table that it is assigned the pre and post expression of 2843 and 2844, respectively.
The pre expression (2843) is in the dgmExpressions table, and it basically has attributes that declare the source attribute (CPU multiplier value of Co-Processor) and the target attribute (CPU Output of the current ship), along with an operand to use on the equation and the expression name (usually something like ((CurrentShip->cpuOutput).(PostMul)).RemoveItemModifier (cpuMultiplier).
Every item has various effects. Each effect has a set of pre and post expressions defining how that item interacts with it's target.
Also, thanks FoxFour for getting that table included in the SDE! |
Indalecia
174
|
Posted - 2014.12.09 05:54:06 -
[40] - Quote
Here's a way of translating modifierInfo into actual dogma expressions: https://github.com/Artefact2/libdogma/blob/master/tools/bootstrap_from_json#L356
TL;DR:
For ItemModifiers: (($domain->$modifiedAttributeID).($operator)).AIM($modifyingAttributeID) (($domain->$modifiedAttributeID).($operator)).RIM($modifyingAttributeID)
For LocationRequiredSkillModifiers: (($domain[$skillTypeID]->$modifiedAttributeID).($operator)).ALRSM($modifyingAttributeID) (($domain[$skillTypeID]->$modifiedAttributeID).($operator)).RLRSM($modifyingAttributeID)
It would be nice to get mappings between operators in modifierInfo and actual dogma associations. So far 5 seems to be PostDiv.
It would be also very nice to get a way to find all the "modes" a ship hull has without having to hardcode it.
https://o.smium.org/ GÇö v0.13.2 GÇö A browser-based fitting tool and loadout sharing platform
|
|
Bloemkoolsaus
Viperfleet Inc. Disavowed.
177
|
Posted - 2014.12.09 08:24:09 -
[41] - Quote
CCP FoxFour wrote:Daimian Mercer wrote:anybody know how to link the dmgTypeEffects for wormhole effects to an actual system? Trying to figure out new wormholes effects. I know the effects are in the SDE - just never been able to link them to a system without my own custom table. I don't think those are exported in the SDE. From what I understand they are actually hidden beacons that are spawned in the system, so unless we exported the contents of the system they wouldn't be included. :(
Sure it is. You'll want to look at the the mapdenormalize table. |
Drailen
New Eden Technology Services
77
|
Posted - 2014.12.09 08:57:36 -
[42] - Quote
Risingson wrote:Will we get the pretty new ui icons ? .... i hope i did not miss them but did not find them in the icons folders. +1 for this, I couldn't see them either. |
Lors Dornick
Kallisti Industries Solar Assault Fleet
1149
|
Posted - 2014.12.09 10:13:22 -
[43] - Quote
CCP FoxFour wrote:Shows you WTF I know... Luckily we voted to have Uncle Stevie on the CSM, and he knows ;)
CCP Greyscale: As to starbases, we agree it's pretty terrible, but we don't want to delay the entire release just for this one factor.
|
Jack Hayson
Atztech Inc. Ixtab.
33
|
Posted - 2014.12.09 13:16:16 -
[44] - Quote
Daimian Mercer wrote:anybody know how to link the dmgTypeEffects for wormhole effects to an actual system? Trying to figure out new wormholes effects. I know the effects are in the SDE - just never been able to link them to a system without my own custom table. Interesting... finding the effect beacons was easy. I got the typeID from (select * FROM mapDenormalize WHERE itemName='Unknown Anomaly') and then the name of the effect from the invTypes table.
However I am completely lost how to connect the beacons to their effect on your ship. I can't find their typeID in any of the dgm tables. :-/ There also isn't a difference between the typeID of e.g. a C1 Magnetar beacon and a C6 Magnetar beacon. |
Bloemkoolsaus
Viperfleet Inc. Disavowed.
177
|
Posted - 2014.12.09 14:19:45 -
[45] - Quote
Jack Hayson wrote:However I am completely lost how to connect the beacons to their effect on your ship. I can't find their typeID in any of the dgm tables. :-/ There also isn't a difference between the typeID of e.g. a C1 Magnetar beacon and a C6 Magnetar beacon.
Try this:
SELECT i.typename, t.attributename, t.displayname, a.valuefloat, t.unitid FROM dgmtypeattributes a INNER JOIN dgmattributetypes t ON t.attributeid = a.attributeid INNER JOIN invtypes i ON i.typeid = a.typeid WHERE i.typename LIKE '%pulsar%' |
Jack Hayson
Atztech Inc. Ixtab.
33
|
Posted - 2014.12.09 14:31:03 -
[46] - Quote
Bloemkoolsaus wrote:Jack Hayson wrote:However I am completely lost how to connect the beacons to their effect on your ship. I can't find their typeID in any of the dgm tables. :-/ There also isn't a difference between the typeID of e.g. a C1 Magnetar beacon and a C6 Magnetar beacon. Try this: SELECT i.typename, t.attributename, t.displayname, a.valuefloat, t.unitid FROM dgmtypeattributes a INNER JOIN dgmattributetypes t ON t.attributeid = a.attributeid INNER JOIN invtypes i ON i.typeid = a.typeid WHERE i.typename LIKE '%pulsar%'
Ahh... how did I miss that? Thank you! :-) |
Siklone
The Arrow Project
0
|
Posted - 2014.12.09 15:21:41 -
[47] - Quote
Steve @ Fuzzwork - thanks for posting these! The custom Postgres format you used (pg_dump -Fc) is already compressed, so you don't need to bzip them :)
In case anyone wants to get this into the text format:
~> bzip2 -d postgres-rhea-1.109013.sql.bz2 && pg_restore postgres-rhea-1.109013.sql > postgres-rhea-1.109013.txtdmp.sql |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4430
|
Posted - 2014.12.09 16:19:41 -
[48] - Quote
Siklone wrote:Steve @ Fuzzwork - thanks for posting these! The custom Postgres format you used (pg_dump -Fc) is already compressed, so you don't need to bzip them :)
In case anyone wants to get this into the text format:
~> bzip2 -d postgres-rhea-1.109013.sql.bz2 && pg_restore postgres-rhea-1.109013.sql > postgres-rhea-1.109013.txtdmp.sql
That'd be a sideeffect of bzip2 *
Just as a tip:
bunzip2 -c postgres-rhea-1.109013.sql.bz2 | pg_restore > postgres-rhea-1.109013.txtdmp.sql
if you don't want that pesky intermediate file ;)
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Zifrian
Licentia Ex Vereor The Gorgon Spawn
1591
|
Posted - 2014.12.09 16:21:44 -
[49] - Quote
Any word on getting the issues fixed as noted above? Or did they get added already and I missed it?
GÇ£Any fool can criticize, condemn, and complain - and most fools do. GÇ¥ - Dale Carnegie
Maximze your Industry Potential! - Download EVE Isk per Hour!
|
|
CCP FoxFour
C C P C C P Alliance
3767
|
Posted - 2014.12.09 17:16:14 -
[50] - Quote
Zifrian wrote:Any word on getting the issues fixed as noted above? Or did they get added already and I missed it?
Sorry, been pretty busy. Can you summarize all the issues into one post?
@CCP_FoxFour // Technical Designer // Team Size Matters
Third-party developer? Check out the official developers site for dev blogs, resources, and more.
|
|
|
Wollari
Dirt Nap Squad Dirt Nap Squad.
78
|
Posted - 2014.12.09 22:05:47 -
[51] - Quote
I thought the new systems would have Shattered planets. In fact the mapDenormalize table doesn't included anything for the 2 new regions 11000031 and 11000032
DOTLAN EveMaps-á| Your out-of-game map, navigation toolset, sov database, etc. since 2008
|
Risingson
90
|
Posted - 2014.12.09 23:52:14 -
[52] - Quote
Wollari wrote:I thought the new systems would have Shattered planets. In fact the mapDenormalize table doesn't included anything for the 2 new regions 11000031 and 11000032
SELECT * FROM mapDenormalize WHERE (regionID = 11000031) OR (regionID = 11000032) yield 262 rows including 172 shattered planets
Eveeye Maps Alpha | Eveeye-áPrototype YD-114 Onboard Computer Systems
|
Wollari
Dirt Nap Squad Dirt Nap Squad.
78
|
Posted - 2014.12.10 00:35:30 -
[53] - Quote
Risingson wrote:Wollari wrote:I thought the new systems would have Shattered planets. In fact the mapDenormalize table doesn't included anything for the 2 new regions 11000031 and 11000032 SELECT * FROM mapDenormalize WHERE (regionID = 11000031) OR (regionID = 11000032) yields 262 rows including 172 shattered planets. I am using SDEExternalsToSql Tool. Maybe your table is not updated? hmmmm Well I used Fuzzys mysql conversation.
DOTLAN EveMaps-á| Your out-of-game map, navigation toolset, sov database, etc. since 2008
|
Wollari
Dirt Nap Squad Dirt Nap Squad.
78
|
Posted - 2014.12.10 00:38:23 -
[54] - Quote
Okay I screwed things up ...
DOTLAN EveMaps-á| Your out-of-game map, navigation toolset, sov database, etc. since 2008
|
Wollari
Dirt Nap Squad Dirt Nap Squad.
78
|
Posted - 2014.12.10 01:00:16 -
[55] - Quote
... it's too late
DOTLAN EveMaps-á| Your out-of-game map, navigation toolset, sov database, etc. since 2008
|
Risingson
90
|
Posted - 2014.12.10 09:01:46 -
[56] - Quote
Wollari wrote:... just fyi. I didn't fully loaded the tables. And the staStationstable had an outdated smallint for the typeID :-) All failures on my part. ... it's getting too late. sleep = efficiency sometimes :)
Eveeye Maps Alpha | Eveeye-áPrototype YD-114 Onboard Computer Systems
|
Risingson
91
|
Posted - 2014.12.12 09:25:44 -
[57] - Quote
CCP FoxFour wrote:Risingson wrote:Will we get the pretty new ui icons ? .... i hope i did not miss them but did not find them in the icons folders. I will ask around for them to be included, Might we get them new ui icons in a 1.1 IEC ?
Eveeye Maps Alpha | Eveeye-áPrototype YD-114 Onboard Computer Systems
|
Verite Rendition
F.R.E.E. Explorer
141
|
Posted - 2014.12.13 06:44:07 -
[58] - Quote
Thanks for the per-table MySQL dumps, Daimian. It made updating the map a piece of cake. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4488
|
Posted - 2014.12.13 22:20:16 -
[59] - Quote
Verite Rendition wrote:Thanks for the per-table MySQL dumps, Daimian. It made updating the map a piece of cake.
psst. Not from Daimian.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Daimian Mercer
Deep Core Mining Inc. Caldari State
85
|
Posted - 2014.12.13 22:23:23 -
[60] - Quote
Yes, send your praise to Steve Ronuken. He is the great help behind all those SDE conversions and such.
Thanks Steve for the hard work you do so quickly!
Creator of Tripwire mapping tool -
EVE-O thread
Twitter | [email protected]
|
|
|
|
|
Pages: 1 [2] 3 :: one page |
First page | Previous page | Next page | Last page |