From bc3fdf095789c2f006159a51e63b612f842c3c1d Mon Sep 17 00:00:00 2001
From: plegall <plg@piwigo.org>
Date: Fri, 18 Oct 2013 20:56:05 +0000
Subject: bug 2977 fixed: when moving an album, whatever the previous status
 private/public we must remove irrelevant permissions (a public album can have
 hidden permission, ie list of groups/users permitted). I've also found a bug
 in the algorithm that selects users/groups to delete (reverse parameters in
 array_diff).

git-svn-id: http://piwigo.org/svn/branches/2.5@24986 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 admin/include/functions.php | 39 ++++++++++++++++-----------------------
 1 file changed, 16 insertions(+), 23 deletions(-)

diff --git a/admin/include/functions.php b/admin/include/functions.php
index 4e53d09e6..025fa4c04 100644
--- a/admin/include/functions.php
+++ b/admin/include/functions.php
@@ -1139,46 +1139,39 @@ SELECT status
   {
     foreach ($categories as $cat_id => $category)
     {
-      switch ($category['status'])
+      if ('public' == $category['status'])
       {
-        case 'public' :
-        {
-          set_cat_status(array($cat_id), 'private');
-          break;
-        }
-        case 'private' :
-        {
-          $subcats = get_subcat_ids(array($cat_id));
+        set_cat_status(array($cat_id), 'private');
+      }
+      
+      $subcats = get_subcat_ids(array($cat_id));
 
-          foreach ($tables as $table => $field)
-          {
-            $query = '
+      foreach ($tables as $table => $field)
+      {
+        $query = '
 SELECT '.$field.'
   FROM '.$table.'
   WHERE cat_id = '.$cat_id.'
 ;';
-            $category_access = array_from_query($query, $field);
+        $category_access = array_from_query($query, $field);
 
-            $query = '
+        $query = '
 SELECT '.$field.'
   FROM '.$table.'
   WHERE cat_id = '.$new_parent.'
 ;';
-            $parent_access = array_from_query($query, $field);
+        $parent_access = array_from_query($query, $field);
 
-            $to_delete = array_diff($parent_access, $category_access);
+        $to_delete = array_diff($category_access, $parent_access);
 
-            if (count($to_delete) > 0)
-            {
-              $query = '
+        if (count($to_delete) > 0)
+        {
+          $query = '
 DELETE FROM '.$table.'
   WHERE '.$field.' IN ('.implode(',', $to_delete).')
     AND cat_id IN ('.implode(',', $subcats).')
 ;';
-              pwg_query($query);
-            }
-          }
-          break;
+          pwg_query($query);
         }
       }
     }
-- 
cgit v1.2.3