PDA

View Full Version : Activate or inactivate category of catalog



michael_s
08-13-2009, 07:04 PM
If you are using "Main categories as thubnails on index"
http://addons.oscommerce.com/info/5119

There is a change to do,If you don't and disable a whole categorie "Main categories as thubnails on index" will still show the thumbnail of disabled categorie on your

main page.

To fix it go to catalog/includes/modules/main_cats.php

FIND:

$result = tep_db_query("SELECT * FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE c.parent_id = '0' AND c.categories_id =

cd.categories_id AND cd.language_id = '" . (int)$languages_id . "' ORDER BY sort_order ");

REMPLACE WITH

$result = tep_db_query("SELECT * FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE c.parent_id = '0' AND c.status_categ = '1' AND

c.categories_id = cd.categories_id AND cd.language_id = '" . (int)$languages_id . "' ORDER BY sort_order ");

You are done, if you disable a whole categorie thubnail will also dispear from main page.


More... (http://addons.oscommerce.com/info/6462)