Advanced search  

News:

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

Pages: [1]   Go Down

Author Topic: Album Thumbnail in database  (Read 301 times)

0 Members and 1 Guest are viewing this topic.

Sweetener

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
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
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 741
    • 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

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
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  ;)
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 20 queries.