vb.org Archive - Miscellaneous Hacks - New posts and reputation comments.

Quote:

Originally Posted by aranthorn (Post 1316268)

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01914 seconds Memory Usage 1,815KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: