让ecshop商品列表页商品显示一条评论

1、让 ecshop 商品列表页商品显示一条评论让 ecshop 商品列表页商品显示一条评论ecshop 模板网 / 2013-06-09 鼠标滑过商品 ,下方显示最新评论 ;无评论时不显示内容 ;打开根目录 category.php大约447-455 行之间将/* 获得商品列表*/$sql = 'SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ' ."INULLmp.

2、user_price, g.shop_price * '$_SESSIONdiscount') AS shop_price, mote_price, g.goods_type, " .'mote_start_date,mote_end_date, g.goods_brief, g.goods_thumb ,g.goods_img ' .'FROM ' .$GLOBALS'ecs'->table('goods') . ' AS g ' .'

3、LEFT JOIN ' .$GLOBALS'ecs'->table('member_price') . ' AS mp ' . "ON mp.goods_id = g.goods_id ANDmp.user_rank = '$_SESSIONuser_rank' " ."WHERE $where $ext ORDER BY $sort$order"$res = $GLOBALS'db'->sel ectLimit($sql, $size,

4、($page - 1) * $size);替换为/* 获得商品列表*/$sql = 'SELECTg.goods_id,c.id_value,c.user_name,c.content,g.goods_name, g.goods_name_style, g.market_price,g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ' ."IFNULL(mp.user_price, g.shop_price * '$_SESSIONdiscount') AS shop_price, g.

5、promote_price, g.goods_type, " .'mote_start_date,mote_end_date, g.goods_brief, g.goods_thumb ,g.goods_img ' .'FROM ' .$GLOBALS'ecs'->table('goods') . ' AS g ' .'LEFT JOIN ' .$GLOBALS'ecs'->table('comment') .

6、 ' AS c ON c.id_value = g.goods_id ' .'LEFT JOIN ' .$GLOBALS'ecs'->table('member_price') . ' AS mp '."ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSIONuser_rank' " ."WHERE $where $ext ORDER BY $sort$order"$res = $GLOB

7、ALS'db'->sel ectLimit($sql, $size, ($page - 1) * $size);然后搜索如下代码:$arr$row'goods_id''name'= $row'goods_name'在其下方添加 :$arr$row'goods_id''uname' = $row'user_name'$arr$row'goods_id''ucon'= $row'content'然后打开 :根目录 /thmes

8、/ 你的模板 /library/goods_list.lib如果你用的默认模板请搜索:<a href="javascript:;" id="compareLink"onClick="Compare.add($goods.goods_id,'$goods.goods_name|escape:"html"','$goods.type')"class="f6">$pare</a>在其下方添加如下代码:<!-if $goods.uname neq ''-><p class="rlcl"><em>$goods.uname:</em>$g