\n"; echo "\n"; echo "Stoney Cove Temperatures\n"; echo "\n"; echo "\n"; echo "\n"; if ($month != 0) { if ($day != 0) { do_day(); } else { do_month(); } } else { do_year(); } echo "\n"; echo "\n"; function do_day() { global $month, $months, $day; for ($i=-2;$i<=50;$i++) { $subs[$i] = -1; } $sqlq = "select tmp_temp, count(tmp_id) from temps where tmp_month = ".$month." and tmp_day = ".$day." group by tmp_temp order by tmp_temp"; $rs = mysql_query($sqlq); $NumRows = mysql_num_rows($rs); $Top_Subs = 0; for ($i=1;$i<=$NumRows;$i++) { $k = mysql_fetch_row($rs); if ($k[1] >= $TopSubs) { $Top_Subs = $k[1]; } $subs[$k[0]] = $k[1]; } #Figure out the scale - we have 25(ish) lines to play with. $Scale = $Top_Subs / 50; $Scale = ceil($Scale); $yaxis[26] = ' | '; $yaxis[25] = ' '.(25 * $Scale).' | '; $yaxis[24] = 'N | '; $yaxis[23] = 'u | '; $yaxis[22] = 'm | '; $yaxis[21] = 'b | '; $yaxis[20] = 'e '.(20 * $Scale).' | '; $yaxis[19] = 'r | '; $yaxis[18] = ' | '; $yaxis[17] = 'o | '; $yaxis[16] = 'f | '; $yaxis[15] = ' '.(15 * $Scale).' | '; $yaxis[14] = 'S | '; $yaxis[13] = 'u | '; $yaxis[12] = 'b | '; $yaxis[11] = 'm | '; $yaxis[10] = 'i '.(10 * $Scale).' | '; $yaxis[9] = 's | '; $yaxis[8] = 's | '; $yaxis[7] = 'i | '; $yaxis[6] = 'o | '; if ((5 * $Scale) < 10) { $yaxis[5] = 'n '.(5 * $Scale).' | '; } else { $yaxis[5] = 'n '.(5 * $Scale).' | '; } $yaxis[4] = 's | '; $yaxis[3] = ' | '; $yaxis[2] = ' | '; $yaxis[1] = ' | '; echo "\n"; echo "\n"; echo "Stoney Cove Temperatures\n"; echo "\n"; echo "\n"; echo "
Stoney Cove Temperatures Submitted for ".$day." ".$months[$month]."
\n"; echo "

 

\n"; echo "
\n";


	for ($i=26;$i>0;$i--) {
		echo $yaxis[$i];
		if ($i == 1) {
			for ($m=-2;$m<=50;$m++) {
				if (ceil($subs[$m] / $Scale) >= $i) {
					if (($subs[$m] / $Scale) < $i) {
						echo "oo_";
					} else {
						echo "00_";
					}
				} else {
					echo "___";
				}
			}
		} else {
			for ($m=-2;$m<=50;$m++) {
				if (ceil($subs[$m] / $Scale) >= $i) {
					if (($subs[$m] / $Scale) < $i) {
						echo "oo ";
					} else {
						echo "00 ";
					}
				} else {
					echo "   ";
				}
			}
		}

		echo "\n";
	}

	echo "       -2 -1 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 \n";
	echo "\n";
	echo "                                        Temperature\n";

	echo "
\n"; echo "\n"; echo "\n"; } function do_month() { global $month, $yaxis, $months; for ($i=1;$i<=31;$i++) { $temps[$i] = -1; } echo "\n"; echo "\n"; echo "Stoney Cove Temperatures\n"; echo "\n"; echo "\n"; echo "
Stoney Cove Average Daily Temperatures for ".$months[$month]."
\n"; echo "

 

\n"; echo "
\n";

	$sqlq = "select tmp_day, avg(tmp_temp) from temps where tmp_month = ".$month." group by tmp_day order by tmp_day";
	$rs = mysql_query($sqlq);
	$NumRows = mysql_num_rows($rs);
	
	for ($i=1;$i<=$NumRows;$i++) {
		$k = mysql_fetch_row($rs);
		$temps[$k[0]]=$k[1];
	}

	for ($i=26;$i>=0;$i--) {
		echo $yaxis[$i];
		for ($m=1;$m<=31;$m++) {
			if ($temps[$m] >= $i) {
				echo "00 ";
			} else {
				echo "   ";
			}
		}
		echo "\n";
	}


	echo "      |________________________________________________________________________________________";
	if ($month == 2) {
		echo "\n";
	} else {
		if (($month == 4) or ($month == 6) or ($month == 9) or ($month == 11)) {
			echo "___\n";
		} else {
			echo "______\n";
		}
	}
	echo "        01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 ";
	if ($month == 2) {
		echo "\n";
	} else {
		if (($month == 4) or ($month == 6) or ($month == 9) or ($month == 11)) {
			echo "30 \n";
		} else {
			echo "30 31 \n";
		}
	}
	echo "\n";
	echo "                                                 Day\n";
	echo "
\n"; echo "\n"; echo "\n"; } function do_year() { global $yaxis; for ($i=1;$i<=12;$i++) { $temps[$i] = -1; } $sqlq = "select tmp_month, avg(tmp_temp) from temps group by tmp_month order by tmp_month"; $rs = mysql_query($sqlq); $NumRows = mysql_num_rows($rs); for ($i=1;$i<=$NumRows;$i++) { $k = mysql_fetch_row($rs); $temps[$k[0]]=$k[1]; } echo "
Stoney Cove Average Monthly Temperatures
\n"; echo "

 

\n"; echo "
\n";

	for ($i=26;$i>=0;$i--) {
		echo $yaxis[$i];
		for ($m=1;$m<=12;$m++) {
			if ($temps[$m] >= $i) {
				echo "000  ";
			} else {
				echo "     ";
			}
		}
		echo "\n";
	}

	echo "      |____________________________________________________________\n";
	echo "        Jan  Feb  Mar  Apr  May  Jun  Jul  Aug  Sep  Oct  Nov  Dec\n";
	echo "\n";
	echo "                                 Month\n";
	echo "
\n"; } ?>