forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: casp3r on June 02, 2010, 05:31:05 pm

Title: Change Ownership of Images
Post 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?
Title: Re: Change Ownership of Images
Post by: Joachim Müller on June 02, 2010, 05:41:02 pm
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).
Title: Re: Change Ownership of Images
Post by: casp3r on June 02, 2010, 10:31:33 pm
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/
Title: Re: Change Ownership of Images
Post by: casp3r on June 03, 2010, 11:51:19 am
Quote
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?
Title: Re: Change Ownership of Images
Post by: Αndré on June 03, 2010, 12:02:14 pm
http://www.w3schools.com/sql/sql_update.asp

Code: [Select]
UPDATE cpg15x_pictures SET owner_id = 'new_id' WHERE owner_id = 'old_id';
Title: Re: Change Ownership of Images
Post by: Joachim Müller on June 03, 2010, 02:13:20 pm
...or
Code: [Select]
UPDATE cpg15x_pictures SET owner_id = 'new_id' WHERE filepath = 'path/to/files/by/a/particular/user/';