Changeset 652 for trunk/include/functions_category.inc.php

Timestamp:

Dec 20, 2004, 11:25:05 PM (19 years ago)

Author:

plg

Message:

• for searching in sub-categories, use the existing get_subcat_ids function

• bug fixed : category total elements count for best rated when $userforbidden_categories is not empty

File:

• trunk/include/functions_category.inc.php (modified) (2 diffs)

trunk/include/functions_category.inc.php

@@ -512 +512 @@
           {
             // searching all the categories id of sub-categories
-            $search_cat_clauses = array();
-            foreach ($search['fields']['cat']['words'] as $cat_id)
-            {
-              $local_clause = 'uppercats REGEXP \'(^|,)'.$cat_id.'(,|$)\'';
-              array_push($search_cat_clauses, $local_clause);
-            }
-            array_walk($search_cat_clauses,
-                       create_function('&$s', '$s = "(".$s.")";'));
-            
-            $query = '
-SELECT DISTINCT(id) AS id
-  FROM '.CATEGORIES_TABLE.'
-  WHERE '.implode(' OR ', $search_cat_clauses).'
-;';
-            $result = pwg_query($query);
-            $cat_ids = array();
-            while ($row = mysql_fetch_array($result))
-            {
-              array_push($cat_ids, $row['id']);
-            }
-            $local_clause = 'category_id IN (';
-            $local_clause.= implode(',',$cat_ids);
-            $local_clause.= ')';
-            array_push($clauses, $local_clause);
+            $cat_ids = get_subcat_ids($search['fields']['cat']['words']);
           }
           else
           {
-            $local_clause = 'category_id IN (';
-            $local_clause.= implode(',',$search['fields']['cat']['words']);
-            $local_clause.= ')';
-            array_push($clauses, $local_clause);
-          }
+            $cat_ids = $search['fields']['cat']['words'];
+          }
+          
+          $local_clause = 'category_id IN ('.implode(',', $cat_ids).')';
+          array_push($clauses, $local_clause);
         }
 
@@ -686 +663 @@
 SELECT COUNT(1) AS count
   FROM '.IMAGES_TABLE.'
+    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
   '.$page['where'].'
 ;';