如何将DZ和UC会员数同步一致的

龙魂丶龙行天下

• SELECT uid FROM `pre_ucenter_members` WHERE uid  NOT IN (SELECT uid FROM `pre_common_member`);
  

[color=rgb(51, 102, 153) !important]复制代码
这个代码是查询,UC中没在DZ中的激活会员，一般查询出来UID后，自己进UC后台手工进行确认删除。这样最保险

另外，SQL命令有风险，执行所有的SQL的时候记得备份，因为这个是不可逆的。如果出现任何问题，本人不承认任何责任。
默认表头 bbs   ，各位站长一定要改成 pre 或者你自己修改过的

• DELETE FROM `bbs_common_member_count` WHERE uid NOT IN(SELECT uid FROM `bbs_common_member`);
• DELETE FROM `bbs_common_member_field_forum` WHERE uid NOT IN(SELECT uid FROM `bbs_common_member`);
• DELETE FROM `bbs_common_member_field_home` WHERE uid NOT IN(SELECT uid FROM `bbs_common_member`);
• DELETE FROM `bbs_common_member_profile` WHERE uid NOT IN(SELECT uid FROM `bbs_common_member`);
• DELETE FROM `bbs_common_member_status` WHERE uid NOT IN(SELECT uid FROM `bbs_common_member`);
• 
  

[color=rgb(51, 102, 153) !important]复制代码
以上代码是让DZ前台和后台显示的会员数目一致