无限星辰工作室-客户无限互联网动力之源

标题: Discuz!用户账号串号登陆解决方案之一 [打印本页]

作者: crx349 时间: 2014-3-18 11:08
标题: Discuz!用户账号串号登陆解决方案之一
故障说明：论坛用户在使用是出现用户串号登陆，A账号变成B账号登陆的情况，原因是Discuz!和UC内的用户id对不上，导致的。

解决方法：必须将UC和DZ的UID统一起来

1.以UC为准的统一方法：

DELETE FROM `uc_members` WHERE uid NOT IN(SELECT uid FROM `pre_common_member`);

复制代码

以上是7.2升级用户的统一代码

DELETE FROM `pre_ucenter_member` WHERE uid NOT IN(SELECT uid FROM `pre_common_member`);

复制代码

以上是7.2升级后用老UC库的

2.以DZ为准的统一代码

SELECT uid FROM `pre_common_member` WHERE uid NOT IN (SELECT uid FROM `uc_members`);

复制代码

以上是7.2升级用户的统一代码

DELETE FROM `pre_common_member` WHERE uid NOT IN(SELECT uid FROM `pre_ucenter_member`);

复制代码

以上是安装Discuz!

SQL语句执行有危险！
请备份被改动的数据表：pre_common_member ，pre_ucenter_member ，uc_members

欢迎光临无限星辰工作室-客户无限互联网动力之源 (https://xmspace.net/)