number of new post

[monstergamer]

if i wanted to have a number beside the new post link, how would go around doing that?

thanx
monstergamer

[Zachery]

It requires running a query, and i dont suggest you do it on EVERY page.


if (THIS_SCRIPT == 'index' AND $bbuserinfo['userid'] != '0')
{
// Posts
$getnewposts = $DB_site->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post WHERE visible = 1 AND dateline >= '$bbuserinfo[lastvisit]'");
$newposts = number_format($getnewposts['count']);
}

:)

[monstergamer]

thanx, i just want it on one page anyway

but where do i add this