Hello, me and My Friend( Almost All My Friend ) Create A Little script for a VMS.
He put a topic in forums but Not explained correctly.
Discounts To Subtract From Pilot Salary V1.0
Well this addon remove the pilot’s salary according to his flight log. For example, the limit of TD in his VA is -300 and the driver exceeds this limit, is much more constructive and interesting actually used the system’s finances vms than simply delete the log. So if Exed the limit of touch, flaps, gear down or up, will be deducted from the pilot’s account as follows:
Every 100 FT / M Exed (Default is -300, but you can change) is removed - $ 1,200, the same way with the flaps and gear, but in a non-linear. A New Box is create in your log accept on admin center ( Default Skin)
Installation
Unzip the file to a folder of your choice
Extract the files to folder “admin / templates” on your PHPVMS.
Change the links to your site in discontoauto.tpl, and pirep_list.tpl.
$total = ($touchdown + $cauda + $flaps + $geardown + $gearup); // essa linha soma os valores indicados e a sua variavel ira discontar do salario do piloto.
// apartir de agora vamos conectar ao BD e pegar o atual salario do piloto.
$banc = mysql_select_db(DATABANK); // aqui selecionamos o banco de dados .
$qu = “UPDATE ".$banc.".table_pilots SET totalpay = totalpay -”.$total." WHERE table_pilots.pilotid = ‘“.$numero_do_piloto.”’"; // a variavel $qu esta carregando todo codigo para inserir no banco de dados.
mysql_query($qu); // aqui executamos a variavel $qu.
Yeah I think it would need to be recoded a bit to take advantage of the adjust pilot pay code snippets that was released a while back that I use on my site. If you use that and recalculate everything, it will not give the cash back to the pilot.