MPTtree, Hieararchical trees in a database table

MPTtree, Hieararchical trees in a database table - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: MPTtree, Hieararchical trees in a database table (/showthread.php?tid=6842)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14

MPTtree, Hieararchical trees in a database table - El Forum - 10-14-2008

[eluser]Base Willy[/eluser]
pistolPete, thanks for your questions.

I'm using extjs provided with admin example.CSS and JS files are loaded correctly. I see it works and tries to load the tree but in firebug i see that tree_admin/get_node returns an empty result.. and still there are no errors in log

MPTtree, Hieararchical trees in a database table - El Forum - 10-14-2008

[eluser]Base Willy[/eluser]
Oopy.. I found the reason. It's because in node_text it's using the 'slug' index but i have 'title' Smile

MPTtree, Hieararchical trees in a database table - El Forum - 10-14-2008

[eluser]Base Willy[/eluser]
..but now i got another problem. When i try to add a new child node it does something with mysql and after that i only see is:

Code:
Error Number: 1100

Table 'sessions' was not locked with LOCK TABLES

and only after restarting mysql server i can see admin_tree main page again..

MPTtree, Hieararchical trees in a database table - El Forum - 10-15-2008

[eluser]pistolPete[/eluser]
You probably misconfigured it somehow... please post some code!
How are you using the "sessions" table combined with MPTtree?
Are you using the current Version of MPTtree (0.1.6-fix2) ?

Btw, I would recommend also using the latest Ext JS (which is v 2.2 at the moment).

If you want to, I can post an updated example...

MPTtree, Hieararchical trees in a database table - El Forum - 10-15-2008

[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.

MPTtree, Hieararchical trees in a database table - El Forum - 10-15-2008

[eluser]m4rw3r[/eluser]
Maybe there is a wrong uri?
It was really some time since I've looked at that source (and I was rewriting MPTTree when I suddenly got other things to do),
so I'm sorry if I'm not so good at helping you for the moment.

MPTtree, Hieararchical trees in a database table - El Forum - 10-17-2008

[eluser]Base Willy[/eluser]
In tree_admin, after right clicking on the root node (which i've added manually) and then clicking New page->New child page what should i see? I don't see anything and there is an error in firebug:

Code:
missing } in XML expression

[Break on this error] background-color: #fff;\n

ext-all.js (line 29)

But if i click on ext-all-js i see normal ext-all.js source..

MPTtree, Hieararchical trees in a database table - El Forum - 10-28-2008

[eluser]m4rw3r[/eluser]
For all those who are asking for the 1.6-fix2 version (the latest, which was posted on CI base), here it is.

MPTtree, Hieararchical trees in a database table - El Forum - 11-12-2008

[eluser]antonumia[/eluser]
this is a really useful addition and I plan to post my controller implementation of it when I've finished.

i have a problem when trying to move a node i.e. the node does not move using the following. I have the lft ids of each node in a tree passed in as $nodeid

Code:
function moveNodeUp($nodeid){

    $node = intval($nodeid);

    if ($node == 1){

        echo 'node is root';

exit();

    }

    $tnode = $this->backend->getNodeLeft($node - 1); // returns the lft value using rgt

    if ($tnode){

        $src = $this->getNodeById($node);

        $tgt = $this->getNodeById($tnode);

        $res =  $src->move_above($tgt);

        echo 'moved:' . $res;

    } else {

        echo 'target doesn\'t exist';

    }

    $this->index();

        }

thanks

anton

MPTtree, Hieararchical trees in a database table - El Forum - 11-14-2008

[eluser]Antivanity[/eluser]
I'm having problems with this..

Code:
$this->load->MPTT('user_tree');

$this->user_tree->insert_root(array('title'=>'FAS', 'userid'=>'1'));

Quote:PHP Fatal error: Cannot pass parameter 1 by reference in /home/camalotlms.com/system/application/models/mpttree.php on line 405

Heres the function that the error is in..

Code:
function get_root(){

        $query = $this->db->getwhere($this->tree_table,array($this->left_col => 1),1);

        $return = $query->num_rows() ? $query->row_array() : false;

        if(!$return)

            $this->debug_message('Root node was not found.'); // this is like 405 with the error..

        return $return;

    }