Miscellaneous Hacks - WOL - Threads

This add-on will show you what threads users are looking at in a specific forum rather than every user on your site when you visit the 'Who's Online' page.
Once install go to a forum, scroll down and if enabled via the vBulletin Options will be text that reads "Currently Active Users". Click on the text I have quoted on your forum to take you to the "Who's Online" list.


How to Install
Download the product XML. Go into to your ACP --> Plugins & Products --> Manage Products click "[Add/Import Product]". Browse to the product you have just downloaded and click "Import".


Template Edits
Open: FORUMDISPLAY
Find:

PHP Code:

$vbphrase[currently_active_users] 


Replace With

PHP Code:

<a href="online.php?f=$foruminfo[forumid]">$vbphrase[currently_active_users]</a> 


Open: WHOSONLINE
Find:

PHP Code:

window.location="online.php?$session[sessionurl_js]order=$sortorder&sort=$sortfield&pp=$perpage&page=$pagenumber$refreshargs_js"; 


Replace With:

PHP Code:

window.location="online.php?$session[sessionurl_js]order=$sortorder&sort=$sortfield&pp=$perpage&page=$pagenumber$refreshargs_js&$forumid"; 


Updates
1.0.0 - First Release
1.0.1 - optimized query, fixed reloading, fixed reload link.

[harmor19]

I'm sorry if you do not understand how this mod works. I only work on a development forum and cannot link you to it so you can see how it works.

If someone could be kind enough to supply a demo I would appreciate it.

[thincom2000]

Don't use ' around the number (it implies a string). This could result in a slow query because MySQL has to do a type conversion on the inforum column (SMALLINT to VARCHAR). If this weren't a full table scan already (which it is), the conversion would cause one, so make it a little easier on the server.

Also recommend having the product add inforum as a session table index to avoid the full scan.

[harmor19]

Originally Posted by thincom2000

Don't use ' around the number (it implies a string). This could result in a slow query because MySQL has to do a type conversion on the inforum column (SMALLINT to VARCHAR). If this weren't a full table scan already (which it is), the conversion would cause one, so make it a little easier on the server.

Also recommend having the product add inforum as a session table index to avoid the full scan.

Like this?

PHP Code:

$currentforumid = $vbulletin->input->clean_gpc('r', 'f', TYPE_UINT);
$hook_query_fields = 'session.inforum';

$hook_query_where = empty($currentforumid) ? "" : "AND session.inforum = $currentforumid"; 


[Stoebi]

PHP Code:

$vbulletin->input->clean_gpc('p', 'f', TYPE_UINT);

$hook_query_fields .= ", session.inforum";
$hook_query_where .= empty($vbulletin->GPC['f']) ? '' : " AND session.inforum = " . $vbulletin->GPC['f']; 


But IMHO the plugin is not needed. I see no difference with and without this plugin.

[harmor19]

Originally Posted by Stoebi

But IMHO the plugin is not needed. I see no difference with and without this plugin.

Go into a forum and scroll to the bottom. Click on "Currently Active Users".

[Stoebi]

Yes, same result with and without plugin. IMHO the template-edit is enough

Thanks *installed*

[harmor19]

Updated the add-on.

[Feanor_87]

Great, thanks!

[mgurain]

Any screen shots ?