Подсчет количества объявлений в категории (субкатегории) - AdsManager

					<td> 
					<h3 class="adsmanager_sub_cat">
					<?php
				}
				else
				{

					<td> 
					<h3 class="adsmanager_sub_cat">
					<?php
				}
				else
				{
					if ($first == false)
						echo ' <br> ';

					echo '<a href="'.$link.'">'.$row->name. " (". $row->num_ads . ")" . '</a>';
					$first = false;
				}
				if ($level == 0)
				{
					adsmanager_html::recurseCategories( $row->id, $level+1, $children,$itemid,$option);
				}
				if ($level == 0)
				{
					?>
					</h3>
					</td>

function getCatTree(&$tree) {
	global $database;

function getCatTree(&$tree) {
	global $database;
	
	$database->setQuery( "SELECT c.*, count(*) as num_ads,a.id as not_empty ".
					 "FROM #__adsmanager_categories as c ".
					 "LEFT JOIN #__adsmanager_ads as a ON a.category = c.id ".
					 "WHERE c.published = 1 ".
					 "GROUP BY c.id ".
					 "ORDER BY c.parent,c.ordering");

	$database->setQuery( "SELECT c.id, c.name, c.parent, ".
						" (select count(*) ".
						"  from #__adsmanager_ads a ".
						"  where a.category = c.id ".
						"    and a.published = 1 ".
						" ) as num_ads ".
						"FROM #__adsmanager_categories as c ".
						"WHERE c.published = 1 ORDER BY c.ordering");

					 
	$list = $database->loadObjectList();
						 
	// establish the hierarchy of the menu
	$tree = array();
	// first pass - collect children
	if(isset($list))
	{
		foreach ($list as $v ) {
			$pt 	= $v->parent;
			$list_temp 	= @$tree[$pt] ? $tree[$pt] : array();
			array_push( $list_temp, $v );
			$tree[$pt] = $list_temp;
		}
	}
}