нашелся вот такой код как из него сделать модуль?
<?php
defined( '_VALID_MOS' ) or die( 'Прямой доступ запрещен.' );
/**
* Best selling Products module for VirtueMart
* @version $Id: mod_virtuemart_topten.php,v 1.4 2005/10/19 09:01:09 codename-matrix Exp $
* @package VirtueMart
* @subpackage modules
*
* @copyright (C) John Syben (john@webme.co.nz)
* Conversion to Mambo and the rest:
* @copyright (C) 2004-2005 Soeren Eberhardt
*
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* VirtueMart is Free Software.
* VirtueMart comes with absolute no warranty.
*
* www.virtuemart.net
* Перевод Федоринов Григорий virtuemart.ru
*----------------------------------------------------------------------
* This code creates a list of the bestselling products
* and displays it wherever you want
*----------------------------------------------------------------------
*/
global $mosConfig_absolute_path, $sess;
/* Load the virtuemart main parse code */
require_once( $mosConfig_absolute_path.'/components/com_virtuemart/virtuemart_parser.php' );
require_once(CLASSPATH.'ps_product.php');
$ps_product = new ps_product;
// change the number of items you wanna haved listed via module parameters
//$num_topsellers = $params->get ('num_topsellers', 10);
$list = "SELECT DISTINCT #__{vm}_product.product_id, product_parent_id,product_name, #__{vm}_category.category_id, category_flypage ";
$list .= "FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category WHERE ";
$q = "#__{vm}_product.product_publish='Y' AND ";
$q .= "#__{vm}_product_category_xref.product_id = #__{vm}_product.product_id AND ";
$q .= "#__{vm}_product_category_xref.category_id = #__{vm}_category.category_id ";
//$q .= "#__{vm}_product.product_sales>0 ";
$q .= "GROUP BY #__{vm}_product.product_name ";
//$q .= "GROUP BY #__{vm}_product.product_id ";
$q .= "ORDER BY #__{vm}_product.product_name";
//$q .= "ORDER BY #__{vm}_product.product_sales DESC";
//$list .= $q . " LIMIT 0, $num_topsellers ";
$list .= $q;
$db = new ps_DB;
$db->query($list);
$i = 0;
?>
<!--10 лучших начало-->
<table border="0" cellpadding="0" cellspacing="0" width="100%" class="menu_bad">
<?php
while ($db->next_record()) {
$flypage = $db->f('category_flypage');
//$tt_item++;
$pid = $db->f("product_parent_id") ? $db->f("product_parent_id") : $db->f("product_id");
?>
<!--<tr class="<?php echo $sectioncolor ?>">-->
<tr>
<!--<td width="15%"><?php printf("%02d", $tt_item); ?></td>-->
<td width="100%">
<li>
<a href="<?php $sess->purl(URL . "index.php?page=shop.product_details&flypage=$flypage&product_id=" . $pid . "&category_id=" . $db->f("category_id")) ?>">
<?php $db->p("product_name"); ?>
</a>
</li>
</td>
</tr>
<?php
} ?>
</table>
<!--10 лучших конец-->
