$db = mysql_connect($host, $dbuser, $dbpassword); mysql_select_db($DatabaseName, $db); // $period=92; // Get the requested period, if blank choose the latest $period = $_GET['period']; if ($period < 1) { $SQL = "SELECT MAX(`period`) FROM `arpsc_ecrept`"; $period = singleResult($SQL, $db); } $p9 = $period; $p1 = (int) ((int) $p9 - 11); // Display the month name for this report $SQL = 'SELECT lastday FROM `periods` WHERE `periodno`=' . $period; $usedate = singleResult($SQL, $db); $monthnames = array('J', 'F', 'M', 'A', 'M', 'J', 'J', 'A', 'S', 'O', 'N', 'D'); ARESheader($title, "ARPSC Michigan Section Summary"); ARESleftBar($db); echo ' <div id="main">' . "\n"; echo " <center>\n"; // CSS classes used in the table $s0 = "class=\"rowS0\""; $s1 = "class=\"rowS1\""; $s1B = "class=\"rowS1B\""; $s1S = "class=\"rowS1S\""; $s1L = "class=\"rowS1L\""; $s2 = "class=\"rowS2\""; $s2S = "class=\"rowS2S\""; //================================================================================================== // F S D 2 1 2 T a b l e //================================================================================================== echo " <p><h1>FSD-212 12-month Summary</h1></p>\n";
<?php include 'includes/session.inc'; $title = _('Michigan Section FSD-212'); include 'includes/functions.inc'; // Remember the launch time $starttime = strftime("%A, %B %d %Y, %H:%M"); // Open the database $db = mysql_connect($host, $dbuser, $dbpassword); mysql_select_db($DatabaseName, $db); ARESheader($title, "Adjust Member Count"); ARESleftBar($db); echo ' <div id="main">' . "\n"; $Q1 = "SELECT DISTINCT `COUNTY` FROM `arpsc_ecrept`"; $R1 = getResult($Q1, $db); while ($row1 = getRow($R1, $db)) { $Q2 = "SELECT MAX(`PERIOD`) FROM `arpsc_ecrept` " . "WHERE `county`='" . $row1[0] . "'"; $last = singleResult($Q2, $db); $Q3 = "SELECT `ARESMEM` FROM `arpsc_ecrept` " . "WHERE `COUNTY`='" . $row1[0] . "' " . "AND `PERIOD`=" . $last; $latest = singleResult($Q3, $db); $Q4 = "SELECT `ARESMEM` FROM `arpsc_ecrept` " . "WHERE `COUNTY`='" . $row1[0] . "' " . "AND `PERIOD`=0"; $zeroth = singleResult($Q4, $db); echo "<p>" . $row1[0] . ": " . $last . ", "; if ($latest == $zeroth) { echo $latest . ", " . $zeroth . "</p>\n"; } else { if ($zeroth > 0) { echo "<b>" . $latest . ", " . $zeroth . "</b><br/>\n"; $Q5 = 'UPDATE `arpsc_ecrept` SET `ARESMEM`=' . $latest . " WHERE `COUNTY`='" . $row1[0] . "' AND `PERIOD`=0"; echo "---" . $Q5 . "---</p>\n"; $R5 = getResult($Q5, $db);
// index.php // $Revision: 1.1 $ - $Date: 2007-11-07 07:44:55-05 $ // // index is the opening page of the mi-nts website. It displays the // standard menu, and then only some text introducing the site. // include 'includes/session.inc'; $title = _('Michigan Section ARES/RACES'); include 'includes/functions.inc'; // Remember the launch time $starttime = strftime("%A, %B %d %Y, %H:%M"); // Open the database $db = mysql_connect($host, $dbuser, $dbpassword); mysql_select_db($DatabaseName, $db); ARESheader($title, "ARES RACES ARPSC Michigan Section"); ARESleftBar($db); ?> <div id="main"> <h1>Welcome</h1> <p> This is the site of the Michigan Section of the Amateur Radio Emergency Services. </p> <p>Michigan ARPSC is the Amateur Radio Public Service Corps and encompasses <a href="http://www.arrl.org/FandES/field/pscm/sec1-ch1.html">ARES</a> (Amateur Radio Emergency Services), <a href="http://www.races.net/what.html">RACES</a> (Radio Amateur Civil Emergency Services) and <a href="http://www.skywarn.org/">Skywarn</a> (a service provided in cooperation with the National Weather Service). ARES Events can be any event where a Communications need exists of a non-commercial nature (<a href="http://www.arrl.org/FandES/field/regulations/news/part97/">FCC Part 97 Rules</a>). ARES is administered by the <a href="http://www.arrl.org/">ARRL - American Radio Relay League</a>. RACES is any event that the Government sees a need for additional communications needs (Generally the Governor of a state or their duly appointed Representative makes the call. For clarification please read <a href="http://www.arrl.org/FandES/field/regulations/news/part97/"> Part 97 Rules</a>) and is administered by <a href="http://www.fema.gov/">FEMA</a>. Skywarn is administered by the <a href="http://www.noaa.gov/">NOAA - National Oceanic and Atmospheric Administration</a> National Weather Service Division. There are four National Weather Service sites in Michigan - <a href="http://www.crh.noaa.gov/dtx/">Detroit/White Lake</a>, <a href="http://www.crh.noaa.gov/grr/">Grand Rapids</a>,
<?php include 'includes/session.inc'; $title = _('Meeting Signup'); include 'includes/functions.inc'; // Remember the launch time $starttime = strftime("%A, %B %d %Y, %H:%M"); // Open the database $db = mysql_connect($host, $dbuser, $dbpassword); mysql_select_db($DatabaseName, $db); ARESheader($title, "ARES Michigan Section ARPSC"); ARESleftBar($db); echo " <div id=\"main\">\n"; echo " <p><h1><center>Online Meeting Signup</center></h1></p>\n"; echo " <center>\n"; // Get the meeting ID from the argument list $meetid = $_GET['mid']; $seq = $_GET['seq']; $call = strtoupper($_POST['call']); $email = strtolower($_POST['email']); //echo "<p>mid=" . $meetid . ", seq=" . $seq . // ", call=" . $call . ", email=" . $email . "</p>\n"; $SQL0 = "SELECT `description` FROM `meet_meetings` WHERE `mid`=" . $meetid; //echo " <p>" . $SQL0 . "</p>\n"; $result0 = getResult($SQL0, $db); $row0 = getRow($result0, $db); $desc = $row0[0]; echo " <h1>" . $desc . "</h1>\n"; $SQL1 = "SELECT `date`,`capacity` FROM `meet_sessions` WHERE `mid`=" . $meetid . " AND `seq`=" . $seq; $res1 = getResult($SQL1, $db); $row1 = getRow($res1, $db);
<?php // updates.php // $Revision: 1.1 $ - $Date: 2007-10-30 16:10:49-04 $ // include 'includes/session.inc'; $title = _('Michigan Section ARES'); include 'includes/functions.inc'; $db = mysql_connect($host, $dbuser, $dbpassword); mysql_select_db($DatabaseName, $db); ARESheader($title, "ARES Net Michigan Section ARPSC RACES"); // Remember the launch time $starttime = strftime("%A, %B %d %Y, %H:%M"); ARESleftBar($db); // Remember the launch time $starttime = strftime("%A, %B %d %Y, %H:%M"); // Determine the dates of the events to search for $now = mktime(); // Today as ISO date $searchdate = strftime("%Y-%m-%d", $now); // Today - 7 days $then = $now - 86400 * 7; // 7 days ago as ISO date $checkdate = strftime("%Y-%m-%d", $then); $maxdate = 0; ?> <div id="main"> <p></p> <?php echo '<h1>Updated Pages</h1>' . "\n"; $s1 = 'SELECT MAX(`updated`) FROM `arpsc_ecrept`';
// Report FSD 212 data for a single county // include 'includes/session.inc'; $title = _('Michigan Section FSD-212'); include 'includes/functions.inc'; // Remember the launch time $starttime = strftime("%A, %B %d %Y, %H:%M"); // Open the database $db = mysql_connect($host, $dbuser, $dbpassword); mysql_select_db($DatabaseName, $db); // Get the requested period, if blank choose the latest $county = $_GET['county']; // // Display the month name for this report // $SQL = 'SELECT lastday FROM `periods` WHERE `periodno`=' . $period; // $usedate=singleResult($SQL,$db); ARESheader($title, "NTS Michigan Section Traffic"); ARESleftBar($db); echo ' <div id="main">' . "\n"; $q2 = "SELECT `countyname` FROM `arpsc_counties` WHERE `countycode`='" . $county . "'"; $countyname = singleResult($q2, $db); echo ' <p><h1>FSD-212 Report for ' . $countyname . "</h1></p>\n"; ?> <table> <tr> <td class="rowS0" rowspan="2">Period</td> <td class="rowS0" rowspan="2">Monthly Man Hours</td> <td class="rowS0" rowspan="2">Contrib Dollar Value</td> <td class="rowS0" rowspan="2">Total # ARES mbrs</td> <td class="rowS0" colspan="2">Net</td> <td class="rowS0" colspan="2">Public Service</td> <td class="rowS0" colspan="2">Emergency</td>
$db = mysql_connect($host, $dbuser, $dbpassword); mysql_select_db($DatabaseName, $db); // $period=92; // Get the requested period, if blank choose the latest $period = $_GET['period']; if ($period < 1) { $SQL = "SELECT MAX(`period`) FROM `arpsc_ecrept`"; $period = singleResult($SQL, $db); } $p9 = $period; $p1 = (int) ((int) $p9 - 17); // Display the month name for this report $SQL = 'SELECT lastday FROM `periods` WHERE `periodno`=' . $period; $usedate = singleResult($SQL, $db); $monthnames = array('J', 'F', 'M', 'A', 'M', 'J', 'J', 'A', 'S', 'O', 'N', 'D'); ARESheader($title, "ARPSC Michigan Section FSD-212"); ARESleftBar($db); echo ' <div id="main">' . "\n"; //echo "<p>period=" . $period . ", first=" . $p1 . ", last=" . $p9 . "</p>\n"; echo " <p><h1>FSD-212 Reporting History</h1></p>\n"; echo " <center>\n"; echo " <table width=\"100%\">\n"; echo "\t<tr>\n"; echo "\t\t<td class=\"rowS0\">Dist</td>\n"; echo "\t\t<td class=\"rowS0\">County</td>\n"; for ($i = $p1; $i < $p9 + 1; $i++) { $index = $i % 12; echo "\t\t<td class=\"rowS0\" width=\"15px\">" . $monthnames[$index] . "</td>\n"; } echo "\t</tr>\n"; // CSS classes used in the table