User specific categories

[Beertje]

What would be the best way to create product categories that are only shown to 'flagged' users? Of course, I have added a tinyint(1) to the customers_info table. Now I need to get categories.php to only show certain categories when that flag is '1'. Also, I'd want products from those categories to only show up as new items and in searches etc. when that flag is set.

 

Now, I'm very (very, very....) new to PHP and MySQL. I've been scanning categories.php and advanced_search_result.php but I can't seem to find the right place to inject the ci.flag = '1'. Will that even work? I've been looking for a contribution that does this, but all I came across was password protected categories, which isn't quite what I'm looking for.

 

Any help would be largely appreciated!

[♥geoffreywalton]

Suspect you need to start in \includes\boxes\categories.php

 

For more info on sql try www.w3schools.com

 

To prevent products in permitted categories from showing via the searches is more difficult. What happens in nested categories if the one 2 levels up is not ok but the one it is in is OK?

 

Enjoy

 

G

[Beertje]

I considered that, too! So, the categories that would be listed to flagged users only, are all top-level categories without sub-categories. I think this would make it easier, and still serves my purpose. Well, it looks like a nice small project to sink my teeth into :D

 

Suspect you need to start in \includes\boxes\categories.php

 

For more info on sql try www.w3schools.com

 

To prevent products in permitted categories from showing via the searches is more difficult. What happens in nested categories if the one 2 levels up is not ok but the one it is in is OK?

 

Enjoy

 

G

[♥geoffreywalton]

So every time you select a product you have to walk up the category tree to see if it can be displayed. OK for a one or 2 level shop but if it goes deeper.

 

Sounds like fun.

 

Maybe consider putting it on the product?

 

G

[Beertje]

Well, it's only for two or three toplevel categories with no sub-categories in them. Will that really be that hard to implement? Tbh, I have no idea... Isn't adding certain restrictions to the queries in the applicable spots enough to make it happen?

 

 

 

So every time you select a product you have to walk up the category tree to see if it can be displayed. OK for a one or 2 level shop but if it goes deeper.

 

Sounds like fun.

 

Maybe consider putting it on the product?

 

G

[♥geoffreywalton]

Start with the categories box and when you have that working move on to sorting out the searches

[Jan Zonjee]

What would be the best way to create product categories that are only shown to 'flagged' users?

Hide products from customer groups for SPPC does this. Might be worthwhile to see how it does that and adapt it to your situation.