Доработать расширение AlphaContent для Xmap - Xmap

	
function getArticles(&$xmap, &$parent, $ddCategoryId, &$params) {
		$db = JFactory::getDBO();
		$db->setQuery("SELECT a.id, a.title, a.sectionid, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END as catslug, a.catid, UNIX_TIMESTAMP(a.created) AS created FROM #__content as a INNER JOIN #__categories as cat ON cat.id=a.catid WHERE a.catid = $ddCategoryId ORDER BY a.title");
		$rows = $db->loadObjectList();

		$xmap->changeLevel(1);


		foreach($rows as $row) {
			$node = new stdclass();
			$node->id = $parent->id;	
			$node->uid = $parent->uid.'h'.$row->id;        
			$node->name = $row->title;
			$node->priority = $params['ddArticles_priority'];
			$node->changefreq = $params['ddArticles_changefreq'];
			$node->link = 'index.php?option=com_content&view=article&Itemid=0&id='.$row->slug.'&catid='.$row->catslug; 
			$node->browserNav = $parent->browserNav;
			$node->modified = $row->created;			
			$xmap->printNode($node);		     
		}	
		$xmap->changeLevel(-1);
	}