http://jackxiang.com/index.php zh-cn http://jackxiang.com/post// jack <xdy108@126.com> Fri, 13 May 2011 15:15:21 +0000 http://jackxiang.com/post//       不懂博客的我，不得不采取宁可错杀1万，不可放过1个的安全策略——

进入后台 -> 数据维护 -> MySQL -> 复制下列语句 -> 确定（以下语句，请对号入座、谨慎操作！）

批量删除未审核评论
delete from [db]replies where reproperty=2
批量删除未审核留言
delete from [db]messages where reproperty=2
批量删除已审核评论（危险，谨慎操作）
delete from [db]replies where reproperty=0
批量删除未审核引用
delete from [db]replies where reproperty=5
批量删除已审核引用
delete from [db]replies where reproperty=4
SQL操作：
select repid,repcontent from boblog_replies where repcontent like "%I affect on those pills%"; select repid   from boblog_replies where repcontent like "%I affect on those pills%"; select repid   from boblog_replies where repcontent like "%相关的主题文章%"; 查出fepid后批量删除： delete from boblog_replies where repid in (57062, 57049, 57038);

Delete it:
delete from boblog_replies where repcontent like "%相关的主题文章%"  and reproperty=2; delete from boblog_replies where repcontent like "%相关的主题文章%";
]]> http://jackxiang.com/post//#blogcomment <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 http://jackxiang.com/post//#blogcomment