// 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: " .$count_total . "
Total Hits: " .$hits. "
Daily Avg. Visits: " .$avgvisit. "
Daily Avg. Hits: " .$avghit. "
";
}
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 '. $user2.' visitor browsing this website.';} else {echo 'There are currently '. $user2.' visitors browsing this website.';}
}
?>