Is it possible? I'm looking and can't figure out a good way to do it. I know random thumbs etc can be done, but I'd like to have my albums random sort so that every refresh the gallery page has them in a different order.
Is this something that would have to be done via sql query?
We at least don't have a function or option for that. But without some custom theming that won't be possible. Think of the possible usability problems with pagination! You could bascially get the same albums from page 1 on page 2 since it is random...
If you use only one page for the toplevel albums you can do that using our object model. You would have to get the albums as an array ($galleryobj->getAlbums()) and then could use PHP's shuffle() function on that. Then create album objects and output them.