Extensions > parentslist

parent list in tl_page

[parentslist]

Create a list of parent and child ids in new fields in table tl_page

IMPORTNAT NOTE:
This extension is still not stable. Please delete and install it again instead of making updates go get clean databse fields. Thanks!

This extension can be used for other extensions. It is for other developers and should not be installed without a dependency.

Two new fields are added to tabel tl_page: parents and rootId. They offer direct and fast access to all parents, grandparents, etc. and the root object for this page.

The field rootId stores the ID of the root object for this page. It allows direct access to that root object with one single SQL selection.

The field parents stores a comma separated list of the parent, the grandparent, ... up to the root object.Using this list you can use one single SQL select to get them all instead of recursively search through the database.
Example: select * from tl_page where id in (27,5,2);

The field childrens stores a list of all children, their children, etc. in a comma seperated list.

To reset all values, please delete the columns parents and rootId from table tl_page löschen an then copy runonce.php from /sytem/modules/partentslist to /system.

Version
1.2.0
Type
Free
Release date
15.04.2014
Category
Other
License
LGPL
Copyright
Copyright (C) 2014 Scyfel (Christian Barkowsky & Jan Theofel)
Author
Barkowsky Webentwicklung (christian.barkowsky) https://brkwsky.de
English transl.
Jan Theofel (jan.theofel) http://www.theofel.com/
Release notes and change log for 1.2.0
Other versions
Release functionality
 
Total functionality
0.00
Release usability
 
Total usability
0.00
Release quality
 
Total quality
0.00
Release rating
 
Total rating
0.00 (0 votes)
Release downloads
83
Total downloads
384
Release installs
158
Total installs
7877
Release updates
408
Total updates
2164
Dependencies of this extension
Other extensions depending on this one
Name
Version from
Version to
Contao
3.2.0
3.2.9
Name
Version from
Version to
1.2.0
1.2.0