Changeset 2424 for trunk/include/section_init.inc.php

Timestamp:

Jul 6, 2008, 12:13:28 AM (16 years ago)

Author:

rvelices

Message:

• feature 832: Folders with no images sql optimization
• recent pics are sorted by date descending, and only then by conforder_by
• updated prototype.js to version 1.6

File:

• trunk/include/section_init.inc.php (modified) (4 diffs)

trunk/include/section_init.inc.php

@@ -236 +236 @@
       { // get all allowed sub-categories
         $query = '
-SELECT id 
+SELECT id
   FROM '.CATEGORIES_TABLE.'
-  WHERE 
+  WHERE
     uppercats LIKE "'.$page['category']['uppercats'].',%" '
     .get_sql_condition_FandF(
@@ -395 +395 @@
   else if ($page['section'] == 'recent_pics')
   {
+    if ( !isset($page['super_order_by']) )
+    {
+      $conf['order_by'] = str_replace(
+        'ORDER BY ',
+        'ORDER BY date_available DESC,',
+        $conf['order_by']
+        );
+    }
+
     $query = '
 SELECT DISTINCT(id)
@@ -524 +533 @@
   WHERE file LIKE "' . $page['image_file'] . '.%" ESCAPE "|"';
     if ( count($page['items']) < 500)
-    {// for very large item sets do not add IN - because slow 
+    {// for very large item sets do not add IN - because slow
       $query .= '
   AND id IN ('.implode(',',$page['items']).')
@@ -534 +543 @@
       case 0: break;
       case 1:
-        list($page['image_id'], $page['image_file']) = mysql_fetch_row($result); 
+        list($page['image_id'], $page['image_file']) = mysql_fetch_row($result);
         break;
       default: // more than 1 file name match