coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 permissions => Topic started by: n3n on April 22, 2006, 02:40:25 PM

Title: Changing image owner
Post by: n3n on April 22, 2006, 02:40:25 PM
hi,

I've uploaded several thousands of images to my gallery using my admin account. However, i wish to keep this account name
low key for security reasons.

Is there any way to (batch) change an image owner ? Tried renaming my user account but
that (obviously) did not work.


Cheers
Title: Re: Changing image owner
Post by: Nibbler on April 22, 2006, 02:54:07 PM
Only by manually changing the database.

UPDATE cpg_pictures SET owner_id = [newid], owner_name = '[new name]' WHERE owner_id = [oldid]
Title: Re: Changing image owner
Post by: n3n on April 22, 2006, 02:57:43 PM
Ok tnx alot Nibber,

Topic can be marked solved.