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

 <?php $uniSearch->list_category($cid, "catid[]", $conf['viev_category'], 'mod_'); ?>

<?php $uniSearch->list_type($types, $product_type_ids, $conf['viev_type'], 'mod_'); ?>

 $q = "SELECT distinct `product_id` FROM #__{vm}_product_type_" . $param_id . " ";

Notice: Undefined index: viev_category in site\components\com_vm_ext_search_free\vm_ext_search_free.php on line 66

<?php $uniSearch->list_category($cid, "catid[]", $conf['viev_category']); ?>

<?php $uniSearch->list_category($cid, "catid[]", ''); ?>

Notice: Undefined variable: param_id in site\components\com_vm_ext_search_free\files\unisearch.php on line 406

   $q = "SELECT distinct `product_id` FROM #__{vm}_product_type_" . $param_id . " ";

$q = "SELECT #__{vm}_product.product_id, #__{vm}_product.product_parent_id, #__{vm}_product.product_thumb_image, ";

<?php echo $db->f("столбец производителя")?>

$q = "SELECT `#__{vm}_manufacturer`.`mf_name`
FROM `#__{vm}_product` LEFT JOIN (`#__{vm}_product_mf_xref` LEFT JOIN `#__{vm}_manufacturer` ON `#__{vm}_product_mf_xref`.`manufacturer_id` = `#__{vm}_manufacturer`.`manufacturer_id`) ON `#__{vm}_product`.`product_id` = `#__{vm}_product_mf_xref`.`product_id`
WHERE (((`#__{vm}_product`.`product_id`)='ид товара'))";

$query  = "SELECT DISTINCT m.manufacturer_id, m.mf_name
					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
					WHERE cx.category_id =".(int)$category_id;
$query .= " ORDER BY m.mf_name ASC";

$query_all  = "SELECT m.manufacturer_id,m.mf_name FROM #__{vm}_manufacturer m ";
$query_all .= "ORDER BY m.mf_name ASC";