The Arcive of Official vBulletin Modifications Site.

New posts and reputation comments. · **Released**: 08-13-2006

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.

adom7 · #**152** 08-18-2007, 10:03 PM

hi, Paul
Great mod and installed.
But i got a problem.
While I was installing it on admincp, i got a 500 internal server error. The page can not displayed. And then, i repaired the database through my server cp. After the page displayed for a while then a minute later it shows blank page.
I guess, there are some changes on forum/ files.
I am a newbie so i am not good at like these functions.
Could you write the files which I have to reupload on my forum?
Last backup 08.16.2007, so i dont want to lose last 2 days.

Best wishes,
Ahmet

Paul M · #**153** 08-19-2007, 09:37 AM

There are no changes to files for this modification.

Mecho · #**154** 08-22-2007, 02:21 PM

is there anyway that i can remove a section in new posts stats ???

thanks

Paul M · #**155** 08-22-2007, 03:39 PM

I don't understand your question.

Mecho · #**156** 08-22-2007, 09:29 PM

Quote:

Originally Posted by Paul M

I don't understand your question.

i want to remove the new posts of a certain section from the NEW POSTS list ... how can i do that ?

thanks

Ba$im · #**157** 08-22-2007, 10:02 PM

thank u so much Paul

Paul M · #**158** 08-22-2007, 10:11 PM

Quote:

Originally Posted by Mecho

i want to remove the new posts of a certain section from the NEW POSTS list ... how can i do that ?

If you're asking how to exclude certain forums from this mods new post count then you can't, there is no such facility.

SliceofLife · #**159** 09-01-2007, 09:36 PM

Thank you. I love this! Excellent instructions too. Good work

KimmiKat · #**160** 09-06-2007, 05:28 AM

One issue that cropped up is the new comments are not showing for some reason. I checked the settings, but zilch!

yoyoyoyo · #**161** 09-16-2007, 04:37 AM

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05092 seconds Memory Usage 2,382KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_code (2)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!