Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Real "read/not read" threads highlighting 1.0 Details »
Real "read/not read" threads highlighting 1.0
Mod Version: 1.00, by JohnWoo (Member) JohnWoo is offline
Developer Last Online: Apr 2014 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (0 vote - 0 average) Installs: 1
Released: 27 Dec 2002 Last Update: Never Downloads:
Not Supported Is in Beta Stage  

Hello everybody !

Few words how it works
As you know vb "marking threads and posts read" system is time and cookie based. This hack is based on adding to "post" table one extra field - "view" (suppose that it must work fine with TEXT type, but for really large forums we can make it LONGTEXT
Now when somebody open thread, his usedid will be added to that "view" field of last post of thread. After several users (who open that thread) string in that field may look like
37 298 16879 7287 29087 28 298
So it will be just a long string with userid-s separated by space
Now then user open forumdisplay.php script will check each last post of each thread for part of string
[space userid space]
and if is will be found thread will be marked as read. If you think that it will use too much database space, i can say that it will use some place of course, but not too much, because after each reply in thread (new last post in thread) all old data in all "view" fields of all old posts in thread will be deleted. On forum home page script looks for userid number in "view" field of last post in each forum and if it found display that there were no new posts in that forum. To make it work faster (with less database requests) i added "lastpostid" field in thread table
Additionally read\unread marking can be time based (new field ) "marktime" in users table. And users are able to select number of hours (all posts older then that number of hours will be marked as read) in their CP options.
And at last to mark forum (or all forums) read we just mark read last post in that forum (or in all forums
Sorry for my English and please ask questions if you don't understand something

PS Updated to 1.1. New thread here
http://www.vbulletin.org/forum/showt...threadid=47101

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Real "read/not read" threads and "new messages in forum" highlighting v1.2 JohnWoo vBulletin 3.0 Full Releases 43 16 Sep 2006 04:54
Real "read/not read" threads and "new messages in forum" highlighting 1.1 JohnWoo vBulletin 2.x Full Releases 30 22 Mar 2004 01:10

Comments
  #2  
Old 27 Dec 2002, 18:56
VeoMorphine VeoMorphine is offline
 
Join Date: Nov 2002
what does it do?
Reply With Quote
  #3  
Old 27 Dec 2002, 19:34
Brad Brad is offline
 
Join Date: Nov 2001
If im correct this will not mark threads as "read" when your session has timed out. I would install it but im worried about it adding alot of clutter to my Database.
Reply With Quote
  #4  
Old 27 Dec 2002, 21:07
JohnWoo's Avatar
JohnWoo JohnWoo is offline
 
Join Date: Jan 2002
Cool

Hi!

Sorry :) just found part of missed code in .txt
Fixed .zip in first edited post already :)

Last edited by JohnWoo; 28 Dec 2002 at 09:16.
Reply With Quote
  #5  
Old 28 Dec 2002, 07:25
Brad Brad is offline
 
Join Date: Nov 2001
John, do you have any idea how many querys this adds and how much processing time it will add to a forum?. Id love to add it but not if it will cause slower responce times.
Reply With Quote
  #6  
Old 28 Dec 2002, 08:45
JohnWoo's Avatar
JohnWoo JohnWoo is offline
 
Join Date: Jan 2002
:)
-one addditional UPDATE is showthread.php
-one additional SELECT (of 2 fields only) for each thread or subforum on forumdisplay.php and search.php pages
-one addditional UPDATE in newthread.php
-two addditional UPDATE in newreply.php
-"mark forum read" works using one UPDATE
-and "mark all forums read" using one UPDATE for each forum :)
So, in theory forumdisplay.php will work little slower, but i can't notice it using eyes only :)

Last edited by JohnWoo; 28 Dec 2002 at 09:17.
Reply With Quote
  #7  
Old 28 Dec 2002, 16:43
Icheb's Avatar
Icheb Icheb is offline
 
Join Date: Oct 2002
Originally posted by JohnWoo
-one additional SELECT (of 2 fields only) for each thread or subforum on forumdisplay.php and search.php pages
If you have 25 threads displayed per page that will add 25 queries, lol . I am rather someone who sacrifices *some* features to get less neccessaire queries.
Reply With Quote
  #8  
Old 28 Dec 2002, 19:36
Ageel's Avatar
Ageel Ageel is offline
 
Join Date: Jun 2002
Hey, as I know.... This is a good one.. BUT
it will add too much data that is not really needed to the database..

Why don't you make an Additional Table .. let's call it (thread_read)
and add 3 fields (userid, threadid, timestamp)
and then add to it so you can at least delete them from time to time especially if the topics are too old --> no need to specify who read it

I hope this would help

thanx

Last edited by Ageel; 28 Dec 2002 at 19:39.
Reply With Quote
  #9  
Old 28 Dec 2002, 19:41
Ageel's Avatar
Ageel Ageel is offline
 
Join Date: Jun 2002
Originally posted by Icheb


If you have 25 threads displayed per page that will add 25 queries, lol . I am rather someone who sacrifices *some* features to get less neccessaire queries.
If using a new table, he could add a JOIN to the thread SELECT so it will be the same # of queries
Reply With Quote
  #10  
Old 28 Dec 2002, 20:08
JohnWoo's Avatar
JohnWoo JohnWoo is offline
 
Join Date: Jan 2002
Hello !
Originally posted by Ageel

it will add too much data that is not really needed to the database..
sorry, but i can't agree :) In theory on forum with 2000-3000 registered users, 25-30 always on-line users, common number 5 posts in each thread and common post length 80 words/400 bytes it will take about 3-4% of DB space :)

Originally posted by Ageel

Why don't you make an Additional Table .. let's call it (thread_read) and add 3 fields (userid, threadid, timestamp)
Tried it already :) That way will use much more db\processor space\time. Actually i am thinking at that problem about year already... Checked code of most free\not free forums and had a lot of different attepts :)

Originally posted by Icheb

If you have 25 threads displayed per page that will add 25 queries, lol . I am rather someone who sacrifices *some* features to get less neccessaire queries.
Sorry :) I still thinking at optimizing... Hope that somebody more clever will perform it with less db time\space :)

PS It was the only feature that i really missed in vb :)
Reply With Quote
  #11  
Old 28 Dec 2002, 20:27
Icheb's Avatar
Icheb Icheb is offline
 
Join Date: Oct 2002
I don't know if you can use a JOIN for that.
You combine two or more tables with a JOIN, and if that JOIN doesn't find something in one of the tables which matches the WHERE criteria, the entire query doesn't return anything if I am not mistaken. So you would have to enter something into that table thread_read (or however you want to call it) for every thread there is on your forum.
Reply With Quote
  #12  
Old 29 Dec 2002, 01:48
Sebastian's Avatar
Sebastian Sebastian is offline
 
Join Date: Oct 2002
This is a good feature...

I REALLY HATE how vbulletin uses cookies for this... If I read a thread i like the stupid ON gif to turn off!!!

yet you have to wait 15 minutes for timeout so it will be marked as read.. isn't that stupid?! When online it's hard to see which forum you have read because the ON gif does not switch to OFF.

I wish vbulletin would have a better system for read/unread threads and forums because the current system really sucks.

I like the idea your trying to do though,.. only if someone could put some sense into vbulletin team to find a workaround for this.
Reply With Quote
  #13  
Old 29 Dec 2002, 17:13
JohnWoo's Avatar
JohnWoo JohnWoo is offline
 
Join Date: Jan 2002
I just posted optimized version here
http://www.vbulletin.org/forum/showt...threadid=47101
Now it do no add extra db request for each thread on forumdisplay
Reply With Quote
  #14  
Old 02 Mar 2009, 07:22
aqaz aqaz is offline
 
Join Date: Nov 2008
No Files Uploaded.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:44.

Layout Options | Width: Wide Color: