Trees

Information about SQL trees: http://dev.e-taller.net/dbtree/

=> a bit of inspiration...

• [url=http://pear.php.net/package/Tree]PEAR Tree Package[/url]

Category:Models::3rd Party

Modified Preorder Tree Traversal (or Nested Sets) tree model

Place the MPTtree.php file in your models directory.
Load the model with $this->load->model(’MPTtree’), and then set the table name with $this->MPTtree->set_table(’tablename’)

Check the comments in file or the accompanying html manual on how to use the model.

Download

File:MPTtree_0_1_4.zip

Change Log

Version 0.1.4

Release Date: February 26, 2008

• Added a few methods to be used with Active Record, see Active Record helpers
• Added calls to db::protect_identifiers() in set_opts() and in set_table()
• Replaced the method xpath() with a much more efficient xpath variant.
• The old xpath() method have been renamed to xpath2().
• HCG: Replaced use of transactions with locks

Version 0.1.2

Release Date: February 20, 2008

Added the method xpath() Remade set_opts() to accept an array with the parameters Added a sanitation of the data to update_node() and to the insert methods. This to prevent damage to the tree.

Version 0.1.1

Release Date: February 18, 2008

Added transaction support Added the method get_descendants_where() Added the method get_children_where() Changed algohrithm for get_children(), the new is almost twice as fast as the old one! Renamed some internal properties to address some conflicts with different CI libraries Changed name of get_decendants() to get_descendants(), a bad misspelling by me.

Version 0.1.0

Release Date: February 9, 2008

Initial Release