Exemple #1
0
$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";
Exemple #2
0
<?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);
Exemple #3
0
//    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.&nbsp;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>,
Exemple #4
0
<?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);
Exemple #5
0
<?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`';
Exemple #6
0
//    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>
Exemple #7
0
$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