Need help

[NTLDR]

Originally posted by Roody
When I asked how I could put it at a member level I was told to run a query like this: AND visible=1

No where in this thread were you told to run that query (as its only part of one).

This is the PHP to add instead:

PHP Code:

$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE visible=1 AND lastpost > '$bbuserinfo[lastvisit]'");
$getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE visible=1 AND dateline > '$bbuserinfo[lastvisit]'"); 


This will take care of posts in the moderation queue, however taking forum permissions into account invloves significate changes to index.php which can't be posted here.