ecshop2.71修改所有品牌为去掉过滤不用加brand.php?=这个条件

ecshop2.71修改所有品牌为去掉过滤不用加brand.php?=这个条件

2011-10-16 07:07:46

标签：职场 休闲 ecshop 所有品牌

 

修改 includes/lib_common.php 文件的 get_brands()函数部分

将
$sql = "SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag ".
            "FROM " . $GLOBALS['ecs']->table('brand') . "AS b, ".
                $GLOBALS['ecs']->table('goods') . " AS g ".
            "WHERE g.brand_id = b.brand_id $children AND is_show = 1 " .
            " AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ".
            "GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC";

修改为

$sql="select brand_id,brand_name,brand_logo, brand_desc,IF(brand_logo > '', '1', '0') AS tag FROM " . $GLOBALS['ecs']->table('brand');