[VB3 RC3] Who viewed this thread?

I know there is already one version of this by Gary W but I already made (and documented) my own so I thought I would post it.

Advantages of my hack:

My hack adds only 1 query to showthread, and it only queries the user table, so it is less server intensive. That is important to any busy board or anyone that wants to save some resources. It integrates with the "thread views" system to update the people that have seen the thread.

Disadvantages:

Well.. with mine even if you browse the forum as "invisible" you would end up showing in the "who read" list.


Info for hackers:
You may modify, improve, upgrade, redistribute this hack, include it
in another hack or yours or translate it provided you do it free of
charge and you distribute it in www.vbulletin.org at least, there is no
need to pm me asking for permission
Some portions of the code are (c) Jelsoft Enterprises Ltd.

[trackpads]

This is a great hack but would be alot better if you could have the information on a separate page. For example, I have a thread that was 100,000 views and honestly have that on the bottom of every page would make it look horrible. but I would like it on other pages for sure so have a link (option per usergroup) would be perfect.

Thanks again,

-Jason

[wi11ie1950]

Originally Posted by wi11ie1950

The mouseover change doesnt work for me no matter how i do it i get:-

Parse error: parse error, unexpected T_INC, expecting T_VARIABLE or '$'
in /home/wi11iec/public_html/forum/showthread.php on line 460

Do the $+++++ go in as well cause they are not in the text file ??

Ok i worked it out.. I guess the +++++ is from VBs censor considering it spells out w h o r e

It all works great now under 3.0.3

[SaN-DeeP]

Originally Posted by SaN-DeeP

Ok i have some serious issues, i wonder if someone else notice about this

My Server is located in US which mite have GMT - 8:00 timings
weras my forum timings and people are of india GMT + 5:30

Currently It is 9:02 AM here.
and i can see this thing when a user last viewed any particular thread
(Yesterday 07:15 PM)

Help me fix this please.

Thank You for nice hack.

Sandy...

any fix for this ?

thanks

[wi11ie1950]

Hi San from what i can see it doesnt use VB country and time settings so if you correct it for India then it will still be wrong for those outside india.
I used the hack to hide the date and time behind the name and show on mouseover

[sv1cec]

Originally Posted by wi11ie1950

Hi San from what i can see it doesnt use VB country and time settings so if you correct it for India then it will still be wrong for those outside india.
I used the hack to hide the date and time behind the name and show on mouseover

I have the same problem with San, my server is located in USA, while all times are using Greece time. What puzzled me, was that the way the info is shown, using vbdate function, the time should have been correct.

So, I tried using this code:

PHP Code:

$nothing=vbdate($vboptions['dateformat'].' '.$vboptions['timeformat'], time()); 


and it produces the correct time for my country. However, when it is called from the hack (admitedly with a different syntax, I have no idea what these 'true', and 'false' parameters do) , in showthread, it shows the wrong time.

So, I did some experimentation, and here is what I came up with. If you change the vbdate arguments used in the showthread, a little, you can have it show the proper time.

Change this:

PHP Code:

(".vbdate($vboptions['dateformat'], $+++++adarray[$whodata['userid']], true, true, false) 


to this:

PHP Code:

(".vbdate($vboptions['dateformat'], $+++++adarray[$whodata['userid']], true, true, true) 


Or if you do not want to see "Today" or "Yesterday", but just a plain date and time, change the code to:

[php]

PHP Code:

(".vbdate($vboptions['dateformat'], $+++++adarray[$whodata['userid']]) 


Here is a description of the vbdate function. The code is located in includes/functions.php

PHP Code:

function vbdate($format, $timestamp = TIMENOW, $doyestoday = false, $locale = true, $adjust = true, $gmdate = false) 


Rgds
-----------
John

[Morgalis]

Hi there

I am installing this with your Mod Management tool, and I am running into a parse error.

vb 3.0.3

parse error - no details given - at the else in the last part of the paste

else
{
// or doing it once an hour
$DB_site->shutdown_query("
INSERT INTO " . TABLE_PREFIX . "threadviews (threadid)
VALUES (" . intval($threadinfo['threadid']) . ')'
);
}

Any suggestions?

[VitroX]

thanks sv1cec for your fix ...

now, is there a way the user list can get sorted first those who has replied and then those who doesnt?, I'm after a way to detect those who dont reply to threads and are only lurking, this could be a way to detect them and that would be very usefull for me.

[Lottis]

Anyone like to help me take the time away?

[VitroX]

Originally Posted by Lottis

Anyone like to help me take the time away?

yes, in modified showthread.php file for this hack, look for:

PHP Code:

if (!empty($+++++adarray))
{
        $+++++adids = array_keys($+++++adarray);
        $+++++sult = $DB_site->query("SELECT user.* FROM ".TABLE_PREFIX."user AS user WHERE userid IN (".implode(",",$+++++adids).") ORDER BY username");
        $+++++ad = "";
        while ($whodata = $DB_site->fetch_array($+++++sult))
        {
            $+++++ad .= "<a href="member.php?u=$whodata[userid]">".fetch_musername($whodata)."</a> (".vbdate($vboptions['dateformat'], $+++++adarray[$whodata['userid']], true, true, false)." ".vbdate($vboptions['timeformat'], $+++++adarray[$whodata['userid']], true, true, false)."), ";
        }
        if ($+++++ad)
        {
            $+++++ad = substr($+++++ad, 0, strlen($+++++ad)-2);
        }
        $total+++++ad = @count($+++++adarray);
} 


and replace it for:

PHP Code:

if (!empty($+++++adarray))
{
        $+++++adids = array_keys($+++++adarray);
        $+++++sult = $DB_site->query("SELECT user.* FROM ".TABLE_PREFIX."user AS user WHERE userid IN (".implode(",",$+++++adids).") ORDER BY username");
        $+++++ad = "";
        while ($whodata = $DB_site->fetch_array($+++++sult))
        {
            $+++++ad .= "<a href="member.php?u=$whodata[userid]">".fetch_musername($whodata)."</a>, ";
        }
        if ($+++++ad)
        {
            $+++++ad = substr($+++++ad, 0, strlen($+++++ad)-2);
        }
        $total+++++ad = @count($+++++adarray);
} 


that should remove the date time info.

[James Collins]

Originally Posted by snake-boy

Is this working in V3.0.3 (yet)?

I would VERY much like to install this but don't want to be wasting my time.

Anyone who's running this successfully with 3.0.3, please say 'aye' ?

-snake

aye

in 3.05 as well (with patch)