Change Owner?

[tonmo]

For whatever reason, I have a bunch of photos assigned to the wrong user in my Gallery. Is there an easy way to do a mass change of ownership? I'd be happy to go into phpmyadmin and run a query but I'm not sure what query I should run. I basically want to change all photos from user x and assign them to user y.

[Chuck S]

well you could issue a query like so

UPDATE pp_photos SET userid='newid',user='newname' WHERE userid='oldid';

[tonmo]

That did it - thanks!

[Chuck S]

No problem glad to help