coppermine-gallery.com/forum

Hello,

I have about 3000 albums  . How can I set the permission at one step to "Visitors can upload files" for all albums. If I click at every album "yes" it will take a very, very, very long time!

Thank you very much

Run a query directly in phpmyadmin.

UPDATE cpg_albums SET uploads = 'YES'

Change the prefix as required.

http://forum.coppermine-gallery.net/index.php/topic,43322.0.html

Thank you, but it won't work  :-[

I have changed:

---

cpg14x_albums

---

ALTER TABLE `cpg14x_albums` CHANGE `uploads` `uploads` ENUM( 'YES', 'NO' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'YES'

---

delete.php

---

$query = "INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, uploads, pos, description) VALUES ('$category', '" . addslashes($op['album_nm']) . "', 'YES',  '{$op['album_sort']}', '')";

---

and

---

$query = "INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, uploads, pos, description, visibility) VALUES ('$category', '".addslashes($op['album_nm'])."', 'YES',  '{$op['album_sort']}', '', " . (FIRST_USER_CAT + USER_ID) . ")";
               } else {
               $query = "INSERT INTO {$CONFIG['TABLE_ALBUMS']} (category, title, uploads, pos, description) VALUES ('$category', '".addslashes($op['album_nm'])."', 'Yes',  '{$op['album_sort']}', '')";

That sets the default for new albums to 'YES'. What you asked for was to mass change existing files so use the UPDATE query I posted.

Yes I did that, but it won't work  :'(

http://img413.imageshack.us/img413/2076/image1cw4.jpg [Edit GauGau] Replaced hotlinked image with attachment [/Edit]

That screenshot doesn't show anything relevent. Click on the SQL tab and paste in

UPDATE cpg14x_albums SET uploads = 'YES'

and submit the form.

Ah okay, I'm an absolut beginner with phpMyAdmin  ;) ;D Now It works! Thank you so much!