Question

我自己的一个discuz X2的论坛，我是管理员，怎么将一个用户的uid更改，即uid：1055改成uid：6，求高手详解

希望能回答详细点啊，我改了数据库，但帐号就需要激活，点激活也没用……谢谢各位啦，急求解……

Answer 1

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

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

Answer 2

留下联系方式、