phpmyadmin working

1 files changed, 1207 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/libraries/classes/CentralColumns.php b/srcs/phpmyadmin/libraries/classes/CentralColumns.php
new file mode 100644
index 0000000..9e11db0
--- /dev/null
+++ b/srcs/phpmyadmin/libraries/classes/CentralColumns.php
@@ -0,0 +1,1207 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Functions for displaying user preferences pages
+ *
+ * @package PhpMyAdmin
+ */
+declare(strict_types=1);
+
+namespace PhpMyAdmin;
+
+use PhpMyAdmin\Charsets\Charset;
+use PhpMyAdmin\Charsets\Collation;
+use PhpMyAdmin\Message;
+
+/**
+ * PhpMyAdmin\CentralColumns class
+ *
+ * @package PhpMyAdmin
+ */
+class CentralColumns
+{
+    /**
+     * DatabaseInterface instance
+     *
+     * @var DatabaseInterface
+     */
+    private $dbi;
+
+    /**
+     * Current user
+     *
+     * @var string
+     */
+    private $user;
+
+    /**
+     * Number of rows displayed when browsing a result set
+     *
+     * @var int
+     */
+    private $maxRows;
+
+    /**
+     * Which editor should be used for CHAR/VARCHAR fields
+     *
+     * @var string
+     */
+    private $charEditing;
+
+    /**
+     * Disable use of INFORMATION_SCHEMA
+     *
+     * @var boolean
+     */
+    private $disableIs;
+
+    /**
+     * @var Relation
+     */
+    private $relation;
+
+    /**
+     * @var Template
+     */
+    public $template;
+
+    /**
+     * Constructor
+     *
+     * @param DatabaseInterface $dbi DatabaseInterface instance
+     */
+    public function __construct(DatabaseInterface $dbi)
+    {
+        $this->dbi = $dbi;
+
+        $this->user = $GLOBALS['cfg']['Server']['user'];
+        $this->maxRows = (int) $GLOBALS['cfg']['MaxRows'];
+        $this->charEditing = $GLOBALS['cfg']['CharEditing'];
+        $this->disableIs = (bool) $GLOBALS['cfg']['Server']['DisableIS'];
+
+        $this->relation = new Relation($this->dbi);
+        $this->template = new Template();
+    }
+
+    /**
+     * Defines the central_columns parameters for the current user
+     *
+     * @return array|bool the central_columns parameters for the current user
+     * @access public
+     */
+    public function getParams()
+    {
+        static $cfgCentralColumns = null;
+
+        if (null !== $cfgCentralColumns) {
+            return $cfgCentralColumns;
+        }
+
+        $cfgRelation = $this->relation->getRelationsParam();
+
+        if ($cfgRelation['centralcolumnswork']) {
+            $cfgCentralColumns = [
+                'user'  => $this->user,
+                'db'    => $cfgRelation['db'],
+                'table' => $cfgRelation['central_columns'],
+            ];
+        } else {
+            $cfgCentralColumns = false;
+        }
+
+        return $cfgCentralColumns;
+    }
+
+    /**
+     * get $num columns of given database from central columns list
+     * starting at offset $from
+     *
+     * @param string $db   selected database
+     * @param int    $from starting offset of first result
+     * @param int    $num  maximum number of results to return
+     *
+     * @return array list of $num columns present in central columns list
+     * starting at offset $from for the given database
+     */
+    public function getColumnsList(string $db, int $from = 0, int $num = 25): array
+    {
+        $cfgCentralColumns = $this->getParams();
+        if (empty($cfgCentralColumns)) {
+            return [];
+        }
+        $pmadb = $cfgCentralColumns['db'];
+        $this->dbi->selectDb($pmadb, DatabaseInterface::CONNECT_CONTROL);
+        $central_list_table = $cfgCentralColumns['table'];
+        //get current values of $db from central column list
+        if ($num == 0) {
+            $query = 'SELECT * FROM ' . Util::backquote($central_list_table) . ' '
+                . 'WHERE db_name = \'' . $this->dbi->escapeString($db) . '\';';
+        } else {
+            $query = 'SELECT * FROM ' . Util::backquote($central_list_table) . ' '
+                . 'WHERE db_name = \'' . $this->dbi->escapeString($db) . '\' '
+                . 'LIMIT ' . $from . ', ' . $num . ';';
+        }
+        $has_list = (array) $this->dbi->fetchResult(
+            $query,
+            null,
+            null,
+            DatabaseInterface::CONNECT_CONTROL
+        );
+        $this->handleColumnExtra($has_list);
+        return $has_list;
+    }
+
+    /**
+     * Get the number of columns present in central list for given db
+     *
+     * @param string $db current database
+     *
+     * @return int number of columns in central list of columns for $db
+     */
+    public function getCount(string $db): int
+    {
+        $cfgCentralColumns = $this->getParams();
+        if (empty($cfgCentralColumns)) {
+            return 0;
+        }
+        $pmadb = $cfgCentralColumns['db'];
+        $this->dbi->selectDb($pmadb, DatabaseInterface::CONNECT_CONTROL);
+        $central_list_table = $cfgCentralColumns['table'];
+        $query = 'SELECT count(db_name) FROM ' .
+            Util::backquote($central_list_table) . ' '
+            . 'WHERE db_name = \'' . $this->dbi->escapeString($db) . '\';';
+        $res = $this->dbi->fetchResult(
+            $query,
+            null,
+            null,
+            DatabaseInterface::CONNECT_CONTROL
+        );
+        if (isset($res[0])) {
+            return (int) $res[0];
+        }
+
+        return 0;
+    }
+
+    /**
+     * return the existing columns in central list among the given list of columns
+     *
+     * @param string  $db        the selected database
+     * @param string  $cols      comma separated list of given columns
+     * @param boolean $allFields set if need all the fields of existing columns,
+     *                           otherwise only column_name is returned
+     *
+     * @return array list of columns in central columns among given set of columns
+     */
+    private function findExistingColNames(
+        string $db,
+        string $cols,
+        bool $allFields = false
+    ): array {
+        $cfgCentralColumns = $this->getParams();
+        if (empty($cfgCentralColumns)) {
+            return [];
+        }
+        $pmadb = $cfgCentralColumns['db'];
+        $this->dbi->selectDb($pmadb, DatabaseInterface::CONNECT_CONTROL);
+        $central_list_table = $cfgCentralColumns['table'];
+        if ($allFields) {
+            $query = 'SELECT * FROM ' . Util::backquote($central_list_table) . ' '
+                . 'WHERE db_name = \'' . $this->dbi->escapeString($db) . '\' AND col_name IN (' . $cols . ');';
+            $has_list = (array) $this->dbi->fetchResult(
+                $query,
+                null,
+                null,
+                DatabaseInterface::CONNECT_CONTROL
+            );
+            $this->handleColumnExtra($has_list);
+        } else {
+            $query = 'SELECT col_name FROM '
+                . Util::backquote($central_list_table) . ' '
+                . 'WHERE db_name = \'' . $this->dbi->escapeString($db) . '\' AND col_name IN (' . $cols . ');';
+            $has_list = (array) $this->dbi->fetchResult(
+                $query,
+                null,
+                null,
+                DatabaseInterface::CONNECT_CONTROL
+            );
+        }
+
+        return $has_list;
+    }
+
+    /**
+     * return error message to be displayed if central columns
+     * configuration storage is not completely configured
+     *
+     * @return Message
+     */
+    private function configErrorMessage(): Message
+    {
+        return Message::error(
+            __(
+                'The configuration storage is not ready for the central list'
+                . ' of columns feature.'
+            )
+        );
+    }
+
+    /**
+     * build the insert query for central columns list given PMA storage
+     * db, central_columns table, column name and corresponding definition to be added
+     *
+     * @param string $column             column to add into central list
+     * @param array  $def                list of attributes of the column being added
+     * @param string $db                 PMA configuration storage database name
+     * @param string $central_list_table central columns configuration storage table name
+     *
+     * @return string query string to insert the given column
+     * with definition into central list
+     */
+    private function getInsertQuery(
+        string $column,
+        array $def,
+        string $db,
+        string $central_list_table
+    ): string {
+        $type = "";
+        $length = 0;
+        $attribute = "";
+        if (isset($def['Type'])) {
+            $extracted_columnspec = Util::extractColumnSpec($def['Type']);
+            $attribute = trim($extracted_columnspec['attribute']);
+            $type = $extracted_columnspec['type'];
+            $length = $extracted_columnspec['spec_in_brackets'];
+        }
+        if (isset($def['Attribute'])) {
+            $attribute = $def['Attribute'];
+        }
+        $collation = isset($def['Collation']) ? $def['Collation'] : "";
+        $isNull = $def['Null'] == "NO" ? '0' : '1';
+        $extra = isset($def['Extra']) ? $def['Extra'] : "";
+        $default = isset($def['Default']) ? $def['Default'] : "";
+        return 'INSERT INTO '
+            . Util::backquote($central_list_table) . ' '
+            . 'VALUES ( \'' . $this->dbi->escapeString($db) . '\' ,'
+            . '\'' . $this->dbi->escapeString($column) . '\',\''
+            . $this->dbi->escapeString($type) . '\','
+            . '\'' . $this->dbi->escapeString((string) $length) . '\',\''
+            . $this->dbi->escapeString($collation) . '\','
+            . '\'' . $this->dbi->escapeString($isNull) . '\','
+            . '\'' . implode(',', [$extra, $attribute])
+            . '\',\'' . $this->dbi->escapeString($default) . '\');';
+    }
+
+    /**
+     * If $isTable is true then unique columns from given tables as $field_select
+     * are added to central list otherwise the $field_select is considered as
+     * list of columns and these columns are added to central list if not already added
+     *
+     * @param array  $field_select if $isTable is true selected tables list
+     *                             otherwise selected columns list
+     * @param bool   $isTable      if passed array is of tables or columns
+     * @param string $table        if $isTable is false, then table name to
+     *                             which columns belong
+     *
+     * @return true|Message
+     */
+    public function syncUniqueColumns(
+        array $field_select,
+        bool $isTable = true,
+        ?string $table = null
+    ) {
+        $cfgCentralColumns = $this->getParams();
+        if (empty($cfgCentralColumns)) {
+            return $this->configErrorMessage();
+        }
+        $db = $_POST['db'];
+        $pmadb = $cfgCentralColumns['db'];
+        $central_list_table = $cfgCentralColumns['table'];
+        $this->dbi->selectDb($db);
+        $existingCols = [];
+        $cols = "";
+        $insQuery = [];
+        $fields = [];
+        $message = true;
+        if ($isTable) {
+            foreach ($field_select as $table) {
+                $fields[$table] = (array) $this->dbi->getColumns(
+                    $db,
+                    $table,
+                    null,
+                    true
+                );
+                foreach ($fields[$table] as $field => $def) {
+                    $cols .= "'" . $this->dbi->escapeString($field) . "',";
+                }
+            }
+
+            $has_list = $this->findExistingColNames($db, trim($cols, ','));
+            foreach ($field_select as $table) {
+                foreach ($fields[$table] as $field => $def) {
+                    if (! in_array($field, $has_list)) {
+                        $has_list[] = $field;
+                        $insQuery[] = $this->getInsertQuery(
+                            $field,
+                            $def,
+                            $db,
+                            $central_list_table
+                        );
+                    } else {
+                        $existingCols[] = "'" . $field . "'";
+                    }
+                }
+            }
+        } else {
+            if ($table === null) {
+                $table = $_POST['table'];
+            }
+            foreach ($field_select as $column) {
+                $cols .= "'" . $this->dbi->escapeString($column) . "',";
+            }
+            $has_list = $this->findExistingColNames($db, trim($cols, ','));
+            foreach ($field_select as $column) {
+                if (! in_array($column, $has_list)) {
+                    $has_list[] = $column;
+                    $field = (array) $this->dbi->getColumns(
+                        $db,
+                        $table,
+                        $column,
+                        true
+                    );
+                    $insQuery[] = $this->getInsertQuery(
+                        $column,
+                        $field,
+                        $db,
+                        $central_list_table
+                    );
+                } else {
+                    $existingCols[] = "'" . $column . "'";
+                }
+            }
+        }
+        if (! empty($existingCols)) {
+            $existingCols = implode(",", array_unique($existingCols));
+            $message = Message::notice(
+                sprintf(
+                    __(
+                        'Could not add %1$s as they already exist in central list!'
+                    ),
+                    htmlspecialchars($existingCols)
+                )
+            );
+            $message->addMessage(
+                Message::notice(
+                    "Please remove them first "
+                    . "from central list if you want to update above columns"
+                )
+            );
+        }
+        $this->dbi->selectDb($pmadb, DatabaseInterface::CONNECT_CONTROL);
+        if (! empty($insQuery)) {
+            foreach ($insQuery as $query) {
+                if (! $this->dbi->tryQuery($query, DatabaseInterface::CONNECT_CONTROL)) {
+                    $message = Message::error(__('Could not add columns!'));
+                    $message->addMessage(
+                        Message::rawError(
+                            $this->dbi->getError(DatabaseInterface::CONNECT_CONTROL)
+                        )
+                    );
+                    break;
+                }
+            }
+        }
+        return $message;
+    }
+
+    /**
+     * if $isTable is true it removes all columns of given tables as $field_select from
+     * central columns list otherwise $field_select is columns list and it removes
+     * given columns if present in central list
+     *
+     * @param string $database     Database name
+     * @param array  $field_select if $isTable selected list of tables otherwise
+     *                             selected list of columns to remove from central list
+     * @param bool   $isTable      if passed array is of tables or columns
+     *
+     * @return true|Message
+     */
+    public function deleteColumnsFromList(
+        string $database,
+        array $field_select,
+        bool $isTable = true
+    ) {
+        $cfgCentralColumns = $this->getParams();
+        if (empty($cfgCentralColumns)) {
+            return $this->configErrorMessage();
+        }
+        $pmadb = $cfgCentralColumns['db'];
+        $central_list_table = $cfgCentralColumns['table'];
+        $this->dbi->selectDb($database);
+        $message = true;
+        $colNotExist = [];
+        $fields = [];
+        if ($isTable) {
+            $cols = '';
+            foreach ($field_select as $table) {
+                $fields[$table] = (array) $this->dbi->getColumnNames(
+                    $database,
+                    $table
+                );
+                foreach ($fields[$table] as $col_select) {
+                    $cols .= '\'' . $this->dbi->escapeString($col_select) . '\',';
+                }
+            }
+            $cols = trim($cols, ',');
+            $has_list = $this->findExistingColNames($database, $cols);
+            foreach ($field_select as $table) {
+                foreach ($fields[$table] as $column) {
+                    if (! in_array($column, $has_list)) {
+                        $colNotExist[] = "'" . $column . "'";
+                    }
+                }
+            }
+        } else {
+            $cols = '';
+            foreach ($field_select as $col_select) {
+                $cols .= '\'' . $this->dbi->escapeString($col_select) . '\',';
+            }
+            $cols = trim($cols, ',');
+            $has_list = $this->findExistingColNames($database, $cols);
+            foreach ($field_select as $column) {
+                if (! in_array($column, $has_list)) {
+                    $colNotExist[] = "'" . $column . "'";
+                }
+            }
+        }
+        if (! empty($colNotExist)) {
+            $colNotExist = implode(",", array_unique($colNotExist));
+            $message = Message::notice(
+                sprintf(
+                    __(
+                        'Couldn\'t remove Column(s) %1$s '
+                        . 'as they don\'t exist in central columns list!'
+                    ),
+                    htmlspecialchars($colNotExist)
+                )
+            );
+        }
+        $this->dbi->selectDb($pmadb, DatabaseInterface::CONNECT_CONTROL);
+
+        $query = 'DELETE FROM ' . Util::backquote($central_list_table) . ' '
+            . 'WHERE db_name = \'' . $this->dbi->escapeString($database) . '\' AND col_name IN (' . $cols . ');';
+
+        if (! $this->dbi->tryQuery($query, DatabaseInterface::CONNECT_CONTROL)) {
+            $message = Message::error(__('Could not remove columns!'));
+            $message->addHtml('<br>' . htmlspecialchars($cols) . '<br>');
+            $message->addMessage(
+                Message::rawError(
+                    $this->dbi->getError(DatabaseInterface::CONNECT_CONTROL)
+                )
+            );
+        }
+        return $message;
+    }
+
+    /**
+     * Make the columns of given tables consistent with central list of columns.
+     * Updates only those columns which are not being referenced.
+     *
+     * @param string $db              current database
+     * @param array  $selected_tables list of selected tables.
+     *
+     * @return true|Message
+     */
+    public function makeConsistentWithList(
+        string $db,
+        array $selected_tables
+    ) {
+        $message = true;
+        foreach ($selected_tables as $table) {
+            $query = 'ALTER TABLE ' . Util::backquote($table);
+            $has_list = $this->getFromTable($db, $table, true);
+            $this->dbi->selectDb($db);
+            foreach ($has_list as $column) {
+                $column_status = $this->relation->checkChildForeignReferences(
+                    $db,
+                    $table,
+                    $column['col_name']
+                );
+                //column definition can only be changed if
+                //it is not referenced by another column
+                if ($column_status['isEditable']) {
+                    $query .= ' MODIFY ' . Util::backquote($column['col_name']) . ' '
+                        . $this->dbi->escapeString($column['col_type']);
+                    if ($column['col_length']) {
+                        $query .= '(' . $column['col_length'] . ')';
+                    }
+
+                    $query .= ' ' . $column['col_attribute'];
+                    if ($column['col_isNull']) {
+                        $query .= ' NULL';
+                    } else {
+                        $query .= ' NOT NULL';
+                    }
+
+                    $query .= ' ' . $column['col_extra'];
+                    if ($column['col_default']) {
+                        if ($column['col_default'] != 'CURRENT_TIMESTAMP'
+                            && $column['col_default'] != 'current_timestamp()') {
+                            $query .= ' DEFAULT \'' . $this->dbi->escapeString(
+                                (string) $column['col_default']
+                            ) . '\'';
+                        } else {
+                            $query .= ' DEFAULT ' . $this->dbi->escapeString(
+                                $column['col_default']
+                            );
+                        }
+                    }
+                    $query .= ',';
+                }
+            }
+            $query = trim($query, " ,") . ";";
+            if (! $this->dbi->tryQuery($query)) {
+                if ($message === true) {
+                    $message = Message::error(
+                        $this->dbi->getError()
+                    );
+                } else {
+                    $message->addText(
+                        $this->dbi->getError(),
+                        '<br>'
+                    );
+                }
+            }
+        }
+        return $message;
+    }
+
+    /**
+     * return the columns present in central list of columns for a given
+     * table of a given database
+     *
+     * @param string  $db        given database
+     * @param string  $table     given table
+     * @param boolean $allFields set if need all the fields of existing columns,
+     *                           otherwise only column_name is returned
+     *
+     * @return array columns present in central list from given table of given db.
+     */
+    public function getFromTable(
+        string $db,
+        string $table,
+        bool $allFields = false
+    ): array {
+        $cfgCentralColumns = $this->getParams();
+        if (empty($cfgCentralColumns)) {
+            return [];
+        }
+        $this->dbi->selectDb($db);
+        $fields = (array) $this->dbi->getColumnNames(
+            $db,
+            $table
+        );
+        $cols = '';
+        foreach ($fields as $col_select) {
+            $cols .= '\'' . $this->dbi->escapeString((string) $col_select) . '\',';
+        }
+        $cols = trim($cols, ',');
+        $has_list = $this->findExistingColNames($db, $cols, $allFields);
+        if (! empty($has_list)) {
+            return (array) $has_list;
+        }
+
+        return [];
+    }
+
+    /**
+     * update a column in central columns list if a edit is requested
+     *
+     * @param string $db            current database
+     * @param string $orig_col_name original column name before edit
+     * @param string $col_name      new column name
+     * @param string $col_type      new column type
+     * @param string $col_attribute new column attribute
+     * @param string $col_length    new column length
+     * @param int    $col_isNull    value 1 if new column isNull is true, 0 otherwise
+     * @param string $collation     new column collation
+     * @param string $col_extra     new column extra property
+     * @param string $col_default   new column default value
+     *
+     * @return true|Message
+     */
+    public function updateOneColumn(
+        string $db,
+        string $orig_col_name,
+        string $col_name,
+        string $col_type,
+        string $col_attribute,
+        string $col_length,
+        int $col_isNull,
+        string $collation,
+        string $col_extra,
+        string $col_default
+    ) {
+        $cfgCentralColumns = $this->getParams();
+        if (empty($cfgCentralColumns)) {
+            return $this->configErrorMessage();
+        }
+        $centralTable = $cfgCentralColumns['table'];
+        $this->dbi->selectDb($cfgCentralColumns['db'], DatabaseInterface::CONNECT_CONTROL);
+        if ($orig_col_name == "") {
+            $def = [];
+            $def['Type'] = $col_type;
+            if ($col_length) {
+                $def['Type'] .= '(' . $col_length . ')';
+            }
+            $def['Collation'] = $collation;
+            $def['Null'] = $col_isNull ? __('YES') : __('NO');
+            $def['Extra'] = $col_extra;
+            $def['Attribute'] = $col_attribute;
+            $def['Default'] = $col_default;
+            $query = $this->getInsertQuery($col_name, $def, $db, $centralTable);
+        } else {
+            $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)
+                . '\'';
+        }
+        if (! $this->dbi->tryQuery($query, DatabaseInterface::CONNECT_CONTROL)) {
+            return Message::error(
+                $this->dbi->getError(DatabaseInterface::CONNECT_CONTROL)
+            );
+        }
+        return true;
+    }
+
+    /**
+     * Update Multiple column in central columns list if a change is requested
+     *
+     * @param array $params Request parameters
+     * @return true|Message
+     */
+    public function updateMultipleColumn(array $params)
+    {
+        $columnDefault = $params['field_default_type'];
+        $columnIsNull = [];
+        $columnExtra = [];
+        $numberCentralFields = count($params['orig_col_name']);
+        for ($i = 0; $i < $numberCentralFields; $i++) {
+            $columnIsNull[$i] = isset($params['field_null'][$i]) ? 1 : 0;
+            $columnExtra[$i] = $params['col_extra'][$i] ?? '';
+
+            if ($columnDefault[$i] === 'NONE') {
+                $columnDefault[$i] = '';
+            } elseif ($columnDefault[$i] === 'USER_DEFINED') {
+                $columnDefault[$i] = $params['field_default_value'][$i];
+            }
+
+            $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]
+            );
+            if (! is_bool($message)) {
+                return $message;
+            }
+        }
+        return true;
+    }
+
+    /**
+     * Function generate and return the table header for
+     * multiple edit central columns page
+     *
+     * @param array $headers headers list
+     *
+     * @return string html for table header in central columns multi edit page
+     */
+    private function getEditTableHeader(array $headers): string
+    {
+        return $this->template->render('database/central_columns/edit_table_header', [
+            'headers' => $headers,
+        ]);
+    }
+
+    /**
+     * build html for editing a row in central columns table
+     *
+     * @param array $row     array contains complete information of a
+     *                       particular row of central list table
+     * @param int   $row_num position the row in the table
+     *
+     * @return string html of a particular row in the central columns table.
+     */
+    private function getHtmlForEditTableRow(array $row, int $row_num): string
+    {
+        $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>';
+        $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>';
+        $tableHtml .=
+            '<td class="nowrap" name="col_length">'
+            . $this->template->render('columns_definitions/column_length', [
+                'column_number' => $row_num,
+                'ci' => 2,
+                'ci_offset' => 0,
+                'length_values_input_size' => 8,
+                'length_to_display' => $row['col_length'],
+            ])
+            . '</td>';
+        $meta = [];
+        if (! isset($row['col_default']) || $row['col_default'] == '') {
+            $meta['DefaultType'] = 'NONE';
+        } elseif ($row['col_default'] == 'CURRENT_TIMESTAMP'
+            || $row['col_default'] == 'current_timestamp()'
+        ) {
+            $meta['DefaultType'] = 'CURRENT_TIMESTAMP';
+        } elseif ($row['col_default'] == 'NULL') {
+            $meta['DefaultType'] = $row['col_default'];
+        } else {
+            $meta['DefaultType'] = 'USER_DEFINED';
+            $meta['DefaultValue'] = $row['col_default'];
+        }
+        $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>';
+        $tableHtml .= '<td name="collation" class="nowrap">';
+        $tableHtml .= '<select lang="en" dir="ltr" name="field_collation[' . $row_num . ']"';
+        $tableHtml .= ' id="field_' . $row_num . '_4">' . "\n";
+        $tableHtml .= '<option value=""></option>' . "\n";
+
+        $charsets = Charsets::getCharsets($this->dbi, $this->disableIs);
+        $collations = Charsets::getCollations($this->dbi, $this->disableIs);
+        /** @var Charset $charset */
+        foreach ($charsets as $charset) {
+            $tableHtml .= '<optgroup label="' . $charset->getName()
+                . '" title="' . $charset->getDescription() . '">' . "\n";
+            /** @var Collation $collation */
+            foreach ($collations[$charset->getName()] as $collation) {
+                $tableHtml .= '<option value="' . $collation->getName()
+                    . '" title="' . $collation->getDescription() . '"'
+                    . ($row['col_collation'] == $collation->getName() ? ' selected' : '') . '>'
+                    . $collation->getName() . '</option>' . "\n";
+            }
+            $tableHtml .= '</optgroup>' . "\n";
+        }
+        $tableHtml .= '</select>' . "\n";
+        $tableHtml .= '</td>';
+        $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>';
+        $tableHtml .=
+            '<td class="nowrap" name="col_isNull">'
+            . $this->template->render('columns_definitions/column_null', [
+                'column_number' => $row_num,
+                'ci' => 6,
+                'ci_offset' => 0,
+                'column_meta' => [
+                    'Null' => $row['col_isNull'],
+                ],
+            ])
+            . '</td>';
+
+        $tableHtml .=
+            '<td class="nowrap" name="col_extra">'
+            . $this->template->render('columns_definitions/column_extra', [
+                'column_number' => $row_num,
+                'ci' => 7,
+                'ci_offset' => 0,
+                'column_meta' => ['Extra' => $row['col_extra']],
+            ])
+            . '</td>';
+        $tableHtml .= '</tr>';
+        return $tableHtml;
+    }
+
+    /**
+     * get the list of columns in given database excluding
+     * the columns present in current table
+     *
+     * @param string $db    selected database
+     * @param string $table current table name
+     *
+     * @return array encoded list of columns present in central list for the given
+     *               database
+     */
+    public function getListRaw(string $db, string $table): array
+    {
+        $cfgCentralColumns = $this->getParams();
+        if (empty($cfgCentralColumns)) {
+            return [];
+        }
+        $centralTable = $cfgCentralColumns['table'];
+        if (empty($table) || $table == '') {
+            $query = 'SELECT * FROM ' . Util::backquote($centralTable) . ' '
+                . 'WHERE db_name = \'' . $this->dbi->escapeString($db) . '\';';
+        } else {
+            $this->dbi->selectDb($db);
+            $columns = (array) $this->dbi->getColumnNames(
+                $db,
+                $table
+            );
+            $cols = '';
+            foreach ($columns as $col_select) {
+                $cols .= '\'' . $this->dbi->escapeString($col_select) . '\',';
+            }
+            $cols = trim($cols, ',');
+            $query = 'SELECT * FROM ' . Util::backquote($centralTable) . ' '
+                . 'WHERE db_name = \'' . $this->dbi->escapeString($db) . '\'';
+            if ($cols) {
+                $query .= ' AND col_name NOT IN (' . $cols . ')';
+            }
+            $query .= ';';
+        }
+        $this->dbi->selectDb($cfgCentralColumns['db'], DatabaseInterface::CONNECT_CONTROL);
+        $columns_list = (array) $this->dbi->fetchResult(
+            $query,
+            null,
+            null,
+            DatabaseInterface::CONNECT_CONTROL
+        );
+        $this->handleColumnExtra($columns_list);
+        return $columns_list;
+    }
+
+    /**
+     * Get HTML for "check all" check box with "with selected" dropdown
+     *
+     * @param string $pmaThemeImage pma theme image url
+     * @param string $text_dir      url for text directory
+     *
+     * @return string
+     */
+    public function getTableFooter(string $pmaThemeImage, string $text_dir): string
+    {
+        $html_output = $this->template->render('select_all', [
+            'pma_theme_image' => $pmaThemeImage,
+            'text_dir' => $text_dir,
+            'form_name' => 'tableslistcontainer',
+        ]);
+        $html_output .= Util::getButtonOrImage(
+            'edit_central_columns',
+            'mult_submit change_central_columns',
+            __('Edit'),
+            'b_edit',
+            'edit central columns'
+        );
+        $html_output .= Util::getButtonOrImage(
+            'delete_central_columns',
+            'mult_submit',
+            __('Delete'),
+            'b_drop',
+            'remove_from_central_columns'
+        );
+        return $html_output;
+    }
+
+    /**
+     * function generate and return the table footer for
+     * multiple edit central columns page
+     *
+     * @return string html for table footer in central columns multi edit page
+     */
+    private function getEditTableFooter(): string
+    {
+        return '<fieldset class="tblFooters">'
+            . '<input class="btn btn-primary" type="submit" '
+            . 'name="save_multi_central_column_edit" value="' . __('Save') . '">'
+            . '</fieldset>';
+    }
+
+    /**
+     * Column `col_extra` is used to store both extra and attributes for a column.
+     * This method separates them.
+     *
+     * @param array $columns_list columns list
+     *
+     * @return void
+     */
+    private function handleColumnExtra(array &$columns_list): void
+    {
+        foreach ($columns_list as &$row) {
+            $vals = explode(',', $row['col_extra']);
+
+            if (in_array('BINARY', $vals)) {
+                $row['col_attribute'] = 'BINARY';
+            } elseif (in_array('UNSIGNED', $vals)) {
+                $row['col_attribute'] = 'UNSIGNED';
+            } elseif (in_array('UNSIGNED ZEROFILL', $vals)) {
+                $row['col_attribute'] = 'UNSIGNED ZEROFILL';
+            } elseif (in_array('on update CURRENT_TIMESTAMP', $vals)) {
+                $row['col_attribute'] = 'on update CURRENT_TIMESTAMP';
+            } else {
+                $row['col_attribute'] = '';
+            }
+
+            if (in_array('auto_increment', $vals)) {
+                $row['col_extra'] = 'auto_increment';
+            } else {
+                $row['col_extra'] = '';
+            }
+        }
+    }
+
+    /**
+     * Get HTML for editing page central columns
+     *
+     * @param array  $selected_fld Array containing the selected fields
+     * @param string $selected_db  String containing the name of database
+     *
+     * @return string HTML for complete editing page for central columns
+     */
+    public function getHtmlForEditingPage(array $selected_fld, string $selected_db): string
+    {
+        $html = '<form id="multi_edit_central_columns">';
+        $header_cells = [
+            __('Name'),
+            __('Type'),
+            __('Length/Values'),
+            __('Default'),
+            __('Collation'),
+            __('Attributes'),
+            __('Null'),
+            __('A_I'),
+        ];
+        $html .= $this->getEditTableHeader($header_cells);
+        $selected_fld_safe = [];
+        foreach ($selected_fld as $key) {
+            $selected_fld_safe[] = $this->dbi->escapeString($key);
+        }
+        $columns_list = implode("','", $selected_fld_safe);
+        $columns_list = "'" . $columns_list . "'";
+        $list_detail_cols = $this->findExistingColNames($selected_db, $columns_list, true);
+        $row_num = 0;
+        foreach ($list_detail_cols as $row) {
+            $tableHtmlRow = $this->getHtmlForEditTableRow(
+                $row,
+                $row_num
+            );
+            $html .= $tableHtmlRow;
+            $row_num++;
+        }
+        $html .= '</table>';
+        $html .= $this->getEditTableFooter();
+        $html .= '</form>';
+        return $html;
+    }
+
+    /**
+     * get number of columns of given database from central columns list
+     * starting at offset $from
+     *
+     * @param string $db   selected database
+     * @param int    $from starting offset of first result
+     * @param int    $num  maximum number of results to return
+     *
+     * @return int count of $num columns present in central columns list
+     * starting at offset $from for the given database
+     */
+    public function getColumnsCount(string $db, int $from = 0, int $num = 25): int
+    {
+        $cfgCentralColumns = $this->getParams();
+        if (empty($cfgCentralColumns)) {
+            return 0;
+        }
+        $pmadb = $cfgCentralColumns['db'];
+        $this->dbi->selectDb($pmadb, DatabaseInterface::CONNECT_CONTROL);
+        $central_list_table = $cfgCentralColumns['table'];
+        //get current values of $db from central column list
+        $query = 'SELECT COUNT(db_name) FROM ' . Util::backquote($central_list_table) . ' '
+            . 'WHERE db_name = \'' . $this->dbi->escapeString($db) . '\'' .
+            ($num === 0 ? '' : 'LIMIT ' . $from . ', ' . $num) . ';';
+        $result = (array) $this->dbi->fetchResult(
+            $query,
+            null,
+            null,
+            DatabaseInterface::CONNECT_CONTROL
+        );
+
+        if (isset($result[0])) {
+            return (int) $result[0];
+        }
+
+        return -1;
+    }
+
+    /**
+     * build dropdown select html to select column in selected table,
+     * include only columns which are not already in central list
+     *
+     * @param string $db           current database to which selected table belongs
+     * @param string $selected_tbl selected table
+     *
+     * @return string html to select column
+     */
+    public function getHtmlForColumnDropdown($db, $selected_tbl)
+    {
+        $existing_cols = $this->getFromTable($db, $selected_tbl);
+        $this->dbi->selectDb($db);
+        $columns = (array) $this->dbi->getColumnNames(
+            $db,
+            $selected_tbl
+        );
+        $selectColHtml = "";
+        foreach ($columns as $column) {
+            if (! in_array($column, $existing_cols)) {
+                $selectColHtml .= '<option value="' . htmlspecialchars($column) . '">'
+                    . htmlspecialchars($column)
+                    . '</option>';
+            }
+        }
+        return $selectColHtml;
+    }
+
+    /**
+     * build html for adding a new user defined column to central list
+     *
+     * @param string $db            current database
+     * @param int    $total_rows    number of rows in central columns
+     * @param int    $pos           offset of first result with complete result set
+     * @param string $pmaThemeImage table footer theme image directorie
+     * @param string $text_dir      table footer arrow direction
+     *
+     * @return string html of the form to let user add a new user defined column to the
+     *                list
+     */
+    public function getHtmlForMain(
+        string $db,
+        int $total_rows,
+        int $pos,
+        string $pmaThemeImage,
+        string $text_dir
+    ): string {
+        $max_rows = $this->maxRows;
+        $attribute_types = $this->dbi->types->getAttributes();
+
+        $tn_pageNow = ($pos / $this->maxRows) + 1;
+        $tn_nbTotalPage = ceil($total_rows / $this->maxRows);
+        $tn_page_selector = $tn_nbTotalPage > 1 ? Util::pageselector(
+            'pos',
+            $this->maxRows,
+            $tn_pageNow,
+            $tn_nbTotalPage
+        ) : '';
+        $this->dbi->selectDb($db);
+        $tables = $this->dbi->getTables($db);
+        $rows_list = $this->getColumnsList($db, $pos, $max_rows);
+
+        $rows_meta = [];
+        $types_upper = [];
+        $row_num = 0;
+        foreach ($rows_list as $row) {
+            $rows_meta[$row_num] = [];
+            if (! isset($row['col_default']) || $row['col_default'] == '') {
+                $rows_meta[$row_num]['DefaultType'] = 'NONE';
+            } else {
+                if ($row['col_default'] == 'CURRENT_TIMESTAMP'
+                    || $row['col_default'] == 'current_timestamp()'
+                ) {
+                    $rows_meta[$row_num]['DefaultType'] = 'CURRENT_TIMESTAMP';
+                } elseif ($row['col_default'] == 'NULL') {
+                    $rows_meta[$row_num]['DefaultType'] = $row['col_default'];
+                } else {
+                    $rows_meta[$row_num]['DefaultType'] = 'USER_DEFINED';
+                    $rows_meta[$row_num]['DefaultValue'] = $row['col_default'];
+                }
+            }
+            $types_upper[$row_num] = mb_strtoupper((string) $row['col_type']);
+            $row_num++;
+        }
+
+        $charsets = Charsets::getCharsets($this->dbi, $this->disableIs);
+        $collations = Charsets::getCollations($this->dbi, $this->disableIs);
+        $charsetsList = [];
+        /** @var Charset $charset */
+        foreach ($charsets as $charset) {
+            $collationsList = [];
+            /** @var Collation $collation */
+            foreach ($collations[$charset->getName()] as $collation) {
+                $collationsList[] = [
+                    'name' => $collation->getName(),
+                    'description' => $collation->getDescription(),
+                ];
+            }
+            $charsetsList[] = [
+                'name' => $charset->getName(),
+                'description' => $charset->getDescription(),
+                'collations' => $collationsList,
+            ];
+        }
+
+        return $this->template->render('database/central_columns/main', [
+            "db" => $db,
+            "total_rows" => $total_rows,
+            "max_rows" => $max_rows,
+            "pos" => $pos,
+            "char_editing" => $this->charEditing,
+            "attribute_types" => $attribute_types,
+            "tn_nbTotalPage" => $tn_nbTotalPage,
+            "tn_page_selector" => $tn_page_selector,
+            "tables" => $tables,
+            "rows_list" => $rows_list,
+            "rows_meta" => $rows_meta,
+            "types_upper" => $types_upper,
+            "pmaThemeImage" => $pmaThemeImage,
+            "text_dir" => $text_dir,
+            'charsets' => $charsetsList,
+        ]);
+    }
+}