global $conn, $lu_cat_no_permission_marker,$la_cat_no_permission_marker, $admin;
//admin vs. user languages
if($admin==1)
$l_cat_no_permission_marker=$la_cat_no_permission_marker;
else
$l_cat_no_permission_marker=$lu_cat_no_permission_marker;
if(!$parent_cat)
$parent_cat=0;
$query="select cat_id, cat_name, cat_perm from inl_cats where cat_pend=0 and cat_sub=$parent_cat ";
if($admin!=1){$query.="and cat_vis=1 ";}
$query.="order by cat_name";
$rs = &$conn->Execute($query);
$count=1;
$ret="";
while(!$rs->EOF)
{ if($rs->fields[2]<1)
$rs->fields[1].=$l_cat_no_permission_marker;
if($count==1)
{ $ret.="\n";
$count=0;
}
else
$ret.="\n";
$rs->MoveNext();
}
return $ret;
?>