无限星辰工作室-客户无限互联网动力之源

标题: Discuz!遭遇到恶意注册批量删除方案之一 [打印本页]

---

作者: crx349    时间: 2015-2-5 15:29
标题: Discuz!遭遇到恶意注册批量删除方案之一

一般注册机与灌水机都是批量的注册账户并灌水发帖
因此注册的uid一般是连续的
可以通过uid来批量删除用户及相关数据
比如大于某uid的批量删除的sql

1. set @delid = 1000000;
   
2. delete from pre_home_feed where uid > @delid;
   
3. delete from pre_home_share where uid > @delid;
   
4. delete from pre_home_comment where uid > @delid;
   
5. delete from pre_home_blogfield where uid > @delid;
   
6. delete from pre_home_blog where uid > @delid;
   
7. delete from pre_home_class where uid > @delid;
   
8. delete from pre_home_pic where uid > @delid;
   
9. delete from pre_common_member where uid > @delid;
   
10. delete from pre_common_member_count where uid > @delid;
    
11. delete from pre_common_member_field_forum where uid > @delid;
    
12. delete from pre_common_member_field_home where uid > @delid;
    
13. delete from pre_home_album where uid > @delid;
    
14. delete from pre_home_docomment where uid > @delid;
    
15. delete from pre_home_doing where uid > @delid;
    
16. delete from pre_home_notification where authorid > @delid;
    
17. delete from pre_forum_post where authorid > @delid;
    
18. delete from pre_forum_thread where authorid > @delid;
    
19. delete from pre_portal_comment where uid > @delid;
    
20. delete from pre_common_member_profile where uid > @delid;
    
21. delete from pre_common_member_status where uid > @delid;
    
22. delete from pre_ucenter_members where uid > @delid;

复制代码

以上句子在后台---站长---数据库---升级 运行
或上phpmyadmin运行下
其中

1. set @delid = 1000000;

复制代码

是定义uid=1000000
大于该uid的用户和关联数据全部删除
可以根据自己站点实际情况定义该值
其中的语句可以单独拆分进行处理

---

欢迎光临 无限星辰工作室-客户无限互联网动力之源 (https://www.xmspace.net/)

Powered by Discuz! X3.4