|Posted: Thu, 2005-11-17 16:13|
Experimenting with a new Gallery 2 installation (great work BTW) has left my gallery many albums using different album settings. The resized images and thumbnail sizes being two of the most time consuming to fix.
A few of the changes I'd like to do are:
1. Set resized images to 640, 800, 1024 and 1600 pixel height and width.
It seems sub-albums do not inherit my gallery album settings and/or changing the gallery album is not recursive. Given the number of albums, it would be much easier to do this with an SQL UPDATE.
2. Set all thumbnails to 150 pixels squared.
Well, I was using 120 for a while and changed my mind. Now its a big mix-up. :-P
3. Reset permissions in selected albums.
Sometimes users add photos to their private albums that were meant for a shared gallery. Albums/items moved to the shared gallery maintain their permissions; making for a time consuming task of deleting permissions and recursively setting them to the shared gallery values. I'd rather have an SQL statement ready to go (e.g. mysql -p gallery2 < reset-shared.sql) in a script of some sort. Actually, this would be helpful for my paranoia that my private items will accidently be reset to public (at least a cron job could keeep fixing them JIC such an accident occurs).
What I would like is some sort of documentation on the tables/colums used by Gallery 2... of course, I'll just take the answer if you have it! A search in How To, FAQ and the forums turned up nothing.