[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.

[Kentaurus]

Seems that there we some cases I didn't consider. I fixed it already and uploaded an updated txt. For the people that installed it please change:

(and there we go with this censor...)

PHP Code:

$+++++adids = array_keys($+++++adarray);
$+++++sult = $DB_site->query("SELECT user.* FROM ".TABLE_PREFIX."user AS user WHERE userid IN (".implode(",",$+++++adids).")");
while ($whodata = $DB_site->fetch_array($+++++sult))
{
    $+++++adnames[] = fetch_musername($whodata); 
}
$+++++ad = @implode(",", $+++++adnames); 


to:

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).")");
     while ($whodata = $DB_site->fetch_array($+++++sult))
     {
         $+++++adnames[] = fetch_musername($whodata); 
     }
     $+++++ad = @implode(",", $+++++adnames);
        $total+++++ad = @count($+++++adarray);
    } 


it is already in the txt

[Boofo]

It still isn't sorting the names quite right. In that list of names I sent you in the email, the last name is still showing up out of order. Any way to fix that?

[Kentaurus]

Originally Posted by Boofo

It still isn't sorting the names quite right. In that list of names I sent you in the email, the last name is still showing up out of order. Any way to fix that?

Then I'll write a small script to sort them, just give me some time

[WAR]

were you planning on releasing an htl compliant version again at some point?
(I was going to wait until then if so)

[Kentaurus]

Originally Posted by WAR

were you planning on releasing an htl compliant version again at some point?
(I was going to wait until then if so)

When HTL 1.1 is ready, maybe. It's just that editing both the HTL and the TXT is some time consuming.

[Boofo]

Originally Posted by Kentaurus

Then I'll write a small script to sort them, just give me some time

Ok, I'll be here waiting.

[Kentaurus]

Originally Posted by Boofo

Ok, I'll be here waiting.

It only happened with the colors highlight .... it was an "error" in the query (actually the order by was missing).

	        $+++++sult = $DB_site->query("SELECT user.* FROM ".TABLE_PREFIX."user AS user WHERE userid IN (".implode(",",$+++++adids).")");

change it to

	        $+++++sult = $DB_site->query("SELECT user.* FROM ".TABLE_PREFIX."user AS user WHERE userid IN (".implode(",",$+++++adids).") ORDER BY username");

If that doesn't work take a broom and hit the hack... err.. I'll fix it again.

whoviewed_colors.txt updated also

[Boofo]

You can hold off on the broom. That fixed it. Thank you kindly, sir.

[Alas-Digitales]

Would be possible that the usersnames had a link to their profile?

[Boofo]

Yes, would it be possible to have the names linked to their profile? That would be excellent.