Miscellaneous Hacks - New posts and reputation comments.

This modification is no longer available or supported.

The 3.6 port of this simple hack with some small changes.

This displays the number of new posts since your last visit & the number of new reputation comments since you last checked your usercp - both are displayed in the welcome panel.

Changes ;

* Fixed bug of them not showing on error pages.
* Either can be now turned off with a setting in vBulletin Options > Display New Posts and Reputation.

Notes:

If upgrading from the 3.5 version then you will need to re-do the template changes.
Versions 3.21+ do not require any manual template changes. See Post #167


History:

v3.11 : Initial vb 3.6 release, bug fixs and settings added.
v3.12 : Updated for Version Checking.
v3.13 : Internal code updates, not released.
v3.14 : Phrases Updated.
v3.15 : Minor code changes (not released).
v3.16 : Changes to the way displayed messages are built.
v3.17 : SQL Changes to use slave.
v3.18 : Fixed broken Index creation (on install).
v3.19 : Internal development version (not released).
v3.20 : Internal development version (not released).
v3.21 : Manual template edits removed, seperate settings group added.
v3.22 : Links prefix added.
v3.23 : Added forum viewing permissions check to count.

[njoker555]

great mod works great right now, tried another one before that didnt seem to work, thanks for it!

[SBlueman]

Does anyone know what needs to be done to have the links work on the vBadvanced portal home page? And can someone explain it in layman's terms to me? I am new to vBulletin and am still learning the ropes. I saw someone mentioned it on page 2 of this thread but I honestly did not understand the solution......sorry for being so ignorant.

[Paul M]

In what way do they not work ?

[SBlueman]

When I click on a link on my portal page it trying to go to http://gridironfans.com/search.php?do=getnew and not http://gridironfans.com/forums/search.php?do=getnew

[raiderlax]

Great Mod, thanks Paul

[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.

[Paul M]

I have nothing against people posting ways to customise it, I just won't add anything to the default mod (or support any customisations).

[Veronica Vain]

Hi I know this will probably sound dumb but I'm new to programming and hacks, I was looking through my ftp and I can't send to find the file Navbar template. Can some one point me to where that would be?

[Ba$im]

hello
thanks for gr8 hack
I would if u have time
I want also show post of user under new post and repuation
i try add $vbphrase[posts]: $post[posts]
but it not work
can u plz help me on this

thanks

[Paul M]

Try $bbuserinfo[posts]