查看完整版本: UID修改!

saltfish 2006-10-5 09:22

UID修改!

我这里假设以前的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;

寂寞小子 2006-10-6 19:20

弱弱的问一下
把偶的UID改成1可以不?
B_Dislike B_thanks

凌晨的爱 2006-10-11 12:12

我喜欢UID=11B_thanks

qdxx 2006-10-12 11:06

支持修改!

0238149 2006-10-12 20:49

我想改成198535

ku ku 2006-10-14 12:36

我要改为
UID=1
名=saltfish:lol: :lol:

B_support B_support 老鱼!

fankyli 2006-10-15 16:47

可以的我要改为UID 32:lol:

clapton 2006-10-22 03:03

............楼上的都是什么人
页: [1]
查看完整版本: UID修改!