Weekly Check In - Davidson County ARES

Tue. Aug 27th, 2024

logged_in){ if ($session->userlevel >= 1){ echo “[Back Home]“; ?> Weekly ARES Check in

mysqlSelectRows("Select * from net where xdate>='".date("Y-m-d")."' limit 1 "); extract($array[0],EXTR_OVERWRITE); $NCN=GetName($NC); $ANCN=GetName($ANC); $ELN=GetName($EL); $WLN=GetName($WL); ?>

Position	Scheduled	Replacement
Net Control
Alt Net Control
East Sector
West Sector

mysqlSelectRows("Select * from net where xdate>'".date("Y-m-d")."' limit 1 "); $NCN=GetName($arr[0]['NC']); $ANCN=GetName($arr[0]['ANC']); $ELN=GetName($arr[0]['EL']); $WLN=GetName($arr[0]['WL']); ?>

Next Week

Position	Scheduled
Net Control
Alt Net Control
East Sector
West Sector

mysqlSelectRows("Select * from checkin where sector='S' order by suffix"); $i = 1; foreach($array as $val){ echo "\n"; $i++; } for ($x = 0; $x <= 1; $x++){ echo "\n"; $i++; } ?> mysqlSelectRows("Select * from checkin where sector='E' order by suffix"); foreach($array as $val){ $b = substr($val['suffix'], 0, 1); if ($b >= "A" and $b <= "I"){ $bgcolor = "#CCFFFF"; } if ($b >= "J" and $b <= "R"){ $bgcolor = "#CCFF99"; } if ($b >= "S" and $b <= "Z"){ $bgcolor = "#FFCCFF"; } echo "\n"; $i++; } for ($x = 0; $x <= 10; $x++){ echo "\n"; $i++; } ?> mysqlSelectRows("Select * from checkin where sector='W' order by suffix"); foreach($array as $val){ $b = substr($val['suffix'], 0, 1); if ($b >= "A" and $b <= "I"){ $bgcolor = "#CCFFFF"; } if ($b >= "J" and $b <= "R"){ $bgcolor = "#CCFF99"; } if ($b >= "S" and $b <= "Z"){ $bgcolor = "#FFCCFF"; } echo "\n"; $i++; } for ($x = 0; $x <= 10; $x++){ echo "\n"; $i++; } ?> mysqlSelectRows("Select * from checkin where sector='v' order by suffix"); foreach($array as $val){ $b = substr($val['suffix'], 0, 1); if ($b >= "A" and $b <= "I"){ $bgcolor = "#CCFFFF"; } if ($b >= "J" and $b <= "R"){ $bgcolor = "#CCFF99"; } if ($b >= "S" and $b <= "Z"){ $bgcolor = "#FFCCFF"; } echo "\n"; $i++; } for ($x = 0; $x <= 10; $x++){ echo "\n"; $i++; } ?>

DCARES Weekly Net Roster
SUPPORT SECTOR
First Name	Last Name	Callsign	Suffix	ARES	Skywarn	Checked In	Winlink	Battery Power
" . $val['fname'] . "	" . $val['lname'] . "	" . $val['callsign'] . "	" . $val['suffix'] . "

			Totals:	0	0
EAST SECTOR
First Name	Last Name	Callsign	Suffix	ARES	Skywarn	Checked In	Winlink	Battery Power
" . $val['fname'] . "	" . $val['lname'] . "	" . $val['callsign'] . "	" . $val['suffix'] . "

			Counts:	0	0
WEST SECTOR
First Name	Last Name	Callsign	Suffix	ARES	Skywarn	Checked In	Winlink	Battery Power
" . $val['fname'] . "	" . $val['lname'] . "	" . $val['callsign'] . "	" . $val['suffix'] . "

			Counts:	0	0
VISITORS
First Name	Last Name	Callsign	Suffix	ARES	Skywarn	Checked In	Winlink	Battery Power
" . $val['fname'] . "	" . $val['lname'] . "	" . $val['callsign'] . "	" . $val['suffix'] . "

			Counts:	0

		Total ARES:		0
		Total SKYWARN:		0
		Total Net Checkins:		0

'
"; } ?>