Import any .sql[.gz] file, from a specifiable directory, rather than only the default adminer.sql[.gz], with Adminer.

import-from-dir.php

<?php
/**
 * Import SQL files from a directory
 *
 * @author joshcangit, https://github.com/joshcangit
 * @author Roy-Orbison, https://github.com/Roy-Orbison
 */

class AdminerImportFromDir {

	protected $dir;

	/**
	 * @param string $dir optional directory to read from, other than Adminer's current working dir.
	 */
	function __construct($dir = '') {
		$dir = (string) $dir;
		if ($dir != '') {
			$dir = rtrim($dir, DIRECTORY_SEPARATOR) . DIRECTORY_SEPARATOR;
		}
		$this->dir = $dir;
	}

	protected function _readFiles($gz = false) {
		$mapped = array();
		$glob = "$this->dir*.[Ss][Qq][Ll]";
		if ($gz) {
			$suffix = '.gz'; # lowercase only because of core
			$glob .= $suffix;
			$suffix_cut = -3;
		}
		if ($files = glob($glob)) {
			$from = strlen($this->dir);
			foreach ($files as $file) {
				if ($from) {
					$file = substr($file, $from); # do not expose server paths in output
				}
				if ($gz) {
					$mapped[substr($file, 0, $suffix_cut)] = $file;
				}
				else {
					$mapped[$file] = $file;
				}
			}
		}
		return $mapped;
	}

	function importServerPath() {
		static $posted = null;

		$files = $this->_readFiles();
		if (extension_loaded('zlib')) {
			$files += $this->_readFiles(true); # core prioritises files without .gz
		}
		if (count($files) > 1) {
			ksort($files);
		}

		if ($posted !== null || !isset($_POST['webfile'])) {
			# use existing translation strings
			echo "<fieldset><legend>" . Adminer\lang('From server') . "</legend><div>";
			echo Adminer\lang('Webserver file %s', '<select name="webfilename">' . Adminer\optionlist(array('' => Adminer\lang('Select')) + $files, $posted, true) . '</select>');
			echo ' <input type="submit" name="webfile" value="' . Adminer\lang('Run file') . '">';
			echo "</div></fieldset>\n";
			$posted = null;
			return false; # skip core UI
		}

		if (
			empty($_POST['webfilename'])
			|| !is_string($_POST['webfilename'])
			|| !array_key_exists($_POST['webfilename'], $files)
		) {
			$posted = '';
			return 'SELECTED_FILE_DOES_NOT_EXIST'; # can't return empty string because of core file_exists() check
		}

		$posted = $_POST['webfilename'];
		return $this->dir . $posted;
	}
}

Normal Adminer plugin usage applies, and it can be added to the plugins array to use the current working directory:

new AdminerImportFromDir,

or a specific path:

new AdminerImportFromDir('/path/to/sql-import-dir'),

The UI is like so:

Adminer 5 wrapped itself into a namespace and plugins now need to call Adminer's functions via this namespace.

Please update this Gist to this: https://gist.github.com/vrana/a775aebcf7be294959068336ddce8c4e

@vrana merged.

https://simple.tools/bulk-file-renamer : Bulk File Renamer is a tool that allows you to rename many files at once using consistent rules. Instead of manually renaming each file, you apply patterns such as prefixes, suffixes, numbering, or text replacement to all selected files locally.