WB 2.08.x

 * upgrade.php

 * 

 * @category     Module

 * @subpackage   upgrade

 * @author       Dietmar Wöllbrink <dietmar.woellbrink@websitebaker.org>

 * @author       Werner v.d.Decken <wkl@isteam.de>

			$sPagesPath = WB_PATH.PAGES_DIRECTORY;

			$sPostsPath = $sPagesPath.'/posts';

			if(is_writable($sPagesPath)) {

				if(!($bRetval = is_dir($sPostsPath))) {

					$iOldUmask = umask(0) ;

				$msg[] = 'TABLE `'.$database->TablePrefix.'mod_news_posts` Datafield `created_by` already exists.'." $OK";

				$doImportDate = false; 

			}

			if($doImportDate) {

				$sql  = 'UPDATE `'.$database->TablePrefix.'mod_news_posts` ';

				$sql .= 'SET `created_by`=`posted_by`, `created_when`=`posted_when`';

				$database->query($sql);

			}

	/**

	 * rebuild news post folder

	 */

			if($count > 0) {

				$msg[] = 'Save date of creation from '.$count.' old accessfiles and delete these files.'." $OK";

			}

// ************************************************

			$sql  = 'UPDATE `'.$database->TablePrefix.'mod_news_posts` ';

			$sql .= 'SET `created_when`=`published_when` ';

			$sql .= 'WHERE `published_when`<`created_when`';