Добавить вывод категории в модуль MisterEstate - Магазины, электронная коммерция, доски объявлений

$query = "SELECT id, name"
	. " FROM #__estateagent_categories"
	. " WHERE publish=1 ORDER BY id DESC LIMIT $limit";

# Query the database
$database->setQuery( $query );
$categories = $database->loadObjectList();

foreach($categories as $o) {
$content .="<div>" . $o->name . "</div>";
}

				$id				= intval(mosGetParam( $_REQUEST, 'id', mosGetParam( $_POST, 'id', 0 )));
				
				$query = "SELECT * FROM #__estateagent_categories " 
				. " WHERE parent=$id"
				. " AND access<=$gid"
				. " AND" 
				. " ("
				. " ((publish_up >= '0000-00-00' AND publish_up <= '$today') AND publish_down >= '$today')"
       			. " OR ((publish_up >= '0000-00-00' AND publish_up <= '$today' ) AND (publish_down = '0000-00-00' OR publish_down >= '$today'))"
       			. " OR (publish_up = '0000-00-00' AND publish_down = '0000-00-00')"
       			. " )"
				. " AND publish=1 ORDER BY ordering ASC";
    $database->setQuery($query);
    $cats = $database->loadObjectList();

			
			
			foreach($cats as $cat) { // show maincategories      		
       			if($x%2==0) echo "<tr class='sectiontableentry1'>";
				?>
				<td valign="top" width="50%">
          				<?php
          				if($entries[$x] > 0){
          					echo "<a href='".sefRelToAbs("index.php?option=com_estateagent&act=cat&task=showCE&id=".$cat->id)."'>" . $cat->name ."</a>";
          				}
          				else echo $cat->name;
          				if($params['entries']==1) echo " (" . $entries[$x] . ")";          			
          				?>

foreach($cats as $cat) {