此文原来是我发在ECSHOP官方论坛里的,旨在讲解如何在ECSHOP的栏目页(商品列表页)显示每个商品的品牌名称,并且末尾附上了“插件下载”地址,直接下载后解压覆盖即可。
- z! X6 t# U6 F# A4 l$ {5 o7 G7 {$ I) X- ]7 \1 w J6 w: m
1、首先修改 category.php 文件
, W6 S7 `, \9 R: b0 p- K: j将$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, ' . | 8 _5 A- p6 @/ L3 H% @
修改为
1 R1 @' Z/ ?5 v- w$sql = 'SELECT g.goods_id, g.goods_name, b.brand_name , g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ' . | / G" C, j; u \& ~1 D7 X$ ^/ L
找到"ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " . |
* @# K6 z5 u( W在它下面增加一行
- Q# _* P2 d3 \& M" ^" LEFT JOIN ". $GLOBALS['ecs']->table('brand') . " AS b on b.brand_id = g.brand_id " . | * A6 f, }0 I _# V7 G8 I1 U
继续,找到$arr[$row['goods_id']]['name'] = $row['goods_name']; |
6 J# L( J9 Y7 W7 o) |" e! K6 p在它下边增加一行
- W) o7 I) }$ ~; C$arr[$row['goods_id']]['brand_name'] = $row['brand_name']; |
8 `5 L1 p9 N; K2、
, O" \) M- q6 i2 V9 B& [0 v5 Q- C9 u: ~. J
接下来打开模板库文件 /themes/default/library/goods_list.lbi
9 Y# }* y# i4 X7 {; V2 ]( d想在哪显示品牌就在哪加入下面的代码
" i5 a+ W* [# u* ` {$goods.brand_name}+ X7 y' w7 U' ]+ ?* C- P+ ^7 a5 v. E
4 x2 _" L( i8 t2 c b- w0 E3、
# Z4 q# O6 P% [% r" a. G如果你的ECSHOP是全新安装的 ECShop_V2.7.2 (UTF8_Release0604),
5 r4 C. ~4 J; r可以直接在下面地址下载修改好的插件,下载后直接解压覆盖即可7 c# I( y3 s2 N; ^
8 D8 a& s( Y: N6 |& F# F下载“ECSHOP商品列表页品牌插件”
0 W3 l b5 @) R: A!qinai!游客!yincang_youke!
$ o; g, R; a4 C# s# W4 Y) i% a- Q! i, p
|