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();
}
}
$sTable = TABLE_PREFIX.'mod_wysiwyg';
if($database->index_exists($sTable, 'PRIMARY')) {
$sql = 'ALTER TABLE `'.$database->DbName.'`.`'.$sTable.'` DROP PRIMARY KEY';
if(!$database->query($sql)) {
$msg[] = ''.$database->get_error().'';
}
}
if(!$database->index_add($sTable, '', 'section_id', 'PRIMARY')) {
$msg[] = ''.$database->get_error().'';
} else {
$msg[] = 'Create PRIMARY KEY ( `section_id` )';
}
// change internal absolute links into relative links
$sTable = TABLE_PREFIX.'mod_wysiwyg';
$sql = 'UPDATE `'.$sTable.'` ';
$sql .= 'SET `content` = REPLACE(`content`, \'"'.WB_URL.MEDIA_DIRECTORY.'\', \'"{SYSVAR:MEDIA_REL}\')';
if (!$database->query($sql)) {
$msg[] = ''.$database->get_error().'';
} else {
$msg[] = 'Change internal absolute links into relative links';
}
// only for $callingScript upgrade-script.php
if($globalStarted) {
if($bDebugModus) {
foreach($msg as $title) {
echo ''.$title.'
';
}
}
}
return $msg;
}
}
// ------------------------------------
$msg = mod_wysiwyg_upgrade();