forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 permissions => Topic started by: PsycoEwok on May 02, 2006, 10:59:18 am

Title: change default album permissions
Post by: PsycoEwok on May 02, 2006, 10:59:18 am
This is a really annoying problem I've been having, and I even had a solution at one point but our gallery recently had to be moved to a new server and for some reason the problem has appeared again. I've searched all the boards here for a solution but still can't find one, so any help will be greatly appreciated.

All I'm wanting to do is change the default album permissions from:
Code: [Select]
Visitors can upload files - No
Visitors can post comments - Yes
Visitors can rate files - Yes

to

Code: [Select]
Visitors can upload files - Yes
Visitors can post comments - Yes
Visitors can rate files - Yes

It's really annoying to have to go and change this manually for each new album I create.

Also, is there any way that I could 'quickly' change ALL albums' current permissions to match what I just stated above? I have over 500 albums in this particular gallery, and I REALLY don't want to have to check the permissions of each and every one to make sure that they're set right.
Title: Re: change default album permissions
Post by: Nibbler on May 02, 2006, 04:05:51 pm
I'm sure I've posted this before.

delete.php

Code: [Select]
$query = "INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, uploads, pos) VALUES ('$category', '" . addslashes($op['album_nm']) . "', 'NO',  '{$op['album_sort']}')";
Change the NO to YES. To change all albums run a query in phpmyadmin, using your actual prefix in place of cpg_

Code: [Select]
UPDATE cpg_albums SET uploads = 'YES', comments = 'YES', votes = 'YES'
Title: Re: change default album permissions
Post by: CrestoneCreations on September 15, 2010, 09:22:04 pm
So I'm not very experienced with running SQL queries on databases and am looking for a bit of hand holding on this.

My objective is to change "Album can be viewed by" from "Members of the Registered Group" to "Everybody (public album)"

I am sure your instructions are clear, but would you give a few more steps to help me out -

I'm in phpMyAdmin, selected cpg_133albums, clicked the SQL tab and now in the Run field there is the following
Code: [Select]
SELECT * FROM `cpg133_albums` WHERE 1

Thanks for your time and patience  :)