Kullanıcı Kimlik Numarasını belirleyen UserID değişmek için aşağıdaki sorgu phpmyadmin de çalışıtırlırın...
Sorgudaki 3 rakamı yeni UserID , 9 Rakamı değiştirikmek istenen eski UserID
Kod:
Sorgudaki 3 rakamı yeni UserID , 9 Rakamı değiştirikmek istenen eski UserID
Kod:
UPDATE `adminlog` SET `userid` = '3' WHERE `adminlog`.`userid` =9;UPDATE `announcement` SET `userid` = '3' WHERE `announcement`.`userid` =9;UPDATE `announcementread` SET `userid` = '3' WHERE `announcementread`.`userid` =9;UPDATE `attachment` SET `userid` = '3' WHERE `attachment`.`userid` =9;UPDATE `calendarmoderator` SET `userid` = '3' WHERE `calendarmoderator`.`userid` =9;UPDATE `cpsession` SET `userid` = '3' WHERE `cpsession`.`userid` =9;UPDATE `customavatar` SET `userid` = '3' WHERE `customavatar`.`userid` =9;UPDATE `customprofilepic` SET `userid` = '3' WHERE `customprofilepic`.`userid` =9;UPDATE `deletionlog` SET `userid` = '3' WHERE `deletionlog`.`userid` =9;UPDATE `editlog` SET `userid` = '3' WHERE `editlog`.`userid` =9;UPDATE `event` SET `userid` = '3' WHERE `event`.`userid` =9;UPDATE `forumread` SET `userid` = '3' WHERE `forumread`.`userid` =9;UPDATE `infraction` SET `userid` = '3' WHERE `infraction`.`userid` =9;UPDATE `moderator` SET `userid` = '3' WHERE `moderator`.`userid` =9;UPDATE `moderatorlog` SET `userid` = '3' WHERE `moderatorlog`.`userid` =9;UPDATE `passwordhistory` SET `userid` = '3' WHERE `passwordhistory`.`userid` =9;UPDATE `paymentinfo` SET `userid` = '3' WHERE `paymentinfo`.`userid` =9;UPDATE `pm` SET `userid` = '3' WHERE `pm`.`userid` =9;UPDATE `pmreceipt` SET `userid` = '3' WHERE `pmreceipt`.`userid` =9;UPDATE `pollvote` SET `userid` = '3' WHERE `pollvote`.`userid` =9;UPDATE `post` SET `userid` = '3' WHERE `post`.`userid` =9;UPDATE `posthash` SET `userid` = '3' WHERE `posthash`.`userid` =9;UPDATE `reminder` SET `userid` = '3' WHERE `reminder`.`userid` =9;UPDATE `reputation` SET `userid` = '3' WHERE `reputation`.`userid` =9;UPDATE `rssfeed` SET `userid` = '3' WHERE `rssfeed`.`userid` =9;UPDATE `search` SET `userid` = '3' WHERE `search`.`userid` =9;UPDATE `session` SET `userid` = '3' WHERE `session`.`userid` =9;UPDATE `sigparsed` SET `userid` = '3' WHERE `sigparsed`.`userid` =9;UPDATE `sigpic` SET `userid` = '3' WHERE `sigpic`.`userid` =9;UPDATE `subscribeevent` SET `userid` = '3' WHERE `subscribeevent`.`userid` =9;UPDATE `subscribeforum` SET `userid` = '3' WHERE `subscribeforum`.`userid` =9;UPDATE `subscribethread` SET `userid` = '3' WHERE `subscribethread`.`userid` =9;UPDATE `subscriptionlog` SET `userid` = '3' WHERE `subscriptionlog`.`userid` =9;UPDATE `tachyforumpost` SET `userid` = '3' WHERE `tachyforumpost`.`userid` =9;UPDATE `tachythreadpost` SET `userid` = '3' WHERE `tachythreadpost`.`userid` =9;UPDATE `threadrate` SET `userid` = '3' WHERE `threadrate`.`userid` =9;UPDATE `threadread` SET `userid` = '3' WHERE `threadread`.`userid` =9;UPDATE `user` SET `userid` = '3' WHERE `user`.`userid` =9;UPDATE `useractivation` SET `userid` = '3' WHERE `useractivation`.`userid` =9;UPDATE `userban` SET `userid` = '3' WHERE `userban`.`userid` =9;UPDATE `userfield` SET `userid` = '3' WHERE `userfield`.`userid` =9;UPDATE `usergroupleader` SET `userid` = '3' WHERE `usergroupleader`.`userid` =9;UPDATE `usergrouprequest` SET `userid` = '3' WHERE `usergrouprequest`.`userid` =9;UPDATE `usernote` SET `userid` = '3' WHERE `usernote`.`userid` =9;UPDATE `usertextfield` SET `userid` = '3' WHERE `usertextfield`.`userid` =9;UPDATE `thread` SET `postuserid` = '3' WHERE `thread`.`postuserid` =9;