query('DELETE FROM `' . $db_mymps . 'comment` WHERE id = \'' . $id . '\' AND type = \'' . $part . '\'');
write_msg('成功删除编号为' . $id . '的网友评论', 'comment.php?part=' . $part, 'Mymps');
} else {
if ($action == 'delall') {
if (!is_array($id)) {
write_msg('您没有选中任何记录！');
}
$db->query('DELETE FROM `' . $db_mymps . 'comment` WHERE id ' . create_in($id) . ' AND type = \'' . $part . '\'');
write_msg('批量删除网友评论成功！', 'comment.php?part=' . $part, 'write_record');
} else {
if ($action == 'level0') {
if (!is_array($id)) {
write_msg('您没有选中任何记录！');
}
foreach ($id as $k => $v) {
$db->query('UPDATE `' . $db_mymps . 'comment` SET comment_level = 0 WHERE id = \'' . $v . '\' AND type = \'' . $part . '\'');
}
write_msg('更新评论状态为 待审状态 操作成功！', 'comment.php?part=' . $part, 'RECORD');
} else {
if ($action == 'level1') {
if (!is_array($id)) {
write_msg('您没有选中任何记录！');
}
foreach ($id as $k => $v) {
$db->query('UPDATE `' . $db_mymps . 'comment` SET comment_level = 1 WHERE id = \'' . $v . '\' AND type = \'' . $part . '\'');
}
write_msg('更新评论状态为 正常状态 操作成功！', 'comment.php?part=' . $part, 'RECORD');
} else {
if ($action == 'list') {
$admindir = getcwdOL();
$comment_level = isset($comment_level) ? intval($comment_level) : '';
require_once MYMPS_DATA . '/info.level.inc.php';
$part_arr = array('information' => '信息评论', 'news' => '新闻评论', 'group' => '团购评论', 'coupon' => '优惠券评论');
$here = $part_arr[$part];
unset($part_arr);
$where = ' WHERE type = \'' . $part . '\' ';
$where .= $keywords != '' ? ' AND a.content LIKE \'%' . $keywords . '%\'' : '';
$where .= $commment_level != '' ? ' AND a.comment_level = \'0\'' : '';
$sql = 'SELECT a.id,a.userid,a.content,a.pubtime,a.ip,a.typeid,a.type,b.title,a.comment_level FROM `' . $db_mymps . 'comment` AS a LEFT JOIN `' . $db_mymps . $part . '` AS b ON a.typeid = b.id ' . $where . ' ORDER BY a.pubtime DESC';
$rows_num = $db->getOne('SELECT COUNT(*) FROM `' . $db_mymps . 'comment` AS a ' . $where);
$param = setParam(array('part', 'keywords', 'comment_level'));
$comment = array();
foreach (page1($sql) as $k => $row) {
$arr['id'] = $row['id'];
$arr['content'] = $row['content'];
switch ($part) {
case 'information':
$arr['title'] = '' . $row[title] . '';
break;
case 'news':
$arr['title'] = '' . $row[title] . '';
break;
case 'group':
$arr['title'] = '' . $row[title] . '';
break;
case 'coupon':
$arr['title'] = '' . $row[title] . '';
break;
}
$arr['userid'] = $row[userid] ? '' . $row[userid] . '' : $row[ip];
$arr['pubtime'] = GetTime($row['pubtime']);
$arr['ip'] = $row['ip'];
$arr['comment_level'] = $information_level[$row[comment_level]];
$comment[] = $arr;
}
include mymps_tpl('comment');
}
}
}
}
}
is_object($db) && $db->Close();
$db = $mymps_global = $part = $action = $here = NULL;