query("ALTER TABLE `".mysql_escape($prefixTableName)."` CHANGE `info1` `info1` MEDIUMTEXT") or die("Error adding fields to uploads, the error was:\n\n". htmlencode(mysqli()->error));
array_push($message, 'You have successfully altered the info1 field text length!');
} elseif ($action === 'uploadsCreatedTime') {
if (isset($schema['createdTime'])) {
$schema['createdTime']['customColumnType'] = "datetime NOT NULL DEFAULT CURRENT_TIMESTAMP";
}
saveSchema('uploads', $schema);
array_push($message, 'You have successfully set the datetime default value to CURRENT_TIMESTAMP.');
} elseif ($action === 'combineInfoFields') {
$table_name = mysql_escape($_REQUEST['table_name']);
$rows_affected = 0;
mysql_do("UPDATE {$TABLE_PREFIX}uploads SET info1=CONCAT_WS(CHAR(10), info1, info2, info3, info4, info5) WHERE tableName='".$table_name."'") or die("Error combining info fields, the error was:\n\n". htmlencode(mysqli()->error));
$rows_affected += mysqli()->affected_rows;
mysql_do("UPDATE {$TABLE_PREFIX}uploads SET info2='', info3='', info4='', info5='' WHERE tableName='".$table_name."'") or die("Error combining info fields, the error was:\n\n". htmlencode(mysqli()->error));
$rows_affected += mysqli()->affected_rows;
if ($rows_affected === 0) {
array_push($message, 'Nothing was processed for table name '. $table_name.'');
} else {
array_push($message, 'You have successfully combined the content of the info2 to info5 fields into info1 for table name '.$table_name.'.');
}
}
}
} else {
$errors = t('Nothing to process.');
}
print json_encode(array(
'errors' => htmlentities($errors),
'message' => $message,
));
exit;
}