Changeset 6871 for branches/2.1/include

Timestamp:

Sep 9, 2010, 3:21:06 PM (14 years ago)

Author:

rvelices

Message:

merge -r6870 from trunk
bug fix (recent some months): RSS and mail notifications could send the same thumbnail several times

File:

• branches/2.1/include/functions_notification.inc.php (modified) (2 diffs)

branches/2.1/include/functions_notification.inc.php

@@ -497 +497 @@
     { // 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.'
@@ -516 +516 @@
     {// 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