phpmyadmin working

1 files changed, 1014 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/js/export.js b/srcs/phpmyadmin/js/export.js
new file mode 100644
index 0000000..db625e7
--- /dev/null
+++ b/srcs/phpmyadmin/js/export.js
@@ -0,0 +1,1014 @@
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Functions used in the export tab
+ *
+ */
+
+var Export = {};
+
+/**
+ * Disables the "Dump some row(s)" sub-options
+ */
+Export.disableDumpSomeRowsSubOptions = function () {
+    $('label[for=\'limit_to\']').fadeTo('fast', 0.4);
+    $('label[for=\'limit_from\']').fadeTo('fast', 0.4);
+    $('input[type=\'text\'][name=\'limit_to\']').prop('disabled', 'disabled');
+    $('input[type=\'text\'][name=\'limit_from\']').prop('disabled', 'disabled');
+};
+
+/**
+ * Enables the "Dump some row(s)" sub-options
+ */
+Export.enableDumpSomeRowsSubOptions = function () {
+    $('label[for=\'limit_to\']').fadeTo('fast', 1);
+    $('label[for=\'limit_from\']').fadeTo('fast', 1);
+    $('input[type=\'text\'][name=\'limit_to\']').prop('disabled', '');
+    $('input[type=\'text\'][name=\'limit_from\']').prop('disabled', '');
+};
+
+/**
+ * Return template data as a json object
+ *
+ * @returns template data
+ */
+Export.getTemplateData = function () {
+    var $form = $('form[name="dump"]');
+    var blacklist = ['token', 'server', 'db', 'table', 'single_table',
+        'export_type', 'export_method', 'sql_query', 'template_id'];
+    var obj = {};
+    var arr = $form.serializeArray();
+    $.each(arr, function () {
+        if ($.inArray(this.name, blacklist) < 0) {
+            if (obj[this.name] !== undefined) {
+                if (! obj[this.name].push) {
+                    obj[this.name] = [obj[this.name]];
+                }
+                obj[this.name].push(this.value || '');
+            } else {
+                obj[this.name] = this.value || '';
+            }
+        }
+    });
+    // include unchecked checboxes (which are ignored by serializeArray()) with null
+    // to uncheck them when loading the template
+    $form.find('input[type="checkbox"]:not(:checked)').each(function () {
+        if (obj[this.name] === undefined) {
+            obj[this.name] = null;
+        }
+    });
+    // include empty multiselects
+    $form.find('select').each(function () {
+        if ($(this).find('option:selected').length === 0) {
+            obj[this.name] = [];
+        }
+    });
+    return obj;
+};
+
+/**
+ * Create a template with selected options
+ *
+ * @param name name of the template
+ */
+Export.createTemplate = function (name) {
+    var templateData = Export.getTemplateData();
+
+    var params = {
+        'ajax_request': true,
+        'server': CommonParams.get('server'),
+        'db': CommonParams.get('db'),
+        'table': CommonParams.get('table'),
+        'exportType': $('input[name="export_type"]').val(),
+        'templateAction': 'create',
+        'templateName': name,
+        'templateData': JSON.stringify(templateData)
+    };
+
+    Functions.ajaxShowMessage();
+    $.post('tbl_export.php', params, function (response) {
+        if (response.success === true) {
+            $('#templateName').val('');
+            $('#template').html(response.data);
+            $('#template').find('option').each(function () {
+                if ($(this).text() === name) {
+                    $(this).prop('selected', true);
+                }
+            });
+            Functions.ajaxShowMessage(Messages.strTemplateCreated);
+        } else {
+            Functions.ajaxShowMessage(response.error, false);
+        }
+    });
+};
+
+/**
+ * Loads a template
+ *
+ * @param id ID of the template to load
+ */
+Export.loadTemplate = function (id) {
+    var params = {
+        'ajax_request': true,
+        'server': CommonParams.get('server'),
+        'db': CommonParams.get('db'),
+        'table': CommonParams.get('table'),
+        'exportType': $('input[name="export_type"]').val(),
+        'templateAction': 'load',
+        'templateId': id,
+    };
+
+    Functions.ajaxShowMessage();
+    $.post('tbl_export.php', params, function (response) {
+        if (response.success === true) {
+            var $form = $('form[name="dump"]');
+            var options = JSON.parse(response.data);
+            $.each(options, function (key, value) {
+                var localValue = value;
+                var $element = $form.find('[name="' + key + '"]');
+                if ($element.length) {
+                    if (($element.is('input') && $element.attr('type') === 'checkbox') && localValue === null) {
+                        $element.prop('checked', false);
+                    } else {
+                        if (($element.is('input') && $element.attr('type') === 'checkbox') ||
+                            ($element.is('input') && $element.attr('type') === 'radio') ||
+                            ($element.is('select') && $element.attr('multiple') === 'multiple')) {
+                            if (! localValue.push) {
+                                localValue = [localValue];
+                            }
+                        }
+                        $element.val(localValue);
+                    }
+                    $element.trigger('change');
+                }
+            });
+            $('input[name="template_id"]').val(id);
+            Functions.ajaxShowMessage(Messages.strTemplateLoaded);
+        } else {
+            Functions.ajaxShowMessage(response.error, false);
+        }
+    });
+};
+
+/**
+ * Updates an existing template with current options
+ *
+ * @param id ID of the template to update
+ */
+Export.updateTemplate = function (id) {
+    var templateData = Export.getTemplateData();
+
+    var params = {
+        'ajax_request': true,
+        'server': CommonParams.get('server'),
+        'db': CommonParams.get('db'),
+        'table': CommonParams.get('table'),
+        'exportType': $('input[name="export_type"]').val(),
+        'templateAction': 'update',
+        'templateId': id,
+        'templateData': JSON.stringify(templateData)
+    };
+
+    Functions.ajaxShowMessage();
+    $.post('tbl_export.php', params, function (response) {
+        if (response.success === true) {
+            Functions.ajaxShowMessage(Messages.strTemplateUpdated);
+        } else {
+            Functions.ajaxShowMessage(response.error, false);
+        }
+    });
+};
+
+/**
+ * Delete a template
+ *
+ * @param id ID of the template to delete
+ */
+Export.deleteTemplate = function (id) {
+    var params = {
+        'ajax_request': true,
+        'server': CommonParams.get('server'),
+        'db': CommonParams.get('db'),
+        'table': CommonParams.get('table'),
+        'exportType': $('input[name="export_type"]').val(),
+        'templateAction': 'delete',
+        'templateId': id,
+    };
+
+    Functions.ajaxShowMessage();
+    $.post('tbl_export.php', params, function (response) {
+        if (response.success === true) {
+            $('#template').find('option[value="' + id + '"]').remove();
+            Functions.ajaxShowMessage(Messages.strTemplateDeleted);
+        } else {
+            Functions.ajaxShowMessage(response.error, false);
+        }
+    });
+};
+
+/**
+ * Unbind all event handlers before tearing down a page
+ */
+AJAX.registerTeardown('export.js', function () {
+    $('#plugins').off('change');
+    $('input[type=\'radio\'][name=\'sql_structure_or_data\']').off('change');
+    $('input[type=\'radio\'][name$=\'_structure_or_data\']').off('change');
+    $('input[type=\'radio\'][name=\'output_format\']').off('change');
+    $('#checkbox_sql_include_comments').off('change');
+    $('input[type=\'radio\'][name=\'quick_or_custom\']').off('change');
+    $('input[type=\'radio\'][name=\'allrows\']').off('change');
+    $('#btn_alias_config').off('click');
+    $('.alias_remove').off('click');
+    $('#db_alias_button').off('click');
+    $('#table_alias_button').off('click');
+    $('#column_alias_button').off('click');
+    $('input[name="table_select[]"]').off('change');
+    $('input[name="table_structure[]"]').off('change');
+    $('input[name="table_data[]"]').off('change');
+    $('#table_structure_all').off('change');
+    $('#table_data_all').off('change');
+    $('input[name="createTemplate"]').off('click');
+    $('select[name="template"]').off('change');
+    $('input[name="updateTemplate"]').off('click');
+    $('input[name="deleteTemplate"]').off('click');
+});
+
+AJAX.registerOnload('export.js', function () {
+    /**
+     * Export template handling code
+     */
+    // create a new template
+    $('input[name="createTemplate"]').on('click', function (e) {
+        e.preventDefault();
+        var name = $('input[name="templateName"]').val();
+        if (name.length) {
+            Export.createTemplate(name);
+        }
+    });
+
+    // load an existing template
+    $('select[name="template"]').on('change', function (e) {
+        e.preventDefault();
+        var id = $(this).val();
+        if (id.length) {
+            Export.loadTemplate(id);
+        }
+    });
+
+    // udpate an existing template with new criteria
+    $('input[name="updateTemplate"]').on('click', function (e) {
+        e.preventDefault();
+        var id = $('select[name="template"]').val();
+        if (id.length) {
+            Export.updateTemplate(id);
+        }
+    });
+
+    // delete an existing template
+    $('input[name="deleteTemplate"]').on('click', function (e) {
+        e.preventDefault();
+        var id = $('select[name="template"]').val();
+        if (id.length) {
+            Export.deleteTemplate(id);
+        }
+    });
+
+    /**
+     * Toggles the hiding and showing of each plugin's options
+     * according to the currently selected plugin from the dropdown list
+     */
+    $('#plugins').on('change', function () {
+        $('#format_specific_opts').find('div.format_specific_options').hide();
+        var selectedPluginName = $('#plugins').find('option:selected').val();
+        $('#' + selectedPluginName + '_options').show();
+    });
+
+    /**
+     * Toggles the enabling and disabling of the SQL plugin's comment options that apply only when exporting structure
+     */
+    $('input[type=\'radio\'][name=\'sql_structure_or_data\']').on('change', function () {
+        var commentsArePresent = $('#checkbox_sql_include_comments').prop('checked');
+        var show = $('input[type=\'radio\'][name=\'sql_structure_or_data\']:checked').val();
+        if (show === 'data') {
+            // disable the SQL comment options
+            if (commentsArePresent) {
+                $('#checkbox_sql_dates').prop('disabled', true).parent().fadeTo('fast', 0.4);
+            }
+            $('#checkbox_sql_relation').prop('disabled', true).parent().fadeTo('fast', 0.4);
+            $('#checkbox_sql_mime').prop('disabled', true).parent().fadeTo('fast', 0.4);
+        } else {
+            // enable the SQL comment options
+            if (commentsArePresent) {
+                $('#checkbox_sql_dates').prop('disabled', false).parent().fadeTo('fast', 1);
+            }
+            $('#checkbox_sql_relation').prop('disabled', false).parent().fadeTo('fast', 1);
+            $('#checkbox_sql_mime').prop('disabled', false).parent().fadeTo('fast', 1);
+        }
+
+        if (show === 'structure') {
+            $('#checkbox_sql_auto_increment').prop('disabled', true).parent().fadeTo('fast', 0.4);
+        } else {
+            $('#checkbox_sql_auto_increment').prop('disabled', false).parent().fadeTo('fast', 1);
+        }
+    });
+
+    // When MS Excel is selected as the Format automatically Switch to Character Set as windows-1252
+    $('#plugins').change(function () {
+        var selectedPluginName = $('#plugins').find('option:selected').val();
+        if (selectedPluginName === 'excel') {
+            $('#select_charset').val('windows-1252');
+        } else {
+            $('#select_charset').val('utf-8');
+        }
+    });
+
+    // For separate-file exports only ZIP compression is allowed
+    $('input[type="checkbox"][name="as_separate_files"]').on('change', function () {
+        if ($(this).is(':checked')) {
+            $('#compression').val('zip');
+        }
+    });
+
+    $('#compression').on('change', function () {
+        if ($('option:selected').val() !== 'zip') {
+            $('input[type="checkbox"][name="as_separate_files"]').prop('checked', false);
+        }
+    });
+});
+
+Export.setupTableStructureOrData = function () {
+    if ($('input[name=\'export_type\']').val() !== 'database') {
+        return;
+    }
+    var pluginName = $('#plugins').find('option:selected').val();
+    var formElemName = pluginName + '_structure_or_data';
+    var forceStructureOrData = !($('input[name=\'' + formElemName + '_default\']').length);
+
+    if (forceStructureOrData === true) {
+        $('input[name="structure_or_data_forced"]').val(1);
+        $('.export_structure input[type="checkbox"], .export_data input[type="checkbox"]')
+            .prop('disabled', true);
+        $('.export_structure, .export_data').fadeTo('fast', 0.4);
+    } else {
+        $('input[name="structure_or_data_forced"]').val(0);
+        $('.export_structure input[type="checkbox"], .export_data input[type="checkbox"]')
+            .prop('disabled', false);
+        $('.export_structure, .export_data').fadeTo('fast', 1);
+
+        var structureOrData = $('input[name="' + formElemName + '_default"]').val();
+
+        if (structureOrData === 'structure') {
+            $('.export_data input[type="checkbox"]')
+                .prop('checked', false);
+        } else if (structureOrData === 'data') {
+            $('.export_structure input[type="checkbox"]')
+                .prop('checked', false);
+        }
+        if (structureOrData === 'structure' || structureOrData === 'structure_and_data') {
+            if (!$('.export_structure input[type="checkbox"]:checked').length) {
+                $('input[name="table_select[]"]:checked')
+                    .closest('tr')
+                    .find('.export_structure input[type="checkbox"]')
+                    .prop('checked', true);
+            }
+        }
+        if (structureOrData === 'data' || structureOrData === 'structure_and_data') {
+            if (!$('.export_data input[type="checkbox"]:checked').length) {
+                $('input[name="table_select[]"]:checked')
+                    .closest('tr')
+                    .find('.export_data input[type="checkbox"]')
+                    .prop('checked', true);
+            }
+        }
+
+        Export.checkSelectedTables();
+        Export.checkTableSelectAll();
+        Export.checkTableSelectStrutureOrData();
+    }
+};
+
+/**
+ * Toggles the hiding and showing of plugin structure-specific and data-specific
+ * options
+ */
+Export.toggleStructureDataOpts = function () {
+    var pluginName = $('select#plugins').val();
+    var radioFormName = pluginName + '_structure_or_data';
+    var dataDiv = '#' + pluginName + '_data';
+    var structureDiv = '#' + pluginName + '_structure';
+    var show = $('input[type=\'radio\'][name=\'' + radioFormName + '\']:checked').val();
+    // Show the #rows if 'show' is not structure
+    $('#rows').toggle(show !== 'structure');
+    if (show === 'data') {
+        $(dataDiv).slideDown('slow');
+        $(structureDiv).slideUp('slow');
+    } else {
+        $(structureDiv).slideDown('slow');
+        if (show === 'structure') {
+            $(dataDiv).slideUp('slow');
+        } else {
+            $(dataDiv).slideDown('slow');
+        }
+    }
+};
+
+/**
+ * Toggles the disabling of the "save to file" options
+ */
+Export.toggleSaveToFile = function () {
+    var $ulSaveAsfile = $('#ul_save_asfile');
+    if (!$('#radio_dump_asfile').prop('checked')) {
+        $ulSaveAsfile.find('> li').fadeTo('fast', 0.4);
+        $ulSaveAsfile.find('> li > input').prop('disabled', true);
+        $ulSaveAsfile.find('> li > select').prop('disabled', true);
+    } else {
+        $ulSaveAsfile.find('> li').fadeTo('fast', 1);
+        $ulSaveAsfile.find('> li > input').prop('disabled', false);
+        $ulSaveAsfile.find('> li > select').prop('disabled', false);
+    }
+};
+
+AJAX.registerOnload('export.js', function () {
+    Export.toggleSaveToFile();
+    $('input[type=\'radio\'][name=\'output_format\']').on('change', Export.toggleSaveToFile);
+});
+
+/**
+ * For SQL plugin, toggles the disabling of the "display comments" options
+ */
+Export.toggleSqlIncludeComments = function () {
+    $('#checkbox_sql_include_comments').on('change', function () {
+        var $ulIncludeComments = $('#ul_include_comments');
+        if (!$('#checkbox_sql_include_comments').prop('checked')) {
+            $ulIncludeComments.find('> li').fadeTo('fast', 0.4);
+            $ulIncludeComments.find('> li > input').prop('disabled', true);
+        } else {
+            // If structure is not being exported, the comment options for structure should not be enabled
+            if ($('#radio_sql_structure_or_data_data').prop('checked')) {
+                $('#text_sql_header_comment').prop('disabled', false).parent('li').fadeTo('fast', 1);
+            } else {
+                $ulIncludeComments.find('> li').fadeTo('fast', 1);
+                $ulIncludeComments.find('> li > input').prop('disabled', false);
+            }
+        }
+    });
+};
+
+Export.checkTableSelectAll = function () {
+    var total = $('input[name="table_select[]"]').length;
+    var strChecked = $('input[name="table_structure[]"]:checked').length;
+    var dataChecked = $('input[name="table_data[]"]:checked').length;
+    var strAll = $('#table_structure_all');
+    var dataAll = $('#table_data_all');
+
+    if (strChecked === total) {
+        strAll
+            .prop('indeterminate', false)
+            .prop('checked', true);
+    } else if (strChecked === 0) {
+        strAll
+            .prop('indeterminate', false)
+            .prop('checked', false);
+    } else {
+        strAll
+            .prop('indeterminate', true)
+            .prop('checked', false);
+    }
+
+    if (dataChecked === total) {
+        dataAll
+            .prop('indeterminate', false)
+            .prop('checked', true);
+    } else if (dataChecked === 0) {
+        dataAll
+            .prop('indeterminate', false)
+            .prop('checked', false);
+    } else {
+        dataAll
+            .prop('indeterminate', true)
+            .prop('checked', false);
+    }
+};
+
+Export.checkTableSelectStrutureOrData = function () {
+    var strChecked = $('input[name="table_structure[]"]:checked').length;
+    var dataChecked = $('input[name="table_data[]"]:checked').length;
+    var autoIncrement = $('#checkbox_sql_auto_increment');
+
+    var pluginName = $('select#plugins').val();
+    var dataDiv = '#' + pluginName + '_data';
+    var structureDiv = '#' + pluginName + '_structure';
+
+    if (strChecked === 0) {
+        $(structureDiv).slideUp('slow');
+    } else {
+        $(structureDiv).slideDown('slow');
+    }
+
+    if (dataChecked === 0) {
+        $(dataDiv).slideUp('slow');
+        autoIncrement.prop('disabled', true).parent().fadeTo('fast', 0.4);
+    } else {
+        $(dataDiv).slideDown('slow');
+        autoIncrement.prop('disabled', false).parent().fadeTo('fast', 1);
+    }
+};
+
+Export.toggleTableSelectAllStr = function () {
+    var strAll = $('#table_structure_all').is(':checked');
+    if (strAll) {
+        $('input[name="table_structure[]"]').prop('checked', true);
+    } else {
+        $('input[name="table_structure[]"]').prop('checked', false);
+    }
+};
+
+Export.toggleTableSelectAllData = function () {
+    var dataAll = $('#table_data_all').is(':checked');
+    if (dataAll) {
+        $('input[name="table_data[]"]').prop('checked', true);
+    } else {
+        $('input[name="table_data[]"]').prop('checked', false);
+    }
+};
+
+Export.checkSelectedTables = function () {
+    $('.export_table_select tbody tr').each(function () {
+        Export.checkTableSelected(this);
+    });
+};
+
+Export.checkTableSelected = function (row) {
+    var $row = $(row);
+    var tableSelect = $row.find('input[name="table_select[]"]');
+    var strCheck = $row.find('input[name="table_structure[]"]');
+    var dataCheck = $row.find('input[name="table_data[]"]');
+
+    var data = dataCheck.is(':checked:not(:disabled)');
+    var structure = strCheck.is(':checked:not(:disabled)');
+
+    if (data && structure) {
+        tableSelect.prop({ checked: true, indeterminate: false });
+        $row.addClass('marked');
+    } else if (data || structure) {
+        tableSelect.prop({ checked: true, indeterminate: true });
+        $row.removeClass('marked');
+    } else {
+        tableSelect.prop({ checked: false, indeterminate: false });
+        $row.removeClass('marked');
+    }
+};
+
+Export.toggleTableSelect = function (row) {
+    var $row = $(row);
+    var tableSelected = $row.find('input[name="table_select[]"]').is(':checked');
+
+    if (tableSelected) {
+        $row.find('input[type="checkbox"]:not(:disabled)').prop('checked', true);
+        $row.addClass('marked');
+    } else {
+        $row.find('input[type="checkbox"]:not(:disabled)').prop('checked', false);
+        $row.removeClass('marked');
+    }
+};
+
+Export.handleAddProcCheckbox = function () {
+    if ($('#table_structure_all').is(':checked') === true
+        && $('#table_data_all').is(':checked') === true
+    ) {
+        $('#checkbox_sql_procedure_function').prop('checked', true);
+    } else {
+        $('#checkbox_sql_procedure_function').prop('checked', false);
+    }
+};
+
+AJAX.registerOnload('export.js', function () {
+    /**
+     * For SQL plugin, if "CREATE TABLE options" is checked/unchecked, check/uncheck each of its sub-options
+     */
+    var $create = $('#checkbox_sql_create_table_statements');
+    var $createOptions = $('#ul_create_table_statements').find('input');
+    $create.on('change', function () {
+        $createOptions.prop('checked', $(this).prop('checked'));
+    });
+    $createOptions.on('change', function () {
+        if ($createOptions.is(':checked')) {
+            $create.prop('checked', true);
+        }
+    });
+
+    /**
+     * Disables the view output as text option if the output must be saved as a file
+     */
+    $('#plugins').on('change', function () {
+        var activePlugin = $('#plugins').find('option:selected').val();
+        var forceFile = $('#force_file_' + activePlugin).val();
+        if (forceFile === 'true') {
+            if ($('#radio_dump_asfile').prop('checked') !== true) {
+                $('#radio_dump_asfile').prop('checked', true);
+                Export.toggleSaveToFile();
+            }
+            $('#radio_view_as_text').prop('disabled', true).parent().fadeTo('fast', 0.4);
+        } else {
+            $('#radio_view_as_text').prop('disabled', false).parent().fadeTo('fast', 1);
+        }
+    });
+
+    $('input[type=\'radio\'][name$=\'_structure_or_data\']').on('change', function () {
+        Export.toggleStructureDataOpts();
+    });
+
+    $('input[name="table_select[]"]').on('change', function () {
+        Export.toggleTableSelect($(this).closest('tr'));
+        Export.checkTableSelectAll();
+        Export.handleAddProcCheckbox();
+        Export.checkTableSelectStrutureOrData();
+    });
+
+    $('input[name="table_structure[]"]').on('change', function () {
+        Export.checkTableSelected($(this).closest('tr'));
+        Export.checkTableSelectAll();
+        Export.handleAddProcCheckbox();
+        Export.checkTableSelectStrutureOrData();
+    });
+
+    $('input[name="table_data[]"]').on('change', function () {
+        Export.checkTableSelected($(this).closest('tr'));
+        Export.checkTableSelectAll();
+        Export.handleAddProcCheckbox();
+        Export.checkTableSelectStrutureOrData();
+    });
+
+    $('#table_structure_all').on('change', function () {
+        Export.toggleTableSelectAllStr();
+        Export.checkSelectedTables();
+        Export.handleAddProcCheckbox();
+        Export.checkTableSelectStrutureOrData();
+    });
+
+    $('#table_data_all').on('change', function () {
+        Export.toggleTableSelectAllData();
+        Export.checkSelectedTables();
+        Export.handleAddProcCheckbox();
+        Export.checkTableSelectStrutureOrData();
+    });
+
+    if ($('input[name=\'export_type\']').val() === 'database') {
+        // Hide structure or data radio buttons
+        $('input[type=\'radio\'][name$=\'_structure_or_data\']').each(function () {
+            var $this = $(this);
+            var name = $this.prop('name');
+            var val = $('input[name="' + name + '"]:checked').val();
+            var nameDefault = name + '_default';
+            if (!$('input[name="' + nameDefault + '"]').length) {
+                $this
+                    .after(
+                        $('<input type="hidden" name="' + nameDefault + '" value="' + val + '" disabled>')
+                    )
+                    .after(
+                        $('<input type="hidden" name="' + name + '" value="structure_and_data">')
+                    );
+                $this.parent().find('label').remove();
+            } else {
+                $this.parent().remove();
+            }
+        });
+        $('input[type=\'radio\'][name$=\'_structure_or_data\']').remove();
+
+        // Disable CREATE table checkbox for sql
+        var createTableCheckbox = $('#checkbox_sql_create_table');
+        createTableCheckbox.prop('checked', true);
+        var dummyCreateTable = $('#checkbox_sql_create_table')
+            .clone()
+            .removeAttr('id')
+            .attr('type', 'hidden');
+        createTableCheckbox
+            .prop('disabled', true)
+            .after(dummyCreateTable)
+            .parent()
+            .fadeTo('fast', 0.4);
+
+        Export.setupTableStructureOrData();
+    }
+
+    /**
+     * Handle force structure_or_data
+     */
+    $('#plugins').on('change', Export.setupTableStructureOrData);
+});
+
+/**
+ * Toggles display of options when quick and custom export are selected
+ */
+Export.toggleQuickOrCustom = function () {
+    if ($('input[name=\'quick_or_custom\']').length === 0 // custom_no_form option
+        || $('#radio_custom_export').prop('checked') // custom
+    ) {
+        $('#databases_and_tables').show();
+        $('#rows').show();
+        $('#output').show();
+        $('#format_specific_opts').show();
+        $('#output_quick_export').hide();
+        var selectedPluginName = $('#plugins').find('option:selected').val();
+        $('#' + selectedPluginName + '_options').show();
+    } else { // quick
+        $('#databases_and_tables').hide();
+        $('#rows').hide();
+        $('#output').hide();
+        $('#format_specific_opts').hide();
+        $('#output_quick_export').show();
+    }
+};
+
+var timeOut;
+
+Export.checkTimeOut = function (timeLimit) {
+    var limit = timeLimit;
+    if (typeof limit === 'undefined' || limit === 0) {
+        return true;
+    }
+    // margin of one second to avoid race condition to set/access session variable
+    limit = limit + 1;
+    var href = 'export.php';
+    var params = {
+        'ajax_request' : true,
+        'check_time_out' : true
+    };
+    clearTimeout(timeOut);
+    timeOut = setTimeout(function () {
+        $.get(href, params, function (data) {
+            if (data.message === 'timeout') {
+                Functions.ajaxShowMessage(
+                    '<div class="error">' +
+                    Messages.strTimeOutError +
+                    '</div>',
+                    false
+                );
+            }
+        });
+    }, limit * 1000);
+};
+
+/**
+ * Handler for Database/table alias select
+ *
+ * @param event object the event object
+ *
+ * @return void
+ */
+Export.aliasSelectHandler = function (event) {
+    var sel = event.data.sel;
+    var type = event.data.type;
+    var inputId = $(this).val();
+    var $label = $(this).next('label');
+    $('input#' + $label.attr('for')).addClass('hide');
+    $('input#' + inputId).removeClass('hide');
+    $label.attr('for', inputId);
+    $('#alias_modal ' + sel + '[id$=' + type + ']:visible').addClass('hide');
+    var $inputWrapper = $('#alias_modal ' + sel + '#' + inputId + type);
+    $inputWrapper.removeClass('hide');
+    if (type === '_cols' && $inputWrapper.length > 0) {
+        var outer = $inputWrapper[0].outerHTML;
+        // Replace opening tags
+        var regex = /<dummy_inp/gi;
+        if (outer.match(regex)) {
+            var newTag = outer.replace(regex, '<input');
+            // Replace closing tags
+            regex = /<\/dummy_inp/gi;
+            newTag = newTag.replace(regex, '</input');
+            // Assign replacement
+            $inputWrapper.replaceWith(newTag);
+        }
+    } else if (type === '_tables') {
+        $('.table_alias_select:visible').trigger('change');
+    }
+    $('#alias_modal').dialog('option', 'position', 'center');
+};
+
+/**
+ * Handler for Alias dialog box
+ *
+ * @param event object the event object
+ *
+ * @return void
+ */
+Export.createAliasModal = function (event) {
+    event.preventDefault();
+    var dlgButtons = {};
+    dlgButtons[Messages.strSaveAndClose] = function () {
+        $(this).dialog('close');
+        $('#alias_modal').parent().appendTo($('form[name="dump"]'));
+    };
+    $('#alias_modal').dialog({
+        width: Math.min($(window).width() - 100, 700),
+        maxHeight: $(window).height(),
+        modal: true,
+        dialogClass: 'alias-dialog',
+        buttons: dlgButtons,
+        create: function () {
+            $(this).closest('.ui-dialog').find('.ui-button').addClass('btn btn-secondary');
+            $(this).css('maxHeight', $(window).height() - 150);
+            var db = CommonParams.get('db');
+            if (db) {
+                var option = $('<option></option>');
+                option.text(db);
+                option.attr('value', db);
+                $('#db_alias_select').append(option).val(db).trigger('change');
+            } else {
+                var params = {
+                    'ajax_request': true,
+                    'server': CommonParams.get('server'),
+                    'type': 'list-databases'
+                };
+                $.post('ajax.php', params, function (response) {
+                    if (response.success === true) {
+                        $.each(response.databases, function (idx, value) {
+                            var option = $('<option></option>');
+                            option.text(value);
+                            option.attr('value', value);
+                            $('#db_alias_select').append(option);
+                        });
+                    } else {
+                        Functions.ajaxShowMessage(response.error, false);
+                    }
+                });
+            }
+        },
+        close: function () {
+            var isEmpty = true;
+            $(this).find('input[type="text"]').each(function () {
+                // trim empty input fields on close
+                if ($(this).val()) {
+                    isEmpty = false;
+                } else {
+                    $(this).parents('tr').remove();
+                }
+            });
+            // Toggle checkbox based on aliases
+            $('input#btn_alias_config').prop('checked', !isEmpty);
+        },
+        position: { my: 'center top', at: 'center top', of: window }
+    });
+};
+
+Export.aliasToggleRow = function (elm) {
+    var inputs = elm.parents('tr').find('input,button');
+    if (elm.val()) {
+        inputs.attr('disabled', false);
+    } else {
+        inputs.attr('disabled', true);
+    }
+};
+
+Export.addAlias = function (type, name, field, value) {
+    if (value === '') {
+        return;
+    }
+
+    var row = $('#alias_data tfoot tr').clone();
+    row.find('th').text(type);
+    row.find('td:first').text(name);
+    row.find('input').attr('name', field);
+    row.find('input').val(value);
+    row.find('.alias_remove').on('click', function () {
+        $(this).parents('tr').remove();
+    });
+
+    var matching = $('#alias_data [name="' + $.escapeSelector(field) + '"]');
+    if (matching.length > 0) {
+        matching.parents('tr').remove();
+    }
+
+    $('#alias_data tbody').append(row);
+};
+
+AJAX.registerOnload('export.js', function () {
+    $('input[type=\'radio\'][name=\'quick_or_custom\']').on('change', Export.toggleQuickOrCustom);
+
+    $('#scroll_to_options_msg').hide();
+    $('#format_specific_opts').find('div.format_specific_options')
+        .hide()
+        .css({
+            'border': 0,
+            'margin': 0,
+            'padding': 0
+        })
+        .find('h3')
+        .remove();
+    Export.toggleQuickOrCustom();
+    Export.toggleStructureDataOpts();
+    Export.toggleSqlIncludeComments();
+    Export.checkTableSelectAll();
+    Export.handleAddProcCheckbox();
+
+    /**
+     * Initially disables the "Dump some row(s)" sub-options
+     */
+    Export.disableDumpSomeRowsSubOptions();
+
+    /**
+     * Disables the "Dump some row(s)" sub-options when it is not selected
+     */
+    $('input[type=\'radio\'][name=\'allrows\']').on('change', function () {
+        if ($('input[type=\'radio\'][name=\'allrows\']').prop('checked')) {
+            Export.enableDumpSomeRowsSubOptions();
+        } else {
+            Export.disableDumpSomeRowsSubOptions();
+        }
+    });
+
+    // Open Alias Modal Dialog on click
+    $('#btn_alias_config').on('click', Export.createAliasModal);
+    $('.alias_remove').on('click', function () {
+        $(this).parents('tr').remove();
+    });
+    $('#db_alias_select').on('change', function () {
+        Export.aliasToggleRow($(this));
+        var table = CommonParams.get('table');
+        if (table) {
+            var option = $('<option></option>');
+            option.text(table);
+            option.attr('value', table);
+            $('#table_alias_select').append(option).val(table).trigger('change');
+        } else {
+            var params = {
+                'ajax_request': true,
+                'server': CommonParams.get('server'),
+                'db': $(this).val(),
+                'type': 'list-tables'
+            };
+            $.post('ajax.php', params, function (response) {
+                if (response.success === true) {
+                    $.each(response.tables, function (idx, value) {
+                        var option = $('<option></option>');
+                        option.text(value);
+                        option.attr('value', value);
+                        $('#table_alias_select').append(option);
+                    });
+                } else {
+                    Functions.ajaxShowMessage(response.error, false);
+                }
+            });
+        }
+    });
+    $('#table_alias_select').on('change', function () {
+        Export.aliasToggleRow($(this));
+        var params = {
+            'ajax_request': true,
+            'server': CommonParams.get('server'),
+            'db': $('#db_alias_select').val(),
+            'table': $(this).val(),
+            'type': 'list-columns'
+        };
+        $.post('ajax.php', params, function (response) {
+            if (response.success === true) {
+                $.each(response.columns, function (idx, value) {
+                    var option = $('<option></option>');
+                    option.text(value);
+                    option.attr('value', value);
+                    $('#column_alias_select').append(option);
+                });
+            } else {
+                Functions.ajaxShowMessage(response.error, false);
+            }
+        });
+    });
+    $('#column_alias_select').on('change', function () {
+        Export.aliasToggleRow($(this));
+    });
+    $('#db_alias_button').on('click', function (e) {
+        e.preventDefault();
+        var db = $('#db_alias_select').val();
+        Export.addAlias(
+            Messages.strAliasDatabase,
+            db,
+            'aliases[' + db + '][alias]',
+            $('#db_alias_name').val()
+        );
+        $('#db_alias_name').val('');
+    });
+    $('#table_alias_button').on('click', function (e) {
+        e.preventDefault();
+        var db = $('#db_alias_select').val();
+        var table = $('#table_alias_select').val();
+        Export.addAlias(
+            Messages.strAliasTable,
+            db + '.' + table,
+            'aliases[' + db + '][tables][' + table + '][alias]',
+            $('#table_alias_name').val()
+        );
+        $('#table_alias_name').val('');
+    });
+    $('#column_alias_button').on('click', function (e) {
+        e.preventDefault();
+        var db = $('#db_alias_select').val();
+        var table = $('#table_alias_select').val();
+        var column = $('#column_alias_select').val();
+        Export.addAlias(
+            Messages.strAliasColumn,
+            db + '.' + table + '.' + column,
+            'aliases[' + db + '][tables][' + table + '][colums][' + column + ']',
+            $('#column_alias_name').val()
+        );
+        $('#column_alias_name').val('');
+    });
+});