MPTtree, Hieararchical trees in a database table

[eluser]omerorhan[/eluser]
Because i didn't get the logic well.
I thought its better to store details of the tree in another table on a multiple language supported site.

or ,should I add a lang_id field to tree and filter it?

I modified tree2array() to make ul list.

Code:

function tree2array($root = 1){
        $node = $this->MPTtree->get_node($root);

        if($node == false)
            return false;
        // query
        $query = $this->db->query('SELECT node.id, node.lft, node.rgt , detail.title
             FROM table1 as node,
             table1 as parent ,
             table1_details AS detail
             where node.lft BETWEEN '.$node['lft'].' AND  '.$node['rgt'].'
             and node.id = detail.page_id
             Group by node.id
             ORDER BY node.lft');

        $right = array();
        $result = array();
        $current =& $result;
        $stack = array();
        $stack[0] =& $result;
        $lastlevel = 0;
        foreach($query->result_array() as $row){

                    
    
            // go more shallow, if needed
            if(count($right)){
                while($right[count($right)-1] < $row['rgt']){
                    array_pop($right);
                }
            }
            // Go one level deeper?
            
            if(count($right) > $lastlevel){
                end($current);
                $current[key($current)]['children'] = array();
                $stack[count($right)] =& $current[key($current)]['children'];
            }
            
            // the stack contains all parents, current and maybe next level
            $current =& $stack[count($right)];
            // add the data
            $current[] = $row;
            
            // go one level deeper with the index
            $lastlevel = count($right);
            $right[] = $row['rgt'];
        
        }
        return $result[0]['children'];
    }

Now i had to make a select list for admin panel.

Code:

$levels = $this->getLevels();
$data['tree'] = $this->cat_select($this->tree2array(),$levels);


function cat_select($array , $levels, $lft = 1){
    if($lft == 1)
    {
        echo "<select name=\"where\">";
    }
                foreach($array as $data)
                {
                    $indent = (str_repeat("&nbsp;", $this->getLevel($levels,$data['lft'])*2));
                    
                    echo '<option value="'.$data['id'].'">'.$indent.$data['title'].'</option>';    
                    
                    if(isset($data['children'])){
                        echo  $this->cat_select($data['children'], $levels , 0);
                    }        
                }
        echo "</select>";
}

function getLevels()
{
    $sql = "select node.id, node.lft, node.title, (COUNT(parent.title) -1) as depth
            From deneme as node,
            deneme as parent
            Where node.lft BETWEEN parent.lft AND parent.rgt
            GROUP BY node.id
            Order BY node.lft
            ";
    $query = $this->db->query($sql);
    
    $result = $query->result_array();
    
    return $result;
}
function getLevel($array, $lft)
{
        foreach($array as $data)
        {
            if($data['lft'] == $lft)
            {
                $depth = $data['depth'];
            }
        }
        if(isset($depth))
        {
            return $depth;
        }
        else
        {
            return;
        }
}

What is wrong in cat_select() function?

It doesn't add options in select box after first leaf ends.