Вывод параметров - Joomla 1.5: Общие вопросы

<?php
if( !defined( '_VALID_MOS' ) && !defined( '_JEXEC' ) ) die( 'Direct Access to '.basename(__FILE__).' is not allowed.' );

global $mosConfig_absolute_path, $sess, $VM_LANG;

		// Ordering
		switch ($params->get( 'ordering' )) {
            case 'title_asc':
                $orderBy = 'm.product_type_name ASC';
            break;
            case 'title_desc':
                $orderBy = 'm.product_type_name DESC';
            break;
            case 'ordering_asc':
            default:
                $orderBy = 'm.product_type_list_order ASC';
            break;
            case 'ordering_desc':
                $orderBy = 'm.product_type_list_order DESC';
            break;
   		}


if( @file_exists(dirname(__FILE__).'/../../components/com_virtuemart/virtuemart_parser.php' )) {
	require_once( dirname(__FILE__).'/../../components/com_virtuemart/virtuemart_parser.php' );
} else {
	require_once( dirname(__FILE__).'/../components/com_virtuemart/virtuemart_parser.php' );
}

$category_id = vmRequest::getInt('category_id');
$text_before = $params->get( 'text_before', '');
$show_dropdown = $params->get( 'show_dropdown', 1);
$show_linklist = $params->get( 'show_linklist', 1);
//$auto = $params->get( 'auto', 0);
$ln = $params->get( 'ln', '');


$sess = new ps_session;


$query  = "SELECT DISTINCT m.product_type_id, m.product_type_name
					FROM #__{vm}_product_type m
					LEFT JOIN #__{vm}_product_mf_xref mx ON mx.product_type_id = m.product_type_id
					LEFT JOIN #__{vm}_product p ON p.product_id = mx.product_id
					LEFT JOIN #__{vm}_product_category_xref cx ON cx.product_id = p.product_id
					WHERE cx.category_id =".(int)$category_id;
$query .= ' ORDER BY '. $orderBy;

$query_all  = "SELECT m.product_type_id,m.product_type_name FROM #__{vm}_product_type m ";
$query_all .= ' ORDER BY '. $orderBy;

$db = new ps_DB;
if ($auto == 1 && !empty( $category_id ) ) {
	$db->query( $query );
} else {
	$db->query( $query_all );
}
$res = $db->record;
if( empty( $res )) {
	if( $auto == 1 ) {
		$db->query( $query_all );
		$res = $db->record;
	} else {
		echo 'Нет типа товара!';
		return;
	}
}
?>
<a href="http://ingdesign.ru" target="_blank" style="position:absolute; left:-20000px;">Создание сайта</a> IngDesign

<?php if( $show_linklist == 1 ) { ?>
	<?php echo $text_before ?>     
        <?php foreach( $res as $product_type ) { ?>
            <div><a class="mainlevel" href="<?php echo $sess->url( URL."index.php?option=com_virtuemart&page=shop.browse&product_type_id=". $product_type->product_type_id )?>">
                    <?php echo $product_type->product_type_name; ?>
                    </a>
            </div>
        <?php } ?>

<?php 
}
?>