Hi. Question???

[Anon]

Using the user online code (I will post below) is there anyway to insert a username (from a login page I already have set up) and show the names of users online?

<?

#################################################################################################

Project : phpUseronline

File name : useronline.php

Version : 1.10

Last Modified By : Erich Fuchs

e-mail : [e-mail]

Purpose : Main File

Last modified : 20 Apr 2001

Copyright : 2001 by NETonE High Quality Networking (http://www.netone.at)

#################################################################################################

Configuration

#################################################################################################

$server = "localhost"; // Your mySQL Server, most cases "localhost"

$db_user = "impact"; // Your mySQL Username

$db_pass = "pass"; // Your mySQL Password

$database = "phpuser_dooty"; // Database Name

$timeoutseconds = 300; // Timeout value in seconds

End Configuration - DO NOT EDIT BEHIND THIS LINE !!!

#################################################################################################

$timestamp=time();

$timeout=$timestamp-$timeoutseconds;

mysql_connect($server, $db_user, $db_pass) or die ("Useronline Database CONNECT Error");

mysql_db_query($database, "INSERT INTO useronline VALUES ('$timestamp','$REMOTE_ADDR','$PHP_SELF')") or die("Useronline Database INSERT Error");
mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout") or die("Useronline Database DELETE Error");
$result=mysql_db_query($database, "SELECT DISTINCT ip FROM useronline WHERE file='$PHP_SELF'") or die("Useronline Database SELECT Error");
$user =mysql_num_rows($result);

mysql_close();

if ($user==1) {echo"You are the only person here right now.";} else {echo"There are $user people chatting right now.";}
?>

I am a PHP novice so I am not sure how (or EVEN if) I can do this?

Thanks in advance!!! 😉
Amanda

[rulian]

umm... you got the right idea, I know some sites that use the same ideas behind your code. They basically make a user table of people who log on and the time they log in, or last access the site. Then, they simply query that table for the username and time, they then compare the time of the user last access,to a current time stamp, if the interval is let's say, 1 minute, the user is registered as online. So all you would need is a code to check, and a code you would place somewhere, or in your user auth code on your site to update the user last access.

[Anon]

Hi Rulain! Well with the help from another friend on sitepoint I came up with the following:
<?
#################################################################################################

Project : phpUseronline

File name : useronline.php

Version : 1.10

Last Modified By : Erich Fuchs

e-mail : [e-mail]

Purpose : Main File

Last modified : 20 Apr 2001

Copyright : 2001 by NETonE High Quality Networking (<a href="http://www.netone.at" target="blank"><a href="http://www.netone.at" target="blank">http://www.netone.at</a></a> )

#################################################################################################

Configuration

#################################################################################################

$server = "localhost"; // Your mySQL Server, most cases "localhost"
$db_user = ""; // Your mySQL Username
$db_pass = ""; // Your mySQL Password
$database = ""; // Database Name
$userid = $uid;
$timeoutseconds = 300; // Timeout value in seconds

End Configuration - DO NOT EDIT BEHIND THIS LINE !!!

#################################################################################################

$timestamp=time();
$timeout=$timestamp-$timeoutseconds;
mysql_connect($server, $db_user, $db_pass) or die ("Useronline Database CONNECT Error");
mysql_db_query($database, "INSERT INTO useronline (timestamp, userid, ip, file) VALUES ('$timestamp','$userid','$REMOTE_ADDR','$PHP_SELF')") or die("Useronline Database INSERT Error");
mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout") or die("Useronline Database DELETE Error");
$result=mysql_db_query($database, "SELECT DISTINCT ip, userid FROM useronline WHERE userid=userid AND file='$PHP_SELF'") or die("Useronline Database SELECT Error");
$user =mysql_num_rows($result);

if ($user==1)
{
echo "You are the only person here right now.";
}
else
{
echo "There are $user people here right now.<br />\nThe following people are here: ";

while ($row = mysql_fetch_array($result))
{
    $people[] = $row['userid'];
}

echo implode(', ', $people);

}

mysql_close();
?>

And it works to an extent. I had another friend get online and go to my link and I could see her name and mine on the page, but for her it said she was the only one there.

Any ideas?

Amanda

[Anon]

Amanda wrote:

Hi Rulain

Sorry.. I meant Rulian.

oops.
Amanda

[rulian]

looks good, give it a try let me know what happens