fjbern1943:
Apparently the plugin is not setup for more than one language. Could this be fixed??????
includes/modules/pages/manufacturers_all/header_php.php
Change from
if (!MANUFACTURERS_ALL_ABOUT_EMPTY_SHOW) { // only show manufacturers with products
$manufacturers_all_sql = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id
left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and m.manufacturers_id = p.manufacturers_id
and m.manufacturers_status = 1
and (p.products_status = 1
and p.products_quantity > 0) " .
$order_by;
} else { // show all manufacturers
$manufacturers_all_sql = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and m.manufacturers_status = 1 " .
$order_by;
}
to
if (!MANUFACTURERS_ALL_ABOUT_EMPTY_SHOW) { // only show manufacturers with products
$manufacturers_all_sql = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.languages_id, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id
left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and mi.languages_id = '" . (int)$_SESSION['languages_id'] . "'
and m.manufacturers_id = p.manufacturers_id
and m.manufacturers_status = 1
and (p.products_status = 1
and p.products_quantity > 0) " .
$order_by;
} else { // show all manufacturers
$manufacturers_all_sql = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.languages_id, mi.manufacturers_url, mi.manufacturers_about
from (" . TABLE_MANUFACTURERS . " m
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
where m.manufacturers_id = mi.manufacturers_id
and mi.languages_id = '" . (int)$_SESSION['languages_id'] . "'
and m.manufacturers_status = 1 " .
$order_by;
}
To prevent the manufacturers from showing twice in admin
YOURADMIN/manufacturers.php
Change
// bof Manufacturers_All_About v1.1 also get manufacturers_info
// $manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from " . TABLE_MANUFACTURERS . " order by manufacturers_name";
$manufacturers_query_raw = "SELECT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, m.manufacturers_status, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
FROM (" . TABLE_MANUFACTURERS . " m
LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
ORDER by $disp_order";
// eof Manufacturers_All_About v1.1 also get manufacturers_info
To
// bof Manufacturers_All_About v1.1 also get manufacturers_info
// $manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from " . TABLE_MANUFACTURERS . " order by manufacturers_name";
$manufacturers_query_raw = "SELECT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, m.manufacturers_status, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
FROM (" . TABLE_MANUFACTURERS . " m
LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
WHERE mi.languages_id = '" . (int)$_SESSION['languages_id'] . "'
ORDER by $disp_order";
// eof Manufacturers_All_About v1.1 also get manufacturers_info
