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.
Previous page12
 

[Request]Scattered assets route planner
Author
Previous Topic Next Topic
Osku Rei
Pixel 6
#21 - 2012-07-19 20:37:38 UTC
stu2000 wrote:
Do you know how to convert from an asset location id (im suspecting station) to a solar system id?


No sorry, im sure someone has asked before on the forums. :)

Next generation of lottery tracker coming soon! http://evelotterytracker.com/

Please like my post if it has helped you :)
Mikokoel
Mining Industry Exile Foundation
Synergy of Steel
#22 - 2012-07-20 08:17:10 UTC
http://wiki.eve-id.net/APIv2_Corp_AssetList_XML#locationID_to_StationID.2FitemID_conversion

I hope this one helps

Mikokoel | Head FC League of Unaligned Master Pilots
stu2000
Perkone
Caldari State
#23 - 2012-07-20 15:29:34 UTC  |  Edited by: stu2000
Thanks, though im pretty sure I found what Im looking for is actually in the 'staStations' table that I just imported. Has solar system id mapped to station id.
Progress:
38 / 14334 systems completed for lookup table, though it gets faster for each system it completes. Will hopefully complete tonight/tomorrow First one took several hours, and now at stage where it completes several per hour.

Im sure this would have gone a lot faster if I wasn't building on a samsung nc10 netbook, but its perfect for a little home server.
stu2000
Perkone
Caldari State
#24 - 2012-07-21 20:32:57 UTC
I havent given up on this but have spent quite a while optimizing my routing table creator, and its made me realise some other useful features that could do with adding, such as avoid 'lowsec tunnel systems'
stu2000
Perkone
Caldari State
#25 - 2012-07-24 22:25:36 UTC  |  Edited by: stu2000
I 'finished' it tonight. I will whack it on a website tomorrow, but its fully functional/tested in command line.

Tried with my own api details and got the following path to retrieve all my assets:

[0] => 30004758
[1] => 30004765
[2] => 30004801
[3] => 30004798
[4] => 30004761
[5] => 30004763
[6] => 30004714
[7] => 30004722
[8] => 30004757
[9] => 30004752
[10] => 30004755
[11] => 30004720
[12] => 30004723
[13] => 30004719
[14] => 30004706
[15] => 30004707
[16] => 30002187
[17] => 30002655
[18] => 30003027
[19] => 30002659
[20] => 30004792
[21] => 30004791
[22] => 30004711
[23] => 30004721
[24] => 30004718
[25] => 30004746
[26] => 30004770
[27] => 30004745
[28] => 30004715
[29] => 30004712
[30] => 30004710
[31] => 30005328
[32] => 30005324
[33] => 30002203
[34] => 30002201
[35] => 30004766
[36] => 30004785
[37] => 30004788
[38] => 30004787
[39] => 30004789
[40] => 30004708
[41] => 30004709
[42] => 30002197
[43] => 30002053
[44] => 30003496
[45] => 30004748
[46] => 30000215
[47] => 30002036
[48] => 30001971
[49] => 30000443
[50] => 30002816
[51] => 30001365
[52] => 30002800
[53] => 30000319
[54] => 30004754
[55] => 30001976
[56] => 30002510
[57] => 30002100
[58] => 30002819
[59] => 30002805
[60] => 30000865
[61] => 30000263
[62] => 30004756
[63] => 30004799
[64] => 30004020
[65] => 30004771
[66] => 30001978
[67] => 30003488
[68] => 30015042
[69] => 30002772
[70] => 30000296
[71] => 30002030
[72] => 30045329
[73] => 30004760
[74] => 30002798
[75] => 30002099
[76] => 30003573
[77] => 30003058
[78] => 30002202
[79] => 30002040
[80] => 30000142
[81] => 30001429
)

[m_cost:Permutation:private] => 319

319 jumps to gather assets in 82 systems is not bad! That was after 30 seconds of calculations, after just 1 second, it gave me a route of 800 jumps so more time is definitely worth having.

by way, table of all possible routes is 28,139,809 rows large and takes up nearly 2 gigabytes when loaded into mysql!
Previous page12