| Server IP : 3.96.16.70 / Your IP : 216.73.216.15 Web Server : Apache System : Linux ip-172-31-26-103.ca-central-1.compute.internal 6.1.163-186.299.amzn2023.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Feb 24 16:35:42 UTC 2026 x86_64 User : ec2-user ( 1000) PHP Version : 8.4.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/prod1.wondermakr.com/phpmyadmin/test/classes/Config/ |
Upload File : |
<?php
declare(strict_types=1);
namespace PhpMyAdmin\Tests\Config;
use PhpMyAdmin\Config\Settings;
use PhpMyAdmin\Config\Settings\Console;
use PhpMyAdmin\Config\Settings\Debug;
use PhpMyAdmin\Config\Settings\Export;
use PhpMyAdmin\Config\Settings\Import;
use PhpMyAdmin\Config\Settings\Schema;
use PhpMyAdmin\Config\Settings\Server;
use PhpMyAdmin\Config\Settings\SqlQueryBox;
use PhpMyAdmin\Config\Settings\Transformations;
use PHPUnit\Framework\TestCase;
use function array_keys;
use function array_merge;
use const DIRECTORY_SEPARATOR;
use const ROOT_PATH;
// phpcs:disable Squiz.NamingConventions.ValidVariableName.MemberNotCamelCaps, Generic.Files.LineLength.TooLong
/**
* @covers \PhpMyAdmin\Config\Settings
* @covers \PhpMyAdmin\Config\Settings\Console
* @covers \PhpMyAdmin\Config\Settings\Debug
* @covers \PhpMyAdmin\Config\Settings\Export
* @covers \PhpMyAdmin\Config\Settings\Import
* @covers \PhpMyAdmin\Config\Settings\Schema
* @covers \PhpMyAdmin\Config\Settings\Server
* @covers \PhpMyAdmin\Config\Settings\SqlQueryBox
* @covers \PhpMyAdmin\Config\Settings\Transformations
*/
class SettingsTest extends TestCase
{
/** @var array<string, array|bool|int|string|null> */
private $defaultValues = [
'PmaAbsoluteUri' => '',
'AuthLog' => 'auto',
'AuthLogSuccess' => false,
'PmaNoRelation_DisableWarning' => false,
'SuhosinDisableWarning' => false,
'LoginCookieValidityDisableWarning' => false,
'ReservedWordDisableWarning' => false,
'TranslationWarningThreshold' => 80,
'AllowThirdPartyFraming' => false,
'blowfish_secret' => '',
'Servers' => [],
'ServerDefault' => 1,
'VersionCheck' => true,
'ProxyUrl' => '',
'ProxyUser' => '',
'ProxyPass' => '',
'MaxDbList' => 100,
'MaxTableList' => 250,
'ShowHint' => true,
'MaxCharactersInDisplayedSQL' => 1000,
'OBGzip' => 'auto',
'PersistentConnections' => false,
'ExecTimeLimit' => 300,
'SessionSavePath' => '',
'MysqlSslWarningSafeHosts' => ['127.0.0.1', 'localhost'],
'MemoryLimit' => '-1',
'SkipLockedTables' => false,
'ShowSQL' => true,
'RetainQueryBox' => false,
'CodemirrorEnable' => true,
'LintEnable' => true,
'AllowUserDropDatabase' => false,
'Confirm' => true,
'CookieSameSite' => 'Strict',
'LoginCookieRecall' => true,
'LoginCookieValidity' => 1440,
'LoginCookieStore' => 0,
'LoginCookieDeleteAll' => true,
'UseDbSearch' => true,
'IgnoreMultiSubmitErrors' => false,
'URLQueryEncryption' => false,
'URLQueryEncryptionSecretKey' => '',
'AllowArbitraryServer' => false,
'ArbitraryServerRegexp' => '',
'CaptchaMethod' => 'invisible',
'CaptchaApi' => 'https://www.google.com/recaptcha/api.js',
'CaptchaCsp' => 'https://apis.google.com https://www.google.com/recaptcha/'
. ' https://www.gstatic.com/recaptcha/ https://ssl.gstatic.com/',
'CaptchaRequestParam' => 'g-recaptcha',
'CaptchaResponseParam' => 'g-recaptcha-response',
'CaptchaLoginPublicKey' => '',
'CaptchaLoginPrivateKey' => '',
'CaptchaSiteVerifyURL' => '',
'enable_drag_drop_import' => true,
'ShowDatabasesNavigationAsTree' => true,
'FirstLevelNavigationItems' => 100,
'MaxNavigationItems' => 50,
'NavigationTreeEnableGrouping' => true,
'NavigationTreeDbSeparator' => '_',
'NavigationTreeTableSeparator' => '__',
'NavigationTreeTableLevel' => 1,
'NavigationLinkWithMainPanel' => true,
'NavigationDisplayLogo' => true,
'NavigationLogoLink' => 'index.php',
'NavigationLogoLinkWindow' => 'main',
'NumRecentTables' => 10,
'NumFavoriteTables' => 10,
'NavigationTreeDisplayItemFilterMinimum' => 30,
'NavigationDisplayServers' => true,
'DisplayServersList' => false,
'NavigationTreeDisplayDbFilterMinimum' => 30,
'NavigationTreeDefaultTabTable' => 'structure',
'NavigationTreeDefaultTabTable2' => '',
'NavigationTreeEnableExpansion' => true,
'NavigationTreeShowTables' => true,
'NavigationTreeShowViews' => true,
'NavigationTreeShowFunctions' => true,
'NavigationTreeShowProcedures' => true,
'NavigationTreeShowEvents' => true,
'NavigationWidth' => 240,
'NavigationTreeAutoexpandSingleDb' => true,
'ShowStats' => true,
'ShowPhpInfo' => false,
'ShowServerInfo' => true,
'ShowChgPassword' => true,
'ShowCreateDb' => true,
'ShowDbStructureCharset' => false,
'ShowDbStructureComment' => false,
'ShowDbStructureCreation' => false,
'ShowDbStructureLastUpdate' => false,
'ShowDbStructureLastCheck' => false,
'HideStructureActions' => true,
'ShowColumnComments' => true,
'TableNavigationLinksMode' => 'icons',
'ShowAll' => false,
'MaxRows' => 25,
'Order' => 'SMART',
'SaveCellsAtOnce' => false,
'GridEditing' => 'double-click',
'RelationalDisplay' => 'K',
'ProtectBinary' => 'blob',
'ShowFunctionFields' => true,
'ShowFieldTypesInDataEditView' => true,
'CharEditing' => 'input',
'MinSizeForInputField' => 4,
'MaxSizeForInputField' => 60,
'InsertRows' => 2,
'ForeignKeyDropdownOrder' => ['content-id', 'id-content'],
'ForeignKeyMaxLimit' => 100,
'DefaultForeignKeyChecks' => 'default',
'ZipDump' => true,
'GZipDump' => true,
'BZipDump' => true,
'CompressOnFly' => true,
'TabsMode' => 'both',
'ActionLinksMode' => 'both',
'PropertiesNumColumns' => 1,
'DefaultTabServer' => 'welcome',
'DefaultTabDatabase' => 'structure',
'DefaultTabTable' => 'browse',
'RowActionType' => 'both',
'Export' => null,
'Import' => null,
'Schema' => null,
'PDFPageSizes' => ['A3', 'A4', 'A5', 'letter', 'legal'],
'PDFDefaultPageSize' => 'A4',
'DefaultLang' => 'en',
'DefaultConnectionCollation' => 'utf8mb4_unicode_ci',
'Lang' => '',
'FilterLanguages' => '',
'RecodingEngine' => 'auto',
'IconvExtraParams' => '//TRANSLIT',
'AvailableCharsets' => [
'iso-8859-1',
'iso-8859-2',
'iso-8859-3',
'iso-8859-4',
'iso-8859-5',
'iso-8859-6',
'iso-8859-7',
'iso-8859-8',
'iso-8859-9',
'iso-8859-10',
'iso-8859-11',
'iso-8859-12',
'iso-8859-13',
'iso-8859-14',
'iso-8859-15',
'windows-1250',
'windows-1251',
'windows-1252',
'windows-1256',
'windows-1257',
'koi8-r',
'big5',
'gb2312',
'utf-16',
'utf-8',
'utf-7',
'x-user-defined',
'euc-jp',
'ks_c_5601-1987',
'tis-620',
'SHIFT_JIS',
'SJIS',
'SJIS-win',
],
'NavigationTreePointerEnable' => true,
'BrowsePointerEnable' => true,
'BrowseMarkerEnable' => true,
'TextareaCols' => 40,
'TextareaRows' => 15,
'LongtextDoubleTextarea' => true,
'TextareaAutoSelect' => false,
'CharTextareaCols' => 40,
'CharTextareaRows' => 7,
'LimitChars' => 50,
'RowActionLinks' => 'left',
'RowActionLinksWithoutUnique' => false,
'TablePrimaryKeyOrder' => 'NONE',
'RememberSorting' => true,
'ShowBrowseComments' => true,
'ShowPropertyComments' => true,
'RepeatCells' => 100,
'QueryHistoryDB' => false,
'QueryHistoryMax' => 25,
'BrowseMIME' => true,
'MaxExactCount' => 50000,
'MaxExactCountViews' => 0,
'NaturalOrder' => true,
'InitialSlidersState' => 'closed',
'UserprefsDisallow' => [],
'UserprefsDeveloperTab' => false,
'TitleTable' => '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@',
'TitleDatabase' => '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@',
'TitleServer' => '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@',
'TitleDefault' => '@HTTP_HOST@ | @PHPMYADMIN@',
'ThemeManager' => true,
'ThemeDefault' => 'pmahomme',
'ThemePerServer' => false,
'DefaultQueryTable' => 'SELECT * FROM @TABLE@ WHERE 1',
'DefaultQueryDatabase' => '',
'SQLQuery' => null,
'EnableAutocompleteForTablesAndColumns' => true,
'UploadDir' => '',
'SaveDir' => '',
'TempDir' => ROOT_PATH . 'tmp' . DIRECTORY_SEPARATOR,
'GD2Available' => 'auto',
'TrustedProxies' => [],
'CheckConfigurationPermissions' => true,
'LinkLengthLimit' => 1000,
'CSPAllow' => '',
'DisableMultiTableMaintenance' => false,
'SendErrorReports' => 'ask',
'ConsoleEnterExecutes' => false,
'ZeroConf' => true,
'DBG' => null,
'environment' => 'production',
'DefaultFunctions' => [
'FUNC_CHAR' => '',
'FUNC_DATE' => '',
'FUNC_NUMBER' => '',
'FUNC_SPATIAL' => 'GeomFromText',
'FUNC_UUID' => 'UUID',
'first_timestamp' => 'NOW',
],
'maxRowPlotLimit' => 500,
'ShowGitRevision' => true,
'MysqlMinVersion' => ['internal' => 50500, 'human' => '5.5.0'],
'DisableShortcutKeys' => false,
'Console' => null,
'DefaultTransformations' => null,
'FirstDayOfCalendar' => 0,
];
/**
* @psalm-suppress UnusedVariable, PossiblyNullArrayAssignment, PossiblyInvalidArrayAssignment
*/
public function testConfigDefaultFile(): void
{
$cfg = [];
include ROOT_PATH . 'libraries/config.default.php';
$settings = new Settings($cfg);
$config = $settings->toArray();
$config['Servers'][1]['SignonCookieParams'] = [];
self::assertEquals($config, $cfg);
}
public function testToArray(): void
{
$settings = new Settings([]);
$config = $settings->toArray();
self::assertIsArray($config['Console']);
self::assertIsArray($config['DBG']);
self::assertIsArray($config['Export']);
self::assertIsArray($config['Import']);
self::assertIsArray($config['Schema']);
self::assertIsArray($config['SQLQuery']);
self::assertIsArray($config['DefaultTransformations']);
self::assertIsArray($config['Servers']);
self::assertIsArray($config['Servers'][1]);
}
/**
* @param mixed[][] $values
* @psalm-param (array{0: string, 1: mixed, 2: mixed})[] $values
*
* @dataProvider providerForTestConstructor
*/
public function testConstructor(array $values): void
{
$actualValues = [];
$expectedValues = [];
/** @psalm-suppress MixedAssignment */
foreach ($values as $value) {
$actualValues[$value[0]] = $value[1];
$expectedValues[$value[0]] = $value[2];
}
$expected = array_merge($this->defaultValues, $expectedValues);
$settings = new Settings($actualValues);
foreach (array_keys($expectedValues) as $key) {
if ($key === 'Servers') {
self::assertContainsOnlyInstancesOf(Server::class, $settings->Servers);
self::assertIsArray($expected[$key]);
self::assertSame(array_keys($expected[$key]), array_keys($settings->Servers));
continue;
}
if ($key === 'Console') {
self::assertInstanceOf(Console::class, $settings->Console);
continue;
}
if ($key === 'DBG') {
self::assertInstanceOf(Debug::class, $settings->DBG);
continue;
}
if ($key === 'Export') {
self::assertInstanceOf(Export::class, $settings->Export);
continue;
}
if ($key === 'Import') {
self::assertInstanceOf(Import::class, $settings->Import);
continue;
}
if ($key === 'Schema') {
self::assertInstanceOf(Schema::class, $settings->Schema);
continue;
}
if ($key === 'SQLQuery') {
self::assertInstanceOf(SqlQueryBox::class, $settings->SQLQuery);
continue;
}
if ($key === 'DefaultTransformations') {
self::assertInstanceOf(Transformations::class, $settings->DefaultTransformations);
continue;
}
self::assertSame($expected[$key], $settings->$key);
}
}
/**
* [setting key, actual value, expected value]
*
* @return mixed[][][][]
* @psalm-return (array{0: string, 1: mixed, 2: mixed})[][][]
*/
public static function providerForTestConstructor(): array
{
return [
'null values' => [
[
['PmaAbsoluteUri', null, ''],
['AuthLog', null, 'auto'],
['AuthLogSuccess', null, false],
['PmaNoRelation_DisableWarning', null, false],
['SuhosinDisableWarning', null, false],
['LoginCookieValidityDisableWarning', null, false],
['ReservedWordDisableWarning', null, false],
['TranslationWarningThreshold', null, 80],
['AllowThirdPartyFraming', null, false],
['blowfish_secret', null, ''],
['Servers', null, [1 => null]],
['ServerDefault', null, 1],
['VersionCheck', null, true],
['ProxyUrl', null, ''],
['ProxyUser', null, ''],
['ProxyPass', null, ''],
['MaxDbList', null, 100],
['MaxTableList', null, 250],
['ShowHint', null, true],
['MaxCharactersInDisplayedSQL', null, 1000],
['OBGzip', null, 'auto'],
['PersistentConnections', null, false],
['ExecTimeLimit', null, 300],
['SessionSavePath', null, ''],
['MysqlSslWarningSafeHosts', null, ['127.0.0.1', 'localhost']],
['MemoryLimit', null, '-1'],
['SkipLockedTables', null, false],
['ShowSQL', null, true],
['RetainQueryBox', null, false],
['CodemirrorEnable', null, true],
['LintEnable', null, true],
['AllowUserDropDatabase', null, false],
['Confirm', null, true],
['CookieSameSite', null, 'Strict'],
['LoginCookieRecall', null, true],
['LoginCookieValidity', null, 1440],
['LoginCookieStore', null, 0],
['LoginCookieDeleteAll', null, true],
['UseDbSearch', null, true],
['IgnoreMultiSubmitErrors', null, false],
['URLQueryEncryption', null, false],
['URLQueryEncryptionSecretKey', null, ''],
['AllowArbitraryServer', null, false],
['ArbitraryServerRegexp', null, ''],
['CaptchaMethod', null, 'invisible'],
['CaptchaApi', null, 'https://www.google.com/recaptcha/api.js'],
['CaptchaCsp', null, 'https://apis.google.com https://www.google.com/recaptcha/ https://www.gstatic.com/recaptcha/ https://ssl.gstatic.com/'],
['CaptchaRequestParam', null, 'g-recaptcha'],
['CaptchaResponseParam', null, 'g-recaptcha-response'],
['CaptchaLoginPublicKey', null, ''],
['CaptchaLoginPrivateKey', null, ''],
['CaptchaSiteVerifyURL', null, ''],
['enable_drag_drop_import', null, true],
['ShowDatabasesNavigationAsTree', null, true],
['FirstLevelNavigationItems', null, 100],
['MaxNavigationItems', null, 50],
['NavigationTreeEnableGrouping', null, true],
['NavigationTreeDbSeparator', null, '_'],
['NavigationTreeTableSeparator', null, '__'],
['NavigationTreeTableLevel', null, 1],
['NavigationLinkWithMainPanel', null, true],
['NavigationDisplayLogo', null, true],
['NavigationLogoLink', null, 'index.php'],
['NavigationLogoLinkWindow', null, 'main'],
['NumRecentTables', null, 10],
['NumFavoriteTables', null, 10],
['NavigationTreeDisplayItemFilterMinimum', null, 30],
['NavigationDisplayServers', null, true],
['DisplayServersList', null, false],
['NavigationTreeDisplayDbFilterMinimum', null, 30],
['NavigationTreeDefaultTabTable', null, 'structure'],
['NavigationTreeDefaultTabTable2', null, ''],
['NavigationTreeEnableExpansion', null, true],
['NavigationTreeShowTables', null, true],
['NavigationTreeShowViews', null, true],
['NavigationTreeShowFunctions', null, true],
['NavigationTreeShowProcedures', null, true],
['NavigationTreeShowEvents', null, true],
['NavigationWidth', null, 240],
['NavigationTreeAutoexpandSingleDb', null, true],
['ShowStats', null, true],
['ShowPhpInfo', null, false],
['ShowServerInfo', null, true],
['ShowChgPassword', null, true],
['ShowCreateDb', null, true],
['ShowDbStructureCharset', null, false],
['ShowDbStructureComment', null, false],
['ShowDbStructureCreation', null, false],
['ShowDbStructureLastUpdate', null, false],
['ShowDbStructureLastCheck', null, false],
['HideStructureActions', null, true],
['ShowColumnComments', null, true],
['TableNavigationLinksMode', null, 'icons'],
['ShowAll', null, false],
['MaxRows', null, 25],
['Order', null, 'SMART'],
['SaveCellsAtOnce', null, false],
['GridEditing', null, 'double-click'],
['RelationalDisplay', null, 'K'],
['ProtectBinary', null, 'blob'],
['ShowFunctionFields', null, true],
['ShowFieldTypesInDataEditView', null, true],
['CharEditing', null, 'input'],
['MinSizeForInputField', null, 4],
['MaxSizeForInputField', null, 60],
['InsertRows', null, 2],
['ForeignKeyDropdownOrder', null, ['content-id', 'id-content']],
['ForeignKeyMaxLimit', null, 100],
['DefaultForeignKeyChecks', null, 'default'],
['ZipDump', null, true],
['GZipDump', null, true],
['BZipDump', null, true],
['CompressOnFly', null, true],
['TabsMode', null, 'both'],
['ActionLinksMode', null, 'both'],
['PropertiesNumColumns', null, 1],
['DefaultTabServer', null, 'welcome'],
['DefaultTabDatabase', null, 'structure'],
['DefaultTabTable', null, 'browse'],
['RowActionType', null, 'both'],
['Export', null, null],
['Import', null, null],
['Schema', null, null],
['PDFPageSizes', null, ['A3', 'A4', 'A5', 'letter', 'legal']],
['PDFDefaultPageSize', null, 'A4'],
['DefaultLang', null, 'en'],
['DefaultConnectionCollation', null, 'utf8mb4_unicode_ci'],
['Lang', null, ''],
['FilterLanguages', null, ''],
['RecodingEngine', null, 'auto'],
['IconvExtraParams', null, '//TRANSLIT'],
['AvailableCharsets', null, ['iso-8859-1', 'iso-8859-2', 'iso-8859-3', 'iso-8859-4', 'iso-8859-5', 'iso-8859-6', 'iso-8859-7', 'iso-8859-8', 'iso-8859-9', 'iso-8859-10', 'iso-8859-11', 'iso-8859-12', 'iso-8859-13', 'iso-8859-14', 'iso-8859-15', 'windows-1250', 'windows-1251', 'windows-1252', 'windows-1256', 'windows-1257', 'koi8-r', 'big5', 'gb2312', 'utf-16', 'utf-8', 'utf-7', 'x-user-defined', 'euc-jp', 'ks_c_5601-1987', 'tis-620', 'SHIFT_JIS', 'SJIS', 'SJIS-win']],
['NavigationTreePointerEnable', null, true],
['BrowsePointerEnable', null, true],
['BrowseMarkerEnable', null, true],
['TextareaCols', null, 40],
['TextareaRows', null, 15],
['LongtextDoubleTextarea', null, true],
['TextareaAutoSelect', null, false],
['CharTextareaCols', null, 40],
['CharTextareaRows', null, 7],
['LimitChars', null, 50],
['RowActionLinks', null, 'left'],
['RowActionLinksWithoutUnique', null, false],
['TablePrimaryKeyOrder', null, 'NONE'],
['RememberSorting', null, true],
['ShowBrowseComments', null, true],
['ShowPropertyComments', null, true],
['RepeatCells', null, 100],
['QueryHistoryDB', null, false],
['QueryHistoryMax', null, 25],
['BrowseMIME', null, true],
['MaxExactCount', null, 50000],
['MaxExactCountViews', null, 0],
['NaturalOrder', null, true],
['InitialSlidersState', null, 'closed'],
['UserprefsDisallow', null, []],
['UserprefsDeveloperTab', null, false],
['TitleTable', null, '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@'],
['TitleDatabase', null, '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@'],
['TitleServer', null, '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@'],
['TitleDefault', null, '@HTTP_HOST@ | @PHPMYADMIN@'],
['ThemeManager', null, true],
['ThemeDefault', null, 'pmahomme'],
['ThemePerServer', null, false],
['DefaultQueryTable', null, 'SELECT * FROM @TABLE@ WHERE 1'],
['DefaultQueryDatabase', null, ''],
['SQLQuery', null, null],
['EnableAutocompleteForTablesAndColumns', null, true],
['UploadDir', null, ''],
['SaveDir', null, ''],
['TempDir', null, ROOT_PATH . 'tmp' . DIRECTORY_SEPARATOR],
['GD2Available', null, 'auto'],
['TrustedProxies', null, []],
['CheckConfigurationPermissions', null, true],
['LinkLengthLimit', null, 1000],
['CSPAllow', null, ''],
['DisableMultiTableMaintenance', null, false],
['SendErrorReports', null, 'ask'],
['ConsoleEnterExecutes', null, false],
['ZeroConf', null, true],
['DBG', null, null],
['environment', null, 'production'],
['DefaultFunctions', null, ['FUNC_CHAR' => '', 'FUNC_DATE' => '', 'FUNC_NUMBER' => '', 'FUNC_SPATIAL' => 'GeomFromText', 'FUNC_UUID' => 'UUID', 'first_timestamp' => 'NOW']],
['maxRowPlotLimit', null, 500],
['ShowGitRevision', null, true],
['MysqlMinVersion', null, ['internal' => 50500, 'human' => '5.5.0']],
['DisableShortcutKeys', null, false],
['Console', null, null],
['DefaultTransformations', null, null],
['FirstDayOfCalendar', null, 0],
],
],
'valid values' => [
[
['PmaAbsoluteUri', 'https://www.phpmyadmin.net/', 'https://www.phpmyadmin.net/'],
['AuthLog', '/path/to/file', '/path/to/file'],
['AuthLogSuccess', true, true],
['PmaNoRelation_DisableWarning', true, true],
['SuhosinDisableWarning', true, true],
['LoginCookieValidityDisableWarning', true, true],
['ReservedWordDisableWarning', true, true],
['TranslationWarningThreshold', 100, 100],
['AllowThirdPartyFraming', 'sameorigin', 'sameorigin'],
['blowfish_secret', 'blowfish_secret', 'blowfish_secret'],
['Servers', [1 => [], 2 => []], [1 => null, 2 => null]],
['ServerDefault', 0, 0],
['VersionCheck', false, false],
['ProxyUrl', 'test', 'test'],
['ProxyUser', 'test', 'test'],
['ProxyPass', 'test', 'test'],
['MaxDbList', 1, 1],
['MaxTableList', 1, 1],
['ShowHint', false, false],
['MaxCharactersInDisplayedSQL', 1, 1],
['OBGzip', true, true],
['PersistentConnections', true, true],
['ExecTimeLimit', 0, 0],
['SessionSavePath', 'test', 'test'],
['MysqlSslWarningSafeHosts', ['test1', 'test2'], ['test1', 'test2']],
['MemoryLimit', '16M', '16M'],
['SkipLockedTables', true, true],
['ShowSQL', false, false],
['RetainQueryBox', true, true],
['CodemirrorEnable', false, false],
['LintEnable', false, false],
['AllowUserDropDatabase', true, true],
['Confirm', false, false],
['CookieSameSite', 'Lax', 'Lax'],
['LoginCookieRecall', false, false],
['LoginCookieValidity', 1, 1],
['LoginCookieStore', 0, 0],
['LoginCookieDeleteAll', false, false],
['UseDbSearch', false, false],
['IgnoreMultiSubmitErrors', true, true],
['URLQueryEncryption', true, true],
['URLQueryEncryptionSecretKey', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'],
['AllowArbitraryServer', true, true],
['ArbitraryServerRegexp', 'test', 'test'],
['CaptchaMethod', 'checkbox', 'checkbox'],
['CaptchaApi', 'test', 'test'],
['CaptchaCsp', 'test', 'test'],
['CaptchaRequestParam', 'test', 'test'],
['CaptchaResponseParam', 'test', 'test'],
['CaptchaLoginPublicKey', 'test', 'test'],
['CaptchaLoginPrivateKey', 'test', 'test'],
['CaptchaSiteVerifyURL', 'test', 'test'],
['enable_drag_drop_import', false, false],
['ShowDatabasesNavigationAsTree', false, false],
['FirstLevelNavigationItems', 1, 1],
['MaxNavigationItems', 1, 1],
['NavigationTreeEnableGrouping', false, false],
['NavigationTreeDbSeparator', 'test', 'test'],
['NavigationTreeTableSeparator', 'test', 'test'],
['NavigationTreeTableLevel', 1, 1],
['NavigationLinkWithMainPanel', false, false],
['NavigationDisplayLogo', false, false],
['NavigationLogoLink', 'test', 'test'],
['NavigationLogoLinkWindow', 'new', 'new'],
['NumRecentTables', 0, 0],
['NumFavoriteTables', 0, 0],
['NavigationTreeDisplayItemFilterMinimum', 1, 1],
['NavigationDisplayServers', false, false],
['DisplayServersList', true, true],
['NavigationTreeDisplayDbFilterMinimum', 1, 1],
['NavigationTreeDefaultTabTable', 'browse', 'browse'],
['NavigationTreeDefaultTabTable2', 'browse', 'browse'],
['NavigationTreeEnableExpansion', false, false],
['NavigationTreeShowTables', false, false],
['NavigationTreeShowViews', false, false],
['NavigationTreeShowFunctions', false, false],
['NavigationTreeShowProcedures', false, false],
['NavigationTreeShowEvents', false, false],
['NavigationWidth', 0, 0],
['NavigationTreeAutoexpandSingleDb', false, false],
['ShowStats', false, false],
['ShowPhpInfo', true, true],
['ShowServerInfo', false, false],
['ShowChgPassword', false, false],
['ShowCreateDb', false, false],
['ShowDbStructureCharset', true, true],
['ShowDbStructureComment', true, true],
['ShowDbStructureCreation', true, true],
['ShowDbStructureLastUpdate', true, true],
['ShowDbStructureLastCheck', true, true],
['HideStructureActions', false, false],
['ShowColumnComments', false, false],
['TableNavigationLinksMode', 'text', 'text'],
['ShowAll', true, true],
['MaxRows', 1, 1],
['Order', 'ASC', 'ASC'],
['SaveCellsAtOnce', true, true],
['GridEditing', 'click', 'click'],
['RelationalDisplay', 'D', 'D'],
['ProtectBinary', 'noblob', 'noblob'],
['ShowFunctionFields', false, false],
['ShowFieldTypesInDataEditView', false, false],
['CharEditing', 'textarea', 'textarea'],
['MinSizeForInputField', 0, 0],
['MaxSizeForInputField', 1, 1],
['InsertRows', 1, 1],
['ForeignKeyDropdownOrder', ['id-content', 'content-id'], ['id-content', 'content-id']],
['ForeignKeyMaxLimit', 1, 1],
['DefaultForeignKeyChecks', 'enable', 'enable'],
['ZipDump', false, false],
['GZipDump', false, false],
['BZipDump', false, false],
['CompressOnFly', false, false],
['TabsMode', 'icons', 'icons'],
['ActionLinksMode', 'icons', 'icons'],
['PropertiesNumColumns', 1, 1],
['DefaultTabServer', 'privileges', 'privileges'],
['DefaultTabDatabase', 'operations', 'operations'],
['DefaultTabTable', 'structure', 'structure'],
['RowActionType', 'icons', 'icons'],
['Export', [], null],
['Import', [], null],
['Schema', [], null],
['PDFPageSizes', ['test1', 'test2'], ['test1', 'test2']],
['PDFDefaultPageSize', 'test1', 'test1'],
['DefaultLang', 'pt_br', 'pt_br'],
['DefaultConnectionCollation', 'utf8_unicode_ci', 'utf8_unicode_ci'],
['Lang', 'pt_br', 'pt_br'],
['FilterLanguages', '^(pt_br|en)', '^(pt_br|en)'],
['RecodingEngine', 'none', 'none'],
['IconvExtraParams', '//IGNORE', '//IGNORE'],
['AvailableCharsets', ['utf-8', 'iso-8859-1'], ['utf-8', 'iso-8859-1']],
['NavigationTreePointerEnable', false, false],
['BrowsePointerEnable', false, false],
['BrowseMarkerEnable', false, false],
['TextareaCols', 1, 1],
['TextareaRows', 1, 1],
['LongtextDoubleTextarea', false, false],
['TextareaAutoSelect', true, true],
['CharTextareaCols', 1, 1],
['CharTextareaRows', 1, 1],
['LimitChars', 1, 1],
['RowActionLinks', 'none', 'none'],
['RowActionLinksWithoutUnique', true, true],
['TablePrimaryKeyOrder', 'DESC', 'DESC'],
['RememberSorting', false, false],
['ShowBrowseComments', false, false],
['ShowPropertyComments', false, false],
['RepeatCells', 0, 0],
['QueryHistoryDB', true, true],
['QueryHistoryMax', 1, 1],
['BrowseMIME', false, false],
['MaxExactCount', 1, 1],
['MaxExactCountViews', 0, 0],
['NaturalOrder', false, false],
['InitialSlidersState', 'open', 'open'],
['UserprefsDisallow', ['DisableMultiTableMaintenance', 'Export/lock_tables'], ['DisableMultiTableMaintenance', 'Export/lock_tables']],
['UserprefsDeveloperTab', true, true],
['TitleTable', '@PHPMYADMIN@', '@PHPMYADMIN@'],
['TitleDatabase', '@PHPMYADMIN@', '@PHPMYADMIN@'],
['TitleServer', '@PHPMYADMIN@', '@PHPMYADMIN@'],
['TitleDefault', '@PHPMYADMIN@', '@PHPMYADMIN@'],
['ThemeManager', false, false],
['ThemeDefault', 'test', 'test'],
['ThemePerServer', true, true],
['DefaultQueryTable', 'test', 'test'],
['DefaultQueryDatabase', 'test', 'test'],
['SQLQuery', [], null],
['EnableAutocompleteForTablesAndColumns', false, false],
['UploadDir', 'test', 'test'],
['SaveDir', 'test', 'test'],
['TempDir', 'test', 'test'],
['GD2Available', 'yes', 'yes'],
['TrustedProxies', ['1.2.3.4' => 'HTTP_X_FORWARDED_FOR', 'key' => 'value'], ['1.2.3.4' => 'HTTP_X_FORWARDED_FOR', 'key' => 'value']],
['CheckConfigurationPermissions', false, false],
['LinkLengthLimit', 1, 1],
['CSPAllow', 'phpmyadmin.net', 'phpmyadmin.net'],
['DisableMultiTableMaintenance', true, true],
['SendErrorReports', 'never', 'never'],
['ConsoleEnterExecutes', true, true],
['ZeroConf', false, false],
['DBG', [], null],
['environment', 'development', 'development'],
['DefaultFunctions', ['key' => 'value', 'key2' => 'value2'], ['key' => 'value', 'key2' => 'value2']],
['maxRowPlotLimit', 1, 1],
['ShowGitRevision', false, false],
['MysqlMinVersion', ['internal' => 80026, 'human' => '8.0.26'], ['internal' => 80026, 'human' => '8.0.26']],
['DisableShortcutKeys', true, true],
['Console', [], null],
['DefaultTransformations', [], null],
['FirstDayOfCalendar', 7, 7],
],
],
'valid values 2' => [
[
['CookieSameSite', 'None', 'None'],
['CaptchaMethod', 'invisible', 'invisible'],
['NavigationTreeTableSeparator', false, false],
['NavigationLogoLinkWindow', 'main', 'main'],
['NavigationTreeDefaultTabTable', 'insert', 'insert'],
['NavigationTreeDefaultTabTable2', 'insert', 'insert'],
['TableNavigationLinksMode', 'both', 'both'],
['Order', 'DESC', 'DESC'],
['GridEditing', 'disabled', 'disabled'],
['RelationalDisplay', 'K', 'K'],
['ProtectBinary', 'all', 'all'],
['CharEditing', 'input', 'input'],
['ForeignKeyDropdownOrder', ['content-id', 'id-content'], ['content-id', 'id-content']],
['DefaultForeignKeyChecks', 'disable', 'disable'],
['TabsMode', 'text', 'text'],
['ActionLinksMode', 'text', 'text'],
['DefaultTabServer', 'welcome', 'welcome'],
['DefaultTabDatabase', 'structure', 'structure'],
['DefaultTabTable', 'browse', 'browse'],
['RowActionType', 'text', 'text'],
['RecodingEngine', 'auto', 'auto'],
['RowActionLinks', 'left', 'left'],
['TablePrimaryKeyOrder', 'NONE', 'NONE'],
['InitialSlidersState', 'closed', 'closed'],
['GD2Available', 'auto', 'auto'],
['TrustedProxies', [], []],
['SendErrorReports', 'ask', 'ask'],
['environment', 'production', 'production'],
['DefaultFunctions', [], []],
['MysqlMinVersion', [], ['internal' => 50500, 'human' => '5.5.0']],
['FirstDayOfCalendar', 0, 0],
],
],
'valid values 3' => [
[
['CookieSameSite', 'Strict', 'Strict'],
['NavigationTreeTableSeparator', [1234], ['1234']],
['NavigationTreeDefaultTabTable', 'structure', 'structure'],
['NavigationTreeDefaultTabTable2', 'structure', 'structure'],
['TableNavigationLinksMode', 'icons', 'icons'],
['Order', 'SMART', 'SMART'],
['GridEditing', 'double-click', 'double-click'],
['ProtectBinary', 'blob', 'blob'],
['ForeignKeyDropdownOrder', ['content-id'], ['content-id']],
['DefaultForeignKeyChecks', 'default', 'default'],
['TabsMode', 'both', 'both'],
['ActionLinksMode', 'both', 'both'],
['DefaultTabServer', 'databases', 'databases'],
['DefaultTabDatabase', 'sql', 'sql'],
['DefaultTabTable', 'sql', 'sql'],
['RowActionType', 'both', 'both'],
['RecodingEngine', 'iconv', 'iconv'],
['RowActionLinks', 'right', 'right'],
['TablePrimaryKeyOrder', 'ASC', 'ASC'],
['InitialSlidersState', 'disabled', 'disabled'],
['GD2Available', 'no', 'no'],
['SendErrorReports', 'always', 'always'],
],
],
'valid values 4' => [
[
['NavigationTreeDefaultTabTable', 'sql', 'sql'],
['NavigationTreeDefaultTabTable2', 'sql', 'sql'],
['ProtectBinary', false, false],
['ForeignKeyDropdownOrder', ['id-content'], ['id-content']],
['DefaultTabServer', 'status', 'status'],
['DefaultTabDatabase', 'search', 'search'],
['DefaultTabTable', 'search', 'search'],
['RecodingEngine', 'recode', 'recode'],
['RowActionLinks', 'both', 'both'],
],
],
'valid values 5' => [
[
['NavigationTreeDefaultTabTable', 'search', 'search'],
['NavigationTreeDefaultTabTable2', 'search', 'search'],
['DefaultTabServer', 'variables', 'variables'],
['DefaultTabDatabase', 'db_structure.php', 'structure'],
['DefaultTabTable', 'insert', 'insert'],
['RecodingEngine', 'mb', 'mb'],
],
],
'valid values 6' => [
[
['NavigationTreeDefaultTabTable', 'tbl_structure.php', 'structure'],
['NavigationTreeDefaultTabTable2', 'tbl_structure.php', 'structure'],
['DefaultTabServer', 'index.php', 'welcome'],
['DefaultTabDatabase', 'db_sql.php', 'sql'],
['DefaultTabTable', 'tbl_structure.php', 'structure'],
],
],
'valid values 7' => [
[
['NavigationTreeDefaultTabTable', 'tbl_sql.php', 'sql'],
['NavigationTreeDefaultTabTable2', 'tbl_sql.php', 'sql'],
['DefaultTabServer', 'server_databases.php', 'databases'],
['DefaultTabDatabase', 'db_search.php', 'search'],
['DefaultTabTable', 'tbl_sql.php', 'sql'],
],
],
'valid values 8' => [
[
['NavigationTreeDefaultTabTable', 'tbl_select.php', 'search'],
['NavigationTreeDefaultTabTable2', 'tbl_select.php', 'search'],
['DefaultTabServer', 'server_status.php', 'status'],
['DefaultTabDatabase', 'db_operations.php', 'operations'],
['DefaultTabTable', 'tbl_select.php', 'search'],
],
],
'valid values 9' => [
[
['NavigationTreeDefaultTabTable', 'tbl_change.php', 'insert'],
['NavigationTreeDefaultTabTable2', 'tbl_change.php', 'insert'],
['DefaultTabServer', 'server_variables.php', 'variables'],
['DefaultTabTable', 'tbl_change.php', 'insert'],
],
],
'valid values 10' => [
[
['NavigationTreeDefaultTabTable', 'sql.php', 'browse'],
['NavigationTreeDefaultTabTable2', 'sql.php', 'browse'],
['DefaultTabServer', 'server_privileges.php', 'privileges'],
['DefaultTabTable', 'sql.php', 'browse'],
],
],
'valid values 11' => [[['NavigationTreeDefaultTabTable2', '', '']]],
'valid values with type coercion' => [
[
['PmaAbsoluteUri', 1234, '1234'],
['AuthLog', 1234, '1234'],
['AuthLogSuccess', 1, true],
['PmaNoRelation_DisableWarning', 1, true],
['SuhosinDisableWarning', 1, true],
['LoginCookieValidityDisableWarning', 1, true],
['ReservedWordDisableWarning', 1, true],
['TranslationWarningThreshold', '0', 0],
['AllowThirdPartyFraming', 1, true],
['blowfish_secret', 1234, '1234'],
['ServerDefault', '0', 0],
['VersionCheck', 0, false],
['ProxyUrl', 1234, '1234'],
['ProxyUser', 1234, '1234'],
['ProxyPass', 1234, '1234'],
['MaxDbList', '1', 1],
['MaxTableList', '1', 1],
['ShowHint', 0, false],
['MaxCharactersInDisplayedSQL', '1', 1],
['OBGzip', 0, false],
['PersistentConnections', 1, true],
['ExecTimeLimit', '0', 0],
['SessionSavePath', 1234, '1234'],
['MysqlSslWarningSafeHosts', ['127.0.0.1' => 'local', false, 1234 => 1234], ['local', '1234']],
['MemoryLimit', 1234, '1234'],
['SkipLockedTables', 1, true],
['ShowSQL', 0, false],
['RetainQueryBox', 1, true],
['CodemirrorEnable', 0, false],
['LintEnable', 0, false],
['AllowUserDropDatabase', 1, true],
['Confirm', 0, false],
['LoginCookieRecall', 0, false],
['LoginCookieValidity', '1', 1],
['LoginCookieStore', '1', 1],
['LoginCookieDeleteAll', 0, false],
['UseDbSearch', 0, false],
['IgnoreMultiSubmitErrors', 1, true],
['URLQueryEncryption', 1, true],
['AllowArbitraryServer', 1, true],
['ArbitraryServerRegexp', 1234, '1234'],
['CaptchaApi', 1234, '1234'],
['CaptchaCsp', 1234, '1234'],
['CaptchaRequestParam', 1234, '1234'],
['CaptchaResponseParam', 1234, '1234'],
['CaptchaLoginPublicKey', 1234, '1234'],
['CaptchaLoginPrivateKey', 1234, '1234'],
['CaptchaSiteVerifyURL', 1234, '1234'],
['enable_drag_drop_import', 0, false],
['ShowDatabasesNavigationAsTree', 0, false],
['FirstLevelNavigationItems', '1', 1],
['MaxNavigationItems', '1', 1],
['NavigationTreeEnableGrouping', 0, false],
['NavigationTreeDbSeparator', 1234, '1234'],
['NavigationTreeTableSeparator', true, '1'],
['NavigationTreeTableLevel', '2', 2],
['NavigationLinkWithMainPanel', 0, false],
['NavigationDisplayLogo', 0, false],
['NavigationLogoLink', 1234, '1234'],
['NumRecentTables', '1', 1],
['NumFavoriteTables', '1', 1],
['NavigationTreeDisplayItemFilterMinimum', '1', 1],
['NavigationDisplayServers', 0, false],
['DisplayServersList', 1, true],
['NavigationTreeDisplayDbFilterMinimum', '1', 1],
['NavigationTreeEnableExpansion', 0, false],
['NavigationTreeShowTables', 0, false],
['NavigationTreeShowViews', 0, false],
['NavigationTreeShowFunctions', 0, false],
['NavigationTreeShowProcedures', 0, false],
['NavigationTreeShowEvents', 0, false],
['NavigationWidth', '1', 1],
['NavigationTreeAutoexpandSingleDb', 0, false],
['ShowStats', 0, false],
['ShowPhpInfo', 1, true],
['ShowServerInfo', 0, false],
['ShowChgPassword', 0, false],
['ShowCreateDb', 0, false],
['ShowDbStructureCharset', 1, true],
['ShowDbStructureComment', 1, true],
['ShowDbStructureCreation', 1, true],
['ShowDbStructureLastUpdate', 1, true],
['ShowDbStructureLastCheck', 1, true],
['HideStructureActions', 0, false],
['ShowColumnComments', 0, false],
['ShowAll', 1, true],
['MaxRows', '1', 1],
['SaveCellsAtOnce', 1, true],
['ShowFunctionFields', 0, false],
['ShowFieldTypesInDataEditView', 0, false],
['MinSizeForInputField', '0', 0],
['MaxSizeForInputField', '1', 1],
['InsertRows', '1', 1],
['ForeignKeyMaxLimit', '1', 1],
['ZipDump', 0, false],
['GZipDump', 0, false],
['BZipDump', 0, false],
['CompressOnFly', 0, false],
['PropertiesNumColumns', '2', 2],
['PDFPageSizes', [1234 => 1234, 'test' => 'test'], ['1234', 'test']],
['PDFDefaultPageSize', 1234, '1234'],
['DefaultLang', 1234, '1234'],
['DefaultConnectionCollation', 1234, '1234'],
['Lang', 1234, '1234'],
['FilterLanguages', 1234, '1234'],
['IconvExtraParams', 1234, '1234'],
['AvailableCharsets', [1234 => 1234, 'test' => 'test'], ['1234', 'test']],
['NavigationTreePointerEnable', 0, false],
['BrowsePointerEnable', 0, false],
['BrowseMarkerEnable', 0, false],
['TextareaCols', '1', 1],
['TextareaRows', '1', 1],
['LongtextDoubleTextarea', 0, false],
['TextareaAutoSelect', 1, true],
['CharTextareaCols', '1', 1],
['CharTextareaRows', '1', 1],
['LimitChars', '1', 1],
['RowActionLinksWithoutUnique', 1, true],
['RememberSorting', 0, false],
['ShowBrowseComments', 0, false],
['ShowPropertyComments', 0, false],
['RepeatCells', '0', 0],
['QueryHistoryDB', 1, true],
['QueryHistoryMax', '1', 1],
['BrowseMIME', 0, false],
['MaxExactCount', '1', 1],
['MaxExactCountViews', '1', 1],
['NaturalOrder', 0, false],
['UserprefsDisallow', [1234 => 1234, 'test' => 'test'], ['1234', 'test']],
['UserprefsDeveloperTab', 1, true],
['TitleTable', 1234, '1234'],
['TitleDatabase', 1234, '1234'],
['TitleServer', 1234, '1234'],
['TitleDefault', 1234, '1234'],
['ThemeManager', 0, false],
['ThemeDefault', 1234, '1234'],
['ThemePerServer', 1, true],
['DefaultQueryTable', 1234, '1234'],
['DefaultQueryDatabase', 1234, '1234'],
['EnableAutocompleteForTablesAndColumns', 0, false],
['UploadDir', 1234, '1234'],
['SaveDir', 1234, '1234'],
['TempDir', 1234, '1234'],
['TrustedProxies', ['test' => 1234], ['test' => '1234']],
['CheckConfigurationPermissions', 0, false],
['LinkLengthLimit', '1', 1],
['CSPAllow', 1234, '1234'],
['DisableMultiTableMaintenance', 1, true],
['ConsoleEnterExecutes', 1, true],
['ZeroConf', 0, false],
['DefaultFunctions', ['test' => 1234], ['test' => '1234']],
['maxRowPlotLimit', '1', 1],
['ShowGitRevision', 0, false],
['MysqlMinVersion', ['internal' => '50500', 'human' => 550], ['internal' => 50500, 'human' => '550']],
['DisableShortcutKeys', 1, true],
['FirstDayOfCalendar', '1', 1],
],
],
'invalid values' => [
[
['Servers', 'invalid', [1 => null]],
['TranslationWarningThreshold', -1, 80],
['ServerDefault', -1, 1],
['MaxDbList', 0, 100],
['MaxTableList', 0, 250],
['MaxCharactersInDisplayedSQL', 0, 1000],
['ExecTimeLimit', -1, 300],
['MysqlSslWarningSafeHosts', 'invalid', ['127.0.0.1', 'localhost']],
['CookieSameSite', 'invalid', 'Strict'],
['LoginCookieValidity', 0, 1440],
['LoginCookieStore', -1, 0],
['CaptchaMethod', 'invalid', 'invisible'],
['FirstLevelNavigationItems', 0, 100],
['MaxNavigationItems', 0, 50],
['NavigationTreeTableSeparator', [], '__'],
['NavigationTreeTableLevel', 0, 1],
['NavigationLogoLinkWindow', 'invalid', 'main'],
['NumRecentTables', -1, 10],
['NumFavoriteTables', -1, 10],
['NavigationTreeDisplayItemFilterMinimum', 0, 30],
['NavigationTreeDisplayDbFilterMinimum', 0, 30],
['NavigationTreeDefaultTabTable', 'invalid', 'structure'],
['NavigationTreeDefaultTabTable2', 'invalid', ''],
['NavigationWidth', -1, 240],
['TableNavigationLinksMode', 'invalid', 'icons'],
['MaxRows', 0, 25],
['Order', 'invalid', 'SMART'],
['GridEditing', 'invalid', 'double-click'],
['RelationalDisplay', 'invalid', 'K'],
['ProtectBinary', true, 'blob'],
['CharEditing', 'invalid', 'input'],
['MinSizeForInputField', -1, 4],
['MaxSizeForInputField', 0, 60],
['InsertRows', 0, 2],
['ForeignKeyDropdownOrder', ['invalid'], ['content-id', 'id-content']],
['ForeignKeyMaxLimit', 0, 100],
['DefaultForeignKeyChecks', 'invalid', 'default'],
['TabsMode', 'invalid', 'both'],
['ActionLinksMode', 'invalid', 'both'],
['PropertiesNumColumns', 0, 1],
['DefaultTabServer', 'invalid', 'welcome'],
['DefaultTabDatabase', 'invalid', 'structure'],
['DefaultTabTable', 'invalid', 'browse'],
['RowActionType', 'invalid', 'both'],
['PDFPageSizes', 'invalid', ['A3', 'A4', 'A5', 'letter', 'legal']],
['RecodingEngine', 'invalid', 'auto'],
['AvailableCharsets', 'invalid', ['iso-8859-1', 'iso-8859-2', 'iso-8859-3', 'iso-8859-4', 'iso-8859-5', 'iso-8859-6', 'iso-8859-7', 'iso-8859-8', 'iso-8859-9', 'iso-8859-10', 'iso-8859-11', 'iso-8859-12', 'iso-8859-13', 'iso-8859-14', 'iso-8859-15', 'windows-1250', 'windows-1251', 'windows-1252', 'windows-1256', 'windows-1257', 'koi8-r', 'big5', 'gb2312', 'utf-16', 'utf-8', 'utf-7', 'x-user-defined', 'euc-jp', 'ks_c_5601-1987', 'tis-620', 'SHIFT_JIS', 'SJIS', 'SJIS-win']],
['TextareaCols', 0, 40],
['TextareaRows', 0, 15],
['CharTextareaCols', 0, 40],
['CharTextareaRows', 0, 7],
['LimitChars', 0, 50],
['RowActionLinks', 'invalid', 'left'],
['TablePrimaryKeyOrder', 'invalid', 'NONE'],
['RepeatCells', -1, 100],
['QueryHistoryMax', 0, 25],
['MaxExactCount', 0, 50000],
['MaxExactCountViews', -1, 0],
['InitialSlidersState', 'invalid', 'closed'],
['UserprefsDisallow', 'invalid', []],
['SQLQuery', 'invalid', null],
['EnableAutocompleteForTablesAndColumns', null, true],
['GD2Available', 'invalid', 'auto'],
['TrustedProxies', 'invalid', []],
['LinkLengthLimit', 0, 1000],
['SendErrorReports', 'invalid', 'ask'],
['DBG', 'invalid', null],
['environment', 'invalid', 'production'],
['DefaultFunctions', 'invalid', ['FUNC_CHAR' => '', 'FUNC_DATE' => '', 'FUNC_NUMBER' => '', 'FUNC_SPATIAL' => 'GeomFromText', 'FUNC_UUID' => 'UUID', 'first_timestamp' => 'NOW']],
['maxRowPlotLimit', 0, 500],
['MysqlMinVersion', 'invalid', ['internal' => 50500, 'human' => '5.5.0']],
['Console', 'invalid', null],
['FirstDayOfCalendar', 8, 0],
],
],
'invalid values 2' => [
[
['Servers', [0 => [], 2 => 'invalid', 'invalid' => [], 4 => []], [4 => null]],
['TranslationWarningThreshold', 101, 100],
['ForeignKeyDropdownOrder', ['id-content', 'invalid'], ['id-content']],
['TrustedProxies', [1234 => 'invalid', 'valid' => 'valid'], ['valid' => 'valid']],
['DefaultFunctions', [1234 => 'invalid', 'valid' => 'valid'], ['valid' => 'valid']],
['FirstDayOfCalendar', -1, 0],
],
],
'invalid values 3' => [
[
['Servers', [0 => []], [1 => null]],
['ForeignKeyDropdownOrder', 'invalid', ['content-id', 'id-content']],
],
],
'invalid values 4' => [[['ForeignKeyDropdownOrder', [1 => 'content-id'], ['content-id', 'id-content']]]],
];
}
}