Advanced search  


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.


  • 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?
It would look much nicer with the name of a sailor (album name) under each random file.

Thank you so much



  • 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/, 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';
Pages: [1]   Go Up

Page created in 0.193 seconds with 20 queries.