WB 2.08.x

14 Aug-2013 Build 1953 M.v.d.Decken(DarkViper)

# solved some problems with MultiLingual module

	<table>

		<thead>

			<tr>

				<th class="description"></th>

				<th class="id"></th>

				<th></th>

			</tr>

		</thead>

		<tbody>

			<tr>

				<td class="left nowrap"><h2>{HEADING_MODIFY_PAGE_SETTINGS}</h2></td>

				<td class="left">PID: {PAGE_ID}</td>

				<td class="right nowrap">

					{TEXT_CURRENT_PAGE}:<strong>{PAGE_TITLE}</strong><br />

					{MODIFY_LINK_BEFORE}{TEXT_MODIFY_PAGE}{MODIFY_LINK_AFTER}

					<span class="{DISPLAY_MANAGE_SECTIONS}">

						- {SECTIONS_LINK_BEFORE}{TEXT_MANAGE_SECTIONS}{SECTIONS_LINK_AFTER}

					</span>

					<br />

					<span class="right {DISPLAY_MODIFIED}">

						{TEXT_LAST_MODIFIED} {MODIFIED_BY}, {MODIFIED_WHEN}

					</span>

				</td>

			</tr>

		</tbody>

	</table>

					style="background-image: url({THEME_URL}/icons/help_16.png);" {p_menu_page_code}>

					<a href="{PAGE_CODE_UPDATE_URL}">{PAGE_CODE_LABEL_TEXT}: </a>

					<option value="{PAGE_CODE_VALUE}"{PAGE_CODE_SELECTED} style="background: {PAGE_CODE_ICON_URL} no-repeat center left; padding-left: 20px;">

						{PAGE_CODE_PAGE_TITLE}

					</option>

	protected $_TEXT     = null;

	protected $_MESSAGE  = null;

	protected $_HEADING  = null;

	protected $_oApp     = null;

	protected $_oDb      = null;

	protected $_aReg     = array();

	protected $_sOutput         = '';

	protected $_iPagesTotal     = 0;

	protected $_iPagesWriteable = 0;

	protected $_iLineColor      = 0;

	protected $_aParentList     = array();

	protected $_queries = 0;

	public function getParentList($iTreeRoot = 0) {

			$this->parseTree($iTreeRoot);

	protected function _wbAdaptor()

	protected function _createTree($iTreeRoot = 0)

	protected function _Tabs($iTabsDiv = 0, $bRelative = true)

	protected function _makeSql($iParentKey = 0)

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

		      .          'FROM `'.$this->_aReg['TABLE_PREFIX'].'pages` `x` '

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

		      .        ') `children`, '

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

		      .        '(SELECT MAX(`position`) FROM `'.$this->_aReg['TABLE_PREFIX'].'pages` '

		      .        '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` '

		      . 'FROM `'.$this->_aReg['TABLE_PREFIX'].'pages` p '

		      .    'INNER JOIN `'.$this->_aReg['TABLE_PREFIX'].'sections` s '

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

//		if($iParentKey) {

//

//			$sql .= 'WHERE `root_parent`='.$iParentKey.' ';

//		} else {

//	// if tree based on root is requested (parent=0)

			$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` '

		      . 'ORDER BY p.`position` ASC';

	protected function _IterateTree($iParent = 0)

	protected function _createListItem($aPage)

	protected function _addToParentList(array $aPage)

			$aPage['disabled'] = ($aPage['iswriteable'] ? 0 : 1);

			$this->_aParentList[] = $aPage;

<?php

/**

 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.

 *

 * This program is free software: you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program.  If not, see <http://www.gnu.org/licenses/>.

 */

/**

 * ParentPageTree.php

 *

 * @category     WbACP

 * @package      WbACP_Pages

 * @copyright    Manuela v.d.Decken <manuela@isteam.de>

 * @author       Manuela v.d.Decken <manuela@isteam.de>

 * @license      http://www.gnu.org/licenses/gpl.html   GPL License

 * @version      0.0.1

 * @revision     $Revision: $

 * @link         $HeadURL: $

 * @lastmodified $Date: $

 * @since        File available since 05.08.2013

 * @description  xyz

 */

class a_pages_SmallRawPageTree extends a_pages_PageTree{

/**

 * 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

 */

	protected function _createTree($iTreeRoot = 0)

	{

		// generate the page lines

		$this->_IterateTree($iTreeRoot);

		return '';

	}

/**

 * iterate through all nodes which having subnodes

 * @param integer start iteration from this parent page ( 0 = root)

 * @return string all of the item lines

 */

	protected function _IterateTree($iParent = 0)

	{

		$sOutput = '';

	// Get page list from database

		if(($oPages = $this->_oDb->query($this->_makeSql($iParent))))

		{

			$this->_queries++;

			$iMinPosition = 1;

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

			{ // iterate through the current branch

				if($this->_aReg['PAGE_LEVEL_LIMIT'] && ($aPage['level'] > $this->_aReg['PAGE_LEVEL_LIMIT'])) {

					return '';

				}

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

				$this->_iLineColor = $this->_iPagesTotal++ % 2;

				$aPage['iswriteable'] = false;

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

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

				{

					if(($aPage['visibility'] == 'deleted' && $this->_aReg['PAGE_TRASH'] == 'inline') ||

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

					{

						$aPage['iswriteable'] = true;

						$this->_iPagesWriteable++;

					}

				} else {

					if($aPage['visibility'] == 'private') { continue; }

				}

			// add this item to the secondary list of parents

				$this->_addToParentList($aPage);

			// if there are children, iterate through this children now

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

					$this->_IterateTree($aPage['page_id']);

				}

			}

		}

		return $sOutput;

	}

} // end of class LanguagePageTree

	$oDb = WbDatabase::getInstance();

/*-- start multilanguage page_code -----------------------------------------------------*/

		$aTplBlockData = array();

	// workout field is set but module missing

		$aTplBlockData['PAGE_CODE_LABEL_TEXT'] = $mLang->TEXT_PAGE_CODE;

		$aTplBlockData['PAGE_CODE_UPDATE_URL'] = WB_REL.'/modules/MultiLingual/update_keys.php?page_id='.$page_id;

	// get the root element(level 0) of current page with same language  in same menu

		$sql =  'SELECT `page_id` FROM `'.$oDb->TablePrefix.'pages` '

		     .  'WHERE `language`=\''.DEFAULT_LANGUAGE.'\' '

		     .         'AND `level`=0 ';

		if(defined('MULTIPLE_MENUS') && MULTIPLE_MENUS == 'true') {

			$sql .=    'AND `menu`='.$aCurrentPage['menu'].' ';

		$sql .= 'ORDER BY `position` ASC';

		$iLangStartPageId = $oDb->get_one($sql);

	// read the tree of the found root element

		$oPageList = new a_pages_SmallRawPageTree();

		$aLangCodePagesList = $oPageList->getParentList($iLangStartPageId);

	// create option list for the select box

		$aTplItemData = array();

		$bPageCodeIsSelected = false;

	// add 'no selection' option at top

		if($admin->get_permission('pages_add_l0') OR !$aCurrentPage['level'])

		{

			$aTplItemData['PAGE_CODE_VALUE']      = 0;

			$aTplItemData['PAGE_CODE_PAGE_TITLE'] = $mLang->TEXT_NONE;

			$bPageCodeIsSelected = ($aCurrentPage['page_code'] == 0);

			$aTplItemData['PAGE_CODE_SELECTED'] = ($bPageCodeIsSelected ? $sSelected : '');

			$oTpl->set_var($aTplItemData);

			$aTplItemData = array();

		$iLastEntryLevel = 0;

		$bSkipChildren = false;

	// loop through all items

		while (list(, $aPage) = each($aLangCodePagesList)) 

		{

		// skip child pages where current user has no rights for

			if($bSkipChildren && ($aPage['level'] > $iLastEntryLevel)) { continue; }

			$bSkipChildren   = false;

			$iLastEntryLevel = $aPage['level'];

		//skip entry if it's not visible

			if(($admin->page_is_visible($aPage)==false) && ($aPage['visibility'] <> 'none') ) { continue; }

		// insert language flag on level 0

			$sThemeRel = WB_REL.'/'.str_replace(WB_URL, '', THEME_URL).'/images/flags/'.strtolower($aPage['language']).'.png)';

			$aTplItemData['PAGE_CODE_ICON_URL'] = ($aPage['level'] ? 'url('.$sThemeRel.')' : 'none');

		// create indent chars

			$sTitlePrefix = str_repeat('-- ', $aPage['level']).' ';

			$aTplItemData['PAGE_CODE_PAGE_TITLE'] = $sTitlePrefix . $aPage['menu_title'];

			$aTplItemData['PAGE_CODE_VALUE']      = intval($aPage['page_code']);

		// set SELECTED status of this entry

			if( $aPage['page_id'] == $aCurrentPage['page_code']

			    && $aCurrentPage['page_code'] != 0

				&& !$bPageCodeIsSelected

			  )

			{ // 

				$aTplItemData['PAGE_CODE_SELECTED'] = $sSelected;

				$bPageCodeIsSelected = true;

			} elseif(!$aPage['iswriteable'])

			{ // 

				$aTplItemData['PAGE_CODE_SELECTED'] = $sDisabled.' class="disabled"';

				$bSkipChildren = true;

			} else {

				$aTplItemData['PAGE_CODE_SELECTED'] = '';

			}

		// output item data

			$oTpl->set_var($aTplItemData);

			$oTpl->parse('page_code_list', 'page_code_list_block', true);

			$aTplItemData = array();

		}

	// output block data

		$oTpl->set_var($aTplBlockData);

/*-- end multilanguage page_code -------------------------------------------------------*/

	$aNewEntry = array();

	$aNewEntry['page_id']        = 0;

	$aNewEntry['menu_title']     = $TEXT['NONE'];

	$aNewEntry['disabled']       = 0;

	$aNewEntry['parent']         = 99;

	$aNewEntry['flag_root_icon'] = '';

	$aNewEntry['level']          = 0;

	$aNewEntry['language']       = '';

	array_unshift($aParents, $aNewEntry);

			$aNewEntry = array();

			$aNewEntry['ID']             = $aItem['page_id'];

			$aNewEntry['PARENT']         = $aItem['parent'];

			$aNewEntry['LEVEL']          = $aItem['level'];

			$aNewEntry['LANGUAGE']       = $aItem['language'];

			$aNewEntry['FLAG_ROOT_ICON'] = '';

			$aNewEntry['DISABLED'] = ($aItem['disabled'] ? ' disabled="disabled" class="disabled"' : '');

			if(!$aItem['parent']) {

				$aNewEntry['FLAG_ROOT_ICON'] = ' style="background-image: url('.THEME_REL.'/images/flags/'

			$aNewEntry['TITLE'] = str_repeat('- ', $aItem['level']).$aItem['menu_title'];

			$oTpl->set_var($aNewEntry);

if(!defined('REVISION')) define('REVISION', '1953');

$oTrans = Translate::getInstance();

	$admin->print_success($oTrans->MESSAGE_PAGES_UPDATE_SETTINGS, ADMIN_URL.'/pages/settings.php?page_id='.$temp_page_id );