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

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..

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

DivaVocals:

Need to do two things..

2. Post clearer instructions for anyone needing this code..

3. 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:

    $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:
> ```
  $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:

    $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.

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..

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');

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.

fonzie:

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.Based SOLEY on the information you posted I cannot say for sure what has happened. So the thing I do suggest is that you recheck your install as this mod does make change to exclude hidden products from searches. If things aren't working correctly it suggests that something went wrong with your install..

I've rechecked my install, and the problem seems to be in this file : includes/modules/pages/advanced_search_result/header_php.php,

when I upload my original file, the search functions works fine, but it shows also the items in the hidden categories,

I hope you can help me,

kind regards.

fonzie:

I've rechecked my install, and the problem seems to be in this file : includes/modules/pages/advanced_search_result/header_php.php,

when I upload my original file, the search functions works fine, but it shows also the items in the hidden categories,

I hope you can help me,

kind regards.
Did you MERGE this file with your own or use the one from the package??

I used the one from the package, I made no other changes to this file for other mods.

fonzie:

I used the one from the package, I made no other changes to this file for other mods.The latest version was submitted by another community member so I cannot remember the details of the change made to this version.. I know that it modified the advanced search page, and the reason for the change was to correct another issue (which escapes me at the moment). If you search this support thread, the reason for the change and the details behind it are posted.. See if you can locate those posts in this support thread.. It might provide some insight into the issue you are having..

thanks for your help,

I found the code in post 301 by Kamelion0927, in post 330 you confirmed the code after testing,

I copied the code into the file, alas, it doesn't work in my shop, the search function returns nothing at all ...

could this be caused by another file ?

fonzie:

thanks for your help,

I found the code in post 301 by Kamelion0927, in post 330 you confirmed the code after testing,

I copied the code into the file, alas, it doesn't work in my shop, the search function returns nothing at all ...

could this be caused by another file ?Explain the part I highlighted.. Nothing as in no search results or nothing as in blank page?? and honestly a site link might be helpful..

the search function returns no results, I'm directed to the 'advanced search', have a look at https://www.bordink35.be

fonzie:

the search function returns no results, I'm directed to the 'advanced search', have a look at www.bordink35.beHonestly I'm puzzled why it doesn't work for you.. you could try the file in the version prior to the latest release..

I checked the previous version, there is no file 'includes/modules/pages/advanced_search_result/header_php.php',

I quickly installed a new testshop, a clean install with just one mod : hidecategories, same problem, I guess I'll have to allow the search function to find every item, even in the hidden categories,

thanks for help.