WB 2.11.0

<?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/>.

 *

 * @category        core

 * @package         test

 * @subpackage      test

 * @author          Dietmar Wöllbrink

 * @copyright       WebsiteBaker Org. e.V.

 * @link            http://websitebaker.org/

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

 * @platform        WebsiteBaker 2.8.4

 * @requirements    PHP 5.4 and higher

 * @version         $Id: rebuildAccessFiles.php 2 2017-07-02 15:14:29Z Manuela $

 * @filesource      $HeadURL: svn://isteam.dynxs.de/wb/2.10.x/branches/main/admin/pages/rebuildAccessFiles.php $

 * @lastmodified    $Date: 2017-07-02 17:14:29 +0200 (Sun, 02 Jul 2017) $

 * @created         2016-02-17

 *

 */

 // Create new admin object and print admin header

require( dirname(dirname((__DIR__))).'/config.php' );

if ( !class_exists('admin', false) ) { require(WB_PATH.'/framework/class.admin.php'); }

if ( !class_exists( 'order', false ) ) { require(WB_PATH.'/framework/class.order.php'); }

// suppress to print the header, so no new FTAN will be set

//$admin = new admin('Pages', 'pages_settings',false);

if ( !function_exists( 'create_access_file' ) ) { require(WB_PATH.'/framework/functions.php'); }

require (WB_PATH.'/modules/SimpleRegister.php');

//$target_url = ADMIN_URL.'/pages/settings.php?page_id='.$page_id;

//$pagetree_url = ADMIN_URL.'/pages/index.php';

    function _makeSql($iParentKey = 0)

    {

        global $oDb, $oReg;

        $iParentKey = intval($iParentKey);

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

              .          'FROM `'.$oReg->TablePrefix.'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 `'.$oReg->TablePrefix.'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`, p.`modified_when`, '

              .        'GROUP_CONCAT(CAST(CONCAT(s.`section_id`, \' - \', s.`module`) AS CHAR) ORDER BY s.`position` SEPARATOR \'\n\') `section_list` '

              . 'FROM `'.$oReg->TablePrefix.'pages` p '

              .    'INNER JOIN `'.$oReg->TablePrefix.'sections` s '

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

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

              .    (($oReg->PageTrash != 'inline') ? 'AND `visibility`!=\'deleted\' ' : '')

              . 'GROUP BY p.`page_id` '

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

        return $sql;

    }

    function _IterateTree($iParent = 0)

    {

        global $oDb, $oReg, $_queries, $index,$aOutput;

      // Get page list from database

        if(($oPages = $oDb->query(_makeSql($iParent))))

        {

            $_queries++;

            $iMinPosition = 1;

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

            { // iterate through the current branch

                if($oReg->PageLevelLimit && ($aPage['level'] > $oReg->PageLevelLimit)) {

                    break;

                }

                // array for sitemap

                $aOutput[$aPage['page_id']] = array(

                'loc' => $oReg->AppUrl.$oReg->PagesDir.trim($aPage['link'],'/').$oReg->PageExtension,

                'lastmod' => date(DATE_W3C, (int)$aPage['modified_when']),

                'changefreq' => 'monthly',

                'priority' => '0.5'

                );

                // array to create accessfiles

                $aOutput[$aPage['page_id']] = $aPage;

                // could not use oReg, we are needing backslashes to create access files

                $sPageFile = WB_PATH.PAGES_DIRECTORY.'/'.trim($aPage['link'],'/').$oReg->PageExtension;

                if( is_writeable( $sPageFile ) || !file_exists( $sPageFile ) ) {

                    create_access_file( $sPageFile, $aPage['page_id'], $aPage['level']);

                    $index++; //

                }

                if((int)$aPage['children'] > 0 ) {

                    _IterateTree($aPage['page_id']);

                }

          }

        }

        return $aOutput;

    }

      $_queries  = $index = 0;

      $iTreeRoot = 0;

      $aOutput   = array();

      $aPageTree = array();

      $aPageTree = _IterateTree($iTreeRoot);

      echo '<h3>Creating '.$index.' access files</h3>';