grand.error
Active Member
Few days ago a forum crashed and "user" table was lost and I had to import an old backup of it, 3 months old. After successfully doing that, i've lost no post & topic count, but lost around 7K or registered users. Now, that wouldn't be a problem if users could register again with same usernames as they had before the crash, but they can't. Don't know why.
Now to my question. Now, all those posts that have been posted in these last 3 months, but users that posted them registered on later date, show as guest made. Is there any way to merge those posts to newly created accounts?
I know there are these tho options for mysql
UPDATE post SET userid=X WHERE username LIKE 'DesiredUsername'
UPDATE thread SET postusername='X', postuserid='Y' WHERE postuserid=0
but that is for one user only. I need to do it for many and possible to automatize it somehow.
Now to my question. Now, all those posts that have been posted in these last 3 months, but users that posted them registered on later date, show as guest made. Is there any way to merge those posts to newly created accounts?
I know there are these tho options for mysql
UPDATE post SET userid=X WHERE username LIKE 'DesiredUsername'
UPDATE thread SET postusername='X', postuserid='Y' WHERE postuserid=0
but that is for one user only. I need to do it for many and possible to automatize it somehow.
