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

Timestamp:

Jun 22, 2011, 3:04:45 PM (13 years ago)

Author:

mistic100

Message:

feature:2358 allow non-recursive mode for get_random_image_in_category

File:

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

trunk/include/functions_category.inc.php

@@ -505 +505 @@
  * we need $category['uppercats'], $category['id'], $category['count_images']
  */
-function get_random_image_in_category($category)
+function get_random_image_in_category($category, $recursive=true)
 {
   $image_id = null;
@@ -514 +514 @@
   FROM '.CATEGORIES_TABLE.' AS c
     INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON ic.category_id = c.id
-  WHERE (c.id='.$category['id'].' OR uppercats LIKE \''.$category['uppercats'].',%\')'
-    .get_sql_condition_FandF
+  WHERE ';
+    if ($recursive)
+    {
+      $query.= '
+    (c.id='.$category['id'].' OR uppercats LIKE \''.$category['uppercats'].',%\')';
+    }
+    else
+    {
+      $query.= '
+    c.id='.$category['id'];
+    }
+    $query.= '
+    '.get_sql_condition_FandF
     (
       array