Plugin? or something

[silvermerc]

Can someone give me a guide to connect a users posts together, Not a merge. The user got deleted and then i need to restore his posts to his current amount?
Ross

[Gio~Logist]

As far as i know, you would need to run a query to update the database.

But even then, i'm wondering how you'd tell your server what posts to associate the user with, if the posts were set to guest already.

[Lynne]

Actually, the post table keeps the username even if the post was deleted (it will have the original username, but have userid set to 0). So, you would do a query that changes all posts with username "xxxx" and userid "0" to username "yyyy" and userid "1234" You'd then have to also update the user table and enter in the correct number of posts for the user.

[Gio~Logist]

Lynne's right. Run the queries as follows:

update thread SET postuserid = 'x' AND postusername = 'y' WHERE postusername = 'oldusername'

update post  SET userid = 'x' AND username = 'y' WHERE username = 'oldusername'

Update it accordingly if your tables have prefixes.