$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
