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
-
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:
Visitors can upload files - No
Visitors can post comments - Yes
Visitors can rate files - Yes
to
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.
-
I'm sure I've posted this before.
delete.php
$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_
UPDATE cpg_albums SET uploads = 'YES', comments = 'YES', votes = 'YES'
-
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
SELECT * FROM `cpg133_albums` WHERE 1
Thanks for your time and patience :)