[Solved]: Category Thumb Being Last Added Image

[aunrea]

Is there a way to have the category thumb be the last added image to that category, instead of a pre-selected image? I tried using cpmFetch to do it but I couldn't figure out how to get the category id.

I am using Coppermine 1.4.16 Modded by Stramm version.
My gallery is located at http://candaceduffyjones.com/gallery

[Nibbler]

Update your gallery. Then edit index.php. Find

Code Select Expand


                if ($subcat['thumb'] > 0) {
                    $sql = "SELECT filepath, filename, url_prefix, pwidth, pheight " . "FROM {$CONFIG['TABLE_PICTURES']} " . "WHERE pid='{$subcat['thumb']}'" . $pic_filter;


Change to

Code Select Expand


                if ($pic_count) {
                    $sql = "SELECT filepath, filename, url_prefix, pwidth, pheight FROM {$CONFIG['TABLE_PICTURES']} as p, {$CONFIG['TABLE_ALBUMS']} as a WHERE p.aid = a.aid AND approved='YES' AND category = {$subcat['cid']} " . $album_filter . " ORDER BY pid DESC LIMIT 1";


[aunrea]

That worked! Thanks!