. */ 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 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']; $attended = $_POST[$mID.'attended']; $points = $_POST[$mID.'points']; if($missed !="" && $points != ""){ $db->Query("UPDATE `rudi_unit_members` SET `points` = $points, `drillcount` = $missed, `attendcount` = $attended 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 ""; } /****** NEW CODE ADDED LARRABEE 11-20-2012 ********/ function EditPoints2(){ 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 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']; $attended = $_POST[$mID.'attended']; $points = $_POST[$mID.'points']; if($missed !="" && $points != ""){ $db->Query("UPDATE `rudi_unit_members` SET `points` = $points, `drillcount` = $missed, `attendcount` = $attended WHERE `member_id` = $mID LIMIT 1"); }else{ ReportError("Error updating points for soldier id# '$mID'. Please contact administrator."); } } PageRedirect(1,"?op=adjutant&edit=pointsnew"); return; } ?>

Rank	Soldier	Status	Points	Drills Missed	Drills Attended
{$soldier['shortname']}	{$soldier['first_name']} {$soldier['last_name']}	".getStatus($soldier['status_id'])."	/100	/3	/3

"; else echo ""; echo ""; echo "\n"; } CloseTable(); echo ""; } /****** END NEW CODE ADDED *******/ 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 ''.$opArr[$x].''; else echo ''.$opArr[$x].''; } echo ''; ?>

Rank	Soldier	Status	Points	Drills Missed	Drills Attended
{$soldier['shortname']}	{$soldier['first_name']} {$soldier['last_name']}	".getStatus($soldier['status_id'])."	/100	/3	/3

"; else echo ""; echo ""; $num++; } CloseTable(); } function EditStatus($member_id){ global $db; $form = new BayonetForm("", "POST"); if($form->VerifySubmit('processed')){ echo "Please wait while your information is being processed..."; $status_id = $form->request['status']; $db->query("UPDATE `rudi_unit_members` SET `status_id` = '$status_id' WHERE `member_id` = '$member_id' LIMIT 1"); PageRedirect(1, "?op=adjutant&edit=loas&member={$member_id}"); 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); ?>

Rank	Soldier	Status
{$member['shortname']}	{$member['first_name']} {$member['last_name']}	Edit

Rank	Soldier	Status
		radioButton('status', 1, $row['status_id'] == 1 ? true : false); ?>Active radioButton('status', 2, $row['status_id'] == 2 ? true : false); ?>On Leave radioButton('status', 3, $row['status_id'] == 3 ? true : false); ?>On Extended Leave
submitButton('processed'); ?>

__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']; } ?>