[Boofo]

Originally Posted by M1th

an example (for getting count of new threads since last visit):

PHP Code:

 
    $getnewthread=$DB_site->query_first("
    SELECT COUNT(*) AS threads
    FROM ".TABLE_PREFIX."thread
    WHERE lastpost IN(" . implode(', ', $forumids) . ") > '".$bbuserinfo['lastvisit']."'
     "); 


You just to the same thing for the other query.

Havent tested it but it should work.

I was talking about the one where forums that the user is not allowed to access is included in the query.