Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: origin album name under random files  (Read 1691 times)

0 Members and 1 Guest are viewing this topic.

donmarkuso

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
origin album name under random files
« 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
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: origin album name under random files
« Reply #1 on: April 16, 2012, 02:36:54 pm »

Open include/functions.inc.php, find
Code: [Select]
        $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
Code: [Select]
        $select_column_list[] = 'a.title AS filename';
Logged
Pages: [1]   Go Up
 

Page created in 0.193 seconds with 20 queries.