Revision 2021
Added by darkviper almost 12 years ago
| PageTree.php | ||
|---|---|---|
| 173 | 173 |
. 'p.`page_id`, p.`parent`, p.`level`, p.`language`, p.`admin_groups`, ' |
| 174 | 174 |
. 'p.`admin_users`, p.`viewing_groups`, p.`viewing_users`, p.`visibility`, ' |
| 175 | 175 |
. 'p.`menu_title`, p.`page_title`, p.`page_trail`, ' |
| 176 |
. 'GROUP_CONCAT(CAST(CONCAT(s.`section_id`, \' - \', s.`module`) AS CHAR) SEPARATOR \'\n\') `section_list` ' |
|
| 176 |
. 'GROUP_CONCAT(CAST(CONCAT(s.`section_id`, \' - \', s.`module`) AS CHAR) ORDER BY s.`position` SEPARATOR \'\n\') `section_list` '
|
|
| 177 | 177 |
. 'FROM `'.$this->_oDb->TablePrefix.'pages` p ' |
| 178 | 178 |
. 'INNER JOIN `'.$this->_oDb->TablePrefix.'sections` s ' |
| 179 | 179 |
. 'ON p.`page_id`=s.`page_id` ' |
Also available in: Unified diff
! PageTree::_makeSql() added sort order to list of sections per page