Quote:
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:
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. |
aranthorn -Thanks, but this is not working completely for me. In addition you need to edit the search.php link in the navbar.
To do this, in the plugin xml look for this code:
PHP Code:
<phrases>
<phrasetype name="GLOBAL" fieldname="global">
<phrase name="npr_single_post" date="1156000000" username="Paul M" version="3.16"><![CDATA[post]]></phrase>
<phrase name="npr_plural_post" date="1156000000" username="Paul M" version="3.16"><![CDATA[Posts]]></phrase>
<phrase name="npr_single_comment" date="1156000000" username="Paul M" version="3.16"><![CDATA[comment]]></phrase>
<phrase name="npr_plural_comment" date="1156000000" username="Paul M" version="3.16"><![CDATA[comments]]></phrase>
<phrase name="npr_posts" date="1156000000" username="Paul M" version="3.16"><![CDATA[<strong>{1} <a href="search.php?do=getnew">New {2}</a></strong> since your last visit.]]></phrase>
<phrase name="npr_reputation" date="1156000000" username="Paul M" version="3.16"><![CDATA[You have <strong>{1} <a href="usercp.php">New</a></strong> reputation {2}.]]></phrase>
<phrase name="npr_no_posts" date="1156000000" username="Paul M" version="3.16"><![CDATA[No <strong><a href="search.php?do=getnew">New Posts</a></strong> since your last visit.]]></phrase>
<phrase name="npr_no_reputation" date="1156000000" username="Paul M" version="3.16"><![CDATA[You have no new reputation comments.]]></phrase>
</phrasetype>
<phrasetype name="vBulletin Settings" fieldname="vbsettings">
<phrase name="setting_npr1_desc" date="1154000000" username="Paul M" version="3.12"><![CDATA[Set to 'Yes' to display the number of new posts since your last visit in the navbar welcome box.]]></phrase>
<phrase name="setting_npr1_title" date="1154000000" username="Paul M" version="3.12"><![CDATA[Enable New Posts Display]]></phrase>
<phrase name="setting_npr2_desc" date="1154000000" username="Paul M" version="3.12"><![CDATA[Set to 'Yes' to display the number of new reputation comments in the navbar welcome box.]]></phrase>
<phrase name="setting_npr2_title" date="1154000000" username="Paul M" version="3.12"><![CDATA[Enable New Reputation Comments Display]]></phrase>
</phrasetype>
</phrases>
and change it to this:
PHP Code:
<phrases>
<phrasetype name="GLOBAL" fieldname="global">
<phrase name="npr_single_post" date="1156000000" username="Paul M" version="3.16"><![CDATA[post]]></phrase>
<phrase name="npr_plural_post" date="1156000000" username="Paul M" version="3.16"><![CDATA[Posts]]></phrase>
<phrase name="npr_single_comment" date="1156000000" username="Paul M" version="3.16"><![CDATA[comment]]></phrase>
<phrase name="npr_plural_comment" date="1156000000" username="Paul M" version="3.16"><![CDATA[comments]]></phrase>
<phrase name="npr_posts" date="1156000000" username="Paul M" version="3.16"><![CDATA[<strong>{1} <a href="search.php?do=getnew&exclude=71">New {2}</a></strong> since your last visit.]]></phrase>
<phrase name="npr_reputation" date="1156000000" username="Paul M" version="3.16"><![CDATA[You have <strong>{1} <a href="usercp.php">New</a></strong> reputation {2}.]]></phrase>
<phrase name="npr_no_posts" date="1156000000" username="Paul M" version="3.16"><![CDATA[No <strong><a href="search.php?do=getnew&exclude=71">New Posts</a></strong> since your last visit.]]></phrase>
<phrase name="npr_no_reputation" date="1156000000" username="Paul M" version="3.16"><![CDATA[You have no new reputation comments.]]></phrase>
</phrasetype>
<phrasetype name="vBulletin Settings" fieldname="vbsettings">
<phrase name="setting_npr1_desc" date="1154000000" username="Paul M" version="3.12"><![CDATA[Set to 'Yes' to display the number of new posts since your last visit in the navbar welcome box.]]></phrase>
<phrase name="setting_npr1_title" date="1154000000" username="Paul M" version="3.12"><![CDATA[Enable New Posts Display]]></phrase>
<phrase name="setting_npr2_desc" date="1154000000" username="Paul M" version="3.12"><![CDATA[Set to 'Yes' to display the number of new reputation comments in the navbar welcome box.]]></phrase>
<phrase name="setting_npr2_title" date="1154000000" username="Paul M" version="3.12"><![CDATA[Enable New Reputation Comments Display]]></phrase>
</phrasetype>
</phrases>
NOTE: change
&exclude=71 to whatever forum you want to exclude from the search.
More Information