Решение для категорий и меню. - [VM1] Модификации и хаки

$database->setQuery("SELECT *
               FROM `#__menu`
               WHERE `link` LIKE '%com_virtuemart%'
               AND `published` =1");
  $GLOBALS['itemid'] = $database->loadResult();

<?php
global $mosConfig_absolute_path, $VM_LANG,$database;
defined('_JEXEC') or die('Restricted access');
$database = & JFactory::getDBO();
if($mosConfig_absolute_path == ''){
  $mosConfig_absolute_path = dirname( __FILE__ ).'/../..';
}
  $database->setQuery("SELECT *
               FROM `#__menu`
               WHERE `link` LIKE '%com_virtuemart%'
               AND `published` =1"
			   );
  $GLOBALS['itemid'] = $database->loadResult();
// no direct access
$GLOBALS[parentmenuislink] = $params->get( 'parentmenuislink', '0' );
$GLOBALS[rememberlaststate] = $params->get( 'rememberlaststate', '0' );

$document =& JFactory::getDocument();
$document->addScript('media/system/js/mootools.js');
$document->addScript('modules/mod_vm_accordion/script/script.js');
$document->addStyleSheet('modules/mod_vm_accordion/styles/style.css');
require_once('administrator/components/com_virtuemart/classes/ps_database.php');
require_once('administrator/components/com_virtuemart/virtuemart.cfg.php');
$db =& new ps_DB;
$query = 'SELECT DISTINCT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id FROM #__{vm}_category AS a, #__{vm}_category_xref AS f  WHERE a.category_publish="Y" AND a.category_id = f.category_child_id AND f.category_parent_id=\'0\'  ORDER BY a.list_order';
$db->query($query);
while($db->next_record()){
  $rows[] = $db->get_row();
}
$x=0;
if(count($rows) > 0){
  foreach($rows as $row){						
     $query = 'SELECT DISTINCT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id'
     . ' FROM #__{vm}_category AS a, #__{vm}_category_xref AS f'
     . ' WHERE a.category_publish="Y" AND a.category_id = f.category_child_id AND f.category_parent_id='.$row->category_id
     . ' ORDER BY a.list_order';						
     $db->query( $query);
      while($db->next_record()){
        $sub_rows[$x][] = $db->get_row();
      }
        $y=0;
        if(isset($sub_rows[$x]) && count($sub_rows[$x]) > 0){
          foreach($sub_rows[$x] as $row){						
             $query = 'SELECT DISTINCT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id'
             . ' FROM #__{vm}_category AS a, #__{vm}_category_xref AS f'
             . ' WHERE a.category_publish="Y" AND a.category_id = f.category_child_id AND f.category_parent_id='.$row->category_id
             . ' ORDER BY a.list_order';
             $db->query($query);
              while($db->next_record()){
                $sub_rows2[$x][$y][] = $db->get_row();
              }
              $y++;
          }
        }
      $x++;
  }
}else{
  return;
}

if(!function_exists("categoryLink")){
  function categoryLink($catId){
    return JRoute::_('index.php?option=com_virtuemart&page=shop.browse&category_id=' . $catId .'&Itemid='.$GLOBALS['itemid'] ) ;
  }
}
require(JModuleHelper::getLayoutPath('mod_vm_accordion', 'default'));
?>