Update: following a requestion by ‘PLaci’, the output of this script now includes System Security Status
Download: EVE Route Calculator, PHP Source (security status update)
Download: EVE Route Calculator, MySQL Database (security status update)
Through 2006-2007, I played EVE quite a bit, and thanks to CCP kindly exporting their entire data-set (Solar Systems, Jump Routes etc) the players have been able to create a multitude of in-game and out-of-game applications. One such application that I wanted to make for quite some time was a Jump Route Calculator, similar to the EVE Clients autopilot.
Thanks to stumbling across the article referenced in this post, and after a little adaption I’ve constructed the required Database and Script to calculate the Autopilot route between any two given Solar Systems in the EVE Universe. Attached is the finished PHP script, and Database used.
Download: EVE Route Calculator, PHP Source
Download: EVE Route Calculator, MySQL Database
Reference links:
http://web.archive.org/web/20070316001615/http://www.asenski.com/archives/7
hi-
just to let you now. i find your digital/foto art quite fascinating.
thanx for the help on the eve route calcs.
the best-
KtoJest
Hi!
Could you make a DB whit system security info?
PLaci
Hi PLaci, sure thing. I’ll see about putting one together during my lunch break today, although I’m not sure if the script I used to generate it previously is on this Laptop or not, so it may not be available today.
PLaci, I’ve updated the PHP script and MySQL dump. The results will now include security status information for all jumps. Enjoy!
Hi!
I have modofied the PHP to:
1.) included
$minSec = strtoupper($_GET['minsec']);
2.) modified
$query=”SELECT * FROM e_systems”;
to
$query=”SELECT * FROM e_systems WHERE secStatus>’$minSec%’”;
PLaci
btw, the DB are a bit wrong, the Kisogo – Jita stargate are not ingame anymore…
Aha, thanks PLaci, I’ll repair and upload a new copy tomorrow, and will add the modifications you’ve made to the script. Thanks a lot for your input!
Could you make the DB whit actual, and not raw sec status?
And I think I made a small error, it should be “>=” and not just “>”…
I was just wondering how you made the database dump? I have some updated info for the Black Rise region, but I have no idea how to integrate it to the database you have and make it still work for your script. Thanks.
Hi Josico. I wrote a PHP script to parse and collate the data from CCPs data dumps. I’m not too sure where I archived it at the moment, and am currently with a client, but once I’m done I’ll have a dig around my old backups for you. I’ll drop you an email when I find it, and will post it up on here for anyone else that would like it
BTW, If you want to use the MySQL dump data instead of the SQL file, here is the SQL query:
SELECT
mapSolarSystemsFrom.regionID,
mapSolarSystemsFrom.constellationID,
mapSolarSystemsFrom.solarSystemName AS SystemName,
mapSolarSystemsFrom.solarSystemID AS SystemID,
GROUP_CONCAT(mapSolarSystemsTo.solarSystemName SEPARATOR ‘:’) AS jumpNodes,
mapSolarSystemsFrom.security
FROM
mapSolarSystems mapSolarSystemsFrom
INNER JOIN mapSolarSystemJumps ON (mapSolarSystemsFrom.solarSystemID = mapSolarSystemJumps.fromSolarSystemID)
INNER JOIN mapSolarSystems mapSolarSystemsTo ON (mapSolarSystemJumps.toSolarSystemID = mapSolarSystemsTo.solarSystemID)
GROUP BY
mapSolarSystemsFrom.regionID,
mapSolarSystemsFrom.constellationID,
mapSolarSystemsFrom.solarSystemName,
mapSolarSystemsFrom.solarSystemID,
mapSolarSystemsFrom.security
————————————————————-
Sabey
Hi, I installed this script on my server it runs but always returns with false any ideas why im running it off the latest data dump (aporypha) using Sabey’s select query as your sql dump dosent appear to have a table definition. Any assistance would be much appreciated.
Milky