New Posts & Threads x2

[gamesxposed]

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:
// ### BOARD STATISTICS #################################################

After add:
//
//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:

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

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

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

Find:
<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:
<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! :cool:

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. :cool:

[aHMET]

any other version?

[Symbian.info]

Only use the new threads function and thats works great :cool:

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

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

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! :D