Change Album and Picture owner

[burrelly]

I have a user who has uploaded thousands of pictures but want to be removed from the forum. We want to be able to keep all the pictures and I really don't want to have to upload them all again.

Is there anyway I can change the owner of the images to another user I have created on the forum?

[King Kovifor]

As far as I know, the only way would be a mySQL Query done through the ACP. But, the problem with that is that it may mess up counters...

[burrelly]

After posting this I had a play about and just changed the owner user id in php admin to the new user.

It seems to have changed the pictures over to the new user. Looking at the pictures though they are still listed under the old user does not seem to have affected anything though.