You should also post this in the support threads for the mod you are modifying as this is code to modify two menu modules to work with hieCategories and as such, it will probably be more useful posted there..

Quote Originally Posted by adowty View Post
...so for anyone else who needs to do this.

I found the correct syntax in the site map file.

$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";


Yee-Haw