Changeset 10770

Timestamp:

May 5, 2011, 10:28:44 AM (13 years ago)

Author:

plg

Message:

bug 2296 fixed: missing join clause, all albums with at least 1 photo inside were considered as not really empty if even if containing pending photos (level 16)

File:

• extensions/community/include/functions_community.inc.php (modified) (1 diff)

extensions/community/include/functions_community.inc.php

@@ -144 +144 @@
     category_id
   FROM '.IMAGE_CATEGORY_TABLE.'
-    JOIN '.IMAGES_TABLE.'
+    JOIN '.IMAGES_TABLE.' ON image_id = id
   WHERE category_id IN ('.implode(',', $empty_categories).')
     AND level > '.$user['level'].'