龙魂公会 - 破碎银河系 - 行星边际2

 找回密码
 点击这里加入

QQ登录

只需一步,快速开始

SG 破碎银河系美服
搜索
热搜: 资料 加点
查看: 375|回复: 3

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

[复制链接]
  • TA的每日心情

    3 天前
  • 签到天数: 5 天

    [LV.2]偶尔看看I

    发表于 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|手机版|小黑屋|龙魂网游公会 龙魂有你更精彩 Q群:14255183 YY频道:51921 

    GMT+8, 2021-10-23 00:58 , Processed in 0.045936 second(s), 22 queries .

    Powered by Discuz! X3.4

    Copyright © 2001-2021, Tencent Cloud.

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