forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: Sweetener on July 04, 2018, 01:40:05 am

Title: Album Thumbnail in database
Post by: 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

Title: Re: Album Thumbnail in database
Post by: gmc on July 04, 2018, 03:34:59 am

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.

Title: Re: Re: Album Thumbnail in database
Post by: Sweetener on July 04, 2018, 02:37:57 pm

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  ;)