找回密码
 点击这里加入

QQ登录

只需一步,快速开始

搜索
热搜: 资料 加点
查看: 2069|回复: 4

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

[复制链接]
  • TA的每日心情
    开心
    2024-12-15 11:29
  • 签到天数: 28 天

    [LV.4]偶尔看看III

    发表于 2021-4-2 15:29:45 | 显示全部楼层 |阅读模式
    • 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前台和后台显示的会员数目一致
    您需要登录后才可以回帖 登录 | 点击这里加入

    本版积分规则

    QQ|Archiver|手机版|小黑屋|龙魂有你更精彩 YY频道:51921 ( 蒙ICP备2024020153号 )

    GMT+8, 2024-12-27 08:04 , Processed in 0.084075 second(s), 22 queries .

    Powered by Discuz! X3.5

    © 2001-2024 Discuz! Team.

    快速回复 返回顶部 返回列表