<?php
$host='localhost';
$dbuser='root';
$dbpass='';
$database='SLOMP';
$db=mysql_connect($host, $dbuser, "$dbpass");
mysql_select_db($database,$db);
$time=time()+180;
$sql="select * from online where ip='".$_SERVER['REMOTE_ADDR']."'";
$res=mysql_query($sql);
$stats=mysql_num_rows($res);
if($stats=="0")
{
mysql_query("INSERT Into online (naam,ip,waar,tijd) VALUES ('$naam','".$_SERVER['REMOTE_ADDR']."','".mysql_real_escape_string($_SERVER['REQUEST_URI'])."','$time')");
}
else
{
mysql_query("UPDATE online SET waar='".mysql_real_escape_string($_SERVER['REQUEST_URI'])."',tijd='$time' WHERE ip = '".$_SERVER['REMOTE_ADDR']."'");
}
$sql="select * from online";
$res=mysql_query($sql);
$online=mysql_num_rows($res);
$now=time();
mysql_query("DELETE FROM online WHERE tijd < $now");
echo "Online: ".$online."<BR>";
?>