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')."\";");
}
You can remove that bit of code and it will take care of the offending query. It's apparently counting the number of new threads in each forum since a user's last visit, so you will lose that hack, but IMO a hack like that certainly isn't worth an additional 50 queries on your homepage.
By the way, it seems you may have installed the microstats hack wrong...
Page generated in 0.5169800 seconds (-506.86% PHP - 606.86% MySQL) with 92 queries.
The query count seems to be accurate, but obviously the percentages aren't.
07-12-2003, 04:59 PM
Threaded Mode