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.

[Caddyman]

i have this installed on my board talkdelaware.com and it works GREAT!

my users love it, now i just added news feeds. they want these dis-included from the new post search and the count it shows "X unread posts" in the welcome box.

i have successfully filtered out the right forums on a search by using the "&exclude=48,4,54,55,56,57,58,59,60,61,62,63,64,65 ,66\" on the end of get new.

is there a way to get the "X unread post" to be filtered as well?

now it will show like "20 unread posts" and when you click the search it will return nothing as the actual search is filtered.

does that make sense?
-Caddy

[mamashid]

HI there paul, i have used your hack for this in the past, I just upgraded it from the 3.6 to this I have 3.7.0 RC running on board, when I added it, it is now not showing in my welcome box, help?

[Caddyman]

ok i found this in the 3.6 thread for this mod. i want to exclude a userid from the new post counts. how do i do it with this mod?

Originally Posted by aranthorn

Everyone keeps asking if they can exclude forums, well, that's a different table in vBulletin. What I did is remove a user. I my case this is an RSS bot. So here's what I did.
Original New Posts and Reputation (1) Plugin:

$repcount = array();
$postcount = array();
$show['pcount'] = $vbulletin->options['npr1'];
$show['rcount'] = $vbulletin->options['npr2'];

if ($vbulletin->userinfo['userid'])
{
	if ($show['pcount'])
	{
		$postcount = $vbulletin->db->query_first_slave("
			SELECT COUNT(dateline) AS pcount 
			FROM ".TABLE_PREFIX."post 
			WHERE dateline > {$vbulletin->userinfo[lastvisit]}
		");
	}
	if ($show['rcount']) 
	{ 
		if ($vbulletin->userinfo['showreputation'])
		{
			$repcount = $vbulletin->db->query_first_slave("
				SELECT COUNT(dateline) AS rcount 
				FROM ".TABLE_PREFIX."reputation 
				WHERE userid = {$vbulletin->userinfo[userid]} 
				AND dateline > {$vbulletin->userinfo[lastrepcheck]}
			");
		}
	}

	if ($postcount['pcount'] == 0)
	{
		$vbulletin->userinfo['pcount'] = $vbphrase['npr_no_posts']; 
	}
	else
	{
		if ($postcount['pcount'] == 1)
		{
			$vbulletin->userinfo['pcount'] = construct_phrase($vbphrase['npr_posts'],$postcount['pcount'],$vbphrase['npr_single_post']); 
		}
		else
		{
			$vbulletin->userinfo['pcount'] = construct_phrase($vbphrase['npr_posts'],$postcount['pcount'],$vbphrase['npr_plural_post']);  
		}		
	}		

	if ($repcount['rcount'] == 0)
	{
		$vbulletin->userinfo['rcount'] = $vbphrase['npr_no_reputation']; 
	}
	else
	{
		if ($repcount['rcount'] == 1)
		{
			$vbulletin->userinfo['rcount'] = construct_phrase($vbphrase['npr_reputation'],$repcount['rcount'],$vbphrase['npr_single_comment']); 
		}
		else
		{
			$vbulletin->userinfo['rcount'] = construct_phrase($vbphrase['npr_reputation'],$repcount['rcount'],$vbphrase['npr_plural_comment']);  
		}		
	}		
}

Have a look at this bit:

	if ($show['pcount'])
	{
		$postcount = $vbulletin->db->query_first_slave("
			SELECT COUNT(dateline) AS pcount 
			FROM ".TABLE_PREFIX."post 
			WHERE dateline > {$vbulletin->userinfo[lastvisit]}
		");
	}

This is where you can manually tweak the query.

	if ($show['pcount'])
	{
		$postcount = $vbulletin->db->query_first_slave("
			SELECT COUNT(dateline) AS pcount 
			FROM ".TABLE_PREFIX."post 
			WHERE dateline > {$vbulletin->userinfo[lastvisit]}
			AND userid != 13476
		");
	}

I added the bold text. The userid is my RSS poster bot userid. You can exclude any of the following by changing my "userid" to one on the list below and my "13476" to whatever floats your boat.

I don't recommend anyone do this unless you know what your doing!

I'm only showing you the query used and possibilities to tweak it and the only reason I'm doing that is because Paul M has stated he's not adding any features to this kick ass mod.

Here are the fields than can be played with:
postid
threadid
parentid
username
userid
title
dateline
pagetext
allowsmilie
showsignature
ipaddress
iconid
visible
attach
infraction
reportthreadid


Paul M ~ if you don't like what I've posted here, I totally understand and will delete the post. Just let me know.

please and thank you

[DJ Matt4684]

Edit: Nevermind, got it working again.

[user02934123123]

Is there any way to display the New Posts reading separately from the Welcome block? I very much like it there; but I'd also like to add it to various locations on custom forum pages -- e.g. we have a 'welcome page' that displays a quotation, and where I used the old Show New Posts hack to paste in the HTML code so that the reading would show.

How can I display this hack's readout elsewhere via HTML in templates?

[DJ Matt4684]

This works for me flawlessly, but on the vbadvanced page (homepage) it does not work. Is there anyway to fix this issue with vbadvanced?

[Paul M]

I think this has the path option, I cant check while on holiday.

[mamashid]

what about me paul???

[mamashid]

took me forever but i figured it out on my own, thanks though!

[Forum Lover]

Marked as Installed. :up: