|
马上注册,结交更多好友,享用更多功能,轻松玩转社区。
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
批量删除未审核主题:
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;
|
|