Changeset 1971 for trunk/include/category_cats.inc.php

Timestamp:

04/22/07 18:19:16 (6 years ago)

Author:

rub

Message:

Add filter conditions on new sql query added for feature 660.

Files:

• trunk/include/category_cats.inc.php (modified) (1 diff)

trunk/include/category_cats.inc.php

@@ -164 +164 @@
     MAX(date_creation) AS date_creation_max
   FROM '.IMAGE_CATEGORY_TABLE.'
+    INNER JOIN '.USER_CACHE_CATEGORIES_TABLE.'
+      ON category_id = cat_id and user_id = '.$user['id'].'
     INNER JOIN '.IMAGES_TABLE.' ON image_id = id
   WHERE category_id IN ('.implode(',', $category_ids).') 
+'.get_sql_condition_FandF
+  (
+    array
+      (
+        'visible_categories' => 'category_id',
+        'visible_images' => 'image_id'
+      ),
+    'AND'
+  ).'
   GROUP BY category_id
 ;';