criar modulo de preço Virtuemart

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


global $mosConfig_absolute_path, $sess, $VM_LANG;

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' );
}
$nome = vmRequest::get('nome');
$show_dropdown = $params->get( 'show_dropdown', 1);
$show_linklist = $params->get( 'show_linklist', 1);
$auto = $params->get( 'auto', 0);

$sess = new ps_session;

$query_all = "SELECT nome FROM jos_preco";
$query = "SELECT DISTINCT p.product_name,pre.product_price FROM jos_vm_product p, jos_vm_product_price pre, jos_preco prc 
		WHERE p.`product_id` = pre.`product_id` 
		AND pre.`product_price` > prc.`preco_ini`
		AND pre.`product_price` < prc.`preco_fim`";


$db = new ps_DB;
if ($auto == 1 && !empty( $nome ) ) {
	$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 'Não há preços definidos';
		return;
	}
}
?>
<?php if( $show_linklist == 1 ) { ?>
    
        <?php foreach( $res as $nome) { ?>
            <div><a href="<?php echo $sess->url( URL."index.php?option=com_virtuemart&page=shop.browse&nome". $nome->nome ) ?>">
                    <?php echo $nome->nome; ?>
                    </a>
            </div>
        <?php } ?>

<?php 
}
?>