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]

You must post all the error text.

[Aclikyano]

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT COUNT(dateline) AS rcount
FROM reputation
WHERE userid = 2
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 : Saturday, May 3rd 2008 @ 03:08:24 PM
Error Date : Saturday, May 3rd 2008 @ 03:08:27 PM
Script : http://www.mysite.com/forums/
Referrer :
IP Address : edited
Username : AtotheC
Classname : vB_Database
MySQL Version : 4.1.22-standard

[Paul M]

You are missing a value for lastrepcheck - I suggest you uninstall this and then re-install it.

[Aclikyano]

Originally Posted by Paul M

You are missing a value for lastrepcheck - I suggest you uninstall this and then re-install it.

and thats a :up:

[GoNz00]

Originally Posted by GoNz00

this was working fine until i installed this version, now its gone and im not sure what to try in forum path.

/forums/
and the full www.clan...co.uk/foeums/ also didnt work ?

db is set right as well as it wused to work ok ?

i forgot all about the issue with ultimate navbar, working again thanks !

[lunarmodule]

Hmm. Well, I upgraded my forum to 7.0 last night and I'm having trouble getting this new version to work for me. It shows the "unread posts" portion, but not the reputation part.

I previously had your 6x version installed (loved it btw), upgraded forum to 3.7.0, uninstalled 6x version in the product manager, installed the new one successfully, but I can only get the "unread posts" part to show up. Everything seemed to go perfectly, no errors.

During the forum upgrade, and before the mod install, I reverted back all templates and I just verified they are unaltered and up to date.

It almost seems to me like it just needs to be turned on, but I verified in vB Options that the bullet for "display new reputation comments" is set to yes.

I saw your warning:

Note that this attaches itself to certain phrases in the "welcome" box and therefore will not work if they are not present (or are modified by other code).

and that seems like it might apply to me but, as far as I can tell, the templates are fresh and untouched.


Any idea what could be wrong?

Thanks a bunch and I love this hack, when I can get it to work.

[lunarmodule]

no additional template modifications are necessary, right? all i did was install the xml in the product manager.

[lunarmodule]

OH, ugh, nm, got it. It doesn't show up unless there is a new rep comment, otherwise the line doesn't appear at all, which is different than the 6x version. But it's fine!

Thanks again, great hack.

[Paul M]

Originally Posted by lunarmodule

OH, ugh, nm, got it. It doesn't show up unless there is a new rep comment, otherwise the line doesn't appear at all, which is different than the 6x version. But it's fine!

Yes, the "no new comments" line was removed.

[johnban]

I installed it but it does not appear in the navbar.

why???