View Full Version : Change Owner?
March 14th, 2010, 07:09 AM
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.
March 14th, 2010, 07:21 AM
well you could issue a query like so
UPDATE pp_photos SET userid='newid',user='newname' WHERE userid='oldid';
March 14th, 2010, 09:45 AM
That did it - thanks!
March 14th, 2010, 09:47 AM
No problem glad to help
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.