coppermine-gallery.com/forum

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: donmarkuso on April 13, 2012, 09:01:50 PM

Title: origin album name under random files
Post by: donmarkuso on April 13, 2012, 09:01:50 PM
Pardon me for bbeing such a nerd  :o

random files: is it possible to show the origin album name under each random file instead the file's name? ...without changing this in general for all thumbs?
What do I have to change and where?

http://photo.markusseidel.com
It would look much nicer with the name of a sailor (album name) under each random file.

Thank you so much

donmarkuso
Title: Re: origin album name under random files
Post by: ΑndrĂ© on April 16, 2012, 02:36:54 PM
Open include/functions.inc.php, find
        $select_columns = implode(', ', $select_column_list);

        $query = "SELECT $select_columns
                FROM {$CONFIG['TABLE_PICTURES']} AS r
                INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON a.aid = r.aid
                WHERE pid IN (" . implode(', ', $pidlist) . ")";

and above, add
        $select_column_list[] = 'a.title AS filename';