Fspax scoring

[tnick74]

Hello,

i try to work out a scoring system using fspax pireps and this is what i have done so far:

1. created 2 fields in the db table "_pireps", named "bonus" and "penalty"

2. added the following code to the /acars/fspax.php:

$data = array( 'pilotid'=>$pilotid,

'code'=>$code,

'flightnum'=>$flightnum,

'leg'=>$leg,

'depicao'=>$depicao,

'arricao'=>$arricao,

'aircraft'=>$aircraft,

'route' => '',

'flighttime'=>$flighttime,

'landingrate'=>$_POST['TouchDownVertSpeedFt'],

'submitdate'=>'NOW()',

'load'=>$_POST['NbrPassengers'],

'fuelused'=>$fuelused,

'bonus'=>$_POST['BonusPoints'],

'penalty'=>$_POST['PenaltyPoints'],

'score'=>$score,

'source'=>'fspax',

'comment'=>$comment,

'log'=> $log);

So, i suppose in every fspax pirep, the bonus and penalty values should be added. But no...when exporting a pirep, these values are not inserted in the pirep db.

Any help please?

[Guest lorathon]

Try adding the following after the FilePIREP portion

$last = PIREPData::getLastReports($pilotid, 1);  // this will get the last pirep (meaning the one just filed above)

$fields = array(
	     'bonus'		=> $_POST['BonusPoints'],
	     'penalty'		=> $_POST['PenaltyPoints']		    
	);

PIREPData::updatePIREPfields($last->pirepid, $fields);

[Nabeel]

Jeff is correct, right now it doesn't look at the fields passed. Unless you're using beta

[tnick74]

Thank you both guys!! now i am really comfused......this is the fspax.php i use. Where to put the code that Jeff posted?

fspax(2).php

[Guest lorathon]

Right after the following

$ret = ACARSData::FilePIREP($pilotid, $data);
if(!$ret)
{
	echo "#Answer# Error - ".PIREPData::$lasterror;
	exit;
}

and before

echo "#Answer# Ok - Saved;";

It is at the bottom of the file.

[tnick74]

Thank you again Jeff!

Now it works, but only for the bonus. Penalty is not inserted.

[Guest lorathon]

Then check the DB field name and the post name. Make sure they are both correct.

[tnick74]

Both db field name and post name are correct. The only thing i noticed is that a comma is missing after ".......POST['PenaltyPoints']". Could it be the cause?

[Nabeel]

No that's fine because its defining a dictionary array and thats the last element. Make sure PenaltyPoints is the correct name

[tnick74]

Yup i think i found the error. Fspax export PenalityPoints, not PenaltyPoints....i hope it will work now

[Nabeel]

Gotta love it when they mispell in the app