/***************************************************** **************HTTP://SOFTWARE.REDSHIFT.JE************* ********************FREE SOFTWARE********************* *****************************************************/ //Configure your database settings here: $server = "localhost"; $db_user = "manpaper_db3"; $db_pass = "blahblah"; $database = "manpaper_db3"; $table = "OnlineCounter"; $timeoutseconds = 300; //Recommended setting //Connect mysql_connect($server, $db_user, $db_pass); //Fetch Time $timestamp = time(); $timeout = $timestamp - $timeoutseconds; $remoteADDR = mysql_real_escape_string($_SERVER['REMOTE_ADDR']); $remoteHOST = mysql_real_escape_string($_SERVER['REMOTE_HOST']); $httpReferer = mysql_real_escape_string($_SERVER['HTTP_REFERER']); $phpSelf = mysql_real_escape_string($_SERVER['PHP_SELF']); $reqeustURI = mysql_real_escape_string($_SERVER['REQUEST_URI']); $userAgent = mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']); //Insert User $insert = mysql_db_query($database, "INSERT INTO $table (`timestamp`, `RemoteADDR`, `RemoteHOST`, `HttpReferer`, `PhpSelf`, `ReqeustURI`, `UserAgent` ) VALUES ('$timestamp', '$remoteADDR', '$remoteHOST', '$httpReferer', '$phpSelf ', '$reqeustURI', '$userAgent')") or die("Failed!"); //Delete User //$delete = mysql_db_query($database, "DELETE FROM $table WHERE timestamp<$timeout") or die("Failed!"); ?>