forum.coppermine-gallery.net

No Support => Feature requests => Scheduled for cpg1.5.x => Topic started by: Harrr on September 07, 2004, 10:35:47 am

Title: Visitors can upload files (for all albums)
Post by: Harrr on September 07, 2004, 10:35:47 am
Say you have a hundred albums. How would you change the 'Visitors can upload files' for all of them, other than go to the properties of each one and change it there.

Maybe someone who knows the DB can give me an SQL statement, though it would be a good feature to have a screen with all albums listed and checkboxes for some properties which you tick/untick and then apply changes.

Thanks in advance.
Title: Re: Visitors can upload files (for all albums)
Post by: mstralka on September 07, 2004, 12:18:34 pm
This will turn on uploading for every album in your system.  To limit it to some albums I would need more details.
Code: [Select]
UPDATE cpg132_albums SET uploads = 'YES'
Title: Re: Visitors can upload files (for all albums)
Post by: nukeworker on March 21, 2005, 09:43:21 pm
This should be added to the FAQ.
Title: Re: Visitors can upload files (for all albums)
Post by: Joachim Müller on March 23, 2005, 10:36:11 am
moving this from the cpg1.3 standalone support board to the approved feature request board for cpg1.5
There should rather be an admin settable option in the future imo.

Joachim
Title: Re: Visitors can upload files (for all albums)
Post by: nukeworker on March 23, 2005, 12:52:58 pm
moving this from the cpg1.3 standalone support board to the approved feature request board for cpg1.5
There should rather be an admin settable option in the future imo.

Joachim

One question.

I ran this query, so far so good. -- I notice that it also changes the setting for the personal gallerys as well.  -- Does that mean that I'm allowing "uer A" to post in "user B"'s gallery??
Title: Re: Visitors can upload files (for all albums)
Post by: kegobeer on March 24, 2005, 01:15:25 am
That shouldn't be the case.  Have you tried it yet?  Just create a few test users, create albums for them, and try uploading.
Title: Re: Visitors can upload files (for all albums)
Post by: nukeworker on March 24, 2005, 03:51:03 pm
That shouldn't be the case.  Have you tried it yet?  Just create a few test users, create albums for them, and try uploading.

I tested it, everything is fine.
Title: Re: Visitors can upload files (for all albums)
Post by: griswold on March 24, 2005, 07:58:45 pm
Where would you change the insert sql to set YES as default. I tried changing the db default but when I add a new album, it still sets it as NO.
Title: Re: Visitors can upload files (for all albums)
Post by: Casper on March 24, 2005, 08:59:28 pm
http://forum.coppermine-gallery.net/index.php?topic=6553.0