Changeset 29052

Timestamp:

Jul 17, 2014, 8:47:07 PM (10 years ago)

Author:

rvelices

Message:

more query2array on admin side

File:

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

trunk/admin/include/functions.php

@@ -42 +42 @@
   WHERE site_id = '.$id.'
 ;';
-  $category_ids = array_from_query($query, 'id');
+  $category_ids = query2array($query, null, 'id');
   delete_categories($category_ids);
 
@@ -84 +84 @@
 '.wordwrap(implode(', ', $ids), 80, "\n").')
 ;';
-  $element_ids = array_from_query($query, 'id');
+  $element_ids = query2array($query, null, 'id');
   delete_elements($element_ids);
 
@@ -96 +96 @@
   WHERE category_id IN ('.implode(',', $ids).')
 ;';
-    $image_ids_linked = array_from_query($query, 'image_id');
+    $image_ids_linked = query2array($query, null, 'image_id');
 
     if (count($image_ids_linked) > 0)
@@ -109 +109 @@
     AND category_id NOT IN ('.implode(',', $ids).')
 ;';
-        $image_ids_not_orphans = array_from_query($query, 'image_id');
+        $image_ids_not_orphans = query2array($query, null, 'image_id');
         $image_ids_to_delete = array_diff($image_ids_linked, $image_ids_not_orphans);
       }
@@ -261 +261 @@
     }
   }
-  
+
   $ids_str = wordwrap(implode(', ', $ids), 80, "\n");
 
@@ -320 +320 @@
   WHERE representative_picture_id IN ('. $ids_str .')
 ;';
-  $category_ids = array_from_query($query, 'id');
+  $category_ids = query2array($query, null, 'id');
   if (count($category_ids) > 0)
   {
@@ -401 +401 @@
       $orphan_tag_ids[] = $tag['id'];
     }
-    
+
     delete_tags($orphan_tag_ids);
   }
@@ -419 +419 @@
   WHERE tag_id IS NULL
 ;';
-  return array_from_query($query);
+  return query2array($query);
 }
 
@@ -459 +459 @@
     AND i.id IS NULL
 ;';
-  $wrong_representant = array_from_query($query, 'id');
+  $wrong_representant = query2array($query, null, 'id');
 
   if (count($wrong_representant) > 0)
@@ -484 +484 @@
     AND '.sprintf($where_cats, 'category_id').'
 ;';
-    $to_rand = array_from_query($query, 'id');
+    $to_rand = query2array($query, null, 'id');
     if (count($to_rand) > 0)
     {
@@ -506 +506 @@
 ;';
   $result = pwg_query($query);
-  $orphan_image_ids = array_from_query($query, 'image_id');
+  $orphan_image_ids = query2array($query, null, 'image_id');
 
   if (count($orphan_image_ids) > 0)
@@ -701 +701 @@
     pwg_query($query);
   }
-  
+
   // make a category private => all its child categories become private
   if ($value == 'private')
   {
     $subcats = get_subcat_ids($categories);
-    
+
     $query = '
 UPDATE '.CATEGORIES_TABLE.'
@@ -740 +740 @@
     // A6 permission removed to U4
     // A7 no permission removed
-    // 
+    //
     // 1) we must extract "top albums": A2, A5 and A6
     // 2) for each top album, decide which album is the reference for permissions
@@ -746 +746 @@
 
     // step 1, search top albums
-    $all_categories = array();
     $top_categories = array();
     $parent_ids = array();
-    
+
     $query = '
 SELECT
@@ -760 +759 @@
   WHERE id IN ('.implode(',', $categories).')
 ;';
-    $result = pwg_query($query);
-    while ($row = pwg_db_fetch_assoc($result))
-    {
-      $all_categories[] = $row;
-    }
-    
+    $all_categories = query2array($query);
     usort($all_categories, 'global_rank_compare');
 
@@ -771 +765 @@
     {
       $is_top = true;
-      
+
       if (!empty($cat['id_uppercat']))
       {
@@ -796 +790 @@
 
     // step 2, search the reference album for permissions
-    // 
+    //
     // to find the reference of each top album, we will need the parent albums
     $parent_cats = array();
@@ -809 +803 @@
   WHERE id IN ('.implode(',', $parent_ids).')
 ;';
-      $result = pwg_query($query);
-      while ($row = pwg_db_fetch_assoc($result))
-      {
-        $parent_cats[$row['id']] = $row;
-      }
+      $parent_cats= query2array($query, 'id');
     }
 
@@ -844 +834 @@
   WHERE cat_id = '.$ref_cat_id.'
 ;';
-        $ref_access = array_from_query($query, $field);
+        $ref_access = query2array($query, null, $field);
 
         if (count($ref_access) == 0)
@@ -950 +940 @@
   WHERE dir IS NOT NULL
 ;';
-  $cat_dirs = simple_hash_from_query($query, 'id', 'dir');
+  $cat_dirs = query2array($query, 'id', 'dir');
 
   // caching galleries_url
@@ -957 +947 @@
   FROM '.SITES_TABLE.'
 ;';
-  $galleries_url = simple_hash_from_query($query, 'id', 'galleries_url');
+  $galleries_url = query2array($query, 'id', 'galleries_url');
 
   // categories : id, site_id, uppercats
@@ -967 +957 @@
 '.wordwrap(implode(', ', $cat_ids), 80, "\n").')
 ;';
-  $categories = array_from_query($query);
+  $categories = query2array($query);
 
   // filling $cat_fulldirs
@@ -1027 +1017 @@
           $extension = get_extension($node);
 
-//          if (in_array($extension, $conf['picture_ext']))
           if (isset($conf['flip_picture_ext'][$extension]))
           {
@@ -1034 +1023 @@
               $fs['thumbnails'][] = $path.'/'.$node;
             }
-            else if (basename($path) == 'pwg_representative')
+            elseif (basename($path) == 'pwg_representative')
             {
               $fs['representatives'][] = $path.'/'.$node;
@@ -1043 +1032 @@
             }
           }
-//          else if (in_array($extension, $conf['file_ext']))
-          else if (isset($conf['flip_file_ext'][$extension]))
+          elseif (isset($conf['flip_file_ext'][$extension]))
           {
             $fs['elements'][] = $path.'/'.$node;
           }
         }
-        else if (is_dir($path.'/'.$node) and $node != 'pwg_high' and $recursive)
+        elseif (is_dir($path.'/'.$node) and $node != 'pwg_high' and $recursive)
         {
           $subdirs[] = $node;
@@ -1090 +1078 @@
   FROM '.USERS_TABLE.'
 ;';
-  $base_users = array_from_query($query, 'id');
+  $base_users = query2array($query, null, 'id');
 
   $query = '
@@ -1096 +1084 @@
   FROM '.USER_INFOS_TABLE.'
 ;';
-  $infos_users = array_from_query($query, 'user_id');
+  $infos_users = query2array($query, null, 'user_id');
 
   // users present in $base_users and not in $infos_users must be added
@@ -1125 +1113 @@
 ;';
     $to_delete = array_diff(
-      array_from_query($query, 'user_id'),
+      query2array($query, null, 'user_id'),
       $base_users
       );
@@ -1150 +1138 @@
   FROM '.CATEGORIES_TABLE.'
 ;';
-  $cat_map = hash_from_query($query, 'id');
+  $cat_map = query2array($query, 'id');
 
   $datas = array();
@@ -1187 +1175 @@
   WHERE storage_category_id IS NOT NULL
 ;';
-  $cat_ids = array_from_query($query, 'storage_category_id');
+  $cat_ids = query2aray($query, null, 'storage_category_id');
   $fulldirs = get_fulldirs($cat_ids);
 
@@ -1424 +1412 @@
       WHERE cat_id = '.$insert['id_uppercat'].'
     ;';
-    $granted_grps =  array_from_query($query, 'group_id');
+    $granted_grps =  query2array($query, null, 'group_id');
     $inserts = array();
     foreach ($granted_grps as $granted_grp)
@@ -1440 +1428 @@
       WHERE cat_id = '.$insert['id_uppercat'].'
     ;';
-    $granted_users =  array_from_query($query, 'user_id');
+    $granted_users =  query2array($query, null, 'user_id');
     add_permission_on_category($inserted_id, array_unique(array_merge(get_admins(), array($user['id']), $granted_users)));
   }
-  else if ('private' == $insert['status'])
+  elseif ('private' == $insert['status'])
   {
     add_permission_on_category($inserted_id, array_unique(array_merge(get_admins(), array($user['id']))));
@@ -1564 +1552 @@
   WHERE name = \''.$tag_name.'\'
 ;';
-  if (count($existing_tags = array_from_query($query, 'id')) == 0)
+  if (count($existing_tags = query2array($query, null, 'id')) == 0)
   {
     // search existing by case insensitive name
@@ -1572 +1560 @@
   WHERE CONVERT(name, CHAR) = \''.$tag_name.'\'
 ;';
-    if (count($existing_tags = array_from_query($query, 'id')) == 0)
+    if (count($existing_tags = query2array($query, null, 'id')) == 0)
     {
       $url_name = trigger_change('render_tag_url', $tag_name);
@@ -1581 +1569 @@
   WHERE url_name = \''.$url_name.'\'
 ;';
-      if (count($existing_tags = array_from_query($query, 'id')) == 0)
+      if (count($existing_tags = query2array($query, null, 'id')) == 0)
       {
         mass_inserts(
@@ -1692 +1680 @@
 ;';
 
-  $current_rank_of = simple_hash_from_query(
+  $current_rank_of = query2array(
     $query,
     'category_id',
@@ -1798 +1786 @@
   WHERE category_id IN ('.implode(',', $sources).')
 ;';
-  $images = array_from_query($query, 'image_id');
+  $images = query2array($query, null, 'image_id');
 
   associate_images_to_categories($images, $destinations);
@@ -1969 +1957 @@
   WHERE name = \''.$tag_name.'\'
 ;';
-  $existing_tags = array_from_query($query, 'id');
+  $existing_tags = query2array($query, null, 'id');
 
   if (count($existing_tags) == 0)
@@ -2451 +2439 @@
     AND status = \'private\'
 ;';
-  $private_cats = array_from_query($query, 'id');
+  $private_cats = query2array($query, null, 'id');
 
   if (count($private_cats) == 0)
@@ -2457 +2445 @@
     return;
   }
-  
+
   $inserts = array();
   foreach ($private_cats as $cat_id)
@@ -2469 +2457 @@
     }
   }
-  
+
   mass_inserts(
     USER_ACCESS_TABLE,
@@ -2500 +2488 @@
 ;';
 
-  return array_from_query($query, 'user_id');
+  return query2array($query, null, 'user_id');
 }
 
@@ -2703 +2691 @@
     }
     closedir($fh);
-    
+
     if (@rmdir($path))
     {
@@ -2748 +2736 @@
     'users' => USER_INFOS_TABLE
     );
-    
+
   if (!is_array($requested))
   {
@@ -2761 +2749 @@
     $requested = array_intersect($requested, array_keys($tables));
   }
-  
+
   $keys = array(
     '_hash' => md5(get_absolute_root_url()),
     );
-  
+
   foreach ($requested as $item)
   {
@@ -2778 +2766 @@
     list($keys[$item]) = pwg_db_fetch_row(pwg_query($query));
   }
-  
+
   return $keys;
 }