ecshop教程之留言板不显示评论

对于客户量较多的网店容易出现问题，因为商品评论很多，留言本上就会显示商品评论，这样就会对商家的形象或多或少有些影响，而留言版就很难被浏览者找出来，下面就针对这个问题，给大家介绍一个方法使用户留言只显示留言不显示评论。问学堂
修改方法:
打开messgage.php
在119--122行代码：
   $sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('comment')." WHERE STATUS =1 AND comment_type =0 ";
    $record_count = $db->getOne($sql);
    $sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('feedback')." WHERE `msg_area`='1' AND `msg_status` = '1' ";
    $record_count += $db->getOne($sql);
修改为代码:   
$sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('comment')." WHERE
STATUS =1 AND comment_type =0 ";

    //$record_count = $db->getOne($sql);

    $sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('feedback')." WHERE `msg_area`='1' AND `msg_status` = '1' ";

    $record_count = $db->getOne($sql);
在149--156行找到代码：   
$sql = "(SELECT 'comment' AS tablename,   comment_id AS ID, content AS msg_content, null AS msg_title, add_time AS msg_time, id_value AS id_value, comment_rank AS comment_rank, null AS message_img, user_name AS user_name, '6' AS msg_type ";
    $sql .= " FROM " .$GLOBALS['ecs']->table('comment');
    $sql .= "WHERE STATUS =1 AND comment_type =0) ";
    $sql .= " UNION ";
    $sql .= "(SELECT 'feedback' AS tablename, msg_id AS ID, msg_content AS msg_content, msg_title AS msg_title, msg_time AS msg_time, null AS id_value, null AS comment_rank, message_img AS message_img, user_name AS user_name, msg_type AS msg_type ";
    $sql .= " FROM " .$GLOBALS['ecs']->table('feedback');
    $sql .= " WHERE `msg_area`='1' AND `msg_status` = '1') ";
    $sql .= " ORDER BY msg_time DESC ";
修改为:
    $sql = "SELECT 'feedback' AS tablename, msg_id AS ID, msg_content AS msg_content, msg_title AS msg_title, msg_time AS msg_time, null AS id_value, null AS comment_rank, message_img AS message_img, user_name AS user_name, msg_type AS msg_type ";

    $sql .= " FROM " .$GLOBALS['ecs']->table('feedback');

    $sql .= " WHERE `msg_area`='1' AND `msg_status` = '1' ";

    $sql .= " ORDER BY msg_time DESC ";

好了，这样就实现了用户留言只显示留言不显示评论的效果了，希望能帮助到大家。物流

正好在学习这个内容，多谢楼主分享

已经收藏, 多谢分享!

我想知道为什么我设置商品属性，详细页面不显示呀

看看

可能是路径问题  可以看看