Advanced search  


cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.

Pages: [1]   Go Down

Author Topic: origin album name under random files  (Read 1705 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.019 seconds with 20 queries.