Jordie (Interspire Staff)
01-22-2006, 10:44 PM
Hey all,
Thought I'd post an update on this one. I changed the code so it will count the articles in the cateogry AND the sub categories it contains.
Follow the same instructions as Chris's, let me know if anyone gets stuck:
Edit the templates/template_name/Panels/RootArticleCategoriesPanel.php file. At the bottom it has a function called '_GetCategoryList'.
Replace it (all) with the following:
function _GetCategoryList()
{
// Get a list of article categories and return them
$output = "";
$query = sprintf("select * from %scategories where ParentID=0 order by Name asc", $GLOBALS["AL_CFG"]["tablePrefix"]);
$catResult = mysql_query($query);
while($catRow = mysql_fetch_array($catResult))
{
$query = sprintf("select count(*) as count from %scategoryassociations WHERE categoryid='%s'", $GLOBALS['AL_CFG']['tablePrefix'], $catRow['CategoryID']);
$countresult = mysql_fetch_assoc(mysql_query($query));
$count = $countresult['count'];
$count = $count + $this->_GetSubCatCount($catRow['CategoryID']);
$output .= sprintf("
<div class=\"ListItem\">
<A href='%s'>
%s
</A> (%s)
</div>
", AL_HELPER::CategoryLink($catRow["CategoryID"], $catRow["Name"]), $catRow["Name"], $count);
}
if(mysql_num_rows($catResult) == 0)
$output .= sprintf("<div>%s</div>", $GLOBALS["AL_LANG"]["hpNoCategories"]);
return $output;
}
function _GetSubCatCount($catID){
$query = sprintf("select * from %scategories where ParentID='%d' order by Name asc", $GLOBALS["AL_CFG"]["tablePrefix"],$catID);
$catResult = mysql_query($query);
while($catRow = mysql_fetch_array($catResult))
{
$query = sprintf("select count(*) as count from %scategoryassociations WHERE categoryid='%s'", $GLOBALS['AL_CFG']['tablePrefix'], $catRow['CategoryID']);
$countresult = mysql_fetch_assoc(mysql_query($query));
$count = $countresult['count'];
$countTotal = $countTotal + $count + $this->_GetSubCatCount($catRow['CategoryID']);
}
return $countTotal ;
}
Edit: Changed it per jurgennijhuis' suggestion below.