faraz

<?php $last_location = PIREPData::getLastReports($pilot->pilotid, 1, PIREP_ACCEPTED); echo $last_location->arricao ; ?>

please check this code . $pireps = PIREPData::findPIREPS(array('DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= p.submitdate')); $thismonth = 0; foreach($pireps as $pirep) { $thismonth = $pirep->flighttime; } echo $thismonth;

Hi Nabeel Did you find any solution for Flight Hours This Month ?

Pilot transfer from current location or current airport to another airports , taking money from pilot total pay. my current location : EGLL and I want transfer to LOWW . after transferred to LOWW , I can add bid flight from LOWW and Price for taransfer is 123$. and i need same system for Aircraft transfer , but in aircraft transfer taking money from VA. and just admin group has permission for aircraft transfer.

HI I'm willing to pay for this .

HI I need modules for pilots transfer (jump seat) and aircraft transfer . I have 20-30 lines for ticket price and pilot transfer , but i don't know how to use it with PHPvms . can anybody write codes and modules for pilot transfer and aircraft transfer?

Thanks Nabeel

Solved <?php $allpilots = PilotData::getAllPilots(); foreach($allpilots as $pilot) { ?> <?php include 'db2.php'; $last_location = PIREPData::getLastReports($pilot->pilotid, 1, PIREP_ACCEPTED); mysql_query("UPDATE phpvms_pilots SET current = ('$last_location->arricao') WHERE pilotid ='$pilot->pilotid'"); ?> <?php } ?> I want automatically update current field every 10 minutes

Hello How can i send data into a database table ? I created field in phpvms_pilots table and name it current , i want send last location in phpvms_pilots table . <?php $allpilots = PilotData::getAllPilots(); foreach($allpilots as $pilot) { ?> <?php include 'db2.php'; $last_location = PIREPData::getLastReports($pilot->pilotid, 1, PIREP_ACCEPTED); mysql_query("UPDATE phpvms_pilots SET current=('$last_location->arricao') WHERE ID='$pilot->pilotid'") ?> <?php } ?> but no data insert in current field .

Flight Hours This Month: <?php $hours = PIREPData::getIntervalDataByMonth(array(), 1); echo $hours->total; DB::debug(); ?> ezDB (v3.00) Debug.. Query [12] -- [sELECT * FROM phpvms_expenselog WHERE `dateadded`=201003] Query Result.. (row) int 0 dateadded string 0 name string 0 type real 0 cost No Results I have 6 PIREPs for this Month . Flight This Month: 6

Hours This Month: ezDB (v3.00) Debug.. Query [10] -- [sELECT DATE_FORMAT(p.submitdate, '%Y-%m') AS ym, UNIX_TIMESTAMP(p.submitdate) AS timestamp, COUNT(p.pirepid) AS total, SUM(p.revenue) as revenue, SUM(p.gross) as gross, SUM(p.fuelprice) as fuelprice, SUM(p.price) as price, SUM(p.expenses) as expenses, (SUM(p.pilotpay) * SUM(p.flighttime)) as pilotpay FROM phpvms_pireps p WHERE DATE_SUB(NOW(), INTERVAL 1 MONTH) <= p.submitdate GROUP BY `ym` ORDER BY `timestamp` ASC] Query Result.. (row) string 0 ym int 0 timestamp int 0 total real 0 revenue real 0 gross real 0 fuelprice real 0 price real 0 expenses real 0 pilotpay No Results

yesterday updated from 904 to 906 and today updated from 906 to 907 . I try for re-upload 907 for 2times . re-upload original file or 907 ? [Checksum failed] /core/common/StatsData.class.php did not match, possibly corrupt or out of date [Checksum failed] /core/common/FuelData.class.php did not match, possibly corrupt or out of date [Checksum failed] /core/templates/profile_main.tpl did not match, possibly corrupt or out of date [Checksum failed] /core/templates/frontpage_recentbids.tpl did not match, possibly corrupt or out of date [Checksum failed] /core/classes/autoload.php did not match, possibly corrupt or out of date [Checksum failed] /core/modules/Pilots/Pilots.php did not match, possibly corrupt or out of date

Install Check Checking PHP version [OK] PHP version is 5.2.x Checking connectivity... [OK] Can contact outside servers Checking for SimpleXML module... [OK] SimpleXML module exists! Checking file hashes for corrupt or mismatched files [Checksum failed] /core/common/StatsData.class.php did not match, possibly corrupt or out of date [Checksum failed] /core/common/FuelData.class.php did not match, possibly corrupt or out of date [Checksum failed] /core/templates/profile_main.tpl did not match, possibly corrupt or out of date [Checksum failed] /core/templates/frontpage_recentbids.tpl did not match, possibly corrupt or out of date [Checksum failed] /core/classes/autoload.php did not match, possibly corrupt or out of date [Checksum failed] /core/modules/Pilots/Pilots.php did not match, possibly corrupt or out of date -- Checked 167 files, found 6 errors http://@@@@@@@@.com/test/admin/index.php/operations/aircraft Fatal error: Class 'CodonCache' not found in /home/@@@@@/public_html/test/core/common/OperationsData.class.php on line 76 line 76 $all_aircraft = CodonCache::read($key);

$hours = PIREPData::getIntervalDataByMonth(array(), 1); echo $hours->total; DB::debug(); ?> that code is correct ? if correct , Not shown anything . Flight Hours this Month:

can anybody help me! Hours This Month doesn't work . how can i use those codes in pilot center and pilot public profile .

Hi Fatal error: Class 'CodonCache' not found in /home/xxxxx/public_html/test/core/codon.config.php on line 80 and Line 80 : CodonCache::init($cache_settings);

for second code nothing show on screen , but first code fully work .

HI <?php $flights = PIREPData::findPIREPS(array('DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= p.submitdate')); $total = count($flights); echo $total; ?> that code for Flight This Month work , now show all pireps, but i want show Flight This Month for accepted pireps . and for Hours This Month : <?php $hours = PIREPData::getIntervalDataByMonth(array(), 1); echo $hours->total; DB::debug(); ?> doesn't work . and how can I use those codes in Pilot center and pilot public profile ?

$flights = PIREPData::findFlights(array('DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= p.submitdate')); $total = count($flights); changed to $flights = PIREPData::findPIREPS(array('DATE_SUB(CURDATE(), INTERVAL 1 MONTH) <= p.submitdate')); $total = count($flights); and <?php $hours = PIREPData::getIntervalDataByMonth(array(), 1); echo $hours->total; ?> I added those code in Pilot center , but doesn't work . and no value show in pilot center .

can anybody help me!

Hi How can i show total pilot in each rank ? RanksData::getAllRanks();

Thank you Nabeel . Those codes doesn't work for me .

I have same problem with Total Hours Flown and Total Flights Today.

HI That code doesn't work for me and just show No reports have been filed .

sorry Nabeel , I didn't find schedule flights .