Number of new posts in navbar?

[94DROPTOPZ]

I'm sure that this is pretty simple for some of you and I have messed with it a bit and can't seem to get it to work. What I'm looking to do is add the number of new posts next to the "New Posts" link in the nav bar, just so before they click the new posts they have an idea of how many new posts there are. I saw this on another site and I think that it's a good idea.

I have seen Garys "hack" but it's really not what I'm looking for right now...

Thanks in advance for your help

[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!

[sabret00the]

you should've done this with the php_include template

[ericgtr]

Originally Posted by sabret00the

you should've done this with the php_include template

Post it up, let's give him some options

[sabret00the]

add to your phpinclude_start

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"><ahref="search.php?$session[sessionurl]do=getnew"accesskey="2">$vbphrase[new_posts_nav]</a></td> 


Replace it with:

PHP Code:

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


That's it!

[ericgtr]

Originally Posted by sabret00the

add to your phpinclude_start

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"><ahref="search.php?$session[sessionurl]do=getnew"accesskey="2">$vbphrase[new_posts_nav]</a></td> 


Replace it with:

PHP Code:

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


That's it!

Cool, so this will add the query anywhere on the site regardless if the navbar is on the page or not? I realize most pages have it anyway but I am wondering about overhead.

[Seiken]

Thats cool even though its only one edit. But its conveinent.

[94DROPTOPZ]

Thank you guys very much, I will try this...

[sabret00the]

Originally Posted by ericgtr

Cool, so this will add the query anywhere on the site regardless if the navbar is on the page or not? I realize most pages have it anyway but I am wondering about overhead.

yup one query to everypage, not sure how worth it, it is, but it's not alot and won't every bring the server to it's needs or nothing of the sort.

[SGT Rock]

All I get is a set of parenthesis without a number: ()