How to use permissions with New Posts Query?

[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

[Akex]

Put this before

PHP Code:

foreach(array_keys($forumcache) AS $forumid)
{
  $forumperms = fetch_permissions($forumid);
  if ($forumperms & CANVIEW AND $forumperms & CANVIEWOTHERS)
  {
    $allow_forumids[] = $forumid;
  }
}
$allowids = implode(",", $allow_forumids);
unset ($forumperms); 

Then you can use this request :

PHP Code:

$newposts = $DB_site->query_first("SELECT count(*) AS count FROM " . TABLE_PREFIX . "post as p
LEFT JOIN " . TABLE_PREFIX . "thread as t ON (t.threadid = p.threadid)
 WHERE p.dateline > '" . $bbuserinfo[lastvisit]. "' AND t.forumid IN($allowids)"); 

[DRJ]

Thanks