Change username on a post?

[Ohiosweetheart]

Is there a way to change the username on a post? So that it's posted by someone else, not me? (hypothetically)

[Lynne]

I believe there is a mod to do this.

[Ohiosweetheart]

off I go to look then.

Thanks Lynne

[EnIgMa1234]

You could also run a query from your admincp with the following:

UPDATE post SET username = 'NEWUSERNAME HERE', userid = 'NEW USERID HERE' WHERE postid = 'POSTID HERE'

[Ohiosweetheart]

do that to change the username on just one post?

[Lynne]

That should work for just one post unless the post is the first post in a thread (in which case you need to modify the thread table also to set the thread starter username and id) or the last post in a thread (in which case you need to modify the thread table to set the lastposter username). Oh, and then if there are attachments, you'd need to change the owner of those also.

[Ohiosweetheart]

ah geeze, never mind then, lol.
Thanks anyway! :)