Changeset 2091 for trunk/include

Timestamp:

Sep 14, 2007, 1:30:46 AM (17 years ago)

Author:

rvelices

Message:

• merge content of layout.css and popuphelp.css (very few lines) into existing css -> faster page loading the first time (avoid 2 http requests)
• optimized sql for $confdisplay_fromto in category_cats.inc.php

File:

• trunk/include/category_cats.inc.php (modified) (5 diffs)

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).') 
+  WHERE category_id IN ('.implode(',', $category_ids).')
 '.get_sql_condition_FandF
   (
@@ -173 +171 @@
       (
         'visible_categories' => 'category_id',
-        'visible_images' => 'image_id'
+        'visible_images' => 'id'
       ),
     'AND'
@@ -187 +185 @@
         );
     }
-    // echo '<pre>'; print_r($dates_of_category); echo '</pre>';
   }
 }
@@ -264 +261 @@
                                   ),
           'DESCRIPTION' =>
-            trigger_event('render_category_literal_description', 
-              trigger_event('render_category_description', 
+            trigger_event('render_category_literal_description',
+              trigger_event('render_category_description',
                 @$category['comment'])),
           'NAME'  => $name,
@@ -277 +274 @@
           $from = $dates_of_category[ $category['id'] ]['from'];
           $to   = $dates_of_category[ $category['id'] ]['to'];
-        
+
           if (!empty($from))
           {
             $info = '';
-          
+
             if ($from == $to)
             {