Integration with vBulletin - FlashChat - Who is in the chat.

This modification is no longer available or supported.

This is a simple display of who is currently chatting in FlashChat - on the forum homepage display.

The main features of Version 4.xx are basically the same as previous versions ;

1. It displays the list on Forum Home with the "Users online" display.
2. The list view is collapsable, so you see just the number.
3. Users who should display as coloured or bold etc are displayed correctly (based on the display usergroup)
4. If you 'hover' over a username it will show the room they are chatting in and their status (away etc).
5. If the chat is empty, a simple "no one is chatting" message is displayed.
6. The hack is now phrased.
7. The ability to turn it on/off is in the ACP Forum Home Options.
8. The ability to allow only certain usergroups to view the list is an ACP option.
9. The location of the flashchat folder is now an ACP option (vBulletin Options > Forums Home Page Options).

Unzip the XML and import into vB using the ACP Product Manager.

To upgrade from version 4.10 onwards, you need to re-import the product with the overwrite option set to yes. To upgrade from version 4.02 to version 4.10 onwards, you need to uninstall the product and remove the template code in FORUMHOME - then upload the new product. To upgrade from version 3.xx to version 4.xx you need to delete the existing plugin and remove the template code in FORUMHOME - then upload the new product.

* An add-on to display a 'Most ever chatters' count is available here.


Note: This hack cannot display any bots in the chat, due to the strange way that flashchat stores this information. Please also note that I am not Tufat.com or anything to do with the Flashchat product - if you have questions about Flashchat in general, their forums are here.


History:

v4.10 : Removed the need to edit the FORUMHOME template.
v4.11 : Hyperlinked display icon to chat page. Added vb number formatting to count.
v4.12 : Added ALT tag to above hyperlink.
v4.13 : Updated ACP view permission option to take into account secondary groups.
v4.14 : Added 'nofollow' attribute to listed usernames.
v4.15 : Restricted list based on flashchat autologout parameter, to get round the issue of connections not being cleaned up.
v4.16 : Minor changes, no update necessary.
v4.17 : Added members status to hover information.
v4.18 : Re-wrote status code to take account of custom status definitions.

[tamborinegal]

Hi Paul,

I hope you can help me. I've had this add-on installed for months and working perfectly but today my host restarted mysql and now I am getting the error below.

Do you have any idea what could be causing this?

Invalid SQL:

SELECT connections.userid, connections.roomid, rooms.name, rooms.ispublic, connections.state,
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 flashchat_connections as connections
LEFT JOIN flashchat_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 > 0 AND connections.ip != '0.0.0.0' 
AND connections.updated > DATE_SUB(NOW(),INTERVAL 120 SECOND) 
ORDER BY start;

MySQL Error  : Can't open file: 'flashchat_connections.MYI'. (errno: 145)
Error Number : 1016

Thanks,

Clancy

[Paul M]

You need to repair the flashchat_connections table via the maintenance section of the ACP.

[tamborinegal]

Originally Posted by Paul M

You need to repair the flashchat_connections table via the maintenance section of the ACP.

Thanks for the quick response Paul.

I tried what you suggested and got the following errors.

flashchat_connections Check Warning: Table is marked as crashed 
flashchat_connections Check Warning: 2 clients are using or haven't closed the table properly 
flashchat_connections Check Error: Checksum for key: 2 doesn't match checksum for records 
flashchat_connections Check Error: Checksum for key: 4 doesn't match checksum for records 
flashchat_connections Check Error: Corrupt 
flashchat_connections

Should I have re-enabled the plugin first?

Clancy

[tamborinegal]

Ran it through again and now it's working again. I don't know why it all stopped working but it's ok now which is great. My forum members are chatters and they would have missed this.

Thanks for your help Paul.

Clancy

[Paul M]

Originally Posted by tamborinegal

Thanks for the quick response Paul.

I tried what you suggested and got the following errors.

Should I have re-enabled the plugin first?

Clancy

That output is normal - that's the repair telling you what it found wrong. Running it again should come back with OK, indicating the repair worked. The fault was caused by mysql not shutting down properly.

[Mysticales]

Installed, thanks. =)

[barryhand]

Is there anyway to use the variables outside the main forum pages.

I want to call $totalchatters on the navbar.

Anyone got the code needed to be added, can I call the hook on globals.php.

This has been requested many time, surely someone has a fix

PS (Great Mod)

[Paul M]

If you change the hook in the "Members in Flashchat (2)" plugin from forumhome_start to global_start then the variables will be available on any page - note it will add one query to every page.

[barryhand]

Cheers Paul.

It's a really good feature to have that.

You might look into streamlining that function

[Paul M]

Most people do not need it.