Whos in the chat room not working independent on my whosonline in chat updates again. I have it listed like previously in this thread.
Would this have changed in 6.4
[] // ----------------------------
// Let's see if there are any people in the chat room - by JoshPet
$LastOnChat = $this -> get_date() - 600;
$query = "
SELECT COUNT(*)
FROM {$config['tbprefix']}Online
WHERE O_Last > '$LastOnChat'
AND (O_What = 'chatheader' OR O_What = 'chatroom' OR O_What = 'chat')
";
$sth = $dbh -> do_query($query);
list($chatcount) = $dbh -> fetch_array($sth);
if ($chatcount == "1") {
$chatoutput = "<tr><td class="lighttable" colspan="2" align="center"><b>There is currently $chatcount user in the <a href="{$config['phpurl']}/chat.php" target="_top">Chat Room</a>. Join them!</td></tr>";
}
else if ($chatcount > "1") {
$chatoutput = "<tr><td class="lighttable" colspan="2" align="center"><b>There are currently $chatcount users in the <a href="{$config['phpurl']}/chat.php" target="_top">Chat Room</a>. Join them!</td></tr>";
}
else {
$chatoutput = "";
}
[/]
My most frequent complaint..