$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);