Text only | Text with Images

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: DefenceTalk.com on November 11, 2003, 04:13:41 AM

Title: Changing upload permissions for ALL albums with one click?
Post by: DefenceTalk.com on November 11, 2003, 04:13:41 AM
Hi,

I have somewhere close to 174 Albums, and changing default upload permissions on them one by one is a pain!!! I would like to know if there is quicker and easier way to do this? I tried going into phpmyadmin tool and editing the table... but too takes long. Any solution?

Thanks
Title: Changing upload permissions for ALL albums with one click?
Post by: Tarique Sani on November 11, 2003, 04:18:21 AM
Use SQL with phpMyAdmin
Title: Changing upload permissions for ALL albums with one click?
Post by: Joachim Müller on November 11, 2003, 07:35:06 AM
something like
Code Select
UPDATE `cpg11d_albums` SET `uploads` = 'YES' WHERE `AID` > '25';(This will make all albums uploadable that are newer than your album # 25. Leaving out the "WHERE" bit will make them all uploadable...
Hope you get the idea...

GauGau
Text only | Text with Images