Page 3 of 4

Re: Log aircraft tracked for replay

Posted: Mon Feb 22, 2016 10:31 pm
by 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";

Re: Log aircraft tracked for replay

Posted: Wed Feb 24, 2016 6:59 pm
by 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?

Re: Log aircraft tracked for replay

Posted: Fri Feb 26, 2016 2:15 pm
by 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

Re: Log aircraft tracked for replay

Posted: Sat Feb 27, 2016 6:54 pm
by 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:
Image

Image

Re: Log aircraft tracked for replay

Posted: Sat Feb 27, 2016 10:04 pm
by bilbolodz
loplo wrote: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.

Re: Log aircraft tracked for replay

Posted: Sat Feb 27, 2016 10:18 pm
by 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.

Re: Log aircraft tracked for replay

Posted: Sun Feb 28, 2016 10:26 am
by loplo
Solved!

Re: Log aircraft tracked for replay

Posted: Sun Feb 28, 2016 1:52 pm
by 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 !

Re: Log aircraft tracked for replay

Posted: Sun Feb 28, 2016 3:58 pm
by ProHill
drencken wrote: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

Re: Log aircraft tracked for replay

Posted: Sun Feb 28, 2016 8:16 pm
by 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