MyBB 1.8

[RateU]

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:

369 370 371 372 373 374 375 376

$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']; }

---