function showVisitors()
{
$rowsPerPage = 20;
$pageNum = 1;
$rowcolor = false;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$query = " SELECT * FROM visitors " .
" LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');
echo '
';
while($row = mysql_fetch_array($result))
{
$rowcolor = !$rowcolor;
echo $rowcolor;
if($rowcolor)
{
echo '| '.$row['username'] .' | '.$row['date'] .' | '.$row['time']. ' |
';
}
else {
echo '| '.$row['username'] .' | '.$row['date'] .' | '.$row['time']. ' |
';
}
}
echo '
';
}
//Controleer of request van SL-server komt, en of parameters ingevuld zijn
function addVisitor($username,$date,$time)
{
if($username != null && $date !=null && $time !=null)
{
$addr = gethostbyaddr($_SERVER['REMOTE_ADDR']);
//if (substr($addr,-14,14) != ".lindenlab.com") die("Invalid request");
//if ($_SERVER['HTTP_X_SECONDLIFE_SHARD'] == "Testing") die("Preview grid not allowed");
if(!get_magic_quotes_gpc()) $username = addslashes($username);
$query = "INSERT INTO visitors VALUES ('','$username', '$date','$time')";
$result = mysql_query($query) or die('Error, query failed');
}
}
?>