Модуль Категории - Joomla 2.5: Общие вопросы

$db = JFactory::getDbo();
$sql = "select count(id) as artcount from #__content where catid=$item->id";
$db->setQuery($sql);
$result = $db->loadObject();
echo $result->artcount;

$categories = JCategories::getInstance('Content');

$categories = JCategories::getInstance('Content', array('countItems' => true));

$db = JFactory::getDbo();
$sql = "select id as arts, catid from #__content group by catid";
$db->setQuery($sql);
$result = $db->loadObjectList();
var_dump ($result);

.........

//var_dump ($result);
echo sizeof($result);

echo 'материалов в категории ('.$results[$item->id].')';

$db = JFactory::getDbo();
$sql = "select id as arts, catid from #__content group by catid";
$db->setQuery($sql);
$result = $db->loadObjectList();
// var_dump ($result);

( <?php echo sizeof($result);?> )

<name>mod_articles_categories2</name>
...
<filename module="mod_articles_categories2">mod_articles_categories2.php</filename>
...
<filename>mod_articles_categories2.xml</filename>

<?php
function count_Category($id = 0, $all = false)
{
    return JCategories::getInstance('Content', array('countItems'=>true))->get($id)->getNumItems($all);
}
$app = JFactory::getApplication();
$id = $app->input->getInt('id', '');
$view = $app->input->getCmd('view', '');
if($id && ($view=='categories' or $view=='category'))
{
    echo 'Материалов в категории - '.count_Category($id).'<br>';
    echo 'Материалов в категории и под категориях - '.count_Category($id, true);

}
?>