function keys_expand($mid, $sep = "-")
{
global $xoopsDB, $keywords;
if (empty($keywords)) {
require_once dirname(__FILE__) . "/functions.php";
$keywords = new Keywords();
}
$kres = $xoopsDB->query("SELECT keyref FROM " . RELAY . " WHERE midref=" . $mid);
$keys = array();
foreach ($keywords->getTree() as $key) {
// roots order
$keys[$key['keyid']] = array();
}
while (list($keyid) = $xoopsDB->fetchRow($kres)) {
$root = find_root_id($keyid);
$depth = find_root_id($keyid, true);
$key = $keywords->get($keyid);
if (!empty($key['keyid'])) {
$keys[$root][$depth] = $key['name'];
}
}
foreach ($keys as $id => $vals) {
if ($vals) {
$keys[$id] = join($sep, $vals);
} else {
unset($keys[$id]);
}
}
return $keys;
}
