hideCategories

Can anybody help out with the issue i am having with the Advanced Search feature.

See the thread below

http://www.zen-cart.com/forum/showthread.php?t=189739

Quote:

---

Originally Posted by gazag

Can anybody help out with the issue i am having with the Advanced Search feature.

See the thread below

http://www.zen-cart.com/forum/showthread.php?t=189739

---

The ONLY thing I can suggest is that you try re-installing hideCategories.. There is no reason for it to cause the issues you have reported unless there is something wrong with your template or your installation of hideCategories is missing steps..

Also (as is stated in the readme) if you have files in your template in common with the hideCategories files, you will need to MERGE those files..

Quote:

---

NOTE: Many of the other files are not core files, but they may already exist if you've modified your cart already. If so, merge them as you see fit to integrate the necessary parts into your page(s).

---

You will need a file merging program like Winmerge or Beyond Compare..

I could not get this to work.
I am using Zen 1.3.9 with CSS Horizontal Drop Menu with jquery and Hide Categories.
Does anyone have an idea iof how to make this work.

Regards

Quote:

---

Originally Posted by DivaVocals

Need to do two things..

1. Post clearer instructions for anyone needing this code..
2. Post a link to this post in the menu support threads since adowty never did this (as I suggested -- **sigh**). It will make it easy for others using one of these menus with hideCategories to find the required instructions..

Modification posted below is required to use hideCategories with the following menu mods:
CSS Horizontal Drop Down Menu
CSS Horizontal Dropdown Menu With jquery
CSS Flyout Menu

If you are using "CSS Horizontal Drop Down Menu" or "CSS Horizontal Dropdown Menu With jquery":
Around line 43 in includes/classes/categories_ul_generator.php find this:

Code:

---

        $categories_query = "select c.categories_id, cd.categories_name, c.parent_id
                                        from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                                        where c.categories_id = cd.categories_id
                                        and c.categories_status=1 " .
                                        " and cd.language_id = '" . (int)$_SESSION['languages_id'] . "' " .
                                        " order by c.parent_id, c.sort_order, cd.categories_name";

---

If you are using "CSS Flyout Menu"
Around line 47 in includes/classes/categories_ul_generator.php find this:

Code:

---

  $categories_query = "select c.categories_id, cd.categories_name, c.parent_id
                      from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                      where c.categories_id = cd.categories_id
                      and c.categories_status=1 " .
//                            "and c.categories_id = ptc.category_id " .
//                            "and ptc.category_id = cd.categories_id " .
//                            "and ptc.product_type_id not in  " . $this->document_types_list . "
                      " and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                        order by c.parent_id, c.sort_order, cd.categories_name";

---

Regardless of which menu you use replace the code above with this:

Code:

---

        $categories_query = "select c.categories_id, cd.categories_name, c.parent_id
                                        from " . TABLE_CATEGORIES . " c LEFT JOIN "
                                        . TABLE_HIDE_CATEGORIES . " h ON (c.categories_id = h.categories_id), "
                                        . TABLE_CATEGORIES_DESCRIPTION . " cd
                                        where (h.visibility_status < 2 OR h.visibility_status IS NULL)
                                        and c.categories_id = cd.categories_id
                                        and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                                        and c.categories_status != '0'
                                        order by c.parent_id, c.sort_order, cd.categories_name";

---

This should hide your hidden categories from the menu.

---

It worked.

My apologies. I must have done something wrong.

It works well.

Quote:

---

Originally Posted by raunharman

I could not get this to work.
I am using Zen 1.3.9 with CSS Horizontal Drop Menu with jquery and Hide Categories.
Does anyone have an idea iof how to make this work.

Regards

---

Which is what I was going say.. The instructions posted work, and if they don't it usually means that the modification was done incorrectly.. Glad you got it all worked out..

Quote:

---

Originally Posted by raunharman

It worked.

My apologies.I must have done something wrong.

It works well.

---

Having problems with Hide Categories. icon changes to different look when I hide a category, it is showing as hidden in SQL, but the category still is displayed.


I have the following line in my definitions because i want to have FUNDRAISERS displayed instead of categories. Could this be causing the problem?

// categories box text in sideboxes/categories.php
define('BOX_HEADING_CATEGORIES', 'FUNDRAISERS');

Quote:

---

Originally Posted by tpiccirillo

Having problems with Hide Categories. icon changes to different look when I hide a category, it is showing as hidden in SQL, but the category still is displayed.


I have the following line in my definitions because i want to have FUNDRAISERS displayed instead of categories. Could this be causing the problem?

// categories box text in sideboxes/categories.php
define('BOX_HEADING_CATEGORIES', 'FUNDRAISERS');

---

Nope.. Suggest your recheck you install and make sure you haven't skipped any steps.. Simply put, if it doesn't work, it means something is missing in your install..

I'm comparing hideCategories 2.1 with Zen Cart 1.5.

The readme file says 3 core files are overwritten, but actually there are 2 additional files:

includes\classes\db\mysql\define_queries.php
includes\classes\sitemap.php

Thanks for the great mod; it is just what I was looking for to get me out of a hole. I have even managed to do my own first bit of customizing and make the categories reappear in the site map, search, side boxes and top menu once people log in!

I have experienced the Advanced search issue defaulting to the last category as reported by gazag so will check his thread for a fix.

One thing I have noticed is that the category counts in the left hand menu box include items in hidden categories as well. No one seems to have mentioned this before so it is either something I have done wrong, no one else uses category counts or no one has noticed.

I have turned category counts off for now but am curious as to whether this mod is meant to cover that area as well?

Hi,

I've recently installed this mod, and now my search function doesn't work anymore, what could be the reason for this, this is the only mod I've installed lately,

I'm using Zen-cart 1.3.9.h with the Cherry-Zen template.