修改ecshop随机显示产品分类页面下的产品.doc

修改ecshop随机显示产品分类页面下的产品时间:2011-11-18 11:15来源:未知作者:最模板点击:909次实现ecshop分类下随机显示商品，打破后台规定的按照上架时间，价格、等先后顺序排序，让很多人上传完毕产品，第一页总是显示同类商品，如何修改ecshop随机显示产品分类页面下的产实现ecshop分类下随机显示商品，打破后台规定的按照上架时间，价格、等先后顺序排序，让很多人上传完毕产品，第一页总是显示同类商品，如何修改ecshop随机显示产品分类页面下的产品，最模板告诉你方法：1、下载ecshop并备份你的根目录下的文件category.php文件2、找到如下代码部分，大约在450行：1. /*获得商品列表*/2. $sql=SELECTg.goods_id,g.goods_name,g.goods_name_style,g.market_price,g.is_new,g.is_best,g.is_hot,g.shop_priceASorg_price,.3. “IFNULL(mp.user_price,g.shop_price*$_SESSIONdiscount)ASshop_price,mote_price,g.goods_type,”.4. mote_start_date,mote_end_date,g.goods_brief,g.goods_thumb,g.goods_img.5. FROM.$GLOBALSecs-table(goods).ASg.6. LEFTJOIN.$GLOBALSecs-table(member_price).ASmp.7. “ONmp.goods_id=g.goods_idANDmp.user_rank=$_SESSIONuser_rank”.8. “WHERE$where$extORDERBY$sort$order”;替换修改为1. $zz=1;2. $sql=SELECTg.goods_id,g.goods_name,g.goods_name_style,g.market_price,g.is_new,g.is_best,g.is_hot,g.shop_priceASorg_price,.3. “IFNULL(mp.user_price,g.shop_price*$_SESSIONdiscount)ASshop_price,mote_price,g.goods_type,”.4. mote_start_date,mote_end_date,g.goods_brief,g.goods_thumb,g.goods_img.5. FROM.$GLOBALSecs-table(goods).ASg.6. LEFTJOIN.$GLOBALSecs-table(member_price).ASmp.7. “ONmp.goods_id=g.goods_idANDmp.user_rank=$_SESSIONuser_rank”.8. “WHERE$where$ext”;9. $sql.=$zz=0?”$order”:”ORDERBYRAND()”;即可实现ecshop分类下的产品随机显示了，但是前提是，到后台清空缓存来实现，不能每次刷新都随机，否则服务器会受不了的，这样就实现了和首页精品、新品、促销等栏目同样的功能。通过ecshop清空缓存来实现产品的随机，随机显示竟然会占用服务器过多资源。所以不建议这样优化！ECSHOP首页商品随机排序的三种方法ECSHOP,首页,商品,随机首页商品随机排序的三种方法都是修改inlcudes/lib_goods.php这个文件1 精品推荐新品上架 热卖商品 促销商品 团购商品 拍卖商品 6类随机排序的调整方法将$order_type = 0;改为$order_type = 12修改“分类下的商品”排列顺序为随机将assign_cat_goods这个函数中的sql$sql = SELECT g.goods_id, g.goods_name, g.market_price, g.shop_price AS org_price, . IFNULL(mp.user_price, g.shop_price * $_SESSIONdiscount) AS shop_price, . mote_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img . FROM . $GLOBALSecs-table(goods) . AS g . LEFT JOIN . $GLOBALSecs-table(member_price) . AS mp . ON mp.goods_id = g.goods_id AND mp.user_rank = $_SESSIONuser_rank . WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND . g.is_delete = 0 AND ( . $children . OR . get_extension_goods($children) . ) . ORDER BY g.sort_order, g.goods_id DESC;改为$order_type = 1; $sql = SELECT g.goods_id, g.goods_name, g.market_price, g.shop_price AS org_price, . IFNULL(mp.user_price, g.shop_price * $_SESSIONdiscount) AS shop_price, . mote_price, promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, g.goods_img . FROM . $GLOBALSecs-table(goods) . AS g . LEFT JOIN . $GLOBALSecs-table(member_price) . AS mp . ON mp.goods_id = g.goods_id AND mp.user_rank = $_SESSIONuser_rank . WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND . g.is_delete = 0 AND ( . $children . OR . get_extension_goods($children) . ) ; $sql .= $order_type = 0 ? ORDER BY g.sort_order, g.goods_id DESC : ORDER BY RAND();其实就是在第一行加上一句“$order_type = 1;”，在最后一行的前面加上“$sql .= $order_type = 0 ? ”，后面加上“ : ORDER BY RAND()”，别忘了是在最后的“;”之前3修改“品牌的商品”排列顺序为随机在assign_brand_goods这个函数的前面加入一句“$order_type = 1;”，将该函数下方第五行的“$sql .= ORDER BY g.sort_order, g.goods_id DESC;”改为“$sql .= $order_type = 0 ? ORDER BY g.sort_order, g.goods_id DESC : ORDER BY RAND();”即可就是将function assign_brand_goods($brand_id, $num = 0, $cat_id = 0) $sql =SELECT g.goods_id, g.goods_name, g.market_price, g.shop_price AS org_price, . IFNULL(mp.user_price, g.shop_price * $_SESSIONdiscount) AS shop_price, . mote_price, mote_start_date, mote_end_date, g.goods_brief, g.goods_thumb, g.goods_img . FROM . $GLOBALSecs-table(goods) . AS g . LEFT JOIN . $GLOBALSecs-table(member_price) . AS mp . ON mp.goods_id = g.goods_id AND mp.user_rank = $_SESSIONuser_rank . WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 AND g.brand_id = $brand_id; if ($cat_id 0) $sql .= get_children($cat_id); $sql .= ORDER BY g.sort_order, g.goods_id DESC;改为function assign_brand_goods($brand_id, $num = 0, $cat_id = 0)$order_type = 1; $sql =SELECT g.goods_id, g.goods_name, g.market_price, g.shop_price AS org_price, . IFNULL(mp.user_price, g.shop_price * $_SESSIONdiscount) AS shop_price, . mote_price, mote_start_date, mote_end_date, g.goods_brief, g.goods_thumb, g.goods_img . FROM . $GLOBALSecs-table(goods) . AS g . LEFT JOIN . $GLOBALSecs-table(member_price) . AS mp . ON mp.goods_id = g.goods_id AND mp.user_rank = $_SESSIONuser_rank . WHERE g.is_on_sale = 1 AND g.is_alone_sa