Support » Plugin: NGG Sidebar Widget » [Plugin: NGG Sidebar Widget] More order options
5 years, 1 month ago
I need to show the galleries with the most recent additions. I’m comfortable coding this myself, are you interested in having the code?
I intend to do something like
SELECT DISTINCTgalleryidFROMngg_picturesORDER BYimagedateDESC LIMIT 4
DESC LIMIT 4
to get the ids of the galleries I want to show. I’m still pondering how to make this not hurt the server too bad. 🙂
WordPress ate my query:
SELECT DISTINCT galleryid FROM ngg_pictures ORDER BY imagedate DESC LIMIT 4
How about only displaying 1 image but allowing you to scroll others when it’s opened?
5 years ago
This is done. I’ve tweaked NGG Sidebar Widget so that the first gallery icon shown is the one with the most recent image in it, and descending accordingly.