Rod Posted January 6 Report Share Posted January 6 We have an issue we can not solve and need assistance please. We have a flight which is displaying on our Live Flight Board from a pilot that was removed/deleted. This is messing up how the Live Flight Map/Live acars Map is displaying. I have deleted the flight from phpvms_acarsdata which fixes the issue for a few minutes, then the flight just reappears after a few minutes which then messes up the maps again. Could anyone please assist us in resolving this issue. We are using: phpVMS Version simpilot 5.5.2 Custom Kacars Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted January 6 Moderators Report Share Posted January 6 Hello there, if the flight comes back up after removing it from acarsdata table, that means the guy is still connected to your website through the acars software and that means their account is still active on your system Quote Link to comment Share on other sites More sharing options...
Rod Posted January 6 Author Report Share Posted January 6 (edited) When the flight reappears in the phpvms_acarsdata it looks like this no name is displayed or Lat/Long. what can we do to resolve this issue? how to we completely remove his account from the system? Edited January 6 by Rod Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted January 6 Moderators Report Share Posted January 6 Like I said the acars software is still on and makes the table refresh, check the pilots table for the pilotid, if it's there, delete their record manually Repeat this process for them in pireps table. Quote Link to comment Share on other sites More sharing options...
Rod Posted January 6 Author Report Share Posted January 6 His pilot id is not in the pilots table anymore, he was already deleted from the pilots table. If the flight is still live how would it be listed in the pireps table until filed? Thank you for your assistance Parkho Quote Link to comment Share on other sites More sharing options...
Rod Posted January 6 Author Report Share Posted January 6 Is their a way to recover his deleted account. Then reactivate it so he is listed in the active roster, then look him up in the phpvms admin / Pilots & Groups / View All Pilots.... to get his IP then block it? Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted January 6 Moderators Report Share Posted January 6 11 minutes ago, Rod said: His pilot id is not in the pilots table anymore, he was already deleted from the pilots table. If the flight is still live how would it be listed in the pireps table until filed? Thank you for your assistance Parkho You're welcome, the acars table only updates when the software is connected to the website and is sending flight data, so he might have some other access accounts to your website like the main email and password (just a guess). Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted January 6 Moderators Report Share Posted January 6 10 minutes ago, Rod said: Is their a way to recover his deleted account. Then reactivate it so he is listed in the active roster, then look him up in the phpvms admin / Pilots & Groups / View All Pilots.... to get his IP then block it? It is not possible to recover the deleted account unless he registers with the same email address. There is one more possibility, Check the bids table, he might still have a bidded flight after account termination. I know acars softwares check for flight bids table to fetch some data Quote Link to comment Share on other sites More sharing options...
Rod Posted January 6 Author Report Share Posted January 6 (edited) So basically we have to wait until he disconnects for it to resolve, then hope he doesn't reconnect! Edited January 6 by Rod Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted January 6 Moderators Report Share Posted January 6 53 minutes ago, Rod said: So basically we have to wait until he disconnects for it to resolve, then hope he doesn't reconnect! Unfortunately, yes! Quote Link to comment Share on other sites More sharing options...
Rod Posted January 6 Author Report Share Posted January 6 So are live flights listed in the pireps table or only flights that have landed and been submitted? Quote Link to comment Share on other sites More sharing options...
Moderators Parkho Posted February 17 Moderators Report Share Posted February 17 On 1/7/2024 at 2:37 AM, Rod said: So are live flights listed in the pireps table or only flights that have landed and been submitted? Only submitted pireps will be recorded in pireps table. Live flights are recorded in acars table and will be deleted after the pirep is submitted. 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.