From 855a7dbb7a3f7ae325cde96ccb24f72b807ec225 Mon Sep 17 00:00:00 2001 From: rvelices Date: Thu, 9 Sep 2010 13:15:50 +0000 Subject: bug fix (recent some months): RSS and mail notifications could send the same thumbnail several times git-svn-id: http://piwigo.org/svn/trunk@6870 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/functions_notification.inc.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/include/functions_notification.inc.php b/include/functions_notification.inc.php index 363ea7e58..4f5f20e80 100644 --- a/include/functions_notification.inc.php +++ b/include/functions_notification.inc.php @@ -496,7 +496,7 @@ SELECT date_available, if ($max_elements>0) { // get some thumbnails ... $query = ' -SELECT id, path, name, tn_ext, file +SELECT DISTINCT id, path, name, tn_ext, file FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=image_id '.$where_sql.' AND date_available=\''.$dates[$i]['date_available'].'\' @@ -515,7 +515,7 @@ SELECT id, path, name, tn_ext, file if ($max_cats>0) {// get some categories ... $query = ' -SELECT c.uppercats, COUNT(DISTINCT i.id) AS img_count +SELECT DISTINCT c.uppercats, COUNT(DISTINCT i.id) AS img_count FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id=image_id INNER JOIN '.CATEGORIES_TABLE.' c ON c.id=category_id '.$where_sql.' @@ -635,4 +635,4 @@ if(!function_exists("strptime")) return $res; } } -?> \ No newline at end of file +?> -- cgit v1.2.3