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: Album Thumbnail in database  (Read 3151 times)

0 Members and 1 Guest are viewing this topic.

Sweetener

  • Contributor
  • Coppermine regular visitor
  • ***
  • Country: 00
  • Offline Offline
  • Posts: 64
Album Thumbnail in database
« 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

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: Album Thumbnail in database
« Reply #1 on: July 04, 2018, 03:34:59 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.
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

Sweetener

  • Contributor
  • Coppermine regular visitor
  • ***
  • Country: 00
  • Offline Offline
  • Posts: 64
Re: Re: Album Thumbnail in database
« Reply #2 on: July 04, 2018, 02:37:57 pm »

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  ;)
Pages: [1]   Go Up
 

Page created in 0.034 seconds with 20 queries.