Revision 1999
Added by darkviper about 12 years ago
| PageTree.php | ||
|---|---|---|
| 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 |
} |
Also available in: Unified diff
! admin/pages/PageTree added list of sections to the tooltip of 'manage_sections'