Miscellaneous Hacks - Unread Posts and Reputation Comments (welcome box)

This modification is no longer available or supported.

Note: The unread posts portion of this hack only works if you use the database thread marking system.

This will display the actual number of posts that are still considered unread by you (and will show up in a 'getnew' search).

Versions 1.22+ also display the number of new reputation comments since you last checked your usercp.

There is the option to count the unread posts since your last visit, or all posts considered unread. This setting reflects the divider in the 'getnew' search display. There is also the option to disable the unread posts display or the new reputation comments display.

All settings are located in vBulletin Options > Display Unread Posts and Reputation.

To install this hack unzip the xml file and import it using the ACP Product Manager.


History:

v1.11 : First Release for vb 3.6 - various changes.
v1.12 : Updated for Version Checking.
v1.13 : Phrases Updated.
v1.14 : Dependancies updated, URL's updated.
v1.15 : Minor phrasing changes.
v1.16 : Changes to the way displayed messages are built.
v1.17 : SQL Changes to use slave.
v1.18 : Fixed broken Index creation (on install).
v1.19 : Modified slightly to exclude moderated or soft deleted posts (unless moderator).
v1.20 : Duplicate line of code removed.
v1.21 : ATCS and disable options added.
v1.22 : New reputation comments added. ATCS removed as now unnecessary.
v1.23 : Bug fixes. Added links prefix setting.
v1.24 : Fix reputation comments not being marked as read.
v1.25 : Permission check updated to include 'canviewthreads'.

[Paul M]

Pretty much as it says - one displays the count of posts unread since your last visit date. The other counts all unread posts (as determined by the days setting in the database marking settings).

[Speechless]

very nice, i've installed it and it's working fine, but it appeared on the default vb template only, how can i add it to my customized template navbar ?

[Tulsa]

It would be really slick if you'd toss in an option for ajax refresh on this hack.

[apiasto]

thnx , like it

[FireFish]

Nice Mod; Quick question if anyone could help:

I'm running 3.6.2 & for some reason, it shows up in the Welcome area twice.

Example:
26 Unread Posts since your last visit.

26 Unread Posts since your last visit.

Anything I can do about this?

[Paul M]

Have you edited you navbar ?

[FireFish]

Originally Posted by Paul M

Have you edited you navbar ?

I PM'd you

[BamaStangGuy]

I keep getting database errors like this:

<!--
Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT COUNT(post.postid) as unread
FROM post as post
INNER JOIN thread as thread ON (thread.threadid = post.threadid)
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
WHERE thread.forumid IN(1, 2, 3, 28, 23, 4, 5, 6, 7, 8, 27, 14, 16, 17, 18, 19, 20, 21, 22, 9, 10, 11, 12, 13)
AND thread.sticky IN (0,1) AND thread.visible IN (0,1,2)
AND thread.lastpost &gt; IF(threadread.readtime IS NULL, , threadread.readtime)
AND thread.lastpost &gt; IF(forumread.readtime IS NULL, , forumread.readtime)
AND thread.lastpost &gt;
AND post.dateline &gt; IF(threadread.readtime IS NULL, , threadread.readtime)
AND post.dateline &gt; IF(forumread.readtime IS NULL, , forumread.readtime)
AND post.dateline &gt;;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' threadread.readtime)
AND thread.lastpost &gt; IF(forumread.readtime IS NULL, , ' at line 9
Error Number : 1064
Date : Thursday, November 9th 2006 @ 11:31:48 AM
Script : vBulletin Template Conditionals List - vBulletin Zone
Referrer : (vBSEO Article) List of Commonly Used Template Conditionals - vBulletin-Fans.com
IP Address : 24.214.88.63
Username : Brent
Classname : vB_Database
-->

I was looking through my plugins to see which deal with the threadread.readtime and this one had it.

Any suggestions on what is causing the database error?

The error happens when clicking on a link from another site to a thread on my site.

It doesn't happen everytime

[ICY ICE]

Paul got it installed in 3.6.2 and works perfectly.

Thanks!

[Paul M]

Originally Posted by BamaStangGuy

I keep getting database errors like this:



I was looking through my plugins to see which deal with the threadread.readtime and this one had it.

Any suggestions on what is causing the database error?

The error happens when clicking on a link from another site to a thread on my site.

It doesn't happen everytime

I have no idea what that SQL query is, it's certainly nothing to do with this mod.