Recently Viewed Threads
 

Recently Viewed Threads

What this does
This will show each user a list of Recently Viewed Threads. The idea came from www.SitePoint.com. I found myself using it alot when I came back to the site to check up on some threads I forgot about, or just couldn't find. AJAX enabled - (quick thread title edit and open/close works!)

This was coded to be placed on the forumhome, though you can edit to your needs if you know what your doing.

How this plugin works
The concept of this plugin is simple. When a user clicks on a thread, it will log the user and thread info in the database. The thread will then be marked as viewed using a conditional timestamp comparison. In lamens terms this means that when a user views a thread, it will log the time the thread was viewed. It will not relog the thread information if the user views the same thread within a certain amount of wait time. (Admin CP setting). Default is 5 minutes.

Descriptive Example
LiveWire clicks on a thread titled 'New Hack Posted'. 1 small query is performed to see if I have recently viewed this thread yet.

If I have viewed this thread already, it will check and see when I viewed it. If it was longer then 5 minutes ago, then it will add the new information using 1 more query.

If I have never viewed this thread before, then it will insert it into the database using 1 query.

To do list...

• Time to install: 2 minutes or less
• Queries to run: 1 (Installer Controlled)
• File Mods: 0
• Templates to edit: 1 (forumhome)
• Templates to add: 1 (Installer Controlled 'forumhome_recentbit')
• New Phrases: 0
• New Plugins: 2

Important Note
This product of mine is marked as beta as I'm still working on some code for future releases. vBCron to clean up Database will be released soon as an addon in the below post.

Product History
Sun, Feb 12 2006 - Forumhome Recent Table is can be collapsed
Sun, Feb 12 2006 - Added plugins (The two plugins didn't export for some reason)
Sat, Feb 11 2006 - Beta Released


Help & Support
Before asking for support Please make sure you have done all necessary changes! If you still need support please post a reply here and double check that you have clicked the Install Button.

Please post bugs and errors here. Hope you like, feedback welcomed! :)

-Post Reserved-

nice, will be using it for sure :)

The recently viewed threads don't show up but the shell of the template does. Nothing else seems to work incorrectly.

There was a strange bug on my end when exporting the product. It didn't add the plugins to the product, anyway I fixed the little buggy for everyone.

Upgrade
For those of you who installed the 1.0 Beta version and wish to upgrade to v1.1 Beta, please import product-recentlyviewed.xml via AdminCP -> Plugin System -> Manage Products And make sure Allow Overwrite is set to YES

Same here. No threads show up for me. :(

Read the post directly above you.

I know, I've done that.

Hmm, I re-uploaded it and it worked this time. Odd.

Dont work for me its blank.

Installed the new version from scratch as well.

Working oK for me :)

Those that think it aint...go view a thread then goo look..(refresh just in case)

Could you please make this collapseable?
Nice hack btw

looked at a thread and still nowt?

It'll be interesting if you could implement this into the UserCP like IPB2

Very strange...Mine worked 1st time..
I then moved the hack further up the template and still
works 100%....I dont know what to suggest..

Have you turned it on in your admincp?

Installed - shows "Recently Viewed Threads" even when there are none to show...very shabby. Also, turns the Thread count in the "Threads/Posts/Users" at the top of my page to however many recently viewed threads there are.

Threads: 1, Posts: 2,303, Members, 2,700 for example.

Oh, and there's no AJAX to be found.

Uninstalled.

Thank you, I'm gonna install this... :D

Hi

I beg to differ, mine is working 100%
please see www.bashys-place.com or to skip the brill intro use www.bashys-place.com/forums i am afraid you will need to register by the looks of it
as its a members only hack, wich is a shame as guest could make use of this as well

Fancy inplementing this LiveWire, Guest as well?

Uninstalled.

Sorry.

Working for me! Thanks for the update LiveWire. To call someone's hack shabby is a bit lame! I think it's top notch. As far as moving to the UserCP is concerned, a little fiddling with the plugins could probably achieve this. I'm gonna try to get it working in CMPS. :)

I've just downloaded and installed this hack on a fresh vBulletin 3.5.3 install and it works perfect. Ajax is working also (Here is another screenshot of me using it) You have to remember to save your settings in the admincp before this to work. The active staus is turned off by default.

vBulletin Options -> Recently Viewed Threads -> Recently Viewed Active -> Set to Yes

Whats the text box with Test in it in your image Livewire?

This post marks a newer version

The forumhome Recent table can now be collapsed. The Main Zip file has been updated. For those who wish to upgrade there templates, please follow these Template Instructions:

Template Forumhome:
------------------------------
Find:
Replace With

That is a title of a thread. You can use AJAX to edit the titles and close threads.

Great m8, thanks for doing this :)
Works well

Good work! *Installed*

I was going to try and create this hack myslef but why when yours works perfect! Install was smooth as can be! I'm going to try and extend this so it can be used on the pages created with the Drupal Plugin..

Awesome Job, not shabby at all, a much needed mod for VB IMO.

Could this be done so that it shows on the users MEMBERPROFILE page?
ie when I look at someone elses profile I see the threads they have recently viewed.

Hi

It appears that i am now getting this DB error whilst using your hack

Please advise?

Bashy. Log into the Admincp and go to Execute SQL Query and run this query:

[sql]
DELETE FROM recentlyviewed
WHERE dateline < (1140115611 - 3600)
[/sql]
This should fix it for a couple of days. When I get home I'll create a maintance script. :)

Ok m8 thanks for that....
I take it without a main fix i will get the issue again, if ya not done the main fix by then do i run that again if i get the same issue?

All seems ok again :)
Cheers for the quick response an all that :)

Just had this error

I tried to run that sql ya gave me but didnt work this time...
Please advise as i have to keep this turned off now :(

Is this hack working?

me too

I had the errrors

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, lastpost, forumid, pollid, open, replycount, postusername, postuserid, lastposter,
thread.dateline, views, thread.iconid AS threadiconid, notes, thread.visible


FROM thread AS thread

LEFT JOIN recentlyviewed AS recentlyviewed ON(recentlyviewed.threadid = thread.threadid)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN(4,5,1,2,3,15,19,8,22,23,28,29,11,34,18,24,25,20 ,40,42,57,59,60,62,31,64,65,35 ,66,6,7,67,41,73,63,72,74,75,76,77,78,79,80,81,82, 83,84,85,86,87,88,89,90,91,92, 93,94,95,96,97,98,99,100,101,102,103,104,105,106,1 07,71,111,115,117,127,157,134, 181,156,120,186,141,159,197,234,217,216,187,237,19 6,192,243,211,244,215,133,212, 246,158,268,270,272,274,276,277,278,279,280,281,28 2,283,284,285,286,287,289,290, 291,292,294,295,296,298,299,300,301,302,303,68,304 ,307,308,309,310,312,313,314,3 15,316,317,318,320,321,322,323,324,325,326,327,328 ,180,330,152,331,333,221,335,3 36,337,188,338,341,342,347,340,359,384,379,386,155 ,385,362,344,390,391,358,396,4 15,441,458,463,436,474,476,429,269,461,484,487,493 ,488,491,502,509,511,512,513,5 14,515,516,517,519,521,522,523,524,504,424,496,492 ,154,421,537,531,470,420,560,5 58,564,477,466,426,542,430,494,475,561,566,520,568 ,604,596,574,600,618,615,614,6 23,624,585,619,622,598,563,577,261,645,423,706,670 ,757,756,866,937,802,808,841,6 92,960,904,829,1030,1014,1029,1034,1046,377,1036,1 044,1033,1018,375,1022,1051,20 6,401,409,367,378,387,13,453,951,1143,1217,1219,11 49,1195,1042,1272,1275,1305,63 2,275,241,675,1658,373,1303)
ORDER BY recentlyviewed.dateline DESC
LIMIT 5;

MySQL Error : Got error 28 from table handler
Error Number : 1030
Date : Thursday, March 30th 2006 @ 03:30:52 PM
Script : http://xxxxxxxxxxxxxx/forums/index.php
Referrer : http://xxxxxxxxxx/forums/showthread.php?t=1679
IP Address : xxxxxxxxxxxxxx
Username : admin
Classname : vb_database

@LiveWire

When run
DELETE FROM recentlyviewed
WHERE dateline < (1140115611 - 3600)

The member access forum OK w/o any error but when iam, the administrator loggin in the error still apear :(

AHA, when i'm trying TRUNCATE TABLE `recentlyviewed`
all become the normal now:)

The hook for this plugin made my forums stats say threads: 5. Maybe you should update that?. I wont click uninstall in hopes that you do fix the slight bug. But it's going to be disabled on my site for now. Thanks.

I'll be updating this in the next day or so, as I need to fix it for my site. ;)

Hi LiveWire, any progress? This seems like a great feature.

I get the issue where it says I have 5 threads too. Also, recently this seems to slow down my forumhome loading. Normally <1 second to over a minute. I had to disable even with it only showing 3 threads updating every 30 minutes. Hope you know about this issue and how to fix. :D