Directory

num : 0;
}

function getChildTerms($parent, $vid)
{
$sql = “select td.tid, td.vid, td.name”
. ” from term_data td”
. ” join term_hierarchy th on th.tid = td.tid”
. ” where th.parent = $parent”
. ” and td.vid = $vid”
. ” order by td.weight, td.name”;
$terms = db_query($sql);
$output = “”;
while ($aterm = db_fetch_object($terms))
{
$output .= “

  • tid’>$aterm->name (”
    . getNodeCount($aterm->tid).”)

    • \n”
    . getChildTerms($aterm->tid, $vid);
    }
    return ($output != “”)? “

      \n” . $output . “

    \n” : “”;
    }

    $sql = “select vid, name from vocabulary where name in (‘directory’) order by name”;
    $vocabularies = db_query($sql);
    $output = “”;
    while ($avoc = db_fetch_object($vocabularies))
    {
    $output .= getChildTerms(0, $avoc->vid);
    }
    print “

      \n” . $output . “

    \n”;

    ?>

    		  

    num : 0;
    }

    function getChildTerms($parent, $vid)
    {
    $sql = “select td.tid, td.vid, td.name”
    . ” from term_data td”
    . ” join term_hierarchy th on th.tid = td.tid”
    . ” where th.parent = $parent”
    . ” and td.vid = $vid”
    . ” order by td.weight, td.name”;
    $terms = db_query($sql);
    $output = “”;
    while ($aterm = db_fetch_object($terms))
    {
    $output .= “

  • tid’>$aterm->name (”
    . getNodeCount($aterm->tid).”)

    • \n”
    . getChildTerms($aterm->tid, $vid);
    }
    return ($output != “”)? “

      \n” . $output . “

    \n” : “”;
    }

    $sql = “select vid, name from vocabulary where name in (‘directory’) order by name”;
    $vocabularies = db_query($sql);
    $output = “”;
    while ($avoc = db_fetch_object($vocabularies))
    {
    $output .= getChildTerms(0, $avoc->vid);
    }
    print “

      \n” . $output . “

    \n”;

    ?>