LYECS LYECS电商系统 老杨商城系统 ECSHOP二次开发
手机版会员中心首页评论数显示错误的BUG修复
LYECS,LYECS+商城系统,多用户商城系统,开源商城系统 发布日期：2016-05-24 作者：老杨
includes/ly_add.php
找到：
//会员留言回复数
function get_count_user_message($user_id){
$sql = "SELECT count(a.msg_id) FROM ".$GLOBALS['ecs']->table( "feedback" )." AS a".
" LEFT JOIN ".$GLOBALS['ecs']->table( "feedback" ). " AS b ON a.parent_id =b.msg_id".
" WHERE b.user_id= '$user_id' AND b.order_id=0 AND a.msg_title='reply' AND a.is_saw=0 ";
$count = $GLOBALS['db']->getOne( $sql );
return $count >0 ? $count : 0;
}
替换为：
function get_count_user_message($user_id){
$sql = "SELECT count(comment_id) FROM ".$GLOBALS['ecs']->table( "comment" )." WHERE user_id= '$user_id' ";
$count = $GLOBALS['db']->getOne( $sql );
return $count >0 ? $count : 0;
}
