New Posts & Threads x2

All this does is simply retrieve the amount of new posts, so I made it add the count in Navbar, and in Statistics down the bottom.

In the navbar it is global, you can see it next to "New Posts". I also made it so if there is more then one post it add's the "S" at the end, note the "[snos]". It is also found down the bottom of your page in "Statistics". Hope you like it. There is also a "New threads" feature in the statistics part, where it shows new threads.

Index.php
find:

PHP Code:

// ### BOARD STATISTICS ################################################# 


After add:

PHP Code:

//
//START NEW THREADS AND POSTS
//
$newthreads = $DB_site->query_first("SELECT count(*) AS count FROM " . TABLE_PREFIX . "thread WHERE lastpost > 

'$bbuserinfo[lastvisit]'");


if ($newthreads[count] == 1)
{
    $newthreads[snos] = "";
}
else
{
    $newthreads[snos] = "s";
}
//
//END NEW THREADS AND POSTS
// 


Style manager >> Your style >> PHP include templates >> phpinclude_start

Add:

PHP Code:

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

if ($newposts[count] == 1) 
{ 
    $newposts[snos] = ""; 
} 
else 
{ 
    $newposts[snos] = "s"; 
} 


Style manager >> Your style >> Navigation / Breadcrumb Templates > navbar

Find:

PHP Code:

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


Replace with:

PHP Code:

<a href="search.php?$session[sessionurl]do=getnew">$vbphrase[new_posts_nav] ($newposts[count])</a> 


Style manager >> Your style >> Forum home templates > FORUMHOME

Find:

PHP Code:

<div>$vbphrase[threads]: $totalthreads, $vbphrase[posts]: $totalposts, $vbphrase[members]: $numbermembers</div>
            <div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div> 


After add:

PHP Code:

<a href="search.php?$session[sessionurl]do=getnew">$newposts[count]</a> New post$newposts[snos] within <a href="search.php?$session[sessionurl]do=getnew">$newthreads[count]</a> thread$newthreads[snos] since you last visited. 


Should be all working, any questions feel free to ask. I will provide support, also any bugs found, or any ideas for improvment please don't hesitate to share your comment.

Statistics screenshot: http://64.5.56.7/images/stats.jpg
Navbar screenshot: http://64.5.56.7/images/navbar.jpg

Enjoy!

Update 12:53 AM EST. - Moved uneeded global query to index.php.

[Intex]

Funnily enough, just made the same modification myself because it didn't have that info and didn't want the welcome panel hack. I'm sure others would find it useful. Good job.

[AlexanderT]

You notice that this will add two extra queries on every single page?

[reteep]

Yep and those 2 more queries hurt. If you got a populated forum this hack will lag it to death.

Nice idea but it results into a too heavy load :/

[gamesxposed]

When I get some time I'll move the second query.

EDIT - I just moved the index query to index.php, so now there is only one global query added, I'll try get rid of the index.php query tomorrow after some sleep.

Nite' people! :squareeyed:

[GamerJunk.net]

Good work!

[gamesxposed]

Thanks man.

[aHMET]

any other version?

[Symbian.info]

Only use the new threads function and thats works great

[Ian Emu-UK]

Nice hack, is there a way to exclude private forums from the search?

Or better still, base them on each users priviledges (Probably server intensive and not worth the bother )

Thanks for the hack anyway.