Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

pordoeb

Archived
  • Posts

    6
  • Joined

  • Last visited

Everything posted by pordoeb

  1. :blush: Thanks for the hint, now its working :) lg pordoeb
  2. Hi, i want to integrate the enable/disable categories contrib to work well in the Google XML Sitemap Feed by Chemo. I change the function GenerateCategorySitemap from $sql = "SELECT categories_id as cID, date_added, last_modified as last_mod FROM " . TABLE_CATEGORIES . " ORDER BY parent_id ASC, sort_order ASC, categories_id ASC"; to $sql = "SELECT categories_id as cID, date_added, last_modified as last_mod FROM " . TABLE_CATEGORIES . " where categories_status = '1' ORDER BY parent_id ASC, sort_order ASC, categories_id ASC"; and it worked well. But now i want to make changes to the function GenerateProductSitemap, not to display products from disabled categories. I change from $sql = "SELECT products_id as pID, products_date_added as date_added, products_last_modified as last_mod, products_ordered FROM " . TABLE_PRODUCTS . " WHERE products_status='1' ORDER BY products_ordered DESC"; to $sql = "SELECT p.products_id as pID, p.products_date_added as date_added, p.products_last_modified as last_mod, p.products_ordered FROM " . TABLE_PRODUCTS . " p, " . TABLE_CATEGORIES . " cd where p.products_status='1' and cd.categories_status = '1' ORDER BY p.products_ordered DESC"; but it doesnt work in anyway. Anyone an idea? lg pordoeb
  3. Hi, i install this contrib and what could i say...it rocks :) But now i want to integrate the enable/disable categories contrib to work well in this contrib. I change the function GenerateCategorySitemap from $sql = "SELECT categories_id as cID, date_added, last_modified as last_mod FROM " . TABLE_CATEGORIES . " ORDER BY parent_id ASC, sort_order ASC, categories_id ASC"; to $sql = "SELECT categories_id as cID, date_added, last_modified as last_mod FROM " . TABLE_CATEGORIES . " where categories_status = '1' ORDER BY parent_id ASC, sort_order ASC, categories_id ASC"; and it worked well. But now i want to make changes to the function GenerateProductSitemap, not to display products from disabled categories. I change from $sql = "SELECT products_id as pID, products_date_added as date_added, products_last_modified as last_mod, products_ordered FROM " . TABLE_PRODUCTS . " WHERE products_status='1' ORDER BY products_ordered DESC"; to $sql = "SELECT p.products_id as pID, p.products_date_added as date_added, p.products_last_modified as last_mod, p.products_ordered FROM " . TABLE_PRODUCTS . " p, " . TABLE_CATEGORIES . " cd where p.products_status='1' and cd.categories_status = '1' ORDER BY p.products_ordered DESC"; but it doesnt work in anyway. Anyone an idea? lg pordoeb
×
×
  • Create New...