Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

marft

Archived
  • Posts

    6
  • Joined

  • Last visited

Posts posted by marft

  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...