1、后台sql查询执行下行数据
ALTER TABLE `ecs_goods_gallery`ADD`img_order`SMALLINT(4)UNSIGNED NOT NULL DEFAULT '50'AFTER`img_original`;
2、修改文件 admin/templates/goods_info.htm 找到以下代码
下一行增加下代码
3、修改文件 admin/goods.php
/* 不保留商品原图的时候删除原图 */ 的上面加以下代码 /* 增加商品相册排序 */
if (!$is_insert && isset($_POST['img_order']))
{
foreach ($_POST['img_order'] AS $img_id => $img_order)
{
$sql = 'UPDATE ' . $ecs->table('goods_gallery') . ' SET img_order = '$img_order' WHERE img_id = '$img_id' LIMIT 1';
$db->query($sql);
}
}
在找到 $sql = 'SELECT * FROM ' . $ecs->table('goods_gallery') . ' WHERE goods_id = '$goods[goods_id]''; 修改为:
$sql = 'SELECT * FROM '.$ecs->table('goods_gallery').' WHERE goods_id = '$goods[goods_id]' ORDER BY img_order ASC';
4、修改文件 includes/lib_goods.php 找到 ' WHERE goods_id = '$goods_id' LIMIT '
修改为:' WHERE goods_id = '$goods_id' ORDER BY img_order ASC LIMIT '
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。