Changeset 1060

Timestamp:

Mar 1, 2006, 1:48:29 AM (18 years ago)

Author:

rvelices

Message:

fix: replaced UPDATE ... LEFT JOIN for compatibility with MySql 3

File:

• trunk/admin/include/functions.php (modified) (38 diffs)

trunk/admin/include/functions.php

@@ -64 +64 @@
 
   $prefix_length = strlen($conf['prefix_thumbnail']);
-  
+
   $thumbnails = array();
   if ($opendir = @opendir($dir.'/thumbnail'))
@@ -122 +122 @@
   }
   delete_categories($category_ids);
-                
+
   // destruction of the site
   $query = '
@@ -130 +130 @@
   pwg_query($query);
 }
-        
+
 
 // The function delete_categories deletes the categories identified by the
@@ -150 +150 @@
   // sub-categories must be so
   $ids = get_subcat_ids($ids);
-  
+
   // destruction of all the related elements
   $query = '
@@ -215 +215 @@
     return;
   }
-  
+
   // destruction of the comments on the image
   $query = '
@@ -255 +255 @@
 ;';
   pwg_query($query);
-                
+
   // destruction of the image
   $query = '
@@ -280 +280 @@
 {
   global $conf;
-  
+
   // destruction of the access linked to the user
   $query = '
@@ -350 +350 @@
 {
   global $conf;
-  
+
   // retrieving all categories to update
   $cat_ids = array();
-  
+
   $query = '
 SELECT id
@@ -390 +390 @@
     return false;
   }
-  
+
   // calculate informations about categories retrieved
   $query = '
@@ -416 +416 @@
     array_push($datas, array('id' => $id, 'nb_images' => 0));
   }
-  
+
   $fields = array('primary' => array('id'),
                   'update'  => array('date_last', 'nb_images'));
@@ -468 +468 @@
         $to_rand = array_diff($wrong_representant, $to_null);
       }
-      
+
       if (count($to_null) > 0)
       {
@@ -478 +478 @@
         pwg_query($query);
       }
-      
+
       // If the random representant is not allowed, we need to find
       // categories with elements and with no representant. Those categories
@@ -497 +497 @@
             )
           );
-      
+
       if (count($to_rand) > 0)
       {
@@ -553 +553 @@
 {
   $dirs = array();
-  
+
   if (is_dir($path))
   {
@@ -611 +611 @@
         $query.= ',';
       }
-      
+
       if (!isset($insert[$dbfield]) or $insert[$dbfield] == '')
       {
@@ -710 +710 @@
       }
     }
-    
+
     $temporary_tablename = $tablename.'_'.micro_seconds();
-    
+
     $query = '
 CREATE TABLE '.$temporary_tablename.'
@@ -781 +781 @@
     $uppercats_array[$row['id']] =  $row['uppercats'];
   }
-  
+
   $datas = array();
   foreach ($uppercats_array as $id => $uppercats)
@@ -886 +886 @@
     return array();
   }
-  
+
   $uppercats = array();
 
@@ -947 +947 @@
   $current_rank = 0;
   $current_uppercat = '';
-                
+
   $query = '
 SELECT id, if(id_uppercat is null,\'\',id_uppercat) AS id_uppercat
@@ -982 +982 @@
     return array();
   }
-  
+
   // caching directories of existing categories
   $query = '
@@ -1010 +1010 @@
   // categories : id, site_id, uppercats
   $categories = array();
-  
+
   $query = '
 SELECT id, uppercats, site_id
@@ -1022 +1022 @@
     array_push($categories, $row);
   }
-  
+
   // filling $cat_fulldirs
   $cat_fulldirs = array();
@@ -1073 +1073 @@
         {
           $extension = get_extension($node);
-          
+
 //          if (in_array($extension, $conf['picture_ext']))
           if (isset($conf['flip_picture_ext'][$extension]))
@@ -1114 +1114 @@
       $fs['elements']        = array_merge($fs['elements'],
                                            $tmp_fs['elements']);
-      
+
       $fs['thumbnails']      = array_merge($fs['thumbnails'],
                                            $tmp_fs['thumbnails']);
-      
+
       $fs['representatives'] = array_merge($fs['representatives'],
                                            $tmp_fs['representatives']);
@@ -1149 +1149 @@
 {
   global $conf;
-  
+
   $query = '
 SELECT '.$conf['user_fields']['id'].' AS id
@@ -1218 +1218 @@
         $base_users
         );
-    
+
     if (count($to_delete) > 0)
     {
@@ -1240 +1240 @@
 {
   $uppercat_ids = array();
-  
+
   $query = '
 SELECT id, id_uppercat
@@ -1251 +1251 @@
       !empty($row['id_uppercat']) ? $row['id_uppercat'] : 'NULL';
   }
-  
+
   // uppercats array associates a category id to the list of uppercats id.
   $uppercats = array();
-  
+
   foreach (array_keys($uppercat_ids) as $id)
   {
@@ -1298 +1298 @@
   $cat_ids = array_from_query($query, 'storage_category_id');
   $fulldirs = get_fulldirs($cat_ids);
- 
+
   foreach ($cat_ids as $cat_id)
   {
@@ -1326 +1326 @@
   }
   $query .= ' GROUP BY element_id;';
-  
+
   $result = pwg_query($query);
 
   $datas = array();
-  
+
   while ($row = mysql_fetch_array($result))
   {
@@ -1341 +1341 @@
       );
   }
-  
+
   mass_updates(
     IMAGES_TABLE,
@@ -1352 +1352 @@
 
   $query='
-UPDATE '.IMAGES_TABLE .' 
+SELECT id FROM '.IMAGES_TABLE .'
   LEFT JOIN '.RATE_TABLE.' ON id=element_id
+  WHERE element_id IS NULL AND average_rate IS NOT NULL';
+  if ( $element_id != -1 )
+  {
+    $query .= ' AND id=' . $element_id;
+  }
+  $to_update = array_from_query( $query, 'id');
+
+  if ( !empty($to_update) )
+  {
+    $query='
+UPDATE '.IMAGES_TABLE .'
   SET average_rate=NULL
-  WHERE element_id IS NULL';
-  if ( $element_id != -1 )
-  {
-    $query .= ' AND id=' . $element_id;
-  }
-  pwg_query($query);
+  WHERE id IN (' . implode(',',$to_update) . ')';
+    pwg_query($query);
+  }
 }
 
@@ -1383 +1391 @@
 
   $categories = array();
-  
+
   $query = '
 SELECT id, id_uppercat, status, uppercats
@@ -1399 +1407 @@
         );
   }
-  
+
   // is the movement possible? The movement is impossible if you try to move
   // a category in a sub-category or itself
@@ -1425 +1433 @@
     }
   }
-  
+
   $tables =
     array(
@@ -1431 +1439 @@
       GROUP_ACCESS_TABLE => 'group_id'
       );
-  
+
   $query = '
 UPDATE '.CATEGORIES_TABLE.'
@@ -1472 +1480 @@
         {
           $subcats = get_subcat_ids(array($cat_id));
-        
+
           foreach ($tables as $table => $field)
           {
@@ -1488 +1496 @@
 ;';
             $parent_access = array_from_query($query, $field);
-          
+
             $to_delete = array_diff($parent_access, $category_access);
-          
+
             if (count($to_delete) > 0)
             {