Salve,
ho uno script che segna quante persone sono on line su un sito in un preciso momento
questo è il sorgente:
1. parte: inserimento dell' utente
[CODE]<?php
include("dbinfo.php");
global $HTTP_SERVER_VARS;
define("SESSION_LENGTH", 20);
$userIP = $HTTP_SERVER_VARS["REMOTE_ADDR"];
$sConn = @mysql_connect($dbServer, $dbUser, $dbPass)
or die("Couldnt connect to database");
$dbConn = @mysql_select_db($dbName, $sConn)
or die("Couldnt select database $dbName");
$timeMax = time() - (60 * SESSION_LENGTH);
$result = mysql_query("select count(*) from usersOnline where unix_timestamp(dateAdded) >= '$timeMax' and userIP = '$userIP'");
$recordExists = mysql_result($result, 0, 0) > 0 ? true : false;
if(!$recordExists)
{
@mysql_query("insert into usersOnline(userIP) values('$userIP')");
}
?>
<?php
define("SESSION_LENGTH", 20);
$sConn = @mysql_connect($dbServer, $dbUser, $dbPass)
or die("Couldnt connect to database");
$dbConn = @mysql_select_db($dbName, $sConn)
or die("Couldnt select database $dbName");
$timeMax = time() - (60 * SESSION_LENGTH);
$result = mysql_query("select count(*) from usersOnline where unix_timestamp(dateAdded) >= '$timeMax' and userIP = '$userIP'");
$recordExists = mysql_result($result, 0, 0) > 0 ? true : false;
if(!$recordExists)
{
@mysql_query("insert into usersOnline(userIP) values('$userIP')");
}
?>