Who's Online php Block

[brundlefly]

Just a block for php-nuke that shows what members are in your php x7Chat.  It lists the names of all people in the chat system. I didn't see one on here, thought since I worked one out I'd provide for others.   Enjoy

Code:

<?php

if (eregi("block-Chat.php", $_SERVER['PHP_SELF'])) {
    Header("Location: index.php");
    die();
}
global $prefix, $db, $sitename;
$exptime = time()-5;
$result = $db->sql_query("SELECT name FROM x7chat2_online WHERE invisible<>'1' AND time>'$exptime' ORDER BY time DESC LIMIT 10");
$content = "<center><b>User(s) Online</b></center><br>";
while ($row = $db->sql_fetchrow($result)) {

    $name = $row['name'];
{
        $content .= "<center>$name<br></center>";
    }
}
$content .= "<center><a href=\"Enter the link you want here\"><br><b><u>Join Chat</u></b></a></center>";
?>

[Mana]

Eh...which directory should we upload this file in?

[Peter Koster]

you don't upload the file, just copy and paste the code to any place on any page you wish the thing to appear.

[Slacker]

Thanks for the block and I have tried it a couple of days. It seems to be a small glitch because some members are shown several times as being online like this:

alex
alex
alex
alex
alex
christie
bob

Is there a fix for this?

[Slacker]

I think I have found a solution by using SELECT DISTINCT, which removes names in more instances, so that only one copy of each name is shown:

$result = $db->sql_query("SELECT name FROM x7chat2_online WHERE invisible<>'1' AND time>'$exptime' ORDER BY time DESC LIMIT 10");

change to:

$result = $db->sql_query("SELECT DISTINCT name FROM x7chat2_online WHERE invisible<>'1' AND time>'$exptime' ORDER BY time DESC LIMIT 10");