Need help with blocking specific subcategories

[frank18]

I am still working on my new mod 'Categeory Specific Access Restriction'

So far all hacks are working a treat for top categories. However, if I want to restrict a subcategory the mod fails.

Here is what I have done so far:

File includes/index_filters/default_filter.php looks like this:

if (!defined('IS_ADMIN_FLAG')) { 
  die('Illegal Access'); 
} 
 
// CATEGORY_RESTRICTION: test for restricted categories and if found then don't show their products in the listing 
    $category_login_query = array(",",CATEGORY_RESTRICTION_LOGIN_CATEGORY); 
    foreach($category_login_query as $category_login); 
 
  if (isset($_SESSION['customer_id']) && isset($_SESSION['customers_privileges']) && $_SESSION['customer_id'] > 0 && $_SESSION['customers_privileges'] > 0) {  
  $block_these = ''; 
  } else {  
  $block_these = " and p.master_categories_id != '$category_login' "; 
    }

.... rest of the file ....

Then added $block_these to each of the where settings.

Did the same in these files:

includes/modules/pages/advanced_search_result/header_php.php
includes/modules/pages/featured_products/header_php.php
includes/modules/pages/products_all/header_php.php
includes/modules/pages/products_new/header_php.php
includes/modules/pages/specials/main_template_vars.php


The hack does not work when I am adding a subcategories ID to the array CATEGORY_RESTRICTION_LOGIN_CATEGORY -- it throws no error either!

Demo site here - ZC version 1.5.1 - new installation

Click category 'Mixed Category' and you still see the listing of products 'Mixed Must Login 1' and 'Mixed Must Login 2'. These two products should not show up.

Now click on 'All Products' or 'New Products' and you still see the listing of products 'Mixed Must Login 1' and 'Mixed Must Login 2' BUT you don't see products from the top category entitled 'Must-Login-category' - just as desired.

All good for the top categories but not for the Mixed Must Login Products in the subcat Mixed Must Login

Appreciate some comments/hints or solutions

Thanks / Frank

[frank18]

I should add that the column

'customers_privileges'

is a new column in the customers table. Certain selected customers can be authorized (via admin) to view and buy restricted products.

[frank18]

Solved it ... persistence paid off again

replaced the code in my first post with this one:

// CATEGORY_RESTRICTION: test for restricted categories and subcategories and if found then don't show their products in the listing 
    $category_login_query_top = array(',',CATEGORY_RESTRICTION_LOGIN_CATEGORY);  // finds must_login top category products 
    $category_login_query_sub = explode('_',CATEGORY_RESTRICTION_LOGIN_CATEGORY);  // finds must_login subcategory products 
    foreach($category_login_query_top as $category_login_top); 
    foreach($category_login_query_sub as $category_login_sub); 
 
  if (isset($_SESSION['customer_id']) && isset($_SESSION['customers_privileges']) && $_SESSION['customer_id'] > 0 && $_SESSION['customers_privileges'] > 0) {  
  $block_top = ''; 
  $block_sub = ''; 
  } else {  
  $block_top = " AND p.master_categories_id != '$category_login_top' "; 
  $block_sub = " AND p.master_categories_id != '$category_login_sub' "; 
    }


.... rest of the file ....

and replaced

$block_these

with

$block_top
$block_sub

in the relevant 'where' statements

see the demo site

Now on to fix the sideboxes