Identify logged users
Moderator: General Moderators
-
rodrigocaldeira
- Forum Commoner
- Posts: 27
- Joined: Wed Mar 05, 2003 6:40 pm
- Location: Brazil
- Contact:
Identify logged users
Hi everyone!
I made a system and this system must to show all actualy logged users. I'm using sessions and MySQL. How can I do this??
Thanks!!
I made a system and this system must to show all actualy logged users. I'm using sessions and MySQL. How can I do this??
Thanks!!
-
rodrigocaldeira
- Forum Commoner
- Posts: 27
- Joined: Wed Mar 05, 2003 6:40 pm
- Location: Brazil
- Contact:
-
rodrigocaldeira
- Forum Commoner
- Posts: 27
- Joined: Wed Mar 05, 2003 6:40 pm
- Location: Brazil
- Contact:
-
rodrigocaldeira
- Forum Commoner
- Posts: 27
- Joined: Wed Mar 05, 2003 6:40 pm
- Location: Brazil
- Contact:
Heres the basics of a usersonline script. You'll need to modify it to take care of who ACTUALLY is online. This just says how many usrers are online:
Code: Select all
//===============================================//
$sql_dbName = "usersonline";
$db_con = mysql_connect("localhost")
OR die ("DB CONNECT Error");
if (! $db_select = mysql_select_db($sql_dbName)) {
mysql_create_db($sql_dbName)
OR die ("DB CREATE Error");
$db_select = mysql_select_db($sql_dbName)
OR die("DB CONNECT Error");
mysql_query("create table useronline(timestamp int, ip varchar(16))")
OR die("Unable to create table");
}
//===============================================//
$timeoutseconds = 200; //# Timeout value in seconds
$timestamp = time();
$timeout = ($timestamp-$timeoutseconds);
$ip = $_SERVER['REMOTE_ADDR'];
mysql_query("INSERT INTO useronline VALUES('$timestamp', '$ip')")
OR die("DB INSERT Error");
mysql_query("DELETE FROM useronline WHERE timestamp<$timeout")
OR die("DB DELETE Error");
$result = mysql_query("SELECT DISTINCT ip FROM useronline")
OR die("DB SELECT Error");
$users = mysql_num_rows($result);
mysql_close();
if ($users==1) { echo "$users User online"; }
else { echo "$users Users online"; }-
rodrigocaldeira
- Forum Commoner
- Posts: 27
- Joined: Wed Mar 05, 2003 6:40 pm
- Location: Brazil
- Contact:
-
rodrigocaldeira
- Forum Commoner
- Posts: 27
- Joined: Wed Mar 05, 2003 6:40 pm
- Location: Brazil
- Contact: