change default album permissions

[PsycoEwok]

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 Expand

Visitors can upload files - No
Visitors can post comments - Yes
Visitors can rate files - Yes

to

Code Select Expand

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.

[Nibbler]

I'm sure I've posted this before.

delete.php

Code Select Expand

$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 Expand

UPDATE cpg_albums SET uploads = 'YES', comments = 'YES', votes = 'YES'

[CrestoneCreations]

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 Expand

SELECT * FROM `cpg133_albums` WHERE 1


Thanks for your time and patience