Miscellany

<?
// Site Statistics //

function showstats() {
	$sql_hits = mysql_query("SELECT * FROM hits");
	$row_hits = mysql_fetch_array($sql_hits);
	$newhits = $row_hits['hits'] + 1;
	mysql_query("UPDATE hits SET hits='$newhits' WHERE id='1'");
	$userip = $_SERVER['REMOTE_ADDR'];
	$date = date("Y-m-d");
	$timestamp = time();
	mysql_query("INSERT INTO stats (IP, date) values('$userip', '$date')");
	$sql_datecheck = mysql_query("SELECT * FROM stats ORDER BY date ASC LIMIT 1");
	$row_datecheck = mysql_fetch_array($sql_datecheck);
	$old_date = $row_datecheck['date'];
	$elapsed_days = datediff("d", "$old_date", "$date");
	$get_today = mysql_query("SELECT * FROM stats WHERE date='$date'");
	$count_today = mysql_num_rows($get_today);
	$get_total = mysql_query("SELECT * FROM stats");
	$count_total = mysql_num_rows($get_total);
	$hits = $row_hits['hits'];
	$avgvisit = round($count_total / $elapsed_days, 0);
	$avghit = round($hits / $elapsed_days, 0);
	echo "Total Visits: <i>" .$count_total . "</i><br />
	Total Hits: <i>" .$hits. "</i><br />
	Daily Avg. Visits: <i>" .$avgvisit. "</i><br />
	Daily Avg. Hits: <i>" .$avghit. "</i><br /><br />";
}

function usersonline() {
	$result2 = mysql_query("SELECT DISTINCT ip FROM useronline WHERE guest=1");
	$user2 = mysql_num_rows($result2);
	mysql_free_result($result2);
	if ($user2==1) {echo 'There is currently <u>'. $user2.'</u> visitor browsing this website.';} else {echo 'There are currently <u>'. $user2.'</u> visitors browsing this website.';}
}
?>