[MOD] Apply permission to sub-categories from their parent category

[kief24]

Is it possible to set (change) permissions for all categories (at once) ?

[Threnody]

V@no,

This is great MOD, thanks so much for sharing it!  I just know this will be a real time saver! 

namaste,
Threnody

[wallpapers]

This is a perfect mod 
and it work also perfect 

thx v@no

[lemccoy]

Is it possible to set (change) permissions for all categories (at once) ?

This is a great mod, easy install and works great.  I also am interested in above. 

[V@no]

Is it possible to set (change) permissions for all categories (at once) ?

Not with this mod.
If you are interested, I can provide you with MySQL query that you can run in phpmyadmin...

[kief24]

Is it possible to set (change) permissions for all categories (at once) ?

Not with this mod.
If you are interested, I can provide you with MySQL query that you can run in phpmyadmin...

yes, i am very interested

thx

[V@no]

Ok, here it is:[qcode]UPDATE 4images_categories SET
auth_viewcat = xx,
auth_viewimage = xx,
auth_download = xx,
auth_upload = xx,
auth_directupload = xx,
auth_vote = xx,
auth_sendpostcard = xx,
auth_readcomment = xx,
auth_postcomment = xx[/qcode]
The xx is one of the following:

• 0 = All
  
• 2 = Only registered members
  
• 3 = Private
  
• 9 = Admins only
  

These are default settings, but to make sure double check in includes/constants.php:

Code: [Select]

// Permission levels
define('AUTH_ALL', 0);
define('AUTH_USER', 2);
define('AUTH_ACL', 3);
define('AUTH_ADMIN', 9);

You can remove auth_xxx from the query if you DON'T want to update that permission.

[kief24]

that worked just perfect ! thx a lot !! 

[yerpo]

Works like a charm. Luckily I didn't go changing each directory's permissions before seeing this 

[yerpo]

Does this mod work in version 1.7.2? It was very useful and I don't know why you didn't include it in the new version.

[ktwenrick]

doesnt work in 1.7.2 i get an error

Fatal error: Cannot redeclare get_subcategories_id() (previously declared in /gallery/admin/categories.php:333) in /gallery/admin/categories.php on line 645

[V@no]

From Step 1.1 of this mod remove

Code: [Select]

      function get_subcategories_id($cat_id = 0)
      {
        global $subcat_ids, $cat_parent_cache;
     
        if (!isset($cat_parent_cache[$cat_id]))
        {
          return false;
        }
        foreach ($cat_parent_cache[$cat_id] as $key => $val)
        {
          $subcat_ids[] = $val;
          get_subcategories_id($val);
        }
        return $subcat_ids;
      }v1.7.2 already has this function.

[wallpapers]

From Step 1.1 of this mod remove

Code: [Select]

      function get_subcategories_id($cat_id = 0)
      {
        global $subcat_ids, $cat_parent_cache;
     
        if (!isset($cat_parent_cache[$cat_id]))
        {
          return false;
        }
        foreach ($cat_parent_cache[$cat_id] as $key => $val)
        {
          $subcat_ids[] = $val;
          get_subcategories_id($val);
        }
        return $subcat_ids;
      }v1.7.2 already has this function.

Thanks V@no this works perfect

[fitterashes]

Ok, here it is:[qcode]UPDATE 4images_categories SET
auth_viewcat = xx,
auth_viewimage = xx,
auth_download = xx,
auth_upload = xx,
auth_directupload = xx,
auth_vote = xx,
auth_sendpostcard = xx,
auth_readcomment = xx,
auth_postcomment = xx[/qcode]
The xx is one of the following:

• 0 = All
  
• 2 = Only registered members
  
• 3 = Private
  
• 9 = Admins only
  

is it possible to define categories to apply the changes ?
ex : UPDATE 4images_categories 200 to 500 SET [...]

(yeah i don't know anything about sql requests)

[fitterashes]

Ok, I answer myself 

Code: [Select]

UPDATE 4images_categories SET
auth_viewcat = x,
auth_viewimage = x,
auth_download = x,
auth_upload = x,
auth_directupload = x,
auth_vote = x,
auth_sendpostcard = x,
auth_readcomment = x,
auth_postcomment = x

WHERE cat_id=Y
or WHERE cat_id>Y etc...