用户中心留言改为前台商品咨询（User center message changed to front desk commodity consultation）.doc

用户中心留言改为前台商品咨询（User center message changed to front desk commodity consultation） User center message changed to front desk commodity consultation Page reference: Themes/ user template name /goods.dwt modify Themes/ user template name /library/feedback.lbi -- New Themes/ user template name /library/feedback_list.lbi -- New Goods.php modify Includes/lib_clips.php modify Includes/lib_insert.php modify Database related: Increase the field feedback in table goods_id with the user_id type 1. add function get_goods_message_list () in lib_clips.php to get a list of front desk messages Function, get_goods_message_list ($goods_id, $num, $start) { Get message data / * * / $msg = array (); $sql = SELECT * FROM,.$GLOBALS[ecs]-table (feedback); $sql = WHERE parent_id AND goods_id=$goods_idORDER BY msg_time = 0 DESC; $res = $GLOBALS[db]-SelectLimit ($sql, $num, $start); While ($rows = $GLOBALS[db]-fetchRow ($res)) { Get message reply / * * / $reply = array (); $sql = SELECT, user_name, user_email, msg_time, msg_content FROM,.$GLOBALS[ecs]-table (feedback) WHERE, parent_id =, $rows[msg_id]; $reply = $GLOBALS[db]-getRow ($sql); If ($reply) { $msg[$rows[msg_id]][re_user_name] = $reply[user_name]; $msg[$rows[msg_id]][re_user_email] = $reply[user_email]; $msg[$rows[msg_id]][re_msg_time] = local_date ($GLOBALS[_CFG][time_format], $reply[msg_time]); $msg[$rows[msg_id]][re_msg_content] = nl2br (htmlspecialchars ($reply[msg_content])); } $msg[$rows[msg_id]][msg_content] = nl2br (htmlspecialchars ($rows[msg_content])); $msg[$rows[msg_id]][msg_time] = local_date ($GLOBALS[_CFG][time_format], $rows[msg_time]); $msg[$rows[msg_id]][msg_type] = $order_id? $rows[user_name]: $GLOBALS[_LANG][type][$rows[msg_type]]; $msg[$rows[msg_id]][msg_title] = nl2br (htmlspecialchars ($rows[msg_title])); } Return $msg; } 2. add function add_goods_messags () in lib_clips.php for adding messages Function add_goods_message ($message) { $status = 1 - $GLOBALS[_CFG][message_check]; If (empty ($message[msg_title]