Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Serious Masta
Caldari
|
Posted - 2010.09.25 15:21:00 -
[1]
Hi,
i need help to get a sql query to determine all systems that are accessable each to each other without low sec jumps (and without lowsec isles).
can someone help please?
|
Catari Taga
Centre Of Attention Middle of Nowhere
|
Posted - 2010.09.25 15:36:00 -
[2]
Since we just had this: http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1385046 (just filter by security) --
|
Serious Masta
Caldari
|
Posted - 2010.09.25 16:10:00 -
[3]
you are the man :)
but just one thing: there is no group_concat in mssql.. is there a equivalent to it?
|
Catari Taga
Centre Of Attention Middle of Nowhere
|
Posted - 2010.09.25 16:48:00 -
[4]
no, although there are ways around it (google), but if you use my example you are doing most of the work in code anyway so might as well do that in code as well (instead of exploding the $jumpNodes value add each row to the array manually, minimal difference. --
|
Serious Masta
Caldari
|
Posted - 2010.09.25 18:19:00 -
[5]
i solved it with a function :)
another question: there is always the question to get the jump count between two solar systems but i dont find a post about that.
someone posts a way to persist the count between to solar systems and the jump count, (only high sec jumps).
like: jita - rens - 25
can you help me again with this?
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2010.09.25 20:40:00 -
[6]
Just cache the results in a separate table. Or calculate all of them once and for all. -- Thanks CCP for cu |
Serious Masta
Caldari
|
Posted - 2010.09.25 23:29:00 -
[7]
Originally by: Tonto Auri Just cache the results in a separate table. Or calculate all of them once and for all.
pre-calculating is the plan. but how is the question^^
|
Catari Taga
Centre Of Attention Middle of Nowhere
|
Posted - 2010.09.25 23:33:00 -
[8]
Edited by: Catari Taga on 25/09/2010 23:35:40 Basically you can use the code that I posted until you reach the destination system, with some modification to make it output a route. Or send me all your ISK and I'll do it for you, lol. --
|
Ix Forres
Caldari Righteous Chaps
|
Posted - 2010.09.26 11:10:00 -
[9]
I'd do this the simple way: Build an autopilot (easy - just implement Djikstra's algorithm in whatever language you're making your app in), then when you want to check if a system is connected highsec or not, first filter by systems that are >0.45 to get rid of systems that themselves are lowsec, then run your AP to a known connected highsec system (say, Jita). Make sure your AP can be told to ignore jumps to lowsec systems, and you can from there very easily precompute or calculate on the fly as appropriate. Side benefit: You now have an AP that you can use for jump count calculations and the most complex SQL you have to write and your DB server has to work with is a very simple SELECT or two. DB servers are not the place to be doing complex calculations. -- Ix Forres - 3rd Party Application Developer - EVE Metrics - accVIEW
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |