Who's in chat on forumhome.. (No eggdrop)

I don't know if any of you will find this useful but its something that I've wanted for a while. For me, the problem with all of the other "who's in chat" hacks is that most of them require something crazy to work (I have no idea what an eggdrop is). Anyway, this one is php/mysql based and should be easy to install.

Description: This will add a new section to your "What's going on?" block which will display a list of users who are currently chatting or viewing the included chat.php page (see screenshot). The list of current chatters is updated every 60 seconds by an auto-refreshing (hidden) iframe in the chat page.

This hack should work with any embedded (web based) IRC chat.

Installation overview:
*Files to edit: (1) -index.php
*Files to upload: (2) -chat.php & icon_chat.gif
*Templates to edit: (1) -FORUMHOME
*Templates to add: (3) -chat_main, chat_chatters, & chat_chatbit
*Queries to run: (1) Adds the chatters table.

After that you simply add the html code to embed your chat applet in the chat_chatbit template. You can then view your chatroom by going to yoursite.com/forums/chat.php.

Note: The list of chatters is updated every 60 seconds, so usernames will still be listed in the "who's in chat" box for up to a minute after they leave the chat page.

Credits: The idea for refreshing the iframe to update the chattime came from John's "extend session" feature in his V3Arcade hack. So thanks John.

[Fender963]

I have uploaded my index.php file.

here is the code I added:

// Who's in chat
$chatdatecut = TIMENOW - 65;
$inchat=$DB_site->query("SELECT *
FROM " . TABLE_PREFIX . "chatters
WHERE chattime > $chatdatecut
ORDER BY username ASC");

if ($DB_site->num_rows($inchat)==0) {
$nobody = "No users are chatting.";
}

while ($chatting=$DB_site->fetch_array($inchat)) {

$chatusername = $chatting[username];
$chatuserid = $chatting[userid];

eval('$chatters .= ", ' . fetch_template('chat_chatters') . '";');
}
$chatters = substr($chatters , 2);

Just as the instructions said. I made no changes. Thank you for the help...

Kyle

EDIT: File removed by Boofo. vBulletin files cannot be posted here. Sorry.

[Fender963]

Dont worry about it EvilLS1, I figured it out. I'm an idiot. Thank you for the help though!

Kyle

[EvilLS1]

Ok, glad ya got it sorted out.

[moonclamp]

I've just added this and it works well ... except if a member has elected to be hidden he/she is still showing as online in the chatroom.

Amy ideas?

[EvilLS1]

Originally Posted by moonclamp

I've just added this and it works well ... except if a member has elected to be hidden he/she is still showing as online in the chatroom.

Amy ideas?

Yeah thats not a bug. I just didn't bother adding it because the hidden users will be listed in the chat's userlist anyway, so why hide them on forumhome? I didn't think it was necessary.

[moonclamp]

My hidden users aren't worried about other members seeing them online.

They are more worried about showing online to non-members who have no access to chat.

Is this easy to change?

... thanks

[EvilLS1]

Moonclamp,
I can give you a quick fix which will make it so that hidden users are never shown in chat (even to those who have permission to see invisible users).

In chat.php find:

 $somestuff = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "chatters WHERE userid=$userid");

	if ($DB_site->num_rows($somestuff)!=0) 
{
	$DB_site->query("UPDATE " . TABLE_PREFIX . "chatters SET chattime = $time WHERE userid = $userid");
} else {
  $DB_site->query("INSERT INTO " . TABLE_PREFIX . "chatters (username,chattime,userid) VALUES ('".addslashes($chatuser)."','$time','".intval($userid)."')");
}

Replace it with:

if ($bbuserinfo[invisible]!=1) {
 $somestuff = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "chatters WHERE userid=$userid");

	if ($DB_site->num_rows($somestuff)!=0) 
{
	$DB_site->query("UPDATE " . TABLE_PREFIX . "chatters SET chattime = $time WHERE userid = $userid");
} else {
  $DB_site->query("INSERT INTO " . TABLE_PREFIX . "chatters (username,chattime,userid) VALUES ('".addslashes($chatuser)."','$time','".intval($userid)."')");
}
}

I didn't test it but it should work.

[moonclamp]

That'll do for me ~ I can always see who is there by going to online.php

Thank you

[moonclamp]

except it didn't work ... and '$somestuff' should have been called '$some****'

[EvilLS1]

I had to use somestuff b/c the other is censored here.

Did you wait 60 seconds for the old session to expire before testing it? Strange.. It should work.