WB 2.08.x

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

 */

/**

 * Reorg.php

 *

 * @package      news_package

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

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

 * @version      0.0.1

 * @revision     $Revision: $

 * @link         $HeadURL: $

 * @lastmodified $Date: $

 * @description  reorganisize all accessfiles of the addon 'news'

	protected $sAccessFilesRoot = '';

/** sub directory for accessfiles

 * @description  This is needed to correct db::x_mod_news_posts::link entries of former versions<br />

 *               It can be removed after <b>all</b> modules accessing news are modified to access

 *               without a hardcoded subdirectory name.

 */

	protected $sAccessFilesSubdir = 'posts/';

 * @return boolean

 * @description Structure of report array.<br />

 *              (int) number of 'FilesDeleted'<br />

 *              (int) number of 'FilesCreated'<br />

 *              (array) 'Success'<br />

 *              (array) 'Failed'

 */

	// reset report

		                        'FilesCreated'=>0,

		                        'Success'=>array(),

		                        'Failed'=>array()

		                      );

		$this->sAccessFilesRoot = $this->oReg->AppPath.$this->oReg->PagesDir.$this->sAccessFilesSubdir;

		$this->deleteAll();

	// recreate new accessfiles

		$this->rebuildAll();

	// return true if all is successful done

		return (sizeof($this->aReport['Failed']) == 0);

	}

/**

 * deleteAll

 * @throws AccessFileException

 * @description delete all accessfiles and its children in $sAccessFilesRoot

 */

	protected function deleteAll()

	{

	// scan start directory for access files

		if(is_array($aMatches))

				$sItem = str_replace('\\', '/', $sItem);

				if(AccessFileHelper::isAccessFile($sItem))

					if(is_writable($sItem) && @unlink($sItem))

						if($this->bDetailedLog)

						{

							$this->aReport['Success'][] = 'File successful removed : '.str_replace($this->oReg->AppPath, '', $sItem);

						}

					// increment successful counter

						$this->aReport['FilesDeleted']++;

					}else

					{

					// if failed

						$this->aReport['Failed'][] = 'Delete file failed : '.str_replace($this->oReg->AppPath, '', $sItem);

			} // endforeach

		}else

		{

			$this->aReport['Failed'][] = 'Directory scan failed : '.str_replace($this->oReg->AppPath, '', $this->sAccessFilesRoot);

		}

/**

 * rebuildAll

 * @return integer  number of successful deleted files

 * @throws AccessFileException

 * @description rebuild all accessfiles from database

 */

	protected function rebuildAll()

	{

		$sql = 'SELECT `page_id`, `post_id`, `section_id`, `link`, `title` '

		     . 'FROM `'.$this->oDb->TablePrefix.'mod_news_posts` '

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

		if(($oPosts = $this->oDb->query($sql)))

		{

			while(($aPost = $oPosts->fetchRow(MYSQL_ASSOC)))

			{

			// sanitize link if there is an old value in database from former versions

				$aPost['link'] = preg_replace( '/^'.preg_quote($this->sAccessFilesSubdir, '/').'/',

				                               '',

				                               trim( str_replace('\\', '/', $aPost['link']), '/')

				                             );

				$sAccFileName = $this->sAccessFilesRoot.$aPost['link'].$this->oReg->PageExtension;

				{

				// create new object

					$oAccFile->addVar('post_id',      $aPost['post_id'],    AccessFile::VAR_INT);

					$oAccFile->addVar('post_section', $aPost['section_id'], AccessFile::VAR_INT);

					$oAccFile->write();

				// destroy object if its file is written

					unset($oAccFile);

					if($this->bDetailedLog)

					{

						$this->aReport['Success'][] = 'File successful created : '.str_replace($this->oReg->AppPath, '', $sAccFileName);

					}

				// increment successful counter

					$this->aReport['FilesCreated']++;

				}catch(AccessFileException $e)

				{

				// if failed

					$this->aReport['Failed'][] = ($this->bDetailedLog ? $e : $e->getMessage());

				}

			} // endwhile

		} // endif

	} // end of function rebuildAll()