forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: casp3r on June 02, 2010, 05:31:05 pm
-
Just wondering if it's possible to change the ownership of an image. I'm looking at the possibility of moving from SMG (Simple Machines Gallery) to Coppermine and I don't want my members to have to upload all their images again so I was going to do it. A long process (nearly 1500 images) but I don't mind. Is it possible to upload the images using the admin account and then reassign ownership of them to the appropriate member?
-
That's possible, but changing the ownership is not implemented as a control in the coppermine user interface - you'd have to run some simple queries against the database (using phpMyAdmin or similar), but that's dead easy. For details, post details (e.g. the link to your gallery that is mandatory to post as per board rules).
-
Hi Joachim and thanks for the reply. Sorry I can't supply a link to the coppermine gallery as I am running it locally (on my laptop) as a trial. The gallery I was thinking of moving over to Coppermine is this one
http://www.niaviation.co.uk/media/
-
you'd have to run some simple queries against the database (using phpMyAdmin or similar), but that's dead easy.
Any chance you could give me an example?
-
http://www.w3schools.com/sql/sql_update.asp
UPDATE cpg15x_pictures SET owner_id = 'new_id' WHERE owner_id = 'old_id';
-
...or
UPDATE cpg15x_pictures SET owner_id = 'new_id' WHERE filepath = 'path/to/files/by/a/particular/user/';