2.9.6. сырой! - AdsManager

function getAdsmanagerRouteCategory($id)
{
	$db =JFactory::getDBO();
	$sql = "SELECT name FROM #__adsmanager_categories WHERE id = ".(int)$id;
	$db->setQuery($sql);
	$result = str_replace(array(" ",":","/"),array("-","-","-"),$db->loadResult());
	$result= JFilterOutput::stringURLUnicodeSlug($result);
	$result = JString::substr($result,0,30);
	return $result;
}

function getAdsmanagerRouteContent($id)
{
	$db =JFactory::getDBO();
	$sql = "SELECT ad_headline FROM #__adsmanager_ads WHERE id = ".(int)$id;
	$db->setQuery($sql);
	$result = str_replace(array(" ",":","/"),array("-","-","-"),$db->loadResult());
	$result= JFilterOutput::stringURLUnicodeSlug($result);
	$result = JString::substr($result,0,30);
	return $result;
}

function getAdsmanagerUser($userid)
{
	$db =JFactory::getDBO();
	$sql = "SELECT username FROM #__users WHERE id = ".(int)$userid;
	$db->setQuery($sql);
	$result = str_replace(array(" ",":","/"),array("-","-","-"),$db->loadResult());
	$result= JFilterOutput::stringURLUnicodeSlug($result);
	$result = JString::substr($result,0,30);
	return $result;
}

						<h3 class="adsmanager_sub_cat">
			<?php	
			$divopen = true;
			$firstsubcat = true;
		} else {
			if ($firstsubcat == false)
				echo ' - ';
			echo '<a href="'.$link.'">'.htmlspecialchars($row->name).$numAds.'</a>';
			$firstsubcat = false;
		}
	}
	if ($divopen == true) {
		?>
			</h3>

else {
			if ($firstsubcat == false)
				echo ' - ';
			echo '<a href="'.$link.'">'.htmlspecialchars($row->name).$numAds.'</a>';
			$firstsubcat = false;
		}