Miscellaneous Hacks - Display Unread Posts and New Reputation Comments

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, also, this attaches itself to certain phrases in the "welcome" box and will not work if they are not present (or are modified by other code).

FYI, the Forum Marking Choices are located in vBulletin Options ;
vBulletin Options > General Settings > Thread/Forum Read Marking Type

This displays the actual number of posts that are still considered unread by you (and will show up in a 'getnew' search). It also displays 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.

There is also the option to display the New Reputation Comments counter as a Welcome Box Notification.

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

Version 3.7.004 adds the following ;

A forum exclusion list - requested a number of times, an option is provided to exclude forums from the unread count & display.

A time limit on unread posts count - if a member has not visited for more than x days then a simple unread posts link will be displayed, not an actual count, this stops potential large sql queries if you have a busy forum. The option can be disabled.



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


History:

v3.7.001 : First Release for vb 3.7.
v3.7.002 : Added Notification Display Option for Reputation Comments.
v3.7.003 : Internal version, not released.
v3.7.004 : Added time limit and forum exclusion list.
v3.7.005 : Fixed path bug in welcome box notification.
v3.7.006 : Slight change to accomodate customised navbars still using vb 3.6 code.
v3.7.007 : Fix potential database error if lastrepcheck is blank, rare, but it can happen it seems.

[Paul M]

Originally Posted by BigDog56

How do you do that?

Edit them in the Plugin Manager.

[Scooterpig]

Thanks Paul that link to fix got it going again along with Boofo's hack, thank you..

[N-0p3rz]

Just updated. Working flawlessly.

Love your work. Thanks..

[Aimee1969]

Thank you so much

[Paul M]

This cannot invent reputation.

[BigDog56]

Originally Posted by Paul M

This cannot invent reputation.

My bad, I figured it out.

[hostlayer]

I installed this on 3.7 but it is not showing up at all, any ideas?

[Miktar]

EDIT: NM, just takes a while.

[Paul M]

Originally Posted by hostlayer

I installed this on 3.7 but it is not showing up at all, any ideas?

Have you read all the notes in the main post.

[slyreptile]

Odd. After removing the old 3.6 version and installing this new version, I'm getting database errors sent to my email account. Apparently some users have having problems viewing the forum and others (like myself) have no issues. Here's the email message:

Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT COUNT(dateline) AS rcount
FROM vb_reputation
WHERE userid = 210
AND dateline >;
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 '' at line
4
Error Number : 1064
Request Date : Thursday, June 12th 2008 @ 09:37:15 AM
Error Date : Thursday, June 12th 2008 @ 09:37:15 AM
Script : http://www.mydomain.com/forum/
Referrer :
IP Address : x.x.x.x
Username : Thiok
Classname : vB_Database
MySQL Version :

I've disabled showing new Reputation comments for now. Don't know if that will work or not. I'm still troubleshooting.