WB 2.08.x

10 Oct-2013 Build 1980 Dietmar Woellbrink (Luisehahne)

! /framework/initialize.php::SetInstallPathConstants() setting of DOCUMENT_ROOT now compatible for windows installation

! /framework/functions.php::rebuild_all_accessfiles() Optimize rebuild access file coding

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

            define('DOCUMENT_ROOT', preg_replace('/'.preg_quote(str_replace('\\', '/', WB_REL), '/').'$/', '', str_replace('\\', '/', WB_PATH)));			

            // creating $_SERVER['DOCUMENT_ROOT'] for Windows IIS Server

            $_SERVER['DOCUMENT_ROOT'] = DOCUMENT_ROOT;

if(!function_exists('rebuild_all_accessfiles'))

{

	function rebuild_all_accessfiles($bShowDetails=false ) 

	{

		$oDb = WbDatabase::getInstance();

		$oReg = WbAdaptor::getInstance();

	// try to remove access files and build new folder protect files

        $sTreeToDelete = $oReg->AppPath.$oReg->PagesDir;

    	if(($sTreeToDelete!='') && is_writeable($sTreeToDelete)==true)

		{

			$aDeleteLog = array();

            DeleteAccessFilesTree($sTreeToDelete, $aDeleteLog);

		// show details if debug is set

            if($bShowDetails) { $aRetval = $aDeleteLog; }

	// set logging informations

		$aRetval = array_merge((isset($aRetval) ? $aRetval : array()),

		                       createFolderProtectFile(rtrim( $oReg->AppPath.$oReg->PagesDir, '/') ));

	// Reformat/rebuild all existing access files

		$sql  = 'SELECT `page_id`,`root_parent`,`parent`,`link`,`level`,`page_trail` '

		      . 'FROM `'.$oDb->TablePrefix.'pages` '

		      . 'WHERE `link` != \'\' '

		      . 'ORDER BY `link`';

        if (($oPage = $oDb->query($sql)))

            $iFileCounter = 0;

		// iterate over all existing page records

            while (($aPageRecord = $oPage->fetchRow(MYSQL_ASSOC)))

		// --- begin reorg tree structure ------------------------------------------------

			// rebuild level entries

				$sql = 'SELECT `level`+1 AS `level`, `page_trail` '

				     . 'FROM `'.$oDb->TablePrefix.'pages` '

					 . 'WHERE `page_id`='.$aPageRecord['parent'];

			// search for parent record

				$oParent = $oDb->query($sql);

				if(($aParentRecord = $oParent->fetchRow(MYSQLI_ASSOC)))

				{

				// get values from existing parent record

					$aPageRecord['level'] = intval($aParentRecord['level']);

					$aPageRecord['root_parent'] = intval($aParentRecord['page_trail']);

					$aPageRecord['page_trail'] = (string)$aParentRecord['page_trail'].','.(string)$aPageRecord['page_id'];

				}else

				{

				// set as root record if no parentrecord exists

					$aPageRecord['level'] = 0;

					$aPageRecord['root_parent'] = $aPageRecord['page_id'];

					$aPageRecord['page_trail'] = (string)$aPageRecord['page_id'];

				}

			// update current record with regenerated values

                $sql  = 'UPDATE `'.$oDb->TablePrefix.'pages` '

				      . 'SET `root_parent`='.$aPageRecord['root_parent'].', '

				      .     '`level`='.$aPageRecord['level'].', '

				      .     '`page_trail`=\''.$aPageRecord['page_trail'].'\' '

				      . 'WHERE `page_id`='.$aPageRecord['page_id'];

				$oDb->query($sql);

		// --- end reorg tree structure --------------------------------------------------

                $sFilename = $oReg->AppPath.$oReg->PagesDir.$aPageRecord['link'].$oReg->PageExtension;

				$oAccessFile = new AccessFile($sFilename, $aPageRecord['page_id']);

				$oAccessFile->write();

				unset($oAccessFile);

                $iFileCounter++;

            $aRetval[] = 'Number of new formated access files: '.$iFileCounter;

		return $aRetval;

	} // end of function rebuild_all_accessfiles()

} // endif