Show Thread Enhancements - Who viewed this thread?

There is an enhanced version of this mod found here.

Who viewed this thread?
Version: 1.0
vB-version: 3.0.0 Release Candidate 3
Developer: Gary W
Install difficulty: Extremely Easy
File edits: 1
Template edits: 1

Description of the Hack:
This hack shows who has viewed any thread. View the screenshot to see how it looks.

If you don't want to have invisible users in the list, then remove $showinvisible = 1;

View the screenshot to see the hack in action

Instructions

FILES
------
showthread.php

TEMPLATES
-------------
SHOWTHREAD

RUN QUERY: ALTER TABLE thread ADD whoviewed TEXT NOT NULL;

ADD PHRASE:
already_viewed_this_thread / Already viewed this thread:


OPEN FILE showthread.php AND FIND

PHP Code:

// *********************************************************************************
//set thread last view
set_bbarray_cookie('thread_lastview', $threadid, TIMENOW); 


ABOVE ADD

PHP Code:

$showinvisible = 1;

// Get who has already viewed this thread
$currentthread = $DB_site->query_first("SELECT whoviewed FROM ".TABLE_PREFIX."thread WHERE threadid = $threadid");
$vieweduserids = explode(" ", $currentthread['whoviewed']);

$userinfo = fetch_userinfo($bbuserinfo['userid']);

if (!$userinfo['invisible'] OR $showinvisible)
{
    if (!empty($currentthread['whoviewed']))
    {
        if (!in_array($bbuserinfo['userid'], $vieweduserids))
        {
            $DB_site->query("UPDATE ".TABLE_PREFIX."thread SET whoviewed = CONCAT(whoviewed, \" \", \"" .$bbuserinfo['userid'] . "\") WHERE threadid = $threadid");
        }
    }
    else
    {
        $DB_site->query("UPDATE ".TABLE_PREFIX."thread SET whoviewed = \"" . $bbuserinfo['userid'] . "\" WHERE threadid = $threadid");
    }
}

// Who has viewed this thread?
if (empty($currentthread['whoviewed']))
{
    $thread['viewers'] = '('.strtolower($vbphrase['none']).')';
}
else
{
    $result = $DB_site->query("SELECT userid, username FROM ".TABLE_PREFIX."user WHERE userid IN (" . implode(", ", $vieweduserids) . ")");
    $viewers = array();
    while ($user = $DB_site->fetch_array($result))
    {
            array_push($viewers, "<a target=\"_blank\" href=\"member.php?".$session['sessionurl'] . "u=".$user['userid'] . "\">" . htmlspecialchars($user['username']) .    "</a>");
    }
    $thread['viewers'] = implode(", ", $viewers);
} 


OPEN SHOWTHREAD TEMPLATE AND FIND

$poll

ABOVE ADD

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center"><tbody>
<tr>
<td class="thead">
<a style="float:$stylevar[right]" href="#top" onClick="return toggle_collapse('forumhome_todayactiveusers')"><img id="collapseimg_forumhome_todayactiveusers" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_todayactiveusers].gif" alt="" border="0" /></a>
$vbphrase[already_viewed_this_thread]
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_todayactiveusers" style="$vbcollapse[collapseobj_forumhome_todayactiveusers]">
<tr>
<td class="alt1"><div class="smallfont">
$thread[viewers]
        </div></td>
</tr>
</tbody>
</table>
<br />

INSTALLATION COMPLETE!

[VitroX]

Originally Posted by VitroX

This is a wonderfull hack, thanks for making.

I wonder if it is possible to show the members with color depending of the usergroup where they belongs, per example Admins in red, Mods in blue, etc.

Thanks again.

This feature is not possible?

[Nj?rd Eriksson]

Great hack, Gary. Thank you.

[Gary King]

Originally Posted by pcalloway

My table heading is showing as blank rather then stating:

"Already viewed this thread:"

In the phrase manager I used "already_viewed_this_thread" as the Var name and "Already viewed this thread:" as the text. Did I goof something up?

Did you modify the showthread template?

[pcalloway]

Originally Posted by Gary W

Did you modify the showthread template?

Yeah, right above $poll... sure did.

[Gary King]

Go to View Source and check to see if you can find:

collapseobj_forumhome_todayactiveusers

in it.

[Ocean]

Hi, Gary! Quick question...

For this hack, you say to put the code ABOVE this text:

 
// ********************************************************************************  * 
//set thread last view

By doing this, we are inserting your PHP code at the end of the "Update Views Counter" Section. However, in vB 3.0.1 - this section is no longer in the same place.

In vB 3.0.1, directly above the "Set Thread Last View" section, is a comment listed: "END LINEAR / THREADED"


So, the question is:

Should we still be inserting the code above the "Set Thread Last View" section? Or should we be putting at the END of the "Update Views Counter" Section?

[Gary King]

The lower the better, before the output of the postbit anyways.

So I say, put it lower if you can't put it exactly where it's supposed to be

[Ocean]

Originally Posted by Gary W

The lower the better, before the output of the postbit anyways.

So I say, put it lower if you can't put it exactly where it's supposed to be

Aha! So, in other words - your original instructions stand.

Thanks, Gary.

[knetgummi]

thats a reaaly good one
thank u very much
greetz
knetgummi

[JagFan]

I installed! Works great...thanks!!