MPTtree, Hieararchical trees in a database table

[eluser]Code Arachn!d[/eluser]
similar to the suggested update_node_by_id function I've just added a method on my own version to reinsert a node:

Code:

function reinsert_node($lft,$arg,$lock = true){
        $root = $this->get_root();
        if($lft > $root[$this->right_col] || $lft < 1)return false;
        if ($lock)
            $this->lock_tree_table();

        $this->db->query('UPDATE '.$this->tree_table.
                        ' SET '.$this->left_col.' = '.$this->left_col.' + 2 '.
                        ' WHERE '.$this->left_col.' >= '.$lft);
        $this->db->query('UPDATE '.$this->tree_table.
                        ' SET '.$this->right_col.' = '.$this->right_col.' + 2 '.
                        ' WHERE '.$this->right_col.' >= '.$lft);
    
        $this->db->where($arg);
        $this->db->update($this->tree_table,array($this->left_col => $lft,$this->right_col => $lft+1));
        if ($lock)
            $this->unlock_tree_table();
        return true;
    }

The idea is to take a record already in the table and add it back into the tree.