Нашел решение.
В подробности вдаваться не буду, выложу сразу алгоритмом.
Кому интересно, вот оригинал:
http://forum.virtuemart.net/index.php?topic=48371.0От себя - огромное тебе спасибо, BUNAK.
1. Файл shop_browse_queries.php1.1. Находим код:// These are the names of all fields we fetch data from
$fieldnames = "`product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`#__{vm}_category`.`category_id`,
`#__{vm}_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`#__{vm}_product`.`mdate`, `#__{vm}_product`.`cdate`";
И меняем его на указанный ниже:// These are the names of all fields we fetch data from
$fieldnames = "
`product_name`,
`products_per_row`,
`category_browsepage`,
`category_flypage`,
`#__{vm}_category`.`category_id`,
`#__{vm}_product`.`product_id`,
`product_full_image`,
`product_thumb_image`,
`product_s_desc`,
`product_parent_id`,
`product_publish`,
`product_in_stock`,
`product_sku`,
`product_url`,
`product_weight`,
`product_weight_uom`,
`product_length`,
`product_width`,
`product_height`,
`product_lwh_uom`,
`product_in_stock`,
`product_available_date`,
`product_availability`,
`#__{vm}_product`.
`mdate`,
`#__{vm}_product`.`cdate`,
`#__{vm}_manufacturer`.`manufacturer_id`,
`#__{vm}_manufacturer`.`mf_name`";
1.2. Находим код:if( $perm->is_registered_customer($auth['user_id']) ) {
$where_clause[] = "(`#__{vm}_product`.`product_id`=`#__{vm}_product_price`.`product_id` OR `#__{vm}_product_price`.`product_id` IS NULL) ";
$join_array[] = 'LEFT JOIN `#__{vm}_shopper_vendor_xref` ON (`#__{vm}_shopper_vendor_xref`.`user_id` ='.$auth['user_id'].' AND `#__{vm}_shopper_vendor_xref`.`shopper_group_id`=`#__{vm}_shopper_group`.`shopper_group_id`)';
}
else {
$where_clause[] = "((`#__{vm}_product`.`product_id`=`#__{vm}_product_price`.`product_id` AND `#__{vm}_shopper_group`.`shopper_group_id`=`#__{vm}_product_price`.`shopper_group_id`) OR `#__{vm}_product_price`.`product_id` IS NULL) ";
$where_clause[] = '`#__{vm}_shopper_group`.`default` = 1';
}
Сразу после него добавляем:$join_array[] = 'LEFT JOIN `#__{vm}_product_mf_xref` ON `#__{vm}_product_mf_xref`.`product_id` = `#__{vm}_product`.`product_id`';
$join_array[] = 'LEFT JOIN `#__{vm}_manufacturer` ON `#__{vm}_manufacturer`.`manufacturer_id` = `#__{vm}_product_mf_xref`.`manufacturer_id`';
Должно получится так:if( $perm->is_registered_customer($auth['user_id']) ) {
$where_clause[] = "(`#__{vm}_product`.`product_id`=`#__{vm}_product_price`.`product_id` OR `#__{vm}_product_price`.`product_id` IS NULL) ";
$join_array[] = 'LEFT JOIN `#__{vm}_shopper_vendor_xref` ON (`#__{vm}_shopper_vendor_xref`.`user_id` ='.$auth['user_id'].' AND `#__{vm}_shopper_vendor_xref`.`shopper_group_id`=`#__{vm}_shopper_group`.`shopper_group_id`)';
}
else {
$where_clause[] = "((`#__{vm}_product`.`product_id`=`#__{vm}_product_price`.`product_id` AND `#__{vm}_shopper_group`.`shopper_group_id`=`#__{vm}_product_price`.`shopper_group_id`) OR `#__{vm}_product_price`.`product_id` IS NULL) ";
$where_clause[] = '`#__{vm}_shopper_group`.`default` = 1';
}
$join_array[] = 'LEFT JOIN `#__{vm}_product_mf_xref` ON `#__{vm}_product_mf_xref`.`product_id` = `#__{vm}_product`.`product_id`';
$join_array[] = 'LEFT JOIN `#__{vm}_manufacturer` ON `#__{vm}_manufacturer`.`manufacturer_id` = `#__{vm}_product_mf_xref`.`manufacturer_id`';
1.3. Находим код:// GET ALL PUBLISHED PRODUCTS FROM THAT MANUFACTURER
if (!empty($manufacturer_id)) {
$table_names .= ',`#__{vm}_product_mf_xref`';
$where_clause[] = "manufacturer_id='".$manufacturer_id."'";
$where_clause[] = "`#__{vm}_product`.`product_id`=`#__{vm}_product_mf_xref`.`product_id` ";
}
Меняем его на указанный ниже:// GET ALL PUBLISHED PRODUCTS FROM THAT MANUFACTURER
if (!empty($manufacturer_id)) {
// $table_names .= ',`#__{vm}_product_mf_xref`';
$where_clause[] = "`#__{vm}_manufacturer`.`manufacturer_id`='".$manufacturer_id."'";
// $where_clause[] = "`#__{vm}_product`.`product_id`=`#__{vm}_product_mf_xref`.`product_id` ";
}
2. Файл shop.browse.phpНаходим код:$products[$i]['product_url'] = $db_browse->f("product_url");
Следующей строкой добавляем:$products[$i]['manufacturer_name'] = $db_browse->f("mf_name");
Все.
Теперь в нужное нам место в файле browse_listtable.tpl.php вставляем $data[$row][] = $product['manufacturer_name'];