function mfDayofweek($strDate) { // parse string into month,day,year list ($intYear,$intMonth,$intDay) = explode('-',$strDate); // create a unix time element from the date $intTime = mktime(12, 0, 0, $intMonth, $intDay,$intYear); // load date and time elements into an array // check the docs on this one, it's useful $aryDateinfo = getdate($intTime); // send back return $aryDateinfo["weekday"]; } $today = gmdate("Y-m-d"); $utc = gmdate("H:i:s"); $n=0; $i=0; require('dbserver.php'); /* MySQL table created to store the data */ $userstable = "E10"; /* make connection to database */ MYSQL_CONNECT($hostname,$username,$password) OR DIE("Unable to connect to database"); @mysql_select_db("$dbName") or die("Unable to select database"); $query = "SELECT * FROM $userstable ORDER BY FREQ,UTC"; $result = MYSQL_QUERY($query); $number = MYSQL_NUMROWS($result); print "Home"; print ""; $i=0; /* CREATE TABLE E10 ( ID int(11) NOT NULL auto_increment, CALL varchar(10) NOT NULL, UTC int(11) DEFAULT '0' NOT NULL, FREQ int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (ID) ); */ /* Close the database connection */ MYSQL_CLOSE(); ?>
"; $s=sprintf("%6sU ", " "); print "$s"; for ($j=0; $j<2400; $j+=100) { $s=sprintf("%04d", $j); $s1=substr($s,0,1); print $s1; print $s1; print $s1; print $s1; } print "
"; $s=sprintf("%6sT ", " "); print "$s"; for ($j=0; $j<2400; $j+=100) { $s=sprintf("%04d", $j); $s1=substr($s,1,1); print $s1; print $s1; print $s1; print $s1; } print "
"; $s=sprintf("%6sC ", " "); print "$s"; for ($j=0; $j<2400; $j+=100) { $s=sprintf("%04d", $j); $s1=substr($s,1,1); print "0"; print "1"; print "3"; print "4"; } print "
"; $s=sprintf("%6s ", "kHz"); print "$s"; for ($j=0; $j<2400; $j+=100) { $s=sprintf("%04d", $j); $s1=substr($s,1,1); print "0"; print "5"; print "0"; print "5"; } $i=0; $oldFreq=-1; $oldTime=0; while($i<$number) { $utc = mysql_result($result,$i,"utc"); $ID = mysql_result($result,$i,"ID"); $call = mysql_result($result,$i,"call"); $freq = mysql_result($result,$i,"freq"); if ($oldFreq != $freq) { $oldFreq = $freq; print "
"; $s=sprintf("%6d ", $freq); print "$s"; $oldTime=0; } $oldh=floor($oldTime/100); $oldm=$oldTime-($oldh*100); $old=$oldm+($oldh*60); $utch=floor($utc/100); $utcm=$utc-($utch*100); $utcd=$utcm+($utch*60); $dif = $utcd-$old; $dif=floor($dif/15); $dif=$dif-1; for ($j=0; $j<$dif; $j++) { print " "; } print substr($call,0,1); $i++; $oldTime=$utc; } print "