Virgil Armstrong
SL33P3R C3LL
11
   |
Posted - 2015.07.20 08:21:36 -
[1] - Quote
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. |
Virgil Armstrong
SL33P3R C3LL
11
|
Posted - 2015.07.20 10:04:19 -
[3] - Quote
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 |
+------+------+------+-----------------------------------------------------------+ |