手工更改论坛会员的uid
看到有人需要，我就写个文章吧，希望达到抛砖引玉的目的。
刚看到的时候就觉得不简单，做的过程中更是觉得不简单，牵涉的表太多了，真正修改uid是个比较麻烦的活，不过也就更新几个表的uid就可以了。
我用Discuz! 4.1.0/5.0严格测试通过
4.1版本
我这里假设以前的uid为3，要修改成30
那么后台升级数据库是这样升级
CODE:
UPDATE `cdb_access` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_adminsessions` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_banned` SET `id`=30 WHERE `id`=3;
UPDATE `cdb_blogcaches` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_buddys` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_creditslog` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_favorites` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_memberfields` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_members` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_moderators` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_modworks` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_onlinetime` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_orders` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_paymentlog` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_posts` SET `authorid`=30 WHERE `authorid`=3;
UPDATE `cdb_promotions` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_ratelog` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_threads` SET `authorid`=30 WHERE `authorid`=3;
UPDATE `cdb_threadsmod` SET `uid`=30 WHERE `uid`=3;
UPDATE `cdb_validating` SET `uid`=30 WHERE `uid`=3;
5.0版本
我这里假设以前的uid为2，要修改成1
那么后台升级数据库是这样升级
CODE:
UPDATE `cdb_access` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_adminsessions` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_banned` SET `id`=1 WHERE `id`=2;
UPDATE `cdb_blogcaches` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_buddys` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_creditslog` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_favorites` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_memberfields` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_members` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_moderators` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_modworks` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_onlinetime` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_orders` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_paymentlog` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_posts` SET `authorid`=1 WHERE `authorid`=2;
UPDATE `cdb_promotions` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_ratelog` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_threads` SET `authorid`=1 WHERE `authorid`=2;
UPDATE `cdb_threadsmod` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_validating` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_myposts` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_mythreads` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_activities` SET `uid`=1 WHERE `uid`=2;
UPDATE `cdb_activityapplies` SET `uid`=1 WHERE `uid`=2;
