Сортировка товаров категории по алфавиту - [VM1] Модификации и хаки

	<?php foreach($products AS $product) : ?>
		<?php $class = JRequest::getVar('product_id') == $product['product_id'] ? 'class="active"' : ''; ?>
		<a <?php echo $class; ?> href="<?php echo JRoute::_('index.php?option=com_virtuemart&category_id='.JRequest::getVar('category_id').'&flypage=flypage.tpl&page=shop.product_details&product_id='.$product['product_id']); ?>">
			<?php echo $product['product_name']; ?>
		</a>
		<br>
	<?php endforeach; ?>

sort($products)

$cats = array();

$where = '';
if($params->get('published') == 0) {
	$where = " AND p.product_publish = 'Y'";
}

$db =& JFactory::getDBO();
$query = "SELECT * FROM #__vm_product_category_xref AS pcx LEFT JOIN #__vm_product AS p ON pcx.product_id = p.product_id WHERE pcx.category_id = ".JRequest::getVar('category_id').$where;
$db->setQuery($query);
$products = $db->loadAssocList();

if(!$products) return;

function getCategory($category_id, &$cats)
{
	$db =& JFactory::getDBO();
	$query = "SELECT cx.category_parent_id, c.category_name FROM #__vm_category_xref AS cx LEFT JOIN #__vm_category AS c ON cx.category_parent_id = c.category_id WHERE cx.category_child_id = ".$category_id;
	$db->setQuery($query);
	$cat = $db->loadAssoc();
	$cats[] = $cat;
	
	if($cat['category_parent_id'] != 0) {
		return getCategory($cat['category_parent_id'], $cats);
	} else {
		return $category_id;
	}
}

	<?php
	$query = "SELECT category_name FROM #__vm_category WHERE category_id = ".JRequest::getVar('category_id');
	$db->setQuery($query);
	$category_name = $db->loadResult();
	
	$query = "SELECT c.category_id FROM #__vm_category_xref AS cx LEFT JOIN #__vm_category AS c ON cx.category_child_id = c.category_id WHERE cx.category_parent_id = ".$bootomCat." AND c.category_name = '".$cats[0]['category_name']."'";
	$db->setQuery($query);
	$catId = $db->loadResult();
	
	$query = "SELECT c.category_id FROM #__vm_category_xref AS cx LEFT JOIN #__vm_category AS c ON cx.category_child_id = c.category_id WHERE cx.category_parent_id = ".$catId." AND c.category_name = '".$category_name."'";
	$db->setQuery($query);
	$catId = $db->loadResult();
	
	$query = "SELECT * FROM #__vm_product_category_xref AS pcx LEFT JOIN #__vm_product AS p ON pcx.product_id = p.product_id WHERE pcx.category_id = ".$catId.$where;
	$db->setQuery($query);
	$products = $db->loadAssocList();
	if(!$products) {
		echo '</div>';
		return;
	}
	?>

$query = "SELECT * FROM #__vm_product_category_xref AS pcx LEFT JOIN #__vm_product AS p ON pcx.product_id = p.product_id WHERE pcx.category_id = ".$catId.$where." ORDER BY p.product_name ASC";