Log aircraft tracked for replay

[bilbolodz]

Thank for quick reply. I've just found these solution myself. I've also made some small patches to your project. I'll post it go github tomorrow.
---
Quick edit without github:

My VRS setup is password protected so to get it working your code needs some changes:
getTrackMlat.php

Code: Select all

curl_setopt_array($ch, $options);
if ( $vrsusername != "" && $vrspassword != "")
{
    curl_setopt($ch, CURLOPT_USERPWD, "$vrsusername:$vrspassword");
}
$data = curl_exec($ch);

config.php

Code: Select all

$vrsusername = "username";
$vrspassword = "password";

[bilbolodz]

I've not found on github file search.php, I've also noticed on http://flights.hillhome.org/flights/index.php that clinking on plane goes to details.php which is also NOT on github. Are you going to make it public?

[ProHill]

It isn't really my intention to duplicate my whole site on github - but just to get the skeleton up there for people to develop their own sites. However, I will be adding a search page eventually.

Andy

[loplo]

Strange thing, my database is being populated, but flights.php returns:
Flights 1 to 100
0 results

LE
my two tables look like this:

[bilbolodz]

Strange thing, my database is being populated, but flights.php returns:
Flights 1 to 100
0 results

Do "the windows part". Flights are generated from sqlite data took from Basestation database.

[loplo]

"Shoot",
I thought it's either windows or Linux. I was wondering about the CSV file, but couldn't figure out what's wrong.

[loplo]

Solved!

[drencken]

This is a very interesting project but I am stuck on the following point :

Windows : the script running every 5 minutes reports errors that suggest that the StandingData.sqb database is locked and so the flights.csv file is generated with zero content.

I'd appreciate any insights. Thanks !

[ProHill]

This is a very interesting project but I am stuck on the following point :

Windows : the script running every 5 minutes reports errors that suggest that the StandingData.sqb database is locked and so the flights.csv file is generated with zero content.

I'd appreciate any insights. Thanks !

Try restarting VRS to release the lock. Note that after a restart, there will be a delay of ~25 minutes before any flights are exported.

Andy

[drencken]

Hi Andy,

so without VRS running I can get the script to run successfully and I get a meaningful flight.csv file but after a while the lock error shows up again - this is with VRS running again - the lock re-appears and the same errors shows up again. Maybe VRS opens this DB in an exclusive mode.

Thanks