(' . $row['total']. ' Registered, '. $visitors. ' Visitors)
'; } $sql = "SELECT count( * ) AS total FROM `usrlist`"; $result = mysql_query ($sql) or die( mysql_error() ); while ($row = mysql_fetch_assoc ( $result )) { $total = $row['total']; echo 'Total unique visits: ' . $total; } } function check_online_no_return ($timeout) { $ip = $_SERVER["REMOTE_ADDR"]; $sql = "SELECT * FROM `usersonline` WHERE ip='". $ip. "'"; $result = mysql_query ($sql) or die( mysql_error() ); while ($row = mysql_fetch_assoc ( $result )) { $id = $row['id']; } $sql = "SELECT count( * ) AS number FROM `usersonline` WHERE ip='". $ip. "'"; $result = mysql_query ($sql) or die( mysql_error() ); while ($row = mysql_fetch_assoc ( $result )) { $number = $row['number']; } if ($number == 0) { if ( !isset ( $_SESSION['username'] ) ) { $sql = "INSERT INTO `usersonline` (`ip`, `time`, `username`) VALUES ('". $ip. "', '". time(). "', 'Anonymous')"; } else { $sql = "INSERT INTO `usersonline` (`ip`, `time`, `username`) VALUES ('". $ip. "', '". time(). "', '". $_SESSION['username']. "')"; } $result = mysql_query ($sql) or die( mysql_error() ); $sql = "SELECT count( * ) AS number FROM `usrlist` WHERE ip='". $ip. "'"; $result = mysql_query ($sql) or die( mysql_error() ); while ($row = mysql_fetch_assoc ( $result )) { $num2 = $row['number']; } if ($num2 == 0) { if ( !isset ( $_SESSION['username'] ) ) { $sql = "INSERT INTO `usrlist` (`ip`, `time`, `username`) VALUES ('". $ip. "', '". time(). "', 'Anonymous')"; } else { $sql = "INSERT INTO `usrlist` (`ip`, `time`, `username`) VALUES ('". $ip. "', '". time(). "', '". $_SESSION['username']. "')"; } $result = mysql_query ($sql) or die( mysql_error() ); } else { if ( !isset ( $_SESSION['username'] ) ) { $sql = "UPDATE `usrlist` SET `time`= '". time(). "', `username`='Anonymous' WHERE ip='". $ip. "'"; } else { $sql = "UPDATE `usrlist` SET `time`= '". time(). "', `username`='". $_SESSION['username']. "' WHERE ip='". $ip. "'"; } $result = mysql_query ($sql) or die( mysql_error() ); } } else { if ( !isset ( $_SESSION['username'] ) ) { $sql = "UPDATE `usersonline` SET `time`= '". time(). "', `username`='Anonymous' WHERE id='". $id. "'"; } else { $sql = "UPDATE `usersonline` SET `time`= '". time(). "', `username`='". $_SESSION['username']. "' WHERE id='". $id. "'"; } $result = mysql_query ($sql) or die( mysql_error() ); if ( !isset ( $_SESSION['username'] ) ) { $sql = "UPDATE `usrlist` SET `time`= '". time(). "', `username`='Anonymous' WHERE ip='". $ip. "'"; } else { $sql = "UPDATE `usrlist` SET `time`= '". time(). "', `username`='". $_SESSION['username']. "' WHERE ip='". $ip. "'"; } $result = mysql_query ($sql) or die( mysql_error() ); } $time = time(); $expire = $time - $timeout; $sql = "SELECT * FROM `usersonline`"; $result = mysql_query ($sql) or die( mysql_error() ); while ($row = mysql_fetch_assoc ( $result )) { if ( $row['time'] < $expire ) { $sql = "DELETE FROM `usersonline` WHERE `id`=". $row['id']; mysql_query ($sql) or die( mysql_error() ); } } } ?>