(08-07-2010, 10:46 AM)flick Wrote: I accidentally deleted a member during an anti-spam spree and so their post(s) are now on the db as by an 'Unregistered' user.
I know it is possible to merge two accounts, but is it possible to merge post(s) by this 'guest/unregistered' account to a new 'registered' account please?
That would be possible as well. Run this query at your phpmyadmin
UPDATE mybb_posts SET uid = x WHERE username = 'deleted_user_username';
Replace x with the user id of the new registered user whom you want to attribute the posts of the deleted user and replace deleted_user_username with the username that your deleted user used to have before he deleted his account.
It will work. As it happens, I did it only yesterday at my own forum too for a couple of deleted users who came back.
If you want to restore back the deleted threads too, run this query
UPDATE mybb_threads SET uid = x WHERE username = 'deleted_user_username';
And replace accordingly the values as explained above. Also if your db tables use another prefix other than the default mybb_ then you should use that instead when running the queries.
Then go to your Admin Panel->Tools & Maintenance->Recount & Rebuild and run the first 4 options there.