Jump to content

vFleetTracker wrong position


Recommended Posts

Hello Guys, 

we got some problems with the map. It's not updating. 

A/C "xy" is already at EDDF and also written in the list in EDDF but on the Map still displayed at CYYZ.

This is our sql Query in vFleetTrackData.class:

*************************************************************************************************************************

    public static function getAllLastLocation()
    {
        return DB::get_results("SELECT flight.*, UNIX_TIMESTAMP(flight.submitdate) as submitdate,
                       dep.name as depname, dep.lat AS deplat, dep.lng AS deplng,
                       arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng,
                       ac.icao AS acicao, ac.name AS acname, ac.fullname AS acfullname,
                       ac.registration AS acregistration
                FROM (SELECT * FROM phpvms_pireps ORDER BY submitdate DESC) AS flight
                LEFT JOIN phpvms_aircraft AS ac ON ac.id = flight.aircraft
                LEFT JOIN phpvms_airports AS dep ON dep.icao = flight.depicao
                LEFT JOIN phpvms_airports AS arr ON arr.icao = flight.arricao
                GROUP BY flight.aircraft
                ORDER BY submitdate DESC");

*************************************************************************************************************************

 

Any help is highly appreciated.

Thanks

Link to post
Share on other sites
  • 4 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...