Jump to content

marft

Members
  • Content count

    6
  • Joined

  • Last visited

Everything posted by marft

  1. marft

    Dynamic SiteMap

    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
×