Thomasha Posted August 27, 2017 Report Share Posted August 27, 2017 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 Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted August 29, 2017 Moderators Report Share Posted August 29, 2017 That should not be correct. Have you ever changes the module files? Quote Link to comment Share on other sites More sharing options...
Thomasha Posted September 22, 2017 Author Report Share Posted September 22, 2017 Hello servetas, sorry for the late response. No. We also tryed to redownload the complete module but without success. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.