forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Permissions & Access Rights => Topic started by: scottking on November 05, 2005, 01:03:04 pm

Title: make entire gallery members of the 'registered' group
Post by: scottking on November 05, 2005, 01:03:04 pm

I was wondering if there is a quick way of changing my entire gallery from Everybody (public) to members of the 'registered' group. I have 166 albums and find it a slow process to click on each individual album and make the permission changes this way. Is there a way to change permissions for each category?

Thanks
Scott

Title: Re: make entire gallery members of the 'registered' group
Post by: Abbas Ali on November 05, 2005, 01:19:31 pm

If you want all albums to be only viewable by registered group then run the following query on the database. Use phpMyAdmin or other tool to do so. (Replace cpgPrefix with prefix you have used.)

Code: [Select]

UPDATE cpgPrefix_albums SET visibility='2'

Note: This will affect all the albums in one shot. Be careful. Also do take a backup before doing so.

Title: Re: make entire gallery members of the 'registered' group
Post by: Joachim Müller on November 06, 2005, 02:56:52 pm

Alternatively, use the solution from the FAQ: http://coppermine.sourceforge.net/faq.php#registeredUsersOnly