MyBB 1.8 still uses this query in
forumdisplay.php like MyBB 1.6?
PHP Code:
$query = $db->simple_select("forums", "threads, unapprovedthreads, deletedthreads", "fid = '{$fid}'", array('limit' => 1));
$forum_threads = $db->fetch_array($query);
$threadcount = $forum_threads['threads'];
if($ismod == true)
{
$threadcount += $forum_threads['unapprovedthreads'] + $forum_threads['deletedthreads'];
}
|
Yes, I have this exact code in line 613 on Mybb 1.8.5
I'm afraid upgrade to 1.8.6, many users with problems, so stop suicide missions on MyBB for me lol
I think MyBB should change the query since 1.8 has prefix filter feature in forumdisplay.
Yep. I think it should uses the previous query (the query which count threads by using threads table) if
$prefixsql has a value.
Also, you may interest to this lines in
showthread.php
PHP Code:
$query = $db->simple_select("forums", "threads, unapprovedthreads", "fid = '{$fid}'", array('limit' => 1));
$forum_threads = $db->fetch_array($query);
$threadcount = $forum_threads['threads'];
if(is_moderator($fid, "canviewunapprove") == true)
{
$threadcount += $forum_threads['unapprovedthreads'];
}
|