Real "read/not read" threads and "new messages in forum" highlighting v1.2

Hello all!

It is just a vb3 version of old hack
https://vborg.vbsupport.ru/showthread.php?t=47101
And with same weak sides.

Features:
- Thread on forumdisplay highlighted for user as read only if that user saw last post in that thread or if last post in that thread is older then user defined (from user CP profile) amount of time (from 1 to 999 hours and infinity)
- Forums on index page and subforums on forumdisplay pages will be highlited as "have no new posts" only if user saw last post in that forum or subforum
- Highliting system is completly cookie-free
- System will require extra Database space (2-4% on large forums and 5-6% on small)
- Sytem will add some extra queries to scripts

-one addditional UPDATE is showthread.php (if there are new posts since your last visit of that thread)
-one additional SELECT (of 2 fields only) for each subforum on forumdisplay.php
-one additional SELECT (of 2 fields only) for each forum on index.php
-one addditional UPDATE in newreply.php
-"mark forum read" works using one extra UPDATE
-and "mark all forums read" using one extra UPDATE for each forum


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 "thread" 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". 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 string in that view field 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 "view" field of thread will be deleted.
On forum home page script looks for userid number in "view" field of last thread in each forum and if it found, display that there were no new posts in that forum.

Additionally read\unread marking can be time based (new field ) "marktime" in users custom fields. 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 profile settings.
And at last to mark forum (or all forums) read we just mark read last thread in that forum (or in all forums

History:
v.1.2
Fixed moved threads highlighting.
some changes in functions.php and functions_forumdisplay.php

v.1.1
Fixed SQL request. If you tried to install v 1.0 already, better drop view field
ALTER TABLE `thread` DROP `view`
and recreate it again
ALTER TABLE `thread` ADD `view` TEXT NOT NULL

Sorry for my English and please ask questions if you don't understand something

[codemonkey]

ohh now it works fine. there is only one problem: The "mark all forums as read" function doenst work.

[JohnWoo]

"mark all forums as read" must mark as read last thread in each forum. After all forums on index.php must not be highlighted. It don't work? Or may be you want to be marked as read all threads in all forums? If yes? then there is no way to mark all threads in all forums as read (because it will update all threads in database ) - sorry.

[codemonkey]

Originally Posted by JohnWoo

"mark all forums as read" must mark as read last thread in each forum. After all forums on index.php must not be highlighted. It don't work? Or may be you want to be marked as read all threads in all forums? If yes? then there is no way to mark all threads in all forums as read (because it will update all threads in database ) - sorry.

But then your hack makes no sense. sorry but why will not every thread mark as read? Like in phpBB or something else.

[JohnWoo]

I know nothing about phpBB, but lets say that you have board with 100.000 threads and 10.000 members. Then when some member will deside to "mark all threads read", vB will have to run query with 100.000 affected rows. And update of text field in 100.000 rows at once will kill your MySQL server, and if it will be still alive, what if 200 members at once will decide to do same thing? So I am sure that it will never be possible in that highlighting scheme. Besides i don't understand what for do you need it - sorry

[enginethatcan't]

installed but problem.....

everything is lit up as if there were new replys to everything. but only one thread has been made. Everything is bold. did I need to change something? and where?

[JohnWoo]

sorry, but i am not sure that i understand
If somebody post reply to thread that was marked as read ( marked for you) it must become bold (unread) because it means that you have not read it yet completely?
Or all threads become unread after reply to one single thread? If first, it was supposed to be so, and if second, you need to check changes in newreply.php

[enginethatcan't]

no replies whatsoever right now

[JohnWoo]

Still understand nothing - sorry
You always see all threads as unread or you never tried to open that threads or they all turn to unread after one single reply ?

[enginethatcan't]

I'm sorry but I really don't understand what you don't get from my pics and explination.

I installed this. EVERYTHING shows up as UNREAD no matter what!

[JohnWoo]

then if you completely sure that scripts were changed correctly, extra field was created as
NOT NULL
(it was fixed in v.1.1) and you have no NULL values in that field for all posts, I have no ideas - sorry... It works on my side.