Guest made posts into specific users posts?

[grand.error]

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.

grand.error Reviewed by grand.error on 21st Dec 2011. Guest made posts into specific users posts? 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 Rating: 5

[Tempus]

Just try repairing your tables via adminCp.

[grand.error]

Sorry for late replay..

Tried that and all the usual stuff that goes with it, didn't help one bit.

[Mr. Goodie2Shoes]

here you go!
http://www.vbulletin.org/forum/showthread.php?t=245183