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
ku ku 2006-10-14 12:36
我要改为
UID=1
名=saltfish:lol: :lol:
B_support B_support 老鱼!