Расширенный поиск VirtueMart - [VM1] Модификации и хаки

$where_clause[] = "`product_parent_id`=0 ";

if( empty( $keyword )&&empty($product_type_id )) {
	$where_clause[] = "`product_parent_id`=0 ";
}

 elseif( $product_type_id) {
        $q = ("SELECT Profil, Visota,  Diametr, Sezon FROM #__{vm}_product_type_2 WHERE product_id='$product_id'");
        $db->query($q);
        $db->next_record();
        $Sezon = $db->f("Sezon");
        $tpl->set('Sezon', $Sezon );       
        }

<params>
		<param name="show_dropdown" type="list" default="1"
			label="Show Drop Down List?"
			description="When enabled, shows a Drop-Down List of Manufacturers which links to Products of the specific Manufacturers.">
			<option value="1">Yes</option>
			<option value="0">No</option>
		</param>
		<param name="auto" type="list" default="1"
			label="Automatically select Manufacturers?"
			description="This enables the Auto-Select of those Manufacturers that have Products in the actual Product Category the customer browses in.">
			<option value="1">Yes</option>
			<option value="0">No</option>
		</param>
		<param name="show_name" type="list" default="1"
			label="Show Manufacturers' Names?"
			description="This enables the display of the Manufacturers' names.  Often set to No when showing Manufacturers' images (logos).">
			<option value="1">Yes</option>
			<option value="0">No</option>
		</param>	
		<param name="show_cat" type="list" default="0"
			label="Show Manufacturer Categories?"
			description="This enables the display of the Manufacturer Category names.  The output is sorted alphabetically by Category, then Manufacturer.">
			<option value="1">Yes</option>
			<option value="0">No</option>
		</param>	
		<param name="show_1_cat" type="text" default=""
			label="Show Only This Manufacturer Category"
			description="This causes the display of only the Manufacturers from the specified Category.  Enter the Category Name." />
		<param name="cache" type="radio" default="0"
			label="Enable Cache"
			description="Select whether to cache the content of this module">
			<option value="0">No</option>
			<option value="1">Yes</option>
		</param>
		<param name="moduleclass_sfx" type="text" default=""
			label="Module Class Suffix"
			description="A suffix to be applied to the CSS class of the module (table.moduletable), this allows individual module styling" />
		<param name="class_sfx" type="text" default=""
			label="Menu Class Suffix"
			description="A suffix to be applied to the CSS class of the menu items" />
	</params>

$category_id = vmRequest::getInt( 'category_id' );
$show_dropdown = $params->get( 'show_dropdown', 1 );
$auto = $params->get( 'auto', 0 );
$show_name = $params->get( 'show_name', 1 );
$show_cat = $params->get( 'show_cat', 0 );
$show_1_cat = $params->get( 'show_1_cat', '' );
$moduleclass_sfx = $params->get( 'moduleclass_sfx', 1 );

require_once ( CLASSPATH. 'ps_product.php');
require_once ( CLASSPATH. 'ps_product_product_type.php');
require_once ( CLASSPATH. 'ps_product_type.php');
require_once ( CLASSPATH. 'ps_product_type_parameter.php');

$query  = "SELECT DISTINCT m.manufacturer_id, m.mf_name";
if( $show_cat == 1 ) $query .= ", mc.mf_category_name ";

$query .= "FROM #__{vm}_manufacturer m
	    LEFT JOIN #__{vm}_product_mf_xref mx ON mx.manufacturer_id = m.manufacturer_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";
if( $show_cat == 1 || $show_1_cat != '' ) $query .= " LEFT JOIN #__{vm}_manufacturer_category mc ON mc.mf_category_id = m.mf_category_id ";
$query .= "WHERE cx.category_id =\"".$category_id."\" ";
if( $show_1_cat != '' ) $query  .=	" AND mc.mf_category_name = \"".$show_1_cat."\" ";
$query .= "ORDER BY ";
if( $show_cat == 1 ) $query .= " mc.mf_category_name ASC , ";
$query .= " m.mf_name ASC";

$query_all  = "SELECT m.manufacturer_id,m.mf_name ";
if( $show_cat == 1 ) $query_all .= ", mc.mf_category_name ";
$query_all .= " FROM #__{vm}_manufacturer m ";
if( $show_cat == 1 || $show_1_cat != '' ) $query_all .= " LEFT JOIN #__{vm}_manufacturer_category mc ON mc.mf_category_id = m.mf_category_id ";
if( $show_1_cat != '' ) $query_all .= " WHERE mc.mf_category_name = \"".$show_1_cat."\" ";
$query_all .= " ORDER BY ";
if( $show_cat == 1 ) $query_all .= " mc.mf_category_name ASC , ";
$query_all .= " m.mf_name ASC";

$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 'No manufacturers defined!';
		return;
	}
}

$product_id=$db_browse->f("product_id");
        $ds->query("SELECT Sezon
                    FROM #__{vm}_product_type_2  
                    WHERE product_id='$product_id'" );
        $ds->next_record();
        $sezon = $ds->f("Sezon");
$products[$i]['sezon'] = $sezon;

<?php echo $sezon ?>