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:
Code:
$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:
Code:
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.
Code:
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.