Changeset 23376 for trunk/admin/site_update.php

Timestamp:

Jun 19, 2013, 10:39:44 PM (11 years ago)

Author:

flop25

Message:

bug:2855
$confinheritance_by_default applies on FTP added albums

File:

• trunk/admin/site_update.php (modified) (2 diffs)

trunk/admin/site_update.php

@@ -267 +267 @@
         array(
           'id' => $insert['id'],
+          'parent' => $parent,
           'status' => $insert['status'],
           'visible' => $insert['visible'],
@@ -299 +300 @@
       // add default permissions to categories
       $category_ids = array();
+      $category_up = array();
       foreach ($inserts as $category)
       {
         $category_ids[] = $category['id'];
+        $category_up[] = $category['id_uppercat'];
       }
-      add_permission_on_category($category_ids, get_admins());
+      $category_up=implode(',',array_unique($category_up));
+      if ($conf['inheritance_by_default'])
+      {
+        $query = '
+          SELECT *
+          FROM '.GROUP_ACCESS_TABLE.'
+          WHERE cat_id IN ('.$category_up.')
+        ;';
+        $result = pwg_query($query);
+        $granted_grps = array();
+        while ($row = pwg_db_fetch_assoc($result))
+        {
+          if (is_null($granted_grps[$row['cat_id']]))
+          {
+            $granted_grps[$row['cat_id']]=array();
+          }
+          array_push(
+            $granted_grps,
+            array(
+              $row['cat_id'] => array_push($granted_grps[$row['cat_id']],$row['group_id'])
+            )
+          );
+        }
+        $insert_granted_grps=array();
+        foreach ($category_ids as $ids)
+        {
+          $parent=$db_categories[$ids]['parent'];
+          foreach ($granted_grps[$parent] as $granted_grp)
+          {
+            array_push(
+              $insert_granted_grps,
+              array(
+                'group_id' => $granted_grp,
+                'cat_id' => $ids
+              )
+            );
+           
+          }
+        }
+
+        mass_inserts(GROUP_ACCESS_TABLE, array('group_id','cat_id'), $insert_granted_grps);
+
+        $query = '
+          SELECT *
+          FROM '.USER_ACCESS_TABLE.'
+          WHERE cat_id IN ('.$category_up.')
+        ;';
+        $result = pwg_query($query);
+        $granted_users = array();
+        while ($row = pwg_db_fetch_assoc($result))
+        {
+          if (is_null($granted_users[$row['cat_id']]))
+          {
+            $granted_users[$row['cat_id']]=array();
+          }
+          array_push(
+            $granted_users,
+            array(
+              $row['cat_id'] => array_push($granted_users[$row['cat_id']],$row['user_id'])
+            )
+          );
+        }
+        $insert_granted_users=array();
+        foreach ($category_ids as $ids)
+        {
+          $parent=$db_categories[$ids]['parent'];
+          foreach ($granted_users[$parent] as $granted_user)
+          {
+            array_push(
+              $insert_granted_users,
+              array(
+                'user_id' => $granted_user,
+                'cat_id' => $ids
+              )
+            );
+           
+          }
+        }
+        mass_inserts(USER_ACCESS_TABLE, array('user_id','cat_id'), $insert_granted_users);
+
+      }     
+      else
+      {
+        add_permission_on_category($category_ids, get_admins());
+      }
     }