Count all Thread for sub-forums

[omardealo]

Hello ,

that's code make a count thread for any forum

PHP Code:

$getforumcount = $db->query_read("SELECT forumid, threadcount, replycount FROM " . TABLE_PREFIX . "forum");
while ($forumcount = $db->fetch_array($getforumcount))
{
$vbulletin->forumcache[$forumcount['forumid']]['threadcount'] = $forumcount['threadcount'];
} 


in template i use :

PHP Code:

 {$vbulletin->forumcache['x']['threadcount']} 


x = forum id

that code worked well , but i want also count thread for a category and all sub-forums in it by same use

PHP Code:

 {$vbulletin->forumcache['x']['threadcount']} 


Any ideas , thnx