Guest Posted April 3, 2005 Share Posted April 3, 2005 Someone else may have already posted this little tweak, but I always seem to be asking questions, so here is my chance to give a little. I have Sitemap MS2-2.2 and Enable Disable Categories installed and needed to hide the disabled categories in the site map (I mean, why have them hidden in the first place, if they are still acessable)? So...in includes/classes/category_tree.php find this around line 30: $categories_query = tep_db_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 cd.language_id = '" . (int)$languages_id . "' order by c.parent_id, c.sort_order, cd.categories_name"); And simply replace with: $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_status = '1'and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by c.parent_id, c.sort_order, cd.categories_name"); I'm no programmer so don't ask if something blows up, but I know this works on my site with no problems. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.