coppermine-gallery.com/forum

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: ewise on February 26, 2014, 06:20:11 PM

Title: How to choose another user
Post by: ewise on February 26, 2014, 06:20:11 PM
Hi,
After uploading photos how to choose another user who would author the photos?
Thank you so much.
Title: Re: How to choose another user
Post by: gmc on February 27, 2014, 04:07:35 AM
Coppermine sets the owner to the user uploading (or batch adding) the files. Don't know of any interface in Coppermine to change owner...
However it can be quite simple to change the owner of all pics in given album via phpMyAdmin.

You will need some data values from other tables (or more complex SQL)
For example to change owner of all pics in album with aid '3' to user with user_is 8 and cpg table prefix of 'cpg_':
UPDATE cpg_pictures SET owner_id = '8' where aid = '3'

Other criteria can of course be used as appropriate... Always a good idea to backup your databases before updating.