Hello.
I use latest version of coppermine.
With plugin KEYWORD_ADD i assign keywords to my albums. When i search keyword it show me all pictures in all albums with this keyword.
What i should edit to see albums by keywords together or instead of images.
For example: i added keyword HELLO in all pictures in 2 album. Now when i search HELLO - i get bunch of pictures from 2 albums. Instead of this i want to get this 2 albums.
How can i make this?
Hello!
Just find in include/search.inc.php this:
$album_query = "SELECT aid, title, description FROM `{$CONFIG['TABLE_ALBUMS']}` AS p"
." WHERE (`title` " . implode(" $type `title` ",$albcat_terms) . ") $FORBIDDEN_SET";
$result = cpg_db_query($album_query);
and replace it by
$album_query = "SELECT `{$CONFIG['TABLE_PICTURES']}`.`aid`,`{$CONFIG['TABLE_ALBUMS']}`.`title`,`{$CONFIG['TABLE_ALBUMS']}`.`description` FROM `{$CONFIG['TABLE_PICTURES']}`,`{$CONFIG['TABLE_ALBUMS']}` WHERE (`keywords` " . implode(" $type `title` ",$albcat_terms) . ") AND `{$CONFIG['TABLE_PICTURES']}`.`aid`=`{$CONFIG['TABLE_ALBUMS']}`.`aid` $FORBIDDEN_SET GROUP BY `{$CONFIG['TABLE_PICTURES']}`.`aid`";
$result = cpg_db_query($album_query );
Work perfectly for me
Small correction:
$album_query = "SELECT `{$CONFIG['TABLE_PICTURES']}`.`aid`,`{$CONFIG['TABLE_ALBUMS']}`.`title`,`{$CONFIG['TABLE_ALBUMS']}`.`description` FROM `{$CONFIG['TABLE_PICTURES']}`,`{$CONFIG['TABLE_ALBUMS']}` WHERE (`keywords` " . implode(" $type `keywords` ",$albcat_terms) . ") AND `{$CONFIG['TABLE_PICTURES']}`.`aid`=`{$CONFIG['TABLE_ALBUMS']}`.`aid` $FORBIDDEN_SET GROUP BY `{$CONFIG['TABLE_PICTURES']}`.`aid`";
$result = cpg_db_query($album_query );
Thanks for resolving your thread.