Script for who is online at my site

[ghgarcia]

I'm looking for a script to determine who is currently accessing my site. Any help would be greatly appreciated.

Thanks
George

[The Little Guy]

just the number of users currently on?

Like this: http://d-top.org (top left)

[ghgarcia]

Yes that would work.

Thanks

[Bushido718]

Well, you'll need a database named 'online' with 2 rows (fields 'ip' (TEXT), and 'timestamp' (INT)).


Note this may not be the best way to do this but this is how i would do it.
[code]
<?php
//connect to you database
mysql_connect("localhost", "user", "pass");
mysql_select_db("your_db");

//get the users ip
$user_ip = $_SERVER['REMOTE_ADDR'];
//get the current time
$time = time();

//add 300 seconds (5 mins) to the time variable
$stamp = $time + 300;

//query for previous entries frm this user
$query = mysql_query("SELECT * FROM 'online' WHERE 'timestamp' > '$time' AND 'ip' = '$user_ip'");
if(!mysql_num_rows($query))
{
//if no entries are found, add one
mysql_query("INSERT INTO 'online' ('ip', 'timestamp') VALUES('$user_ip', '$stamp')");
}
else
{
//if one is found update the time stamp
mysql_query("UPDATE 'online' SET 'timestamp' = '$stamp' WHERE 'ip' = '$user_ip'");
}
//delete idle entries
mysql_query("DELETE FROM 'online' WHERE 'timestamp' < '$time'");

//pull out all entries
$query = mysql_query("SELECT * FROM 'online'");

//get the number of entres
$num_users = mysql_num_rows($query);

//display it
echo $num_users;
?>
[/code]

that should work, will be accurate within 5 mins.

[ghgarcia]

Thanks that did the trick. I changed it a little to fit my site but it works great.

Thanks again,
George