WB 2.08.x

! = Update/Change

===============================================================================

03 Oct-2013 Build 1972 Dietmar Woellbrink (Luisehahne)

# bugfix pages/settings_save.php sql strict

! update fix pages/settings.php page code list

 * @deprecated   

 * @description  xyz

 */

{

}

// Include config file

$config_file = dirname(__FILE__).'/config.php';

if(file_exists($config_file) && !defined('WB_URL'))

      . 'WHERE `name`=\'pages_directory\'';

$sPagesDirectory = WbDatabase::getInstance()->get_one($sql);

$sTmp = trim($sPagesDirectory, '/');

if($sTmp != $sPagesDirectory) {

	$sql = 'UPDATE `'.TABLE_PREFIX.'settings` '

		 . 'SET `value` = \''.$sTmpDir.'\' '

class a_pages_PageTree

{

/** @var object instance of the application object */

	protected $_oApp     = null;

/** @var object instance of the database object */

	protected $_oDb      = null;

/** @var string full HTML formattet list of pages */

	protected $_sOutput         = '';

/** @var integer number of all reachable pages */	

	public function __construct() 

	{

		// import global vars and objects

	}

/**

 * parse the page tree and return

		return $this->_aParentList;

	}

/**

 * create a page tree as a well formatted, unordered list

 * @param int use page-ID as root of the generated page tree. (default: 0)

 * @return string the whoole list

		      . $this->_Tabs(1).'<tbody>'.PHP_EOL

		      . $this->_Tabs(1).'<tr class="pages_list_header">'.PHP_EOL

		      . $this->_Tabs(1).'<th style="width:20px;">'.PHP_EOL.'</th>'.PHP_EOL

		                        '</th>'.PHP_EOL

		      . $this->_Tabs(0).'<th class="list_page_id">PID</th>'.PHP_EOL

		                        ':</th>'.PHP_EOL

		      . $this->_Tabs(0).'<th class="list_page_id">&nbsp;</th>'.PHP_EOL

		      . $this->_Tabs(-1).'</tr>'.PHP_EOL

	}

/**

 * compose the needed SQL statement

 * @return string SQL statement

 */			

	protected function _makeSql($iParentKey = 0)

	{

		$sql  = 'SELECT ( SELECT COUNT(*) '

		      .          'WHERE x.`parent`=p.`page_id`'

		      .        ') `children`, '

		      .        's.`module`, MAX(s.`publ_start` + s.`publ_end`) published, p.`link`, '

		      .        'WHERE `parent`='.$iParentKey.') max_position, '

		      .        '0 min_position, '

		      .        'p.`position`, '

		      .        'p.`page_id`, p.`parent`, p.`level`, p.`language`, p.`admin_groups`, '

		      .        'p.`admin_users`, p.`viewing_groups`, p.`viewing_users`, p.`visibility`, '

		      .        'p.`menu_title`, p.`page_title`, p.`page_trail` '

		      .    'ON p.`page_id`=s.`page_id` ';

//		if($iParentKey) {

//

			$sql .= 'WHERE `parent`='.$iParentKey.' ';

//		}

	// do not get pages with 'deleted' flag set on activated trashcan

			$sql .= 'AND `visibility`!=\'deleted\' ';

		}

		$sql .= 'GROUP BY p.`page_id` '

			$iMinPosition = 1;

			while($aPage = $oPages->fetchRow(MYSQL_ASSOC))

			{ // iterate through the current branch

					return '';

				}

				$aPage['min_position'] = ($aPage['position'] < $iMinPosition ? $aPage['position'] : $iMinPosition);

				if( $this->_oApp->ami_group_member($aPage['admin_users']) ||

					$this->_oApp->is_group_match($this->_oApp->get_groups_id(), $aPage['admin_groups']))

				{

					   ($aPage['visibility'] != 'deleted'))

					{

						$aPage['iswriteable'] = true;

		          . (int)($aPage['level']*20).'px;">';

		if((bool)$aPage['children']) {

			$sOutput .= '<a href="javascript:toggle_visibility(\'p'.$aPage['page_id'].'\');" '

			          . ( ((isset($_COOKIE['p'.$aPage['page_id']]) 

						  && $_COOKIE['p'.$aPage['page_id']] == '1') ? 'minus' : 'plus')

						)

	// --- TAB 2 --- (menu title) --------------------------------------------------------

		$sOutput .= $this->_Tabs(0).'<td class="list_menu_title">';

		if($this->_oApp->get_permission('pages_modify') && $aPage['iswriteable']) {

		}

		}

		if($this->_oApp->get_permission('pages_modify') && $aPage['iswriteable']) {

			$sOutput .= '<span class="modify_link">'.$aPage['menu_title'].'</span></a>';

		}else {

	// --- TAB 5 --- (show this page in new window) --------------------------------------

		$sOutput .= $this->_Tabs(0).'<td class="list_actions">';

		if($aPage['visibility'] != 'deleted' && $aPage['visibility'] != 'none') {

			                                 '', 

			                                 $this->_oApp->page_link($aPage['link'])

			                                );

		}else { 

		}

		$sOutput .= '</td>'.PHP_EOL;

		$sOutput .= $this->_Tabs(0).'<td class="list_actions">';

		if($aPage['visibility'] != 'deleted') { 

			if($this->_oApp->get_permission('pages_settings') && $aPage['iswriteable']) {

			}

		}else {

		}

		$sOutput .= '</td>'.PHP_EOL;

	// --- TAB 7 --- (edit sections) -----------------------------------------------------

		$sOutput .= $this->_Tabs(0).'<td class="list_actions">';

			$file = $this->_oApp->page_is_active($aPage) ? "clock_16.png" : "clock_red_16.png";

			$file = ($aPage['published'] && $aPage['module'] != 'menu_link') ? $file : 'noclock_16.png';

		}else { 

		}

		$sOutput .= '</td>'.PHP_EOL;

		if($aPage['position'] > $aPage['min_position']) {

			if($aPage['visibility'] != 'deleted') {

				if($this->_oApp->get_permission('pages_settings') && $aPage['iswriteable']) {

				}

			}

		}

		if($aPage['position'] < $aPage['max_position']) {

			if($aPage['visibility'] != 'deleted') {

				if($this->_oApp->get_permission('pages_settings') && $aPage['iswriteable']) {

				}

			}

		}

		$sOutput .= $this->_Tabs(0).'<td class="list_actions">';

		if($this->_oApp->get_permission('pages_delete') && $aPage['iswriteable']) {

			$sOutput .= '<a href="javascript:confirm_link(pages_delete_confirm+\'?\',\''

			          . $this->_oApp->getIDKEY($aPage['page_id']).'\');" title="'

		}else { 

		}

		$sOutput .= '</td>'.PHP_EOL;

			$this->_oApp->get_permission('pages_add')

			&& $aPage['iswriteable'] 

			&& ($aPage['visibility'] != 'deleted') 

		  )

		{

			$sOutput .= '<a href="javascript:add_child_page(\''.$aPage['page_id'].'\');" '

		}else { 

			$sOutput .= ' '; 

		}

 */	

	protected function _addToParentList(array $aPage)

	{

			&& $aPage['iswriteable'] 

			&& ($aPage['visibility'] != 'deleted')

			&& $this->_oApp->get_permission('pages_add') ) 

			$iMinPosition = 1;

			while($aPage = $oPages->fetchRow(MYSQL_ASSOC))

			{ // iterate through the current branch

					return '';

				}

				$aPage['min_position'] = ($aPage['position'] < $iMinPosition ? $aPage['position'] : $iMinPosition);

				if( $this->_oApp->ami_group_member($aPage['admin_users']) ||

					$this->_oApp->is_group_match($this->_oApp->get_groups_id(), $aPage['admin_groups']))

				{

					   ($aPage['visibility'] != 'deleted'))

					{

						$aPage['iswriteable'] = true;

// check if defined to avoid errors during installation (redirect to admin panel fails if PHP error/warnings are enabled)

if(!defined('VERSION')) define('VERSION', '2.8.3');

if(!defined('SP')) define('SP', '');