Extensions > parentslist
parent list in tl_page
Create a list of parent and child ids in new fields in table tl_page
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.