QQ登录

只需一步,快速开始

扫一扫,访问微社区

立即注册 找回密码

流星爱

发表于 2016-1-20 18:21:42 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,轻松玩转社区。

您需要 登录 才可以下载或查看,没有帐号?立即注册

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;

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

返回顶部上一主题下一主题返回列表
  • 站长:47343626
  • 邮箱:lx@lxlove.cn
  • logo
快速回复 返回顶部 返回列表