getTableEngine($sTable))) {
if(('myisam' != strtolower($sOldType))) {
if(!$database->query('ALTER TABLE `'.$sTable.'` Engine = \'MyISAM\' ')) {
$msg = $database->get_error();
}
}
} else {
$msg .= $database->get_error().'
';
}
// sanitize URLs inside mod_wysiwyg.content ----------------------------
$msg = '';
$sRelUrl = preg_replace('/^https?:\/\/[^\/]+(.*)/is', '\1', WB_URL);
$sDocumentRootUrl = str_replace($sRelUrl, '', WB_URL);
$sMediaUrl = WB_URL.MEDIA_DIRECTORY;
$sql = 'SELECT `content`, `section_id` FROM `'.TABLE_PREFIX.'mod_wysiwyg`';
if (($oInstances = $database->query($sql))) {
while (($aInstance = $oInstances->fetchRow(MYSQLI_ASSOC))) {
// add $sDocumentRootUrl to relative URLs
$aPatterns = array(
'/(<[^>]*?=\s*\")(\/+)([^\"]*?\"[^>]*?)/is',
'/(<[^>]*=\s*")('.preg_quote($sMediaUrl, '/').')([^">]*".*>)/siU'
);
$aReplacements = array(
'\1'.$sDocumentRootUrl.'/\3',
'$1{SYSVAR:MEDIA_REL}$3'
);
$aInstance['content'] = preg_replace($aPatterns, $aReplacements, $aInstance['content']);
$sql = 'UPDATE `'.TABLE_PREFIX.'mod_wysiwyg` '
. 'SET `content`=\''.$database->escapeString($aInstance['content']).'\' '
. 'WHERE `section_id`='.(int)$aInstance['section_id'];
if (!$database->query($sql)) {
$msg = $database->get_error();
break;
}
}
} else { $msg = $database->get_error(); }
// ---------------------------------------------------------------------
$sql = 'UPDATE `'.$sTable.'` SET '
. '`content` = REPLACE(`content`, \'"'.WB_URL.MEDIA_DIRECTORY.'\', \'"{SYSVAR:MEDIA_REL}\')';
if (!$database->query($sql)) {
$msg .= $database->get_error().'
';
}
// ------------------------------------