. */ function EditPoints(){ global $db; $result = $db->Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE rudi_unit_members.status_id != 4 AND rudi_unit_members.status_id != 5 ORDER BY rudi_ranks.weight DESC , rudi_unit_members.date_promotion ASC , rudi_unit_members.date_enlisted ASC"); $row = $db->Fetch($result); if(isset($_POST['processed'])){ echo "Updating data... Please wait."; foreach($row as $soldier){ $mID = $soldier['member_id']; $missed = $_POST[$mID.'missed']; $points = $_POST[$mID.'points']; if($missed !="" && $points != ""){ $db->Query("UPDATE `rudi_unit_members` SET `points` = $points, `drillcount` = $missed WHERE `member_id` = $mID LIMIT 1"); }else{ ReportError("Error updating points for soldier id# '$mID'. Please contact administrator."); } } PageRedirect(1,"?op=adjutant&edit=points"); return; } ?>
"; else echo ""; echo ""; echo "\n"; } CloseTable(); echo ""; } function editLOAs($status_id = 1){ global $db; $result = $db->Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE rudi_unit_members.status_id = '$status_id' ORDER BY rudi_ranks.weight DESC , rudi_unit_members.date_promotion ASC , rudi_unit_members.date_enlisted ASC"); $row = $db->Fetch($result); ?> '; for($x=1; $x<4; $x++){ if($status_id == $x) echo ''; else echo ''; } echo ''; ?>
RankSoldierStatusPointsDrills Missed
{$soldier['shortname']} {$soldier['first_name']} {$soldier['last_name']} ".getStatus($soldier['status_id'])." /100 /3
"; else echo ""; echo ""; $num++; } CloseTable(); } function EditStatus($member_id){ global $db; $form = new BayonetForm($_SERVER['PHP_SELF'], "POST"); if($form->VerifySubmit('processed')){ return; } $result = $db->Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE `member_id` = '$member_id' LIMIT 1"); $row = $db->FetchRow($result); ?>
RankSoldierStatus
{$member['shortname']}{$member['first_name']} {$member['last_name']}Edit
RankSoldierStatus
radioButton('status', 1, true); ?>Active
radioButton('status', 2); ?>On Leave
radioButton('status', 3); ?>On Extended Leave
__destruct(); } function getStatus($sID){ global $db; $gStatusName = "N/A"; $result = $db->Query("SELECT `name` FROM `rudi_statuses` WHERE `status_id` = $sID LIMIT 1"); $row = $db->FetchRow($result); return $row['name']; } ?>