Hide Categories - with Categories Image Box

[Mort-lemur]

Hi,

 

I have installed the contribution by Spooks for hiding Categories This One and it works great.

 

However I have the categories image box contribution installed as well.

 

The hide categories works on the admin side, and hides the category from the Menu (in my case dynamenu) but it does not hide it in the categories image box.

 

I cannot find a support thread for this.

 

At the bottom of the install instructions, Sam says

There may other instances I have missed, the genereral Rule is: If there is a general tep_db_query including TABLE_CATEGORIES add the filter: and categories_status = 1

but I am completely lost in adding this to the categories image box code.

 

Any help would be great please.

 

Thanks

[Mort-lemur]

I think I have found the block of code to modify in catalog/includes/modules/categories_images.php

 

which reads as this:

 

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

 

I have tried modding this as :

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

 

But I get an SQL error on my index page as follows:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.categories_status from categories_descri' at line 5

 

select c.categories_id, c.categories_image_front, cd.categories_description_front, cd.categories_name c.categories_status from categories_description cd, categories c where c.parent_id = '0' and c.categories_status = '1' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order

 

Any help would be really useful.

 

Thanks

[♥kymation]

You're missing a comma. You don't actually need to get the value of categories_status anyway, so this should work:

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

Regards

Jim

[Mort-lemur]

Thanks Jim,

 

Worked a Treat.

 

Thanks

 

If you have no objection can I post this as an update in Sams Contribution so others can do this without struggling?

 

Thanks

[♥kymation]

Of course you can. How could I object to spreading knowledge?

 

Regards

Jim

[Mort-lemur]

Thanks Jim,

 

I actually can not add the update - Spooks has locked the contribution - and I think he has vanished....

 

Thanks

[♥kymation]

Maybe you could post it in the support thread for that Contribution. At lease people have a chance of finding information there.

 

Regards

Jim