DZ批量删除未审核的主题和用户..

lxx

批量删除未审核主题:

DELETE FROM `pre_forum_thread` WHERE displayorder = '-2';
DELETE FROM `pre_forum_post` WHERE invisible = '-2';

批量删除未审核用户(未验证.自行备份数据):

先执行这一句：

delete from pre_ucenter_members where uid in (select uid from pre_common_member where groupid=8);

然后再执行：

delete from pre_common_member where groupid=8;

先去 后台用户组  系统用户组 看下你的 等待验证会员是否是 8  如果不是改成你对应的就可以了



批量删除除管理员以外的所有用户:

delete from pre_common_member where uid>1;
delete from pre_common_member_count where uid>1;
delete from pre_common_member_field_forum where uid>1;
delete from pre_common_member_field_home where uid>1;
delete from pre_common_member_profile where uid>1;
delete from pre_common_member_status where uid>1;
delete from pre_common_onlinetime where uid>1;
delete from pre_common_member_validate where uid>1;
delete from pre_ucenter_memberfields where uid>1;
delete from pre_ucenter_members where uid>1;