Today at 03:02 AM Tigga said this in Post #11 Try searching for something like this in your index.php file:
SELECT COUNT(threadid) AS total FROM thread WHERE dateline>
That's the query that's being executed 50+ times. If you remove that then it should lower the number quite a bit.
Yeah I have this chunk of code in my index
Code:
f ((!$forumperms['canpostnew'] and $showlocks) or $forum['allowposting']==0) {
$forum['onoff'].='lock';
}
// prepare template vars
if (!$showforumdescription) {
$forum['description']='';
}
if ($bbuserinfo[userid]!=0) {
$newforumthreads = $DB_site->query_first("SELECT COUNT(threadid) AS total FROM thread WHERE dateline>$bbuserinfo[lastvisit] and forumid=$forum[forumid] ");
$newforumthreadvew = $newforumthreads[total];
eval("\$forum[newforumthreadvew] = \"".gettemplate('forumhome_newforumthreads')."\";");
}