0){
$msg[] = 'TABLE '.implode(' missing! '.$FAIL.'
TABLE ',$aPackage).' missing! '.$FAIL;
$msg[] = 'WYSIWYG upgrade failed '." $FAIL";
if($globalStarted) {
echo ''.implode('
',$msg).'
';
}
return ( ($globalStarted==true ) ? $globalStarted : $msg);
} else {
for($x=0; $xgetTableEngine($oDb->TablePrefix.$aTable[$x]))) {
if(('myisam' != strtolower($sOldType))) {
if(!$oDb->query('ALTER TABLE `'.$oDb->TablePrefix.$aTable[$x].'` Engine = \'MyISAM\' ')) {
$msg[] = $oDb->get_error();
} else{
$msg[] = 'TABLE `'.$oDb->TablePrefix.$aTable[$x].'` changed to Engine = \'MyISAM\''." $OK";
}
} else {
$msg[] = 'TABLE `'.$oDb->TablePrefix.$aTable[$x].'` has Engine = \'MyISAM\''." $OK";
}
} else {
$msg[] = $oDb->get_error();
}
}
// add change or missing index
$sTable = $oDb->TablePrefix.'mod_wysiwyg';
if($oDb->index_exists($sTable, 'PRIMARY')) {
$sql = 'ALTER TABLE `'.$oDb->DbName.'`.`'.$sTable.'` DROP PRIMARY KEY';
if(!$oDb->query($sql)) {
$msg[] = ''.$oDb->get_error();
}
}
if(!$oDb->index_add($sTable, '', 'section_id', 'PRIMARY')) {
$msg[] = ''.$oDb->get_error();
} else {
$msg[] = 'Create PRIMARY KEY ( `section_id` )'." $OK";
}
// change table structure
$sTable = $oDb->TablePrefix.'mod_wysiwyg';
$sDescription = 'LONGTEXT NOT NULL';
$sFieldName = 'text';
if(!$oDb->field_modify($sTable,$sFieldName,$sDescription)) {
$msg[] = ''.$oDb->get_error();
} else {
$msg[] = 'Field ( `text` ) description has been changed successfully'." $OK";
}
$sFieldName = 'content';
if(!$oDb->field_modify($sTable,$sFieldName,$sDescription)) {
$msg[] = ''.$oDb->get_error();
} else {
$msg[] = 'Field ( `content` ) description has been changed successfully'." $OK";
}
// change internal absolute links into Sysvar placeholders and repair already existing entries
$sTable = $oDb->TablePrefix.'mod_wysiwyg';
$sql = 'SELECT `section_id`, `content` FROM `'.$oDb->TablePrefix.'mod_wysiwyg` ';
if (($oEntrySet = $oDb->doQuery($sql))) {
$iRecords = 0;
$iReplaced = 0;
$aSearch = array( '/\{SYSVAR\:MEDIA_REL\}[\/\\\\]?/sU',
'/\{SYSVAR\:WB_URL\}[\/\\\\]?/sU',
'/(\{SYSVAR\:AppUrl\.MediaDir\})[\/\\\\]?/sU',
'/(\{SYSVAR\:AppUrl\})[\/\\\\]?/sU'
);
$aReplace = array( '{SYSVAR:AppUrl.MediaDir}', '{SYSVAR:AppUrl}', '\1', '\1' );
while (($aEntry = $oEntrySet->fetchRow(MYSQL_ASSOC))) {
$iCount = 0;
$aEntry['content'] = preg_replace($aSearch, $aReplace, $aEntry['content'], -1, $iCount);
if ($iCount > 0) {
$iReplaced += $iCount;
$sql = 'UPDATE `'.$oDb->TablePrefix.'mod_wysiwyg` '
. 'SET `content`=\''.$oDb->escapeString($aEntry['content']).'\' '
. 'WHERE `section_id`='.$aEntry['section_id'];
$oDb->doQuery($sql);
$iRecords++;
}
}
$msg[] = '['.$iRecords.'] records with ['.$iReplaced.'] SYSVAR placeholder(s) repaired'." $OK";
}
try {
$sql = 'UPDATE `'.$sTable.'` ';
$sql .= 'SET `content` = REPLACE(`content`, \'"'.$oReg->AppPath.$oReg->MediaDir.'\', \'"{SYSVAR:AppPath.MediaDir}\')';
$oDb->doQuery($sql);
$msg[] = 'Change internal absolute Media links into SYSVAR placeholders'." $OK";
} catch(WbDatabaseException $e) {
$msg[] = ''.$oDb->get_error();
}
try {
$sql = 'UPDATE `'.$sTable.'` ';
$sql .= 'SET `content` = REPLACE(`content`, \'"'.$oReg->AppPath.'\', \'"{SYSVAR:AppPath}\')';
$oDb->doQuery($sql);
$msg[] = 'Change internal absolute links into SYSVAR placeholders'." $OK";
} catch(WbDatabaseException $e) {
$msg[] = ''.$oDb->get_error();
}
// only for $callingScript upgrade-script.php
if($globalStarted) {
if($bDebug) {
echo ''.implode('
',$msg).'
';
}
}
}
$msg[] = 'WYSIWYG upgrade successfull finished'." $OK";
if($globalStarted) {
echo "WYSIWYG upgrade successfull finished $OK
";
}
return ( ($globalStarted==true ) ? $globalStarted : $msg);
}
// ------------------------------------
$bDebugModus = ((isset($bDebugModus)) ? $bDebugModus : false);
if( is_array($msg = mod_wysiwyg_upgrade($bDebugModus)) ) {
echo ''.implode('
',$msg).'
';
}