Tweet
sessions: user online?
Moderator
<?php
include("../inc/db_data.inc.php");
// Schreiben des Eintrags in eine Tabelle...
$logtab = "userlog";
$time = explode( " ", microtime());
$userusec = (double)$time[0];
$usersec = (double)$time[1];
$User_Id = $usersec + $userusec;
$IP = getenv(REMOTE_ADDR);
$HOST = gethostbyaddr($REMOTE_ADDR);
$userlog = "";
$deleteuser = mysql_query("DELETE FROM $logtab WHERE DATE < $usersec -800");
$userlog = mysql_fetch_row(MYSQL_QUERY("SELECT * FROM $logtab WHERE IP LIKE '$IP'"));
if ($userlog == false) {
$ok = mysql_query("INSERT INTO $logtab (ID,IP,NAME,DATE)
VALUES('$User_Id','$IP','$HOST','$usersec')");
}
$resultlogtab = mysql_query("SELECT COUNT(*) AS total FROM $logtab");
$numberlogtab = mysql_fetch_array($resultlogtab);
// Hier wird die Anzahl der User ausgegeben...
print "<html><head>\n";
print "<meta http-equiv='refresh' content='60'>";
print "<meta http-equiv='Pragma' content='no_cache'>";
print "<body>";
if ($numberlogtab[total] != ""){
print "<p align='right'><font face=\"Comic Sans MS\" size=\"-2\">
<BR>$numberlogtab[total] User online</font></p>";
print "</body>";
print "</html>";
}
?>
CREATE TABLE userlog ( ID int(4) NOT NULL default '0', IP varchar(255) NOT NULL default '0', NAME varchar(255) NOT NULL default '0', DATE varchar(255) NOT NULL default '0' ) TYPE=MyISAM;
Kommentar