404

[ Avaa Bypassed ]




Upload:

Command:

botdev@18.225.156.49: ~ $
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * set of functions with the operations section in pma
 *
 * @package PhpMyAdmin
 */
use PMA\libraries\engines\Innodb;
use PMA\libraries\Message;
use PMA\libraries\Partition;
use PMA\libraries\plugins\export\ExportSql;
use PMA\libraries\Response;
use PMA\libraries\StorageEngine;
use PMA\libraries\Table;
use PMA\libraries\Util;

/**
 * Get HTML output for database comment
 *
 * @param string $db database name
 *
 * @return string $html_output
 */
function PMA_getHtmlForDatabaseComment($db)
{
    $html_output = '<div class="operations_half_width">'
        . '<form method="post" action="db_operations.php" id="formDatabaseComment">'
        . PMA_URL_getHiddenInputs($db)
        . '<fieldset>'
        . '<legend>';
    if (PMA\libraries\Util::showIcons('ActionLinksMode')) {
        $html_output .= PMA\libraries\Util::getImage('b_comment.png') . '&nbsp;';
    }
    $html_output .=  __('Database comment');
    $html_output .= '</legend>';
    $html_output .= '<input type="text" name="comment" '
        . 'class="textfield" size="30"'
        . 'value="' . htmlspecialchars(PMA_getDBComment($db)) . '" />'
        . '</fieldset>';
    $html_output .= '<fieldset class="tblFooters">'
        . '<input type="submit" value="' . __('Go') . '" />'
        . '</fieldset>'
        . '</form>'
        . '</div>';

    return $html_output;
}

/**
 * Get HTML output for rename database
 *
 * @param string $db database name
 *
 * @return string $html_output
 */
function PMA_getHtmlForRenameDatabase($db)
{
    $html_output = '<div class="operations_half_width">'
        . '<form id="rename_db_form" '
        . 'class="ajax" '
        . 'method="post" action="db_operations.php" '
        . 'onsubmit="return emptyCheckTheField(this, \'newname\')">';
    if (isset($_REQUEST['db_collation'])) {
        $html_output .= '<input type="hidden" name="db_collation" '
            . 'value="' . $_REQUEST['db_collation']
            . '" />' . "\n";
    }
    $html_output .= '<input type="hidden" name="what" value="data" />'
        . '<input type="hidden" name="db_rename" value="true" />'
        . PMA_URL_getHiddenInputs($db)
        . '<fieldset>'
        . '<legend>';

    if (PMA\libraries\Util::showIcons('ActionLinksMode')) {
        $html_output .= PMA\libraries\Util::getImage('b_edit.png') . '&nbsp;';
    }
    $html_output .= __('Rename database to')
        . '</legend>';

    $html_output .= '<input id="new_db_name" type="text" name="newname" '
        . 'maxlength="64" size="30" class="textfield" required="required" '
        . 'value="' . htmlspecialchars($db) . '"/>';

    if ($GLOBALS['db_priv'] && $GLOBALS['table_priv']
        && $GLOBALS['col_priv'] && $GLOBALS['proc_priv']
        && $GLOBALS['is_reload_priv']
    ) {
        $html_output .= '<input type="checkbox" name="adjust_privileges" '
            . 'value="1" id="checkbox_adjust_privileges" checked="checked" />';
    } else {
        $html_output .= '<input type="checkbox" name="adjust_privileges" '
            . 'value="1" id="checkbox_adjust_privileges" title="' . __(
                'You don\'t have sufficient privileges to perform this '
                . 'operation; Please refer to the documentation for more details'
            )
            . '" disabled/>';
    }

    $html_output .= '<label for="checkbox_adjust_privileges">'
            . __('Adjust privileges') . Util::showDocu('faq', 'faq6-39')
            . '</label><br />';

    $html_output .= ''
        . '</fieldset>'
        . '<fieldset class="tblFooters">'
        . '<input id="rename_db_input" type="submit" value="' . __('Go') . '" />'
        . '</fieldset>'
        . '</form>'
        . '</div>';

    return $html_output;
}

/**
 * Get HTML for database drop link
 *
 * @param string $db database name
 *
 * @return string $html_output
 */
function PMA_getHtmlForDropDatabaseLink($db)
{
    $this_sql_query = 'DROP DATABASE ' . PMA\libraries\Util::backquote($db);
    $this_url_params = array(
        'sql_query' => $this_sql_query,
        'back' => 'db_operations.php',
        'goto' => 'index.php',
        'reload' => '1',
        'purge' => '1',
        'message_to_show' => sprintf(
            __('Database %s has been dropped.'),
            htmlspecialchars(PMA\libraries\Util::backquote($db))
        ),
        'db' => null,
    );

    $html_output = '<div class="operations_half_width">'
        . '<fieldset class="caution">';
    $html_output .= '<legend>';
    if (PMA\libraries\Util::showIcons('ActionLinksMode')) {
        $html_output .= PMA\libraries\Util::getImage('b_deltbl.png') . '&nbsp';
    }
    $html_output .= __('Remove database')
        . '</legend>';
    $html_output .= '<ul>';
    $html_output .= PMA_getDeleteDataOrTablelink(
        $this_url_params,
        'DROP_DATABASE',
        __('Drop the database (DROP)'),
        'drop_db_anchor'
    );
    $html_output .= '</ul></fieldset>'
        . '</div>';

    return $html_output;
}

/**
 * Get HTML snippet for copy database
 *
 * @param string $db database name
 *
 * @return string $html_output
 */
function PMA_getHtmlForCopyDatabase($db)
{
    $drop_clause = 'DROP TABLE / DROP VIEW';
    $choices = array(
        'structure' => __('Structure only'),
        'data'      => __('Structure and data'),
        'dataonly'  => __('Data only')
    );

    if (isset($_COOKIE)
        && isset($_COOKIE['pma_switch_to_new'])
        && $_COOKIE['pma_switch_to_new'] == 'true'
    ) {
        $pma_switch_to_new = 'true';
    }

    $html_output = '<div class="operations_half_width clearfloat">';
    $html_output .= '<form id="copy_db_form" '
        . 'class="ajax" '
        . 'method="post" action="db_operations.php" '
        . 'onsubmit="return emptyCheckTheField(this, \'newname\')">';

    if (isset($_REQUEST['db_collation'])) {
        $html_output .= '<input type="hidden" name="db_collation" '
        . 'value="' . $_REQUEST['db_collation'] . '" />' . "\n";
    }
    $html_output .= '<input type="hidden" name="db_copy" value="true" />' . "\n"
        . PMA_URL_getHiddenInputs($db);
    $html_output .= '<fieldset>'
        . '<legend>';

    if (PMA\libraries\Util::showIcons('ActionLinksMode')) {
        $html_output .= PMA\libraries\Util::getImage('b_edit.png') . '&nbsp';
    }
    $html_output .= __('Copy database to')
        . '</legend>'
        . '<input type="text" maxlength="64" name="newname" size="30" '
        . 'class="textfield" value="' . htmlspecialchars($db) . '" '
        . 'required="required" /><br />'
        . PMA\libraries\Util::getRadioFields(
            'what', $choices, 'data', true
        );
    $html_output .= '<br />';
    $html_output .= '<input type="checkbox" name="create_database_before_copying" '
        . 'value="1" id="checkbox_create_database_before_copying"'
        . 'checked="checked" />';
    $html_output .= '<label for="checkbox_create_database_before_copying">'
        . __('CREATE DATABASE before copying') . '</label><br />';
    $html_output .= '<input type="checkbox" name="drop_if_exists" value="true"'
        . 'id="checkbox_drop" />';
    $html_output .= '<label for="checkbox_drop">'
        . sprintf(__('Add %s'), $drop_clause)
        . '</label><br />';
    $html_output .= '<input type="checkbox" name="sql_auto_increment" value="1" '
        . 'checked="checked" id="checkbox_auto_increment" />';
    $html_output .= '<label for="checkbox_auto_increment">'
        . __('Add AUTO_INCREMENT value') . '</label><br />';
    $html_output .= '<input type="checkbox" name="add_constraints" value="1"'
        . 'id="checkbox_constraints" checked="checked"/>';
    $html_output .= '<label for="checkbox_constraints">'
        . __('Add constraints') . '</label><br />';
    $html_output .= '<br />';

    if ($GLOBALS['db_priv'] && $GLOBALS['table_priv']
        && $GLOBALS['col_priv'] && $GLOBALS['proc_priv']
        && $GLOBALS['is_reload_priv']
    ) {
        $html_output .= '<input type="checkbox" name="adjust_privileges" '
            . 'value="1" id="checkbox_privileges" checked="checked" />';
    } else {
        $html_output .= '<input type="checkbox" name="adjust_privileges" '
            . 'value="1" id="checkbox_privileges" title="' . __(
                'You don\'t have sufficient privileges to perform this '
                . 'operation; Please refer to the documentation for more details'
            )
            . '" disabled/>';
    }
    $html_output .= '<label for="checkbox_privileges">'
        . __('Adjust privileges') . Util::showDocu('faq', 'faq6-39')
        . '</label><br />';

    $html_output .= '<input type="checkbox" name="switch_to_new" value="true"'
        . 'id="checkbox_switch"'
        . ((isset($pma_switch_to_new) && $pma_switch_to_new == 'true')
            ? ' checked="checked"'
            : '')
        . '/>';
    $html_output .= '<label for="checkbox_switch">'
        . __('Switch to copied database') . '</label>'
        . '</fieldset>';
    $html_output .= '<fieldset class="tblFooters">'
        . '<input type="submit" name="submit_copy" value="' . __('Go') . '" />'
        . '</fieldset>'
        . '</form>'
        . '</div>';

    return $html_output;
}

/**
 * Get HTML snippet for change database charset
 *
 * @param string $db    database name
 * @param string $table table name
 *
 * @return string $html_output
 */
function PMA_getHtmlForChangeDatabaseCharset($db, $table)
{
    $html_output = '<div class="operations_half_width">'
        . '<form id="change_db_charset_form" ';
    $html_output .= 'class="ajax" ';
    $html_output .= 'method="post" action="db_operations.php">';

    $html_output .= PMA_URL_getHiddenInputs($db, $table);

    $html_output .= '<fieldset>' . "\n"
       . '    <legend>';
    if (PMA\libraries\Util::showIcons('ActionLinksMode')) {
        $html_output .= PMA\libraries\Util::getImage('s_asci.png') . '&nbsp';
    }
    $html_output .= '<label for="select_db_collation">' . __('Collation')
        . '</label>' . "\n"
        . '</legend>' . "\n"
        . PMA_generateCharsetDropdownBox(
            PMA_CSDROPDOWN_COLLATION,
            'db_collation',
            'select_db_collation',
            isset($_REQUEST['db_collation']) ? $_REQUEST['db_collation'] : '',
            false
        )
        . '</fieldset>'
        . '<fieldset class="tblFooters">'
        . '<input type="submit" name="submitcollation"'
        . ' value="' . __('Go') . '" />' . "\n"
        . '</fieldset>' . "\n"
        . '</form></div>' . "\n";

    return $html_output;
}

/**
 * Run the Procedure definitions and function definitions
 *
 * to avoid selecting alternatively the current and new db
 * we would need to modify the CREATE definitions to qualify
 * the db name
 *
 * @param string $db database name
 *
 * @return void
 */
function PMA_runProcedureAndFunctionDefinitions($db)
{
    $procedure_names = $GLOBALS['dbi']->getProceduresOrFunctions($db, 'PROCEDURE');
    if ($procedure_names) {
        foreach ($procedure_names as $procedure_name) {
            $GLOBALS['dbi']->selectDb($db);
            $tmp_query = $GLOBALS['dbi']->getDefinition(
                $db, 'PROCEDURE', $procedure_name
            );
            // collect for later display
            $GLOBALS['sql_query'] .= "\n" . $tmp_query;
            $GLOBALS['dbi']->selectDb($_REQUEST['newname']);
            $GLOBALS['dbi']->query($tmp_query);
        }
    }

    $function_names = $GLOBALS['dbi']->getProceduresOrFunctions($db, 'FUNCTION');
    if ($function_names) {
        foreach ($function_names as $function_name) {
            $GLOBALS['dbi']->selectDb($db);
            $tmp_query = $GLOBALS['dbi']->getDefinition(
                $db, 'FUNCTION', $function_name
            );
            // collect for later display
            $GLOBALS['sql_query'] .= "\n" . $tmp_query;
            $GLOBALS['dbi']->selectDb($_REQUEST['newname']);
            $GLOBALS['dbi']->query($tmp_query);
        }
    }
}

/**
 * Create database before copy
 *
 * @return void
 */
function PMA_createDbBeforeCopy()
{
    // lower_case_table_names=1 `DB` becomes `db`
    if ($GLOBALS['dbi']->getLowerCaseNames() === '1') {
        $_REQUEST['newname'] = mb_strtolower(
            $_REQUEST['newname']
        );
    }

    $local_query = 'CREATE DATABASE IF NOT EXISTS '
        . PMA\libraries\Util::backquote($_REQUEST['newname']);
    if (isset($_REQUEST['db_collation'])) {
        $local_query .= ' DEFAULT'
            . PMA_generateCharsetQueryPart($_REQUEST['db_collation']);
    }
    $local_query .= ';';
    $GLOBALS['sql_query'] .= $local_query;

    // save the original db name because Tracker.php which
    // may be called under $GLOBALS['dbi']->query() changes $GLOBALS['db']
    // for some statements, one of which being CREATE DATABASE
    $original_db = $GLOBALS['db'];
    $GLOBALS['dbi']->query($local_query);
    $GLOBALS['db'] = $original_db;

    // Set the SQL mode to NO_AUTO_VALUE_ON_ZERO to prevent MySQL from creating
    // export statements it cannot import
    $sql_set_mode = "SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO'";
    $GLOBALS['dbi']->query($sql_set_mode);

    // rebuild the database list because Table::moveCopy
    // checks in this list if the target db exists
    $GLOBALS['dblist']->databases->build();
}

/**
 * Get views as an array and create SQL view stand-in
 *
 * @param array     $tables_full       array of all tables in given db or dbs
 * @param ExportSql $export_sql_plugin export plugin instance
 * @param string    $db                database name
 *
 * @return array $views
 */
function PMA_getViewsAndCreateSqlViewStandIn(
    $tables_full, $export_sql_plugin, $db
) {
    $views = array();
    foreach ($tables_full as $each_table => $tmp) {
        // to be able to rename a db containing views,
        // first all the views are collected and a stand-in is created
        // the real views are created after the tables
        if ($GLOBALS['dbi']->getTable($db, $each_table)->isView()) {

            // If view exists, and 'add drop view' is selected: Drop it!
            if ($_REQUEST['what'] != 'nocopy'
                && isset($_REQUEST['drop_if_exists'])
                && $_REQUEST['drop_if_exists'] == 'true'
            ) {
                $drop_query = 'DROP VIEW IF EXISTS '
                    . PMA\libraries\Util::backquote($_REQUEST['newname']) . '.'
                    . PMA\libraries\Util::backquote($each_table);
                $GLOBALS['dbi']->query($drop_query);

                $GLOBALS['sql_query'] .= "\n" . $drop_query . ';';
            }

            $views[] = $each_table;
            // Create stand-in definition to resolve view dependencies
            $sql_view_standin = $export_sql_plugin->getTableDefStandIn(
                $db, $each_table, "\n"
            );
            $GLOBALS['dbi']->selectDb($_REQUEST['newname']);
            $GLOBALS['dbi']->query($sql_view_standin);
            $GLOBALS['sql_query'] .= "\n" . $sql_view_standin;
        }
    }
    return $views;
}

/**
 * Get sql query for copy/rename table and boolean for whether copy/rename or not
 *
 * @param array   $tables_full array of all tables in given db or dbs
 * @param boolean $move        whether database name is empty or not
 * @param string  $db          database name
 *
 * @return array SQL queries for the constraints
 */
function PMA_copyTables($tables_full, $move, $db)
{
    $sqlContraints = array();
    foreach ($tables_full as $each_table => $tmp) {
        // skip the views; we have created stand-in definitions
        if ($GLOBALS['dbi']->getTable($db, $each_table)->isView()) {
            continue;
        }

        // value of $what for this table only
        $this_what = $_REQUEST['what'];

        // do not copy the data from a Merge table
        // note: on the calling FORM, 'data' means 'structure and data'
        if ($GLOBALS['dbi']->getTable($db, $each_table)->isMerge()) {
            if ($this_what == 'data') {
                $this_what = 'structure';
            }
            if ($this_what == 'dataonly') {
                $this_what = 'nocopy';
            }
        }

        if ($this_what != 'nocopy') {
            // keep the triggers from the original db+table
            // (third param is empty because delimiters are only intended
            //  for importing via the mysql client or our Import feature)
            $triggers = $GLOBALS['dbi']->getTriggers($db, $each_table, '');

            if (! Table::moveCopy(
                $db, $each_table, $_REQUEST['newname'], $each_table,
                (isset($this_what) ? $this_what : 'data'),
                $move, 'db_copy'
            )) {
                $GLOBALS['_error'] = true;
                break;
            }
            // apply the triggers to the destination db+table
            if ($triggers) {
                $GLOBALS['dbi']->selectDb($_REQUEST['newname']);
                foreach ($triggers as $trigger) {
                    $GLOBALS['dbi']->query($trigger['create']);
                    $GLOBALS['sql_query'] .= "\n" . $trigger['create'] . ';';
                }
            }

            // this does not apply to a rename operation
            if (isset($_REQUEST['add_constraints'])
                && ! empty($GLOBALS['sql_constraints_query'])
            ) {
                $sqlContraints[] = $GLOBALS['sql_constraints_query'];
                unset($GLOBALS['sql_constraints_query']);
            }
        }
    }
    return $sqlContraints;
}

/**
 * Run the EVENT definition for selected database
 *
 * to avoid selecting alternatively the current and new db
 * we would need to modify the CREATE definitions to qualify
 * the db name
 *
 * @param string $db database name
 *
 * @return void
 */
function PMA_runEventDefinitionsForDb($db)
{
    $event_names = $GLOBALS['dbi']->fetchResult(
        'SELECT EVENT_NAME FROM information_schema.EVENTS WHERE EVENT_SCHEMA= \''
        . $GLOBALS['dbi']->escapeString($db) . '\';'
    );
    if ($event_names) {
        foreach ($event_names as $event_name) {
            $GLOBALS['dbi']->selectDb($db);
            $tmp_query = $GLOBALS['dbi']->getDefinition($db, 'EVENT', $event_name);
            // collect for later display
            $GLOBALS['sql_query'] .= "\n" . $tmp_query;
            $GLOBALS['dbi']->selectDb($_REQUEST['newname']);
            $GLOBALS['dbi']->query($tmp_query);
        }
    }
}

/**
 * Handle the views, return the boolean value whether table rename/copy or not
 *
 * @param array   $views views as an array
 * @param boolean $move  whether database name is empty or not
 * @param string  $db    database name
 *
 * @return void
 */
function PMA_handleTheViews($views, $move, $db)
{
    // temporarily force to add DROP IF EXIST to CREATE VIEW query,
    // to remove stand-in VIEW that was created earlier
    // ( $_REQUEST['drop_if_exists'] is used in moveCopy() )
    if (isset($_REQUEST['drop_if_exists'])) {
        $temp_drop_if_exists = $_REQUEST['drop_if_exists'];
    }

    $_REQUEST['drop_if_exists'] = 'true';
    foreach ($views as $view) {
        $copying_succeeded = Table::moveCopy(
            $db, $view, $_REQUEST['newname'], $view, 'structure', $move, 'db_copy'
        );
        if (! $copying_succeeded) {
            $GLOBALS['_error'] = true;
            break;
        }
    }
    unset($_REQUEST['drop_if_exists']);

    if (isset($temp_drop_if_exists)) {
        // restore previous value
        $_REQUEST['drop_if_exists'] = $temp_drop_if_exists;
    }
}

/**
 * Adjust the privileges after Renaming the db
 *
 * @param string $oldDb   Database name before renaming
 * @param string $newname New Database name requested
 *
 * @return void
 */
function PMA_AdjustPrivileges_moveDB($oldDb, $newname)
{
    if ($GLOBALS['db_priv'] && $GLOBALS['table_priv']
        && $GLOBALS['col_priv'] && $GLOBALS['proc_priv']
        && $GLOBALS['is_reload_priv']
    ) {
        $GLOBALS['dbi']->selectDb('mysql');
        $newname = str_replace("_", "\_", $newname);
        $oldDb = str_replace("_", "\_", $oldDb);

        // For Db specific privileges
        $query_db_specific = 'UPDATE ' . Util::backquote('db')
            . 'SET Db = \'' . $GLOBALS['dbi']->escapeString($newname)
            . '\' where Db = \'' . $GLOBALS['dbi']->escapeString($oldDb) . '\';';
        $GLOBALS['dbi']->query($query_db_specific);

        // For table specific privileges
        $query_table_specific = 'UPDATE ' . Util::backquote('tables_priv')
            . 'SET Db = \'' . $GLOBALS['dbi']->escapeString($newname)
            . '\' where Db = \'' . $GLOBALS['dbi']->escapeString($oldDb) . '\';';
        $GLOBALS['dbi']->query($query_table_specific);

        // For column specific privileges
        $query_col_specific = 'UPDATE ' . Util::backquote('columns_priv')
            . 'SET Db = \'' . $GLOBALS['dbi']->escapeString($newname)
            . '\' where Db = \'' . $GLOBALS['dbi']->escapeString($oldDb) . '\';';
        $GLOBALS['dbi']->query($query_col_specific);

        // For procedures specific privileges
        $query_proc_specific = 'UPDATE ' . Util::backquote('procs_priv')
            . 'SET Db = \'' . $GLOBALS['dbi']->escapeString($newname)
            . '\' where Db = \'' . $GLOBALS['dbi']->escapeString($oldDb) . '\';';
        $GLOBALS['dbi']->query($query_proc_specific);

        // Finally FLUSH the new privileges
        $flush_query = "FLUSH PRIVILEGES;";
        $GLOBALS['dbi']->query($flush_query);
    }
}

/**
 * Adjust the privileges after Copying the db
 *
 * @param string $oldDb   Database name before copying
 * @param string $newname New Database name requested
 *
 * @return void
 */
function PMA_AdjustPrivileges_copyDB($oldDb, $newname)
{
    if ($GLOBALS['db_priv'] && $GLOBALS['table_priv']
        && $GLOBALS['col_priv'] && $GLOBALS['proc_priv']
        && $GLOBALS['is_reload_priv']
    ) {
        $GLOBALS['dbi']->selectDb('mysql');
        $newname = str_replace("_", "\_", $newname);
        $oldDb = str_replace("_", "\_", $oldDb);

        $query_db_specific_old = 'SELECT * FROM '
            . Util::backquote('db') . ' WHERE '
            . 'Db = "' . $oldDb . '";';

        $old_privs_db = $GLOBALS['dbi']->fetchResult($query_db_specific_old, 0);

        foreach ($old_privs_db as $old_priv) {
            $newDb_db_privs_query = 'INSERT INTO ' . Util::backquote('db')
                . ' VALUES("' . $old_priv[0] . '", "' . $newname . '", "'
                . $old_priv[2] . '", "' . $old_priv[3] . '", "' . $old_priv[4]
                . '", "' . $old_priv[5] . '", "' . $old_priv[6] . '", "'
                . $old_priv[7] . '", "' . $old_priv[8] . '", "' . $old_priv[9]
                . '", "' . $old_priv[10] . '", "' . $old_priv[11] . '", "'
                . $old_priv[12] . '", "' . $old_priv[13] . '", "' . $old_priv[14]
                . '", "' . $old_priv[15] . '", "' . $old_priv[16] . '", "'
                . $old_priv[17] . '", "' . $old_priv[18] . '", "' . $old_priv[19]
                . '", "' . $old_priv[20] . '", "' . $old_priv[21] . '");';

            $GLOBALS['dbi']->query($newDb_db_privs_query);
        }

        // For Table Specific privileges
        $query_table_specific_old = 'SELECT * FROM '
            . Util::backquote('tables_priv') . ' WHERE '
            . 'Db = "' . $oldDb . '";';

        $old_privs_table = $GLOBALS['dbi']->fetchResult(
            $query_table_specific_old,
            0
        );

        foreach ($old_privs_table as $old_priv) {
            $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] . '");';

            $GLOBALS['dbi']->query($newDb_table_privs_query);
        }

        // For Column Specific privileges
        $query_col_specific_old = 'SELECT * FROM '
            . Util::backquote('columns_priv') . ' WHERE '
            . 'Db = "' . $oldDb . '";';

        $old_privs_col = $GLOBALS['dbi']->fetchResult(
            $query_col_specific_old,
            0
        );

        foreach ($old_privs_col as $old_priv) {
            $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] . '");';

            $GLOBALS['dbi']->query($newDb_col_privs_query);
        }

        // For Procedure Specific privileges
        $query_proc_specific_old = 'SELECT * FROM '
            . Util::backquote('procs_priv') . ' WHERE '
            . 'Db = "' . $oldDb . '";';

        $old_privs_proc = $GLOBALS['dbi']->fetchResult(
            $query_proc_specific_old,
            0
        );

        foreach ($old_privs_proc as $old_priv) {
            $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] . '");';

            $GLOBALS['dbi']->query($newDb_proc_privs_query);
        }

        // Finally FLUSH the new privileges
        $flush_query = "FLUSH PRIVILEGES;";
        $GLOBALS['dbi']->query($flush_query);
    }
}

/**
 * Create all accumulated constraints
 *
 * @param array $sqlConstratints array of sql constraints for the database
 *
 * @return void
 */
function PMA_createAllAccumulatedConstraints($sqlConstratints)
{
    $GLOBALS['dbi']->selectDb($_REQUEST['newname']);
    foreach ($sqlConstratints as $one_query) {
        $GLOBALS['dbi']->query($one_query);
        // and prepare to display them
        $GLOBALS['sql_query'] .= "\n" . $one_query;
    }
}

/**
 * Duplicate the bookmarks for the db (done once for each db)
 *
 * @param boolean $_error whether table rename/copy or not
 * @param string  $db     database name
 *
 * @return void
 */
function PMA_duplicateBookmarks($_error, $db)
{
    if (! $_error && $db != $_REQUEST['newname']) {
        $get_fields = array('user', 'label', 'query');
        $where_fields = array('dbase' => $db);
        $new_fields = array('dbase' => $_REQUEST['newname']);
        Table::duplicateInfo(
            'bookmarkwork', 'bookmark', $get_fields,
            $where_fields, $new_fields
        );
    }
}

/**
 * Get the HTML snippet for order the table
 *
 * @param array $columns columns array
 *
 * @return string $html_out
 */
function PMA_getHtmlForOrderTheTable($columns)
{
    $html_output = '<div class="operations_half_width">';
    $html_output .= '<form method="post" id="alterTableOrderby" '
        . 'action="tbl_operations.php">';
    $html_output .= PMA_URL_getHiddenInputs(
        $GLOBALS['db'], $GLOBALS['table']
    );
    $html_output .= '<fieldset id="fieldset_table_order">'
        . '<legend>' . __('Alter table order by') . '</legend>'
        . '<select name="order_field">';

    foreach ($columns as $fieldname) {
        $html_output .= '<option '
            . 'value="' . htmlspecialchars($fieldname['Field']) . '">'
            . htmlspecialchars($fieldname['Field']) . '</option>' . "\n";
    }
    $html_output .= '</select> ' . __('(singly)') . ' '
        . '<br />'
        . '<input id="order_order_asc" name="order_order"'
        . ' type="radio" value="asc" checked="checked" />'
        . '<label for="order_order_asc">' . __('Ascending') . '</label>'
        . '<input id="order_order_desc" name="order_order"'
        . ' type="radio" value="desc" />'
        . '<label for="order_order_desc">' . __('Descending') . '</label>'
        . '</fieldset>'
        . '<fieldset class="tblFooters">'
        . '<input type="hidden" name="submitorderby" value="1" />'
        . '<input type="submit" value="' . __('Go') . '" />'
        . '</fieldset>'
        . '</form>'
        . '</div>';

     return $html_output;
}

/**
 * Get the HTML snippet for move table
 *
 * @return string $html_output
 */
function PMA_getHtmlForMoveTable()
{
    $html_output = '<div class="operations_half_width">';
    $html_output .= '<form method="post" action="tbl_operations.php"'
        . ' id="moveTableForm" class="ajax"'
        . ' onsubmit="return emptyCheckTheField(this, \'new_name\')">'
        . PMA_URL_getHiddenInputs($GLOBALS['db'], $GLOBALS['table']);

    $html_output .= '<input type="hidden" name="reload" value="1" />'
        . '<input type="hidden" name="what" value="data" />'
        . '<fieldset id="fieldset_table_rename">';

    $html_output .= '<legend>' . __('Move table to (database<b>.</b>table)')
        . '</legend>';

    if (count($GLOBALS['dblist']->databases) > $GLOBALS['cfg']['MaxDbList']) {
        $html_output .= '<input type="text" maxlength="100" size="30" '
            . 'name="target_db" value="' . htmlspecialchars($GLOBALS['db'])
            . '"/>';
    } else {
        $html_output .= '<select class="halfWidth" name="target_db">'
            . $GLOBALS['dblist']->databases->getHtmlOptions(true, false)
            . '</select>';
    }
    $html_output .= '&nbsp;<strong>.</strong>&nbsp;';
    $html_output .= '<input class="halfWidth" type="text" size="20" name="new_name"'
        . ' maxlength="64" required="required" '
        . 'value="' . htmlspecialchars($GLOBALS['table']) . '" /><br />';

    // starting with MySQL 5.0.24, SHOW CREATE TABLE includes the AUTO_INCREMENT
    // next value but users can decide if they want it or not for the operation

    $html_output .= '<input type="checkbox" name="sql_auto_increment" '
        . 'value="1" id="checkbox_auto_increment_mv" checked="checked" />'
        . '<label for="checkbox_auto_increment_mv">'
        . __('Add AUTO_INCREMENT value')
        . '</label><br />';

    if ($GLOBALS['table_priv'] && $GLOBALS['col_priv']
        && $GLOBALS['is_reload_priv']
    ) {
        $html_output .= '<input type="checkbox" name="adjust_privileges" '
            . 'value="1" id="checkbox_privileges_tables_move" '
            . 'checked="checked" />';
    } else {
        $html_output .= '<input type="checkbox" name="adjust_privileges" '
            . 'value="1" id="checkbox_privileges_tables_move" title="' . __(
                'You don\'t have sufficient privileges to perform this '
                . 'operation; Please refer to the documentation for more details'
            )
            . '" disabled/>';
    }
    $html_output .= '<label for="checkbox_privileges_tables_move">'
        . __('Adjust privileges') . Util::showDocu('faq', 'faq6-39')
        . '</label><br />';

    $html_output .= '</fieldset><fieldset class="tblFooters">'
        . '<input type="submit" name="submit_move" value="' . __('Go') . '" />'
        . '</fieldset>'
        . '</form>'
        . '</div>';

    return $html_output;
}

/**
 * Get the HTML div for Table option
 *
 * @param string  $comment            Comment
 * @param array   $tbl_collation      table collation
 * @param string  $tbl_storage_engine table storage engine
 * @param boolean $is_myisam_or_aria  whether MYISAM | ARIA or not
 * @param boolean $is_isam            whether ISAM or not
 * @param string  $pack_keys          pack keys
 * @param string  $auto_increment     value of auto increment
 * @param string  $delay_key_write    delay key write
 * @param string  $transactional      value of transactional
 * @param string  $page_checksum      value of page checksum
 * @param boolean $is_innodb          whether INNODB or not
 * @param boolean $is_pbxt            whether PBXT or not
 * @param boolean $is_aria            whether ARIA or not
 * @param string  $checksum           the checksum
 *
 * @return string $html_output
 */
function PMA_getTableOptionDiv($comment, $tbl_collation, $tbl_storage_engine,
    $is_myisam_or_aria, $is_isam, $pack_keys, $auto_increment, $delay_key_write,
    $transactional, $page_checksum, $is_innodb, $is_pbxt, $is_aria, $checksum
) {
    $html_output = '<div class="operations_half_width clearfloat">';
    $html_output .= '<form method="post" action="tbl_operations.php"';
    $html_output .= ' id="tableOptionsForm" class="ajax">';
    $html_output .= PMA_URL_getHiddenInputs(
        $GLOBALS['db'], $GLOBALS['table']
    );
    $html_output .= '<input type="hidden" name="reload" value="1" />';

    $html_output .= PMA_getTableOptionFieldset(
        $comment, $tbl_collation,
        $tbl_storage_engine, $is_myisam_or_aria, $is_isam, $pack_keys,
        $delay_key_write, $auto_increment, $transactional, $page_checksum,
        $is_innodb, $is_pbxt, $is_aria, $checksum
    );

    $html_output .= '<fieldset class="tblFooters">'
        . '<input type="hidden" name="submitoptions" value="1" />'
        . '<input type="submit" value="' . __('Go') . '" />'
        . '</fieldset>'
        . '</form>'
        . '</div>';

    return $html_output;
}

/**
 * Get HTML for the rename table part of table options
 *
 * @return string $html_output
 */
function PMA_getHtmlForRenameTable()
{
    $html_output = '<tr><td class="vmiddle">' . __('Rename table to') . '</td>'
        . '<td>'
        . '<input type="text" size="20" name="new_name" maxlength="64" '
        . 'value="' . htmlspecialchars($GLOBALS['table'])
        . '" required="required" />'
        . '</td></tr>'
        . '<tr><td></td><td>';

    if ($GLOBALS['table_priv'] && $GLOBALS['col_priv']
        && $GLOBALS['is_reload_priv']
    ) {
        $html_output .= '<input type="checkbox" name="adjust_privileges" '
            . 'value="1" id="checkbox_privileges_table_options" '
            . 'checked="checked" />';
    } else {
        $html_output .= '<input type="checkbox" name="adjust_privileges" '
            . 'value="1" id="checkbox_privileges_table_options" title="' . __(
                'You don\'t have sufficient privileges to perform this '
                . 'operation; Please refer to the documentation for more details'
            )
            . '" disabled/>';
    }
    $html_output .= '<label for="checkbox_privileges_table_options">'
        . __('Adjust privileges') . '&nbsp;'
        . Util::showDocu('faq', 'faq6-39') . '</label>';

    $html_output .= '</td></tr>';
    return $html_output;
}

/**
 * Get HTML for the table comments part of table options
 *
 * @param string $current_value of the table comments
 *
 * @return string $html_output
 */
function PMA_getHtmlForTableComments($current_value)
{
    $commentLength = PMA_MYSQL_INT_VERSION >= 50503 ? 2048 : 60;
    $html_output = '<tr><td class="vmiddle">' . __('Table comments') . '</td>'
        . '<td><input type="text" name="comment" '
        . 'maxlength="' . $commentLength . '" size="30"'
        . 'value="' . htmlspecialchars($current_value) . '" />'
        . '<input type="hidden" name="prev_comment" value="'
        . htmlspecialchars($current_value) . '" />'
        . '</td>'
        . '</tr>';

    return $html_output;
}

/**
 * Get HTML for the PACK KEYS part of table options
 *
 * @param string $current_value of the pack keys option
 *
 * @return string $html_output
 */
function PMA_getHtmlForPackKeys($current_value)
{
    $html_output = '<tr>'
        . '<td class="vmiddle"><label for="new_pack_keys">PACK_KEYS</label></td>'
        . '<td><select name="new_pack_keys" id="new_pack_keys">';

    $html_output .= '<option value="DEFAULT"';
    if ($current_value == 'DEFAULT') {
        $html_output .= 'selected="selected"';
    }
    $html_output .= '>DEFAULT</option>
            <option value="0"';
    if ($current_value == '0') {
        $html_output .= 'selected="selected"';
    }
    $html_output .= '>0</option>
            <option value="1" ';
    if ($current_value == '1') {
        $html_output .= 'selected="selected"';
    }
    $html_output .= '>1</option>'
        . '</select>'
        . '</td>'
        . '</tr>';

    return $html_output;
}

/**
 * Get HTML fieldset for Table option, it contains HTML table for options
 *
 * @param string  $comment            Comment
 * @param array   $tbl_collation      table collation
 * @param string  $tbl_storage_engine table storage engine
 * @param boolean $is_myisam_or_aria  whether MYISAM | ARIA or not
 * @param boolean $is_isam            whether ISAM or not
 * @param string  $pack_keys          pack keys
 * @param string  $delay_key_write    delay key write
 * @param string  $auto_increment     value of auto increment
 * @param string  $transactional      value of transactional
 * @param string  $page_checksum      value of page checksum
 * @param boolean $is_innodb          whether INNODB or not
 * @param boolean $is_pbxt            whether PBXT or not
 * @param boolean $is_aria            whether ARIA or not
 * @param string  $checksum           the checksum
 *
 * @return string $html_output
 */
function PMA_getTableOptionFieldset($comment, $tbl_collation,
    $tbl_storage_engine, $is_myisam_or_aria, $is_isam, $pack_keys,
    $delay_key_write, $auto_increment, $transactional,
    $page_checksum, $is_innodb, $is_pbxt, $is_aria, $checksum
) {
    $html_output = '<fieldset>'
        . '<legend>' . __('Table options') . '</legend>';

    $html_output .= '<table>';
    $html_output .= PMA_getHtmlForRenameTable();
    $html_output .= PMA_getHtmlForTableComments($comment);

    //Storage engine
    $html_output .= '<tr><td class="vmiddle">' . __('Storage Engine')
        . '&nbsp;' . PMA\libraries\Util::showMySQLDocu('Storage_engines')
        . '</td>'
        . '<td>'
        . StorageEngine::getHtmlSelect(
            'new_tbl_storage_engine', null, $tbl_storage_engine
        )
        . '</td>'
        . '</tr>';

    //Table character set
    $html_output .= '<tr><td class="vmiddle">' . __('Collation') . '</td>'
        . '<td>'
        . PMA_generateCharsetDropdownBox(
            PMA_CSDROPDOWN_COLLATION,
            'tbl_collation', null, $tbl_collation, false
        )
        . '</td>'
        . '</tr>';

    // Change all Column collations
    $html_output .= '<tr><td></td><td>'
        . '<input type="checkbox" name="change_all_collations" value="1" '
        . 'id="checkbox_change_all_collations" />'
        . '<label for="checkbox_change_all_collations">'
        . __('Change all column collations')
        . '</label>'
        . '</td></tr>';

    if ($is_myisam_or_aria || $is_isam) {
        $html_output .= PMA_getHtmlForPackKeys($pack_keys);
    } // end if (MYISAM|ISAM)

    if ($is_myisam_or_aria) {
        $html_output .= PMA_getHtmlForTableRow(
            'new_checksum',
            'CHECKSUM',
            $checksum
        );

        $html_output .= PMA_getHtmlForTableRow(
            'new_delay_key_write',
            'DELAY_KEY_WRITE',
            $delay_key_write
        );
    } // end if (MYISAM)

    if ($is_aria) {
        $html_output .= PMA_getHtmlForTableRow(
            'new_transactional',
            'TRANSACTIONAL',
            $transactional
        );

        $html_output .= PMA_getHtmlForTableRow(
            'new_page_checksum',
            'PAGE_CHECKSUM',
            $page_checksum
        );
    } // end if (ARIA)

    if (mb_strlen($auto_increment) > 0
        && ($is_myisam_or_aria || $is_innodb || $is_pbxt)
    ) {
        $html_output .= '<tr><td class="vmiddle">'
            . '<label for="auto_increment_opt">AUTO_INCREMENT</label></td>'
            . '<td><input type="number" name="new_auto_increment" '
            . 'id="auto_increment_opt"'
            . 'value="' . $auto_increment . '" /></td>'
            . '</tr> ';
    } // end if (MYISAM|INNODB)

    $possible_row_formats = PMA_getPossibleRowFormat();

    // for MYISAM there is also COMPRESSED but it can be set only by the
    // myisampack utility, so don't offer here the choice because if we
    // try it inside an ALTER TABLE, MySQL (at least in 5.1.23-maria)
    // does not return a warning
    // (if the table was compressed, it can be seen on the Structure page)

    if (isset($possible_row_formats[$tbl_storage_engine])) {
        $current_row_format
            = mb_strtoupper($GLOBALS['showtable']['Row_format']);
        $html_output .= '<tr><td class="vmiddle">'
            . '<label for="new_row_format">ROW_FORMAT</label></td>'
            . '<td>';
        $html_output .= PMA\libraries\Util::getDropdown(
            'new_row_format', $possible_row_formats[$tbl_storage_engine],
            $current_row_format, 'new_row_format'
        );
        $html_output .= '</td></tr>';
    }
    $html_output .= '</table>'
        . '</fieldset>';

    return $html_output;
}

/**
 * Get the common HTML table row (tr) for new_checksum, new_delay_key_write,
 * new_transactional and new_page_checksum
 *
 * @param string $attribute class, name and id attribute
 * @param string $label     label value
 * @param string $val       checksum, delay_key_write, transactional, page_checksum
 *
 * @return string $html_output
 */
function PMA_getHtmlForTableRow($attribute, $label, $val)
{
    return '<tr>'
        . '<td class="vmiddle">'
        . '<label for="' . $attribute . '">' . $label . '</label>'
        . '</td>'
        . '<td>'
        . '<input type="checkbox" name="' . $attribute . '" id="' . $attribute . '"'
        . ' value="1"' . ((!empty($val) && $val == 1) ? ' checked="checked"' : '')
        . '/>'
        . '</td>'
        . '</tr>';
}

/**
 * Get array of possible row formats
 *
 * @return array $possible_row_formats
 */
function PMA_getPossibleRowFormat()
{
    // the outer array is for engines, the inner array contains the dropdown
    // option values as keys then the dropdown option labels

    $possible_row_formats = array(
        'ARCHIVE' => array(
            'COMPRESSED' => 'COMPRESSED',
        ),
        'ARIA'  => array(
            'FIXED'     => 'FIXED',
            'DYNAMIC'   => 'DYNAMIC',
            'PAGE'      => 'PAGE'
        ),
        'MARIA'  => array(
            'FIXED'     => 'FIXED',
            'DYNAMIC'   => 'DYNAMIC',
            'PAGE'      => 'PAGE'
        ),
        'MYISAM' => array(
             'FIXED'    => 'FIXED',
             'DYNAMIC'  => 'DYNAMIC'
        ),
        'PBXT'   => array(
             'FIXED'    => 'FIXED',
             'DYNAMIC'  => 'DYNAMIC'
        ),
        'INNODB' => array(
             'COMPACT'  => 'COMPACT',
             'REDUNDANT' => 'REDUNDANT'
        )
    );

    /** @var Innodb $innodbEnginePlugin */
    $innodbEnginePlugin = StorageEngine::getEngine('Innodb');
    $innodbPluginVersion = $innodbEnginePlugin->getInnodbPluginVersion();
    if (!empty($innodbPluginVersion)) {
        $innodb_file_format = $innodbEnginePlugin->getInnodbFileFormat();
    } else {
        $innodb_file_format = '';
    }
    if ('Barracuda' == $innodb_file_format
        && $innodbEnginePlugin->supportsFilePerTable()
    ) {
        $possible_row_formats['INNODB']['DYNAMIC'] = 'DYNAMIC';
        $possible_row_formats['INNODB']['COMPRESSED'] = 'COMPRESSED';
    }

    return $possible_row_formats;
}

/**
 * Get HTML div for copy table
 *
 * @return string $html_output
 */
function PMA_getHtmlForCopytable()
{
    $html_output = '<div class="operations_half_width">';
    $html_output .= '<form method="post" action="tbl_operations.php" '
        . 'name="copyTable" '
        . 'id="copyTable" '
        . ' class="ajax" '
        . 'onsubmit="return emptyCheckTheField(this, \'new_name\')">'
        . PMA_URL_getHiddenInputs($GLOBALS['db'], $GLOBALS['table'])
        . '<input type="hidden" name="reload" value="1" />';

    $html_output .= '<fieldset>';
    $html_output .= '<legend>'
        . __('Copy table to (database<b>.</b>table)') . '</legend>';

    if (count($GLOBALS['dblist']->databases) > $GLOBALS['cfg']['MaxDbList']) {
        $html_output .= '<input class="halfWidth" type="text" maxlength="100" '
            . 'size="30" name="target_db" '
            . 'value="' . htmlspecialchars($GLOBALS['db']) . '"/>';
    } else {
        $html_output .= '<select class="halfWidth" name="target_db">'
            . $GLOBALS['dblist']->databases->getHtmlOptions(true, false)
            . '</select>';
    }
    $html_output .= '&nbsp;<strong>.</strong>&nbsp;';
    $html_output .= '<input class="halfWidth" type="text" required="required" '
        . 'size="20" name="new_name" maxlength="64" '
        . 'value="' . htmlspecialchars($GLOBALS['table']) . '"/><br />';

    $choices = array(
        'structure' => __('Structure only'),
        'data'      => __('Structure and data'),
        'dataonly'  => __('Data only')
    );

    $html_output .= PMA\libraries\Util::getRadioFields(
        'what', $choices, 'data', true
    );
    $html_output .= '<br />';

    $html_output .= '<input type="checkbox" name="drop_if_exists" '
        . 'value="true" id="checkbox_drop" />'
        . '<label for="checkbox_drop">'
        . sprintf(__('Add %s'), 'DROP TABLE') . '</label><br />'
        . '<input type="checkbox" name="sql_auto_increment" '
        . 'value="1" id="checkbox_auto_increment_cp" />'
        . '<label for="checkbox_auto_increment_cp">'
        . __('Add AUTO_INCREMENT value') . '</label><br />';

    // display "Add constraints" choice only if there are
    // foreign keys
    if (PMA_getForeigners($GLOBALS['db'], $GLOBALS['table'], '', 'foreign')) {
        $html_output .= '<input type="checkbox" name="add_constraints" '
            . 'value="1" id="checkbox_constraints" checked="checked"/>';
        $html_output .= '<label for="checkbox_constraints">'
            . __('Add constraints') . '</label><br />';
    } // endif

    $html_output .= '<br />';

    if ($GLOBALS['table_priv'] && $GLOBALS['col_priv']
        && $GLOBALS['is_reload_priv']
    ) {
        $html_output .= '<input type="checkbox" name="adjust_privileges" '
            . 'value="1" id="checkbox_adjust_privileges" checked="checked" />';
    } else {
        $html_output .= '<input type="checkbox" name="adjust_privileges" '
            . 'value="1" id="checkbox_adjust_privileges" title="' . __(
                'You don\'t have sufficient privileges to perform this '
                . 'operation; Please refer to the documentation for more details'
            )
            . '" disabled/>';
    }
    $html_output .= '<label for="checkbox_adjust_privileges">'
        . __('Adjust privileges') . Util::showDocu('faq', 'faq6-39')
        . '</label><br />';

    if (isset($_COOKIE['pma_switch_to_new'])
        && $_COOKIE['pma_switch_to_new'] == 'true'
    ) {
        $pma_switch_to_new = 'true';
    }

    $html_output .= '<input type="checkbox" name="switch_to_new" value="true"'
        . 'id="checkbox_switch"'
        . ((isset($pma_switch_to_new) && $pma_switch_to_new == 'true')
            ? ' checked="checked"'
            : '' . '/>');
    $html_output .= '<label for="checkbox_switch">'
        . __('Switch to copied table') . '</label>'
        . '</fieldset>';

    $html_output .= '<fieldset class="tblFooters">'
        . '<input type="submit" name="submit_copy" value="' . __('Go') . '" />'
        . '</fieldset>'
        . '</form>'
        . '</div>';

    return $html_output;
}

/**
 * Get HTML snippet for table maintenance
 *
 * @param boolean $is_myisam_or_aria whether MYISAM | ARIA or not
 * @param boolean $is_innodb         whether innodb or not
 * @param boolean $is_berkeleydb     whether  berkeleydb or not
 * @param array   $url_params        array of URL parameters
 *
 * @return string $html_output
 */
function PMA_getHtmlForTableMaintenance(
    $is_myisam_or_aria, $is_innodb, $is_berkeleydb, $url_params
) {
    $html_output = '<div class="operations_half_width">';
    $html_output .= '<fieldset>'
        . '<legend>' . __('Table maintenance') . '</legend>';
    $html_output .= '<ul id="tbl_maintenance">';

    // Note: BERKELEY (BDB) is no longer supported, starting with MySQL 5.1
    $html_output .= PMA_getListofMaintainActionLink(
        $is_myisam_or_aria, $is_innodb, $url_params, $is_berkeleydb
    );

    $html_output .= '</ul>'
        . '</fieldset>'
        . '</div>';

    return $html_output;
}

/**
 * Get HTML 'li' having a link of maintain action
 *
 * @param boolean $is_myisam_or_aria whether MYISAM | ARIA or not
 * @param boolean $is_innodb         whether innodb or not
 * @param array   $url_params        array of URL parameters
 * @param boolean $is_berkeleydb     whether  berkeleydb or not
 *
 * @return string $html_output
 */
function PMA_getListofMaintainActionLink($is_myisam_or_aria,
    $is_innodb, $url_params, $is_berkeleydb
) {
    $html_output = '';

    // analyze table
    if ($is_innodb || $is_myisam_or_aria || $is_berkeleydb) {
        $params = array(
            'sql_query' => 'ANALYZE TABLE '
                . PMA\libraries\Util::backquote($GLOBALS['table']),
            'table_maintenance' => 'Go',
        );
        $html_output .= PMA_getMaintainActionlink(
            __('Analyze table'),
            $params,
            $url_params,
            'ANALYZE_TABLE'
        );
    }

    // check table
    if ($is_myisam_or_aria || $is_innodb) {
        $params = array(
            'sql_query' => 'CHECK TABLE '
                . PMA\libraries\Util::backquote($GLOBALS['table']),
            'table_maintenance' => 'Go',
        );
        $html_output .= PMA_getMaintainActionlink(
            __('Check table'),
            $params,
            $url_params,
            'CHECK_TABLE'
        );
    }

    // checksum table
    $params = array(
        'sql_query' => 'CHECKSUM TABLE '
            . Util::backquote($GLOBALS['table']),
        'table_maintenance' => 'Go',
    );
    $html_output .= PMA_getMaintainActionlink(
        __('Checksum table'),
        $params,
        $url_params,
        'CHECKSUM_TABLE'
    );

    // defragment table
    if ($is_innodb) {
        $params = array(
            'sql_query' => 'ALTER TABLE '
            . PMA\libraries\Util::backquote($GLOBALS['table'])
            . ' ENGINE = InnoDB;'
        );
        $html_output .= PMA_getMaintainActionlink(
            __('Defragment table'),
            $params,
            $url_params,
            'InnoDB_File_Defragmenting'
        );
    }

    // flush table
    $params = array(
        'sql_query' => 'FLUSH TABLE '
            . PMA\libraries\Util::backquote($GLOBALS['table']),
        'message_to_show' => sprintf(
            __('Table %s has been flushed.'),
            htmlspecialchars($GLOBALS['table'])
        ),
        'reload' => 1,
    );
    $html_output .= PMA_getMaintainActionlink(
        __('Flush the table (FLUSH)'),
        $params,
        $url_params,
        'FLUSH'
    );

    // optimize table
    if ($is_myisam_or_aria || $is_innodb || $is_berkeleydb) {
        $params = array(
            'sql_query' => 'OPTIMIZE TABLE '
                . PMA\libraries\Util::backquote($GLOBALS['table']),
            'table_maintenance' => 'Go',
        );
        $html_output .= PMA_getMaintainActionlink(
            __('Optimize table'),
            $params,
            $url_params,
            'OPTIMIZE_TABLE'
        );
    }

    // repair table
    if ($is_myisam_or_aria) {
        $params = array(
            'sql_query' => 'REPAIR TABLE '
                . PMA\libraries\Util::backquote($GLOBALS['table']),
            'table_maintenance' => 'Go',
        );
        $html_output .= PMA_getMaintainActionlink(
            __('Repair table'),
            $params,
            $url_params,
            'REPAIR_TABLE'
        );
    }

    return $html_output;
}

/**
 * Get maintain action HTML link
 *
 * @param string $action_message action message
 * @param array  $params         url parameters array
 * @param array  $url_params     additional url parameters
 * @param string $link           contains name of page/anchor that is being linked
 *
 * @return string $html_output
 */
function PMA_getMaintainActionlink($action_message, $params, $url_params, $link)
{
    return '<li>'
        . '<a class="maintain_action ajax" '
        . 'href="sql.php'
        . PMA_URL_getCommon(array_merge($url_params, $params)) . '">'
        . $action_message
        . '</a>'
        . PMA\libraries\Util::showMySQLDocu($link)
        . '</li>';
}

/**
 * Get HTML for Delete data or table (truncate table, drop table)
 *
 * @param array $truncate_table_url_params url parameter array for truncate table
 * @param array $dropTableUrlParams        url parameter array for drop table
 *
 * @return string $html_output
 */
function PMA_getHtmlForDeleteDataOrTable(
    $truncate_table_url_params,
    $dropTableUrlParams
) {
    $html_output = '<div class="operations_half_width">'
        . '<fieldset class="caution">'
        . '<legend>' . __('Delete data or table') . '</legend>';

    $html_output .= '<ul>';

    if (! empty($truncate_table_url_params)) {
        $html_output .= PMA_getDeleteDataOrTablelink(
            $truncate_table_url_params,
            'TRUNCATE_TABLE',
            __('Empty the table (TRUNCATE)'),
            'truncate_tbl_anchor'
        );
    }
    if (!empty($dropTableUrlParams)) {
        $html_output .= PMA_getDeleteDataOrTablelink(
            $dropTableUrlParams,
            'DROP_TABLE',
            __('Delete the table (DROP)'),
            'drop_tbl_anchor'
        );
    }
    $html_output .= '</ul></fieldset></div>';

    return $html_output;
}

/**
 * Get the HTML link for Truncate table, Drop table and Drop db
 *
 * @param array  $url_params url parameter array for delete data or table
 * @param string $syntax     TRUNCATE_TABLE or DROP_TABLE or DROP_DATABASE
 * @param string $link       link to be shown
 * @param string $htmlId     id of the link
 *
 * @return String html output
 */
function PMA_getDeleteDataOrTablelink($url_params, $syntax, $link, $htmlId)
{
    return  '<li><a '
        . 'href="sql.php' . PMA_URL_getCommon($url_params) . '"'
        . ' id="' . $htmlId . '" class="ajax">'
        . $link . '</a>'
        . PMA\libraries\Util::showMySQLDocu($syntax)
        . '</li>';
}

/**
 * Get HTML snippet for partition maintenance
 *
 * @param array $partition_names array of partition names for a specific db/table
 * @param array $url_params      url parameters
 *
 * @return string $html_output
 */
function PMA_getHtmlForPartitionMaintenance($partition_names, $url_params)
{
    $choices = array(
        'ANALYZE' => __('Analyze'),
        'CHECK' => __('Check'),
        'OPTIMIZE' => __('Optimize'),
        'REBUILD' => __('Rebuild'),
        'REPAIR' => __('Repair'),
        'TRUNCATE' => __('Truncate')
    );

    $partition_method = Partition::getPartitionMethod(
        $GLOBALS['db'], $GLOBALS['table']
    );
    // add COALESCE or DROP option to choices array depeding on Partition method
    if ($partition_method == 'RANGE'
        || $partition_method == 'RANGE COLUMNS'
        || $partition_method == 'LIST'
        || $partition_method == 'LIST COLUMNS'
    ) {
        $choices['DROP'] = __('Drop');
    } else {
        $choices['COALESCE'] = __('Coalesce');
    }

    $html_output = '<div class="operations_half_width">'
        . '<form id="partitionsForm" class="ajax" '
        . 'method="post" action="tbl_operations.php" >'
        . PMA_URL_getHiddenInputs($GLOBALS['db'], $GLOBALS['table'])
        . '<fieldset>'
        . '<legend>'
        . __('Partition maintenance')
        . PMA\libraries\Util::showMySQLDocu('partitioning_maintenance')
        . '</legend>';

    $html_select = '<select id="partition_name" name="partition_name[]"'
        . ' multiple="multiple" required="required">' . "\n";
    $first = true;
    foreach ($partition_names as $one_partition) {
        $one_partition = htmlspecialchars($one_partition);
        $html_select .= '<option value="' . $one_partition . '"';
        if ($first) {
            $html_select .= ' selected="selected"';
            $first = false;
        }
        $html_select .=  '>' . $one_partition . '</option>' . "\n";
    }
    $html_select .= '</select>' . "\n";
    $html_output .= sprintf(__('Partition %s'), $html_select);

    $html_output .= '<div class="clearfloat" />';
    $html_output .= PMA\libraries\Util::getRadioFields(
        'partition_operation', $choices, 'ANALYZE', false, true, 'floatleft'
    );
    $this_url_params = array_merge(
        $url_params,
        array(
            'sql_query' => 'ALTER TABLE '
            . PMA\libraries\Util::backquote($GLOBALS['table'])
            . ' REMOVE PARTITIONING;'
        )
    );
    $html_output .= '<div class="clearfloat" /><br />';

    $html_output .= '<a href="sql.php'
        . PMA_URL_getCommon($this_url_params) . '">'
        . __('Remove partitioning') . '</a>';

    $html_output .= '</fieldset>'
        . '<fieldset class="tblFooters">'
        . '<input type="hidden" name="submit_partition" value="1">'
        . '<input type="submit" value="' . __('Go') . '" />'
        . '</fieldset>'
        . '</form>'
        . '</div>';

    return $html_output;
}

/**
 * Get the HTML for Referential Integrity check
 *
 * @param array $foreign    all Relations to foreign tables for a given table
 *                          or optionally a given column in a table
 * @param array $url_params array of url parameters
 *
 * @return string $html_output
 */
function PMA_getHtmlForReferentialIntegrityCheck($foreign, $url_params)
{
    $html_output = '<div class="operations_half_width">'
        . '<fieldset>'
        . '<legend>' . __('Check referential integrity:') . '</legend>';

    $html_output .= '<ul>';

    foreach ($foreign as $master => $arr) {
        $join_query  = 'SELECT '
            . PMA\libraries\Util::backquote($GLOBALS['table']) . '.*'
            . ' FROM ' . PMA\libraries\Util::backquote($GLOBALS['table'])
            . ' LEFT JOIN '
            . PMA\libraries\Util::backquote($arr['foreign_db'])
            . '.'
            . PMA\libraries\Util::backquote($arr['foreign_table']);
        if ($arr['foreign_table'] == $GLOBALS['table']) {
            $foreign_table = $GLOBALS['table'] . '1';
            $join_query .= ' AS ' . PMA\libraries\Util::backquote($foreign_table);
        } else {
            $foreign_table = $arr['foreign_table'];
        }
        $join_query .= ' ON '
            . PMA\libraries\Util::backquote($GLOBALS['table']) . '.'
            . PMA\libraries\Util::backquote($master)
            . ' = '
            . PMA\libraries\Util::backquote($arr['foreign_db'])
            . '.'
            . PMA\libraries\Util::backquote($foreign_table) . '.'
            . PMA\libraries\Util::backquote($arr['foreign_field'])
            . ' WHERE '
            . PMA\libraries\Util::backquote($arr['foreign_db'])
            . '.'
            . PMA\libraries\Util::backquote($foreign_table) . '.'
            . PMA\libraries\Util::backquote($arr['foreign_field'])
            . ' IS NULL AND '
            . PMA\libraries\Util::backquote($GLOBALS['table']) . '.'
            . PMA\libraries\Util::backquote($master)
            . ' IS NOT NULL';
        $this_url_params = array_merge(
            $url_params,
            array('sql_query' => $join_query)
        );

        $html_output .= '<li>'
            . '<a href="sql.php'
            . PMA_URL_getCommon($this_url_params)
            . '">'
            . $master . '&nbsp;->&nbsp;' . $arr['foreign_db'] . '.'
            . $arr['foreign_table'] . '.' . $arr['foreign_field']
            . '</a></li>' . "\n";
    } //  foreach $foreign
    $html_output .= '</ul></fieldset></div>';

    return $html_output;
}

/**
 * Reorder table based on request params
 *
 * @return array SQL query and result
 */
function PMA_getQueryAndResultForReorderingTable()
{
    $sql_query = 'ALTER TABLE '
        . PMA\libraries\Util::backquote($GLOBALS['table'])
        . ' ORDER BY '
        . PMA\libraries\Util::backquote(urldecode($_REQUEST['order_field']));
    if (isset($_REQUEST['order_order'])
        && $_REQUEST['order_order'] === 'desc'
    ) {
        $sql_query .= ' DESC';
    }
    $sql_query .= ';';
    $result = $GLOBALS['dbi']->query($sql_query);

    return array($sql_query, $result);
}

/**
 * Get table alters array
 *
 * @param boolean $is_myisam_or_aria   whether MYISAM | ARIA or not
 * @param boolean $is_isam             whether ISAM or not
 * @param string  $pack_keys           pack keys
 * @param string  $checksum            value of checksum
 * @param boolean $is_aria             whether ARIA or not
 * @param string  $page_checksum       value of page checksum
 * @param string  $delay_key_write     delay key write
 * @param boolean $is_innodb           whether INNODB or not
 * @param boolean $is_pbxt             whether PBXT or not
 * @param string  $row_format          row format
 * @param string  $newTblStorageEngine table storage engine
 * @param string  $transactional       value of transactional
 * @param string  $tbl_collation       collation of the table
 *
 * @return array  $table_alters
 */
function PMA_getTableAltersArray($is_myisam_or_aria, $is_isam, $pack_keys,
    $checksum, $is_aria, $page_checksum, $delay_key_write, $is_innodb,
    $is_pbxt, $row_format, $newTblStorageEngine, $transactional, $tbl_collation
) {
    global $auto_increment;

    $table_alters = array();

    if (isset($_REQUEST['comment'])
        && urldecode($_REQUEST['prev_comment']) !== $_REQUEST['comment']
    ) {
        $table_alters[] = 'COMMENT = \''
            . $GLOBALS['dbi']->escapeString($_REQUEST['comment']) . '\'';
    }

    if (! empty($newTblStorageEngine)
        && mb_strtolower($newTblStorageEngine) !== mb_strtolower($GLOBALS['tbl_storage_engine'])
    ) {
        $table_alters[] = 'ENGINE = ' . $newTblStorageEngine;
    }
    if (! empty($_REQUEST['tbl_collation'])
        && $_REQUEST['tbl_collation'] !== $tbl_collation
    ) {
        $table_alters[] = 'DEFAULT '
            . PMA_generateCharsetQueryPart($_REQUEST['tbl_collation']);
    }

    if (($is_myisam_or_aria || $is_isam)
        && isset($_REQUEST['new_pack_keys'])
        && $_REQUEST['new_pack_keys'] != (string)$pack_keys
    ) {
        $table_alters[] = 'pack_keys = ' . $_REQUEST['new_pack_keys'];
    }

    $_REQUEST['new_checksum'] = empty($_REQUEST['new_checksum']) ? '0' : '1';
    if ($is_myisam_or_aria
        && $_REQUEST['new_checksum'] !== $checksum
    ) {
        $table_alters[] = 'checksum = ' . $_REQUEST['new_checksum'];
    }

    $_REQUEST['new_transactional']
        = empty($_REQUEST['new_transactional']) ? '0' : '1';
    if ($is_aria
        && $_REQUEST['new_transactional'] !== $transactional
    ) {
        $table_alters[] = 'TRANSACTIONAL = ' . $_REQUEST['new_transactional'];
    }

    $_REQUEST['new_page_checksum']
        = empty($_REQUEST['new_page_checksum']) ? '0' : '1';
    if ($is_aria
        && $_REQUEST['new_page_checksum'] !== $page_checksum
    ) {
        $table_alters[] = 'PAGE_CHECKSUM = ' . $_REQUEST['new_page_checksum'];
    }

    $_REQUEST['new_delay_key_write']
        = empty($_REQUEST['new_delay_key_write']) ? '0' : '1';
    if ($is_myisam_or_aria
        && $_REQUEST['new_delay_key_write'] !== $delay_key_write
    ) {
        $table_alters[] = 'delay_key_write = ' . $_REQUEST['new_delay_key_write'];
    }

    if (($is_myisam_or_aria || $is_innodb || $is_pbxt)
        && ! empty($_REQUEST['new_auto_increment'])
        && (! isset($auto_increment)
        || $_REQUEST['new_auto_increment'] !== $auto_increment)
    ) {
        $table_alters[] = 'auto_increment = '
            . $GLOBALS['dbi']->escapeString($_REQUEST['new_auto_increment']);
    }

    if (! empty($_REQUEST['new_row_format'])) {
        $newRowFormat = $_REQUEST['new_row_format'];
        $newRowFormatLower = mb_strtolower($newRowFormat);
        if (($is_myisam_or_aria || $is_innodb || $is_pbxt)
            && (!mb_strlen($row_format)
            || $newRowFormatLower !== mb_strtolower($row_format))
        ) {
            $table_alters[] = 'ROW_FORMAT = '
                . $GLOBALS['dbi']->escapeString($newRowFormat);
        }
    }

    return $table_alters;
}

/**
 * set initial value of the set of variables, based on the current table engine
 *
 * @param string $tbl_storage_engine table storage engine in upper case
 *
 * @return array ($is_myisam_or_aria, $is_innodb, $is_isam,
 *                $is_berkeleydb, $is_aria, $is_pbxt)
 */
function PMA_setGlobalVariablesForEngine($tbl_storage_engine)
{
    //Options that apply to MYISAM usually apply to ARIA
    $is_myisam_or_aria = ($tbl_storage_engine == 'MYISAM'
        || $tbl_storage_engine == 'ARIA'
        || $tbl_storage_engine == 'MARIA'
    );
    $is_aria = ($tbl_storage_engine == 'ARIA');

    $is_isam = ($tbl_storage_engine == 'ISAM');
    $is_innodb = ($tbl_storage_engine == 'INNODB');
    $is_berkeleydb = ($tbl_storage_engine == 'BERKELEYDB');
    $is_pbxt = ($tbl_storage_engine == 'PBXT');

    return array(
        $is_myisam_or_aria, $is_innodb, $is_isam,
        $is_berkeleydb, $is_aria, $is_pbxt
    );
}

/**
 * Get warning messages array
 *
 * @return array  $warning_messages
 */
function PMA_getWarningMessagesArray()
{
    $warning_messages = array();
    foreach ($GLOBALS['dbi']->getWarnings() as $warning) {
        // In MariaDB 5.1.44, when altering a table from Maria to MyISAM
        // and if TRANSACTIONAL was set, the system reports an error;
        // I discussed with a Maria developer and he agrees that this
        // should not be reported with a Level of Error, so here
        // I just ignore it. But there are other 1478 messages
        // that it's better to show.
        if (! ($_REQUEST['new_tbl_storage_engine'] == 'MyISAM'
            && $warning['Code'] == '1478'
            && $warning['Level'] == 'Error')
        ) {
            $warning_messages[] = $warning['Level'] . ': #' . $warning['Code']
                . ' ' . $warning['Message'];
        }
    }
    return $warning_messages;
}

/**
 * Get SQL query and result after ran this SQL query for a partition operation
 * has been requested by the user
 *
 * @return array $sql_query, $result
 */
function PMA_getQueryAndResultForPartition()
{
    $sql_query = 'ALTER TABLE '
        . PMA\libraries\Util::backquote($GLOBALS['table']) . ' '
        . $_REQUEST['partition_operation']
        . ' PARTITION ';

    if ($_REQUEST['partition_operation'] == 'COALESCE') {
        $sql_query .= count($_REQUEST['partition_name']);
    } else {
        $sql_query .= implode(', ', $_REQUEST['partition_name']) . ';';
    }

    $result = $GLOBALS['dbi']->query($sql_query);

    return array($sql_query, $result);
}

/**
 * Adjust the privileges after renaming/moving a table
 *
 * @param string $oldDb    Database name before table renaming/moving table
 * @param string $oldTable Table name before table renaming/moving table
 * @param string $newDb    Database name after table renaming/ moving table
 * @param string $newTable Table name after table renaming/moving table
 *
 * @return void
 */
function PMA_AdjustPrivileges_renameOrMoveTable($oldDb, $oldTable, $newDb, $newTable)
{
    if ($GLOBALS['table_priv'] && $GLOBALS['col_priv']
        && $GLOBALS['is_reload_priv']
    ) {
        $GLOBALS['dbi']->selectDb('mysql');

        // For table specific privileges
        $query_table_specific = 'UPDATE ' . Util::backquote('tables_priv')
            . 'SET Db = \'' . $GLOBALS['dbi']->escapeString($newDb) . '\', Table_name = \'' . $GLOBALS['dbi']->escapeString($newTable)
            . '\' where Db = \'' . $GLOBALS['dbi']->escapeString($oldDb) . '\' AND Table_name = \'' . $GLOBALS['dbi']->escapeString($oldTable)
            . '\';';
        $GLOBALS['dbi']->query($query_table_specific);

        // For column specific privileges
        $query_col_specific = 'UPDATE ' . Util::backquote('columns_priv')
            . 'SET Db = \'' . $GLOBALS['dbi']->escapeString($newDb) . '\', Table_name = \'' . $GLOBALS['dbi']->escapeString($newTable)
            . '\' where Db = \'' . $GLOBALS['dbi']->escapeString($oldDb) . '\' AND Table_name = \'' . $GLOBALS['dbi']->escapeString($oldTable)
            . '\';';
        $GLOBALS['dbi']->query($query_col_specific);

        // Finally FLUSH the new privileges
        $flush_query = "FLUSH PRIVILEGES;";
        $GLOBALS['dbi']->query($flush_query);
    }
}

/**
 * Adjust the privileges after copying a table
 *
 * @param string $oldDb    Database name before table copying
 * @param string $oldTable Table name before table copying
 * @param string $newDb    Database name after table copying
 * @param string $newTable Table name after table copying
 *
 * @return void
 */
function PMA_AdjustPrivileges_copyTable($oldDb, $oldTable, $newDb, $newTable)
{
    if ($GLOBALS['table_priv'] && $GLOBALS['col_priv']
        && $GLOBALS['is_reload_priv']
    ) {
        $GLOBALS['dbi']->selectDb('mysql');

        // For Table Specific privileges
        $query_table_specific_old = 'SELECT * FROM '
            . Util::backquote('tables_priv') . ' where '
            . 'Db = "' . $oldDb . '" AND Table_name = "' . $oldTable . '";';

        $old_privs_table = $GLOBALS['dbi']->fetchResult(
            $query_table_specific_old,
            0
        );

        foreach ($old_privs_table as $old_priv) {
            $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] . '");';

            $GLOBALS['dbi']->query($newDb_table_privs_query);
        }

        // For Column Specific privileges
        $query_col_specific_old = 'SELECT * FROM '
            . Util::backquote('columns_priv') . ' WHERE '
            . 'Db = "' . $oldDb . '" AND Table_name = "' . $oldTable . '";';

        $old_privs_col = $GLOBALS['dbi']->fetchResult(
            $query_col_specific_old,
            0
        );

        foreach ($old_privs_col as $old_priv) {
            $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] . '");';

            $GLOBALS['dbi']->query($newDb_col_privs_query);
        }

        // Finally FLUSH the new privileges
        $flush_query = "FLUSH PRIVILEGES;";
        $GLOBALS['dbi']->query($flush_query);
    }
}

/**
 * Change all collations and character sets of all columns in table
 *
 * @param string $db            Database name
 * @param string $table         Table name
 * @param string $tbl_collation Collation Name
 *
 * @return void
 */
function PMA_changeAllColumnsCollation($db, $table, $tbl_collation)
{
    $GLOBALS['dbi']->selectDb($db);

    $change_all_collations_query = 'ALTER TABLE '
        . PMA\libraries\Util::backquote($table)
        . ' CONVERT TO';

    list($charset) = explode('_', $tbl_collation);

    $change_all_collations_query .= ' CHARACTER SET ' . $charset
        . ($charset == $tbl_collation ? '' : ' COLLATE ' . $tbl_collation);

    $GLOBALS['dbi']->query($change_all_collations_query);
}

/**
 * Move or copy a table
 *
 * @param string $db    current database name
 * @param string $table current table name
 *
 * @return void
 */
function PMA_moveOrCopyTable($db, $table)
{
    /**
     * Selects the database to work with
     */
    $GLOBALS['dbi']->selectDb($db);

    /**
     * $_REQUEST['target_db'] could be empty in case we came from an input field
     * (when there are many databases, no drop-down)
     */
    if (empty($_REQUEST['target_db'])) {
        $_REQUEST['target_db'] = $db;
    }

    /**
     * A target table name has been sent to this script -> do the work
     */
    if (PMA_isValid($_REQUEST['new_name'])) {
        if ($db == $_REQUEST['target_db'] && $table == $_REQUEST['new_name']) {
            if (isset($_REQUEST['submit_move'])) {
                $message = Message::error(__('Can\'t move table to same one!'));
            } else {
                $message = Message::error(__('Can\'t copy table to same one!'));
            }
        } else {
            Table::moveCopy(
                $db, $table, $_REQUEST['target_db'], $_REQUEST['new_name'],
                $_REQUEST['what'], isset($_REQUEST['submit_move']), 'one_table'
            );

            if (isset($_REQUEST['adjust_privileges'])
                && ! empty($_REQUEST['adjust_privileges'])
            ) {
                if (isset($_REQUEST['submit_move'])) {
                    PMA_AdjustPrivileges_renameOrMoveTable(
                        $db, $table, $_REQUEST['target_db'], $_REQUEST['new_name']
                    );
                } else {
                    PMA_AdjustPrivileges_copyTable(
                        $db, $table, $_REQUEST['target_db'], $_REQUEST['new_name']
                    );
                }

                if (isset($_REQUEST['submit_move'])) {
                    $message = Message::success(
                        __(
                            'Table %s has been moved to %s. Privileges have been '
                            . 'adjusted.'
                        )
                    );
                } else {
                    $message = Message::success(
                        __(
                            'Table %s has been copied to %s. Privileges have been '
                            . 'adjusted.'
                        )
                    );
                }

            } else {
                if (isset($_REQUEST['submit_move'])) {
                    $message = Message::success(
                        __('Table %s has been moved to %s.')
                    );
                } else {
                    $message = Message::success(
                        __('Table %s has been copied to %s.')
                    );
                }
            }

            $old = PMA\libraries\Util::backquote($db) . '.'
                . PMA\libraries\Util::backquote($table);
            $message->addParam($old);
            $new = PMA\libraries\Util::backquote($_REQUEST['target_db']) . '.'
                . PMA\libraries\Util::backquote($_REQUEST['new_name']);
            $message->addParam($new);

            /* Check: Work on new table or on old table? */
            if (isset($_REQUEST['submit_move'])
                || PMA_isValid($_REQUEST['switch_to_new'])
            ) {
            }
        }
    } else {
        /**
         * No new name for the table!
         */
        $message = Message::error(__('The table name is empty!'));
    }

    if ($GLOBALS['is_ajax_request'] == true) {
        $response = PMA\libraries\Response::getInstance();
        $response->addJSON('message', $message);
        if ($message->isSuccess()) {
            $response->addJSON('db', $GLOBALS['db']);
        } else {
            $response->setRequestStatus(false);
        }
        exit;
    }
}

Filemanager

Name Type Size Permission Actions
bfShapeFiles Folder 0755
config Folder 0755
controllers Folder 0755
dbi Folder 0755
di Folder 0755
engines Folder 0755
gis Folder 0755
navigation Folder 0755
plugins Folder 0755
properties Folder 0755
rte Folder 0755
sql-parser Folder 0755
Advisor.php File 15.13 KB 0644
Config.php File 54.7 KB 0644
Console.php File 14.82 KB 0644
DatabaseInterface.php File 95.6 KB 0644
DbList.php File 1.9 KB 0644
DbQbe.php File 68.87 KB 0644
DbSearch.php File 17.21 KB 0644
DisplayResults.php File 206 KB 0644
Error.php File 12.7 KB 0644
ErrorHandler.php File 16.48 KB 0644
File.php File 18.82 KB 0644
Font.php File 4.24 KB 0644
Footer.php File 10.52 KB 0644
Header.php File 25.34 KB 0644
Index.php File 23.79 KB 0644
IndexColumn.php File 4.46 KB 0644
Language.php File 4.27 KB 0644
LanguageManager.php File 20.75 KB 0644
Linter.php File 5.02 KB 0644
ListAbstract.php File 3.15 KB 0644
ListDatabase.php File 4.62 KB 0644
Menu.php File 21.14 KB 0644
Message.php File 18.67 KB 0644
OutputBuffering.php File 3.59 KB 0644
PDF.php File 3.94 KB 0644
Partition.php File 7.26 KB 0644
Psr4Autoloader.php File 4.85 KB 0644
RecentFavoriteTable.php File 11.78 KB 0644
Response.php File 12.61 KB 0644
SavedSearches.php File 11.67 KB 0644
Scripts.php File 7.38 KB 0644
ServerStatusData.php File 15.72 KB 0644
StorageEngine.php File 13.61 KB 0644
SubPartition.php File 3.52 KB 0644
SysInfo.php File 799 B 0644
SysInfoLinux.php File 1.92 KB 0644
SysInfoSunOS.php File 1.86 KB 0644
SysInfoWINNT.php File 3.08 KB 0644
SystemDatabase.php File 3.66 KB 0644
Table.php File 88.12 KB 0644
Template.php File 4.45 KB 0644
Theme.php File 11.34 KB 0644
ThemeManager.php File 12.91 KB 0644
Tracker.php File 30.35 KB 0644
Types.php File 6.08 KB 0644
TypesMySQL.php File 17.26 KB 0644
Util.php File 172.46 KB 0644
VersionInformation.php File 7.87 KB 0644
ZipFile.php File 6.63 KB 0644
advisor.lib.php File 1.6 KB 0644
advisory_rules.txt File 25.94 KB 0644
autoloader.php File 450 B 0644
bookmark.lib.php File 8.5 KB 0644
browse_foreigners.lib.php File 9.83 KB 0644
central_columns.lib.php File 49.38 KB 0644
charset_conversion.lib.php File 3.54 KB 0644
check_user_privileges.lib.php File 10.65 KB 0644
cleanup.lib.php File 1.29 KB 0644
common.inc.php File 34.38 KB 0644
config.default.php File 66.5 KB 0644
config.values.php File 10.17 KB 0644
core.lib.php File 29.94 KB 0644
create_addfield.lib.php File 15.68 KB 0644
database_interface.inc.php File 2.63 KB 0644
db_common.inc.php File 3.12 KB 0644
db_designer.lib.php File 10.4 KB 0644
db_table_exists.lib.php File 3.21 KB 0644
display_change_password.lib.php File 5.45 KB 0644
display_create_table.lib.php File 1.53 KB 0644
display_export.lib.php File 38.11 KB 0644
display_git_revision.lib.php File 3.04 KB 0644
display_import.lib.php File 24.34 KB 0644
display_import_ajax.lib.php File 3.13 KB 0644
display_select_lang.lib.php File 2.36 KB 0644
error.inc.php File 1.21 KB 0644
error_report.lib.php File 10.25 KB 0644
export.lib.php File 35.16 KB 0644
file_listing.lib.php File 2.37 KB 0644
iconv_wrapper.lib.php File 3.88 KB 0644
import.lib.php File 50.64 KB 0644
index.lib.php File 1.37 KB 0644
information_schema_relations.lib.php File 10.95 KB 0644
insert_edit.lib.php File 112.79 KB 0644
ip_allow_deny.lib.php File 9.35 KB 0644
js_escape.lib.php File 4.43 KB 0644
kanji-encoding.lib.php File 4.46 KB 0644
language_stats.inc.php File 1.45 KB 0644
logging.lib.php File 521 B 0644
mime.lib.php File 704 B 0644
mult_submits.inc.php File 10.64 KB 0644
mult_submits.lib.php File 20.44 KB 0644
mysql_charsets.inc.php File 4.09 KB 0644
mysql_charsets.lib.php File 10.47 KB 0644
mysql_relations.lib.php File 5.12 KB 0644
normalization.lib.php File 33.98 KB 0644
opendocument.lib.php File 7.94 KB 0644
operations.lib.php File 73.64 KB 0644
parse_analyze.lib.php File 2.12 KB 0644
plugin_interface.lib.php File 19.69 KB 0644
plugin_interface.lib.php.bak File 19.69 KB 0644
pmd_common.php File 24.2 KB 0644
relation.lib.php File 68.41 KB 0644
relation_cleanup.lib.php File 13.84 KB 0644
replication.inc.php File 8.82 KB 0644
replication_gui.lib.php File 37.45 KB 0644
sanitizing.lib.php File 6.3 KB 0644
select_server.lib.php File 3.4 KB 0644
server_common.inc.php File 1.22 KB 0644
server_common.lib.php File 1.92 KB 0644
server_privileges.lib.php File 179.22 KB 0644
server_status.lib.php File 9.92 KB 0644
server_status_advisor.lib.php File 1.89 KB 0644
server_status_monitor.lib.php File 26.22 KB 0644
server_status_processes.lib.php File 9.57 KB 0644
server_status_queries.lib.php File 4.86 KB 0644
server_status_variables.lib.php File 28.95 KB 0644
server_user_groups.lib.php File 12.8 KB 0644
server_users.lib.php File 1.35 KB 0644
session.inc.php File 5.22 KB 0644
session.lib.php File 735 B 0644
special_schema_links.lib.php File 17.51 KB 0644
sql.lib.php File 77.51 KB 0644
sql.lib.php.bak File 77.51 KB 0644
sql_query_form.lib.php File 15.71 KB 0644
string.lib.php File 800 B 0644
stringMb.lib.php File 1.86 KB 0644
stringNative.lib.php File 6.82 KB 0644
sysinfo.lib.php File 1.34 KB 0644
tbl_columns_definition_form.inc.php File 13.55 KB 0644
tbl_common.inc.php File 1.3 KB 0644
tbl_info.inc.php File 3.54 KB 0644
tbl_partition_definition.inc.php File 5.55 KB 0644
tracking.lib.php File 54.93 KB 0644
transformations.lib.php File 14.63 KB 0644
url_generating.lib.php File 6.77 KB 0644
user_preferences.inc.php File 2.38 KB 0644
user_preferences.lib.php File 8.17 KB 0644
util.lib.php File 749 B 0644
vendor_config.php File 2.49 KB 0644
zip_extension.lib.php File 5.38 KB 0644