Server IP : 85.214.239.14 / Your IP : 3.133.126.241 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/3/root/var/www/wordpress/phpMyAdmin/libraries/classes/ |
Upload File : |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * MySQL charset metadata and manipulations * * @package PhpMyAdmin */ declare(strict_types=1); namespace PhpMyAdmin; use PhpMyAdmin\Charsets\Charset; use PhpMyAdmin\Charsets\Collation; /** * Class used to manage MySQL charsets * * @package PhpMyAdmin */ class Charsets { /** * MySQL charsets map * * @var array */ public static $mysqlCharsetMap = [ 'big5' => 'big5', 'cp-866' => 'cp866', 'euc-jp' => 'ujis', 'euc-kr' => 'euckr', 'gb2312' => 'gb2312', 'gbk' => 'gbk', 'iso-8859-1' => 'latin1', 'iso-8859-2' => 'latin2', 'iso-8859-7' => 'greek', 'iso-8859-8' => 'hebrew', 'iso-8859-8-i' => 'hebrew', 'iso-8859-9' => 'latin5', 'iso-8859-13' => 'latin7', 'iso-8859-15' => 'latin1', 'koi8-r' => 'koi8r', 'shift_jis' => 'sjis', 'tis-620' => 'tis620', 'utf-8' => 'utf8', 'windows-1250' => 'cp1250', 'windows-1251' => 'cp1251', 'windows-1252' => 'latin1', 'windows-1256' => 'cp1256', 'windows-1257' => 'cp1257', ]; /** * The charset for the server * @var Charset|null */ private static $serverCharset = null; /** * @var array<string, Charset> */ private static $charsets = []; /** * @var array<string, array<string, Collation>> */ private static $collations = []; /** * Loads charset data from the server * * @param DatabaseInterface $dbi DatabaseInterface instance * @param boolean $disableIs Disable use of INFORMATION_SCHEMA * * @return void */ private static function loadCharsets(DatabaseInterface $dbi, bool $disableIs): void { /* Data already loaded */ if (count(self::$charsets) > 0) { return; } if ($disableIs) { $sql = 'SHOW CHARACTER SET'; } else { $sql = 'SELECT `CHARACTER_SET_NAME` AS `Charset`,' . ' `DEFAULT_COLLATE_NAME` AS `Default collation`,' . ' `DESCRIPTION` AS `Description`,' . ' `MAXLEN` AS `Maxlen`' . ' FROM `information_schema`.`CHARACTER_SETS`'; } $res = $dbi->query($sql); self::$charsets = []; while ($row = $dbi->fetchAssoc($res)) { self::$charsets[$row['Charset']] = Charset::fromServer($row); } $dbi->freeResult($res); ksort(self::$charsets, SORT_STRING); } /** * Loads collation data from the server * * @param DatabaseInterface $dbi DatabaseInterface instance * @param boolean $disableIs Disable use of INFORMATION_SCHEMA * * @return void */ private static function loadCollations(DatabaseInterface $dbi, bool $disableIs): void { /* Data already loaded */ if (count(self::$collations) > 0) { return; } if ($disableIs) { $sql = 'SHOW COLLATION'; } else { $sql = 'SELECT `COLLATION_NAME` AS `Collation`,' . ' `CHARACTER_SET_NAME` AS `Charset`,' . ' `ID` AS `Id`,' . ' `IS_DEFAULT` AS `Default`,' . ' `IS_COMPILED` AS `Compiled`,' . ' `SORTLEN` AS `Sortlen`' . ' FROM `information_schema`.`COLLATIONS`'; } $res = $dbi->query($sql); self::$collations = []; while ($row = $dbi->fetchAssoc($res)) { self::$collations[$row['Charset']][$row['Collation']] = Collation::fromServer($row); } $dbi->freeResult($res); foreach (array_keys(self::$collations) as $charset) { ksort(self::$collations[$charset], SORT_STRING); } } /** * Get current server charset * * @param DatabaseInterface $dbi DatabaseInterface instance * @param boolean $disableIs Disable use of INFORMATION_SCHEMA * * @return Charset */ public static function getServerCharset(DatabaseInterface $dbi, bool $disableIs): Charset { if (self::$serverCharset !== null) { return self::$serverCharset; } self::loadCharsets($dbi, $disableIs); $serverCharset = $dbi->getVariable('character_set_server'); if (! is_string($serverCharset)) {// MySQL 5.7.8 fallback, issue #15614 $serverCharset = $dbi->fetchValue("SELECT @@character_set_server;"); } self::$serverCharset = self::$charsets[$serverCharset]; return self::$serverCharset; } /** * Get all server charsets * * @param DatabaseInterface $dbi DatabaseInterface instance * @param boolean $disableIs Disable use of INFORMATION_SCHEMA * * @return array */ public static function getCharsets(DatabaseInterface $dbi, bool $disableIs): array { self::loadCharsets($dbi, $disableIs); return self::$charsets; } /** * Get all server collations * * @param DatabaseInterface $dbi DatabaseInterface instance * @param boolean $disableIs Disable use of INFORMATION_SCHEMA * * @return array */ public static function getCollations(DatabaseInterface $dbi, bool $disableIs): array { self::loadCollations($dbi, $disableIs); return self::$collations; } /** * @param DatabaseInterface $dbi DatabaseInterface instance * @param bool $disableIs Disable use of INFORMATION_SCHEMA * @param string|null $name Collation name * * @return Collation|null */ public static function findCollationByName(DatabaseInterface $dbi, bool $disableIs, ?string $name): ?Collation { $pieces = explode('_', (string) $name); if ($pieces === false || ! isset($pieces[0])) { return null; } $charset = $pieces[0]; $collations = self::getCollations($dbi, $disableIs); return $collations[$charset][$name] ?? null; } }