Thomas

same, i will be happy to help you test it.

Ok, 1st- Simpilot, Vatsim doesnt work on my site, do you possibly have the code or maybe can you even send me it 2nd- Jayden, where do you want me to add this?

Yes, Nabeel did fix it , so it works fine now Long Live phpVMS and Nabeel...

Ok, I will do it when i have time mate, But im happy staying with the release version until the next release is out. Now just to fix the routemap...

Hi Nabeel, FInally sorted it, i updated to the latest version, 2.0.800 still didnt work, So, i downloaded the Latest Release 1.2.700 (NOT THE BETA) So i then put the 1.2.700 core/modules/acars files into the beta core/modules/acars, Filed pireps with no problem. So now that fspax and fsacars works, then how doesnt xacars now?

Hi Guys, Some of you might of heard of VSN or Virtual-Skies, its like Vatsim however alot smaller, Is it possible to intergrate online pilots from there website to ours/your va's live map? There website: http://www.virtual-skies.com/ So its just the same, live map wise, just need a code or something with Js? Thanks, Thomas.

So, is there anyway to resolve this Nabeel?

Xacars, works fine, like i said, ive also re-checked the configs and re-entered them for fsacars and fs pax, they both still dont work. Also just noticed that Xacars shows pilots online with the live map but the other two, fsacars and fspax, do not show the online pilots. So theres more than just one Bug/error/update to this.

Xacars worked fine, so its something to do with FSacars and FS Pax, Weird huh?

we dont use localhost as hosting24.com - the providers of our providers dont, its better security, but more complicated, We dont use Xacars, FSacars doesnt work and FSpax doesnt work, I cleaned out the log.txt, gave it permissions and then logged a pirep, still same error and also nothing appeared in the modules/acars/log.txt

Yes theres landingrate, could i remove it and see if it works? Also, our providers doesnt use localhost, would that maybe cause a problem? We use: 10.21.47.198 Thomas.

And when you say you added a coloumn to the PIREP Table, where do you mean? In the SQL DB or in an actual FIELD?

It started with Version 2.0.795 I updated it with the update.php and also then did a update.php?force Which was successfull, then this problem, http://members.pulseair.co.uk/core/modules/ACARS/log.txt -- You can check the log here mate. We have just attempted to file a pirep, same error.

Addded the line, still no luck, still same error however new things in the core/logs/log.txt file: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a WHERE p.aircraft = a.id AND pilotid' at line 2 SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours, FROM phpvms_pireps p, phpvms_aircraft a WHERE p.aircraft = a.id AND pilotid=12 GROUP BY a.name You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a WHERE p.aircraft = a.id AND pilotid' at line 2

This is the full config fspax.php... <?php /** * phpVMS - Virtual Airline Administration Software * Copyright (c) 2008 Nabeel Shahzad * For more information, visit www.phpvms.net * Forums: http://www.phpvms.net/forum * Documentation: http://www.phpvms.net/docs * * phpVMS is licenced under the following license: * Creative Commons Attribution Non-commercial Share Alike (by-nc-sa) * View license.txt in the root, or visit http://creativecommons.org/licenses/by-nc-sa/3.0/ * * @author Nabeel Shahzad * @copyright Copyright (c) 2008, Nabeel Shahzad * @link http://www.phpvms.net * @license http://creativecommons.org/licenses/by-nc-sa/3.0/ */ /* FSPassengers, Copyright © Daniel Polli http://www.fspassengers.com */ writedebug("FSPAX DEBUG"); //writedebug($_SERVER['QUERY_STRING']); writedebug(print_r($_POST, true)); # Check for connection if($_POST['FsPAskConnexion'] == 'yes') { # Validate pilot: $_POST['UserName'] = DB::escape($_POST['UserName']); # Entered as ### if(is_numeric($_POST['UserName'])) { $pilotid = intval(intval(trim( $_POST['UserName']))) - Config::Get('PILOTID_OFFSET'); } else { # Check if they entered as XXX### if(preg_match('/^([A-Za-z]*)(.*)(d*)/', $_POST['UserName'], $matches)>0) { $pilotid = intval(intval(trim($matches[2]))) - Config::Get('PILOTID_OFFSET'); } else { # Invalid Pilot echo '#Answer# Error - Invalid pilot ID format;'; return; } } $pilotdata = PilotData::GetPilotData($pilotid); if(!$pilotdata) { echo '#Answer# Error - Username don't exist or wrong password;'; return; } # Give it what it wants # Derive the config from the main config settings echo "#Answer# Ok - connected;"; echo 'Weight='.Config::Get('WeightUnit').' Dist='.Config::Get('DistanceUnit').' Speed='.Config::Get('SpeedUnit').' Alt='.Config::Get('AltUnit').' Liqu='.Config::Get('LiquidUnit'); echo '#welcome#'.Config::Get('WelcomeMessage').'#endwelcome#'; } if($_POST['FsPAskToRegister'] == 'yes') { $comment = ''; # Get the pilot id: if(is_numeric($_POST['UserName'])) { $pilotid = intval(intval(trim( $_POST['UserName']))) - Config::Get('PILOTID_OFFSET'); } else { if(preg_match('/^([A-Za-z]*)(d*)/', $_POST['UserName'], $matches) == 0) { echo "#Answer# Error: Pilot doesn't exist ;"; return; } $pilotid = intval(intval(trim($matches[2]))) - Config::Get('PILOTID_OFFSET'); } # Get the flight ID $flightinfo = SchedulesData::getProperFlightNum($_POST['FlightId']); $code = $flightinfo['code']; $flightnum = $flightinfo['flightnum']; /*if(preg_match('/^([A-Za-z]*)(d*)/', $_POST['FlightId'], $matches) == 0) { echo "#Answer# Error - Invalid flight ID;"; return; }*/ preg_match('/^([A-Za-z]*) - .*/', $_POST['DepartureIcaoName'], $aptinfo); $depicao = $aptinfo[1]; # Make sure it exists if(!OperationsData::GetAirportInfo($depicao)) { OperationsData::RetrieveAirportInfo($depicao); } preg_match('/^([A-Za-z]*) - .*/', $_POST['ArrivalIcaoName'], $aptinfo); $arricao = $aptinfo[1]; # Make sure it exists if(!OperationsData::GetAirportInfo($arricao)) { OperationsData::RetrieveAirportInfo($arricao); } //if($code == '') //{ # Find a flight using just the flight code $sched = SchedulesData::FindFlight($matches[2]); # Can't do it. They completely screwed this up if(!$sched) { return; } $code = $sched->code; $flightnum = $sched->flightnum; $leg = $sched->leg; $aircraft = $sched->aircraft; /*$depicao = $sched->depicao; $arricao = $sched->arricao;*/ if($depicao != $sched->depicao || $arricao != $sched->arricao) { $comment = 'phpVMS Message: Arrival or Departure does not match schedule. '; } //} # Get the time, don't care about seconds preg_match('/^(d*):(d*):(d*)/', $_POST['TotalBlockTime'], $time); $flighttime = $time[1].'.'.$time[2]; # Get the fuel used $fuelused = floatval($_POST['StartFuelQuantity']) - floatval($_POST['EndFuelQuantity']); # Form the log: $log = ''; foreach($_POST as $name=>$value) { if($name == 'FsPAskToRegister' || $name == 'UserName' || $name == 'Password') { continue; } $log .= "$name=$value<br />".PHP_EOL; } $comment .= 'FSPassengers Flight. No aircraft entered'; $data = array( 'pilotid'=>$pilotid, 'code'=>$code, 'flightnum'=>$flightnum, 'leg'=>$leg, 'depicao'=>$depicao, 'arricao'=>$arricao, 'aircraft'=>$aircraft, 'flighttime'=>$flighttime, 'submitdate'=>'NOW()', 'load'=>$_POST['NbrPassengers'], 'fuelused'=>$fuelused, 'source'=>'fspax', 'comment'=>$comment, 'log'=> $log); writedebug($data); $ret = ACARSData::FilePIREP($pilotid, $data); echo "#Answer# Ok - Saved;"; }

Plus Nabeel its not just FS Pax, its ACARS Aswell.

Ok first of all nabeel, my fspax file looks completely different from that, Line 170: 'aircraft'=>$aircraft, Line 171: 'flighttime'=>$flighttime, Line 172: 'submitdate'=>'NOW()', Shall i still add that line?

Ok Nabeel, well your flight isnt showing in the admin panel, only the one's filed manually are, and also re-installing FSpax didnt solve anybodys problem.

But how couldnt this work, it was downloaded AFTER the latest update beta? Link: http://pulseair.co.uk/PLS_config.cfg Contains: menu_name=Pulse Air :: Welcome To Our Website!; base_url=http://members.pulseair.co.uk; path_stats=index.php/acars; path_export=action.php/acars/fspax; username=PLS0001; password=none; Thomas.

Ok Nabeel, but its not allowing us to export us to the database, Pic 1, saying connection ok: Pic 2, saying it failed to connect: Does that make any sense to you because its got me and also the rest of the VA Confused lol In the log.txt: SELECT a.name AS aircraft, COUNT(p.aircraft) AS count, SUM(p.flighttime) AS hours, FROM phpvms_pireps p, phpvms_aircraft a WHERE p.aircraft = a.id AND pilotid=12 GROUP BY a.name You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpvms_pireps p, phpvms_aircraft a WHERE p.aircraft = a.id AND pilotid' at line 2

Ok Nabeel i will do the permissions now, so how exactly do i fix this FS Acars/ FS Pax error?

Not Working For Me Still, Also there are many "Permission" errors... An Error Was Encountered /home3/pulseair/public_html/members//lib/rss/latestpireps.rss is not writeable! Warning: fopen(/home3/pulseair/public_html/members//core/logs/log.txt) [function.fopen]: failed to open stream: Permission denied in /home3/pulseair/public_html/members/core/classes/Debug.class.php on line 86 Warning: fwrite(): supplied argument is not a valid stream resource in /home3/pulseair/public_html/members/core/classes/Debug.class.php on line 87

Ofcourse Tom...

Still didnt work for me, Database error, this started just after 795 was run, Now ive updated and it still doesnt work plus i am getting more Access Denied errors.

Ok, so then how is it just me?