These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Rhea 1.0 SDE is out

First post First post
Author
Previous Topic Next Topic
Bloemkoolsaus
Deep Core Mining Inc.
Caldari State
#41 - 2014-12-09 08:24:09 UTC
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
Doomheim
#42 - 2014-12-09 08:57:36 UTC
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
#43 - 2014-12-09 10:13:22 UTC
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
The Scope
Gallente Federation
#44 - 2014-12-09 13:16:16 UTC
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
Deep Core Mining Inc.
Caldari State
#45 - 2014-12-09 14:19:45 UTC
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
The Scope
Gallente Federation
#46 - 2014-12-09 14:31:03 UTC
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? Shocked
Thank you! :-)
Siklone
The Forsakened Few
We Forsakened Few
#47 - 2014-12-09 15:21:41 UTC  |  Edited by: Siklone
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
#48 - 2014-12-09 16:19:41 UTC
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 * Blink

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 XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Zifrian
Federal Defense Union
Gallente Federation
#49 - 2014-12-09 16:21:44 UTC
Any word on getting the issues fixed as noted above? Or did they get added already and I missed it?

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
CCP FoxFour
C C P
C C P Alliance
#50 - 2014-12-09 17:16:14 UTC
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 Tech Co

Third-party developer? Check out the official developers site for dev blogs, resources, and more.
Wollari
Dirt Nap Squad
#51 - 2014-12-09 22:05:47 UTC  |  Edited by: Wollari
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

Basically 774 celestial items are missing in the mapDenormalize table but are present in the mapCelestialStatistics table
* Star
* Unkown Anomly
* Planets

(I know there're no moons)

SELECT * FROM mapCelestialStatistics 
WHERE celestialID NOT IN (SELECT itemID FROM mapDenormalize)


--> 774 celestials that exists in mapCelestialStatistics but are not listed in mapDenormalize

So What's the highest number of known celestials

SELECT MAX(itemID) FROM `mapDenormalize` 
WHERE itemID IN (SELECT celestialID FROM mapCelestialStatistics)


--> 40487618

What's the count of newer items?

SELECT count(*) FROM `mapCelestialStatistics` WHERE `celestialID` > 40487618


--> exact 774. this must be the new generated celestials for Rhea

DOTLAN EveMaps | Your out-of-game map, navigation toolset, sov database, etc. since 2008
Risingson
#52 - 2014-12-09 23:52:14 UTC  |  Edited by: Risingson
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?
Wollari
Dirt Nap Squad
#53 - 2014-12-10 00:35:30 UTC
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
#54 - 2014-12-10 00:38:23 UTC
Okay I screwed things up ...

DOTLAN EveMaps | Your out-of-game map, navigation toolset, sov database, etc. since 2008
Wollari
Dirt Nap Squad
#55 - 2014-12-10 01:00:16 UTC  |  Edited by: Wollari
... 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.

DOTLAN EveMaps | Your out-of-game map, navigation toolset, sov database, etc. since 2008
Risingson
#56 - 2014-12-10 09:01:46 UTC
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 :)
Risingson
#57 - 2014-12-12 09:25:44 UTC
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 ?
Verite Rendition
F.R.E.E. Explorer
#58 - 2014-12-13 06:44:07 UTC
Thanks for the per-table MySQL dumps, Daimian. It made updating the map a piece of cake. Smile
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#59 - 2014-12-13 22:20:16 UTC
Verite Rendition wrote:
Thanks for the per-table MySQL dumps, Daimian. It made updating the map a piece of cake. Smile



psst. Not from Daimian. Blink

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Daimian Mercer
Deep Core Mining Inc.
Caldari State
#60 - 2014-12-13 22:23:23 UTC
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 | daimian.mercer@gmail.com