zencart lightinthbox GIFT2006模板多语言产品重复显示问题

时间:12-08-06 栏目:问题及解决 作者:admin 评论:0 点击: 8,209 次

GIFT2006 zencart模板添加多语言数据后,分类显示重复,产品列表显示重复的解决方法参考下面的步骤:

 

打开:/includes/templates/slucky/sideboxes/tpl_categories.php
修改:

$subcategories_query = "select c.categories_id
from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
where c.parent_id = '" . (int)$cPath_array[$ii-1]. "'and c.categories_id = cd.categories_id and c.categories_status= '1' and cd.language_id=".(int)$_SESSION['languages_id'] ." order by c.sort_order,cd.categories_name ";

打开:/includes/index_filters/default_filter.php
修改:
left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id AND mi.languages_id = pd.language_id

 

产品页:

打开:/includes/templates/slucky/templates/tpl_product_flash_page.php
修改:
$flash_page_query = "select p.products_id,p.products_image,pd.products_name from " . TABLE_PRODUCTS ." p, ". TABLE_PRODUCTS_DESCRIPTION . " pd where p.`products_id`=pd.`products_id` AND master_categories_id = " . zen_get_products_category_id($products_id)." order by p.products_recommend DESC,p.products_sort_order,p.products_id desc";
为:
$flash_page_query = "select p.products_id,p.products_image,pd.products_name from " . TABLE_PRODUCTS ." p, ". TABLE_PRODUCTS_DESCRIPTION . " pd where p.`products_id`=pd.`products_id` AND master_categories_id = " . zen_get_products_category_id($products_id)." and pd.language_id=".(int)$_SESSION['languages_id'] ." order by p.products_recommend DESC,p.products_sort_order,p.products_id desc";

 

另有我以前一遍文章《2011新版Lightinthebox使用多语言后菜单重复问题的解决》可参考。

 

 

声明: 本文由( admin )原创编译,转载请保留链接: zencart lightinthbox GIFT2006模板多语言产品重复显示问题

zencart lightinthbox GIFT2006模板多语言产品重复显示问题:等您坐沙发呢!

发表评论


------====== 本站公告 ======------
联系信息:
电话:19970108113(微信同号) QQ:3142401606
支付宝:https://me.alipay.com/lxq73061
相关插件程序等信息均会在站内发布,敬请关注。

读者排行