讓ecshop商品列表頁商品顯示一條評(píng)論

1、讓 ecshop 商品列表頁商品顯示一條評(píng)論讓 ecshop 商品列表頁商品顯示一條評(píng)論ecshop 模板網(wǎng) / 2013-06-09 鼠標(biāo)滑過商品 ,下方顯示最新評(píng)論 ;無評(píng)論時(shí)不顯示內(nèi)容 ;打開根目錄 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如果你用的默認(rèn)模板請(qǐng)搜索:<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