Coppermine Photo Gallery to SlideShowPro
cpg2ssp.php version 1.0 | by webXS24.com
Development
Connections between attributes and filespaths for SSP and the Coppermine database tables
This document describes more exact where the script finds the data in the tables of Coppermine and in the filesystem.
The <album> tag
id
The id of the album as in Coppermine is used to support permalinks
title
The album title is queried from table albums.title. The user can change it in the form
description
The album description is queried from table albums.description. User can change it in the form
lgPath
A query finds all the pictures that belongs to an album. In pictures.filepath is the base path. If the uploaded pictures are bigger than the configured intermediate size, they keep the original names and per photo a normal_filename.jpg and a thumb_filename.jpg are generated by Coppermine. If the pictures were the intermediate size or smaller, they keep their original names and only a thumb_filename is created.
The script finds this out and create a filepath like:
/coppermine/albums/album1/ or
/coppermine/albums/album1/normal_
tnPath
See lgPath above. The path created is:
/coppermine/albums/album1/thumb_
tn
A query on albums.thumb finds the pid (pictureID) and finds the path of that thumb in pictures.filepath
audio
The audio functionality cannot be put in a standard Coppermine installation. The workaround is to drop the .mp3 files in a special folder. The path to that folder is set in the config part of cpg2ssp.php. The script searches inside the folder for all files ending with '.mp3'. All files that have that extension will show in the list of songs in the form.
audioCaption
The audio caption is filled in by the user when a song is selected
The <img> tag
src
The src is found by the same query that finds all images belonging to an album.
basepath + pictures.filepath
+ [normal_]pictures.filename
title
Comes from pictures.title
caption
Comes from pictures.caption
link
According to user configuration, the link is automaticaly created.
Depending on value of links_type, the link can be excluded, or it can be the link that is stored in cgp database — pictures.user1 "(SSP) link "—, or the link to the original size photo. All options can be set in the config part of cpg2ssp.php
target
Reads from pictures.user2 "(SSP) target ", but can also be the default set by the user
pause
Reads from pictures.user3"(SSP) pause "
