Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: change default album permissions  (Read 5874 times)

0 Members and 1 Guest are viewing this topic.

PsycoEwok

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 3
change default album permissions
« 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.
Logged

Nibbler

  • Guest
Re: change default album permissions
« Reply #1 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'
Logged

CrestoneCreations

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Re: change default album permissions
« Reply #2 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  :)
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.