forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 themes/skins/templates => Topic started by: aunrea on May 02, 2008, 01:21:39 am

Title: [Solved]: Category Thumb Being Last Added Image
Post by: aunrea on May 02, 2008, 01:21:39 am

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

Title: Re: Category Thumb Being Last Added Image
Post by: Nibbler on May 02, 2008, 02:08:42 pm

Update your gallery. Then edit index.php. Find

Code: [Select]

                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]

                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";


Title: Re: Category Thumb Being Last Added Image
Post by: aunrea on May 06, 2008, 10:51:52 pm

That worked! Thanks!