New Thread Count Wrong

[Scott MacVicar]

I wish i had looked at the hack now

PHP Code:

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


is the hack

I suppose you could make some minor alterations to the hack, to make this work.

you need to move the following section of code under the query which gets access table permissions.

PHP Code:

foreach($ipermcache as $forumid => $perms) {
  if($perms['canview']) {
    $goodforums[] = $forumid;
  }
}
if(!empty($goodforums)) {
  $forumperms='AND forumid='.implode(' OR forumid=',$goodforums);
}
$getnewthread=$DB_site->query_first("SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '$bbuserinfo[lastvisit]' $forumperms");
$getnewpost=$DB_site->query_first("SELECT COUNT(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]' $forumperms"); 


So you add this below
// if user is know, then welcome

and then relocate the entire piece of code to below

PHP Code:

} else {
  $accesscache = '';
} 


this won't have any effect on the forums