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