Quote Originally Posted by DivaVocals View Post
Another question.. My inactive products are showing up on my sitemap.. Anyone have a clue what I need to do to make sure these don't display??
Okay.. so I know this is the query I need to modify.. I am just not entirely sure how to make the correct edits.. Can anyone help??

Code:
$categories_query = "select c.categories_id, cd.categories_name, c.parent_id
    from " . TABLE_CATEGORIES . " c LEFT JOIN "
    . TABLE_HIDE_CATEGORIES . " h ON (c.categories_id = h.categories_id), "
    . TABLE_CATEGORIES_DESCRIPTION . " cd
    where (h.visibility_status < 2 OR h.visibility_status IS NULL)
    and c.categories_id = cd.categories_id
    and cd.language_id = '" . (int)$_SESSION['languages_id'] . "'
    and c.categories_status != '0'
    order by c.parent_id, c.sort_order, cd.categories_name";