ecshop留言板增加字段说明

ecshop留言板添加一项必填项-联系人一、首先要为你的数据库的ecs_comment增加一个字段以存储联系人姓名：可以直接在后台-->数据库管理--->SQL查询里里直接执行以下sql语句:alter table ecs_comment add contact varchar(60) not null default '';此处注意，这条sql语句中的表前缀ecs_要和你网站的前缀一致，不然会报错，如果你不知道你ecshop网站的数据表前缀.二：步骤1. 更改文件message_board.dwt<tr><td align="right">{$lang.message_board_qq}</td><td><input name="msg_qq" type="text" class="inputBg" size="20" value=""/></td></tr><script type="text/javascript">{foreach from=$lang.message_board_js item=item key=key}var {$key} = "{$item}";{/foreach}{literal}function submitMsgBoard(frm){var msg = new Object;er_email = frm.elements['user_email'].value;msg.msg_qq = frm.elements['msg_qq'].value;msg.msg_title = frm.elements['msg_title'].value;msg.msg_content = frm.elements['msg_content'].value;msg.captcha = frm.elements['captcha'] ? frm.elements['captcha'].value : '';var msg_err = '';if (er_email.length > 0){if (!(Utils.isEmail(er_email))){msg_err += msg_error_email + '\n';}}else{msg_err += msg_empty_email + '\n';}if (msg.msg_title.length == 0){msg_err += msg_title_empty + '\n';}if (frm.elements['captcha'] && msg.captcha.length==0){msg_err += msg_captcha_empty + '\n'}if (msg.msg_content.length == 0){msg_err += msg_content_empty + '\n'}if (msg.msg_qq.length == 0){msg_err += 'QQ不能为空\n';}if (msg.msg_title.length > 200){msg_err += msg_title_limit + '\n';}if (msg_err.length > 0){alert(msg_err);return false;}else{return true;}}{/literal}</script>步骤 2. 更改文件message.php$message = array('user_id' => $user_id,'user_name' => $user_name,'user_email' => isset($_POST['user_email']) ? htmlspecialchars(trim($_POST['user_email'])) : '','msg_qq' => isset($_POST['msg_qq']) ? trim($_POST['msg_qq']) : '','msg_type' => isset($_POST['msg_type']) ? intval($_POST['msg_type']) : 0,'msg_title' => isset($_POST['msg_title']) ? trim($_POST['msg_title']) : '','msg_content' => isset($_POST['msg_content']) ? trim($_POST['msg_content']) : '','order_id' => 0,'msg_area' => 1,'upload' => array());步骤 2. 更改文件lib_clips.php$message['msg_area'] = isset($message['msg_area']) ? intval($message['msg_area']) : 0;$sql = "INSERT INTO " . $GLOBALS['ecs']->table('feedback') ." (msg_id, parent_id, user_id, user_name, user_email,msg_qq,msg_title, msg_type, msg_status, msg_content, msg_time, message_img, order_id, msg_area)"." VALUES (NULL, 0, '$message[user_id]', '$message[user_name]', '$message[user_email]', "." '$message[msg_qq]','$message[msg_title]', '$message[msg_type]', '$status', '$message[msg_content]', '".gmtime()."', '$img_name', '$message[order_id]', '$message[msg_area]')";$GLOBALS['db']->query($sql);这个文件一定要处理，否则数据没有写进去图例：图一图二这时数据库中已有数据了，然后我们要在后台给他调用出来：打开admin/user_msg.php,把/***** @access public* @param** @return void*/function msg_list(){/* 过滤条件*/$filter['keywords'] = empty($_REQUEST['keywords']) ? '' : trim($_REQUEST['keywords']);if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {$filter['keywords'] = json_str_iconv($filter['keywords']);}$filter['msg_type'] = isset($_REQUEST['msg_type']) ? intval($_REQUEST['msg_type']) : -1;$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'f.msg_id' : trim($_REQUEST['sort_by']);$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);$where = '';if ($filter['keywords']){$where .= " AND f.msg_title LIKE '%" . mysql_like_quote($filter['keywords']) . "%' ";}if ($filter['msg_type'] != -1){$where .= " AND f.msg_type = '$filter[msg_type]' ";}$sql = "SELECT count(*) FROM " .$GLOBALS['ecs']->table('feedback'). " AS f" ." WHERE parent_id = '0' " . $where;$filter['record_count'] = $GLOBALS['db']->getOne($sql);/* 分页大小*/$filter = page_and_size($filter);$sql = "SELECT f.msg_id, er_name, f.contact, f.msg_title, f.msg_type, f.order_id, f.msg_status, f.msg_time, f.msg_area, COUNT(r.msg_id) AS reply " ."FROM " . $GLOBALS['ecs']->table('feedback') . " AS f "."LEFT JOIN " . $GLOBALS['ecs']->table('feedback') . " AS r ON r.parent_id=f.msg_id "."WHERE f.parent_id = 0 $where " ."GROUP BY f.msg_id "."ORDER by $filter[sort_by] $filter[sort_order] "."LIMIT " . $filter['start'] . ', ' . $filter['page_size'];$msg_list = $GLOBALS['db']->getAll($sql);foreach ($msg_list AS $key => $value){ if($value['order_id'] > 0){$msg_list[$key]['order_sn'] = $GLOBALS['db']->getOne("SELECT order_sn FROM " . $GLOBALS['ecs']->table('order_info') ." WHERE order_id= " .$value['order_id']);}$msg_list[$key]['msg_time'] = local_date($GLOBALS['_CFG']['time_format'], $value['msg_time']); $msg_list[$key]['msg_type'] = $GLOBALS['_LANG']['type'][$value['msg_type']];}$filter['keywords'] = stripslashes($filter['keywords']);$arr = array('msg_list' => $msg_list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);return $arr;}b、打开admin/templates/msg_list.htm 把<td align="center">{$er_name}</td>改成<td align="center">{$er_name}<br />{$msg.contact}</td>到这就全部完成了，大家试下吧，这个保证能用，这个是在教学中学生常问到的问题，所整理成一个文档方式，转载请注明。