View Full Version : Query Photo Owner Change
February 25th, 2007, 03:13 PM
Does anyone know what query I could run to change all photos owned by one user to another?
February 25th, 2007, 06:32 PM
well if your using any version over 5.0 you can do this
UPDATE pp_photos SET userid=1, user='dude' WHERE userid=2
which of course you replace userids to the respective ones you want to use above it simply means every photo owned by userid 2 will be changed to userid 1 and of course you might want to update the user's name at the same time
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.