mclaren99uk

Thanks for the help all running ok now Sorry for delay, have been away

Hi but there is no code change, or am i missing something. They are the same?

Hi Sorry for the delay, as was late here and needed some sleep. Below is the section you have asked for public static function GetACARSData($cutofftime = '') { //cutoff time in days if(empty($cutofftime)) { // Go from minutes to hours $cutofftime = Config::Get('ACARS_LIVE_TIME'); //$cutofftime = $cutofftime / 60; } $sql = 'SELECT a.*, c.name as aircraftname, p.code, p.pilotid as pilotid, p.firstname, p.lastname, dep.name as depname, dep.lat AS deplat, dep.lng AS deplng, arr.name as arrname, arr.lat AS arrlat, arr.lng AS arrlng FROM ' . TABLE_PREFIX .'acarsdata a LEFT JOIN '.TABLE_PREFIX.'aircraft c ON a.`aircraft`= c.`registration` LEFT JOIN '.TABLE_PREFIX.'pilots p ON a.`pilotid`= p.`pilotid` LEFT JOIN '.TABLE_PREFIX.'airports AS dep ON dep.icao = a.depicao LEFT JOIN '.TABLE_PREFIX.'airports AS arr ON arr.icao = a.arricao '; if($cutofftime !== 0) { $sql .= 'WHERE DATE_SUB(NOW(), INTERVAL '.$cutofftime.' MINUTE) <= a.`lastupdate`'; } return DB::get_results($sql); DB::debug(); }

Thanks, where do i find it? what file?

ive added that in, and nothing has appeared. Ive created the coloum with the heading but the data field is blank. This is with the standard install with no modifications

Hi, where do i find that and how do i do it? i am not fimilar with this

Hi This there a variable to show the aircraft ICAO code and not the full aircraft name? Many Thanks

If you can add information into the database via scripting then it can be removed in the same way. How to you think other CMS's work? How do you think Forums work? Data gets added to the database and can be deleted. If you wanted to delete a post, you dont go into the database to do it do you! If that is the case then this phpvms is not a CMS is it `phpvms_airports` appears to be the table that they are created in. So if you can add items in there, via the HTML interface, but im sure that they can be removed. as you dont want to be giving access to the sql to do this.

I have attached a screenshot showing the screen i am on about I need to remove KJFK from this screen, but not completely from the database, without the need for coding

Hi Sorry i dont think i have explained it correctly. Im not after removing the airfield from the database completely, but from the airport list. The default airfiled if KJFK, under tasks, you have the option to add additional airports. and against them you have an "Edit" option. but not a removal/delete I would like to remove the airport from the airport listing. I can add a picture to show right now

Im not up on the programming side of things. so all the technical stuff is over my head. I would expect tho, that if you add something in, then you should be able to remove it, with out having to go into the back of things. Is that not the whole point of a CMS?

maybe this should be something that should be added, so that the default airfield can be removed more easily

Hi All I am new to all this so please excuse me if this seems to be a daft question, but how to you remove an airport from the "Add & Edit Airports" list Does this have to be removed from the database? I have also tried to rename the default airfield "KJFK" but it wont let me. I can add new airfields, but not modify them or remove them. Any advice