<?
include('/var/www/drupal/includes/tree.inc');
$table="term_hierarchy_test";
$parents->vid=1;
$parents->tid=1; //tid of the term we want to save in the tree
$parents->parent=array();

# first save a root level parent (2):
tree_term_save(&$parents,$table);
# then a son (2.1)
$parents->tid=2;
$parent_array[0]['nv']=2;
$parent_array[0]['dv']=1;
$parents->parent=$parent_array;
tree_term_save(&$parents,$table);
# then another son (2.2)
$parents->tid=3;
$parent_array[0]['nv']=2;
$parent_array[0]['dv']=1;
$parents->parent=$parent_array;
tree_term_save(&$parents,$table);
# then another son (2.3)
$parents->tid=4;
$parent_array[0]['nv']=2;
$parent_array[0]['dv']=1;
$parents->parent=$parent_array;
tree_term_save(&$parents,$table);
# then another son (2.4)
$parents->tid=5;
$parent_array[0]['nv']=2;
$parent_array[0]['dv']=1;
$parents->parent=$parent_array;
tree_term_save(&$parents,$table);
# insert son of son (2.4.1)
$parents->tid=6;
$parent_array[0]['nv']='14';
$parent_array[0]['dv']='5';
$parents->parent=$parent_array;
tree_term_save(&$parents,$table);
# insert son of son (2.4.2)
$parents->tid=7;
$parent_array[0]['nv']='14';
$parent_array[0]['dv']='5';
$parents->parent=$parent_array;
tree_term_save(&$parents,$table);
# insert son of son (2.4.3)
$parents->tid=8;
$parent_array[0]['nv']='14';
$parent_array[0]['dv']='5';
$parents->parent=$parent_array;
tree_term_save(&$parents,$table);


# # now fetch some tree
$vid=1;
echo "<H3>Tree</H3>";
echo ('<pre>');
var_dump(tree_tree_get(1,2,1,3,NULL,$table));
echo ('</pre>');
#from middle of the tree
echo "<H3>Middle of the tree</H3>";
echo ('<pre>');
var_dump(tree_tree_get(1,14,5,3,NULL,$table));
echo ('</pre>');
echo "<H3>Bottom of the tree</H3>";
echo ('<pre>');
var_dump(tree_tree_get(1,31,11,3,NULL,$table));
echo ('</pre>');
echo "<H3>tree get parents of the tree</H3>";
echo ('<pre>');
var_dump(tree_parents_get(31,11,1,$table));
echo ('</pre>');
# now move a tree
#we are moving everything under 2.4.4 to the third child of 2. so under 2.3
tree_subtree_move(14,5,2,1,3,1,$table);
# $children = db_query("truncate $table");
# ?>