Combining Threads, Posts, Members queries on forumhome into one?

[Xenon]

hehe, just found out a way to combine the thread an postcount queries!!!!

in your index.php you find this:

PHP Code:

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=number_format($countposts['posts']);

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
$totalthreads=number_format($countthreads['threads']); 


replace it with this:

PHP Code:

// get total posts
$counters=$DB_site->query_first('SELECT SUM(replycount) AS posts, SUM(threadcount) AS threads FROM forum WHERE parentid=-1');
$totalposts=number_format($counters['posts']);
$totalthreads=number_format($counters['threads']); 


if the thread/post ammount is incorrect you have tu update your counters in your acp first