Who viewed this thread?

This is a port of: https://vborg.vbsupport.ru/showthread.php?t=61222
(ported with permission)

Who viewed this thread?
This hack shows who has viewed any thread. View the screenshot to see how it looks.

Details
1 Query
1 New Phrase
1 Template Edit
1 Plugin XML

Screenshots
Available here, though now the box appears below the Current Active Users instead of above the post reply button, and it is not collapsible anymore.

Credits
Gary King, for allowing me to port his hack.

-----------

Instructions

Run query [sql]ALTER TABLE thread ADD whoviewed TEXT NOT NULL;[/sql]

Create new phrase
already_viewed_this_thread / Already viewed this thread:

Edit template
Open SHOWTHREAD and find:

<!-- currently active users -->
<if condition="$show['activeusers']">
	<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
	<tr>
		<td class="tcat" colspan="2">
			<phrase 1="$totalonline" 2="$numberregistered" 3="$numberguest">$vbphrase[users_viewing_this_thread_x_y_z]</phrase>
		</td>
	</tr>
	<tr>
		<td class="alt1" colspan="2">
			<span class="smallfont">$activeusers</span>
		</td>
	</tr>
	</table>
</if>
<!-- currently active users -->

Below this add:

<!-- who viewed this thread -->
	<br />
	<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
	<tr>
		<td class="tcat" colspan="2">
			$vbphrase[already_viewed_this_thread]
		</td>
	</tr>
	<tr>
		<td class="alt1" colspan="2">
			<span class="smallfont">$thread[viewers]</span>
		</td>
	</tr>
	</table>
<!-- who viewed this thread -->

Plugin
Just upload it, and it's all done.

Options
If you want to have invisible users in the list, go to the plugin manager, click edit to edit this plugin then add this to the beginning:

$showinvisible = 1;

[.Tim]

Thanks! Great hack, been waiting for this one a while. Will have a lot of happy users now.
Is there anyway to add the time read to this?

Like it is in this one:

https://vborg.vbsupport.ru/showthread.php?t=61225

[Johannes de Le?n]

Originally Posted by .Tim

Thanks! Great hack, been waiting for this one a while. Will have a lot of happy users now.
Is there anyway to add the time read to this?

Like it is in this one:

https://vborg.vbsupport.ru/showthread.php?t=61225

I'll see what I can do.

[Chris M]

While this is a nice idea, I have to worry about the performance issues associated with this on a large board - Potentially every user could have viewed it, and with a large board which is active the likelyhood of causing performance issues is greatly increased :ermm:

Satan

[Loki12]

Excellent Johannes! I will install when I get home tonight ...

[welo]

Originally Posted by hellsatan

While this is a nice idea, I have to worry about the performance issues associated with this on a large board - Potentially every user could have viewed it, and with a large board which is active the likelyhood of causing performance issues is greatly increased

This will create a performance hit if you allow everyone access to it (especially guests). However, you can restrict the usergroups who can see the "who viewed" box (thus eliminating uneccessary queries) by wrapping all the injected template code in an <if> statement:

<if condition="in_array($bbuserinfo['usergroupid'], array( 5, 6, 7))">
<!-- who viewed this thread code-->
</if>

...will restrict viewing only to admins and mods. Add other usergroups at your discretion.

Installed, and thanks. :up:

[Marco van Herwaarden]

Originally Posted by welo

This will create a performance hit if you allow everyone access to it (especially guests). However, you can restrict the usergroups who can see the "who viewed" box (thus eliminating uneccessary queries) by wrapping all the injected template code in an <if> statement:

Putting a condition in the template will not stop queries from being executed. Limiting guests, will not have any influence on performance.

[welo]

Okay, replies like that, especially from a moderator, just irk the hell out of me. If you're going to slap down my solution you'd better have one handy that works, or at least tell me why mine won't. If a template condition doesn't render then no query is executed. If you prove me wrong I'll gladly apologize.

[Marco van Herwaarden]

Simple, this is in general how things work (and don't see it as slapping down, just don't always have the time to give a more extended asnwer):
- PHP Script is run
- Logic of the script is followed
- Script will retrieve all needed information from the database and place the information in variables.
- Once all info is available, the script will evaluate a template, in which the variables get replaced by their values.

As you see a condition placed in a template, only effect what is displayed, not what is retrieved from the database.

I can't give you an alternative solution, because i never even looked into this hack. But if you want to improve performance by excluding guests, you will have to edit the PHP-script to make that it will not query the database if a guest is viewing.

[Wordplay]

just showing my appriciation for the hack, installed! thank you for making it.