PDA

View Full Version : I Want To Transfer All Posts From One Account To Another

CeleronXL
07-05-2002, 01:31 PM
Ok, one of my users has a few accounts with posts on them. I want to delete the other accounts and make all of the posts that were made with them now bear his new name. His member ID's are:

44
377
379

The userID I want to transfer them to is:

49.

What is the query I would need to run? I think there's two for each member ID.
Xenon
07-05-2002, 01:53 PM
UPDATE post SET userid=49 WHERE userid=44 OR userid=377 OR userid=379
CeleronXL
07-05-2002, 02:02 PM
Don't you have to run the same thing for table "thread"?
Xenon
07-05-2002, 04:05 PM
yes, or you can update counters after you run my query...

because you have to upgrade counters for users postcount you can also update the thread informations ;)