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.

[Ian Cunningham]

Is there any way to implement this on a big board? i.e 1Mil+ posts?

I tried it and it REALLY slowed things down :ermm:

[Paul M]

You could try adding an Index to the two fields it uses.

[Ian Cunningham]

Originally Posted by Paul M

You could try adding an Index to the two fields it uses.

You'll have to excuse my newbie ignorance... how would I do that?

[cyberphr]

Nice hack, and coincidentally I am a GX member!