Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

marft

Archived
  • Posts

    6
  • Joined

  • Last visited

About marft

  • Birthday 01/01/1990

Profile Information

marft's Achievements

  1. 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
×
×
  • Create New...