Flashchat: Who is chatting

This modification is no longer available or supported.

This is a simple ForumHome display of who is currently using your Flashchat.

Version 2.20 is for use with Flashchat 4.1.x - however, it may work with older versions of Flashchat if set-up correctly.

The main features of Version 2.xx are ;

1. It displays the list on Forum Home with the "Users online" display.

2. The list view is collapsable, so you just see the number.

3. Users who should display as coloured or bold etc should be displayed correctly. (based on the display usergroup)

4. If you 'hover' over a username it will show the room they are chatting in.

5. If the chat is empty, a simple "no one is chatting" message is displayed.


Note: This will not display the names of any bots in the chat, due to the strange way that flashchat stores this information.


With help from Cyricx a CPMS module is located in this post. (Version 2.20 only, unsupported - use at your own risk).

[Paul M]

Originally Posted by Romeos Tune

Hey Paul,

I'm running VB3.03 and the latest FlashChat.... For some reason I'm getting this error. It's adding an extra vb3_ it seems when doing the queries.... I'm still too new to figure this out I guess..... Any help would be appreciated.....

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic, connections.start,
user.usergroupid, user.displaygroupid, user.options, user.username, groupa.opentag as opentaga, groupa.closetag as closetaga,
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM vb3_vb3__fc_connections as connections
LEFT JOIN vb3_vb3__fc_rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN vb3_user as user ON(connections.userid = user.userid)
LEFT JOIN vb3_usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN vb3_usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start
mysql error: Table 'vb.vb3_vb3__fc_connections' doesn't exist

mysql error number: 1146

Which versions of flashchat, and this hack are you using ?

The 'vb3_' is your vB table prefix, because it assumes the flashchat tables were also created with this prefix. On top of this there is also a flashchat prefix which was added in 4.0.x which has complicated matters. Does your chat actually work ? What are you flashchat tables actually called ? What prefix (pref) is defined in your flashchat config.srv.php ?

[esology]

Originally Posted by Paul M

Which versions of flashchat, and this hack are you using ?

FlashChat 4.0.6
Whos chatting Hack 2.16

Originally Posted by Paul M

The 'vb3_' is your vB table prefix, because it assumes the flashchat tables were also created with this prefix. On top of this there is also a flashchat prefix which was added in 4.0.x which has complicated matters. Does your chat actually work ?

Yes, chat works fine

Originally Posted by Paul M

What are you flashchat tables actually called ? What prefix (pref) is defined in your flashchat config.srv.php ?

vb3_fc

[Paul M]

Okay, looks like flashchat 4.0.x now ignores the vB prefix (except at install ?) and just uses it's own internal one.

Try replacing the code in index.php with this 2.17 version and let me know how it goes.

PHP Code:

// ## Paul M - Flashchat - Who is in the chat v2.17 ## //

$fcfolder = 'chat';
// ## Make sure the folder name defined above is the correct name of your flashchat installation folder ## //

$GLOBALS['fc_config_stop'] = true;
require_once("./" . $fcfolder . "/inc/common.php"); 
$fcprefix = $GLOBALS['fc_config']['db']['pref'];
$chatlist = $DB_site->query("SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic, connections.start, 
user.usergroupid, user.displaygroupid, user.options, user.username, groupa.opentag as opentaga, groupa.closetag as closetaga, 
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM " . $fcprefix . "connections as connections
LEFT JOIN " . $fcprefix . "rooms as rooms ON(connections.roomid = rooms.id)
LEFT JOIN " . TABLE_PREFIX . "user as user ON(connections.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE connections.userid IS NOT NULL ORDER BY start" );
unset($chatters);
$totalchatters = 0;
while ($chat = $DB_site->fetch_array($chatlist))
{
    $totalchatters += 1;
    $roomname = "In private room";
    $chat['opentag'] = $chat['opentaga'] ;
    $chat['closetag'] = $chat['closetaga'] ;
    if ($chat['displaygroupid']) 
    {
        $chat['opentag'] = $chat['opentagb'] ;
        $chat['closetag'] = $chat['closetagb'] ;
    }
    if ($chat['ispublic']) { $roomname = "In ".$chat['name']; }
    $chatters .= "<a href='member.php?u=$chat[userid]' title=\"$roomname\" >";
    $chatters .= $chat['opentag'].$chat['username'].$chat['closetag']."</a>, ";
}
if ($chatters)
{
    $chatters = substr($chatters, 0, strlen($chatters)-2);
}
else
{
    $chatters = "No one is currently using the chat";
}

// ############# End of Who is in the chat ############### 


If this cures it then I will update the first post.

[esology]

Thanks Paul! Works like a charm.

[Paul M]

Originally Posted by esology

Thanks Paul! Works like a charm.

Good. I have updated the install file. I hope they don't change this behaviour again ......

[Romeos Tune]

Thanks Paul! That fixed my problem too.... Awesome!

[dfaonxa]

Just wanted to say thanks for the mod, works perfectly and so easy to install! Thanks! :up:

[plateau]

good job!

install clicked!!!

[Cyricx]

Running vb 3.0.7 and flash chat 4.0.6

Works great!!

No errors at all, only bug I noticed is that it counts bots as being in the room(bad), but doesn't list them in the Who's In Chat(good).

We have 1 bot in our chat so unfortunately it never thinks noone is in chat thought it will have a blank area where the names list heh.

[Cyricx]

the inthechat.php is missing the code to grab the template..

Find

?>

And Add ABOVE it:

eval('$home[$onlineid][\'content\'] = "' . fetch_template('adv_portal_ts') . '";');

Has the same problem as the forumhome section in counting bots though.