[Discuz!] Discuz!遭遇到惡意注冊和灌水后的批量處理方案

Discuz!站點(diǎn)經(jīng)常遇到的問題就是惡意注冊和惡意灌水網(wǎng)站在被灌水后整個(gè)網(wǎng)站整體體驗(yàn)就會(huì)下降
注冊量大了之后會(huì)造成空間占用龐大、查詢速度下降等問題
而后臺(tái)刪除功能非常消耗系統(tǒng)性能
并且容易造成誤操作刪除管理員等問題
因此通過數(shù)據(jù)庫直接刪除會(huì)員以及相關(guān)信息會(huì)極大的提高刪除效率
在此提供一些常用的關(guān)聯(lián)刪除方法方便各位站長使用
執(zhí)行sql可以通過phpmyadmin進(jìn)行
如果沒有phpmyadmin的站長可以通過修改config_global.php

1. $_config['admincp']['runquery'] = '0';

復(fù)制代碼

其中0改成1

1. $_config['admincp']['runquery'] = '1';

復(fù)制代碼

這樣就可以通過后臺(tái)-站長-數(shù)據(jù)庫-升級(jí)執(zhí)行sql語句

下載 (28.97 KB)

2015-2-2 11:47

一般注冊機(jī)與灌水機(jī)都是批量的注冊賬戶并灌水發(fā)帖
因此注冊的uid一般是連續(xù)的
可以通過uid來批量刪除用戶及相關(guān)數(shù)據(jù)
比如大于某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;

復(fù)制代碼

其中

1. set @delid = 1000000;

復(fù)制代碼

是定義uid=1000000
大于該uid的用戶和關(guān)聯(lián)數(shù)據(jù)全部刪除
可以根據(jù)自己站點(diǎn)實(shí)際情況定義該值
其中的語句可以單獨(dú)拆分進(jìn)行處理

刪除數(shù)據(jù)后還要對網(wǎng)站進(jìn)行一下掃尾工作
1.登錄后臺(tái)-工具-更新緩存，避免前臺(tái)數(shù)據(jù)與實(shí)際數(shù)據(jù)不吻合。
2.登錄后臺(tái)-站長-數(shù)據(jù)庫-優(yōu)化，對數(shù)據(jù)庫碎片進(jìn)行優(yōu)化，減少占用，提升效率。