Changeset 2543 for trunk/include/functions_notification.inc.php

Timestamp:

Sep 17, 2008, 3:48:31 AM (16 years ago)

Author:

rvelices

Message:

• fix status header (web services + IE6 min display)
• sql optims in feed /notification
• dont send cookie for 10 years from admin/history.php

File:

• trunk/include/functions_notification.inc.php (modified) (7 diffs)

trunk/include/functions_notification.inc.php

@@ -36 +36 @@
  * @return string sql where
  */
-function get_std_sql_where_restrict_filter($prefix_condition, $force_one_condition = false)
+function get_std_sql_where_restrict_filter($prefix_condition, $img_field='ic.image_id', $force_one_condition = false)
 {
   return get_sql_condition_FandF
@@ -44 +44 @@
                 'forbidden_categories' => 'ic.category_id',
                 'visible_categories' => 'ic.category_id',
-                'visible_images' => 'ic.image_id'
+                'visible_images' => $img_field
               ),
             $prefix_condition,
@@ -90 +90 @@
   WHERE date_available > \''.$start.'\'
     AND date_available <= \''.$end.'\'
-      '.get_std_sql_where_restrict_filter('AND').'
+      '.get_std_sql_where_restrict_filter('AND', 'id').'
 ;';
       break;
@@ -98 +98 @@
   WHERE date_available > \''.$start.'\'
     AND date_available <= \''.$end.'\'
-      '.get_std_sql_where_restrict_filter('AND').'
+      '.get_std_sql_where_restrict_filter('AND', 'id').'
 ;';
       break;
@@ -435 +435 @@
   global $conf, $user;
 
-  $where_sql = get_std_sql_where_restrict_filter('WHERE', true);
+  $where_sql = get_std_sql_where_restrict_filter('WHERE', 'i.id', true);
 
   $query = '
@@ -441 +441 @@
       COUNT(DISTINCT id) nb_elements,
       COUNT(DISTINCT category_id) nb_cats
-  FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=image_id
+  FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=image_id
   '.$where_sql.'
   GROUP BY date_available
@@ -460 +460 @@
       $query = '
 SELECT DISTINCT id, path, name, tn_ext, file
-  FROM '.IMAGES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=image_id
+  FROM '.IMAGES_TABLE.' i INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id=image_id
   '.$where_sql.'
     AND date_available="'.$dates[$i]['date_available'].'"