hideCategories

Quote:

---

Originally Posted by bumpspt

Love this mod Steven. This is exactly what I needed for my site.

Like a couple others on this thread, I use the top category tab and wanted a way to hide the categories there as well. I came up with this solution that is working for me....

copy: /includes/modules/categories_tab.php
to: /includes/modules/YOURTEMPLATE/categories_tab.php

around line 31, replace the code:

PHP Code:

---

$categories_tab_query = "select c.categories_id, cd.categories_name from " .

TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd

                          where c.categories_id=cd.categories_id and c.parent_id= '0' and cd.language_id='" . (int)$_SESSION['languages_id'] . "' and c.categories_status='1'" . 


---

with new code:

PHP Code:

---

$categories_tab_query = "select c.categories_id, cd.categories_name from " .

TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd," . TABLE_HIDE_CATEGORIES . " cde

                          where c.categories_id=cd.categories_id and c.categories_id=cde.categories_id and c.parent_id= '0' and cd.language_id='" . (int)$_SESSION['languages_id'] . "' and c.categories_status='1' and cde.visibility_status='0'" . 


---

This adds an argument to the query to check the visibility status and hide any category that is not set to normal.

As with another post I read in this thread, this does require that all of your categories have a hide_categories value in the database. The other post noted this could be done through editing the database to add the value. Being a novice, I don't like to directly edit the database and found a different solution. For new categories, or categories that were created before installing the hide mod, edit the category to be hidden, save, then re-edit to normal. This creates the record needed in the database.

Hope this helps.

---

I installed the original hide categories mod alright. I followed the above instructions to install your mod, but the zen cart page become blank (only head banner is displayed) after the mod is installed, what might the problem be? Thanks

Hi :) . I've used this mod before and never had trouble, but with this particular site, I am. Two things. First, they're using the Best Sellers box and I'm getting this error with your bestsellers.php in the modules/sideboxes/custom folder:

Code:

---

1146 Table '(removed for security purposes)_zc2.products_description' doesn't exist
in:
[select distinct p.products_id, pd.products_name, p.products_ordered from zen_products p LEFT JOIN zen_hide_categories h ON (p.master_categories_id = h.categories_id), products_description pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10]

---

Second, I just took that file out and thought it was working, but when I clicked on the manufacturer for the product, the product still showed up.

Any help is appreciated :) .

Hi, I'm back. I have installed this again in a different shop and the best sellers sidebox is not a problem, but the product is not hidden. The category is, I chose hidden, direct link only, but the product is showing up everywhere.

Okay, figured out the sql error, but in both shops I have installed this in in the last two days, it isn't hiding them from the displays. They're showing up in new products (bottom of the page) and also when I browse by manufacturer. Sorry to keep posting, am not trying to bump, just giving updates on what is happening. Any help is appreciated.

Well I installed this mod a week or so ago and it appears to be functioning to the point it is not creating any errors, but have one issue that is driving two of us crazy. The cats do appear to be hidden in the edit screen, but no matter what I do they still show up in the breadcrumbs on the main page. I have called myself double checking the files but nothing seems to help. Our cart is driven by direct links on after the completion of registration type forms. But if a user stumbles on to the main menu the required form will be bypassed. I have had to point the main menu to one of the cats for the time being but would like to be able to go back to the standard for one cat but until I can hide the others that is not feasible. Of course being older than dirt makes me a bit slow.
Mel

This is a response to your post, but also a reminder/suggestion in general.

This contribution, as initially stated, was done for a specific site so the categories are hidden from the modules/boxes/pages that the specific site used and ignored the ones that it didn't use. It is up to the user to find and fix... or eliminate... any page elements, sideboxes, etc that aren't used by this mod. Hints are provided in the readme. So in general, if you aren't up to snuff with PHP programming and aren't intimately familiar with zen cart, then my suggestion is you not use this contribution. It is probably more headache then it is ultimately worth to you.

If I had the time... and I don't... to do this contrib over again with more general use in mind (rather than just the site that was paying me) I would probably go about it entirely different, making use of the hooks available in recent zen versions if at all possible. With new major versions of Zen on the horizon... I doubt I'd undertake it even if I had the time (and I don't) until they were released and stable. I'm talking about zen v4 whenever it is ready, because it should give even better ways to interact with your data.

- Steven

For me, they're showing up in the sideboxes and in the New Products on the main page...I have the Category Tabs disabled. This is happening on two sites...can't figure it out. I understand you wrote it for a particular purpose, but I think what I'm trying to do is within that realm and don't understand why it isn't working...

Hi.

Advice #1 - read the readme file that came with the contrib.
Advice #2 - look for something else if #1 + your php knowledge doesn't = a solution.

Steve

Hi all,

I've recently migrated to a new server host and prior to this move the hide categories mod worked perfectly. However now the store is on the new server the mod is still there i.e. I have the hide options when editing a category. But when I choose to hide a category it does nothing and the category is still visible.

Any ideas?

Just guesses.

My top guess is when you backed up and restored the DB that somehow the new entries got trashed? Try uninstalling the mod and installing it fresh.

Otherwise perhaps an incompatibility with the version of PHP and/or MySQL on your new server?

Dunno.

Steve