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.
 

Static Data Export bug in Thera size?
Author
Previous Topic Next Topic
Virgil Armstrong
Sunrise Services
#1 - 2015-07-20 08:21:36 UTC
I've been trying to calculate the size of solar systems by looking into the mapSolarSystems table for radius and the x,y,z min/max. Taking a few samples, most systems seem about right, Thera however should be like 400 AU in diameter right?

mysql> select (xMax - xMin)/149597870700 as xSize, (yMax - yMin)/149597870700 as ySize,  (zMax - zMin)/149597870700 as zSize, radius/149597870700 as radius_au from mapSolarSystems where solarSystemName = "Thera";


+-------------------+--------------------+-------------------+-------------------+
| xSize             | ySize              | zSize             | radius_au         |
+-------------------+--------------------+-------------------+-------------------+
| 40.10752273361067 | 13369.174244536891 | 40.10752273361067 | 20.80770413296301 |
+-------------------+--------------------+-------------------+-------------------+


Seems about a factor 10 off. Is this a CCP bug? or just a translation bug (using Fuzzwork's data export).

If it is a CCP bug, how do I file it? In the https://community.eveonline.com/support/bug-reports/ is no section for the developer toolkit.
Kali Izia
GoomWaffe
#2 - 2015-07-20 08:47:26 UTC
Those values aren't used for anything in-game so they just fudged the numbers. IIRC there are some planets etc where you'll see "wrong" numbers too.

Here's a quote from Foxfour about Thera:
Quote:
Had a quick chat with CCP Masterplan:
While creating Thera we could not find any use of the solar system radius and nor could we figure out a correlation between it and the planet layout. It even appears that the map basis it's radius off the outermost planet as when Thera was first created with the system radius set to 1AU nothing broke. So in the end the radius of Thera was just set to the outermost planet + 10%... or something.
TL;DR: The static radius values are mostly an unused relic and don't really represent anything important.
Have fun! :D
Virgil Armstrong
Sunrise Services
#3 - 2015-07-20 10:04:19 UTC
hmm, the "or something" it seems.

when using the planet layout the max distance from the sun in Thera is about 203 AU. Gonna use this to calculate the size.

select abs(round((m.x)/149597870700)) as x, 
abs(round((m.y)/149597870700)) as y, 
abs(round((m.z)/149597870700)) as z, 
m.itemName
from mapSolarSystems as s 
left join mapDenormalize as m on s.solarSystemID = m.solarSystemID 
where s.solarSystemName = "Thera";


+------+------+------+-----------------------------------------------------------+
| x    | y    | z    | itemName                                                  |
+------+------+------+-----------------------------------------------------------+
|  125 |    2 |   71 | Thera XII - The Sanctuary Surveillance Observatory        |
|  125 |    2 |   71 | Thera XII - The Sanctuary Institute of Paleocybernetics   |
|  125 |    2 |   71 | Thera XII                                                 |
|   34 |    1 |   11 | Thera VIII                                                |
|   32 |    1 |   93 | Thera XI                                                  |
|   15 |    5 |    0 | Thera V                                                   |
|    4 |    0 |   19 | Thera VI                                                  |
|    4 |    0 |    3 | Thera III                                                 |
|    1 |    0 |    0 | Thera I                                                   |
|    0 |    0 |    0 | Thera - Star                                              |
|    1 |    0 |    1 | Thera II                                                  |
|   10 |    0 |    6 | Thera IV                                                  |
|   11 |    2 |  203 | Thera XIV                                                 |
|   11 |    2 |  203 | Thera XIV - The Sanctuary Fullerene Loom                  |
|   21 |    0 |   15 | Thera VII                                                 |
|   33 |    1 |   81 | Thera X                                                   |
|   50 |    1 |   24 | Thera IX                                                  |
|  140 |   33 |  115 | Thera XIII                                                |
|  140 |   33 |  115 | Thera XIII - The Sanctuary Applied Gravitation Laboratory |
+------+------+------+-----------------------------------------------------------+