' . t('The database currently lists @x_filenames containing non-ASCII characters.', array('@x_filenames' => format_plural($count, '1 file name', '@count file names'))) . '
';
$description .= t('This count might be inaccurate, though, since some files may not need to be renamed. For example, off-site files will never be changed.') . '
' . t('Note: table shows only the first 10 entries.') . '
'; } $description .= '' . t('WARNING: if you have manually entered image or file paths in text fields (for example, text areas or WYSIWYG editors), renaming the files will break these references. Since there is currently no automated way to also fix referenced files in textual contents, it is a very good idea to backup the database and %files directory beforehand. Modules accessing files using their internal system ids are not affected.', array('%files' => file_directory_path())) . '
'; $description .= '' . t('This action cannot be undone.') . '
'; return confirm_form($form, $question, 'admin/config/media/file-system/settings', $description, t('Transliterate')); } /** * Form submit function; retroactively transliterates existing file names. * * @see transliteration_retroactive() */ function transliteration_retroactive_submit($form, &$form_state) { $count = 0; $errors = array(); $result = transliteration_file_query()->execute(); while ($file = $result->fetchObject()) { $wrapper = file_stream_wrapper_get_instance_by_uri($file->uri); if (!$wrapper) { // Missing implementation. $errors[] = file_uri_target($file->uri); continue; } if (!in_array('DrupalLocalStreamWrapper', class_parents($wrapper))) { // Skip non-local files. continue; } if (!file_exists($wrapper->realpath())) { // Missing file. $errors[] = file_uri_target($file->uri); continue; } // Sanitize file name. $filename = transliteration_clean_filename(basename($file->uri)); // Build destination URI. $destination = file_stream_wrapper_uri_normalize(drupal_dirname($file->uri) . '/' . $filename); $destination = file_destination($destination, FILE_EXISTS_RENAME); // Rename and update the file record accordingly. if ($wrapper->rename($file->uri, $destination)) { $file->uri = $destination; // Don't use file_save() as it modifies the timestamp. drupal_write_record('file_managed', $file, 'fid'); // Inform modules that the file has been updated. module_invoke_all('file_update', $file); $count++; } else { $errors[] = file_uri_target($file->uri); } } if ($errors) { $message = t('Not all file names could be converted. The following files could not be accessed and have been ignored:'); $message .= theme('item_list', array('items' => $errors)); drupal_set_message($message, 'error'); } else { drupal_set_message(t('@filenames have been successfully transliterated.', array('@filenames' => format_plural($count, '1 file name', '@count file names')))); } // Flush page cache. cache_clear_all(); } /** * Builds a query that returns all file names from the database containing non-ASCII characters. * * @return * SelectQuery */ function transliteration_file_query() { // Regular expressions are not supported by Drupal's database layer and // operators differ between manufacturers. switch (db_driver()) { case 'mysql': case 'mysqli': $operator = 'NOT REGEXP'; $regex = '/[a-z0-9_.-]+$'; break; case 'pgsql': $operator = '!~*'; $regex = '/[a-z0-9_.-]+$'; break; default: return FALSE; } return db_select('file_managed') ->fields('file_managed') ->condition('uri', $regex, $operator); }