[Free] FlightAware Schedule Puller

phpVMS Legacy Add-Ons (v2/v5) Releases
41

Updates:

 

So, I ran it for a week using a cron job (someone can probably figure out how to do that) but as you see from the code, it is the definition of a mess and no documentation.

I also found an issue since I was calculating the time by checking the difference between departure time and arrival, which could give unrealistic times if for example you depart 18:00 and arrive 01:00, it would say flighttime is 17:00…

Another thing I need to fix is the days of week a flight is flown, which was always set to all days. This time it will check for existing entry and if it exits, it will update this to include the correct day of week  

Right now, I am rewriting it and documenting, so “stay tuned” when next version is released.

42

Update!

It has now been rewritten to what I consider “good code” and documented.

Below you will find a link with instructions on how to set it up etc.

Feedback is appreciated

https://github.com/RAZERZ/PullFlightData

EDIT: This rewritten code also contains the “features” that I stated above

1 Like
43

i still get the ACCESS DENIED from try to create the SQL 

 

so what details do i need to change on line 59

 

Also in your text documentation there is no where to tell you to place the Puller and Grabber files 

44

what is $apiUserId ? Its not there

45

 How would you do this from a windows computer?

46

Hey,

just to get it right. This script pull only data from one specific airport?

47

On 11/21/2017 at 2:11 PM, elfrost said:

I’m using something like that.
I created my own php script and i run it with a cronjob.

It keeps my schedule databse up to date and I grab data from Flightaware totally free.

Basically, the scrip go to 

$ch = curl_init(“http://flightaware.com/live/fleet/“.$code.”?;offset=“.($i\*40).”&sort=ASC;order=actualdeparturetime”);

$code is defined by whatever you want ( WJA-JBU-AAL-DAL…)

The script is connected directly with your phpvms database so it updates/upload all datas in there.

If flight does not exist = it creates
If flight exist = check for update
if exist and up to date = do nothing

and also, if flight do not receive any update for x days, then delete it

So you understand here that my schedule is always up to date and synchroinized with flightaware
 

I’m pretty proud of it because i’m not a php expert and I’m working on it for one year lol
I used flightaware API before but I found out a way to get data for free…

Would you be willing to share this script and some instructions on how to get it to work?