172 |
172 |
. 'p.`position`, '
|
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 |
|
. 'p.`menu_title`, p.`page_title`, p.`page_trail` '
|
|
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 |
177 |
. 'FROM `'.$this->_oDb->TablePrefix.'pages` p '
|
177 |
178 |
. 'INNER JOIN `'.$this->_oDb->TablePrefix.'sections` s '
|
178 |
|
. 'ON p.`page_id`=s.`page_id` ';
|
179 |
|
// if($iParentKey) {
|
180 |
|
//
|
181 |
|
// $sql .= 'WHERE `root_parent`='.$iParentKey.' ';
|
182 |
|
// } else {
|
183 |
|
// // if tree based on root is requested (parent=0)
|
184 |
|
$sql .= 'WHERE `parent`='.$iParentKey.' ';
|
185 |
|
// }
|
186 |
|
// do not get pages with 'deleted' flag set on activated trashcan
|
187 |
|
if($this->_oReg->PageTrash != 'inline') {
|
188 |
|
$sql .= 'AND `visibility`!=\'deleted\' ';
|
189 |
|
}
|
190 |
|
$sql .= 'GROUP BY p.`page_id` '
|
|
179 |
. 'ON p.`page_id`=s.`page_id` '
|
|
180 |
. 'WHERE `parent`='.$iParentKey.' '
|
|
181 |
. (($this->_oReg->PageTrash != 'inline') ? 'AND `visibility`!=\'deleted\' ' : '')
|
|
182 |
. 'GROUP BY p.`page_id` '
|
191 |
183 |
. 'ORDER BY p.`position` ASC';
|
192 |
184 |
return $sql;
|
193 |
185 |
}
|
... | ... | |
332 |
324 |
$file = $this->_oApp->page_is_active($aPage) ? "clock_16.png" : "clock_red_16.png";
|
333 |
325 |
$file = ($aPage['published'] && $aPage['module'] != 'menu_link') ? $file : 'noclock_16.png';
|
334 |
326 |
$sOutput .= '<a href="'.$this->_oReg->AcpRel.'pages/sections.php?page_id='
|
335 |
|
. $aPage['page_id'].'" title="'.$this->_oTrans->HEADING_MANAGE_SECTIONS.'">'
|
|
327 |
. $aPage['page_id'].'" title="'.$this->_oTrans->HEADING_MANAGE_SECTIONS."\n".$aPage['section_list'].'">'
|
336 |
328 |
. '<img src="'.$this->_oReg->ThemeRel.'images/'.$file.'" alt="'
|
337 |
|
. $this->_oTrans->HEADING_MANAGE_SECTIONS.'" /></a>';
|
|
329 |
. $this->_oTrans->HEADING_MANAGE_SECTIONS."\n".$aPage['section_list'].'" /></a>';
|
338 |
330 |
}else {
|
339 |
331 |
$sOutput .= '<img src="'.$this->_oReg->ThemeRel.'images/blank_16.gif" alt=" " />';
|
340 |
332 |
}
|
! admin/pages/PageTree added list of sections to the tooltip of 'manage_sections'