setOrderingInfo($_GET['order']); if (isset($_GET['page'])) $myData->actPageNr = $_GET['page']; if (isset($_POST['formdata'])) $myData->getWhereClause($_POST['formdata']); $maxRecord = 15; $sqlbase = "SELECT * FROM vb3_user ORDER BY userid ASC "; $sql = $sqlbase."LIMIT ".(($myData->actPageNr-1)*$maxRecord).",".$maxRecord; $Result = $MyDb->f_ExecuteSql($sql); $ResultRowNr = $MyDb->f_GetSelectedRows($Result); $ResultTotalRow = $MyDb->f_ExecuteSql($sqlbase); $totalRows = $MyDb->f_GetSelectedRows($ResultTotalRow); $row = 0; while ($Resultset = $MyDb->f_GetRecord($Result)) { $sqlbasevb3_userfield = "SELECT * FROM vb3_userfield WHERE userid = '".$Resultset['userid']."' "; $Resultvb3_userfield = $MyDb->f_ExecuteSql($sqlbasevb3_userfield); $Resultsetvb3_userfield = $MyDb->f_GetRecord($Resultvb3_userfield); $total_hours = number_format($Resultsetvb3_userfield['field9'],1); $sqlbaseflights = "SELECT COUNT( pirep_id ) as count_flights FROM pirep WHERE pilot_id = 'VAA".$Resultset['userid']."' "; $Resultflights = $MyDb->f_ExecuteSql($sqlbaseflights); $Resultsetflights = $MyDb->f_GetRecord($Resultflights); $total_flights = number_format($Resultsetflights['count_flights']); $sqlbaselastflight = "SELECT * FROM pirep WHERE pilot_id = 'VAA".$Resultset['userid']."' ORDER BY date DESC LIMIT 1 "; $Resultlastflight = $MyDb->f_ExecuteSql($sqlbaselastflight); $Resultsetlastflight = $MyDb->f_GetRecord($Resultlastflight); $date = date("m-d-Y",strtoTime($Resultsetlastflight['date'])); $time = date("h:i A",strtoTime($Resultsetlastflight['date'])); $joindate = date('m-d-Y', $Resultset['joindate']); $chrispage = setPager($myData->actPageNr,ceil($totalRows/$maxRecord),$IDPilot); $navbits = array(); $navbits[$parent] = 'Logbook'; $navbits = construct_navbits($navbits); eval('$navbar = "' . fetch_template('navbar') . '";'); eval('print_output("' . fetch_template('logbook_top') . '");'); $str = (($row++ % 2) == 0 ) ? '' : ''; //Now taken care of in templates. //echo $str; //echo 'VAA'.$Resultset['userid'].''; //if ($total_flights == 0) { //echo ''.$Resultset['username'].''; //echo ''.$joindate.''; //echo 'NO FLIGHTS LOGGED'; //echo ''.$Resultsetvb3_userfield['field13'].' hrs'; //} else { //echo ''.$Resultset['username'].''; //echo ''.$joindate.''; //echo ''.$date.''; //echo ''.$total_flights.''; //echo ''.$total_hours.' hrs'; //echo ''.number_format($Resultsetvb3_userfield['field13'],1).' hrs'; //} //echo ''; } ?>