$sql = 'DELETE FROM ' . table('comment') . " WHERE comment_id='" . $comment_id . "'";
if ($db->query($sql)) {
$sql = 'UPDATE ' . table('blog') . " SET comments =comments-1 WHERE blog_id='{$blog_id}'";
$db->query($sql);
sys_message('删除评论成功', $referer_url);
} else {
sys_message('删除评论失败，请重新删除', $referer_url);
}
} elseif ($action == 'edit_comment') {
$comment_id = intval($_GET['id']);
if (empty($comment_id)) {
sys_message('日志评论id不能为空', $referer_url);
}
$sql = 'SELECT o.* , u.title FROM ' . table('comment') . ' o LEFT JOIN ' . table('blog') . ' u on o.blog_id=u.blog_id' . " WHERE comment_id='" . $comment_id . "'";
if ($row = $db->getrow($sql)) {
$row['content'] = unprocess_text($row['content']);
$smarty->assign('comment', $row);
} else {
sys_message('读取日志评论数据失败，请返回重新修改', $referer_url);
}
$smarty->assign('type', 'act_edit_comment&id=' . $comment_id);
$smarty->assign('admin_title', '编辑评论');
$smarty->display('edit_comment.html');
} elseif ($action == 'act_edit_comment') {
$comment_id = intval($_GET['id']);
if (empty($comment_id)) {
sys_message('日志评论ID不能为空', $referer_url);
}
$status = !empty($_POST['status']) ? $_POST['status'] : 0;
$content = $_POST['content'];
if (empty($content)) {
$xml_body .= "<description><![CDATA[{$val['content']}]]></description> \n";
$xml_body .= "<category><![CDATA[{$val['cat_name']}]]></category> \n";
$xml_body .= "<pubDate>{$val['add_time']}</pubDate> \n";
$xml_body .= "<guid>{$u}/blog.php?id={$val['blog_id']}</guid> \n";
$xml_body .= "</item> \n";
}
} elseif ($act == 'comments') {
$sql = 'SELECT b.blog_id,b.title,b.url_type,c.user_name,c.content,c.add_time FROM ' . table('blog') . ' AS b LEFT JOIN ' . table('comment') . ' AS c on b.blog_id=c.blog_id' . " ORDER BY c.comment_id DESC ";
if ($comments = $db->getall($sql)) {
$xml_body = '';
foreach ($comments as $key => $val) {
//评论是否还在审核中
if ($val['status'] == 1) {
$val['content'] = '该评论正在审核中';
} else {
$val['content'] = unprocess_text($val['content']);
}
$val['add_time'] = pbtime($val['add_time']);
$url = build_url('blog', $val['blog_id'], $val['url_type']);
$xml_body .= "<item> \n";
$xml_body .= "<title>【评论:{$val['title']}】</title> \n";
$xml_body .= "<author>{$val['user_name']}</author> \n";
$xml_body .= "<link>{$url}</link> \n";
$xml_body .= "<description><![CDATA[{$val['content']}]]></description> \n";
$xml_body .= "<pubDate>{$val['add_time']}</pubDate> \n";
$xml_body .= "<guid>{$url}</guid> \n";
$xml_body .= "</item> \n";
}
}
}
$u = dirname($url);
