DedeCMS 批量删掉垃圾注册用户和垃圾文档
发布时间：2022-05-20 14:21:34 所属栏目：经验 来源：互联网
导读：DedeCMS 批量删除垃圾注册用户和垃圾文档： 1)查找垃圾用户(需要根据垃圾用户的特征来判断). select logintime,userid,sex from hfpet_member where sex= order by logintime desc; delete from hfpet_member where sex= and mid 8000; 2)查找文档微表中memb
|
DedeCMS 批量删除垃圾注册用户和垃圾文档： 1)查找垃圾用户(需要根据垃圾用户的特征来判断). select logintime,userid,sex from hfpet_member where sex='' order by logintime desc; delete from hfpet_member where sex='' and mid> 8000; 2)查找文档微表中member id 不为空且member id 不是注册用户的文档 文档微表,用于一些轻量的查询！ select * from hfpet_arctiny where mid !='' and mid not in (select mid from hfpet_member) order by id asc; 3)查找没有被审核，且member id 不为空且member id 不是注册用户的文档 select title,mid,ismake from hfpet_archives where ismake='' and mid !='' and mid not in (select mid from hfpet_member); 4)查找没有文档id 的 addonarticle select * from hfpet_addonarticle where aid not in (select id from hfpet_archives); 删除顺序： delete from hfpet_member where sex='' and mid> 12000; delete from hfpet_arctiny where mid !='' and mid not in (select mid from hfpet_member); delete from hfpet_archives where ismake='' and mid !='' and mid not in (select mid from hfpet_member); delete from hfpet_addonarticle where aid not in (select id from hfpet_archives);  （编辑：通化站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐