coppermine-gallery.com/forum

Hello there!
I was wondering if someone knows how the album thumbnail is saved in the database, because I am trying to fetch it with an I cant find where is the album thumbnail

thank u

Quote from: Sweetener on July 04, 2018, 01:40:05 AM
Hello there!
I was wondering if someone knows how the album thumbnail is saved in the database, because I am trying to fetch it with an I cant find where is the album thumbnail

thank u

In the cpgxxx_albums table, the column 'thumb' contains the pid of the album thumbnail - which is the 'pid' in the cpgxxx_pictures table of the thumb image.
The images themselves are of course not in the database - the name of the thumb file is constructed from the 'filepath' and 'filename' in the cpgxxx_pictures table along with the 'thumb_pfx' value from cpgxxx_config:
  {filepath}{thumb_pfx}{filename} would be the thumbnail displayed for the album.

Quote from: gmc on July 04, 2018, 03:34:59 AM
In the cpgxxx_albums table, the column 'thumb' contains the pid of the album thumbnail - which is the 'pid' in the cpgxxx_pictures table of the thumb image.
The images themselves are of course not in the database - the name of the thumb file is constructed from the 'filepath' and 'filename' in the cpgxxx_pictures table along with the 'thumb_pfx' value from cpgxxx_config:
  {filepath}{thumb_pfx}{filename} would be the thumbnail displayed for the album.

Thank you so much  ;)