Hi all,
I had the problem that the dynamic site map shows inactive (disabled) products, too. I corrected this with that little code in the file /includes/classes/category_tree.php:
old line 33:
$categories_query = tep_db_query("select c.products_id, cd.products_name, c.products_tax_class_id from " . TABLE_PRODUCTS . " c, " . TABLE_PRODUCTS_DESCRIPTION . " cd where c.products_id = cd.products_id and cd.language_id = '" . (int)$languages_id . "' order by c.products_tax_class_id, cd.products_name");
new line 33:
$categories_query = tep_db_query("select c.products_id, cd.products_name, c.products_tax_class_id from " . TABLE_PRODUCTS . " c, " . TABLE_PRODUCTS_DESCRIPTION . " cd where c.products_id = cd.products_id and cd.language_id = '" . (int)$languages_id . "' and c.products_status = '1' order by c.products_tax_class_id, cd.products_name");
(The new extension is and c.products_status = '1' )
Bye,
Marcel