moving one member's posts to another..

[JoBlo]

Hi there:

There's a member of board who used to be signed up under another name and has asked me to "transfer" all of his old posts (under the old username) to his new username.

Is this possible? And if so, how do I go about it?

Thanks.

[filburt1]

Would it be easier to just change the account's name?

This query should update all posts but I'm not sure about other details:

UPDATE post SET userid=[i]new userid[/i] WHERE userid=[i]old userid[/i]

[Xenon]

don't forget to update counters after runing this query

[JoBlo]

Originally posted by filburt1
Would it be easier to just change the account's name?

This query should update all posts but I'm not sure about other details:

UPDATE post SET userid=[i]new userid[/i] WHERE userid=[i]old userid[/i]

Thanks for that, but to be honest, I don't know exactly what you mean. I just got the board and don't understand the "tech" side of it. Is there a section called QUERY in which I am to input this line? (and interchange the usernames, etc....)?

[filburt1]

They're userids not usernames.

To run queries, you can download and install http://phpmyadmin.sourceforge.net/ but I wouldn't recommend running that query until a developer reads this.