| Author |
Thread Statistics | Show CCP posts - 11 post(s) |
|

ISD LackOfFaith
ISD Community Communications Liaisons
639

|
Posted - 2013.10.28 22:01:00 -
[1] - Quote
Adaris wrote:Rubicon's warp/accel changes should shake things up though. More for shorter warps than for longer ones, actually. The issue was acceleration time being constant. In short warps, that resulted in most of it being spent accelerating, so reducing acceleration times for small ships (and lengthening it for big ships) will have more of an effect. In long warps, you already spent most of it at top warp speed, so the effect is lessened.
Just FYI.  ISD LackOfFaith Lieutenant Community Communication Liaisons (CCLs) Interstellar Services Department @ISD_LackOfFaith on Twitter |
|
|

ISD Dorrim Barstorlode
ISD Community Communications Liaisons
2470

|
Posted - 2013.10.28 22:04:00 -
[2] - Quote
The update will makes things better for interdictors and hics, mostly because the targets they chase down are larger than they are. Super excited for my favorite ship class to get even better. ISD Dorrim Barstorlode Captain Community Communication Liaisons (CCLs) Interstellar Services Department |
|
|

ISD LackOfFaith
ISD Community Communications Liaisons
639

|
Posted - 2013.10.28 22:28:00 -
[3] - Quote
Abdiel Kavash wrote:Leave it to the ISDs to completely derail a thread.  ... Fine, be that way! 
I ran this SQLite query on a recent DB dump:
Quote:select solarSystemName, radius from mapsolarsystems order by radius desc limit 50;
The raw results are here: http://pastebin.com/rixaPWvG
Tinkering with the numbers shows that those figures are in meters (otherwise we would get completely bogus AU figures). This means that, looking at the top 50 systems by radius:
- The largest system in Eve is J101248 in W-space, with a radius of 142.3 AU. That means that its diameter (and longest possible warp) is right around 284.6 AU.
- Ranking 23rd is the largest K-space system, 9-266Q, with a radius of 101.5 AU, or a diameter of 203 AU.
- Aeter is the largest empire system (and 39th in the ranking), with a radius of 83.8 AU, or a diameter of 167.6 AU. It is in lowsec, though.
- The largest hisec system appears to be Yria, which is ranked 48th. It is 78.8 AU in radius, or 157.6 AU across.
Someone should probably check my numbers, or actually visit these systems to confirm the veracity of the info. I have been known to screw up. ISD LackOfFaith Lieutenant Community Communication Liaisons (CCLs) Interstellar Services Department @ISD_LackOfFaith on Twitter |
|
|

ISD LackOfFaith
ISD Community Communications Liaisons
639

|
Posted - 2013.10.28 22:36:00 -
[4] - Quote
Abdiel Kavash wrote:The radius in the DB has likely nothing to do with actual distances of objects within the system. I can confirm that there are definitely gates further out than 203 AU in some systems. Fair enough, I'll poke around and see if I can't get some measurements on that. Just have to figure out where/how the gate coordinates are tucked away. ISD LackOfFaith Lieutenant Community Communication Liaisons (CCLs) Interstellar Services Department @ISD_LackOfFaith on Twitter |
|
|

ISD LackOfFaith
ISD Community Communications Liaisons
640

|
Posted - 2013.10.28 23:03:00 -
[5] - Quote
Desert Ice78 wrote:As a matter of interest, why is that top 50 list overwhelmenly populated with WH space? Beats me. SQL databases do not really answer "why" questions. W-space is big? ISD LackOfFaith Lieutenant Community Communication Liaisons (CCLs) Interstellar Services Department @ISD_LackOfFaith on Twitter |
|
|

ISD Dorrim Barstorlode
ISD Community Communications Liaisons
2471

|
Posted - 2013.10.29 00:02:00 -
[6] - Quote
ISD LackOfFaith wrote:Desert Ice78 wrote:As a matter of interest, why is that top 50 list overwhelmenly populated with WH space? Beats me. SQL databases do not really answer "why" questions. W-space is big? W-space wouldn't count, no gates there. ISD Dorrim Barstorlode Captain Community Communication Liaisons (CCLs) Interstellar Services Department |
|
|

ISD LackOfFaith
ISD Community Communications Liaisons
642

|
Posted - 2013.10.29 00:06:00 -
[7] - Quote
Aaaaand done. I wrote a quick little Python script to go through every solar system and compare the distances between its gates. You can find it here.
When run, its output is:
Quote: Maximum gate-gate warp was... in system 9-266Q a distance of 201.97 AU from Stargate (1-Y6KI) to Stargate (N6G-H3)
There you have it. It's still in 9-266Q as my radius search of earlier, but the warp is slightly shorter than the diameter of the system.
Let me know if you find any problems with my code or need me to look up something else.  ISD LackOfFaith Lieutenant Community Communication Liaisons (CCLs) Interstellar Services Department @ISD_LackOfFaith on Twitter |
|
|

ISD LackOfFaith
ISD Community Communications Liaisons
642

|
Posted - 2013.10.29 00:25:00 -
[8] - Quote
For the spreadsheet people, I have compiled some CSV data for every maximum gate warp for every system. It's even nice to just CTRL+F through and see what warps you should camp try to not warp across in slow ships.
Enjoy! ISD LackOfFaith Lieutenant Community Communication Liaisons (CCLs) Interstellar Services Department @ISD_LackOfFaith on Twitter |
|
|

ISD LackOfFaith
ISD Community Communications Liaisons
645

|
Posted - 2013.10.29 02:06:00 -
[9] - Quote
Hmm, I've double-checked it, and it looks like the database dump might be the inaccurate thing. I'll keep looking into it. That's weird, though. ISD LackOfFaith Lieutenant Community Communication Liaisons (CCLs) Interstellar Services Department @ISD_LackOfFaith on Twitter |
|
|

ISD LackOfFaith
ISD Community Communications Liaisons
651

|
Posted - 2013.10.29 14:19:00 -
[10] - Quote
Found the problem:
Quote:Q_GATE_LOCATION = """ select mapdenormalize.itemid, mapdenormalize.x, mapdenormalize.y, mapdenormalize.z from mapdenormalize inner join invitems on invitems.itemid=mapdenormalize.itemid where invitems.itemid=? """
Should have been:
Quote:Q_GATE_LOCATION = """ select mapdenormalize.x, mapdenormalize.y, mapdenormalize.z from mapdenormalize inner join invitems on invitems.itemid=mapdenormalize.itemid where invitems.itemid=? """
Might not make sense for the people who are not tech-oriented, but i was essentially getting 4 3D coordinates, and only using the first 3, thus ignoring the Z component and replacing it with a bogus item ID. So, those who were pointing out that there's a 3rd dimension weren't entirely wrong, but not entirely right either.
The fixed script is here, and the new results are here.
A summary of the (fixed) longest gate-gate warps:
- Absolute longest (rank #1): in 9-266Q, from the H-PA29 gate to the BV-1JG gate. 283.34 AU.
- Longest in lowsec (rank #7): in Rilera, from the Edani gate to the Tegheon gate. 180.38 AU.
- Longest in hisec (rank #9): in Ronne, from the Gammel gate to the Jarkkolen gate. 179.01 AU.
The systems you guys pointed out:
- 9-266Q is already mentioned above.
- V89M-R only has a 24.72 AU warp, from OJOS-T to 66U-1P. Maybe it was another nearby system.
- D4KU-5 is 15th on the list, with a 163.42 AU warp from Hophib to L-A5XP.
- Resbroko is 26th on the list, with a 149.417 AU warp from Hadozeko to Auner.
- H-PA29 actually only has a short warp (13.87 AU). Are you sure you weren't thinking of the adjacent 9-266Q?
- X-7OMU now has the right distance of 231 AU, and ranks 4th.
It looks like system radius is indeed a poor indicator of maximum warp, since the radius is "horizontal" only, and does not account for celestials far above/below the system, or even farther out horizontally than the last planet. Let me know if you spot anything else needing attention. ISD LackOfFaith Lieutenant Community Communication Liaisons (CCLs) Interstellar Services Department @ISD_LackOfFaith on Twitter |
|
|

ISD LackOfFaith
ISD Community Communications Liaisons
651

|
Posted - 2013.10.29 18:47:00 -
[11] - Quote
I think you should be cursing a RNG. If I remember correctly, the Eve universe took several days to get generated using whatever algorithm CCP used, and used the random number generator seed of "42". ISD LackOfFaith Lieutenant Community Communication Liaisons (CCLs) Interstellar Services Department @ISD_LackOfFaith on Twitter |
|
| |
|