hideCategories

[lukemcr]

Quick question, S-mack: by the way, this mod is great.

I've installed hideCategories, but hidden categories are still showing up in the upper category listing, underneath the logo. Everything's fine in the category navigation on the left - hidden categories are staying properly hidden.

During the installation, I only manually modified one file, tpl_advanced_search.php. (I merged the changed hideCategories code with my custom tpl_advanced_search.php.) What files control the upper category navigation hidden settings?

Thanks a lot for the help!

[s_mack]

Yeah... that's why this isn't really a clean mod :) There are potentially dozens of places that one would have to account for in order to hide the categories completely... as mentioned in the ReadMe, I just did the ones we were using - which didn't include the upper links.

I don't know what file controls that upper menu as I've never used it. See if you can find that out (by asking in a general forum or something) and report it here and someone (maybe me) should be able to figure out what code to change.



Ultimately, when I'm less busy, I'd like to re-release this contrib with an as-exhaustive-as-possible set of files... but even then, there will be 3rd-party contribs and such that will need to be modified. In other words... this was destined from the beginning to be a nightmare to support :)

It would be dead easy if the core code made thier population calls differently. If every file in the system called some common function to get the list of categories/items then we'd only have to modify that one function rather than dozens or even hundreds of files.

Oh well.

- Steven

[MOTAS]

I use the table prefixes in my client's cart, because there are other things going on in the database, and had a problem getting this contrib to run out of the box. I found out there is a simple code fix to two files:
./includes/templates/YOUR_TEMPLATE/templates/tpl_products_all_default.php
LINE 24

	$products_all_query_raw = preg_replace('/, ' . TABLE_PRODUCTS_DESCRIPTION . ' pd(\s*)WHERE/', ' LEFT JOIN ' . TABLE_HIDE_CATEGORIES . ' h ON (p.master_categories_id = h.categories_id), ' . TABLE_PRODUCTS_DESCRIPTION . ' pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND', $products_all_query_raw);

./includes/templates/YOUR_TEMPLATE/templates/tpl_products_new_default.php
LINE 24

	$products_new_query_raw = preg_replace('/, ' . TABLE_PRODUCTS_DESCRIPTION . ' pd(\s*)WHERE/', ' LEFT JOIN ' . TABLE_HIDE_CATEGORIES . ' h ON (p.master_categories_id = h.categories_id), ' . TABLE_PRODUCTS_DESCRIPTION . ' pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND', $products_new_query_raw);

I added the second TABLE_PRODUCTS_DESCRIPTION, which was previously set to 'products_description'. In other words, it was looking for the table named products_description and not DB_PREFIX . products_description.

It was likely just a missed statement. I know someone else in this thread had posted having a problem with this.

hope that helps...
marc...

[s_mack]

Thanks! Missed that one :)

- Steven

[MOTAS]

No problem. I caught something else too. Is it fair to assume that FILENAME_STOCK_MANAGER and FILENAME_IMAGE_HANDLER are constants from installed modules? I am not running these modules and it appears to have messed something up in my store's admin. I changed the file:
admin/includes/modules/category_product_listing.php

I attached the file to this thread. The changes are from line 367-376. Minor, but could help someone else down the road.

cheers,
marc...

[s_mack]

yeah, those were already covered above.

[MOTAS]

excellent. sorry about that, didn't read the full thread. my bad.

as a side note, the file I uploaded is no good. there was something else I added that I shouldn't have. please ignore it.

[d1rage5]

I use the table prefixes in my client's cart, because there are other things going on in the database, and had a problem getting this contrib to run out of the box. I found out there is a simple code fix to two files:
./includes/templates/YOUR_TEMPLATE/templates/tpl_products_all_default.php
LINE 24

	$products_all_query_raw = preg_replace('/, ' . TABLE_PRODUCTS_DESCRIPTION . ' pd(\s*)WHERE/', ' LEFT JOIN ' . TABLE_HIDE_CATEGORIES . ' h ON (p.master_categories_id = h.categories_id), ' . TABLE_PRODUCTS_DESCRIPTION . ' pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND', $products_all_query_raw);

./includes/templates/YOUR_TEMPLATE/templates/tpl_products_new_default.php
LINE 24

	$products_new_query_raw = preg_replace('/, ' . TABLE_PRODUCTS_DESCRIPTION . ' pd(\s*)WHERE/', ' LEFT JOIN ' . TABLE_HIDE_CATEGORIES . ' h ON (p.master_categories_id = h.categories_id), ' . TABLE_PRODUCTS_DESCRIPTION . ' pd WHERE (h.visibility_status < 2 OR h.visibility_status IS NULL) AND', $products_new_query_raw);

I added the second TABLE_PRODUCTS_DESCRIPTION, which was previously set to 'products_description'. In other words, it was looking for the table named products_description and not DB_PREFIX . products_description.

It was likely just a missed statement. I know someone else in this thread had posted having a problem with this.

hope that helps...
marc...

So do i need to change anything now with this update or do i still need to add my prfix somewhere?

[s_mack]

give it a try. you haven't provided any information that lets anyone help you. To the question, "what am I missing"... the obvious and only answer is "whatever you're missing".

Read the readme carefully, go over this forum carefully... it obviously works for most people so just go step-by-step.

Good luck.

[d1rage5]

give it a try. you haven't provided any information that lets anyone help you. To the question, "what am I missing"... the obvious and only answer is "whatever you're missing".

Read the readme carefully, go over this forum carefully... it obviously works for most people so just go step-by-step.

Good luck.

OK everything is installed, every file is in its correct location, sql patch is installed and sussful.

When i login to the admin page....goto cat/products and add a new cat and go to edit it, there is no option for hinding the cat and when you are at the root of cat/products you dont see any change here as well.

if you want to login and take a look let me know, (send PM)

Thanks,
Daniel