getTableEngine(TABLE_PREFIX.$aTable[$x]))) {
if(('myisam' != strtolower($sOldType))) {
if(!$database->query('ALTER TABLE `'.TABLE_PREFIX.$aTable[$x].'` Engine = \'MyISAM\' ')) {
$msg[] = $database->get_error();
} else{
$msg[] = 'TABLE `'.TABLE_PREFIX.$aTable[$x].'` changed to Engine = \'MyISAM\'';
}
} else {
$msg[] = 'TABLE `'.TABLE_PREFIX.$aTable[$x].'` has Engine = \'MyISAM\'';
}
} else {
$msg[] = $database->get_error();
}
}
$sPagesPath = WB_PATH.PAGES_DIRECTORY;
$sPostsPath = $sPagesPath.'/posts';
// create /posts/ - directory if not exists
if(!file_exists($sPostsPath)) {
if(is_writable($sPagesPath)) {
make_dir(WB_PATH.PAGES_DIRECTORY.'/posts/');
} else {
if(!$globalStarted){
$msg[] = ($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE']);
// $admin->print_error($MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE']);
return $msg;
} else {
echo ''.$MESSAGE['PAGES_CANNOT_CREATE_ACCESS_FILE'].'';
return;
}
}
$msg[] = 'Directory "'.PAGES_DIRECTORY.'/posts/" created';
} else {
$msg[] = 'Directory "'.PAGES_DIRECTORY.'/posts/" already exists.';
}
// check if new fields must be added
$doImportDate = true;
if(!$database->field_exists(TABLE_PREFIX.'mod_news_posts', 'created_when')) {
if(!$database->field_add(TABLE_PREFIX.'mod_news_posts', 'created_when',
'INT NOT NULL DEFAULT \'0\' AFTER `commenting`')) {
if($globalStarted){
echo ''.$MESSAGE['RECORD_MODIFIED_FAILED'].'';
return;
} else {
// $admin->print_error($MESSAGE['RECORD_MODIFIED_FAILED']);
$msg[] = $$MESSAGE['RECORD_MODIFIED_FAILED'];
return $msg;
}
}
if($globalStarted) {
echo 'Datafield `'.TABLE_PREFIX.'mod_news_posts`.`created_when` added.
';
}
} else { $doImportDate = false; }
if(!$database->field_exists(TABLE_PREFIX.'mod_news_posts', 'created_by')) {
if(!$database->field_add(TABLE_PREFIX.'mod_news_posts', 'created_by',
'INT NOT NULL DEFAULT \'0\' AFTER `created_when`')) {
if($globalStarted){
echo ''.$MESSAGE['RECORD_MODIFIED_FAILED'].'';
return;
}else {
// $admin->print_error($MESSAGE['RECORD_MODIFIED_FAILED']);
$msg[] = $$MESSAGE['RECORD_MODIFIED_FAILED'];
return $msg;
}
}
if($globalStarted) {
echo 'datafield `'.TABLE_PREFIX.'mod_news_posts`.`created_by` added.
';
}
}
// preset new fields `created_by` and `created_when` from existing values
if($doImportDate) {
$sql = 'UPDATE `'.TABLE_PREFIX.'mod_news_posts` ';
$sql .= 'SET `created_by`=`posted_by`, `created_when`=`posted_when`';
$database->query($sql);
}
/**
* rebuild news post folder
*/
$array = rebuildFolderProtectFile($sPostsPath);
// now iterate through all existing accessfiles,
// write its creation date into database
$oDir = new DirectoryIterator($sPostsPath);
$count = 0;
foreach ($oDir as $fileinfo)
{
$fileName = $fileinfo->getFilename();
if((!$fileinfo->isDot()) &&
($fileName != 'index.php') &&
(substr_compare($fileName,PAGE_EXTENSION,(0-strlen(PAGE_EXTENSION)),strlen(PAGE_EXTENSION)) === 0)
)
{
// save creation date from old accessfile
if($doImportDate) {
$link = '/posts/'.preg_replace('/'.preg_quote(PAGE_EXTENSION).'$/i', '', $fileinfo->getFilename());
$sql = 'UPDATE `'.TABLE_PREFIX.'mod_news_posts` ';
$sql .= 'SET `created_when`='.$fileinfo->getMTime().' ';
$sql .= 'WHERE `link`=\''.$link.'\'';
$database->query($sql);
}
// delete old access file
unlink($fileinfo->getPathname());
$count++;
}
}
unset($oDir);
if($count > 0) {
$msg[] = 'save date of creation from '.$count.' old accessfiles and delete these files.';
}
// ************************************************
// Check the validity of 'create-file-timestamp' and balance against 'posted-timestamp'
$sql = 'UPDATE `'.TABLE_PREFIX.'mod_news_posts` ';
$sql .= 'SET `created_when`=`published_when` ';
$sql .= 'WHERE `published_when`<`created_when`';
$database->query($sql);
$sql = 'UPDATE `'.TABLE_PREFIX.'mod_news_posts` ';
$sql .= 'SET `created_when`=`posted_when` ';
$sql .= 'WHERE `published_when`=0 OR `published_when`>`posted_when`';
$database->query($sql);
// ************************************************
// rebuild all access-files
$count = 0;
$backSteps = preg_replace('@^'.preg_quote(WB_PATH).'@', '', $sPostsPath);
$backSteps = str_repeat( '../', substr_count($backSteps, '/'));
$sql = 'SELECT `page_id`,`post_id`,`section_id`,`link` ';
$sql .= 'FROM `'.TABLE_PREFIX.'mod_news_posts`';
$sql .= 'WHERE `link` != \'\'';
if( ($resPosts = $database->query($sql)) )
{
while( $recPost = $resPosts->fetchRow() )
{
$file = $sPagesPath.$recPost['link'].PAGE_EXTENSION;
$content =
'Number of new created access files: '.$count.'';
}
// only for upgrade-script
if($globalStarted) {
if($bDebugModus) {
foreach($msg as $title) {
echo ''.$title.'
';
}
}
}
return $msg;
}
}
// end mod_news_Upgrade
// ------------------------------------
$msg = mod_news_Upgrade();
/* **** END UPGRADE ********************************************************* */