查看完整版本: 手工更改论坛会员的uid

手工更改论坛会员的uid

[size=12px]看到有人需要，我就写个文章吧，希望达到抛砖引玉的目的。

刚看到的时候就觉得不简单，做的过程中更是觉得不简单，牵涉的表太多了，真正修改uid是个比较麻烦的活，不过也就更新几个表的uid就可以了。
[color=red][b]我用Discuz! 4.1.0/5.0严格测试通过[/b][/color]


[color=red]4.1版本
[/color]
我这里假设以前的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;

[color=red]5.0版本[/color]
[color=#ff0000][/color]
我这里假设以前的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;
[/size]

支持老鱼,不过我笨笨的用不到....

用不到B_noidea

鱼哥 这个是DZ语言吗? 我怎么感觉想数据库SQL语言 很简单易懂

UPDATE `cdb_access` SET `uid`=30 WHERE `uid`=3;
这个翻译成中文 应该是
修改 `cdb_access表` 设置 `uid`=30  当`uid`=3 时

z这东西真复杂``````

厉害

标准的SQL语言。

只是看到那么多表就头疼………

晕～～

这个UID有什么用？
就是个注册编号吗？

B_support B_support B_support (y) (y) 不过我是不明白

能把我的改成N个8吗:lol:

都管理员弄得啊.