Index: modules/Manufacturers/customer_manufacturers.php
===================================================================
RCS file: /usr/local/cvsroot/eshop/modules/Manufacturers/customer_manufacturers.php,v
retrieving revision 1.12
diff -u -r1.12 customer_manufacturers.php
--- modules/Manufacturers/customer_manufacturers.php 11 Jan 2006 06:56:12 -0000 1.12
+++ modules/Manufacturers/customer_manufacturers.php 19 Apr 2007 13:18:24 -0000
@@ -40,7 +40,7 @@
if ($manufacturers_menu > 0) {
if ($config["Manufacturers"]["manufacturers_limit"] > 0)
$smarty->assign("show_other_manufacturers", $manufacturers_menu>$config["Manufacturers"]["manufacturers_limit"]);
- $manufacturers_menu = func_query("SELECT $sql_tbl[manufacturers].*, IFNULL($sql_tbl[manufacturers_lng].manufacturer, $sql_tbl[manufacturers].manufacturer) as manufacturer, IFNULL($sql_tbl[manufacturers_lng].descr, $sql_tbl[manufacturers].descr) as descr FROM $sql_tbl[manufacturers] USE INDEX (avail) LEFT JOIN $sql_tbl[manufacturers_lng] ON $sql_tbl[manufacturers].manufacturerid = $sql_tbl[manufacturers_lng].manufacturerid AND $sql_tbl[manufacturers_lng].code = '$shop_language' WHERE avail = 'Y' ORDER BY orderby, manufacturer".(($config["Manufacturers"]["manufacturers_limit"] > 0) ? " LIMIT ".$config["Manufacturers"]["manufacturers_limit"] : ""));
+ $manufacturers_menu = func_query("SELECT $sql_tbl[manufacturers].*, IF($sql_tbl[images_M].id IS NULL, '', 'Y') as is_image, $sql_tbl[images_M].image_path, IFNULL($sql_tbl[manufacturers_lng].manufacturer, $sql_tbl[manufacturers].manufacturer) as manufacturer, IFNULL($sql_tbl[manufacturers_lng].descr, $sql_tbl[manufacturers].descr) as descr FROM $sql_tbl[manufacturers] USE INDEX (avail) LEFT JOIN $sql_tbl[manufacturers_lng] ON $sql_tbl[manufacturers].manufacturerid = $sql_tbl[manufacturers_lng].manufacturerid AND $sql_tbl[manufacturers_lng].code = '$shop_language' LEFT JOIN $sql_tbl[images_M] ON $sql_tbl[manufacturers].manufacturerid = $sql_tbl[images_M].id WHERE $sql_tbl[manufacturers].avail = 'Y' ORDER BY $sql_tbl[manufacturers].orderby, $sql_tbl[manufacturers].manufacturer".(($config["Manufacturers"]["manufacturers_limit"] > 0) ? " LIMIT ".$config["Manufacturers"]["manufacturers_limit"] : ""));
$smarty->assign("manufacturers_menu", $manufacturers_menu);
}
Index: skin1/modules/Manufacturers/menu_manufacturers.tpl
===================================================================
RCS file: /usr/local/cvsroot/eshop/skin1/modules/Manufacturers/menu_manufacturers.tpl,v
retrieving revision 1.5
diff -u -r1.5 menu_manufacturers.tpl
--- skin1/modules/Manufacturers/menu_manufacturers.tpl 17 Nov 2005 06:55:47 -0000 1.5
+++ skin1/modules/Manufacturers/menu_manufacturers.tpl 19 Apr 2007 13:18:24 -0000
@@ -2,7 +2,7 @@
{if $manufacturers_menu ne ''}
{capture name=menu}
{section name=mid loop=$manufacturers_menu}
-
+
{/section}
{if $show_other_manufacturers}