I've been searching through the documentation but I cannot find any way to change the author of a post. We have a couple posts on our forum which were made by real users, but before I set things up correctly, and they posted unregistered.
Is there a way to change the author of individual posts? (I am the admin.)
Have them repost it when registered and delete the old one? It probably possible to do it through phpmyadmin but you would have to get one of smart people.
I'm not sure if this would work, you can try it, but make sure you have a backup in case something goes wrong because I haven't tested.
On phpMyAdmin, run this query:
UPDATE mybb_posts SET uid=xx, username='newUsername' WHERE pid=x
If mybb_ is not the table prefix, make sure you change it, get the uid of the new user, change newUsername to the Username you want it to be changed to, and change x to the actual post id where you want this change to happen.
DCR Wrote:UPDATE mybb_posts SET username='newUsername' WHERE pid=x
You also need to change the uid (user ID) of the post, so it should be:
UPDATE mybb_posts SET uid='<<<USERID>>>', username='<<<THE USERNAME>>>' WHERE pid='<<<POST ID>>>'
The User ID can be found by going to the user's profile, and looking at the URL. The URL will be something like
http://www.example.com/member.php?action=profile&uid=x where x is the User ID.
The Post ID can be found by looking at the link at the top right of the post (for this post, for example, it's "Post: #4", click on the #4 and you should see this URL in your browser's location bar:
http://community.mybboard.net/showthread...#pid185795
The Post ID for this post is 185795.
Thanks for the correction Dennis.