[DRJ]

I have this query in phpinclude

PHP Code:

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


It works fine to get the total new posts, but it also counts posts that users cannot see based on the forum permissions.

Is there another condition I could add to check the users permissions to make sure that they can see the post and if not, don't count that post for the total.

Thanks