Here is the list of the most complex expressions used in the code. A complex expression is an expression that requires more than 20 tokens to be build.
Literal arrays are omitted.
File | Count | Expression |
---|---|---|
/libraries/classes/Table/ColumnsDefinition.php:417 | 1 | array_merge($form_params, ["field_default_value_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Default', ''), "field_default_type_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'DefaultType', ''), "field_collation_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Collation', ''), "field_attribute_orig[${columnNumber}]" => trim(Util::getValueByKey($extracted_columnspec, 'attribute', '')), "field_null_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Null', ''), "field_extra_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Extra', ''), "field_comments_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Comment', ''), "field_virtuality_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Virtuality', ''), "field_expression_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Expression', ''), ]) |
/libraries/classes/Table/ColumnsDefinition.php:283 | 1 | array_merge($mime_map[$columnMeta['Field']] ?? [ ], ['mimetype' => Util::getValueByKey($_POST, "field_mimetype.${columnNumber}"), 'transformation' => Util::getValueByKey($_POST, "field_transformation.${columnNumber}"), 'transformation_options' => Util::getValueByKey($_POST, "field_transformation_options.${columnNumber}"), ]) |
/libraries/classes/SqlQueryForm.php:149 | 1 | htmlspecialchars(!empty($GLOBALS['cfg']['Servers'][$GLOBALS['server']]['verbose']) ? $GLOBALS['cfg']['Servers'][$GLOBALS['server']]['verbose'] : $GLOBALS['cfg']['Servers'][$GLOBALS['server']]['host']) |
/libraries/classes/SqlQueryForm.php:147 | 1 | sprintf(__('Run SQL query/queries on server “%s”'), htmlspecialchars(!empty($GLOBALS['cfg']['Servers'][$GLOBALS['server']]['verbose']) ? $GLOBALS['cfg']['Servers'][$GLOBALS['server']]['verbose'] : $GLOBALS['cfg']['Servers'][$GLOBALS['server']]['host'])) |
/libraries/classes/Table/ColumnsDefinition.php:182 | 1 | array_merge($columnMeta, ['Field' => Util::getValueByKey($_POST, "field_name.${columnNumber}", null), 'Type' => Util::getValueByKey($_POST, "field_type.${columnNumber}", null), 'Collation' => Util::getValueByKey($_POST, "field_collation.${columnNumber}", ''), 'Null' => Util::getValueByKey($_POST, "field_null.${columnNumber}", ''), 'DefaultType' => Util::getValueByKey($_POST, "field_default_type.${columnNumber}", 'NONE'), 'DefaultValue' => Util::getValueByKey($_POST, "field_default_value.${columnNumber}", ''), 'Extra' => Util::getValueByKey($_POST, "field_extra.${columnNumber}", null), 'Virtuality' => Util::getValueByKey($_POST, "field_virtuality.${columnNumber}", ''), 'Expression' => Util::getValueByKey($_POST, "field_expression.${columnNumber}", ''), ]) |
/libraries/classes/Plugins/Export/Helpers/TableProperty.php:261 | 1 | str_replace(['#ucfirstName#', '#dotNetPrimitiveType#', '#dotNetObjectType#', '#type#', '#notNull#', '#unique#', ], [ExportCodegen::cgMakeIdentifier($this->name), $this->getDotNetPrimitiveType( ), $this->getDotNetObjectType( ), $this->getPureType( ), $this->isNotNull( ), $this->isUnique( ), ], $text) |
/libraries/classes/Config/Validator.php:304 | 1 | $test = static::testDBConnection(empty($values['Servers/1/host']) ? '' : $values['Servers/1/host'], empty($values['Servers/1/port']) ? '' : $values['Servers/1/port'], empty($values['Servers/1/socket']) ? '' : $values['Servers/1/socket'], empty($values['Servers/1/user']) ? '' : $values['Servers/1/user'], $password, 'Server') |
/libraries/classes/Config/FormDisplay.php:266 | 1 | $htmlOutput .= $this->formDisplayTemplate->displayFieldsetTop(Descriptions::get('Form_' . $form->name), Descriptions::get('Form_' . $form->name, 'desc'), $formErrors, ['id' => $form->name]) |
/libraries/classes/Config/Descriptions.php:67 | 1 | $descriptions = ['AllowArbitraryServer_desc' => __('If enabled, user can enter any MySQL server in login form for cookie auth.'), 'AllowArbitraryServer_name' => __('Allow login to any MySQL server'), 'ArbitraryServerRegexp_desc' => __('Restricts the MySQL servers the user can enter when a login to an arbitrary ' . 'MySQL server is enabled by matching the IP or hostname of the MySQL server ' . 'to the given regular expression.'), 'ArbitraryServerRegexp_name' => __('Restrict login to MySQL server'), 'AllowThirdPartyFraming_desc' => __('Enabling this allows a page located on a different domain to call phpMyAdmin ' . 'inside a frame, and is a potential [strong]security hole[/strong] allowing ' . 'cross-frame scripting (XSS) attacks.'), 'AllowThirdPartyFraming_name' => __('Allow third party framing'), 'AllowUserDropDatabase_name' => __('Show "Drop database" link to normal users'), 'blowfish_secret_desc' => __('Secret passphrase used for encrypting cookies in [kbd]cookie[/kbd] ' . 'authentication.'), 'blowfish_secret_name' => __('Blowfish secret'), 'BrowseMarkerEnable_desc' => __('Highlight selected rows.'), 'BrowseMarkerEnable_name' => __('Row marker'), 'BrowsePointerEnable_desc' => __('Highlight row pointed by the mouse cursor.'), 'BrowsePointerEnable_name' => __('Highlight pointer'), 'BZipDump_desc' => __('Enable bzip2 compression for' . ' import operations.'), 'BZipDump_name' => __('Bzip2'), 'CharEditing_desc' => __('Defines which type of editing controls should be used for CHAR and VARCHAR ' . 'columns; [kbd]input[/kbd] - allows limiting of input length, ' . '[kbd]textarea[/kbd] - allows newlines in columns.'), 'CharEditing_name' => __('CHAR columns editing'), 'CodemirrorEnable_desc' => __('Use user-friendly editor for editing SQL queries ' . '(CodeMirror) with syntax highlighting and ' . 'line numbers.'), 'CodemirrorEnable_name' => __('Enable CodeMirror'), 'LintEnable_desc' => __('Find any errors in the query before executing it.' . ' Requires CodeMirror to be enabled.'), 'LintEnable_name' => __('Enable linter'), 'MinSizeForInputField_desc' => __('Defines the minimum size for input fields generated for CHAR and VARCHAR ' . 'columns.'), 'MinSizeForInputField_name' => __('Minimum size for input field'), 'MaxSizeForInputField_desc' => __('Defines the maximum size for input fields generated for CHAR and VARCHAR ' . 'columns.'), 'MaxSizeForInputField_name' => __('Maximum size for input field'), 'CharTextareaCols_desc' => __('Number of columns for CHAR/VARCHAR textareas.'), 'CharTextareaCols_name' => __('CHAR textarea columns'), 'CharTextareaRows_desc' => __('Number of rows for CHAR/VARCHAR textareas.'), 'CharTextareaRows_name' => __('CHAR textarea rows'), 'CheckConfigurationPermissions_name' => __('Check config file permissions'), 'CompressOnFly_desc' => __('Compress gzip exports on the fly without the need for much memory; if ' . 'you encounter problems with created gzip files disable this feature.'), 'CompressOnFly_name' => __('Compress on the fly'), 'Confirm_desc' => __('Whether a warning ("Are your really sure…") should be displayed ' . 'when you\'re about to lose data.'), 'Confirm_name' => __('Confirm DROP queries'), 'DBG_sql_desc' => __('Log SQL queries and their execution time, to be displayed in the console'), 'DBG_sql_name' => __('Debug SQL'), 'DefaultTabDatabase_desc' => __('Tab that is displayed when entering a database.'), 'DefaultTabDatabase_name' => __('Default database tab'), 'DefaultTabServer_desc' => __('Tab that is displayed when entering a server.'), 'DefaultTabServer_name' => __('Default server tab'), 'DefaultTabTable_desc' => __('Tab that is displayed when entering a table.'), 'DefaultTabTable_name' => __('Default table tab'), 'EnableAutocompleteForTablesAndColumns_desc' => __('Autocomplete of the table and column names in the SQL queries.'), 'EnableAutocompleteForTablesAndColumns_name' => __('Enable autocomplete for table and column names'), 'HideStructureActions_desc' => __('Whether the table structure actions should be hidden.'), 'ShowColumnComments_name' => __('Show column comments'), 'ShowColumnComments_desc' => __('Whether column comments should be shown in table structure view'), 'HideStructureActions_name' => __('Hide table structure actions'), 'DefaultTransformations_Hex_name' => __('Default transformations for Hex'), 'DefaultTransformations_Hex_desc' => __('Values for options list for default transformations. These will be overwritten if' . ' transformation is filled in at table structure page.'), 'DefaultTransformations_Substring_name' => __('Default transformations for Substring'), 'DefaultTransformations_Substring_desc' => __('Values for options list for default transformations. These will be overwritten if' . ' transformation is filled in at table structure page.'), 'DefaultTransformations_Bool2Text_name' => __('Default transformations for Bool2Text'), 'DefaultTransformations_Bool2Text_desc' => __('Values for options list for default transformations. These will be overwritten if' . ' transformation is filled in at table structure page.'), 'DefaultTransformations_External_name' => __('Default transformations for External'), 'DefaultTransformations_External_desc' => __('Values for options list for default transformations. These will be overwritten if' . ' transformation is filled in at table structure page.'), 'DefaultTransformations_PreApPend_name' => __('Default transformations for PreApPend'), 'DefaultTransformations_PreApPend_desc' => __('Values for options list for default transformations. These will be overwritten if' . ' transformation is filled in at table structure page.'), 'DefaultTransformations_DateFormat_name' => __('Default transformations for DateFormat'), 'DefaultTransformations_DateFormat_desc' => __('Values for options list for default transformations. These will be overwritten if' . ' transformation is filled in at table structure page.'), 'DefaultTransformations_Inline_name' => __('Default transformations for Inline'), 'DefaultTransformations_Inline_desc' => __('Values for options list for default transformations. These will be overwritten if' . ' transformation is filled in at table structure page.'), 'DefaultTransformations_TextImageLink_name' => __('Default transformations for TextImageLink'), 'DefaultTransformations_TextImageLink_desc' => __('Values for options list for default transformations. These will be overwritten if' . ' transformation is filled in at table structure page.'), 'DefaultTransformations_TextLink_name' => __('Default transformations for TextLink'), 'DefaultTransformations_TextLink_desc' => __('Values for options list for default transformations. These will be overwritten if' . ' transformation is filled in at table structure page.'), 'DisplayServersList_desc' => __('Show server listing as a list instead of a drop down.'), 'DisplayServersList_name' => __('Display servers as a list'), 'DisableMultiTableMaintenance_desc' => __('Disable the table maintenance mass operations, like optimizing or repairing ' . 'the selected tables of a database.'), 'DisableMultiTableMaintenance_name' => __('Disable multi table maintenance'), 'ExecTimeLimit_desc' => __('Set the number of seconds a script is allowed to run ([kbd]0[/kbd] for no ' . 'limit).'), 'ExecTimeLimit_name' => __('Maximum execution time'), 'Export_lock_tables_name' => sprintf(__('Use %s statement'), htmlspecialchars('<code>LOCK TABLES</code>')), 'Export_asfile_name' => __('Save as file'), 'Export_charset_name' => __('Character set of the file'), 'Export_codegen_format_name' => __('Format'), 'Export_compression_name' => __('Compression'), 'Export_csv_columns_name' => __('Put columns names in the first row'), 'Export_csv_enclosed_name' => __('Columns enclosed with'), 'Export_csv_escaped_name' => __('Columns escaped with'), 'Export_csv_null_name' => __('Replace NULL with'), 'Export_csv_removeCRLF_name' => __('Remove CRLF characters within columns'), 'Export_csv_separator_name' => __('Columns terminated with'), 'Export_csv_terminated_name' => __('Lines terminated with'), 'Export_excel_columns_name' => __('Put columns names in the first row'), 'Export_excel_edition_name' => __('Excel edition'), 'Export_excel_null_name' => __('Replace NULL with'), 'Export_excel_removeCRLF_name' => __('Remove CRLF characters within columns'), 'Export_file_template_database_name' => __('Database name template'), 'Export_file_template_server_name' => __('Server name template'), 'Export_file_template_table_name' => __('Table name template'), 'Export_format_name' => __('Format'), 'Export_htmlword_columns_name' => __('Put columns names in the first row'), 'Export_htmlword_null_name' => __('Replace NULL with'), 'Export_htmlword_structure_or_data_name' => __('Dump table'), 'Export_latex_caption_name' => __('Include table caption'), 'Export_latex_columns_name' => __('Put columns names in the first row'), 'Export_latex_comments_name' => __('Comments'), 'Export_latex_data_caption_name' => __('Table caption'), 'Export_latex_data_continued_caption_name' => __('Continued table caption'), 'Export_latex_data_label_name' => __('Label key'), 'Export_latex_mime_name' => __('Media type'), 'Export_latex_null_name' => __('Replace NULL with'), 'Export_latex_relation_name' => __('Relationships'), 'Export_latex_structure_caption_name' => __('Table caption'), 'Export_latex_structure_continued_caption_name' => __('Continued table caption'), 'Export_latex_structure_label_name' => __('Label key'), 'Export_latex_structure_or_data_name' => __('Dump table'), 'Export_method_name' => __('Export method'), 'Export_ods_columns_name' => __('Put columns names in the first row'), 'Export_ods_null_name' => __('Replace NULL with'), 'Export_odt_columns_name' => __('Put columns names in the first row'), 'Export_odt_comments_name' => __('Comments'), 'Export_odt_mime_name' => __('Media type'), 'Export_odt_null_name' => __('Replace NULL with'), 'Export_odt_relation_name' => __('Relationships'), 'Export_odt_structure_or_data_name' => __('Dump table'), 'Export_onserver_name' => __('Save on server'), 'Export_onserver_overwrite_name' => __('Overwrite existing file(s)'), 'Export_as_separate_files_name' => __('Export as separate files'), 'Export_quick_export_onserver_name' => __('Save on server'), 'Export_quick_export_onserver_overwrite_name' => __('Overwrite existing file(s)'), 'Export_remember_file_template_name' => __('Remember file name template'), 'Export_sql_auto_increment_name' => __('Add AUTO_INCREMENT value'), 'Export_sql_backquotes_name' => __('Enclose table and column names with backquotes'), 'Export_sql_compatibility_name' => __('SQL compatibility mode'), 'Export_sql_dates_name' => __('Creation/Update/Check dates'), 'Export_sql_delayed_name' => __('Use delayed inserts'), 'Export_sql_disable_fk_name' => __('Disable foreign key checks'), 'Export_sql_views_as_tables_name' => __('Export views as tables'), 'Export_sql_metadata_name' => __('Export related metadata from phpMyAdmin configuration storage'), 'Export_sql_create_database_name' => sprintf(__('Add %s'), 'CREATE DATABASE / USE'), 'Export_sql_drop_database_name' => sprintf(__('Add %s'), 'DROP DATABASE'), 'Export_sql_drop_table_name' => sprintf(__('Add %s'), 'DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER'), 'Export_sql_create_table_name' => sprintf(__('Add %s'), 'CREATE TABLE'), 'Export_sql_create_view_name' => sprintf(__('Add %s'), 'CREATE VIEW'), 'Export_sql_create_trigger_name' => sprintf(__('Add %s'), 'CREATE TRIGGER'), 'Export_sql_hex_for_binary_name' => __('Use hexadecimal for BINARY & BLOB'), 'Export_sql_if_not_exists_name' => __('Add IF NOT EXISTS (less efficient as indexes will be generated during' . ' table creation)'), 'Export_sql_view_current_user' => __('Exclude definition of current user'), 'Export_sql_or_replace_view_name' => sprintf(__('%s view'), 'OR REPLACE'), 'Export_sql_ignore_name' => __('Use ignore inserts'), 'Export_sql_include_comments_name' => __('Comments'), 'Export_sql_insert_syntax_name' => __('Syntax to use when inserting data'), 'Export_sql_max_query_size_name' => __('Maximal length of created query'), 'Export_sql_mime_name' => __('Media type'), 'Export_sql_procedure_function_name' => sprintf(__('Add %s'), 'CREATE PROCEDURE / FUNCTION / EVENT'), 'Export_sql_relation_name' => __('Relationships'), 'Export_sql_structure_or_data_name' => __('Dump table'), 'Export_sql_type_name' => __('Export type'), 'Export_sql_use_transaction_name' => __('Enclose export in a transaction'), 'Export_sql_utc_time_name' => __('Export time in UTC'), 'Export_texytext_columns_name' => __('Put columns names in the first row'), 'Export_texytext_null_name' => __('Replace NULL with'), 'Export_texytext_structure_or_data_name' => __('Dump table'), 'ForeignKeyDropdownOrder_desc' => __('Sort order for items in a foreign-key dropdown box; [kbd]content[/kbd] is ' . 'the referenced data, [kbd]id[/kbd] is the key value.'), 'ForeignKeyDropdownOrder_name' => __('Foreign key dropdown order'), 'ForeignKeyMaxLimit_desc' => __('A dropdown will be used if fewer items are present.'), 'ForeignKeyMaxLimit_name' => __('Foreign key limit'), 'DefaultForeignKeyChecks_desc' => __('Default value for foreign key checks checkbox for some queries.'), 'DefaultForeignKeyChecks_name' => __('Foreign key checks'), 'FirstDayOfCalendar_name' => __('First day of calendar'), 'Form_Browse_name' => __('Browse mode'), 'Form_Browse_desc' => __('Customize browse mode.'), 'Form_CodeGen_name' => 'CodeGen', 'Form_CodeGen_desc' => __('Customize default options.'), 'Form_Csv_name' => __('CSV'), 'Form_Csv_desc' => __('Customize default options.'), 'Form_Developer_name' => __('Developer'), 'Form_Developer_desc' => __('Settings for phpMyAdmin developers.'), 'Form_Edit_name' => __('Edit mode'), 'Form_Edit_desc' => __('Customize edit mode.'), 'Form_Export_defaults_name' => __('Export defaults'), 'Form_Export_defaults_desc' => __('Customize default export options.'), 'Form_General_name' => __('General'), 'Form_General_desc' => __('Set some commonly used options.'), 'Form_Import_defaults_name' => __('Import defaults'), 'Form_Import_defaults_desc' => __('Customize default common import options.'), 'Form_Import_export_name' => __('Import / export'), 'Form_Import_export_desc' => __('Set import and export directories and compression options.'), 'Form_Latex_name' => __('LaTeX'), 'Form_Latex_desc' => __('Customize default options.'), 'Form_Navi_databases_name' => __('Databases'), 'Form_Navi_databases_desc' => __('Databases display options.'), 'Form_Navi_panel_name' => __('Navigation panel'), 'Form_Navi_panel_desc' => __('Customize appearance of the navigation panel.'), 'Form_Navi_tree_name' => __('Navigation tree'), 'Form_Navi_tree_desc' => __('Customize the navigation tree.'), 'Form_Navi_servers_name' => __('Servers'), 'Form_Navi_servers_desc' => __('Servers display options.'), 'Form_Navi_tables_name' => __('Tables'), 'Form_Navi_tables_desc' => __('Tables display options.'), 'Form_Main_panel_name' => __('Main panel'), 'Form_Microsoft_Office_name' => __('Microsoft Office'), 'Form_Microsoft_Office_desc' => __('Customize default options.'), 'Form_Open_Document_name' => 'OpenDocument', 'Form_Open_Document_desc' => __('Customize default options.'), 'Form_Other_core_settings_name' => __('Other core settings'), 'Form_Other_core_settings_desc' => __('Settings that didn\'t fit anywhere else.'), 'Form_Page_titles_name' => __('Page titles'), 'Form_Page_titles_desc' => __('Specify browser\'s title bar text. Refer to ' . '[doc@faq6-27]documentation[/doc] for magic strings that can be used ' . 'to get special values.'), 'Form_Security_name' => __('Security'), 'Form_Security_desc' => __('Please note that phpMyAdmin is just a user interface and its features do not ' . 'limit MySQL.'), 'Form_Server_name' => __('Basic settings'), 'Form_Server_auth_name' => __('Authentication'), 'Form_Server_auth_desc' => __('Authentication settings.'), 'Form_Server_config_name' => __('Server configuration'), 'Form_Server_config_desc' => __('Advanced server configuration, do not change these options unless you know ' . 'what they are for.'), 'Form_Server_desc' => __('Enter server connection parameters.'), 'Form_Server_pmadb_name' => __('Configuration storage'), 'Form_Server_pmadb_desc' => __('Configure phpMyAdmin configuration storage to gain access to additional ' . 'features, see [doc@linked-tables]phpMyAdmin configuration storage[/doc] in ' . 'documentation.'), 'Form_Server_tracking_name' => __('Changes tracking'), 'Form_Server_tracking_desc' => __('Tracking of changes made in database. Requires the phpMyAdmin configuration ' . 'storage.'), 'Form_Sql_name' => __('SQL'), 'Form_Sql_box_name' => __('SQL Query box'), 'Form_Sql_box_desc' => __('Customize links shown in SQL Query boxes.'), 'Form_Sql_desc' => __('Customize default options.'), 'Form_Sql_queries_name' => __('SQL queries'), 'Form_Sql_queries_desc' => __('SQL queries settings.'), 'Form_Startup_name' => __('Startup'), 'Form_Startup_desc' => __('Customize startup page.'), 'Form_DbStructure_name' => __('Database structure'), 'Form_DbStructure_desc' => __('Choose which details to show in the database structure (list of tables).'), 'Form_TableStructure_name' => __('Table structure'), 'Form_TableStructure_desc' => __('Settings for the table structure (list of columns).'), 'Form_Tabs_name' => __('Tabs'), 'Form_Tabs_desc' => __('Choose how you want tabs to work.'), 'Form_DisplayRelationalSchema_name' => __('Display relational schema'), 'Form_DisplayRelationalSchema_desc' => '', 'PDFDefaultPageSize_name' => __('Paper size'), 'PDFDefaultPageSize_desc' => '', 'Form_Databases_name' => __('Databases'), 'Form_Text_fields_name' => __('Text fields'), 'Form_Text_fields_desc' => __('Customize text input fields.'), 'Form_Texy_name' => __('Texy! text'), 'Form_Texy_desc' => __('Customize default options'), 'Form_Warnings_name' => __('Warnings'), 'Form_Warnings_desc' => __('Disable some of the warnings shown by phpMyAdmin.'), 'Form_Console_name' => __('Console'), 'GZipDump_desc' => __('Enable gzip compression for import ' . 'and export operations.'), 'GZipDump_name' => __('GZip'), 'IconvExtraParams_name' => __('Extra parameters for iconv'), 'IgnoreMultiSubmitErrors_desc' => __('If enabled, phpMyAdmin continues computing multiple-statement queries even if ' . 'one of the queries failed.'), 'IgnoreMultiSubmitErrors_name' => __('Ignore multiple statement errors'), 'Import_allow_interrupt_desc' => __('Allow interrupt of import in case script detects it is close to time limit. ' . 'This might be a good way to import large files, however it can break ' . 'transactions.'), 'enable_drag_drop_import_name' => __('Enable drag and drop import'), 'enable_drag_drop_import_desc' => __('Uncheck the checkbox to disable drag and drop import'), 'Import_allow_interrupt_name' => __('Partial import: allow interrupt'), 'Import_charset_name' => __('Character set of the file'), 'Import_csv_col_names_name' => __('Lines terminated with'), 'Import_csv_enclosed_name' => __('Columns enclosed with'), 'Import_csv_escaped_name' => __('Columns escaped with'), 'Import_csv_ignore_name' => __('Do not abort on INSERT error'), 'Import_csv_replace_name' => __('Add ON DUPLICATE KEY UPDATE'), 'Import_csv_replace_desc' => __('Update data when duplicate keys found on import'), 'Import_csv_terminated_name' => __('Columns terminated with'), 'Import_format_desc' => __('Default format; be aware that this list depends on location (database, table) ' . 'and only SQL is always available.'), 'Import_format_name' => __('Format of imported file'), 'Import_ldi_enclosed_name' => __('Columns enclosed with'), 'Import_ldi_escaped_name' => __('Columns escaped with'), 'Import_ldi_ignore_name' => __('Do not abort on INSERT error'), 'Import_ldi_local_option_name' => __('Use LOCAL keyword'), 'Import_ldi_replace_name' => __('Add ON DUPLICATE KEY UPDATE'), 'Import_ldi_replace_desc' => __('Update data when duplicate keys found on import'), 'Import_ldi_terminated_name' => __('Columns terminated with'), 'Import_ods_col_names_name' => __('Column names in first row'), 'Import_ods_empty_rows_name' => __('Do not import empty rows'), 'Import_ods_recognize_currency_name' => __('Import currencies ($5.00 to 5.00)'), 'Import_ods_recognize_percentages_name' => __('Import percentages as proper decimals (12.00% to .12)'), 'Import_skip_queries_desc' => __('Number of queries to skip from start.'), 'Import_skip_queries_name' => __('Partial import: skip queries'), 'Import_sql_compatibility_name' => __('SQL compatibility mode'), 'Import_sql_no_auto_value_on_zero_name' => __('Do not use AUTO_INCREMENT for zero values'), 'Import_sql_read_as_multibytes_name' => __('Read as multibytes'), 'InitialSlidersState_name' => __('Initial state for sliders'), 'InsertRows_desc' => __('How many rows can be inserted at one time.'), 'InsertRows_name' => __('Number of inserted rows'), 'LimitChars_desc' => __('Maximum number of characters shown in any non-numeric column on browse view.'), 'LimitChars_name' => __('Limit column characters'), 'LoginCookieDeleteAll_desc' => __('If TRUE, logout deletes cookies for all servers; when set to FALSE, logout ' . 'only occurs for the current server. Setting this to FALSE makes it easy to ' . 'forget to log out from other servers when connected to multiple servers.'), 'LoginCookieDeleteAll_name' => __('Delete all cookies on logout'), 'LoginCookieRecall_desc' => __('Define whether the previous login should be recalled or not in ' . '[kbd]cookie[/kbd] authentication mode.'), 'LoginCookieRecall_name' => __('Recall user name'), 'LoginCookieStore_desc' => __('Defines how long (in seconds) a login cookie should be stored in browser. ' . 'The default of 0 means that it will be kept for the existing session only, ' . 'and will be deleted as soon as you close the browser window. This is ' . 'recommended for non-trusted environments.'), 'LoginCookieStore_name' => __('Login cookie store'), 'LoginCookieValidity_desc' => __('Define how long (in seconds) a login cookie is valid.'), 'LoginCookieValidity_name' => __('Login cookie validity'), 'LongtextDoubleTextarea_desc' => __('Double size of textarea for LONGTEXT columns.'), 'LongtextDoubleTextarea_name' => __('Bigger textarea for LONGTEXT'), 'MaxCharactersInDisplayedSQL_desc' => __('Maximum number of characters used when a SQL query is displayed.'), 'MaxCharactersInDisplayedSQL_name' => __('Maximum displayed SQL length'), 'MaxDbList_cmt' => __('Users cannot set a higher value'), 'MaxDbList_desc' => __('Maximum number of databases displayed in database list.'), 'MaxDbList_name' => __('Maximum databases'), 'FirstLevelNavigationItems_desc' => __('The number of items that can be displayed on each page on the first level' . ' of the navigation tree.'), 'FirstLevelNavigationItems_name' => __('Maximum items on first level'), 'MaxNavigationItems_desc' => __('The number of items that can be displayed on each page of the navigation tree.'), 'MaxNavigationItems_name' => __('Maximum items in branch'), 'MaxRows_desc' => __('Number of rows displayed when browsing a result set. If the result set ' . 'contains more rows, "Previous" and "Next" links will be ' . 'shown.'), 'MaxRows_name' => __('Maximum number of rows to display'), 'MaxTableList_cmt' => __('Users cannot set a higher value'), 'MaxTableList_desc' => __('Maximum number of tables displayed in table list.'), 'MaxTableList_name' => __('Maximum tables'), 'MemoryLimit_desc' => __('The number of bytes a script is allowed to allocate, e.g. [kbd]32M[/kbd] ' . '([kbd]-1[/kbd] for no limit and [kbd]0[/kbd] for no change).'), 'MemoryLimit_name' => __('Memory limit'), 'ShowDatabasesNavigationAsTree_desc' => __('In the navigation panel, replaces the database tree with a selector'), 'ShowDatabasesNavigationAsTree_name' => __('Show databases navigation as tree'), 'NavigationWidth_name' => __('Navigation panel width'), 'NavigationWidth_desc' => __('Set to 0 to collapse navigation panel.'), 'NavigationLinkWithMainPanel_desc' => __('Link with main panel by highlighting the current database or table.'), 'NavigationLinkWithMainPanel_name' => __('Link with main panel'), 'NavigationDisplayLogo_desc' => __('Show logo in navigation panel.'), 'NavigationDisplayLogo_name' => __('Display logo'), 'NavigationLogoLink_desc' => __('URL where logo in the navigation panel will point to.'), 'NavigationLogoLink_name' => __('Logo link URL'), 'NavigationLogoLinkWindow_desc' => __('Open the linked page in the main window ([code]main[/code]) or in a new one ' . '([code]new[/code]).'), 'NavigationLogoLinkWindow_name' => __('Logo link target'), 'NavigationDisplayServers_desc' => __('Display server choice at the top of the navigation panel.'), 'NavigationDisplayServers_name' => __('Display servers selection'), 'NavigationTreeDefaultTabTable_name' => __('Target for quick access icon'), 'NavigationTreeDefaultTabTable2_name' => __('Target for second quick access icon'), 'NavigationTreeDisplayItemFilterMinimum_desc' => __('Defines the minimum number of items (tables, views, routines and events) to ' . 'display a filter box.'), 'NavigationTreeDisplayItemFilterMinimum_name' => __('Minimum number of items to display the filter box'), 'NavigationTreeDisplayDbFilterMinimum_name' => __('Minimum number of databases to display the database filter box'), 'NavigationTreeEnableGrouping_desc' => __('Group items in the navigation tree (determined by the separator defined in ' . 'the Databases and Tables tabs above).'), 'NavigationTreeEnableGrouping_name' => __('Group items in the tree'), 'NavigationTreeDbSeparator_desc' => __('String that separates databases into different tree levels.'), 'NavigationTreeDbSeparator_name' => __('Database tree separator'), 'NavigationTreeTableSeparator_desc' => __('String that separates tables into different tree levels.'), 'NavigationTreeTableSeparator_name' => __('Table tree separator'), 'NavigationTreeTableLevel_name' => __('Maximum table tree depth'), 'NavigationTreePointerEnable_desc' => __('Highlight server under the mouse cursor.'), 'NavigationTreePointerEnable_name' => __('Enable highlighting'), 'NavigationTreeEnableExpansion_desc' => __('Whether to offer the possibility of tree expansion in the navigation panel.'), 'NavigationTreeEnableExpansion_name' => __('Enable navigation tree expansion'), 'NavigationTreeShowTables_name' => __('Show tables in tree'), 'NavigationTreeShowTables_desc' => __('Whether to show tables under database in the navigation tree'), 'NavigationTreeShowViews_name' => __('Show views in tree'), 'NavigationTreeShowViews_desc' => __('Whether to show views under database in the navigation tree'), 'NavigationTreeShowFunctions_name' => __('Show functions in tree'), 'NavigationTreeShowFunctions_desc' => __('Whether to show functions under database in the navigation tree'), 'NavigationTreeShowProcedures_name' => __('Show procedures in tree'), 'NavigationTreeShowProcedures_desc' => __('Whether to show procedures under database in the navigation tree'), 'NavigationTreeShowEvents_name' => __('Show events in tree'), 'NavigationTreeShowEvents_desc' => __('Whether to show events under database in the navigation tree'), 'NavigationTreeAutoexpandSingleDb_name' => __('Expand single database'), 'NavigationTreeAutoexpandSingleDb_desc' => __('Whether to expand single database in the navigation tree automatically.'), 'NumRecentTables_desc' => __('Maximum number of recently used tables; set 0 to disable.'), 'NumFavoriteTables_desc' => __('Maximum number of favorite tables; set 0 to disable.'), 'NumRecentTables_name' => __('Recently used tables'), 'NumFavoriteTables_name' => __('Favorite tables'), 'RowActionLinks_desc' => __('These are Edit, Copy and Delete links.'), 'RowActionLinks_name' => __('Where to show the table row links'), 'RowActionLinksWithoutUnique_desc' => __('Whether to show row links even in the absence of a unique key.'), 'RowActionLinksWithoutUnique_name' => __('Show row links anyway'), 'DisableShortcutKeys_name' => __('Disable shortcut keys'), 'DisableShortcutKeys_desc' => __('Disable shortcut keys'), 'NaturalOrder_desc' => __('Use natural order for sorting table and database names.'), 'NaturalOrder_name' => __('Natural order'), 'TableNavigationLinksMode_desc' => __('Use only icons, only text or both.'), 'TableNavigationLinksMode_name' => __('Table navigation bar'), 'OBGzip_desc' => __('Use GZip output buffering for increased speed in HTTP transfers.'), 'OBGzip_name' => __('GZip output buffering'), 'Order_desc' => __('[kbd]SMART[/kbd] - i.e. descending order for columns of type TIME, DATE, ' . 'DATETIME and TIMESTAMP, ascending order otherwise.'), 'Order_name' => __('Default sorting order'), 'PersistentConnections_desc' => __('Use persistent connections to MySQL databases.'), 'PersistentConnections_name' => __('Persistent connections'), 'PmaNoRelation_DisableWarning_desc' => __('Disable the default warning that is displayed on the database details ' . 'Structure page if any of the required tables for the phpMyAdmin ' . 'configuration storage could not be found.'), 'PmaNoRelation_DisableWarning_name' => __('Missing phpMyAdmin configuration storage tables'), 'ReservedWordDisableWarning_desc' => __('Disable the default warning that is displayed on the Structure page if column ' . 'names in a table are reserved MySQL words.'), 'ReservedWordDisableWarning_name' => __('MySQL reserved word warning'), 'TabsMode_desc' => __('Use only icons, only text or both.'), 'TabsMode_name' => __('How to display the menu tabs'), 'ActionLinksMode_desc' => __('Use only icons, only text or both.'), 'ActionLinksMode_name' => __('How to display various action links'), 'ProtectBinary_desc' => __('Disallow BLOB and BINARY columns from editing.'), 'ProtectBinary_name' => __('Protect binary columns'), 'QueryHistoryDB_desc' => __('Enable if you want DB-based query history (requires phpMyAdmin configuration ' . 'storage). If disabled, this utilizes JS-routines to display query history ' . '(lost by window close).'), 'QueryHistoryDB_name' => __('Permanent query history'), 'QueryHistoryMax_cmt' => __('Users cannot set a higher value'), 'QueryHistoryMax_desc' => __('How many queries are kept in history.'), 'QueryHistoryMax_name' => __('Query history length'), 'RecodingEngine_desc' => __('Select which functions will be used for character set conversion.'), 'RecodingEngine_name' => __('Recoding engine'), 'RememberSorting_desc' => __('When browsing tables, the sorting of each table is remembered.'), 'RememberSorting_name' => __('Remember table\'s sorting'), 'TablePrimaryKeyOrder_desc' => __('Default sort order for tables with a primary key.'), 'TablePrimaryKeyOrder_name' => __('Primary key default sort order'), 'RepeatCells_desc' => __('Repeat the headers every X cells, [kbd]0[/kbd] deactivates this feature.'), 'RepeatCells_name' => __('Repeat headers'), 'GridEditing_name' => __('Grid editing: trigger action'), 'RelationalDisplay_name' => __('Relational display'), 'RelationalDisplay_desc' => __('For display Options'), 'SaveCellsAtOnce_name' => __('Grid editing: save all edited cells at once'), 'SaveDir_desc' => __('Directory where exports can be saved on server.'), 'SaveDir_name' => __('Save directory'), 'Servers_AllowDeny_order_desc' => __('Leave blank if not used.'), 'Servers_AllowDeny_order_name' => __('Host authorization order'), 'Servers_AllowDeny_rules_desc' => __('Leave blank for defaults.'), 'Servers_AllowDeny_rules_name' => __('Host authorization rules'), 'Servers_AllowNoPassword_name' => __('Allow logins without a password'), 'Servers_AllowRoot_name' => __('Allow root login'), 'Servers_SessionTimeZone_name' => __('Session timezone'), 'Servers_SessionTimeZone_desc' => __('Sets the effective timezone; possibly different than the one from your ' . 'database server'), 'Servers_auth_http_realm_desc' => __('HTTP Basic Auth Realm name to display when doing HTTP Auth.'), 'Servers_auth_http_realm_name' => __('HTTP Realm'), 'Servers_auth_type_desc' => __('Authentication method to use.'), 'Servers_auth_type_name' => __('Authentication type'), 'Servers_bookmarktable_desc' => __('Leave blank for no [doc@bookmarks@]bookmark[/doc] ' . 'support, suggested: [kbd]pma__bookmark[/kbd]'), 'Servers_bookmarktable_name' => __('Bookmark table'), 'Servers_column_info_desc' => __('Leave blank for no column comments/media types, suggested: ' . '[kbd]pma__column_info[/kbd].'), 'Servers_column_info_name' => __('Column information table'), 'Servers_compress_desc' => __('Compress connection to MySQL server.'), 'Servers_compress_name' => __('Compress connection'), 'Servers_controlpass_name' => __('Control user password'), 'Servers_controluser_desc' => __('A special MySQL user configured with limited permissions, more information ' . 'available on [doc@linked-tables]documentation[/doc].'), 'Servers_controluser_name' => __('Control user'), 'Servers_controlhost_desc' => __('An alternate host to hold the configuration storage; leave blank to use the ' . 'already defined host.'), 'Servers_controlhost_name' => __('Control host'), 'Servers_controlport_desc' => __('An alternate port to connect to the host that holds the configuration storage; ' . 'leave blank to use the default port, or the already defined port, if the ' . 'controlhost equals host.'), 'Servers_controlport_name' => __('Control port'), 'Servers_hide_db_desc' => __('Hide databases matching regular expression (PCRE).'), 'Servers_DisableIS_desc' => __('More information on [a@https://github.com/phpmyadmin/phpmyadmin/issues/8970]phpMyAdmin ' . 'issue tracker[/a] and [a@https://bugs.mysql.com/19588]MySQL Bugs[/a]'), 'Servers_DisableIS_name' => __('Disable use of INFORMATION_SCHEMA'), 'Servers_hide_db_name' => __('Hide databases'), 'Servers_history_desc' => __('Leave blank for no SQL query history support, suggested: ' . '[kbd]pma__history[/kbd].'), 'Servers_history_name' => __('SQL query history table'), 'Servers_host_desc' => __('Hostname where MySQL server is running.'), 'Servers_host_name' => __('Server hostname'), 'Servers_LogoutURL_name' => __('Logout URL'), 'Servers_MaxTableUiprefs_desc' => __('Limits number of table preferences which are stored in database, the oldest ' . 'records are automatically removed.'), 'Servers_MaxTableUiprefs_name' => __('Maximal number of table preferences to store'), 'Servers_savedsearches_name' => __('QBE saved searches table'), 'Servers_savedsearches_desc' => __('Leave blank for no QBE saved searches support, suggested: ' . '[kbd]pma__savedsearches[/kbd].'), 'Servers_export_templates_name' => __('Export templates table'), 'Servers_export_templates_desc' => __('Leave blank for no export template support, suggested: ' . '[kbd]pma__export_templates[/kbd].'), 'Servers_central_columns_name' => __('Central columns table'), 'Servers_central_columns_desc' => __('Leave blank for no central columns support, suggested: ' . '[kbd]pma__central_columns[/kbd].'), 'Servers_only_db_desc' => __('You can use MySQL wildcard characters (% and _), escape them if you want to ' . 'use their literal instances, i.e. use [kbd]\'my\_db\'[/kbd] and not ' . '[kbd]\'my_db\'[/kbd].'), 'Servers_only_db_name' => __('Show only listed databases'), 'Servers_password_desc' => __('Leave empty if not using config auth.'), 'Servers_password_name' => __('Password for config auth'), 'Servers_pdf_pages_desc' => __('Leave blank for no PDF schema support, suggested: [kbd]pma__pdf_pages[/kbd].'), 'Servers_pdf_pages_name' => __('PDF schema: pages table'), 'Servers_pmadb_desc' => __('Database used for relations, bookmarks, and PDF features. See ' . '[doc@linked-tables]pmadb[/doc] for complete information. ' . 'Leave blank for no support. Suggested: [kbd]phpmyadmin[/kbd].'), 'Servers_pmadb_name' => __('Database name'), 'Servers_port_desc' => __('Port on which MySQL server is listening, leave empty for default.'), 'Servers_port_name' => __('Server port'), 'Servers_recent_desc' => __('Leave blank for no "persistent" recently used tables across sessions, ' . 'suggested: [kbd]pma__recent[/kbd].'), 'Servers_recent_name' => __('Recently used table'), 'Servers_favorite_desc' => __('Leave blank for no "persistent" favorite tables across sessions, ' . 'suggested: [kbd]pma__favorite[/kbd].'), 'Servers_favorite_name' => __('Favorites table'), 'Servers_relation_desc' => __('Leave blank for no ' . '[doc@relations@]relation-links[/doc] support, ' . 'suggested: [kbd]pma__relation[/kbd].'), 'Servers_relation_name' => __('Relation table'), 'Servers_SignonSession_desc' => __('See [doc@authentication-modes]authentication ' . 'types[/doc] for an example.'), 'Servers_SignonSession_name' => __('Signon session name'), 'Servers_SignonURL_name' => __('Signon URL'), 'Servers_socket_desc' => __('Socket on which MySQL server is listening, leave empty for default.'), 'Servers_socket_name' => __('Server socket'), 'Servers_ssl_desc' => __('Enable SSL for connection to MySQL server.'), 'Servers_ssl_name' => __('Use SSL'), 'Servers_table_coords_desc' => __('Leave blank for no PDF schema support, suggested: [kbd]pma__table_coords[/kbd].'), 'Servers_table_coords_name' => __('Designer and PDF schema: table coordinates'), 'Servers_table_info_desc' => __('Table to describe the display columns, leave blank for no support; ' . 'suggested: [kbd]pma__table_info[/kbd].'), 'Servers_table_info_name' => __('Display columns table'), 'Servers_table_uiprefs_desc' => __('Leave blank for no "persistent" tables\' UI preferences across sessions, ' . 'suggested: [kbd]pma__table_uiprefs[/kbd].'), 'Servers_table_uiprefs_name' => __('UI preferences table'), 'Servers_tracking_add_drop_database_desc' => __('Whether a DROP DATABASE IF EXISTS statement will be added as first line to ' . 'the log when creating a database.'), 'Servers_tracking_add_drop_database_name' => __('Add DROP DATABASE'), 'Servers_tracking_add_drop_table_desc' => __('Whether a DROP TABLE IF EXISTS statement will be added as first line to the ' . 'log when creating a table.'), 'Servers_tracking_add_drop_table_name' => __('Add DROP TABLE'), 'Servers_tracking_add_drop_view_desc' => __('Whether a DROP VIEW IF EXISTS statement will be added as first line to the ' . 'log when creating a view.'), 'Servers_tracking_add_drop_view_name' => __('Add DROP VIEW'), 'Servers_tracking_default_statements_desc' => __('Defines the list of statements the auto-creation uses for new versions.'), 'Servers_tracking_default_statements_name' => __('Statements to track'), 'Servers_tracking_desc' => __('Leave blank for no SQL query tracking support, suggested: ' . '[kbd]pma__tracking[/kbd].'), 'Servers_tracking_name' => __('SQL query tracking table'), 'Servers_tracking_version_auto_create_desc' => __('Whether the tracking mechanism creates versions for tables and views ' . 'automatically.'), 'Servers_tracking_version_auto_create_name' => __('Automatically create versions'), 'Servers_userconfig_desc' => __('Leave blank for no user preferences storage in database, suggested: ' . '[kbd]pma__userconfig[/kbd].'), 'Servers_userconfig_name' => __('User preferences storage table'), 'Servers_users_desc' => __('Both this table and the user groups table are required to enable the ' . 'configurable menus feature; leaving either one of them blank will disable ' . 'this feature, suggested: [kbd]pma__users[/kbd].'), 'Servers_users_name' => __('Users table'), 'Servers_usergroups_desc' => __('Both this table and the users table are required to enable the configurable ' . 'menus feature; leaving either one of them blank will disable this feature, ' . 'suggested: [kbd]pma__usergroups[/kbd].'), 'Servers_usergroups_name' => __('User groups table'), 'Servers_navigationhiding_desc' => __('Leave blank to disable the feature to hide and show navigation items, ' . 'suggested: [kbd]pma__navigationhiding[/kbd].'), 'Servers_navigationhiding_name' => __('Hidden navigation items table'), 'Servers_user_desc' => __('Leave empty if not using config auth.'), 'Servers_user_name' => __('User for config auth'), 'Servers_verbose_desc' => __('A user-friendly description of this server. Leave blank to display the ' . 'hostname instead.'), 'Servers_verbose_name' => __('Verbose name of this server'), 'ShowAll_desc' => __('Whether a user should be displayed a "show all (rows)" button.'), 'ShowAll_name' => __('Allow to display all the rows'), 'ShowChgPassword_desc' => __('Please note that enabling this has no effect with [kbd]config[/kbd] ' . 'authentication mode because the password is hard coded in the configuration ' . 'file; this does not limit the ability to execute the same command directly.'), 'ShowChgPassword_name' => __('Show password change form'), 'ShowCreateDb_name' => __('Show create database form'), 'ShowDbStructureComment_desc' => __('Show or hide a column displaying the comments for all tables.'), 'ShowDbStructureComment_name' => __('Show table comments'), 'ShowDbStructureCreation_desc' => __('Show or hide a column displaying the Creation timestamp for all tables.'), 'ShowDbStructureCreation_name' => __('Show creation timestamp'), 'ShowDbStructureLastUpdate_desc' => __('Show or hide a column displaying the Last update timestamp for all tables.'), 'ShowDbStructureLastUpdate_name' => __('Show last update timestamp'), 'ShowDbStructureLastCheck_desc' => __('Show or hide a column displaying the Last check timestamp for all tables.'), 'ShowDbStructureLastCheck_name' => __('Show last check timestamp'), 'ShowDbStructureCharset_desc' => __('Show or hide a column displaying the charset for all tables.'), 'ShowDbStructureCharset_name' => __('Show table charset'), 'ShowFieldTypesInDataEditView_desc' => __('Defines whether or not type fields should be initially displayed in ' . 'edit/insert mode.'), 'ShowFieldTypesInDataEditView_name' => __('Show field types'), 'ShowFunctionFields_desc' => __('Display the function fields in edit/insert mode.'), 'ShowFunctionFields_name' => __('Show function fields'), 'ShowHint_desc' => __('Whether to show hint or not.'), 'ShowHint_name' => __('Show hint'), 'ShowPhpInfo_desc' => __('Shows link to [a@https://php.net/manual/function.phpinfo.php]phpinfo()[/a] ' . 'output.'), 'ShowPhpInfo_name' => __('Show phpinfo() link'), 'ShowServerInfo_name' => __('Show detailed MySQL server information'), 'ShowSQL_desc' => __('Defines whether SQL queries generated by phpMyAdmin should be displayed.'), 'ShowSQL_name' => __('Show SQL queries'), 'RetainQueryBox_desc' => __('Defines whether the query box should stay on-screen after its submission.'), 'RetainQueryBox_name' => __('Retain query box'), 'ShowStats_desc' => __('Allow to display database and table statistics (e.g. space usage).'), 'ShowStats_name' => __('Show statistics'), 'SkipLockedTables_desc' => __('Mark used tables and make it possible to show databases with locked tables.'), 'SkipLockedTables_name' => __('Skip locked tables'), 'SQLQuery_Edit_name' => __('Edit'), 'SQLQuery_Explain_name' => __('Explain SQL'), 'SQLQuery_Refresh_name' => __('Refresh'), 'SQLQuery_ShowAsPHP_name' => __('Create PHP code'), 'SuhosinDisableWarning_desc' => __('Disable the default warning that is displayed on the main page if Suhosin is ' . 'detected.'), 'SuhosinDisableWarning_name' => __('Suhosin warning'), 'LoginCookieValidityDisableWarning_desc' => __('Disable the default warning that is displayed on the main page if the value ' . 'of the PHP setting session.gc_maxlifetime is less than the value of ' . '`LoginCookieValidity`.'), 'LoginCookieValidityDisableWarning_name' => __('Login cookie validity warning'), 'TextareaCols_desc' => __('Textarea size (columns) in edit mode, this value will be emphasized for SQL ' . 'query textareas (*2).'), 'TextareaCols_name' => __('Textarea columns'), 'TextareaRows_desc' => __('Textarea size (rows) in edit mode, this value will be emphasized for SQL ' . 'query textareas (*2).'), 'TextareaRows_name' => __('Textarea rows'), 'TitleDatabase_desc' => __('Title of browser window when a database is selected.'), 'TitleDatabase_name' => __('Database'), 'TitleDefault_desc' => __('Title of browser window when nothing is selected.'), 'TitleDefault_name' => __('Default title'), 'TitleServer_desc' => __('Title of browser window when a server is selected.'), 'TitleServer_name' => __('Server'), 'TitleTable_desc' => __('Title of browser window when a table is selected.'), 'TitleTable_name' => __('Table'), 'TrustedProxies_desc' => __('Input proxies as [kbd]IP: trusted HTTP header[/kbd]. The following example ' . 'specifies that phpMyAdmin should trust a HTTP_X_FORWARDED_FOR ' . '(X-Forwarded-For) header coming from the proxy 1.2.3.4:[br][kbd]1.2.3.4: ' . 'HTTP_X_FORWARDED_FOR[/kbd].'), 'TrustedProxies_name' => __('List of trusted proxies for IP allow/deny'), 'UploadDir_desc' => __('Directory on server where you can upload files for import.'), 'UploadDir_name' => __('Upload directory'), 'UseDbSearch_desc' => __('Allow for searching inside the entire database.'), 'UseDbSearch_name' => __('Use database search'), 'UserprefsDeveloperTab_desc' => __('When disabled, users cannot set any of the options below, regardless of the ' . 'checkbox on the right.'), 'UserprefsDeveloperTab_name' => __('Enable the Developer tab in settings'), 'VersionCheck_desc' => __('Enables check for latest version on main phpMyAdmin page.'), 'VersionCheck_name' => __('Version check'), 'ProxyUrl_desc' => __('The url of the proxy to be used when retrieving the information about the ' . 'latest version of phpMyAdmin or when submitting error reports. You need this ' . 'if the server where phpMyAdmin is installed does not have direct access to ' . 'the internet. The format is: "hostname:portnumber".'), 'ProxyUrl_name' => __('Proxy url'), 'ProxyUser_desc' => __('The username for authenticating with the proxy. By default, no ' . 'authentication is performed. If a username is supplied, Basic ' . 'Authentication will be performed. No other types of authentication are ' . 'currently supported.'), 'ProxyUser_name' => __('Proxy username'), 'ProxyPass_desc' => __('The password for authenticating with the proxy.'), 'ProxyPass_name' => __('Proxy password'), 'ZipDump_desc' => __('Enable ZIP compression for import and export operations.'), 'ZipDump_name' => __('ZIP'), 'CaptchaLoginPublicKey_desc' => __('Enter your public key for your domain reCaptcha service.'), 'CaptchaLoginPublicKey_name' => __('Public key for reCaptcha'), 'CaptchaLoginPrivateKey_desc' => __('Enter your private key for your domain reCaptcha service.'), 'CaptchaLoginPrivateKey_name' => __('Private key for reCaptcha'), 'CaptchaSiteVerifyURL_desc' => __('Enter your siteverify URL for your reCaptcha service.'), 'CaptchaSiteVerifyURL_name' => __('URL for reCaptcha siteverify'), 'SendErrorReports_desc' => __('Choose the default action when sending error reports.'), 'SendErrorReports_name' => __('Send error reports'), 'ConsoleEnterExecutes_desc' => __('Queries are executed by pressing Enter (instead of Ctrl+Enter). New lines ' . 'will be inserted with Shift+Enter.'), 'ConsoleEnterExecutes_name' => __('Enter executes queries in console'), 'ZeroConf_desc' => __('Enable Zero Configuration mode which lets you setup phpMyAdmin ' . 'configuration storage tables automatically.'), 'ZeroConf_name' => __('Enable Zero Configuration mode'), 'Console_StartHistory_name' => __('Show query history at start'), 'Console_AlwaysExpand_name' => __('Always expand query messages'), 'Console_CurrentQuery_name' => __('Show current browsing query'), 'Console_EnterExecutes_name' => __('Execute queries on Enter and insert new line with Shift + Enter'), 'Console_DarkTheme_name' => __('Switch to dark theme'), 'Console_Height_name' => __('Console height'), 'Console_Mode_name' => __('Console mode'), 'Console_GroupQueries_name' => __('Group queries'), 'Console_Order_name' => __('Order'), 'Console_OrderBy_name' => __('Order by'), 'DefaultConnectionCollation_name' => __('Server connection collation'), ] |
/libraries/classes/Config/Validator.php:360 | 1 | $test = static::testDBConnection(empty($values['Servers/1/host']) ? '' : $values['Servers/1/host'], empty($values['Servers/1/port']) ? '' : $values['Servers/1/port'], empty($values['Servers/1/socket']) ? '' : $values['Servers/1/socket'], empty($values['Servers/1/controluser']) ? '' : $values['Servers/1/controluser'], empty($values['Servers/1/controlpass']) ? '' : $values['Servers/1/controlpass'], 'Server_pmadb') |
/libraries/classes/Database/Designer/Common.php:780 | 1 | $delete_query = 'DELETE FROM ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . $GLOBALS['cfgRelation']['relation'] . ' WHERE ' . "master_db = '" . $this->dbi->escapeString($DB2) . "'" . " AND master_table = '" . $this->dbi->escapeString($T2) . "'" . " AND master_field = '" . $this->dbi->escapeString($F2) . "'" . " AND foreign_db = '" . $this->dbi->escapeString($DB1) . "'" . " AND foreign_table = '" . $this->dbi->escapeString($T1) . "'" . " AND foreign_field = '" . $this->dbi->escapeString($F1) . "'" |
/libraries/classes/Database/Designer/Common.php:699 | 1 | $q = 'INSERT INTO ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($GLOBALS['cfgRelation']['relation']) . '(master_db, master_table, master_field, ' . 'foreign_db, foreign_table, foreign_field)' . ' values(' . "'" . $this->dbi->escapeString($DB2) . "', " . "'" . $this->dbi->escapeString($T2) . "', " . "'" . $this->dbi->escapeString($F2) . "', " . "'" . $this->dbi->escapeString($DB1) . "', " . "'" . $this->dbi->escapeString($T1) . "', " . "'" . $this->dbi->escapeString($F1) . "')" |
/libraries/classes/Database/Designer/Common.php:858 | 1 | $query = 'INSERT INTO ' . Util::backquote($cfgDesigner['db']) . '.' . Util::backquote($cfgDesigner['table']) . ' (username, settings_data)' . " VALUES('" . $this->dbi->escapeString($cfgDesigner['user']) . "', '" . json_encode($save_data) . "');" |
/libraries/classes/Database/Designer/Common.php:847 | 1 | $save_query = 'UPDATE ' . Util::backquote($cfgDesigner['db']) . '.' . Util::backquote($cfgDesigner['table']) . " SET settings_data = '" . $orig_data . "'" . " WHERE username = '" . $this->dbi->escapeString($cfgDesigner['user']) . "';" |
/libraries/classes/Database/Designer/Common.php:378 | 1 | $query = 'SELECT `page_nr`' . ' FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['pdf_pages']) . " WHERE `db_name` = '" . $this->dbi->escapeString($db) . "'" . " AND `page_descr` = '" . $this->dbi->escapeString($db) . "'" |
/libraries/classes/Database/Routines.php:1829 | 1 | $where = 'ROUTINE_SCHEMA ' . Util::getCollateForIS( ) . '=' . "'" . $this->dbi->escapeString($db) . "' " . "AND SPECIFIC_NAME='" . $this->dbi->escapeString($routine['name']) . "'" . "AND ROUTINE_TYPE='" . $this->dbi->escapeString($routine['type']) . "'" |
/libraries/classes/Database/Designer/Common.php:650 | 1 | $upd_query = 'ALTER TABLE ' . Util::backquote($DB2) . '.' . Util::backquote($T2) . ' ADD FOREIGN KEY (' . Util::backquote($F2) . ')' . ' REFERENCES ' . Util::backquote($DB1) . '.' . Util::backquote($T1) . '(' . Util::backquote($F1) . ')' |
/libraries/classes/Database/Designer/Common.php:532 | 1 | $query = 'INSERT INTO ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['table_coords']) . ' (`db_name`, `table_name`, `pdf_page_number`, `x`, `y`)' . ' VALUES (' . "'" . $this->dbi->escapeString($DB) . "', " . "'" . $this->dbi->escapeString($TAB) . "', " . "'" . $pageId . "', " . "'" . $this->dbi->escapeString($_POST['t_x'][$key]) . "', " . "'" . $this->dbi->escapeString($_POST['t_y'][$key]) . "')" |
/libraries/classes/Database/Routines.php:442 | 1 | $adjustProcPrivilege = 'INSERT INTO ' . Util::backquote('mysql') . '.' . Util::backquote('procs_priv') . ' VALUES("' . $priv[0] . '", "' . $priv[1] . '", "' . $priv[2] . '", "' . $_POST['item_name'] . '", "' . $_POST['item_type'] . '", "' . $priv[5] . '", "' . $priv[6] . '", "' . $priv[7] . '");' |
/libraries/classes/Database/Designer.php:170 | 1 | $query = 'SELECT `settings_data` FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['designer_settings']) . ' WHERE ' . Util::backquote('username') . ' = "' . $dbi->escapeString($GLOBALS['cfg']['Server']['user']) . '";' |
/libraries/classes/Database/Routines.php:981 | 1 | $retval .= '<option value="' . $charset->getName( ) . '" title="' . $charset->getDescription( ) . '"' . ($routine['item_returnopts_text'] == $charset->getName( ) ? ' selected' : '') . '>' . $charset->getName( ) . '</option>' . "\n" |
/libraries/classes/Database/Routines.php:633 | 1 | $where = 'ROUTINE_SCHEMA ' . Util::getCollateForIS( ) . '=' . "'" . $this->dbi->escapeString($db) . "' " . "AND SPECIFIC_NAME='" . $this->dbi->escapeString($name) . "'" . "AND ROUTINE_TYPE='" . $this->dbi->escapeString($type) . "'" |
/libraries/classes/Plugins/Export/ExportLatex.php:634 | 1 | $local_buffer = $col_as . "\000" . $type . "\000" . ($row['Null'] == '' || $row['Null'] == 'NO' ? __('No') : __('Yes')) . "\000" . ($row['Default'] ?? '') |
/libraries/classes/Plugins/Export/ExportSql.php:755 | 1 | $head .= $this->exportComment(__('Generation Time:') . ' ' . Util::localisedDate( )) . $this->exportComment(__('Server version:') . ' ' . $GLOBALS['dbi']->getVersionString( )) . $this->exportComment(__('PHP Version:') . ' ' . PHP_VERSION) . $this->possibleCRLF( ) |
/libraries/classes/Plugins/Export/ExportSql.php:1158 | 1 | $sql_query = 'SELECT `page_nr`, `page_descr` FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation[$type]) . ' WHERE ' . Util::backquote($dbNameColumn) . " = '" . $GLOBALS['dbi']->escapeString($db) . "'" |
/libraries/classes/Plugins/Export/ExportSql.php:1172 | 1 | $sql_query_row = 'SELECT `db_name`, `page_descr` FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation[$type]) . ' WHERE ' . Util::backquote($dbNameColumn) . " = '" . $GLOBALS['dbi']->escapeString($db) . "'" . " AND `page_nr` = '" . intval($page) . "'" |
/libraries/classes/Plugins/Export/ExportOdt.php:612 | 1 | $GLOBALS['odt_buffer'] .= '<table:table' . ' table:name="' . htmlspecialchars($table_alias) . '_triggers">' . '<table:table-column' . ' table:number-columns-repeated="4"/>' . '<table:table-row>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Name') . '</text:p>' . '</table:table-cell>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Time') . '</text:p>' . '</table:table-cell>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Event') . '</text:p>' . '</table:table-cell>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Definition') . '</text:p>' . '</table:table-cell>' . '</table:table-row>' |
/libraries/classes/Plugins/Export/ExportLatex.php:220 | 1 | $head .= $crlf . '% ' . __('Generation Time:') . ' ' . Util::localisedDate( ) . $crlf . '% ' . __('Server version:') . ' ' . $GLOBALS['dbi']->getVersionString( ) . $crlf . '% ' . __('PHP Version:') . ' ' . PHP_VERSION . $crlf |
/libraries/classes/Plugins/Export/ExportLatex.php:337 | 1 | $buffer .= ' \\caption{' . Util::expandUserString($GLOBALS['latex_data_caption'], ['texEscape', static::class, ], ['table' => $table_alias, 'database' => $db_alias, ]) . '} \\label{' . Util::expandUserString($GLOBALS['latex_data_label'], null, ['table' => $table_alias, 'database' => $db_alias, ]) . '} \\\\' |
/libraries/classes/Plugins/Export/ExportLatex.php:568 | 1 | $buffer .= ' \\caption{' . Util::expandUserString($GLOBALS['latex_structure_caption'], ['texEscape', static::class, ], ['table' => $table_alias, 'database' => $db_alias, ]) . '} \\label{' . Util::expandUserString($GLOBALS['latex_structure_label'], null, ['table' => $table_alias, 'database' => $db_alias, ]) . '} \\\\' . $crlf |
/libraries/classes/Plugins/Schema/Pdf/PdfRelationSchema.php:768 | 1 | $diagram_row = [$field_name, $type, $attribute, $row['Null'] == '' || $row['Null'] == 'NO' ? __('No') : __('Yes'), $row['Default'] ?? '', $row['Extra'], $linksTo, $comments[$field_name] ?? '', isset($mime_map, $mime_map[$field_name]) ? str_replace('_', '/', $mime_map[$field_name]['mimetype']) : '', ] |
/libraries/classes/Plugins/Schema/Pdf/Pdf.php:277 | 1 | $test_query = 'SELECT * FROM ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($GLOBALS['cfgRelation']['pdf_pages']) . ' WHERE db_name = \'' . $GLOBALS['dbi']->escapeString($this->_db) . '\' AND page_nr = \'' . $this->_pageNumber . '\'' |
/libraries/classes/Plugins/Schema/Eps/EpsRelationSchema.php:75 | 1 | $this->_tables[$table] = new TableStatsEps($this->diagram, $this->db, $table, $this->diagram->getFont( ), $this->diagram->getFontSize( ), $this->pageNumber, $this->_tablewidth, $this->showKeys, $this->tableDimension, $this->offline) |
/libraries/classes/Plugins/Export/ExportOdt.php:392 | 1 | $GLOBALS['odt_buffer'] .= '<table:table-row>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Column') . '</text:p>' . '</table:table-cell>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Type') . '</text:p>' . '</table:table-cell>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Null') . '</text:p>' . '</table:table-cell>' . '<table:table-cell office:value-type="string">' . '<text:p>' . __('Default') . '</text:p>' . '</table:table-cell>' . '</table:table-row>' |
/libraries/classes/Config/ServerConfigChecks.php:70 | 1 | $sAllowArbitraryServerWarn = sprintf(__('This %soption%s should be disabled as it allows attackers to ' . 'bruteforce login to any MySQL server. If you feel this is necessary, ' . 'use %srestrict login to MySQL server%s or %strusted proxies list%s. ' . 'However, IP-based protection with trusted proxies list may not be ' . 'reliable if your IP belongs to an ISP where thousands of users, ' . 'including you, are connected to.'), '[a@' . Url::getCommon(['page' => 'form', 'formset' => 'Features']) . '#tab_Security]', '[/a]', '[a@' . Url::getCommon(['page' => 'form', 'formset' => 'Features']) . '#tab_Security]', '[/a]', '[a@' . Url::getCommon(['page' => 'form', 'formset' => 'Features']) . '#tab_Security]', '[/a]') |
/libraries/classes/Config/ServerConfigChecks.php:173 | 1 | $sSecurityInfoMsg = Sanitize::sanitizeMessage(sprintf(__('If you feel this is necessary, use additional protection settings - ' . '%1$shost authentication%2$s settings and %3$strusted proxies list%4%s. ' . 'However, IP-based protection may not be reliable if your IP belongs ' . 'to an ISP where thousands of users, including you, are connected to.'), '[a@' . Url::getCommon(['page' => 'servers', 'mode' => 'edit', 'id' => $i]) . '#tab_Server_config]', '[/a]', '[a@' . Url::getCommon(['page' => 'form', 'formset' => 'Features']) . '#tab_Security]', '[/a]')) |
/libraries/classes/Plugins/Transformations/Abs/ImageUploadTransformationsPlugin.php:85 | 1 | $html .= '<img src="' . $src . '" width="' . (isset($options[0]) ? intval($options[0]) : '100') . '" height="' . (isset($options[1]) ? intval($options[1]) : '100') . '" alt="' . __('Image preview here') . '">' |
/libraries/classes/Plugins/Schema/Svg/SvgRelationSchema.php:77 | 1 | $this->_tables[$table] = new TableStatsSvg($this->diagram, $this->db, $table, $this->diagram->getFont( ), $this->diagram->getFontSize( ), $this->pageNumber, $this->_tablewidth, $this->showKeys, $this->tableDimension, $this->offline) |
/libraries/classes/RelationCleanup.php:158 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['table_uiprefs']) . ' WHERE db_name = \'' . $this->dbi->escapeString($db) . '\'' . ' AND table_name = \'' . $this->dbi->escapeString($table) . '\'' |
/libraries/classes/RelationCleanup.php:147 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['relation']) . ' WHERE foreign_db = \'' . $this->dbi->escapeString($db) . '\'' . ' AND foreign_table = \'' . $this->dbi->escapeString($table) . '\'' |
/libraries/classes/RelationCleanup.php:138 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['relation']) . ' WHERE master_db = \'' . $this->dbi->escapeString($db) . '\'' . ' AND master_table = \'' . $this->dbi->escapeString($table) . '\'' |
/libraries/classes/RelationCleanup.php:128 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['table_coords']) . ' WHERE db_name = \'' . $this->dbi->escapeString($db) . '\'' . ' AND table_name = \'' . $this->dbi->escapeString($table) . '\'' |
/libraries/classes/RelationCleanup.php:118 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['table_info']) . ' WHERE db_name = \'' . $this->dbi->escapeString($db) . '\'' . ' AND table_name = \'' . $this->dbi->escapeString($table) . '\'' |
/libraries/classes/RelationCleanup.php:108 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['column_info']) . ' WHERE db_name = \'' . $this->dbi->escapeString($db) . '\'' . ' AND table_name = \'' . $this->dbi->escapeString($table) . '\'' |
/libraries/classes/RelationCleanup.php:83 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['relation']) . ' WHERE foreign_db = \'' . $this->dbi->escapeString($db) . '\'' . ' AND foreign_table = \'' . $this->dbi->escapeString($table) . '\'' . ' AND foreign_field = \'' . $this->dbi->escapeString($column) . '\'' |
/libraries/classes/RelationCleanup.php:72 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['relation']) . ' WHERE master_db = \'' . $this->dbi->escapeString($db) . '\'' . ' AND master_table = \'' . $this->dbi->escapeString($table) . '\'' . ' AND master_field = \'' . $this->dbi->escapeString($column) . '\'' |
/libraries/classes/RelationCleanup.php:57 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['table_info']) . ' WHERE db_name = \'' . $this->dbi->escapeString($db) . '\'' . ' AND table_name = \'' . $this->dbi->escapeString($table) . '\'' . ' AND display_field = \'' . $this->dbi->escapeString($column) . '\'' |
/libraries/classes/RelationCleanup.php:45 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['column_info']) . ' WHERE db_name = \'' . $this->dbi->escapeString($db) . '\'' . ' AND table_name = \'' . $this->dbi->escapeString($table) . '\'' . ' AND column_name = \'' . $this->dbi->escapeString($column) . '\'' |
/libraries/classes/Normalization.php:659 | 1 | $html .= '<p><input type="text" name="' . htmlspecialchars($tableName) . '" value="' . htmlspecialchars($tableName) . '">' . '( <u>' . htmlspecialchars($key) . '</u>' . (count($dependents) > 0 ? ', ' : '') . htmlspecialchars(implode(', ', $dependents)) . ' )' |
/libraries/classes/Normalization.php:566 | 1 | $queries[] = 'CREATE TABLE ' . Util::backquote($tablesName->$key) . ' SELECT DISTINCT ' . $backquotedKey . (count($dependents) > 0 ? ', ' : '') . implode(',', Util::backquote($dependents)) . ' FROM ' . Util::backquote($table) . ';' |
/libraries/classes/Normalization.php:522 | 1 | $html .= '<p><input type="text" name="' . htmlspecialchars($key) . '" value="' . htmlspecialchars($tableName) . '">' . '( <u>' . htmlspecialchars($key) . '</u>' . (count($dependents) > 0 ? ', ' : '') . htmlspecialchars(implode(', ', $dependents)) . ' )' |
/libraries/classes/Normalization.php:229 | 1 | $html .= "<div id='mainContent' data-normalizeto='" . $normalizedTo . "'>" . '<fieldset>' . '<legend>' . __('Step 1.') . $step . ' ' . $stepTxt . '</legend>' . '<h4>' . __('Do you have any column which can be split into more than' . ' one column? ' . 'For example: address can be split into street, city, country and zip.') . "<br>(<a class='central_columns_dialog' data-maxrows='25' " . "data-pick=false href='#'> " . __('Show me the central list of columns that are not already in this table') . ' </a>)</h4>' . "<p class='cm-em'>" . __('Select a column which can be split into more ' . 'than one (on select of \'no such column\', it\'ll move to next step).') . '</p>' . "<div id='extra'>" . "<select id='selectNonAtomicCol' name='makeAtomic'>" . '<option selected="selected" disabled="disabled">' . __('Select one…') . '</option>' . "<option value='no_such_col'>" . __('No such column') . '</option>' . $this->getHtmlForColumnsList($db, $table, _pgettext('string types', 'String')) . '</select>' . '<span>' . __('split into ') . "</span><input id='numField' type='number' value='2'>" . '<input type="submit" class="btn btn-primary" id="splitGo" value="' . __('Go') . '"></div>' . "<div id='newCols'></div>" . "</fieldset><fieldset class='tblFooters'>" . '</fieldset>' . '</div>' |
/libraries/classes/Normalization.php:156 | 1 | $contentCells[$columnNumber] = ['column_number' => $columnNumber, 'column_meta' => $columnMeta, 'type_upper' => '', 'length_values_input_size' => 8, 'length' => '', 'extracted_columnspec' => [ ], 'submit_attribute' => null, 'comments_map' => $commentsMap, 'fields_meta' => null, 'is_backup' => true, 'move_columns' => [ ], 'cfg_relation' => $cfgRelation, 'available_mime' => $availableMime, 'mime_map' => $mimeMap, ] |
/libraries/classes/Transformations.php:438 | 1 | $upd_query = 'INSERT INTO ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['column_info']) . ' (db_name, table_name, column_name, mimetype, ' . 'transformation, transformation_options, ' . 'input_transformation, input_transformation_options) ' . ' VALUES(' . '\'' . $GLOBALS['dbi']->escapeString($db) . '\',' . '\'' . $GLOBALS['dbi']->escapeString($table) . '\',' . '\'' . $GLOBALS['dbi']->escapeString($key) . '\',' . '\'' . $GLOBALS['dbi']->escapeString($mimetype) . '\',' . '\'' . $GLOBALS['dbi']->escapeString($transformation) . '\',' . '\'' . $GLOBALS['dbi']->escapeString($transformationOpts) . '\',' . '\'' . $GLOBALS['dbi']->escapeString($inputTransform) . '\',' . '\'' . $GLOBALS['dbi']->escapeString($inputTransformOpts) . '\')' |
/libraries/classes/Table.php:2638 | 1 | $sql_query_recreate .= $this->getSQLToCreateForeignKey($table, $master_field, $existrel_foreign[$master_field_md5]['ref_db_name'], $existrel_foreign[$master_field_md5]['ref_table_name'], $existrel_foreign[$master_field_md5]['ref_index_list'], $existrel_foreign[$master_field_md5]['constraint'], $options_array[$existrel_foreign[$master_field_md5]['on_delete'] ?? ''] ?? null, $options_array[$existrel_foreign[$master_field_md5]['on_update'] ?? ''] ?? null) |
/libraries/classes/Table.php:2700 | 1 | $sql_query .= ' FOREIGN KEY (' . implode(', ', $field) . ') REFERENCES ' . ($this->_db_name != $foreignDb ? Util::backquote($foreignDb) . '.' : '') . Util::backquote($foreignTable) . '(' . implode(', ', $foreignField) . ')' |
/libraries/classes/Table.php:2409 | 1 | $upd_query = 'UPDATE ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($cfgRelation['relation']) . ' SET foreign_db = \'' . $this->_dbi->escapeString($foreign_db) . '\', ' . ' foreign_table = \'' . $this->_dbi->escapeString($foreign_table) . '\', ' . ' foreign_field = \'' . $this->_dbi->escapeString($foreign_field) . '\' ' . ' WHERE master_db = \'' . $this->_dbi->escapeString($this->_db_name) . '\'' . ' AND master_table = \'' . $this->_dbi->escapeString($this->_name) . '\'' . ' AND master_field = \'' . $this->_dbi->escapeString($master_field) . '\'' |
/libraries/classes/Table.php:2426 | 1 | $upd_query = 'DELETE FROM ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($cfgRelation['relation']) . ' WHERE master_db = \'' . $this->_dbi->escapeString($this->_db_name) . '\'' . ' AND master_table = \'' . $this->_dbi->escapeString($this->_name) . '\'' . ' AND master_field = \'' . $this->_dbi->escapeString($master_field) . '\'' |
/libraries/classes/Table.php:2338 | 1 | $upd_query = 'REPLACE INTO ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($cfgRelation['table_info']) . '(db_name, table_name, display_field) VALUES(' . '\'' . $this->_dbi->escapeString($this->_db_name) . '\',' . '\'' . $this->_dbi->escapeString($this->_name) . '\',' . '\'' . $this->_dbi->escapeString($display_field) . '\')' |
/libraries/classes/Table.php:2393 | 1 | $upd_query = 'INSERT INTO ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($cfgRelation['relation']) . '(master_db, master_table, master_field, foreign_db,' . ' foreign_table, foreign_field)' . ' values(' . '\'' . $this->_dbi->escapeString($this->_db_name) . '\', ' . '\'' . $this->_dbi->escapeString($this->_name) . '\', ' . '\'' . $this->_dbi->escapeString($master_field) . '\', ' . '\'' . $this->_dbi->escapeString($foreign_db) . '\', ' . '\'' . $this->_dbi->escapeString($foreign_table) . '\',' . '\'' . $this->_dbi->escapeString($foreign_field) . '\')' |
/libraries/classes/Table.php:1900 | 1 | $sql_query = ' REPLACE INTO ' . $pma_table . " (username, db_name, table_name, prefs) VALUES ('" . $this->_dbi->escapeString($username) . "', '" . $secureDbName . "', '" . $this->_dbi->escapeString($this->_name) . "', '" . $this->_dbi->escapeString(json_encode($this->uiprefs)) . "')" |
/libraries/classes/Table.php:2330 | 1 | $upd_query = 'DELETE FROM ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($cfgRelation['table_info']) . ' WHERE db_name = \'' . $this->_dbi->escapeString($this->_db_name) . '\'' . ' AND table_name = \'' . $this->_dbi->escapeString($this->_name) . '\'' |
/libraries/classes/Table.php:1390 | 1 | $new_comment_query = 'REPLACE INTO ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($GLOBALS['cfgRelation']['column_info']) . ' (db_name, table_name, column_name, comment' . ($GLOBALS['cfgRelation']['mimework'] ? ', mimetype, transformation, transformation_options' : '') . ') VALUES(\'' . $dbi->escapeString($target_db) . '\',\'' . $dbi->escapeString($target_table) . '\',\'' . $dbi->escapeString($comments_copy_row['column_name']) . '\',\'' . $dbi->escapeString($comments_copy_row['comment']) . '\'' . ($GLOBALS['cfgRelation']['mimework'] ? ',\'' . $dbi->escapeString($comments_copy_row['mimetype']) . '\',\'' . $dbi->escapeString($comments_copy_row['transformation']) . '\',\'' . $dbi->escapeString($comments_copy_row['transformation_options']) . '\'' : '') . ')' |
/libraries/classes/Table.php:1873 | 1 | $sql_query = ' SELECT `prefs` FROM ' . $pma_table . " WHERE `username` = '" . $this->_dbi->escapeString($GLOBALS['cfg']['Server']['user']) . "'" . " AND `db_name` = '" . $this->_dbi->escapeString($this->_db_name) . "'" . " AND `table_name` = '" . $this->_dbi->escapeString($this->_name) . "'" |
/libraries/classes/Table.php:957 | 1 | $new_table_query = 'INSERT IGNORE INTO ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($GLOBALS['cfgRelation'][$pma_table]) . ' (' . implode(', ', $select_parts) . ', ' . implode(', ', $new_parts) . ') VALUES (\'' . implode('\', \'', $value_parts) . '\', \'' . implode('\', \'', $new_value_parts) . '\')' |
/libraries/classes/Table.php:1370 | 1 | $comments_copy_rs = $relation->queryAsControlUser('SELECT column_name, comment' . ($GLOBALS['cfgRelation']['mimework'] ? ', mimetype, transformation, transformation_options' : '') . ' FROM ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($GLOBALS['cfgRelation']['column_info']) . ' WHERE ' . ' db_name = \'' . $dbi->escapeString($source_db) . '\'' . ' AND ' . ' table_name = \'' . $dbi->escapeString((string) $source_table) . '\'') |
/libraries/classes/Table.php:797 | 1 | $result = $this->_dbi->tryQuery('SELECT 1 FROM ' . Util::backquote($db) . '.' . Util::backquote($table) . ' LIMIT ' . $GLOBALS['cfg']['MaxExactCountViews'], DatabaseInterface::CONNECT_USER, DatabaseInterface::QUERY_STORE) |
/libraries/classes/Table.php:933 | 1 | $table_copy_query = ' SELECT ' . implode(', ', $select_parts) . ' FROM ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($GLOBALS['cfgRelation'][$pma_table]) . ' WHERE ' . implode(' AND ', $where_parts) |
/libraries/classes/RelationCleanup.php:171 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['navigationhiding']) . ' WHERE db_name = \'' . $this->dbi->escapeString($db) . '\'' . ' AND (table_name = \'' . $this->dbi->escapeString($table) . '\'' . ' OR (item_name = \'' . $this->dbi->escapeString($table) . '\'' . ' AND item_type = \'table\'))' |
/libraries/classes/Table.php:275 | 1 | $result = $this->_dbi->fetchResult('SELECT TABLE_NAME' . ' FROM information_schema.VIEWS' . ' WHERE TABLE_SCHEMA = \'' . $this->_dbi->escapeString($this->_db_name) . '\'' . ' AND TABLE_NAME = \'' . $this->_dbi->escapeString($this->_name) . '\'' . ' AND IS_UPDATABLE = \'YES\'') |
/libraries/classes/Operations.php:695 | 1 | $choices = ['ANALYZE' => __('Analyze'), 'CHECK' => __('Check'), 'OPTIMIZE' => __('Optimize'), 'REBUILD' => __('Rebuild'), 'REPAIR' => __('Repair'), 'TRUNCATE' => __('Truncate'), ] |
/libraries/classes/Operations.php:650 | 1 | $actions[] = ['params' => ['sql_query' => 'FLUSH TABLE ' . Util::backquote($table), 'message_to_show' => sprintf(__('Table %s has been flushed.'), htmlspecialchars($table)), 'reload' => true, ], 'message' => __('Flush the table (FLUSH)'), 'link' => 'FLUSH', ] |
/libraries/classes/Operations.php:1010 | 1 | $query_table_specific = 'UPDATE ' . Util::backquote('tables_priv') . 'SET Db = \'' . $this->dbi->escapeString($newDb) . '\', Table_name = \'' . $this->dbi->escapeString($newTable) . '\' where Db = \'' . $this->dbi->escapeString($oldDb) . '\' AND Table_name = \'' . $this->dbi->escapeString($oldTable) . '\';' |
/libraries/classes/Operations.php:756 | 1 | $joinQuery .= ' ON ' . Util::backquote($table) . '.' . Util::backquote($master) . ' = ' . Util::backquote($arr['foreign_db']) . '.' . Util::backquote($foreignTable) . '.' . Util::backquote($arr['foreign_field']) . ' WHERE ' . Util::backquote($arr['foreign_db']) . '.' . Util::backquote($foreignTable) . '.' . Util::backquote($arr['foreign_field']) . ' IS NULL AND ' . Util::backquote($table) . '.' . Util::backquote($master) . ' IS NOT NULL' |
/libraries/classes/Operations.php:1063 | 1 | $newDb_table_privs_query = 'INSERT INTO ' . Util::backquote('tables_priv') . ' VALUES("' . $old_priv[0] . '", "' . $newDb . '", "' . $old_priv[2] . '", "' . $newTable . '", "' . $old_priv[4] . '", "' . $old_priv[5] . '", "' . $old_priv[6] . '", "' . $old_priv[7] . '");' |
/libraries/classes/Operations.php:1019 | 1 | $query_col_specific = 'UPDATE ' . Util::backquote('columns_priv') . 'SET Db = \'' . $this->dbi->escapeString($newDb) . '\', Table_name = \'' . $this->dbi->escapeString($newTable) . '\' where Db = \'' . $this->dbi->escapeString($oldDb) . '\' AND Table_name = \'' . $this->dbi->escapeString($oldTable) . '\';' |
/libraries/classes/Util.php:766 | 1 | $month = [__('Jan'), __('Feb'), __('Mar'), __('Apr'), _pgettext('Short month name', 'May'), __('Jun'), __('Jul'), __('Aug'), __('Sep'), __('Oct'), __('Nov'), __('Dec'), ] |
/libraries/classes/Operations.php:1083 | 1 | $newDb_col_privs_query = 'INSERT INTO ' . Util::backquote('columns_priv') . ' VALUES("' . $old_priv[0] . '", "' . $newDb . '", "' . $old_priv[2] . '", "' . $newTable . '", "' . $old_priv[4] . '", "' . $old_priv[5] . '", "' . $old_priv[6] . '");' |
/libraries/classes/Replication.php:94 | 1 | $out = $GLOBALS['dbi']->tryQuery('CHANGE MASTER TO ' . 'MASTER_HOST=\'' . $host . '\',' . 'MASTER_PORT=' . ($port * 1) . ',' . 'MASTER_USER=\'' . $user . '\',' . 'MASTER_PASSWORD=\'' . $password . '\',' . 'MASTER_LOG_FILE=\'' . $pos['File'] . '\',' . 'MASTER_LOG_POS=' . $pos['Position'] . ';', $link) |
/libraries/classes/TablePartitionDefinition.php:175 | 1 | $subpartitions[$j] = ['name' => $partition['name'] . '_s' . $j, 'engine' => '', 'comment' => '', 'data_directory' => '', 'index_directory' => '', 'max_rows' => '', 'min_rows' => '', 'tablespace' => '', 'node_group' => '', ] |
/libraries/classes/SavedSearches.php:363 | 1 | $sqlQuery = 'UPDATE ' . $savedSearchesTbl . "SET `search_name` = '" . $GLOBALS['dbi']->escapeString($this->getSearchName( )) . "', " . "`search_data` = '" . $GLOBALS['dbi']->escapeString(json_encode($this->getCriterias( ))) . "' " . 'WHERE id = ' . $this->getId( ) |
/libraries/classes/SavedSearches.php:326 | 1 | $sqlQuery = 'INSERT INTO ' . $savedSearchesTbl . '(`username`, `db_name`, `search_name`, `search_data`)' . ' VALUES (' . "'" . $GLOBALS['dbi']->escapeString($this->getUsername( )) . "'," . "'" . $GLOBALS['dbi']->escapeString($this->getDbname( )) . "'," . "'" . $GLOBALS['dbi']->escapeString($this->getSearchName( )) . "'," . "'" . $GLOBALS['dbi']->escapeString(json_encode($this->getCriterias( ))) . "')" |
/libraries/classes/Operations.php:436 | 1 | $newDb_table_privs_query = 'INSERT INTO ' . Util::backquote('tables_priv') . ' VALUES("' . $old_priv[0] . '", "' . $newname . '", "' . $old_priv[2] . '", "' . $old_priv[3] . '", "' . $old_priv[4] . '", "' . $old_priv[5] . '", "' . $old_priv[6] . '", "' . $old_priv[7] . '");' |
/libraries/classes/SavedSearches.php:462 | 1 | $sqlQuery = 'SELECT id, search_name ' . 'FROM ' . $savedSearchesTbl . ' ' . 'WHERE ' . "username = '" . $GLOBALS['dbi']->escapeString($this->getUsername( )) . "' " . "AND db_name = '" . $GLOBALS['dbi']->escapeString($this->getDbname( )) . "' " |
/libraries/classes/Operations.php:477 | 1 | $newDb_proc_privs_query = 'INSERT INTO ' . Util::backquote('procs_priv') . ' VALUES("' . $old_priv[0] . '", "' . $newname . '", "' . $old_priv[2] . '", "' . $old_priv[3] . '", "' . $old_priv[4] . '", "' . $old_priv[5] . '", "' . $old_priv[6] . '", "' . $old_priv[7] . '");' |
/libraries/classes/Operations.php:457 | 1 | $newDb_col_privs_query = 'INSERT INTO ' . Util::backquote('columns_priv') . ' VALUES("' . $old_priv[0] . '", "' . $newname . '", "' . $old_priv[2] . '", "' . $old_priv[3] . '", "' . $old_priv[4] . '", "' . $old_priv[5] . '", "' . $old_priv[6] . '");' |
/libraries/classes/Tracker.php:421 | 1 | $sql_query = ' UPDATE ' . self::getTrackingTable( ) . " SET `tracking_active` = '" . $new_state . "' " . " WHERE `db_name` = '" . $GLOBALS['dbi']->escapeString($dbname) . "' " . " AND `table_name` = '" . $GLOBALS['dbi']->escapeString($tablename) . "' " . " AND `version` = '" . $GLOBALS['dbi']->escapeString((string) $version) . "' " |
/libraries/classes/Tracker.php:471 | 1 | $sql_query = ' UPDATE ' . self::getTrackingTable( ) . ' SET `' . $save_to . "` = '" . $new_data_processed . "' " . " WHERE `db_name` = '" . $GLOBALS['dbi']->escapeString($dbname) . "' " . " AND `table_name` = '" . $GLOBALS['dbi']->escapeString($tablename) . "' " . " AND `version` = '" . $GLOBALS['dbi']->escapeString($version) . "' " |
/libraries/classes/Tracker.php:910 | 1 | $sql_query = " /*NOTRACK*/\n" . ' UPDATE ' . self::getTrackingTable( ) . ' SET ' . Util::backquote($save_to) . ' = CONCAT( ' . Util::backquote($save_to) . ",'\n" . $GLOBALS['dbi']->escapeString($query) . "') ," . " `date_updated` = '" . $date . "' " |
/libraries/classes/Tracker.php:930 | 1 | $sql_query .= " WHERE FIND_IN_SET('" . $result['identifier'] . "',tracking) > 0" . " AND `db_name` = '" . $GLOBALS['dbi']->escapeString($dbname ?? '') . "' " . " AND `table_name` = '" . $GLOBALS['dbi']->escapeString($result['tablename']) . "' " . " AND `version` = '" . $GLOBALS['dbi']->escapeString($version ?? '') . "' " |
/libraries/classes/SqlQueryForm.php:147 | 1 | $legend = sprintf(__('Run SQL query/queries on server “%s”'), htmlspecialchars(!empty($GLOBALS['cfg']['Servers'][$GLOBALS['server']]['verbose']) ? $GLOBALS['cfg']['Servers'][$GLOBALS['server']]['verbose'] : $GLOBALS['cfg']['Servers'][$GLOBALS['server']]['host'])) |
/libraries/classes/Transformations.php:300 | 1 | $com_qry .= '`mimetype`, ' . '`transformation`, ' . '`transformation_options`, ' . '`input_transformation`, ' . '`input_transformation_options`' . ' FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['column_info']) . ' WHERE `db_name` = \'' . $GLOBALS['dbi']->escapeString($db) . '\'' . ' AND `table_name` = \'' . $GLOBALS['dbi']->escapeString($table) . '\'' . ' AND ( `mimetype` != \'\'' . (!$strict ? ' OR `transformation` != \'\'' . ' OR `transformation_options` != \'\'' . ' OR `input_transformation` != \'\'' . ' OR `input_transformation_options` != \'\'' : '') . ')' |
/libraries/classes/Transformations.php:392 | 1 | $test_qry = ' SELECT `mimetype`, `comment` FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['column_info']) . ' WHERE `db_name` = \'' . $GLOBALS['dbi']->escapeString($db) . '\' AND `table_name` = \'' . $GLOBALS['dbi']->escapeString($table) . '\' AND `column_name` = \'' . $GLOBALS['dbi']->escapeString($key) . '\'' |
/libraries/classes/Transformations.php:412 | 1 | $upd_query = 'UPDATE ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['column_info']) . ' SET ' . '`mimetype` = \'' . $GLOBALS['dbi']->escapeString($mimetype) . '\', ' . '`transformation` = \'' . $GLOBALS['dbi']->escapeString($transformation) . '\', ' . '`transformation_options` = \'' . $GLOBALS['dbi']->escapeString($transformationOpts) . '\', ' . '`input_transformation` = \'' . $GLOBALS['dbi']->escapeString($inputTransform) . '\', ' . '`input_transformation_options` = \'' . $GLOBALS['dbi']->escapeString($inputTransformOpts) . '\'' |
/libraries/classes/Util.php:1112 | 1 | [$con_val, $condition] = self::getConditionValue(!isset($row[$i]) || $row[$i] === null ? null : $row[$i], $meta, $GLOBALS['dbi']->fieldFlags($handle, $i), $fields_cnt, $con_key, $condition) |
/libraries/classes/Util.php:1777 | 1 | $mapping = ['structure' => __('Structure'), 'sql' => __('SQL'), 'search' => __('Search'), 'insert' => __('Insert'), 'browse' => __('Browse'), 'operations' => __('Operations'), ] |
/libraries/classes/Util.php:1897 | 1 | $replace = ['@HTTP_HOST@' => $vars['http_host'], '@SERVER@' => $vars['server_name'], '__SERVER__' => $vars['server_name'], '@VERBOSE@' => $vars['server_verbose'], '@VSERVER@' => $vars['server_verbose_or_name'], '@DATABASE@' => $vars['database'], '__DB__' => $vars['database'], '@TABLE@' => $vars['table'], '__TABLE__' => $vars['table'], '@PHPMYADMIN@' => $vars['phpmyadmin_version'], ] |
/libraries/classes/Util.php:2486 | 1 | $tabList = ['server' => ['databases' => __('Databases'), 'sql' => __('SQL'), 'status' => __('Status'), 'rights' => __('Users'), 'export' => __('Export'), 'import' => __('Import'), 'settings' => __('Settings'), 'binlog' => __('Binary log'), 'replication' => __('Replication'), 'vars' => __('Variables'), 'charset' => __('Charsets'), 'plugins' => __('Plugins'), 'engine' => __('Engines'), ], 'db' => ['structure' => __('Structure'), 'sql' => __('SQL'), 'search' => __('Search'), 'query' => __('Query'), 'export' => __('Export'), 'import' => __('Import'), 'operation' => __('Operations'), 'privileges' => __('Privileges'), 'routines' => __('Routines'), 'events' => __('Events'), 'triggers' => __('Triggers'), 'tracking' => __('Tracking'), 'designer' => __('Designer'), 'central_columns' => __('Central columns'), ], 'table' => ['browse' => __('Browse'), 'structure' => __('Structure'), 'sql' => __('SQL'), 'search' => __('Search'), 'insert' => __('Insert'), 'export' => __('Export'), 'import' => __('Import'), 'privileges' => __('Privileges'), 'operation' => __('Operations'), 'tracking' => __('Tracking'), 'triggers' => __('Triggers'), ], ] |
/libraries/classes/ZipExtension.php:242 | 1 | $time = $timearray['year'] - 1980 << 25 | ($timearray['mon'] << 21) | ($timearray['mday'] << 16) | ($timearray['hours'] << 11) | ($timearray['minutes'] << 5) | ($timearray['seconds'] >> 1) |
/libraries/classes/ZipExtension.php:276 | 1 | $cdrec = "\x50\x4b\x01\x02" . "\x00\x00" . "\x14\x00" . "\x00\x00" . "\x08\x00" . $hexdtime . pack('V', $crc) . pack('V', $c_len) . pack('V', $unc_len) . pack('v', strlen($temp_name)) . pack('v', 0) . pack('v', 0) . pack('v', 0) . pack('v', 0) . pack('V', 32) . pack('V', $old_offset) . $temp_name |
/libraries/classes/Tracker.php:273 | 1 | $sql_query = "/*NOTRACK*/\n" . 'INSERT INTO ' . self::getTrackingTable( ) . ' (' . 'db_name, ' . 'table_name, ' . 'version, ' . 'date_created, ' . 'date_updated, ' . 'schema_snapshot, ' . 'schema_sql, ' . 'data_sql, ' . 'tracking ' . ') ' . "values ( '" . $GLOBALS['dbi']->escapeString($dbname) . "', '" . $GLOBALS['dbi']->escapeString($tablename) . "', '" . $GLOBALS['dbi']->escapeString($version) . "', '" . $GLOBALS['dbi']->escapeString($date) . "', '" . $GLOBALS['dbi']->escapeString($date) . "', '" . $GLOBALS['dbi']->escapeString($snapshot) . "', '" . $GLOBALS['dbi']->escapeString($create_sql) . "', '" . $GLOBALS['dbi']->escapeString("\n") . "', '" . $GLOBALS['dbi']->escapeString($tracking_set) . "' )" |
/libraries/classes/Tracker.php:374 | 1 | $sql_query = "/*NOTRACK*/\n" . 'INSERT INTO ' . self::getTrackingTable( ) . ' (' . 'db_name, ' . 'table_name, ' . 'version, ' . 'date_created, ' . 'date_updated, ' . 'schema_snapshot, ' . 'schema_sql, ' . 'data_sql, ' . 'tracking ' . ') ' . "values ( '" . $GLOBALS['dbi']->escapeString($dbname) . "', '" . $GLOBALS['dbi']->escapeString('') . "', '" . $GLOBALS['dbi']->escapeString($version) . "', '" . $GLOBALS['dbi']->escapeString($date) . "', '" . $GLOBALS['dbi']->escapeString($date) . "', '" . $GLOBALS['dbi']->escapeString('') . "', '" . $GLOBALS['dbi']->escapeString($create_sql) . "', '" . $GLOBALS['dbi']->escapeString("\n") . "', '" . $GLOBALS['dbi']->escapeString($tracking_set) . "' )" |
/libraries/classes/CentralColumns.php:722 | 1 | $message = $this->updateOneColumn($params['db'], $params['orig_col_name'][$i], $params['field_name'][$i], $params['field_type'][$i], $params['field_attribute'][$i], $params['field_length'][$i], $columnIsNull[$i], $params['field_collation'][$i], $columnExtra[$i], $columnDefault[$i]) |
/libraries/classes/CentralColumns.php:677 | 1 | $query = 'UPDATE ' . Util::backquote($centralTable) . ' SET col_type = \'' . $this->dbi->escapeString($col_type) . '\'' . ', col_name = \'' . $this->dbi->escapeString($col_name) . '\'' . ', col_length = \'' . $this->dbi->escapeString($col_length) . '\'' . ', col_isNull = ' . $col_isNull . ', col_collation = \'' . $this->dbi->escapeString($collation) . '\'' . ', col_extra = \'' . implode(',', [$col_extra, $col_attribute]) . '\'' . ', col_default = \'' . $this->dbi->escapeString($col_default) . '\'' . ' WHERE db_name = \'' . $this->dbi->escapeString($db) . '\' ' . 'AND col_name = \'' . $this->dbi->escapeString($orig_col_name) . '\'' |
/libraries/classes/Sanitize.php:186 | 1 | $replace_pairs = ['[em]' => '<em>', '[/em]' => '</em>', '[strong]' => '<strong>', '[/strong]' => '</strong>', '[code]' => '<code>', '[/code]' => '</code>', '[kbd]' => '<kbd>', '[/kbd]' => '</kbd>', '[br]' => '<br>', '[/a]' => '</a>', '[/doc]' => '</a>', '[sup]' => '<sup>', '[/sup]' => '</sup>', '[conferr]' => '<iframe src="show_config_errors.php"><a href=' . '"show_config_errors.php">show_config_errors.php</a></iframe>', '[dochelpicon]' => Html\Generator::getImage('b_help', __('Documentation')), ] |
/libraries/classes/CreateAddField.php:85 | 1 | $definition = $this->getStatementPrefix($isCreateTable) . Table::generateFieldSpec(trim($_POST['field_name'][$i]), $_POST['field_type'][$i], $_POST['field_length'][$i], $_POST['field_attribute'][$i], $_POST['field_collation'][$i] ?? '', $_POST['field_null'][$i] ?? 'NO', $_POST['field_default_type'][$i], $_POST['field_default_value'][$i], $_POST['field_extra'][$i] ?? false, $_POST['field_comments'][$i] ?? '', $_POST['field_virtuality'][$i] ?? '', $_POST['field_expression'][$i] ?? '') |
/libraries/classes/CentralColumns.php:838 | 1 | $tableHtml .= '<option value="' . $collation->getName( ) . '" title="' . $collation->getDescription( ) . '"' . ($row['col_collation'] == $collation->getName( ) ? ' selected' : '') . '>' . $collation->getName( ) . '</option>' . "\n" |
/libraries/classes/CentralColumns.php:814 | 1 | $tableHtml .= '<td class="nowrap" name="col_default">' . $this->template->render('columns_definitions/column_default', ['column_number' => $row_num, 'ci' => 3, 'ci_offset' => 0, 'type_upper' => mb_strtoupper((string) $row['col_default']), 'column_meta' => $meta, 'char_editing' => $this->charEditing, ]) . '</td>' |
/libraries/classes/CentralColumns.php:781 | 1 | $tableHtml .= '<td name = "col_type" class="nowrap">' . $this->template->render('columns_definitions/column_type', ['column_number' => $row_num, 'ci' => 1, 'ci_offset' => 0, 'type_upper' => mb_strtoupper($row['col_type']), 'column_meta' => [ ], ]) . '</td>' |
/libraries/classes/CentralColumns.php:766 | 1 | $tableHtml = '<tr>' . '<input name="orig_col_name[' . $row_num . ']" type="hidden" ' . 'value="' . htmlspecialchars($row['col_name']) . '">' . '<td name="col_name" class="nowrap">' . $this->template->render('columns_definitions/column_name', ['column_number' => $row_num, 'ci' => 0, 'ci_offset' => 0, 'column_meta' => ['Field' => $row['col_name'], ], 'cfg_relation' => ['centralcolumnswork' => false], 'max_rows' => $this->maxRows, ]) . '</td>' |
/libraries/classes/InsertEdit.php:3587 | 1 | $html_output .= $this->getHtmlForInsertEditFormColumn($table_columns, $column_number, $comments_map, $timestamp_seen, $current_result, $chg_evt_handler, $jsvkey, $vkey, $insert_mode, $current_row, $o_rows, $tabindex, $columns_cnt, $is_upload, $tabindex_for_function, $foreigners, $tabindex_for_null, $tabindex_for_value, $table, $db, $row_id, $titles, $biggest_max_file_size, $default_char_editing, $text_dir, $repopulate, $column_mime, $where_clause) |
/libraries/classes/InsertEdit.php:2944 | 1 | $sql_for_real_value = 'SELECT ' . Util::backquote($table) . '.' . Util::backquote($column_name) . ' FROM ' . Util::backquote($db) . '.' . Util::backquote($table) . ' WHERE ' . $_POST['where_clause'][0] |
/libraries/classes/InsertEdit.php:2492 | 1 | $dispsql = 'SELECT ' . Util::backquote($display_field) . ' FROM ' . Util::backquote($foreigner['foreign_db']) . '.' . Util::backquote($foreigner['foreign_table']) . ' WHERE ' . Util::backquote($foreigner['foreign_field']) . $where_comparison |
/libraries/classes/InsertEdit.php:917 | 1 | $html_output .= '<a class="ajax browse_foreign" href="' . Url::getFromRoute('/browse-foreigners') . '" data-post="' . Url::getCommon(['db' => $db, 'table' => $table, 'field' => $column['Field'], 'rownumber' => $rownumber, 'data' => $data, ], '') . '">' . str_replace("'", "\'", $titles['Browse']) . '</a>' |
/libraries/classes/Import.php:1383 | 1 | $message .= sprintf('<li><a href="%s" title="%s">%s</a> (<a href="%s" title="%s">' . __('Structure') . '</a>) (<a href="%s" title="%s">' . __('Options') . '</a>)</li>', $tbl_url, sprintf(__('Go to table: %s'), htmlspecialchars(Util::backquote($table[self::TBL_NAME]))), htmlspecialchars($table[self::TBL_NAME]), $tbl_struct_url, sprintf(__('Structure of %s'), htmlspecialchars(Util::backquote($table[self::TBL_NAME]))), $tbl_ops_url, sprintf(__('Edit settings for %s'), htmlspecialchars(Util::backquote($table[self::TBL_NAME])))) |
/libraries/classes/Import.php:1350 | 1 | $message .= sprintf('<br><li><a href="%s" title="%s">%s</a> (<a href="%s" title="%s">' . __('Options') . '</a>)</li>', $db_url, sprintf(__('Go to database: %s'), htmlspecialchars(Util::backquote($db_name))), htmlspecialchars($db_name), $db_ops_url, sprintf(__('Edit settings for %s'), htmlspecialchars(Util::backquote($db_name)))) |
/libraries/classes/Import.php:1145 | 1 | $type_array = [self::NONE => 'NULL', self::VARCHAR => 'varchar', self::INT => 'int', self::DECIMAL => 'decimal', self::BIGINT => 'bigint', self::GEOMETRY => 'geometry', ] |
/libraries/classes/UserPassword.php:212 | 1 | $local_query = 'ALTER USER \'' . $GLOBALS['dbi']->escapeString($username) . '\'@\'' . $GLOBALS['dbi']->escapeString($hostname) . '\'' . ' IDENTIFIED with ' . $orig_auth_plugin . ' BY ' . ($password == '' ? '\'\'' : '\'' . $GLOBALS['dbi']->escapeString($password) . '\'') |
/libraries/classes/Linter.php:174 | 1 | $response[] = ['message' => sprintf(__('%1$s (near <code>%2$s</code>)'), htmlspecialchars((string) $error[0]), htmlspecialchars((string) $error[2])), 'fromLine' => $fromLine, 'fromColumn' => $fromColumn, 'toLine' => $toLine, 'toColumn' => $toColumn, 'severity' => 'error', ] |
/libraries/classes/Header.php:223 | 1 | $params = ['common_query' => Url::getCommonRaw([ ], ''), 'opendb_url' => Util::getScriptNameForOption($GLOBALS['cfg']['DefaultTabDatabase'], 'database'), 'lang' => $GLOBALS['lang'], 'server' => $GLOBALS['server'], 'table' => $table ?? '', 'db' => $db ?? '', 'token' => $_SESSION[' PMA_token '], 'text_dir' => $GLOBALS['text_dir'], 'show_databases_navigation_as_tree' => $GLOBALS['cfg']['ShowDatabasesNavigationAsTree'], 'pma_text_default_tab' => Util::getTitleForTarget($GLOBALS['cfg']['DefaultTabTable']), 'pma_text_left_default_tab' => Util::getTitleForTarget($GLOBALS['cfg']['NavigationTreeDefaultTabTable']), 'pma_text_left_default_tab2' => Util::getTitleForTarget($GLOBALS['cfg']['NavigationTreeDefaultTabTable2']), 'LimitChars' => $GLOBALS['cfg']['LimitChars'], 'pftext' => $pftext, 'confirm' => $GLOBALS['cfg']['Confirm'], 'LoginCookieValidity' => $GLOBALS['cfg']['LoginCookieValidity'], 'session_gc_maxlifetime' => (int) ini_get('session.gc_maxlifetime'), 'logged_in' => isset($GLOBALS['dbi']) ? $GLOBALS['dbi']->isUserType('logged') : false, 'is_https' => $GLOBALS['PMA_Config']->isHttps( ), 'rootPath' => $GLOBALS['PMA_Config']->getRootPath( ), 'arg_separator' => Url::getArgSeparator( ), 'PMA_VERSION' => PMA_VERSION, ] |
/libraries/classes/Tracking.php:1186 | 1 | $tableQuery = ' SELECT * FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['tracking']) . ' WHERE `db_name` = \'' . $GLOBALS['dbi']->escapeString($db) . '\' AND `table_name` = \'' . $GLOBALS['dbi']->escapeString($tableName) . '\' AND `version` = \'' . $versionNumber . '\'' |
/libraries/classes/Tracking.php:1273 | 1 | $options = [0 => ['label' => __('not active'), 'value' => 'deactivate_now', 'selected' => $state != 'active', ], 1 => ['label' => __('active'), 'value' => 'activate_now', 'selected' => $state == 'active', ], ] |
/libraries/classes/TablePartitionDefinition.php:39 | 1 | $partitionDetails['can_have_subpartitions'] = $partitionDetails['partition_count'] > 1 && isset($partitionDetails['partition_by']) && ($partitionDetails['partition_by'] === 'RANGE' || $partitionDetails['partition_by'] === 'RANGE COLUMNS' || $partitionDetails['partition_by'] === 'LIST' || $partitionDetails['partition_by'] === 'LIST COLUMNS') |
/libraries/classes/TablePartitionDefinition.php:121 | 1 | $partitions[$i] = ['name' => 'p' . $i, 'value_type' => '', 'value' => '', 'engine' => '', 'comment' => '', 'data_directory' => '', 'index_directory' => '', 'max_rows' => '', 'min_rows' => '', 'tablespace' => '', 'node_group' => '', ] |
/libraries/classes/Bookmark.php:127 | 1 | $query = 'INSERT INTO ' . Util::backquote($cfgBookmark['db']) . '.' . Util::backquote($cfgBookmark['table']) . ' (id, dbase, user, query, label) VALUES (NULL, ' . "'" . $this->dbi->escapeString($this->_database) . "', " . "'" . $this->dbi->escapeString($this->_user) . "', " . "'" . $this->dbi->escapeString($this->_query) . "', " . "'" . $this->dbi->escapeString($this->_label) . "')" |
/libraries/classes/DatabaseInterface.php:819 | 1 | [$sql, $arrayKeys] = QueryGenerator::getInformationSchemaColumnsFullRequest($database !== null ? $this->escapeString($database, $link) : null, $table !== null ? $this->escapeString($table, $link) : null, $column !== null ? $this->escapeString($column, $link) : null) |
/libraries/classes/Plugins.php:472 | 1 | $ret .= '<input type="checkbox" name="' . $plugin_name . '_' . $propertyItem->getName( ) . '"' . ' value="something" id="checkbox_' . $plugin_name . '_' . $propertyItem->getName( ) . '"' . ' ' . self::checkboxCheck($section, $plugin_name . '_' . $propertyItem->getName( )) |
/libraries/classes/Plugins.php:573 | 1 | $ret .= '<input type="text" name="' . $plugin_name . '_' . $pitem->getName( ) . '"' . ' value="' . self::getDefault($section, $plugin_name . '_' . $pitem->getName( )) . '"' . ' id="text_' . $plugin_name . '_' . $pitem->getName( ) . '"' . ($pitem->getSize( ) != null ? ' size="' . $pitem->getSize( ) . '"' : '') . ($pitem->getLen( ) != null ? ' maxlength="' . $pitem->getLen( ) . '"' : '') . '>' |
/libraries/classes/CentralColumns.php:847 | 1 | $tableHtml .= '<td class="nowrap" name="col_attribute">' . $this->template->render('columns_definitions/column_attribute', ['column_number' => $row_num, 'ci' => 5, 'ci_offset' => 0, 'extracted_columnspec' => ['attribute' => $row['col_attribute'], ], 'column_meta' => [ ], 'submit_attribute' => false, 'attribute_types' => $this->dbi->types->getAttributes( ), ]) . '</td>' |
/libraries/classes/Sql.php:2138 | 1 | $html_output = $this->getQueryResponseForResultsReturned($result ?? null, $analyzed_sql_results, $db, $table, $message ?? null, $sql_data ?? null, $displayResultsObject, $pmaThemeImage, $unlim_num_rows, $num_rows, $disp_query ?? null, $disp_message ?? null, $profiling_results, $query_type ?? null, $selectedTables ?? null, $sql_query, $complete_query ?? null) |
/libraries/classes/Tracking.php:331 | 1 | $str1 = '<select name="logtype">' . '<option value="schema"' . ($selection_schema ? ' selected="selected"' : '') . '>' . __('Structure only') . '</option>' . '<option value="data"' . ($selection_data ? ' selected="selected"' : '') . '>' . __('Data only') . '</option>' . '<option value="schema_and_data"' . ($selection_both ? ' selected="selected"' : '') . '>' . __('Structure and data') . '</option>' . '</select>' |
/libraries/classes/Tracking.php:482 | 1 | $html .= Url::getHiddenInputs($url_params + ['report' => 'true', 'version' => $_POST['version'], 'logtype' => $_POST['logtype'], 'date_from' => $_POST['date_from'], 'date_to' => $_POST['date_to'], 'users' => $_POST['users'], 'report_export' => 'true', ]) |
/libraries/classes/Plugins.php:594 | 1 | $ret .= '<input type="number" name="' . $plugin_name . '_' . $propertyItem->getName( ) . '"' . ' value="' . self::getDefault($section, $plugin_name . '_' . $propertyItem->getName( )) . '"' . ' id="number_' . $plugin_name . '_' . $propertyItem->getName( ) . '"' . ' min="0"' . '>' |
/libraries/classes/Tracking.php:126 | 1 | $sql_query = ' SELECT * FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['tracking']) . " WHERE db_name = '" . $GLOBALS['dbi']->escapeString($GLOBALS['db']) . "' " . " AND table_name = '" . $GLOBALS['dbi']->escapeString($GLOBALS['table']) . "' " . ' ORDER BY version DESC ' |
/libraries/classes/Controllers/Server/DatabasesController.php:250 | 1 | $json = ['message' => $message, 'sql_query' => Generator::getMessage('', $sqlQuery, 'success'), 'url_query' => $scriptName . Url::getCommon(['db' => $params['new_db']], strpos($scriptName, '?') === false ? '?' : '&'), ] |
/libraries/classes/Controllers/Server/DatabasesController.php:437 | 1 | $databases[$database['SCHEMA_NAME']] = ['name' => $database['SCHEMA_NAME'], 'collation' => [ ], 'statistics' => $statistics, 'replication' => $replication, 'is_system_schema' => Utilities::isSystemSchema($database['SCHEMA_NAME'], true), 'is_pmadb' => $database['SCHEMA_NAME'] === ($cfg['Server']['pmadb'] ?? ''), 'url' => $url, ] |
/libraries/classes/Controllers/Server/Status/MonitorController.php:58 | 1 | $form = ['server_time' => (int) (microtime(true) * 1000), 'server_os' => SysInfo::getOs( ), 'is_superuser' => $this->dbi->isSuperuser( ), 'server_db_isLocal' => $this->data->db_isLocal, ] |
/libraries/classes/Controllers/Server/Status/VariablesController.php:20 | 1 | $params = ['flush' => $_POST['flush'] ?? null, 'filterAlert' => $_POST['filterAlert'] ?? null, 'filterText' => $_POST['filterText'] ?? null, 'filterCategory' => $_POST['filterCategory'] ?? null, 'dontFormat' => $_POST['dontFormat'] ?? null, ] |
/libraries/classes/Controllers/Database/DesignerController.php:130 | 1 | [$success, $message] = $this->designerCommon->addNewRelation($_POST['db'], $_POST['T1'], $_POST['F1'], $_POST['T2'], $_POST['F2'], $_POST['on_delete'], $_POST['on_update'], $_POST['DB1'], $_POST['DB2']) |
/libraries/classes/Controllers/Database/DataDictionaryController.php:109 | 1 | $rows[$row['Field']] = ['name' => $row['Field'], 'has_primary_key' => isset($primaryKeys[$row['Field']]), 'type' => $extractedColumnSpec['type'], 'print_type' => $extractedColumnSpec['print_type'], 'is_nullable' => $row['Null'] !== '' && $row['Null'] !== 'NO', 'default' => $row['Default'] ?? null, 'comment' => $columnsComments[$row['Field']] ?? '', 'mime' => $mime, 'relation' => $relation, ] |
/libraries/classes/Controllers/Setup/HomeController.php:135 | 1 | $servers[$id] = ['id' => $id, 'name' => $this->config->getServerName($id), 'auth_type' => $this->config->getValue('Servers/' . $id . '/auth_type'), 'dsn' => $this->config->getServerDSN($id), 'params' => ['token' => $_SESSION[' PMA_token '], 'edit' => ['page' => 'servers', 'mode' => 'edit', 'id' => $id, ], 'remove' => ['page' => 'servers', 'mode' => 'remove', 'id' => $id, ], ], ] |
/libraries/classes/Controllers/Server/EnginesController.php:42 | 1 | $engine = ['engine' => $params['engine'], 'title' => $storageEngine->getTitle( ), 'help_page' => $storageEngine->getMysqlHelpPage( ), 'comment' => $storageEngine->getComment( ), 'info_pages' => $storageEngine->getInfoPages( ), 'support' => $storageEngine->getSupportInformationMessage( ), 'variables' => $storageEngine->getHtmlVariables( ), 'page' => !empty($page) ? $storageEngine->getPage($page) : '', ] |
/libraries/classes/Controllers/Server/Status/ProcessesController.php:65 | 2 | $params = ['showExecuting' => $_POST['showExecuting'] ?? null, 'full' => $_POST['full'] ?? null, 'column_name' => $_POST['column_name'] ?? null, 'order_by_field' => $_POST['order_by_field'] ?? null, 'sort_order' => $_POST['sort_order'] ?? null, ] |
/libraries/classes/Controllers/Server/Status/ProcessesController.php:127 | 1 | $sortableColumns = [['column_name' => __('ID'), 'order_by_field' => 'Id', ], ['column_name' => __('User'), 'order_by_field' => 'User', ], ['column_name' => __('Host'), 'order_by_field' => 'Host', ], ['column_name' => __('Database'), 'order_by_field' => 'db', ], ['column_name' => __('Command'), 'order_by_field' => 'Command', ], ['column_name' => __('Time'), 'order_by_field' => 'Time', ], ['column_name' => __('Status'), 'order_by_field' => 'State', ], ['column_name' => __('Progress'), 'order_by_field' => 'Progress', ], ['column_name' => __('SQL query'), 'order_by_field' => 'Info', ], ] |
/libraries/classes/Controllers/Server/Status/ProcessesController.php:243 | 1 | $rows[] = ['id' => $process['Id'], 'user' => $process['User'], 'host' => $process['Host'], 'db' => !isset($process['db']) || strlen($process['db']) === 0 ? '' : $process['db'], 'command' => $process['Command'], 'time' => $process['Time'], 'state' => !empty($process['State']) ? $process['State'] : '---', 'progress' => !empty($process['Progress']) ? $process['Progress'] : '---', 'info' => !empty($process['Info']) ? Generator::formatSql($process['Info'], !$showFullSql) : '---', ] |
/libraries/classes/Controllers/Table/ChangeController.php:236 | 1 | $html_output .= $this->insertEdit->getHtmlForInsertEditRow($url_params, $table_columns, $comments_map, $timestamp_seen, $current_result, $chg_evt_handler, $jsvkey, $vkey, $insert_mode, $current_row, $o_rows, $tabindex, $columns_cnt, $is_upload, $tabindex_for_function, $foreigners, $tabindex_for_null, $tabindex_for_value, $table, $db, $row_id, $titles, $biggest_max_file_size, $text_dir, $repopulate, $where_clause_array) |
/libraries/classes/Controllers/Server/Status/VariablesController.php:74 | 1 | $variables[$name] = ['name' => $name, 'value' => $value, 'is_numeric' => is_numeric($value), 'class' => $this->data->allocationMap[$name] ?? null, 'doc' => '', 'has_alert' => false, 'is_alert' => false, 'description' => $descriptions[$name] ?? '', 'description_doc' => [ ], ] |
/libraries/classes/Controllers/Server/Status/QueriesController.php:38 | 1 | $stats = ['total' => $totalQueries, 'per_hour' => $totalQueries * $hourFactor, 'per_minute' => $totalQueries * 60 / $this->data->status['Uptime'], 'per_second' => $totalQueries / $this->data->status['Uptime'], ] |
/libraries/classes/Controllers/Server/Status/ProcessesController.php:24 | 2 | $params = ['showExecuting' => $_POST['showExecuting'] ?? null, 'full' => $_POST['full'] ?? null, 'column_name' => $_POST['column_name'] ?? null, 'order_by_field' => $_POST['order_by_field'] ?? null, 'sort_order' => $_POST['sort_order'] ?? null, ] |
/libraries/classes/Controllers/Server/Status/ProcessesController.php:43 | 1 | $urlParams = ['ajax_request' => true, 'full' => $params['full'] ?? '', 'column_name' => $params['column_name'] ?? '', 'order_by_field' => $params['order_by_field'] ?? '', 'sort_order' => $params['sort_order'] ?? '', ] |
/libraries/classes/Controllers/Table/StructureController.php:967 | 1 | $partition['subpartitions'][$j] = ['name' => $partition['name'] . '_s' . $j, 'engine' => '', 'comment' => '', 'data_directory' => '', 'index_directory' => '', 'max_rows' => '', 'min_rows' => '', 'tablespace' => '', 'node_group' => '', ] |
/libraries/classes/Controllers/Table/StructureController.php:940 | 1 | $partitionDetails['partitions'][$i] = ['name' => $p->name, 'value_type' => $type, 'value' => $expr, 'engine' => $p->options->has('ENGINE', true), 'comment' => trim((string) $p->options->has('COMMENT', true), "'"), 'data_directory' => trim((string) $p->options->has('DATA DIRECTORY', true), "'"), 'index_directory' => trim((string) $p->options->has('INDEX_DIRECTORY', true), "'"), 'max_rows' => $p->options->has('MAX_ROWS', true), 'min_rows' => $p->options->has('MIN_ROWS', true), 'tablespace' => $p->options->has('TABLESPACE', true), 'node_group' => $p->options->has('NODEGROUP', true), ] |
/libraries/classes/Controllers/Table/StructureController.php:1110 | 1 | $changes[] = 'CHANGE ' . Table::generateAlter(Util::getValueByKey($_POST, "field_orig.${i}", ''), $_POST['field_name'][$i], $_POST['field_type'][$i], $_POST['field_length'][$i], $_POST['field_attribute'][$i], Util::getValueByKey($_POST, "field_collation.${i}", ''), Util::getValueByKey($_POST, "field_null.${i}", 'NO'), $_POST['field_default_type'][$i], $_POST['field_default_value'][$i], Util::getValueByKey($_POST, "field_extra.${i}", false), Util::getValueByKey($_POST, "field_comments.${i}", ''), Util::getValueByKey($_POST, "field_virtuality.${i}", ''), Util::getValueByKey($_POST, "field_expression.${i}", ''), Util::getValueByKey($_POST, "field_move_to.${i}", ''), $columns_with_index) |
/libraries/classes/Controllers/Table/StructureController.php:980 | 1 | $partition['subpartitions'][$j] = ['name' => $sp->name, 'engine' => $sp->options->has('ENGINE', true), 'comment' => trim($sp->options->has('COMMENT', true), "'"), 'data_directory' => trim($sp->options->has('DATA DIRECTORY', true), "'"), 'index_directory' => trim($sp->options->has('INDEX_DIRECTORY', true), "'"), 'max_rows' => $sp->options->has('MAX_ROWS', true), 'min_rows' => $sp->options->has('MIN_ROWS', true), 'tablespace' => $sp->options->has('TABLESPACE', true), 'node_group' => $sp->options->has('NODEGROUP', true), ] |
/libraries/classes/Controllers/Table/SearchController.php:401 | 1 | $value = $this->template->render('table/search/input_box', ['str' => '', 'column_type' => (string) $type, 'html_attributes' => $htmlAttributes, 'column_id' => 'fieldID_', 'in_zoom_search_edit' => false, 'foreigners' => $this->_foreigners, 'column_name' => $this->_columnNames[$column_index], 'column_name_hash' => md5($this->_columnNames[$column_index]), 'foreign_data' => $foreignData, 'table' => $this->table, 'column_index' => $search_index, 'foreign_max_limit' => $GLOBALS['cfg']['ForeignKeyMaxLimit'], 'criteria_values' => $entered_value, 'db' => $this->db, 'titles' => $titles, 'in_fbs' => true, ]) |
/libraries/classes/Controllers/Table/SearchController.php:335 | 1 | $sql_query = 'SELECT MIN(' . Util::backquote($column) . ') AS `min`, ' . 'MAX(' . Util::backquote($column) . ') AS `max` ' . 'FROM ' . Util::backquote($this->db) . '.' . Util::backquote($this->table) |
/libraries/classes/Controllers/Table/StructureController.php:919 | 1 | $partitionDetails['partitions'][$i] = ['name' => 'p' . $i, 'value_type' => '', 'value' => '', 'engine' => '', 'comment' => '', 'data_directory' => '', 'index_directory' => '', 'max_rows' => '', 'min_rows' => '', 'tablespace' => '', 'node_group' => '', ] |
/libraries/classes/Controllers/Table/StructureController.php:669 | 1 | $changes[] = 'CHANGE ' . Table::generateAlter($column, $column, mb_strtoupper($extracted_columnspec['type']), $extracted_columnspec['spec_in_brackets'], $extracted_columnspec['attribute'], $data['Collation'] ?? '', $data['Null'] === 'YES' ? 'YES' : 'NO', $default_type, $current_timestamp ? '' : $data['Default'], isset($data['Extra']) && $data['Extra'] !== '' ? $data['Extra'] : false, isset($data['COLUMN_COMMENT']) && $data['COLUMN_COMMENT'] !== '' ? $data['COLUMN_COMMENT'] : false, $data['Virtuality'], $data['Expression'], $i === 0 ? '-first' : $column_names[$i - 1]) |
/libraries/classes/Controllers/Table/OperationsController.php:226 | 1 | $table_alters = $this->operations->getTableAltersArray($pma_table, $create_options['pack_keys'], (empty($create_options['checksum']) ? '0' : '1'), ($create_options['page_checksum'] ?? ''), (empty($create_options['delay_key_write']) ? '0' : '1'), $row_format, $new_tbl_storage_engine, (isset($create_options['transactional']) && $create_options['transactional'] == '0' ? '0' : '1'), $tbl_collation) |
/libraries/classes/Controllers/Table/ZoomSearchController.php:450 | 1 | $value = $this->template->render('table/search/input_box', ['str' => '', 'column_type' => (string) $type, 'column_id' => 'fieldID_', 'in_zoom_search_edit' => false, 'foreigners' => $this->_foreigners, 'column_name' => $this->_columnNames[$column_index], 'column_name_hash' => md5($this->_columnNames[$column_index]), 'foreign_data' => $foreignData, 'table' => $this->table, 'column_index' => $search_index, 'foreign_max_limit' => $GLOBALS['cfg']['ForeignKeyMaxLimit'], 'criteria_values' => $entered_value, 'db' => $this->db, 'titles' => $titles, 'in_fbs' => true, ]) |
/libraries/classes/Controllers/Table/FindReplaceController.php:264 | 1 | $sql_query = 'SELECT ' . Util::backquote($column) . ',' . ' 1,' . ' COUNT(*)' . ' FROM ' . Util::backquote($this->db) . '.' . Util::backquote($this->table) . ' WHERE ' . Util::backquote($column) . " RLIKE '" . $this->dbi->escapeString($find) . "' COLLATE " . $charSet . '_bin' |
/libraries/classes/Controllers/Table/FindReplaceController.php:216 | 1 | $sql_query = 'SELECT ' . Util::backquote($column) . ',' . ' REPLACE(' . Util::backquote($column) . ", '" . $find . "', '" . $replaceWith . "')," . ' COUNT(*)' . ' FROM ' . Util::backquote($this->db) . '.' . Util::backquote($this->table) . ' WHERE ' . Util::backquote($column) . " LIKE '%" . $find . "%' COLLATE " . $charSet . '_bin' |
/libraries/classes/Controllers/Table/StructureController.php:1264 | 1 | $changes_revert[] = 'CHANGE ' . Table::generateAlter(Util::getValueByKey($_POST, "field_orig.${i}", ''), $_POST['field_name'][$i], $_POST['field_type_orig'][$i], $_POST['field_length_orig'][$i], $_POST['field_attribute_orig'][$i], Util::getValueByKey($_POST, "field_collation_orig.${i}", ''), Util::getValueByKey($_POST, "field_null_orig.${i}", 'NO'), $_POST['field_default_type_orig'][$i], $_POST['field_default_value_orig'][$i], Util::getValueByKey($_POST, "field_extra_orig.${i}", false), Util::getValueByKey($_POST, "field_comments_orig.${i}", ''), Util::getValueByKey($_POST, "field_virtuality_orig.${i}", ''), Util::getValueByKey($_POST, "field_expression_orig.${i}", ''), Util::getValueByKey($_POST, "field_move_to_orig.${i}", '')) |
/libraries/classes/Controllers/Table/StructureController.php:1186 | 1 | $columns_with_index = $this->dbi->getTable($this->db, $this->table)->getColumnsWithIndex(Index::PRIMARY | Index::UNIQUE | Index::INDEX | Index::SPATIAL | Index::FULLTEXT) |
/libraries/classes/Controllers/Table/ZoomSearchController.php:368 | 1 | $tmpData = [$_POST['criteriaColumnNames'][0] => $row[$_POST['criteriaColumnNames'][0]], $_POST['criteriaColumnNames'][1] => $row[$_POST['criteriaColumnNames'][1]], 'where_clause' => $uniqueCondition[0], ] |
/libraries/classes/Controllers/Table/StructureController.php:1475 | 1 | $titles = ['Change' => Generator::getIcon('b_edit', __('Change')), 'Drop' => Generator::getIcon('b_drop', __('Drop')), 'NoDrop' => Generator::getIcon('b_drop', __('Drop')), 'Primary' => Generator::getIcon('b_primary', __('Primary')), 'Index' => Generator::getIcon('b_index', __('Index')), 'Unique' => Generator::getIcon('b_unique', __('Unique')), 'Spatial' => Generator::getIcon('b_spatial', __('Spatial')), 'IdxFulltext' => Generator::getIcon('b_ftext', __('Fulltext')), 'NoPrimary' => Generator::getIcon('bd_primary', __('Primary')), 'NoIndex' => Generator::getIcon('bd_index', __('Index')), 'NoUnique' => Generator::getIcon('bd_unique', __('Unique')), 'NoSpatial' => Generator::getIcon('bd_spatial', __('Spatial')), 'NoIdxFulltext' => Generator::getIcon('bd_ftext', __('Fulltext')), 'DistinctValues' => Generator::getIcon('b_browse', __('Distinct values')), ] |
/libraries/classes/Display/Results.php:3219 | 1 | $_url_params = ['db' => $this->__get('db'), 'table' => $this->__get('table'), 'where_clause' => $where_clause, 'clause_is_unique' => $clause_is_unique, 'sql_query' => $url_sql_query, 'goto' => Url::getFromRoute('/sql'), ] |
/libraries/classes/Display/Results.php:3281 | 1 | $_url_params = ['db' => $this->__get('db'), 'table' => $this->__get('table'), 'sql_query' => $url_sql_query, 'message_to_show' => __('The row has been deleted.'), 'goto' => empty($goto) ? Url::getFromRoute('/table/sql') : $goto, ] |
/libraries/classes/Display/Results.php:2568 | 1 | $table_body_html .= $this->template->render('display/results/checkbox_and_links', ['position' => self::POSITION_NONE, 'has_checkbox' => !empty($del_url) && $displayParts['del_lnk'] !== self::KILL_PROCESS, 'edit' => ['url' => $edit_url, 'string' => $edit_str, 'clause_is_unique' => $clause_is_unique], 'copy' => ['url' => $copy_url, 'string' => $copy_str], 'delete' => ['url' => $del_url, 'string' => $del_str], 'row_number' => $row_no, 'where_clause' => $where_clause, 'condition' => json_encode($condition_array), 'is_ajax' => Response::getInstance( )->isAjax( ), 'js_conf' => $js_conf ?? '', ]) |
/libraries/classes/Display/Results.php:2606 | 1 | $table_body_html .= $this->template->render('display/results/checkbox_and_links', ['position' => self::POSITION_RIGHT, 'has_checkbox' => !empty($del_url) && $displayParts['del_lnk'] !== self::KILL_PROCESS, 'edit' => ['url' => $edit_url, 'string' => $edit_str, 'clause_is_unique' => $clause_is_unique ?? true, ], 'copy' => ['url' => $copy_url, 'string' => $copy_str], 'delete' => ['url' => $del_url, 'string' => $del_str], 'row_number' => $row_no, 'where_clause' => $where_clause ?? '', 'condition' => json_encode($condition_array ?? [ ]), 'is_ajax' => Response::getInstance( )->isAjax( ), 'js_conf' => $js_conf ?? '', ]) |
/libraries/classes/Display/Results.php:1694 | 1 | $_multi_url_params = ['db' => $this->__get('db'), 'table' => $this->__get('table'), 'sql_query' => $multi_sorted_sql_query, 'sql_signature' => Core::signSqlQuery($multi_sorted_sql_query), 'session_max_rows' => $session_max_rows, 'is_browse_distinct' => $this->__get('is_browse_distinct'), ] |
/libraries/classes/Display/Results.php:2555 | 1 | $table_body_html .= $this->template->render('display/results/checkbox_and_links', ['position' => self::POSITION_LEFT, 'has_checkbox' => !empty($del_url) && $displayParts['del_lnk'] !== self::KILL_PROCESS, 'edit' => ['url' => $edit_url, 'string' => $edit_str, 'clause_is_unique' => $clause_is_unique], 'copy' => ['url' => $copy_url, 'string' => $copy_str], 'delete' => ['url' => $del_url, 'string' => $del_str], 'row_number' => $row_no, 'where_clause' => $where_clause, 'condition' => json_encode($condition_array), 'is_ajax' => Response::getInstance( )->isAjax( ), 'js_conf' => $js_conf ?? '', ]) |
/libraries/classes/Display/Results.php:1650 | 1 | $sort_tbl = isset($fields_meta->table) && strlen($fields_meta->table) > 0 && $fields_meta->orgname == $fields_meta->name ? Util::backquote($fields_meta->table) . '.' : '' |
/libraries/classes/Display/Results.php:1685 | 1 | $_single_url_params = ['db' => $this->__get('db'), 'table' => $this->__get('table'), 'sql_query' => $single_sorted_sql_query, 'sql_signature' => Core::signSqlQuery($single_sorted_sql_query), 'session_max_rows' => $session_max_rows, 'is_browse_distinct' => $this->__get('is_browse_distinct'), ] |
/libraries/classes/Display/Export.php:764 | 1 | $query = 'INSERT INTO ' . $templateTable . '(' . ' `username`, `export_type`,' . ' `template_name`, `template_data`' . ') VALUES (' . "'" . $user . "', " . "'" . $GLOBALS['dbi']->escapeString($_POST['exportType']) . "', '" . $GLOBALS['dbi']->escapeString($_POST['templateName']) . "', '" . $GLOBALS['dbi']->escapeString($_POST['templateData']) . "');" |
/libraries/classes/Display/GitRevision.php:105 | 1 | $name = __('Git revision:') . ' ' . $branch . ',<br> ' . sprintf(__('committed on %1$s by %2$s'), Util::localisedDate(strtotime($committer['date'])), '<a href="' . Core::linkURL('mailto:' . htmlspecialchars($committer['email'])) . '">' . htmlspecialchars($committer['name']) . '</a>') . ($author != $committer ? ', <br>' . sprintf(__('authored on %1$s by %2$s'), Util::localisedDate(strtotime($author['date'])), '<a href="' . Core::linkURL('mailto:' . htmlspecialchars($author['email'])) . '">' . htmlspecialchars($author['name']) . '</a>') : '') |
/libraries/classes/Display/Export.php:164 | 1 | $query = 'SELECT `id`, `template_name` FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['export_templates']) . ' WHERE `username` = ' . "'" . $GLOBALS['dbi']->escapeString($GLOBALS['cfg']['Server']['user']) . "' AND `export_type` = '" . $GLOBALS['dbi']->escapeString($exportType) . "'" . ' ORDER BY `template_name`;' |
/libraries/classes/Display/Export.php:610 | 1 | $result .= $template->render(['type' => _pgettext('Alias', 'Column'), 'name' => $db . '.' . $table . '.' . $column, 'field' => 'aliases[' . $db . '][tables][' . $table . '][colums][' . $column . ']', 'value' => $columnName, ]) |
/libraries/classes/Display/Results.php:5018 | 1 | $sqlQuery = 'SELECT * FROM ' . Util::backquote($map[$meta->name][3]) . '.' . Util::backquote($map[$meta->name][0]) . ' WHERE ' . Util::backquote($map[$meta->name][1]) . $where_comparison |
/libraries/classes/Display/Results.php:5025 | 1 | $_url_params = ['db' => $map[$meta->name][3], 'table' => $map[$meta->name][0], 'pos' => '0', 'sql_signature' => Core::signSqlQuery($sqlQuery), 'sql_query' => $sqlQuery, ] |
/libraries/classes/Display/Results.php:4641 | 1 | $results_operations_html .= Generator::linkOrButton(Url::getFromRoute('/view/create', ['db' => $this->__get('db'), 'table' => $this->__get('table'), 'printview' => '1', 'sql_query' => $this->__get('sql_query'), ]), Generator::getIcon('b_view_add', __('Create view'), true), ['class' => 'create_view ajax btn']) |
/libraries/classes/Display/Results.php:4873 | 1 | $dispsql = 'SELECT ' . Util::backquote($map[$meta->name][2]) . ' FROM ' . Util::backquote($map[$meta->name][3]) . '.' . Util::backquote($map[$meta->name][0]) . ' WHERE ' . Util::backquote($map[$meta->name][1]) . $where_comparison |
/libraries/classes/Controllers/BrowseForeignersController.php:43 | 1 | $params = ['db' => $_POST['db'] ?? null, 'table' => $_POST['table'] ?? null, 'field' => $_POST['field'] ?? null, 'fieldkey' => $_POST['fieldkey'] ?? null, 'data' => $_POST['data'] ?? null, 'foreign_showAll' => $_POST['foreign_showAll'] ?? null, 'foreign_filter' => $_POST['foreign_filter'] ?? null, ] |
/libraries/classes/Controllers/ChangeLogController.php:64 | 1 | $replaces = ['@(https?://[./a-zA-Z0-9.-_-]*[/a-zA-Z0-9_])@' => '<a href="url.php?url=\\1">\\1</a>', '/([0-9]{4}-[0-9]{2}-[0-9]{2}) (.+[^ ]) +<(.*@.*)>/i' => '\\1 <a href="mailto:\\3">\\2</a>', '/FAQ ([0-9]+)\.([0-9a-z]+)/i' => '<a href="url.php?url=' . $faq_url . '#faq\\1-\\2">FAQ \\1.\\2</a>', '/issue\s*#?([0-9]{4,5}) /i' => '<a href="url.php?url=' . $github_url . 'issues/\\1">issue #\\1</a> ', '/((CAN|CVE)-[0-9]+-[0-9]+)/' => '<a href="url.php?url=https://cve.mitre.org/cgi-bin/cvename.cgi?name=\\1">\\1</a>', '/(PMASA-[0-9]+-[0-9]+)/' => '<a href="url.php?url=https://www.phpmyadmin.net/security/\\1/">\\1</a>', '/([0-9]+)\.([0-9]+)\.([0-9]+)\.0 (\([0-9-]+\))/' => '<a id="\\1_\\2_\\3"></a>' . '<a href="url.php?url=' . $github_url . 'commits/RELEASE_\\1_\\2_\\3">' . '\\1.\\2.\\3.0 \\4</a>', '/([0-9]+)\.([0-9]+)\.([0-9]+)\.([1-9][0-9]*) (\([0-9-]+\))/' => '<a id="\\1_\\2_\\3_\\4"></a>' . '<a href="url.php?url=' . $github_url . 'commits/RELEASE_\\1_\\2_\\3_\\4">' . '\\1.\\2.\\3.\\4 \\5</a>', '/( ### )(.*)/' => '\\1<b>\\2</b>', '/a href="/' => 'a target="_blank" rel="noopener noreferrer" href="', ] |
/libraries/classes/Controllers/GisDataEditorController.php:132 | 1 | $templateOutput = $this->template->render('gis_data_editor_form', ['width' => $visualizationSettings['width'], 'height' => $visualizationSettings['height'], 'pma_theme_image' => $GLOBALS['pmaThemeImage'], 'field' => $_POST['field'], 'input_name' => $_POST['input_name'], 'srid' => $srid, 'visualization' => $visualization, 'open_layers' => $open_layers, 'gis_types' => $gis_types, 'geom_type' => $geom_type, 'geom_count' => $geom_count, 'gis_data' => $gis_data, 'result' => $result, ]) |
/libraries/classes/Controllers/HomeController.php:221 | 1 | $phpInfo = $this->template->render('list/item', ['content' => __('Show PHP information'), 'id' => null, 'class' => 'list-group-item', 'url' => ['href' => Url::getFromRoute('/phpinfo'), 'target' => '_blank', 'id' => null, 'class' => null, ], 'mysql_help_page' => null, ]) |
/libraries/classes/Controllers/HomeController.php:194 | 1 | $databaseServer = ['host' => $hostInfo, 'type' => Util::getServerType( ), 'connection' => Generator::getServerSSL( ), 'version' => $this->dbi->getVersionString( ) . ' - ' . $this->dbi->getVersionComment( ), 'protocol' => $this->dbi->getProtoInfo( ), 'user' => $this->dbi->fetchValue('SELECT USER();'), 'charset' => $serverCharset->getDescription( ) . ' (' . $serverCharset->getName( ) . ')', ] |
/libraries/classes/Controllers/HomeController.php:150 | 1 | $userPreferences = $this->template->render('list/item', ['content' => Generator::getImage('b_tblops') . ' ' . __('More settings'), 'id' => 'li_user_preferences', 'class' => 'list-group-item', 'url' => ['href' => Url::getFromRoute('/preferences/manage'), 'target' => null, 'id' => null, 'class' => null, ], 'mysql_help_page' => null, ]) |
/libraries/classes/Controllers/HomeController.php:113 | 1 | $changePassword = $this->template->render('list/item', ['content' => Generator::getImage('s_passwd') . ' ' . __('Change password'), 'id' => 'li_change_password', 'class' => 'list-group-item', 'url' => ['href' => Url::getFromRoute('/user-password'), 'target' => null, 'id' => 'change_password_anchor', 'class' => 'ajax', ], 'mysql_help_page' => null, ]) |
/libraries/classes/Controllers/HomeController.php:100 | 1 | $hasServerSelection = $cfg['ServerDefault'] == 0 || (!$cfg['NavigationDisplayServers'] && (count($cfg['Servers']) > 1 || ($server == 0 && count($cfg['Servers']) === 1))) |
/libraries/classes/Controllers/Database/StructureController.php:1228 | 1 | $ignored = (is_string($searchTable) && strlen($searchTable) > 0) || (is_string($searchDb) && strlen($searchDb) > 0) || $this->hasTable($GLOBALS['replication_info']['slave']['Wild_Ignore_Table'], $table) |
/libraries/classes/Controllers/Database/StructureController.php:1212 | 1 | $do = (is_string($searchDoDBInTruename) && strlen($searchDoDBInTruename) > 0) || (is_string($searchDoDBInDB) && strlen($searchDoDBInDB) > 0) || ($nbServSlaveDoDb == 0 && $nbServSlaveIgnoreDb == 0) || $this->hasTable($GLOBALS['replication_info']['slave']['Wild_Do_Table'], $table) |
/libraries/classes/Controllers/Database/StructureController.php:980 | 1 | $structure_table_rows[] = ['table_name_hash' => md5($current_table['TABLE_NAME']), 'db_table_name_hash' => md5($this->db . '.' . $current_table['TABLE_NAME']), 'db' => $this->db, 'curr' => $i, 'input_class' => implode(' ', $input_class), 'table_is_view' => $table_is_view, 'current_table' => $current_table, 'browse_table_title' => $may_have_rows ? $titles['Browse'] : $titles['NoBrowse'], 'search_table_title' => $may_have_rows ? $titles['Search'] : $titles['NoSearch'], 'browse_table_label_title' => htmlspecialchars($current_table['TABLE_COMMENT']), 'browse_table_label_truename' => $truename, 'empty_table_sql_query' => 'TRUNCATE ' . Util::backquote($current_table['TABLE_NAME']), 'empty_table_message_to_show' => urlencode(sprintf(__('Table %s has been emptied.'), htmlspecialchars($current_table['TABLE_NAME']))), 'empty_table_title' => $may_have_rows ? $titles['Empty'] : $titles['NoEmpty'], 'tracking_icon' => $this->getTrackingIcon($truename), 'server_slave_status' => $GLOBALS['replication_info']['slave']['status'], 'table_url_params' => $tableUrlParams, 'db_is_system_schema' => $this->dbIsSystemSchema, 'titles' => $titles, 'drop_query' => $drop_query, 'drop_message' => $drop_message, 'collation' => $collationDefinition, 'formatted_size' => $formatted_size, 'unit' => $unit, 'overhead' => $overhead, 'create_time' => isset($create_time) && $create_time ? Util::localisedDate(strtotime($create_time)) : '-', 'update_time' => isset($update_time) && $update_time ? Util::localisedDate(strtotime($update_time)) : '-', 'check_time' => isset($check_time) && $check_time ? Util::localisedDate(strtotime($check_time)) : '-', 'charset' => $charset ?? '', 'is_show_stats' => $this->isShowStats, 'ignored' => $ignored, 'do' => $do, 'approx_rows' => $approx_rows, 'show_superscript' => $show_superscript, 'already_favorite' => $this->checkFavoriteTable($current_table['TABLE_NAME']), 'num_favorite_tables' => $GLOBALS['cfg']['NumFavoriteTables'], 'properties_num_columns' => $GLOBALS['cfg']['PropertiesNumColumns'], 'limit_chars' => $GLOBALS['cfg']['LimitChars'], 'show_charset' => $GLOBALS['cfg']['ShowDbStructureCharset'], 'show_comment' => $GLOBALS['cfg']['ShowDbStructureComment'], 'show_creation' => $GLOBALS['cfg']['ShowDbStructureCreation'], 'show_last_update' => $GLOBALS['cfg']['ShowDbStructureLastUpdate'], 'show_last_check' => $GLOBALS['cfg']['ShowDbStructureLastCheck'], ] |
/libraries/classes/Controllers/Database/StructureController.php:956 | 1 | $html .= $this->template->render('database/structure/table_header', ['db' => $this->db, 'db_is_system_schema' => $this->dbIsSystemSchema, 'replication' => $GLOBALS['replication_info']['slave']['status'], 'properties_num_columns' => $GLOBALS['cfg']['PropertiesNumColumns'], 'is_show_stats' => $GLOBALS['is_show_stats'], 'show_charset' => $GLOBALS['cfg']['ShowDbStructureCharset'], 'show_comment' => $GLOBALS['cfg']['ShowDbStructureComment'], 'show_creation' => $GLOBALS['cfg']['ShowDbStructureCreation'], 'show_last_update' => $GLOBALS['cfg']['ShowDbStructureLastUpdate'], 'show_last_check' => $GLOBALS['cfg']['ShowDbStructureLastCheck'], 'num_favorite_tables' => $GLOBALS['cfg']['NumFavoriteTables'], 'structure_table_rows' => $structure_table_rows, ]) |
/libraries/classes/Controllers/Database/StructureController.php:305 | 1 | $json['anchor'] = $this->template->render('database/structure/favorite_anchor', ['table_name_hash' => md5($favoriteTable), 'db_table_name_hash' => md5($this->db . '.' . $favoriteTable), 'fav_params' => $favoriteParams, 'already_favorite' => $alreadyFavorite, 'titles' => $titles, ]) |
/libraries/classes/Controllers/Database/ExportController.php:94 | 1 | $multi_values .= '<table class="export_table_select">' . '<thead><tr><th></th>' . '<th>' . __('Tables') . '</th>' . '<th class="export_structure">' . __('Structure') . '</th>' . '<th class="export_data">' . __('Data') . '</th>' . '</tr><tr>' . '<td></td>' . '<td class="export_table_name all">' . __('Select all') . '</td>' . '<td class="export_structure all">' . '<input type="checkbox" id="table_structure_all"></td>' . '<td class="export_data all"><input type="checkbox" id="table_data_all">' . '</td>' . '</tr></thead>' . '<tbody>' |
/libraries/classes/Controllers/Database/CentralColumnsController.php:108 | 1 | $message = $this->updateMultipleColumn(['db' => $_POST['db'] ?? null, 'orig_col_name' => $_POST['orig_col_name'] ?? null, 'field_name' => $_POST['field_name'] ?? null, 'field_default_type' => $_POST['field_default_type'] ?? null, 'field_default_value' => $_POST['field_default_value'] ?? null, 'field_length' => $_POST['field_length'] ?? null, 'field_attribute' => $_POST['field_attribute'] ?? null, 'field_type' => $_POST['field_type'] ?? null, 'field_collation' => $_POST['field_collation'] ?? null, 'field_null' => $_POST['field_null'] ?? null, 'col_extra' => $_POST['col_extra'] ?? null, ]) |
/libraries/classes/Controllers/Database/CentralColumnsController.php:60 | 1 | $tmp_msg = $this->addNewColumn(['col_name' => $_POST['col_name'] ?? null, 'col_default' => $_POST['col_default'] ?? null, 'col_default_sel' => $_POST['col_default_sel'] ?? null, 'col_extra' => $_POST['col_extra'] ?? null, 'col_isNull' => $_POST['col_isNull'] ?? null, 'col_length' => $_POST['col_length'] ?? null, 'col_attribute' => $_POST['col_attribute'] ?? null, 'col_type' => $_POST['col_type'] ?? null, 'collation' => $_POST['collation'] ?? null, ]) |
/libraries/classes/Navigation/Nodes/NodeTriggerContainer.php:26 | 1 | $this->links = ['text' => Url::getFromRoute('/database/triggers', ['server' => $GLOBALS['server'], ]) . '&db=%2$s&table=%1$s', 'icon' => Url::getFromRoute('/database/triggers', ['server' => $GLOBALS['server'], ]) . '&db=%2$s&table=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeTriggerContainer.php:42 | 1 | $new->links = ['text' => Url::getFromRoute('/database/triggers', ['server' => $GLOBALS['server'], 'add_item' => 1, ]) . '&db=%3$s', 'icon' => Url::getFromRoute('/database/triggers', ['server' => $GLOBALS['server'], 'add_item' => 1, ]) . '&db=%3$s', ] |
/libraries/classes/Navigation/Nodes/NodeEvent.php:30 | 1 | $this->links = ['text' => Url::getFromRoute('/database/events', ['server' => $GLOBALS['server'], 'edit_item' => 1, ]) . '&db=%2$s&item_name=%1$s', 'icon' => Url::getFromRoute('/database/events', ['server' => $GLOBALS['server'], 'export_item' => 1, ]) . '&db=%2$s&item_name=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeFunction.php:30 | 1 | $this->links = ['text' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'item_type' => 'FUNCTION', 'edit_item' => 1, ]) . '&db=%2$s&item_name=%1$s', 'icon' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'item_type' => 'FUNCTION', 'execute_dialog' => 1, ]) . '&db=%2$s&item_name=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeIndex.php:30 | 1 | $this->links = ['text' => Url::getFromRoute('/table/indexes', ['server' => $GLOBALS['server'], ]) . '&db=%3$s&table=%2$s&index=%1$s', 'icon' => Url::getFromRoute('/table/indexes', ['server' => $GLOBALS['server'], ]) . '&db=%3$s&table=%2$s&index=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeDatabase.php:51 | 1 | $this->links = ['text' => $scriptName . ($hasRoute === false ? '?' : '&') . 'server=' . $GLOBALS['server'] . '&db=%1$s', 'icon' => Url::getFromRoute('/database/operations') . '&server=' . $GLOBALS['server'] . '&db=%1$s&', 'title' => __('Structure'), ] |
/libraries/classes/Server/Privileges.php:178 | 1 | $av_grants = explode('\',\'', mb_substr($row1['Type'], mb_strpos($row1['Type'], '(') + 2, mb_strpos($row1['Type'], ')') - mb_strpos($row1['Type'], '(') - 3)) |
/libraries/classes/Server/Privileges.php:730 | 1 | $res = $this->dbi->query('SELECT `Column_name`, `Column_priv`' . ' FROM `mysql`.`columns_priv`' . ' WHERE `User`' . ' = \'' . $this->dbi->escapeString($username) . "'" . ' AND `Host`' . ' = \'' . $this->dbi->escapeString($hostname) . "'" . ' AND `Db`' . ' = \'' . $this->dbi->escapeString(Util::unescapeMysqlWildcards($db)) . "'" . ' AND `Table_name`' . ' = \'' . $this->dbi->escapeString($table) . '\';') |
/libraries/classes/Server/Privileges.php:1104 | 2 | $sql_query = 'SET PASSWORD FOR \'' . $this->dbi->escapeString($username) . '\'@\'' . $this->dbi->escapeString($hostname) . '\' = ' . ($_POST['pma_pw'] == '' ? '\'\'' : $hashing_function . '(\'' . preg_replace('@.@s', '*', $_POST['pma_pw']) . '\')') |
/libraries/classes/Server/Privileges.php:1150 | 2 | $sql_query = 'SET PASSWORD FOR \'' . $this->dbi->escapeString($username) . '\'@\'' . $this->dbi->escapeString($hostname) . '\' = ' . ($_POST['pma_pw'] == '' ? '\'\'' : $hashing_function . '(\'' . preg_replace('@.@s', '*', $_POST['pma_pw']) . '\')') |
/libraries/classes/Server/Privileges.php:1158 | 1 | $local_query = 'SET PASSWORD FOR \'' . $this->dbi->escapeString($username) . '\'@\'' . $this->dbi->escapeString($hostname) . '\' = ' . ($_POST['pma_pw'] == '' ? '\'\'' : $hashing_function . '(\'' . $this->dbi->escapeString($_POST['pma_pw']) . '\')') |
/libraries/classes/Server/Privileges.php:1739 | 1 | $user = ['name' => $username, 'host' => $hostname, 'has_password' => !empty($password) || isset($_POST['pma_pw']), 'privileges' => implode(', ', $this->extractPrivInfo(null, true)), 'has_group' => !empty($cfgRelation['users']) && !empty($cfgRelation['usergroups']), 'has_group_edit' => $cfgRelation['menuswork'] && $user_group_count > 0, 'has_grant' => isset($_POST['Grant_priv']) && $_POST['Grant_priv'] == 'Y', ] |
/libraries/classes/Server/Privileges.php:1959 | 1 | $uiData = ['database' => ['form_id' => 'database_specific_priv', 'sub_menu_label' => __('Database'), 'legend' => __('Database-specific privileges'), 'type_label' => __('Database'), ], 'table' => ['form_id' => 'table_specific_priv', 'sub_menu_label' => __('Table'), 'legend' => __('Table-specific privileges'), 'type_label' => __('Table'), ], 'routine' => ['form_id' => 'routine_specific_priv', 'sub_menu_label' => __('Routine'), 'legend' => __('Routine-specific privileges'), 'type_label' => __('Routine'), ], ] |
/libraries/classes/Server/Privileges.php:2189 | 1 | $hosts[] = ['user' => $host['User'], 'host' => $host['Host'], 'has_password' => $hasPassword, 'has_select_priv' => isset($host['Select_priv']), 'privileges' => $host['privs'], 'group' => $group_assignment[$host['User']] ?? '', 'has_grant' => $host['Grant_priv'] == 'Y', ] |
/libraries/classes/Server/Privileges.php:2449 | 1 | $grantBackQuery = 'GRANT ' . implode(', ', $this->extractPrivInfo( )) . ' ON ' . $itemType . ' ' . $db_and_table . ' TO \'' . $this->dbi->escapeString($username) . '\'@\'' . $this->dbi->escapeString($hostname) . '\'' |
/libraries/classes/Server/Privileges.php:3394 | 1 | $res2 = $this->dbi->query('SELECT `Column_name`, `Column_priv`' . ' FROM `mysql`.`columns_priv`' . ' WHERE `User`' . ' = \'' . $this->dbi->escapeString($_POST['old_username']) . "'" . ' AND `Host`' . ' = \'' . $this->dbi->escapeString($_POST['old_username']) . '\'' . ' AND `Db`' . ' = \'' . $this->dbi->escapeString($row['Db']) . "'" . ' AND `Table_name`' . ' = \'' . $this->dbi->escapeString($row['Table_name']) . "'" . ';', DatabaseInterface::CONNECT_USER, DatabaseInterface::QUERY_STORE) |
/libraries/classes/Server/Privileges.php:3488 | 1 | $queries[] = 'GRANT ' . implode(', ', $this->extractPrivInfo($row)) . ' ON ' . Util::backquote($row['Db']) . '.*' . ' TO \'' . $this->dbi->escapeString($username) . '\'@\'' . $this->dbi->escapeString($hostname) . '\'' . ($row['Grant_priv'] == 'Y' ? ' WITH GRANT OPTION;' : ';') |
/libraries/classes/Server/Privileges.php:3451 | 1 | $queries[] = 'GRANT ' . implode(', ', $tmp_privs1) . ' ON ' . Util::backquote($row['Db']) . '.' . Util::backquote($row['Table_name']) . ' TO \'' . $this->dbi->escapeString($username) . '\'@\'' . $this->dbi->escapeString($hostname) . '\'' . (in_array('Grant', explode(',', $row['Table_priv'])) ? ' WITH GRANT OPTION;' : ';') |
/libraries/classes/Server/Privileges.php:3579 | 1 | $q = 'GRANT ALL PRIVILEGES ON ' . Util::backquote(Util::escapeMysqlWildcards($this->dbi->escapeString($username)) . '\_%') . '.* TO \'' . $this->dbi->escapeString($username) . '\'@\'' . $this->dbi->escapeString($hostname) . '\';' |
/libraries/classes/Server/Privileges.php:3563 | 1 | $q = 'GRANT ALL PRIVILEGES ON ' . Util::backquote(Util::escapeMysqlWildcards($this->dbi->escapeString($username))) . '.* TO \'' . $this->dbi->escapeString($username) . '\'@\'' . $this->dbi->escapeString($hostname) . '\';' |
/libraries/classes/Table/ColumnsDefinition.php:182 | 1 | $columnMeta = array_merge($columnMeta, ['Field' => Util::getValueByKey($_POST, "field_name.${columnNumber}", null), 'Type' => Util::getValueByKey($_POST, "field_type.${columnNumber}", null), 'Collation' => Util::getValueByKey($_POST, "field_collation.${columnNumber}", ''), 'Null' => Util::getValueByKey($_POST, "field_null.${columnNumber}", ''), 'DefaultType' => Util::getValueByKey($_POST, "field_default_type.${columnNumber}", 'NONE'), 'DefaultValue' => Util::getValueByKey($_POST, "field_default_value.${columnNumber}", ''), 'Extra' => Util::getValueByKey($_POST, "field_extra.${columnNumber}", null), 'Virtuality' => Util::getValueByKey($_POST, "field_virtuality.${columnNumber}", ''), 'Expression' => Util::getValueByKey($_POST, "field_expression.${columnNumber}", ''), ]) |
/libraries/classes/Server/Privileges.php:3950 | 1 | $sql = 'SELECT `Proc_priv`' . ' FROM `mysql`.`procs_priv`' . " WHERE `User` = '" . $this->dbi->escapeString($username) . "'" . " AND `Host` = '" . $this->dbi->escapeString($hostname) . "'" . " AND `Db` = '" . $this->dbi->escapeString(Util::unescapeMysqlWildcards($database)) . "'" . " AND `Routine_name` LIKE '" . $this->dbi->escapeString($routine) . "';" |
/libraries/classes/Table/ColumnsDefinition.php:417 | 1 | $form_params = array_merge($form_params, ["field_default_value_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Default', ''), "field_default_type_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'DefaultType', ''), "field_collation_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Collation', ''), "field_attribute_orig[${columnNumber}]" => trim(Util::getValueByKey($extracted_columnspec, 'attribute', '')), "field_null_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Null', ''), "field_extra_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Extra', ''), "field_comments_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Comment', ''), "field_virtuality_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Virtuality', ''), "field_expression_orig[${columnNumber}]" => Util::getValueByKey($columnMeta, 'Expression', ''), ]) |
/libraries/classes/Table/ColumnsDefinition.php:283 | 1 | $mime_map[$columnMeta['Field']] = array_merge($mime_map[$columnMeta['Field']] ?? [ ], ['mimetype' => Util::getValueByKey($_POST, "field_mimetype.${columnNumber}"), 'transformation' => Util::getValueByKey($_POST, "field_transformation.${columnNumber}"), 'transformation_options' => Util::getValueByKey($_POST, "field_transformation_options.${columnNumber}"), ]) |
/libraries/classes/Table/ColumnsDefinition.php:523 | 1 | $html = $template->render('columns_definitions/column_definitions_form', ['is_backup' => $is_backup, 'fields_meta' => $fields_meta ?? null, 'mimework' => $cfgRelation['mimework'], 'action' => $action, 'form_params' => $form_params, 'content_cells' => $content_cells, 'partition_details' => $partitionDetails, 'primary_indexes' => $_POST['primary_indexes'] ?? null, 'unique_indexes' => $_POST['unique_indexes'] ?? null, 'indexes' => $_POST['indexes'] ?? null, 'fulltext_indexes' => $_POST['fulltext_indexes'] ?? null, 'spatial_indexes' => $_POST['spatial_indexes'] ?? null, 'table' => $_POST['table'] ?? null, 'comment' => $_POST['comment'] ?? null, 'tbl_collation' => $_POST['tbl_collation'] ?? null, 'charsets' => $charsetsList, 'tbl_storage_engine' => $_POST['tbl_storage_engine'] ?? null, 'storage_engines' => $storageEngines, 'connection' => $_POST['connection'] ?? null, 'change_column' => $_POST['change_column'] ?? $_GET['change_column'] ?? null, 'is_virtual_columns_supported' => Util::isVirtualColumnsSupported( ), 'browse_mime' => $cfg['BrowseMIME'] ?? null, 'server_type' => Util::getServerType( ), 'server_version' => $dbi->getVersion( ), 'max_rows' => intval($cfg['MaxRows']), 'char_editing' => $cfg['CharEditing'] ?? null, 'attribute_types' => $dbi->types->getAttributes( ), 'privs_available' => ($col_priv ?? false) && ($is_reload_priv ?? false), 'max_length' => $dbi->getVersion( ) >= 50503 ? 1024 : 255, 'have_partitioning' => Partition::havePartitioning( ), 'dbi' => $dbi, 'disable_is' => $cfg['Server']['DisableIS'], ]) |
/libraries/classes/Table/ColumnsDefinition.php:480 | 1 | $content_cells[$columnNumber] = ['column_number' => $columnNumber, 'column_meta' => $columnMeta, 'type_upper' => $type_upper, 'default_value' => $default_value, 'length_values_input_size' => $length_values_input_size, 'length' => $length, 'extracted_columnspec' => $extracted_columnspec, 'submit_attribute' => $submit_attribute, 'comments_map' => $comments_map, 'fields_meta' => $fields_meta ?? null, 'is_backup' => $is_backup, 'move_columns' => $move_columns, 'cfg_relation' => $cfgRelation, 'available_mime' => $available_mime, 'mime_map' => $mime_map ?? [ ], ] |
/libraries/classes/Engines/Innodb.php:217 | 1 | $output .= ' </tbody>' . "\n" . '</table>' . "\n\n" . '<table class="data" id="table_innodb_bufferpool_activity">' . "\n" . ' <caption class="tblHeaders">' . "\n" . ' ' . __('Buffer Pool Activity') . "\n" . ' </caption>' . "\n" . ' <tbody>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Read requests') . '</th>' . "\n" . ' <td class="value">' . Util::formatNumber($status['Innodb_buffer_pool_read_requests'], 0) . "\n" . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Write requests') . '</th>' . "\n" . ' <td class="value">' . Util::formatNumber($status['Innodb_buffer_pool_write_requests'], 0) . "\n" . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Read misses') . '</th>' . "\n" . ' <td class="value">' . Util::formatNumber($status['Innodb_buffer_pool_reads'], 0) . "\n" . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Write waits') . '</th>' . "\n" . ' <td class="value">' . Util::formatNumber($status['Innodb_buffer_pool_wait_free'], 0) . "\n" . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Read misses in %') . '</th>' . "\n" . ' <td class="value">' . ($status['Innodb_buffer_pool_read_requests'] == 0 ? '---' : htmlspecialchars(Util::formatNumber($status['Innodb_buffer_pool_reads'] * 100 / $status['Innodb_buffer_pool_read_requests'], 3, 2)) . ' %') . "\n" . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Write waits in %') . '</th>' . "\n" . ' <td class="value">' . ($status['Innodb_buffer_pool_write_requests'] == 0 ? '---' : htmlspecialchars(Util::formatNumber($status['Innodb_buffer_pool_wait_free'] * 100 / $status['Innodb_buffer_pool_write_requests'], 3, 2)) . ' %') . "\n" . '</td>' . "\n" . ' </tr>' . "\n" . ' </tbody>' . "\n" . '</table>' . "\n" |
/libraries/classes/Engines/Innodb.php:132 | 1 | $output = '<table class="data" id="table_innodb_bufferpool_usage">' . "\n" . ' <caption class="tblHeaders">' . "\n" . ' ' . __('Buffer Pool Usage') . "\n" . ' </caption>' . "\n" . ' <tfoot>' . "\n" . ' <tr>' . "\n" . ' <th colspan="2">' . "\n" . ' ' . __('Total') . "\n" . ' : ' . Util::formatNumber($status['Innodb_buffer_pool_pages_total'], 0) . ' ' . __('pages') . ' / ' . implode(' ', Util::formatByteDown($status['Innodb_buffer_pool_pages_total'] * $status['Innodb_page_size'])) . "\n" . ' </th>' . "\n" . ' </tr>' . "\n" . ' </tfoot>' . "\n" . ' <tbody>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Free pages') . '</th>' . "\n" . ' <td class="value">' . Util::formatNumber($status['Innodb_buffer_pool_pages_free'], 0) . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Dirty pages') . '</th>' . "\n" . ' <td class="value">' . Util::formatNumber($status['Innodb_buffer_pool_pages_dirty'], 0) . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Pages containing data') . '</th>' . "\n" . ' <td class="value">' . Util::formatNumber($status['Innodb_buffer_pool_pages_data'], 0) . "\n" . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Pages to be flushed') . '</th>' . "\n" . ' <td class="value">' . Util::formatNumber($status['Innodb_buffer_pool_pages_flushed'], 0) . "\n" . '</td>' . "\n" . ' </tr>' . "\n" . ' <tr>' . "\n" . ' <th>' . __('Busy pages') . '</th>' . "\n" . ' <td class="value">' . Util::formatNumber($status['Innodb_buffer_pool_pages_misc'], 0) . "\n" . '</td>' . "\n" . ' </tr>' |
/libraries/classes/Display/Results.php:816 | 1 | $_url_params = ['db' => $this->__get('db'), 'table' => $this->__get('table'), 'sql_query' => $this->__get('sql_query'), 'goto' => $this->__get('goto'), 'is_browse_distinct' => $this->__get('is_browse_distinct'), ] |
/libraries/classes/Display/Results.php:323 | 1 | $this->transformation_info = ['information_schema' => ['events' => ['event_definition' => $sql_highlighting_data], 'processlist' => ['info' => $sql_highlighting_data], 'routines' => ['routine_definition' => $sql_highlighting_data], 'triggers' => ['action_statement' => $sql_highlighting_data], 'views' => ['view_definition' => $sql_highlighting_data], ], 'mysql' => ['event' => ['body' => $blob_sql_highlighting_data, 'body_utf8' => $blob_sql_highlighting_data, ], 'general_log' => ['argument' => $sql_highlighting_data], 'help_category' => ['url' => $link_data], 'help_topic' => ['example' => $sql_highlighting_data, 'url' => $link_data, ], 'proc' => ['param_list' => $blob_sql_highlighting_data, 'returns' => $blob_sql_highlighting_data, 'body' => $blob_sql_highlighting_data, 'body_utf8' => $blob_sql_highlighting_data, ], 'slow_log' => ['sql_text' => $sql_highlighting_data], ], ] |
/libraries/classes/Display/Results.php:1563 | 1 | $url_params_full_text = ['db' => $this->__get('db'), 'table' => $this->__get('table'), 'sql_query' => $this->__get('sql_query'), 'goto' => $this->__get('goto'), 'full_text_button' => 1, ] |
/libraries/classes/Display/Results.php:898 | 1 | $hiddenFields = ['db' => $this->__get('db'), 'table' => $this->__get('table'), 'server' => $this->__get('server'), 'sql_query' => $this->__get('sql_query'), 'is_browse_distinct' => $this->__get('is_browse_distinct'), 'goto' => $this->__get('goto'), ] |
/libraries/classes/Plugins/Export/ExportSql.php:2025 | 1 | $schema_create .= $this->exportComment(' ' . Util::backquote($rel_field_alias, $sql_backquotes)) . $this->exportComment(' ' . Util::backquote($one_key['ref_table_name'], $sql_backquotes) . ' -> ' . Util::backquote($one_key['ref_index_list'][$index], $sql_backquotes)) |
/libraries/classes/Plugins/Export/ExportSql.php:2306 | 1 | $head = $this->possibleCRLF( ) . $this->exportComment( ) . $this->exportComment('VIEW ' . $formatted_table_name) . $this->exportComment(__('Data:') . ' ' . __('None')) . $this->exportComment( ) . $this->possibleCRLF( ) |
/libraries/classes/Plugins/Export/ExportSql.php:1243 | 1 | $sql_query .= Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation[$type]) . ' WHERE ' . Util::backquote($dbNameColumn) . " = '" . $GLOBALS['dbi']->escapeString($db) . "'" |
/libraries/classes/Plugins/Export/ExportSql.php:1999 | 1 | $schema_create .= $this->exportComment(' ' . Util::backquote($rel_field_alias, $sql_backquotes)) . $this->exportComment(' ' . Util::backquote($rel['foreign_table'], $sql_backquotes) . ' -> ' . Util::backquote($rel['foreign_field'], $sql_backquotes)) |
/libraries/classes/Navigation/NavigationTree.php:346 | 1 | $retval = $this->buildPathPart($path, $this->pos2Name[$key] ?? '', $this->pos2Value[$key] ?? 0, $this->pos3Name[$key] ?? '', $this->pos3Value[$key] ?? 0) |
/libraries/classes/Navigation/NavigationTree.php:1311 | 1 | $listNavigator = Generator::getListNavigator($this->tree->getPresence('databases', ''), $this->pos, ['server' => $GLOBALS['server']], Url::getFromRoute('/navigation'), 'frame_navigation', $GLOBALS['cfg']['FirstLevelNavigationItems'], 'pos', ['dbselector']) |
/libraries/classes/Plugins/Export/ExportXml.php:253 | 1 | $head .= $crlf . '- ' . __('Generation Time:') . ' ' . Util::localisedDate( ) . $crlf . '- ' . __('Server version:') . ' ' . $GLOBALS['dbi']->getVersionString( ) . $crlf . '- ' . __('PHP Version:') . ' ' . PHP_VERSION . $crlf . '-->' . $crlf . $crlf |
/libraries/classes/Plugins/Export/Helpers/TableProperty.php:261 | 1 | $text = str_replace(['#ucfirstName#', '#dotNetPrimitiveType#', '#dotNetObjectType#', '#type#', '#notNull#', '#unique#', ], [ExportCodegen::cgMakeIdentifier($this->name), $this->getDotNetPrimitiveType( ), $this->getDotNetObjectType( ), $this->getPureType( ), $this->isNotNull( ), $this->isUnique( ), ], $text) |
/libraries/classes/Navigation/Navigation.php:186 | 1 | $sqlQuery = 'DELETE FROM ' . $navTable . ' WHERE' . " `username`='" . $this->dbi->escapeString($GLOBALS['cfg']['Server']['user']) . "'" . " AND `item_name`='" . $this->dbi->escapeString($itemName) . "'" . " AND `item_type`='" . $this->dbi->escapeString($itemType) . "'" . " AND `db_name`='" . $this->dbi->escapeString($dbName) . "'" . (!empty($tableName) ? " AND `table_name`='" . $this->dbi->escapeString($tableName) . "'" : '') |
/libraries/classes/Navigation/Navigation.php:213 | 1 | $typeMap = ['group' => __('Groups:'), 'event' => __('Events:'), 'function' => __('Functions:'), 'procedure' => __('Procedures:'), 'table' => __('Tables:'), 'view' => __('Views:'), ] |
/libraries/classes/Navigation/NavigationTree.php:1522 | 1 | $retval .= Generator::getListNavigator($this->tree->getPresence('databases', $this->searchClause), $this->pos, ['server' => $GLOBALS['server']], Url::getFromRoute('/navigation'), 'frame_navigation', $GLOBALS['cfg']['FirstLevelNavigationItems'], 'pos', ['dbselector']) |
/libraries/classes/Navigation/Navigation.php:155 | 1 | $sqlQuery = 'INSERT INTO ' . $navTable . '(`username`, `item_name`, `item_type`, `db_name`, `table_name`)' . ' VALUES (' . "'" . $this->dbi->escapeString($GLOBALS['cfg']['Server']['user']) . "'," . "'" . $this->dbi->escapeString($itemName) . "'," . "'" . $this->dbi->escapeString($itemType) . "'," . "'" . $this->dbi->escapeString($dbName) . "'," . "'" . (!empty($tableName) ? $this->dbi->escapeString($tableName) : '') . "')" |
/libraries/classes/Navigation/Nodes/NodeFunctionContainer.php:44 | 1 | $new->links = ['text' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'item_type' => 'FUNCTION', 'add_item' => 1, ]) . '&db=%2$s', 'icon' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'item_type' => 'FUNCTION', 'add_item' => 1, ]) . '&db=%2$s', ] |
/libraries/classes/Navigation/Nodes/NodeColumn.php:34 | 1 | $this->links = ['text' => Url::getFromRoute('/table/structure/change', ['server' => $GLOBALS['server'], 'change_column' => 1, ]) . '&db=%3$s&table=%2$s&field=%1$s', 'icon' => Url::getFromRoute('/table/structure/change', ['server' => $GLOBALS['server'], 'change_column' => 1, ]) . '&db=%3$s&table=%2$s&field=%1$s', 'title' => __('Structure'), ] |
/libraries/classes/Navigation/Navigation.php:241 | 1 | $sqlQuery = 'SELECT `item_name`, `item_type` FROM ' . $navTable . " WHERE `username`='" . $this->dbi->escapeString($GLOBALS['cfg']['Server']['user']) . "'" . " AND `db_name`='" . $this->dbi->escapeString($database) . "'" . " AND `table_name`='" . (!empty($table) ? $this->dbi->escapeString($table) : '') . "'" |
/libraries/classes/Navigation/Nodes/NodeFunctionContainer.php:26 | 1 | $this->links = ['text' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'type' => 'FUNCTION', ]) . '&db=%1$s', 'icon' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'type' => 'FUNCTION', ]) . '&db=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeTable.php:206 | 1 | $retval[] = ['name' => $arr['Field'], 'key' => $arr['Key'], 'type' => Util::extractColumnSpec($arr['Type'])['type'], 'default' => $arr['Default'], 'nullable' => ($arr['Null'] === 'NO' ? '' : 'nullable'), ] |
/libraries/classes/Navigation/Nodes/NodeTable.php:66 | 1 | $this->links = ['text' => $scriptName . (strpos($scriptName, '?') === false ? '?' : '&') . 'server=' . $GLOBALS['server'] . '&db=%2$s&table=%1$s' . '&pos=0', 'icon' => [$firstIconLink . (strpos($firstIconLink, '?') === false ? '?' : '&') . 'server=' . $GLOBALS['server'] . '&db=%2$s&table=%1$s', $secondIconLink . (strpos($secondIconLink, '?') === false ? '?' : '&') . 'server=' . $GLOBALS['server'] . '&db=%2$s&table=%1$s', ], 'title' => $this->title, ] |
/libraries/classes/Navigation/Nodes/NodeViewContainer.php:45 | 1 | $new->links = ['text' => Url::getFromRoute('/view/create', ['server' => $GLOBALS['server'], ]) . '&db=%2$s', 'icon' => Url::getFromRoute('/view/create', ['server' => $GLOBALS['server'], ]) . '&db=%2$s', ] |
/libraries/classes/Navigation/Nodes/NodeViewContainer.php:26 | 1 | $this->links = ['text' => Url::getFromRoute('/database/structure', ['server' => $GLOBALS['server'], 'tbl_type' => 'view', ]) . '&db=%1$s', 'icon' => Url::getFromRoute('/database/structure', ['server' => $GLOBALS['server'], 'tbl_type' => 'view', ]) . '&db=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeProcedure.php:30 | 1 | $this->links = ['text' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'item_type' => 'PROCEDURE', 'edit_item' => 1, ]) . '&db=%2$s&item_name=%1$s', 'icon' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'item_type' => 'PROCEDURE', 'execute_dialog' => 1, ]) . '&db=%2$s&item_name=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeEventContainer.php:42 | 1 | $new->links = ['text' => Url::getFromRoute('/database/events', ['server' => $GLOBALS['server'], 'add_item' => 1, ]) . '&db=%2$s', 'icon' => Url::getFromRoute('/database/events', ['server' => $GLOBALS['server'], 'add_item' => 1, ]) . '&db=%2$s', ] |
/libraries/classes/Navigation/Nodes/NodeEventContainer.php:26 | 1 | $this->links = ['text' => Url::getFromRoute('/database/events', ['server' => $GLOBALS['server'], ]) . '&db=%1$s', 'icon' => Url::getFromRoute('/database/events', ['server' => $GLOBALS['server'], ]) . '&db=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeTrigger.php:30 | 1 | $this->links = ['text' => Url::getFromRoute('/database/triggers', ['server' => $GLOBALS['server'], 'edit_item' => 1, ]) . '&db=%3$s&item_name=%1$s', 'icon' => Url::getFromRoute('/database/triggers', ['server' => $GLOBALS['server'], 'export_item' => 1, ]) . '&db=%3$s&item_name=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeIndexContainer.php:42 | 1 | $new->links = ['text' => Url::getFromRoute('/table/indexes', ['server' => $GLOBALS['server'], 'create_index' => 1, 'added_fields' => 2, ]) . '&db=%3$s&table=%2$s', 'icon' => Url::getFromRoute('/table/indexes', ['server' => $GLOBALS['server'], 'create_index' => 1, 'added_fields' => 2, ]) . '&db=%3$s&table=%2$s', ] |
/libraries/classes/Navigation/Nodes/NodeIndexContainer.php:26 | 2 | $this->links = ['text' => Url::getFromRoute('/table/structure', ['server' => $GLOBALS['server'], ]) . '&db=%2$s&table=%1$s', 'icon' => Url::getFromRoute('/table/structure', ['server' => $GLOBALS['server'], ]) . '&db=%2$s&table=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeTableContainer.php:45 | 1 | $new->links = ['text' => Url::getFromRoute('/table/create', ['server' => $GLOBALS['server'], ]) . '&db=%2$s', 'icon' => Url::getFromRoute('/table/create', ['server' => $GLOBALS['server'], ]) . '&db=%2$s', ] |
/libraries/classes/Navigation/Nodes/NodeTableContainer.php:26 | 1 | $this->links = ['text' => Url::getFromRoute('/database/structure', ['server' => $GLOBALS['server'], 'tbl_type' => 'table', ]) . '&db=%1$s', 'icon' => Url::getFromRoute('/database/structure', ['server' => $GLOBALS['server'], 'tbl_type' => 'table', ]) . '&db=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeColumnContainer.php:42 | 1 | $new->links = ['text' => Url::getFromRoute('/table/add-field', ['server' => $GLOBALS['server'], 'field_where' => 'last', 'after_field' => '', ]) . '&db=%3$s&table=%2$s', 'icon' => Url::getFromRoute('/table/add-field', ['server' => $GLOBALS['server'], 'field_where' => 'last', 'after_field' => '', ]) . '&db=%3$s&table=%2$s', ] |
/libraries/classes/Navigation/Nodes/NodeColumnContainer.php:26 | 2 | $this->links = ['text' => Url::getFromRoute('/table/structure', ['server' => $GLOBALS['server'], ]) . '&db=%2$s&table=%1$s', 'icon' => Url::getFromRoute('/table/structure', ['server' => $GLOBALS['server'], ]) . '&db=%2$s&table=%1$s', ] |
/libraries/classes/Navigation/Nodes/NodeProcedureContainer.php:44 | 1 | $new->links = ['text' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'add_item' => 1, ]) . '&db=%2$s', 'icon' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'add_item' => 1, ]) . '&db=%2$s', ] |
/libraries/classes/Navigation/Nodes/NodeProcedureContainer.php:26 | 1 | $this->links = ['text' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'type' => 'PROCEDURE', ]) . '&db=%1$s', 'icon' => Url::getFromRoute('/database/routines', ['server' => $GLOBALS['server'], 'type' => 'PROCEDURE', ]) . '&db=%1$s', ] |
/libraries/classes/Gis/GisLineString.php:310 | 1 | $wkt .= (isset($gis_data[$index]['LINESTRING'][$i]['x']) && trim((string) $gis_data[$index]['LINESTRING'][$i]['x']) != '' ? $gis_data[$index]['LINESTRING'][$i]['x'] : $empty) . ' ' . (isset($gis_data[$index]['LINESTRING'][$i]['y']) && trim((string) $gis_data[$index]['LINESTRING'][$i]['y']) != '' ? $gis_data[$index]['LINESTRING'][$i]['y'] : $empty) . ',' |
/libraries/classes/Gis/GisMultiPoint.php:317 | 1 | $wkt .= (isset($gis_data[$index]['MULTIPOINT'][$i]['x']) && trim((string) $gis_data[$index]['MULTIPOINT'][$i]['x']) != '' ? $gis_data[$index]['MULTIPOINT'][$i]['x'] : '') . ' ' . (isset($gis_data[$index]['MULTIPOINT'][$i]['y']) && trim((string) $gis_data[$index]['MULTIPOINT'][$i]['y']) != '' ? $gis_data[$index]['MULTIPOINT'][$i]['y'] : '') . ',' |
/libraries/classes/Gis/GisMultiPolygon.php:425 | 1 | $wkt .= (isset($data_row[$k][$i][$j]['x']) && trim((string) $data_row[$k][$i][$j]['x']) != '' ? $data_row[$k][$i][$j]['x'] : $empty) . ' ' . (isset($data_row[$k][$i][$j]['y']) && trim((string) $data_row[$k][$i][$j]['y']) != '' ? $data_row[$k][$i][$j]['y'] : $empty) . ',' |
/libraries/classes/Gis/GisMultiLineString.php:350 | 1 | $wkt .= (isset($data_row[$i][$j]['x']) && trim((string) $data_row[$i][$j]['x']) != '' ? $data_row[$i][$j]['x'] : $empty) . ' ' . (isset($data_row[$i][$j]['y']) && trim((string) $data_row[$i][$j]['y']) != '' ? $data_row[$i][$j]['y'] : $empty) . ',' |
/libraries/classes/Controllers/Table/GisVisualizationController.php:154 | 1 | $html = $this->template->render('table/gis_visualization/gis_visualization', ['url_params' => $url_params, 'download_url' => $downloadUrl, 'label_candidates' => $labelCandidates, 'spatial_candidates' => $spatialCandidates, 'visualization_settings' => $visualizationSettings, 'sql_query' => $sqlQuery, 'visualization' => $this->visualization->toImage('svg'), 'draw_ol' => $this->visualization->asOl( ), 'pma_theme_image' => $GLOBALS['pmaThemeImage'], ]) |
/libraries/classes/Controllers/Table/FindReplaceController.php:360 | 1 | $sql_query = 'UPDATE ' . Util::backquote($this->table) . ' SET ' . Util::backquote($column) . ' =' . ' REPLACE(' . Util::backquote($column) . ", '" . $find . "', '" . $replaceWith . "')" . ' WHERE ' . Util::backquote($column) . " LIKE '%" . $find . "%' COLLATE " . $charSet . '_bin' |
/libraries/classes/Gis/GisPolygon.php:381 | 1 | $wkt .= (isset($gis_data[$index]['POLYGON'][$i][$j]['x']) && trim((string) $gis_data[$index]['POLYGON'][$i][$j]['x']) != '' ? $gis_data[$index]['POLYGON'][$i][$j]['x'] : $empty) . ' ' . (isset($gis_data[$index]['POLYGON'][$i][$j]['y']) && trim((string) $gis_data[$index]['POLYGON'][$i][$j]['y']) != '' ? $gis_data[$index]['POLYGON'][$i][$j]['y'] : $empty) . ',' |
/libraries/classes/Gis/GisPolygon.php:239 | 1 | $polygon_options = ['name' => $label, 'id' => $label . $this->getRandomId( ), 'class' => 'polygon vector', 'stroke' => 'black', 'stroke-width' => 0.5, 'fill' => $fill_color, 'fill-rule' => 'evenodd', 'fill-opacity' => 0.8, ] |
/libraries/classes/Relation.php:1656 | 1 | $table_query = 'UPDATE ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['relation']) . ' SET master_field = \'' . $this->dbi->escapeString($new_name) . '\'' . ' WHERE master_db = \'' . $this->dbi->escapeString($db) . '\'' . ' AND master_table = \'' . $this->dbi->escapeString($table) . '\'' . ' AND master_field = \'' . $this->dbi->escapeString($field) . '\'' |
/libraries/classes/Relation.php:1637 | 1 | $table_query = 'UPDATE ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['table_info']) . ' SET display_field = \'' . $this->dbi->escapeString($new_name) . '\'' . ' WHERE db_name = \'' . $this->dbi->escapeString($db) . '\'' . ' AND table_name = \'' . $this->dbi->escapeString($table) . '\'' . ' AND display_field = \'' . $this->dbi->escapeString($field) . '\'' |
/libraries/classes/Relation.php:1551 | 1 | $f_query_filter = empty($foreign_filter) ? '' : ' WHERE ' . Util::backquote($foreign_field) . ' LIKE "%' . $this->dbi->escapeString($foreign_filter) . '%"' . ($foreign_display === false ? '' : ' OR ' . Util::backquote($foreign_display) . ' LIKE "%' . $this->dbi->escapeString($foreign_filter) . '%"') |
/libraries/classes/Relation.php:1270 | 1 | $search_query = ' SELECT `timevalue` FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['history']) . ' WHERE `username` = \'' . $this->dbi->escapeString($username) . '\' ORDER BY `timevalue` DESC LIMIT ' . $GLOBALS['cfg']['QueryHistoryMax'] . ', 1' |
/libraries/classes/Relation.php:1113 | 1 | $upd_query = 'INSERT INTO ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['column_info']) . ' (`db_name`, `table_name`, `column_name`, `comment`)' . ' VALUES (\'' . $this->dbi->escapeString($db) . "', '', '(db_comment)', '" . $this->dbi->escapeString($comment) . "') " . ' ON DUPLICATE KEY UPDATE ' . "`comment` = '" . $this->dbi->escapeString($comment) . "'" |
/libraries/classes/Relation.php:939 | 1 | $disp_query = ' SELECT `display_field` FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['table_info']) . ' WHERE `db_name` = \'' . $this->dbi->escapeString((string) $db) . '\' AND `table_name` = \'' . $this->dbi->escapeString((string) $table) . '\'' |
/libraries/classes/Relation.php:854 | 1 | $rel_query = ' SELECT `master_field`, `foreign_db`, `foreign_table`, `foreign_field` FROM ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['relation']) . ' WHERE `master_db` = \'' . $this->dbi->escapeString($db) . '\' AND `master_table` = \'' . $this->dbi->escapeString($table) . '\' ' |
/libraries/classes/Relation.php:778 | 1 | $query = 'SHOW COLUMNS FROM ' . Util::backquote($GLOBALS['cfg']['Server']['pmadb']) . '.' . Util::backquote($GLOBALS['cfg']['Server']['column_info']) . ' WHERE Field IN (\'' . implode('\', \'', $new_cols) . '\')' |
/libraries/classes/ErrorReport.php:157 | 1 | $errors[$i++] = ['lineNum' => $errorObj->getLine( ), 'file' => $errorObj->getFile( ), 'type' => $errorObj->getType( ), 'msg' => $errorObj->getOnlyMessage( ), 'stackTrace' => $errorObj->getBacktrace(5), 'stackhash' => $errorObj->getHash( ), ] |
/libraries/classes/ErrorReport.php:96 | 1 | $report = ['pma_version' => PMA_VERSION, 'browser_name' => PMA_USR_BROWSER_AGENT, 'browser_version' => PMA_USR_BROWSER_VER, 'user_os' => PMA_USR_OS, 'server_software' => $_SERVER['SERVER_SOFTWARE'], 'user_agent_string' => $_SERVER['HTTP_USER_AGENT'], 'locale' => $PMA_Config->getCookie('pma_lang'), 'configuration_storage' => $relParams['db'] === null ? 'disabled' : 'enabled', 'php_version' => PHP_VERSION, ] |
/libraries/classes/OpenDocument.php:38 | 1 | $data = [$mime, $data, '<?xml version="1.0" encoding="UTF-8"?' . '>' . '<office:document-meta ' . 'xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" ' . 'xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" ' . 'office:version="1.0">' . '<office:meta>' . '<meta:generator>phpMyAdmin ' . PMA_VERSION . '</meta:generator>' . '<meta:initial-creator>phpMyAdmin ' . PMA_VERSION . '</meta:initial-creator>' . '<meta:creation-date>' . strftime('%Y-%m-%dT%H:%M:%S') . '</meta:creation-date>' . '</office:meta>' . '</office:document-meta>', '<?xml version="1.0" encoding="UTF-8"?' . '>' . '<office:document-styles ' . self::NS . ' office:version="1.0">' . '<office:font-face-decls>' . '<style:font-face style:name="Arial Unicode MS"' . ' svg:font-family="\'Arial Unicode MS\'" style:font-pitch="variable"/>' . '<style:font-face style:name="DejaVu Sans1"' . ' svg:font-family="\'DejaVu Sans\'" style:font-pitch="variable"/>' . '<style:font-face style:name="HG Mincho Light J"' . ' svg:font-family="\'HG Mincho Light J\'" style:font-pitch="variable"/>' . '<style:font-face style:name="DejaVu Serif"' . ' svg:font-family="\'DejaVu Serif\'" style:font-family-generic="roman"' . ' style:font-pitch="variable"/>' . '<style:font-face style:name="Thorndale"' . ' svg:font-family="Thorndale" style:font-family-generic="roman"' . ' style:font-pitch="variable"/>' . '<style:font-face style:name="DejaVu Sans"' . ' svg:font-family="\'DejaVu Sans\'" style:font-family-generic="swiss"' . ' style:font-pitch="variable"/>' . '</office:font-face-decls>' . '<office:styles>' . '<style:default-style style:family="paragraph">' . '<style:paragraph-properties fo:hyphenation-ladder-count="no-limit"' . ' style:text-autospace="ideograph-alpha" style:punctuation-wrap="hanging"' . ' style:line-break="strict" style:tab-stop-distance="0.4925in"' . ' style:writing-mode="page"/>' . '<style:text-properties style:use-window-font-color="true"' . ' style:font-name="DejaVu Serif" fo:font-size="12pt" fo:language="en"' . ' fo:country="US" style:font-name-asian="DejaVu Sans1"' . ' style:font-size-asian="12pt" style:language-asian="none"' . ' style:country-asian="none" style:font-name-complex="DejaVu Sans1"' . ' style:font-size-complex="12pt" style:language-complex="none"' . ' style:country-complex="none" fo:hyphenate="false"' . ' fo:hyphenation-remain-char-count="2"' . ' fo:hyphenation-push-char-count="2"/>' . '</style:default-style>' . '<style:style style:name="Standard" style:family="paragraph"' . ' style:class="text"/>' . '<style:style style:name="Text_body" style:display-name="Text body"' . ' style:family="paragraph" style:parent-style-name="Standard"' . ' style:class="text">' . '<style:paragraph-properties fo:margin-top="0in"' . ' fo:margin-bottom="0.0835in"/>' . '</style:style>' . '<style:style style:name="Heading" style:family="paragraph"' . ' style:parent-style-name="Standard" style:next-style-name="Text_body"' . ' style:class="text">' . '<style:paragraph-properties fo:margin-top="0.1665in"' . ' fo:margin-bottom="0.0835in" fo:keep-with-next="always"/>' . '<style:text-properties style:font-name="DejaVu Sans" fo:font-size="14pt"' . ' style:font-name-asian="DejaVu Sans1" style:font-size-asian="14pt"' . ' style:font-name-complex="DejaVu Sans1" style:font-size-complex="14pt"/>' . '</style:style>' . '<style:style style:name="Heading_1" style:display-name="Heading 1"' . ' style:family="paragraph" style:parent-style-name="Heading"' . ' style:next-style-name="Text_body" style:class="text"' . ' style:default-outline-level="1">' . '<style:text-properties style:font-name="Thorndale" fo:font-size="24pt"' . ' fo:font-weight="bold" style:font-name-asian="HG Mincho Light J"' . ' style:font-size-asian="24pt" style:font-weight-asian="bold"' . ' style:font-name-complex="Arial Unicode MS"' . ' style:font-size-complex="24pt" style:font-weight-complex="bold"/>' . '</style:style>' . '<style:style style:name="Heading_2" style:display-name="Heading 2"' . ' style:family="paragraph" style:parent-style-name="Heading"' . ' style:next-style-name="Text_body" style:class="text"' . ' style:default-outline-level="2">' . '<style:text-properties style:font-name="DejaVu Serif"' . ' fo:font-size="18pt" fo:font-weight="bold"' . ' style:font-name-asian="DejaVu Sans1" style:font-size-asian="18pt"' . ' style:font-weight-asian="bold" style:font-name-complex="DejaVu Sans1"' . ' style:font-size-complex="18pt" style:font-weight-complex="bold"/>' . '</style:style>' . '</office:styles>' . '<office:automatic-styles>' . '<style:page-layout style:name="pm1">' . '<style:page-layout-properties fo:page-width="8.2673in"' . ' fo:page-height="11.6925in" style:num-format="1"' . ' style:print-orientation="portrait" fo:margin-top="1in"' . ' fo:margin-bottom="1in" fo:margin-left="1.25in"' . ' fo:margin-right="1.25in" style:writing-mode="lr-tb"' . ' style:footnote-max-height="0in">' . '<style:footnote-sep style:width="0.0071in"' . ' style:distance-before-sep="0.0398in"' . ' style:distance-after-sep="0.0398in" style:adjustment="left"' . ' style:rel-width="25%" style:color="#000000"/>' . '</style:page-layout-properties>' . '<style:header-style/>' . '<style:footer-style/>' . '</style:page-layout>' . '</office:automatic-styles>' . '<office:master-styles>' . '<style:master-page style:name="Standard" style:page-layout-name="pm1"/>' . '</office:master-styles>' . '</office:document-styles>', '<?xml version="1.0" encoding="UTF-8"?' . '>' . '<manifest:manifest' . ' xmlns:manifest="urn:oasis:names:tc:opendocument:xmlns:manifest:1.0">' . '<manifest:file-entry manifest:media-type="' . $mime . '" manifest:full-path="/"/>' . '<manifest:file-entry manifest:media-type="text/xml"' . ' manifest:full-path="content.xml"/>' . '<manifest:file-entry manifest:media-type="text/xml"' . ' manifest:full-path="meta.xml"/>' . '<manifest:file-entry manifest:media-type="text/xml"' . ' manifest:full-path="styles.xml"/>' . '</manifest:manifest>', ] |
/libraries/classes/Relation.php:1871 | 1 | $ins_query = 'INSERT INTO ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($cfgRelation['pdf_pages']) . ' (db_name, page_descr)' . ' VALUES (\'' . $this->dbi->escapeString($db) . '\', \'' . $this->dbi->escapeString($newpage) . '\')' |
/libraries/classes/Relation.php:1840 | 1 | $query = 'UPDATE ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($GLOBALS['cfgRelation']['navigationhiding']) . " SET db_name = '" . $this->dbi->escapeString($target_db) . "'," . " item_name = '" . $this->dbi->escapeString($target_table) . "'" . " WHERE db_name = '" . $this->dbi->escapeString($source_db) . "'" . " AND item_name = '" . $this->dbi->escapeString($source_table) . "'" . " AND item_type = 'table'" |
/libraries/classes/Relation.php:1802 | 1 | $remove_query = 'DELETE FROM ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($GLOBALS['cfgRelation']['table_coords']) . " WHERE db_name = '" . $this->dbi->escapeString($source_db) . "'" . " AND table_name = '" . $this->dbi->escapeString($source_table) . "'" |
/libraries/classes/Relation.php:1707 | 1 | $query = 'UPDATE ' . Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . Util::backquote($GLOBALS['cfgRelation'][$table]) . ' SET ' . $db_field . ' = \'' . $this->dbi->escapeString($target_db) . '\', ' . $table_field . ' = \'' . $this->dbi->escapeString($target_table) . '\'' . ' WHERE ' . $db_field . ' = \'' . $this->dbi->escapeString($source_db) . '\'' . ' AND ' . $table_field . ' = \'' . $this->dbi->escapeString($source_table) . '\'' |
/libraries/classes/Relation.php:1670 | 1 | $table_query = 'UPDATE ' . Util::backquote($cfgRelation['db']) . '.' . Util::backquote($cfgRelation['relation']) . ' SET foreign_field = \'' . $this->dbi->escapeString($new_name) . '\'' . ' WHERE foreign_db = \'' . $this->dbi->escapeString($db) . '\'' . ' AND foreign_table = \'' . $this->dbi->escapeString($table) . '\'' . ' AND foreign_field = \'' . $this->dbi->escapeString($field) . '\'' |
/libraries/classes/SystemDatabase.php:100 | 1 | $new_transformations_sql .= sprintf("%s ('%s', '%s', '%s', '%s', '%s', '%s', '%s')", $add_comma ? ', ' : '', $db, $view_name, $column['real_column'] ?? $column['refering_column'], $data_row['comment'], $data_row['mimetype'], $data_row['transformation'], $GLOBALS['dbi']->escapeString($data_row['transformation_options'])) |
/libraries/classes/Operations.php:907 | 1 | if($pma_table->isEngine(['MYISAM', 'ARIA', 'INNODB', 'PBXT', 'ROCKSDB']) && !empty($_POST['new_auto_increment']) && (!isset($auto_increment) || $_POST['new_auto_increment'] !== $auto_increment) && $_POST['new_auto_increment'] !== $_POST['hidden_auto_increment']) { /**/ } |
/libraries/classes/SavedSearches.php:289 | 1 | if($this->getUsername( ) == null || $this->getDbname( ) == null || $this->getSearchName( ) == null || $this->getCriterias( ) == null) { /**/ } |
/libraries/classes/CheckUserPrivileges.php:282 | 1 | if((preg_match('/' . $re0 . '%|_/', $show_grants_dbname) && !preg_match('/\\\\%|\\\\_/', $show_grants_dbname)) || (!$this->dbi->tryQuery('USE ' . preg_replace('/' . $re1 . '(%|_)/', '\\1\\3', $dbname_to_test)) && mb_substr($this->dbi->getError( ), 1, 4) != 1044)) { /**/ } |
/libraries/classes/Config.php:574 | 1 | if((!isset($config_data['ThemeDefault']) && $tmanager->theme->getId( ) != 'original') || isset($config_data['ThemeDefault']) && $config_data['ThemeDefault'] != $tmanager->theme->getId( )) { /**/ } |
/libraries/classes/Table.php:2529 | 1 | if($ref_db_name != $foreign_db || $existrel_foreign[$master_field_md5]['ref_table_name'] != $foreign_table || $existrel_foreign[$master_field_md5]['ref_index_list'] != $foreign_field || $existrel_foreign[$master_field_md5]['index_list'] != $master_field || $_POST['constraint_name'][$master_field_md5] != $constraint_name || ($_POST['on_delete'][$master_field_md5] != $on_delete) || ($_POST['on_update'][$master_field_md5] != $on_update)) { /**/ } |
/libraries/classes/Table.php:2292 | 1 | if($index->getChoice( ) != 'SPATIAL' && $index->getChoice( ) != 'FULLTEXT' && in_array($type, Index::getIndexTypes( )) && !$this->isEngine(['TOKUDB'])) { /**/ } |
/libraries/classes/Util.php:1085 | 1 | if(isset($meta->orgtable) && ($meta->table != $meta->orgtable) && !$GLOBALS['dbi']->getTable($GLOBALS['db'], $meta->table)->isView( )) { /**/ } |
/libraries/classes/Footer.php:254 | 1 | if(Core::isValid($_REQUEST['no_history']) || !empty($GLOBALS['error_message']) || empty($GLOBALS['sql_query']) || !isset($GLOBALS['dbi']) || !$GLOBALS['dbi']->isUserType('logged')) { /**/ } |
/libraries/classes/InsertEdit.php:2067 | 1 | elseif((substr($column['True_Type'], 0, 9) == 'timestamp' || $column['True_Type'] == 'datetime' || $column['True_Type'] == 'time') && (mb_strpos($current_row[$column['Field']], '.') !== false)) { /**/ } elseif(in_array($column['True_Type'], $gis_data_types)) { /**/ } else { /**/ } |
/libraries/classes/InsertEdit.php:1417 | 1 | if(($GLOBALS['cfg']['ProtectBinary'] === 'blob' && $column['is_blob']) || ($GLOBALS['cfg']['ProtectBinary'] === 'all') || ($GLOBALS['cfg']['ProtectBinary'] === 'noblob' && !$column['is_blob'])) { /**/ } elseif($column['is_blob'] || ($column['len'] > $GLOBALS['cfg']['LimitChars'])) { /**/ } else { /**/ } |
/libraries/classes/InsertEdit.php:1254 | 1 | if($data == $enum_value['plain'] || ($data == '' && (!isset($_POST['where_clause']) || $column['Null'] != 'YES') && isset($column['Default']) && $enum_value['plain'] == $column['Default'])) { /**/ } elseif($readOnly) { /**/ } |
/libraries/classes/InsertEdit.php:1197 | 1 | if($data == $enum_value['plain'] || ($data == '' && (!isset($_POST['where_clause']) || $column['Null'] != 'YES') && isset($column['Default']) && $enum_value['plain'] == $column['Default'])) { /**/ } |
/libraries/classes/Plugins.php:190 | 1 | if(isset($_GET[$opt]) || !isset($_GET['repopulate']) && ((!empty($GLOBALS['timeout_passed']) && isset($_REQUEST[$opt])) || !empty($GLOBALS['cfg'][$section][$opt]))) { /**/ } |
/libraries/classes/Scripts.php:98 | 1 | if(strpos($filename, 'jquery') !== false || strpos($filename, 'codemirror') !== false || strpos($filename, 'messages.php') !== false || strpos($filename, 'ajax.js') !== false || strpos($filename, 'cross_framing_protection.js') !== false) { /**/ } |
/libraries/classes/InsertEdit.php:2770 | 1 | elseif(!(empty($multi_edit_funcs[$key]) && isset($multi_edit_columns_prev[$key]) && (($current_value === "'" . $this->dbi->escapeString($multi_edit_columns_prev[$key]) . "'") || ($current_value === '0x' . $multi_edit_columns_prev[$key]))) && !empty($current_value)) { /**/ } |
/libraries/classes/InsertEdit.php:2696 | 1 | if((isset($multi_edit_salt[$key]) && ($multi_edit_funcs[$key] == 'AES_ENCRYPT' || $multi_edit_funcs[$key] == 'AES_DECRYPT')) || (!empty($multi_edit_salt[$key]) && ($multi_edit_funcs[$key] == 'DES_ENCRYPT' || $multi_edit_funcs[$key] == 'DES_DECRYPT' || $multi_edit_funcs[$key] == 'ENCRYPT'))) { /**/ } |
/libraries/classes/Plugins/Auth/AuthenticationCookie.php:805 | 1 | if(!isset($data['mac'], $data['iv'], $data['payload']) || !is_array($data) || !is_string($data['mac']) || !is_string($data['iv']) || !is_string($data['payload'])) { /**/ } |
/libraries/classes/Plugins/Export/ExportSql.php:2902 | 1 | if($statement->options->has('TRIGGER') || $statement->options->has('PROCEDURE') || $statement->options->has('FUNCTION') || $statement->options->has('VIEW')) { /**/ } |
/libraries/classes/Database/Events.php:217 | 1 | if(!count($errors) && (!empty($_POST['editor_process_add']) || !empty($_POST['editor_process_edit']) || (empty($_REQUEST['add_item']) && empty($_REQUEST['edit_item']) && empty($_POST['item_changetype'])))) { /**/ } |
/libraries/classes/Config/ServerConfigChecks.php:188 | 1 | if($this->cfg->getValue('Servers/' . $i . '/auth_type') == 'config' && $this->cfg->getValue('Servers/' . $i . '/user') != '' && $this->cfg->getValue('Servers/' . $i . '/password') != '') { /**/ } |
/libraries/classes/Server/Privileges.php:1282 | 1 | if(((isset($_POST['Grant_priv']) && $_POST['Grant_priv'] == 'Y') || (isset($GLOBALS['Grant_priv']) && $GLOBALS['Grant_priv'] == 'Y')) && !((Util::getServerType( ) == 'MySQL' || Util::getServerType( ) == 'Percona Server') && $this->dbi->getVersion( ) >= 80011)) { /**/ } |
/libraries/classes/Server/Privileges.php:2471 | 1 | if((isset($_POST['Grant_priv']) && $_POST['Grant_priv'] == 'Y') || (strlen($dbname) === 0 && (isset($_POST['max_questions']) || isset($_POST['max_connections']) || isset($_POST['max_updates']) || isset($_POST['max_user_connections'])))) { /**/ } |
/libraries/classes/Plugins/Import/ImportCsv.php:318 | 1 | while (($need_end && ($ch != $csv_enclosed || $csv_enclosed == $csv_escaped)) || (!$need_end && !($ch == $csv_terminated || $ch == $csv_new_line || ($csv_new_line == 'auto' && ($ch == "\r" || $ch == "\n"))))) { /**/ } |
/libraries/classes/Server/Privileges.php:229 | 1 | if(($row !== null && $row[$current_grant[0]] == 'Y') || ($row === null && ($GLOBALS[$current_grant[0]] == 'Y' || (is_array($GLOBALS[$current_grant[0]]) && count($GLOBALS[$current_grant[0]]) == $_REQUEST['column_count'] && empty($GLOBALS[$current_grant[0] . '_none']))))) { /**/ } elseif(!empty($GLOBALS[$current_grant[0]]) && is_array($GLOBALS[$current_grant[0]]) && empty($GLOBALS[$current_grant[0] . '_none'])) { /**/ } else { /**/ } |
/libraries/classes/Database/Designer.php:287 | 1 | elseif(strpos($tab_column[$table_name]['TYPE'][$j], 'date') !== false || strpos($tab_column[$table_name]['TYPE'][$j], 'time') !== false || strpos($tab_column[$table_name]['TYPE'][$j], 'year') !== false) { /**/ } |
/libraries/classes/Database/Designer.php:361 | 1 | elseif(strpos($tabColumn[$tableName]['TYPE'][$j], 'int') !== false || strpos($tabColumn[$tableName]['TYPE'][$j], 'float') !== false || strpos($tabColumn[$tableName]['TYPE'][$j], 'double') !== false || strpos($tabColumn[$tableName]['TYPE'][$j], 'decimal') !== false) { /**/ } elseif(strpos($tabColumn[$tableName]['TYPE'][$j], 'date') !== false || strpos($tabColumn[$tableName]['TYPE'][$j], 'time') !== false || strpos($tabColumn[$tableName]['TYPE'][$j], 'year') !== false) { /**/ } |
/libraries/classes/Core.php:275 | 1 | if(isset($GLOBALS['dbi'], $GLOBALS['PMA_Config']) && $GLOBALS['dbi'] !== null && $GLOBALS['PMA_Config']->get('is_setup') === false && Response::getInstance( )->isAjax( )) { /**/ } elseif(!empty($_REQUEST['ajax_request'])) { /**/ } else { /**/ } |
/libraries/classes/Database/Designer.php:282 | 1 | elseif(strpos($tab_column[$table_name]['TYPE'][$j], 'int') !== false || strpos($tab_column[$table_name]['TYPE'][$j], 'float') !== false || strpos($tab_column[$table_name]['TYPE'][$j], 'double') !== false || strpos($tab_column[$table_name]['TYPE'][$j], 'decimal') !== false) { /**/ } elseif(strpos($tab_column[$table_name]['TYPE'][$j], 'date') !== false || strpos($tab_column[$table_name]['TYPE'][$j], 'time') !== false || strpos($tab_column[$table_name]['TYPE'][$j], 'year') !== false) { /**/ } |
/libraries/classes/Database/Routines.php:541 | 1 | if(isset($_POST['item_param_name'], $_POST['item_param_type']) && isset($_POST['item_param_length']) && isset($_POST['item_param_opts_num']) && isset($_POST['item_param_opts_text']) && is_array($_POST['item_param_name']) && is_array($_POST['item_param_type']) && is_array($_POST['item_param_length']) && is_array($_POST['item_param_opts_num']) && is_array($_POST['item_param_opts_text'])) { /**/ } |
/libraries/classes/Database/Routines.php:1729 | 1 | if(stripos($routine['item_param_type'][$i], 'enum') !== false || stripos($routine['item_param_type'][$i], 'set') !== false || in_array(mb_strtolower($routine['item_param_type'][$i]), $no_support_types)) { /**/ } else { /**/ } |
/libraries/classes/Database/Designer.php:366 | 1 | elseif(strpos($tabColumn[$tableName]['TYPE'][$j], 'date') !== false || strpos($tabColumn[$tableName]['TYPE'][$j], 'time') !== false || strpos($tabColumn[$tableName]['TYPE'][$j], 'year') !== false) { /**/ } |
/libraries/classes/Database/Routines.php:143 | 1 | if(!count($errors) && (!empty($_POST['editor_process_add']) || !empty($_POST['editor_process_edit']) || (empty($_REQUEST['add_item']) && empty($_REQUEST['edit_item']) && empty($_POST['routine_addparameter']) && empty($_POST['routine_removeparameter']) && empty($_POST['routine_changetype'])))) { /**/ } |
/libraries/classes/Controllers/HomeController.php:423 | 1 | if(isset($cfg['Server']['controluser'], $cfg['Server']['controlpass']) && $server != 0 && $cfg['Server']['controluser'] == 'pma' && $cfg['Server']['controlpass'] == 'pmapass') { /**/ } |
/libraries/classes/Display/Results.php:4822 | 1 | if(($_SESSION['tmpval']['display_binary'] && $meta->type === self::STRING_FIELD) || ($_SESSION['tmpval']['display_blob'] && stripos($meta->type, self::BLOB_FIELD) !== false)) { /**/ } |
/libraries/classes/Controllers/Server/PrivilegesController.php:389 | 1 | if($this->response->isAjax( ) && empty($_REQUEST['ajax_page_request']) && !isset($_GET['export']) && (!isset($_POST['submit_mult']) || $_POST['submit_mult'] != 'export') && ((!isset($_GET['initial']) || $_GET['initial'] === null || $_GET['initial'] === '') || (isset($_POST['delete']) && $_POST['delete'] === __('Go'))) && !isset($_GET['showall']) && !isset($_GET['edit_user_group_dialog'])) { /**/ } |
/libraries/classes/Controllers/Database/StructureController.php:1308 | 1 | if($this->db == $this->replication->extractDbOrTable($db_table) && preg_match('@^' . preg_quote(mb_substr($this->replication->extractDbOrTable($db_table, 'table'), 0, -1), '@') . '@', $truename)) { /**/ } |
/libraries/classes/Controllers/Table/TrackingController.php:62 | 1 | if(Tracker::isActive( ) && Tracker::isTracked($GLOBALS['db'], $GLOBALS['table']) && !(isset($_POST['toggle_activation']) && $_POST['toggle_activation'] == 'deactivate_now') && !(isset($_POST['report_export']) && $_POST['export_type'] == 'sqldumpfile')) { /**/ } |
/libraries/classes/Controllers/Table/StructureController.php:1197 | 1 | if(isset($_POST['field_collation'][$i], $_POST['field_collation_orig'][$i]) && $_POST['field_collation'][$i] !== $_POST['field_collation_orig'][$i] && !in_array($_POST['field_orig'][$i], $columns_with_index)) { /**/ } else { /**/ } |
/libraries/classes/Controllers/Table/ZoomSearchController.php:142 | 1 | if(!isset($_POST['zoom_submit']) || $_POST['criteriaColumnNames'][0] == 'pma_null' || $_POST['criteriaColumnNames'][1] == 'pma_null' || $_POST['criteriaColumnNames'][0] == $_POST['criteriaColumnNames'][1]) { /**/ } |
/libraries/classes/Html/Generator.php:1233 | 1 | if(($url_length > $GLOBALS['cfg']['LinkLengthLimit']) || !$in_suhosin_limits || (strpos($url, 'sql_query=') !== false && strpos($url, 'sql_signature=') === false) || strpos($url, 'view[as]=') !== false) { /**/ } |
/libraries/classes/Server/Privileges.php:2527 | 1 | if(Util::getServerType( ) == 'MySQL' && $serverVersion >= 50606 && $serverVersion < 50706 && ((isset($row['authentication_string']) && empty($row['password'])) || (isset($row['plugin']) && $row['plugin'] == 'sha256_password'))) { /**/ } |
/libraries/classes/Display/Results.php:2185 | 1 | if(($GLOBALS['cfg']['RowActionLinks'] == self::POSITION_RIGHT) || ($GLOBALS['cfg']['RowActionLinks'] == self::POSITION_BOTH) && (($displayParts['edit_lnk'] != self::NO_EDIT_OR_DELETE) || ($displayParts['del_lnk'] != self::NO_EDIT_OR_DELETE)) && ($displayParts['text_btn'] == '1')) { /**/ } elseif(($GLOBALS['cfg']['RowActionLinks'] == self::POSITION_LEFT) || ($GLOBALS['cfg']['RowActionLinks'] == self::POSITION_BOTH) && (($displayParts['edit_lnk'] == self::NO_EDIT_OR_DELETE) && ($displayParts['del_lnk'] == self::NO_EDIT_OR_DELETE)) && (!isset($GLOBALS['is_header_sent']) || !$GLOBALS['is_header_sent'])) { /**/ } |
/libraries/classes/Display/Results.php:886 | 1 | if($this->__get('unlim_num_rows') === false || (!$isShowingAll && $_SESSION['tmpval']['pos'] + $_SESSION['tmpval']['max_rows'] < $this->__get('unlim_num_rows') && $this->__get('num_rows') >= $_SESSION['tmpval']['max_rows'])) { /**/ } |
/libraries/classes/Display/Results.php:2648 | 1 | if(!$GLOBALS['cfgRelation']['commwork'] || !$GLOBALS['cfgRelation']['mimework'] || !$GLOBALS['cfg']['BrowseMIME'] || $_SESSION['tmpval']['hide_transformation'] || !empty($added[$orgFullTableName])) { /**/ } |
/libraries/classes/Display/Results.php:2199 | 1 | elseif(($GLOBALS['cfg']['RowActionLinks'] == self::POSITION_LEFT) || ($GLOBALS['cfg']['RowActionLinks'] == self::POSITION_BOTH) && (($displayParts['edit_lnk'] == self::NO_EDIT_OR_DELETE) && ($displayParts['del_lnk'] == self::NO_EDIT_OR_DELETE)) && (!isset($GLOBALS['is_header_sent']) || !$GLOBALS['is_header_sent'])) { /**/ } |
/libraries/classes/Display/Results.php:3714 | 1 | if((stripos($field_flags, self::BINARY_FIELD) !== false && ($GLOBALS['cfg']['ProtectBinary'] === 'all' || ($GLOBALS['cfg']['ProtectBinary'] === 'noblob' && stripos($meta->type, self::BLOB_FIELD) === false) || ($GLOBALS['cfg']['ProtectBinary'] === 'blob' && stripos($meta->type, self::BLOB_FIELD) !== false))) || $bIsText) { /**/ } |
/libraries/classes/Display/Results.php:2832 | 1 | if(!empty($this->transformation_info[$dbLower][$tblLower][$nameLower]) && isset($row[$i]) && (trim($row[$i]) != '') && !$_SESSION['tmpval']['hide_transformation']) { /**/ } |
/libraries/classes/Relation.php:115 | 1 | if(empty($_SESSION['relation'][$GLOBALS['server']]) || empty($_SESSION['relation'][$GLOBALS['server']]['PMA_VERSION']) || $_SESSION['relation'][$GLOBALS['server']]['PMA_VERSION'] != PMA_VERSION) { /**/ } |
/libraries/classes/Relation.php:674 | 1 | if($GLOBALS['server'] == 0 || empty($GLOBALS['cfg']['Server']['pmadb']) || !$this->dbi->selectDb($GLOBALS['cfg']['Server']['pmadb'], DatabaseInterface::CONNECT_CONTROL)) { /**/ } |
/libraries/classes/InsertEdit.php:527 | 1 | if(($GLOBALS['cfg']['ProtectBinary'] === 'blob' && $column['is_blob'] && !$is_upload) || ($GLOBALS['cfg']['ProtectBinary'] === 'all' && $column['is_binary']) || ($GLOBALS['cfg']['ProtectBinary'] === 'noblob' && $column['is_binary'])) { /**/ } elseif($readOnly || mb_strstr($column['True_Type'], 'enum') || mb_strstr($column['True_Type'], 'set') || in_array($column['pma_type'], $no_support_types)) { /**/ } else { /**/ } |