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

[JohnWoo]

Sorry, but I can't show, because I have no "my vB" outside http://localhost:80/ I worked long time ago in one company as vB administrator and since that time it is just a fun for me
But you may find screenshot image for that hack in old 2.2.x thread.

[jluerken]

Originally Posted by JohnWoo

Sorry, but I can't show, because I have no "my vB" outside http://localhost:80/ I worked long time ago in one company as vB administrator and since that time it is just a fun for me
But you may find screenshot image for that hack in old 2.2.x thread.

I don't see a screen there that really shows what this hack is doing.

[JohnWoo]

<a href="https://vborg.vbsupport.ru/attachment.php?attachmentid=9718" target="_blank">https://vborg.vbsupport.ru/attac...achmentid=9718</a>
?

[MrNase]

This hack doesn't work and it's not just me. A friend of mine tested that hack before i did and he had the same problems as me.

Somebody else should test it, too.

[JohnWoo]

Originally Posted by MrNase

This hack doesn't work and it's not just me. A friend of mine tested that hack before i did and he had the same problems as me.

Somebody else should test it, too.

I have nothing to say - sorry
But in last 2 days i tested it may be 12 or 15 times and now i am 99.9% sure that it works
PS Looks like we have different base scripts..
PPS Here is new one screen for vb3

[MrNase]

i must be too stupid. I installed this hack 3 times and it still doesn't work.

It must be something with the database because the entry in the database is still 'null' but i visited that thread with both accounts and it must be '1 2' and not 'null'


After i replied to that thread it gets marked as read.

[boardster]

Hi JohnWoo,

thank you for this great hack.

Unfortunately I've problems to install this hack. Maybe I dont follow all instructions exactly.

Can you upload the files you have changed, please?

[JohnWoo]

Seems that i found problem
Feel myself stupid I couldn't found it for so long time because was looking at scripts changes and missed one small word in sql request...
Sorry

[boardster]

Originally Posted by JohnWoo

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

Now it works fine!!

Thank you very much, JohnWoo. =)

[codemonkey]

no it doesnt work here. in boardsters board it doesnt work too.
http://www.boardunity.de <- here you can see it.