Change Ownership of Images

[casp3r]

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?

[Joachim Müller]

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).

[casp3r]

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/

[casp3r]

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?

[Αndré]

http://www.w3schools.com/sql/sql_update.asp

Code Select Expand

UPDATE cpg15x_pictures SET owner_id = 'new_id' WHERE owner_id = 'old_id';

[Joachim Müller]

...or

Code Select Expand

UPDATE cpg15x_pictures SET owner_id = 'new_id' WHERE filepath = 'path/to/files/by/a/particular/user/';