File: /home/awaldron/www/archive/demo/content_stats.php
<?php
session_start();
/// THIS PAGE IS OUT OF WHACK, CONSIDER OVERHAULING
?>
<html>
<head>
<title><-Vocollect Inc.-> Page Statistics</title>
</head>
<link rel="stylesheet" type="text/css" href="default.css">
<?php
include("_functions.php");
dbconnect();
$yest = substr(date_unixtots(time()-86400),0,8);
$year = 0;
$month = 0;
$yesterday = 0;
$today = 0;
$title = str_replace("\'","'",str_replace("and","&",$_GET["title"]));
$self = $_GET["self"];
$sql = "SELECT log_stamp FROM tbl_userlog WHERE log_page='".$self."' AND log_stamp >= ".mktime(0,0,0,1,1,date("Y")." AND log_stamp <= ".mktime(23,59,59,12,31,date("Y")." AND log_name <> 'falcon1'";
$res = mysql_query($sql);
$year = mysql_num_rows($res);
for ($i=0; $i < mysql_num_rows($res); $i++) {
$row = mysql_fetch_array($res);
if (($row["log_stamp"] >= (date("Ym")."01000000")) && ($row["log_stamp"] <= (date("Ymt")."235959"))) $month++;
if (($row["log_stamp"] >= ($yest."000000")) && ($row["log_stamp"] <= ($yest."235959"))) $yesterday++;
if (($row["log_stamp"] >= (date("Ymd")."000000")) && ($row["log_stamp"] <= (date("Ymd")."235959"))) $today++;
}
echo "<P><span class=\"subhead\">Page Statistics</span>\n";
echo "<br><b>".$title."</b><br>(".$self.")\n";
echo "<P><table border=0>\n";
echo "<tr><td><b>Hits Today:</b></td><td>".$today."</td></tr>\n";
echo "<tr><td><b>Hits Yesterday:</b></td><td>".$yesterday."</td></tr>\n";
echo "<tr><td><b>Hits This Month:</b></td><td>".$month."</td></tr>\n";
echo "<tr><td><b>Hits This Year:</b></td><td>".$year."</td></tr>\n";
echo "</table>\n";
?>
</body>
</html>