Discuz论坛怎么将一个用户的uid更改，即uid：10001改成uid：10000

民审-M · 发表于 2016-9-1 21:31:26

- 特别鸣谢：本教程由草根吧建站学习研究"*明"友情分享，请勿二次转载、倒卖建站学习研究资源，一经发现，直接封号！-
怎么将一个用户的uid更改，即uid：10001改成uid：10000：

UPDATE `pre_common_member` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_session` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_member_count` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_member_field_forum` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_member_field_home` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_member_profile` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_member_status` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_statuser` set uid=10000 WHERE uid=10001;
UPDATE `pre_forum_post` set fid=10000 WHERE fid=10001;
UPDATE `pre_forum_post` set authorid=10000 WHERE authorid=10001;
UPDATE `pre_forum_thread` set fid=10000 WHERE fid=10001;
UPDATE `pre_forum_thread` set authorid=10000 WHERE authorid=10001;
UPDATE `pre_forum_groupuser` set uid=10000 WHERE uid=10001;
UPDATE `pre_forum_groupuser` set fid=10000 WHERE fid=10001;
UPDATE `pre_ucenter_friends` set uid=10000 WHERE uid=10001;
UPDATE `pre_ucenter_friends` set friendid=10000 WHERE friendid=10001;
UPDATE `pre_ucenter_memberfields` set uid=10000 WHERE uid=10001;
UPDATE `pre_ucenter_memberfields` set uid=10000 WHERE uid=10001;
UPDATE `pre_ucenter_members` set uid=10000 WHERE uid=10001;
UPDATE `pre_ucenter_pms` set msgfromid=10000 WHERE msgfromid=10001;
UPDATE `pre_ucenter_pms` set msgtoid=10000 WHERE msgtoid=10001;
UPDATE `pre_home_friend` set uid=10000 WHERE uid=10001;
UPDATE `pre_home_friend` set fuid=10000 WHERE fuid=10001;
UPDATE `pre_home_friendlog` set uid=10000 WHERE uid=10001;
UPDATE `pre_home_friendlog` set fuid=10000 WHERE fuid=10001;
UPDATE `pre_home_notification` set uid=10000 WHERE uid=10001;

复制代码

这样就可以把uid10001的所有资料包括贴子什么的全部改成 uid10000的

Discuz论坛怎么将一个用户的uid更改，即uid：10001改成uid：10000

相关帖子

浏览过的版块

个人中心