[ericgtr]

Here you go, this query is compliments of vBadvanced.

In your vbroot/index.php find:

PHP Code:

// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ### 


Add this just above it:

PHP Code:

//New Posts
        $getnewposts = $DB_site->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post WHERE dateline >= '$bbuserinfo[lastvisit]'");
        $newposts = number_format($getnewposts['count']);
//New Posts 


In your navbar template find:

PHP Code:

<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getnew" accesskey="2">$vbphrase[new_posts_nav]</a></td> 


Replace it with:

PHP Code:

<td class="vbmenu_control"><a href="search.php?$session[sessionurl]do=getnew" accesskey="2">$vbphrase[new_posts_nav]</a> ($newposts new)</td> 


That's it!