Somehow, he is a blank member

[steve worcester]

I have a member that somehow was deleted from vBulletin, I made him a new member and was able to get back his posts, but his photos will show up under his old vBulletin member id, but they show under a blank username.

How can i get them back under his new username?
Here is an example
Gallery - AAW Photo Gallery

[Chuck S]

Well you will need to do some mass query if and only if his old userid is still on the photos

UPDATE pp_photos SET userid=NEWID WHERE userid=OLDID

[steve worcester]

Did that then
resync photo/comments usernames/update comments counts.
update your user table last photo field.
And we are all good - thanks again.

[Chuck S]

Not a problem glad to assist.