Hello all,
I need an additional link list view without thumbnails of all pictures stored in our the gallery.
My first solution was the
link list from fotofreek, which is
already done. But this simple link list contains multiple entries per mushroom sort, for example:
Cortinarius rubellus (Spitzgebuckelter Rauhkopf)
Cortinarius rubellus (Spitzgebuckelter Rauhkopf)
Cortinarius rubellus (Spitzgebuckelter Rauhkopf)
A better solution should be an unique entry and beyond the number of available pictures per mushroom sort e.g.
Cortinarius rubellus (Spitzgebuckelter Rauhkopf) [3]
that links to a search with the strings "Cortinarius" AND "rubellus" AND "(Spitzgebuckelter" AND "Rauhkopf)" e.g.
thumbnails.php?album=search&type=full&search=Cortinarius+rubellus+(Spitzgebuckelter+Rauhkopf)At the attached screenshot you can see an example of such a link list view.
I saw this feature on
Fero Bednar's homepage. He wrote me, that a friend helps him to integrate this feature into CPG and he sents me the code of the function which is used for listing unique titles:
case 'list': // List unique titles fero
if ($ALBUM_SET && $CURRENT_CAT_NAME) {
$album_name = $lang_meta_album_names['list'].' -
'. $CURRENT_CAT_NAME;
} else {
$album_name = $lang_meta_album_names['list'];
}
$result = db_query("SELECT COUNT(*) from
{$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' $ALBUM_SET");
$nbEnr = mysql_fetch_array($result);
$count = $nbEnr[0];
mysql_free_result($result);
if($select_columns != '*') $select_columns .= ', title';
$result = db_query("SELECT $select_columns FROM
{$CONFIG['TABLE_PICTURES']} WHERE approved = 'YES' $ALBUM_SET ORDER BY
title ASC $limit");
$rowset = db_fetch_rowset($result);
mysql_free_result($result);
if ($set_caption) foreach ($rowset as $key => $row){
if ($row['user_id']) {
$user_link = '<br /><a href
="profile.php?uid='.$row['user_id'].'">'.$row['user_name'].'</a>';
} else {
$user_link = '';
}
$caption = "<span
class=\"thumb_caption\">".localised_date($row['ctime'],
$lastup_date_fmt).$user_link.'</span>';
$rowset[$key]['caption_text'] = $caption;
}
return $rowset;
break;
He wrote also that the code is stored in /include/functions and his link list view /list.php is a modified /thumbnails.php.
The problem are my minimal knowledge on how to integrate this feature into our CPG148 installation.
Could anyone help me please?
regards AK