CCGV + SEO + minishop = categories display error?

[Guest]

Hi all

 

I'm working on a store that has a lot of contribs installed - these include CCGV, 'minishop', SEO Urls and many more. The minishop contrib was installed and then the includes/configure.php code adulterated to 'hide' one category from the menu - this hid the sub categories.

 

I came along and installed contribution "Category Box Enhancement", version 1.1 - this provides a dropdown list of categories and sub categories. The 'hidden' categories appeared in this list but I took them out using the following:

 

$categories_query = tep_db_query("select c.categories_id, cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where parent_id = '" . (int)$parent_id . "' and cd.categories_name !='HIDDEN CATEGORY NAME' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

 

When CCGV was enabled in the admin the above code shows the "Gift Cards" category in teh new dropdown menu but the following code used in the main part of configure .php does not:

 

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where parent_id = '" . (int)$value . "' and cd.categories_name !=!='HIDDEN CATEGORY NAME' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

 

The main difference is the c.parent_id .

 

Can anybody tell me how/why this is and how to remedy it?

 

SK

 

p.s. I am sorry but I cannot tell what versions of each contrib is installed