Show Thread Enhancements - Who has read a Thread

This modification is no longer available or supported.

This displays who has read a thread, and the time they last looked at it.

Hovering over a name will show when the member last viewed the thread, and (optionally) what IP address they viewed it from (Note: as of v3.34 you can only view the ip addresses in the 'View-All' display).

There is now an option to allow a thread author to view who has read their thread when they are not in one of the allowed usergroups. The IP and number of days restrictions still apply.

A new time set/reset facility has been added. Members allowed to use this facility can click on the 'set' link and it will set a personal 'cutoff' time - only showing who has read the thread after that time. The time can be reset as many times as you want, and also completely cleared again. When using this facility there is also a link to allow you to view a seperate list of all readers of the thread.

A cron job has now been added that can (optionally) delete records from the whoread table that are over a certain age - this is provided for large forums where the number of table entries can start to reach a million or more after 12 months. The delete age is a setting in the ACP.

Warning: When using the set/reset option - there is only a limited capacity of entries per thread (several thousand) - therefore you should only allow this feature to be used by a limited number of people - typically Staff usergroups. Allowing all members to use it will probably slow down your forum and cause errors if more than about 3000 members set a date on one thread.


There are settings for the following (in vBulletin Options > Who Has Read a Thread) ;

1. Turn the system on/off.
2. Restrict the display to certain usergroups
3. Restrict the IP display to certain usergroups.
4. Restrict the display to a set number of days.

New in v3.28

5. Option to allow thread author to view who read information.
6. Option to turn on the who read cutoff date (reset) function
7. Restrict use of reset function to certain usergroups.
8. Option to set whoread data records to be cleaned out after xxx days.

New in v3.39

9. Clicking on a user will display a page of their thread viewing history, most recent first.


Note: When using option 4 or the set/reset facility, the data is still kept beyond this limit, so they can be changed at any time.

Download the zip, extract the XML file and import using the vb Product Manager.


History:

v3.20 : First Release for vb 3.6, a few code changes.
v3.21 : Dependancies updated for 3.6.0 Gold.
v3.22 : Updated for Version Checking.
v3.23 : Internal Development version.
v3.24 : Internal Development version.
v3.25 : Internal Development version.
v3.26 : Internal Development version.
v3.27 : Private release.
v3.28 : Public release of new features.
v3.29 : Fixed bug in clean-up, the setting was hours, not days.
v3.30 : Added options to disable/change auto template insert (not released).
v3.31 : Internal Code Changes, Settings Group renamed.
v3.32 : Minor template change.
v3.33 : SQL Changes to use slave.
v3.34 : Added new template for username display code, made 'View-All' always available.
v3.35 : Added last post marker to 'View-All' display.
v3.36 : Fix uncached templates.
v3.37 : Fixed missing date/time display when 'set' function is used.
v3.38 : Moved auto-template options to mods main settings group.
v3.39 : Version infomation added, display of user thread reading activity added.
v3.40 : Bugfix : Correct bugs reported in posts #308 & #318.
v3.41 : Minor changes to install code only.

[PoetJA-1975]

Thanx PAUL M - very nice modification & should help with getting peeps to comment on threads! One question: Where are the settings at? Can't see any in Thread Display Options...

/me clicks install

Jacquii.

[Paul M]

The setting are in vbulletin options.

[xenon58]

thanks for a great Mod Paul. I've clicked on istalled, but ...

while installing this on my forum, my pc decided to do a reboot all of a sudden, while in the process of installing. once i got that issue sorted, i went to ACP to check if it was installed or not, and of course Who read the thread was not one of the options, so I've decided to install it again, and used overwrite option while doing so. The process started, but here is what I get

Cleaning up rougue settings
Installing Table
Data Copy - Processing 1199 Records
Processed 1000 Records

and nothing else is going on after that. no pages are loaded, everything just stays at that page. So if I go back to ACP-Options, there is no entry for Who read this thread, and of course no option to uninstall in the products page.

Can you please tell me how can I fix this? Is there a way to remove this manually and re-install from scratch? I swear I dont know what to do with this.

thnx in advance for the time and help.

[Paul M]

For some reason it's failing to process your threadread table. I cannot really guess as to why, perhaps you have very low memory settings.

Since it obviously managed the first 1000 okay you could simply edit the product XML slightly to limit it to 1000 records.

Around line 47 of the XML you should see a line that ends with LIMIT 10000 - change that to LIMIT 1000 and then try again.

[xenon58]

thank you very much for your quick respond, I do appreciate it.

I've followed your advise, and its line #45 to be exact (not to make fun of you, but in case someone else will be looking for it) and I did changed it to 1000. Unfortunately, here is what I've got ...

Cleaning up rougue settings
Installing Table
Data Copy - Processing 1000 Records

I was thinking maybe I should manually delete whoread table, and see if I would be able to re-install it, but is it the only table that is created and responsible for this mod, or there are others?

thanks again for the time and help, it is greatly appreciated

[Paul M]

Originally Posted by xenon58

I've followed your advise, and its line #45 to be exact (not to make fun of you, but in case someone else will be looking for it) and I did changed it to 1000

That's actually quite interesting, because it's most definitely line 47.

So, either you are manually counting and made a mistake, or the file you have is somehow corrupt. Please download the zip again and re-extract the file. Having done that, confirm that you have 586 lines in total, and that line 47 is this ;

PHP Code:

$data = $vbulletin->db->query_read_slave("SELECT * FROM ".TABLE_PREFIX."threadread ORDER BY readtime DESC LIMIT 10000"); 


[xenon58]

Originally Posted by Paul M

So, either you are manually counting and made a mistake, or the file you have is somehow corrupt. Please download the zip again and re-extract the file. Having done that, confirm that you have 586 lines in total, and that line 47 is this ;

PHP Code:

$data = $vbulletin->db->query_read_slave("SELECT * FROM ".TABLE_PREFIX."threadread ORDER BY readtime DESC LIMIT 10000"); 


i stand corrected, you are right, it is line #47. I've opened it in another editor, and used a command to show line numbers, it is a 47 indeed.

$data = $vbulletin->db->query_read_slave("SELECT * FROM ".TABLE_PREFIX."threadread ORDER BY readtime DESC LIMIT 1000");

As I've mentioned above, I did changed the number to a 1000, but still no go. Can you please tell me if the idea of manually removing whoread table from db and reinstalling this mod again might fix the issue? Again, thanks a lot for the time and help

[Paul M]

I can't see that your suggestion would make any difference, please PM me an admin login to your forum so I can look at what is happening.

[xenon58]

Paul, sorry for being quet, was out for a weekend. I see that I forgot to mention the fact that this was a local install, but nonetheless, I will try to install this on my live forum and see whats going on. At this point I cant access my local forum because of a hw failure, so I'm thinking maybe something was going on there while I was trying to figure out why it didnt install. As soon as I have it installed, I will post here.

Again, thank you very much for your time and help, it is greatly appreciated.

[EDIT]

As promissed, here is a small report. Once I've got everything re-installed and fixed and all that good stuff, I've tried again to install this hack. It didnt go again, same error as above, so I've followed your tip and made a change to a LIMIT. This time, instead of 1000, I went with a 100, and it got installed and it works perfectly. Thank you again for your time and help.

all the best!

[beduino]

Hello,
In my style default the hack works, but in other [customized] no.
I read we can edit templates manually.
Where are the instructions? [which templates and how edit ...]
Tks in advance,
Beduino