functions/Indexes.js

  1. import Indexes from '../utils/IndexEnum';
  2. import { PMA_Messages as PMA_messages } from '../variables/export_variables';
  3. import PMA_commonParams from '../variables/common_params';
  4. import { PMA_ajaxShowMessage, PMA_ajaxRemoveMessage, PMA_showHints } from '../utils/show_ajax_messages';
  5. import { PMA_prepareForAjaxRequest } from './AjaxRequest';
  6. import { PMA_highlightSQL } from '../utils/sql';
  7. import { PMA_previewSQL } from './Sql/PreviewSql';
  8. import { PMA_verifyColumnsProperties } from './Table/TableColumns';
  9. import { PMA_sprintf } from '../utils/sprintf';
  10. import { PMA_init_slider } from '../utils/Slider';
  11. import { PMA_reloadNavigation } from './navigation';
  13. /**
  14.  * Returns the array of indexes based on the index choice
  15.  *
  16.  * @param index_choice index choice
  17.  */
  18. export function PMA_getIndexArray (index_choice) {
  19.     var source_array = null;
  21.     switch (index_choice.toLowerCase()) {
  22.     case 'primary':
  23.         source_array = Indexes.primary_indexes;
  24.         break;
  25.     case 'unique':
  26.         source_array = Indexes.unique_indexes;
  27.         break;
  28.     case 'index':
  29.         source_array = Indexes.indexes;
  30.         break;
  31.     case 'fulltext':
  32.         source_array = Indexes.fulltext_indexes;
  33.         break;
  34.     case 'spatial':
  35.         source_array = Indexes.spatial_indexes;
  36.         break;
  37.     default:
  38.         return null;
  39.     }
  40.     return source_array;
  41. }
  43. /**
  44.  * Hides/shows the inputs and submits appropriately depending
  45.  * on whether the index type chosen is 'SPATIAL' or not.
  46.  */
  47. export function checkIndexType () {
  48.     /**
  49.      * @var Object Dropdown to select the index choice.
  50.      */
  51.     var $select_index_choice = $('#select_index_choice');
  52.     /**
  53.      * @var Object Dropdown to select the index type.
  54.      */
  55.     var $select_index_type = $('#select_index_type');
  56.     /**
  57.      * @var Object Table header for the size column.
  58.      */
  59.     var $size_header = $('#index_columns').find('thead tr th:nth-child(2)');
  60.     /**
  61.      * @var Object Inputs to specify the columns for the index.
  62.      */
  63.     var $column_inputs = $('select[name="index[columns][names][]"]');
  64.     /**
  65.      * @var Object Inputs to specify sizes for columns of the index.
  66.      */
  67.     var $size_inputs = $('input[name="index[columns][sub_parts][]"]');
  68.     /**
  69.      * @var Object Footer containg the controllers to add more columns
  70.      */
  71.     var $add_more = $('#index_frm').find('.add_more');
  73.     if ($select_index_choice.val() === 'SPATIAL') {
  74.         // Disable and hide the size column
  75.         $size_header.hide();
  76.         $size_inputs.each(function () {
  77.             $(this)
  78.                 .prop('disabled', true)
  79.                 .parent('td').hide();
  80.         });
  82.         // Disable and hide the columns of the index other than the first one
  83.         var initial = true;
  84.         $column_inputs.each(function () {
  85.             var $column_input = $(this);
  86.             if (! initial) {
  87.                 $column_input
  88.                     .prop('disabled', true)
  89.                     .parent('td').hide();
  90.             } else {
  91.                 initial = false;
  92.             }
  93.         });
  95.         // Hide controllers to add more columns
  96.         $add_more.hide();
  97.     } else {
  98.         // Enable and show the size column
  99.         $size_header.show();
  100.         $size_inputs.each(function () {
  101.             $(this)
  102.                 .prop('disabled', false)
  103.                 .parent('td').show();
  104.         });
  106.         // Enable and show the columns of the index
  107.         $column_inputs.each(function () {
  108.             $(this)
  109.                 .prop('disabled', false)
  110.                 .parent('td').show();
  111.         });
  113.         // Show controllers to add more columns
  114.         $add_more.show();
  115.     }
  117.     if ($select_index_choice.val() === 'SPATIAL' ||
  118.             $select_index_choice.val() === 'FULLTEXT') {
  119.         $select_index_type.val('').prop('disabled', true);
  120.     } else {
  121.         $select_index_type.prop('disabled', false);
  122.     }
  123. }
  125. /**
  126.  * Sets current index information into form parameters.
  127.  *
  128.  * @param array  source_array Array containing index columns
  129.  * @param string index_choice Choice of index
  130.  *
  131.  * @return void
  132.  */
  133. function PMA_setIndexFormParameters (source_array, index_choice) {
  134.     if (index_choice === 'index') {
  135.         $('input[name="indexes"]').val(JSON.stringify(source_array));
  136.     } else {
  137.         $('input[name="' + index_choice + '_indexes"]').val(JSON.stringify(source_array));
  138.     }
  139. }
  141. /**
  142.  * Removes a column from an Index.
  143.  *
  144.  * @param string col_index Index of column in form
  145.  *
  146.  * @return void
  147.  */
  148. export function PMA_removeColumnFromIndex (col_index) {
  149.     // Get previous index details.
  150.     var previous_index = $('select[name="field_key[' + col_index + ']"]')
  151.         .attr('data-index');
  152.     if (previous_index.length) {
  153.         previous_index = previous_index.split(',');
  154.         var source_array = PMA_getIndexArray(previous_index[0]);
  155.         if (source_array === null) {
  156.             return;
  157.         }
  159.         // Remove column from index array.
  160.         var source_length = source_array[previous_index[1]].columns.length;
  161.         for (var i = 0; i < source_length; i++) {
  162.             if (source_array[previous_index[1]].columns[i].col_index === col_index) {
  163.                 source_array[previous_index[1]].columns.splice(i, 1);
  164.             }
  165.         }
  167.         // Remove index completely if no columns left.
  168.         if (source_array[previous_index[1]].columns.length === 0) {
  169.             source_array.splice(previous_index[1], 1);
  170.         }
  172.         // Update current index details.
  173.         $('select[name="field_key[' + col_index + ']"]').attr('data-index', '');
  174.         // Update form index parameters.
  175.         PMA_setIndexFormParameters(source_array, previous_index[0].toLowerCase());
  176.     }
  177. }
  179. /**
  180.  * Adds a column to an Index.
  181.  *
  182.  * @param array  source_array Array holding corresponding indexes
  183.  * @param string array_index  Index of an INDEX in array
  184.  * @param string index_choice Choice of Index
  185.  * @param string col_index    Index of column on form
  186.  *
  187.  * @return void
  188.  */
  189. function PMA_addColumnToIndex (source_array, array_index, index_choice, col_index) {
  190.     if (col_index >= 0) {
  191.         // Remove column from other indexes (if any).
  192.         PMA_removeColumnFromIndex(col_index);
  193.     }
  194.     var index_name = $('input[name="index[Key_name]"]').val();
  195.     var index_comment = $('input[name="index[Index_comment]"]').val();
  196.     var key_block_size = $('input[name="index[Key_block_size]"]').val();
  197.     var parser = $('input[name="index[Parser]"]').val();
  198.     var index_type = $('select[name="index[Index_type]"]').val();
  199.     var columns = [];
  200.     $('#index_columns').find('tbody').find('tr').each(function () {
  201.         // Get columns in particular order.
  202.         var col_index = $(this).find('select[name="index[columns][names][]"]').val();
  203.         var size = $(this).find('input[name="index[columns][sub_parts][]"]').val();
  204.         columns.push({
  205.             'col_index': col_index,
  206.             'size': size
  207.         });
  208.     });
  210.     // Update or create an index.
  211.     source_array[array_index] = {
  212.         'Key_name': index_name,
  213.         'Index_comment': index_comment,
  214.         'Index_choice': index_choice.toUpperCase(),
  215.         'Key_block_size': key_block_size,
  216.         'Parser': parser,
  217.         'Index_type': index_type,
  218.         'columns': columns
  219.     };
  221.     // Display index name (or column list)
  222.     var displayName = index_name;
  223.     if (displayName === '') {
  224.         var columnNames = [];
  225.         $.each(columns, function () {
  226.             columnNames.push($('input[name="field_name[' +  this.col_index + ']"]').val());
  227.         });
  228.         displayName = '[' + columnNames.join(', ') + ']';
  229.     }
  230.     $.each(columns, function () {
  231.         var id = 'index_name_' + this.col_index + '_8';
  232.         var $name = $('#' + id);
  233.         if ($name.length === 0) {
  234.             $name = $('<a id="' + id + '" href="#" class="ajax show_index_dialog"></a>');
  235.             $name.insertAfter($('select[name="field_key[' + this.col_index + ']"]'));
  236.         }
  237.         var $text = $('<small>').text(displayName);
  238.         $name.html($text);
  239.     });
  241.     if (col_index >= 0) {
  242.         // Update index details on form.
  243.         $('select[name="field_key[' + col_index + ']"]')
  244.             .attr('data-index', index_choice + ',' + array_index);
  245.     }
  246.     PMA_setIndexFormParameters(source_array, index_choice.toLowerCase());
  247. }
  249. /**
  250.  * Get choices list for a column to create a composite index with.
  251.  *
  252.  * @param string index_choice Choice of index
  253.  * @param array  source_array Array hodling columns for particular index
  254.  *
  255.  * @return jQuery Object
  256.  */
  257. function PMA_getCompositeIndexList (source_array, col_index) {
  258.     // Remove any previous list.
  259.     if ($('#composite_index_list').length) {
  260.         $('#composite_index_list').remove();
  261.     }
  263.     // Html list.
  264.     var $composite_index_list = $(
  265.         '<ul id="composite_index_list">' +
  266.         '<div>' + PMA_messages.strCompositeWith + '</div>' +
  267.         '</ul>'
  268.     );
  270.     // Add each column to list available for composite index.
  271.     var source_length = source_array.length;
  272.     var already_present = false;
  273.     for (var i = 0; i < source_length; i++) {
  274.         var sub_array_len = source_array[i].columns.length;
  275.         var column_names = [];
  276.         for (var j = 0; j < sub_array_len; j++) {
  277.             column_names.push(
  278.                 $('input[name="field_name[' + source_array[i].columns[j].col_index + ']"]').val()
  279.             );
  281.             if (col_index === source_array[i].columns[j].col_index) {
  282.                 already_present = true;
  283.             }
  284.         }
  286.         $composite_index_list.append(
  287.             '<li>' +
  288.             '<input type="radio" name="composite_with" ' +
  289.             (already_present ? 'checked="checked"' : '') +
  290.             ' id="composite_index_' + i + '" value="' + i + '">' +
  291.             '<label for="composite_index_' + i + '">' + column_names.join(', ') +
  292.             '</lablel>' +
  293.             '</li>'
  294.         );
  295.     }
  297.     return $composite_index_list;
  298. }
  300. /**
  301.  * Ensures indexes names are valid according to their type and, for a primary
  302.  * key, lock index name to 'PRIMARY'
  303.  * @param string   form_id  Variable which parses the form name as
  304.  *                            the input
  305.  * @return boolean  false    if there is no index form, true else
  306.  */
  307. export function checkIndexName (form_id) {
  308.     if ($('#' + form_id).length === 0) {
  309.         return false;
  310.     }
  312.     // Gets the elements pointers
  313.     var $the_idx_name = $('#input_index_name');
  314.     var $the_idx_choice = $('#select_index_choice');
  316.     // Index is a primary key
  317.     if ($the_idx_choice.find('option:selected').val() === 'PRIMARY') {
  318.         $the_idx_name.val('PRIMARY');
  319.         $the_idx_name.prop('disabled', true);
  320.     } else {
  321.         if ($the_idx_name.val() === 'PRIMARY') {
  322.             $the_idx_name.val('');
  323.         }
  324.         $the_idx_name.prop('disabled', false);
  325.     }
  327.     return true;
  328. } // end of the 'checkIndexName()' function
  330. /**
  331.  * Shows 'Add Index' dialog.
  332.  *
  333.  * @param array  source_array   Array holding particluar index
  334.  * @param string array_index    Index of an INDEX in array
  335.  * @param array  target_columns Columns for an INDEX
  336.  * @param string col_index      Index of column on form
  337.  * @param object index          Index detail object
  338.  *
  339.  * @return void
  340.  */
  341. export function PMA_showAddIndexDialog (source_array, array_index, target_columns, col_index, index) {
  342.     // Prepare post-data.
  343.     var $table = $('input[name="table"]');
  344.     var table = $table.length > 0 ? $table.val() : '';
  345.     var post_data = {
  346.         server: PMA_commonParams.get('server'),
  347.         db: $('input[name="db"]').val(),
  348.         table: table,
  349.         ajax_request: 1,
  350.         create_edit_table: 1,
  351.         index: index
  352.     };
  354.     var columns = {};
  355.     for (var i = 0; i < target_columns.length; i++) {
  356.         var column_name = $('input[name="field_name[' + target_columns[i] + ']"]').val();
  357.         var column_type = $('select[name="field_type[' + target_columns[i] + ']"]').val().toLowerCase();
  358.         columns[column_name] = [column_type, target_columns[i]];
  359.     }
  360.     post_data.columns = JSON.stringify(columns);
  362.     var button_options = {};
  363.     button_options[PMA_messages.strGo] = function () {
  364.         var is_missing_value = false;
  365.         $('select[name="index[columns][names][]"]').each(function () {
  366.             if ($(this).val() === '') {
  367.                 is_missing_value = true;
  368.             }
  369.         });
  371.         if (! is_missing_value) {
  372.             PMA_addColumnToIndex(
  373.                 source_array,
  374.                 array_index,
  375.                 index.Index_choice,
  376.                 col_index
  377.             );
  378.         } else {
  379.             PMA_ajaxShowMessage(
  380.                 '<div class="error"><img src="themes/dot.gif" title="" alt=""' +
  381.                 ' class="icon ic_s_error" /> ' + PMA_messages.strMissingColumn +
  382.                 ' </div>', false
  383.             );
  385.             return false;
  386.         }
  388.         $(this).dialog('close');
  389.     };
  390.     button_options[PMA_messages.strCancel] = function () {
  391.         if (col_index >= 0) {
  392.             // Handle state on 'Cancel'.
  393.             var $select_list = $('select[name="field_key[' + col_index + ']"]');
  394.             if (! $select_list.attr('data-index').length) {
  395.                 $select_list.find('option[value*="none"]').attr('selected', 'selected');
  396.             } else {
  397.                 var previous_index = $select_list.attr('data-index').split(',');
  398.                 $select_list.find('option[value*="' + previous_index[0].toLowerCase() + '"]')
  399.                     .attr('selected', 'selected');
  400.             }
  401.         }
  402.         $(this).dialog('close');
  403.     };
  404.     var $msgbox = PMA_ajaxShowMessage();
  405.     $.post('tbl_indexes.php', post_data, function (data) {
  406.         if (data.success === false) {
  407.             // in the case of an error, show the error message returned.
  408.             PMA_ajaxShowMessage(data.error, false);
  409.         } else {
  410.             PMA_ajaxRemoveMessage($msgbox);
  411.             // Show dialog if the request was successful
  412.             var $div = $('<div/>');
  413.             $div
  414.                 .append(data.message)
  415.                 .dialog({
  416.                     title: PMA_messages.strAddIndex,
  417.                     width: 450,
  418.                     minHeight: 250,
  419.                     open: function () {
  420.                         checkIndexName('index_frm');
  421.                         PMA_showHints($div);
  422.                         PMA_init_slider();
  423.                         $('#index_columns').find('td').each(function () {
  424.                             $(this).css('width', $(this).width() + 'px');
  425.                         });
  426.                         $('#index_columns').find('tbody').sortable({
  427.                             axis: 'y',
  428.                             containment: $('#index_columns').find('tbody'),
  429.                             tolerance: 'pointer'
  430.                         });
  431.                         // We dont need the slider at this moment.
  432.                         $(this).find('fieldset.tblFooters').remove();
  433.                     },
  434.                     modal: true,
  435.                     buttons: button_options,
  436.                     close: function () {
  437.                         $(this).remove();
  438.                     }
  439.                 });
  440.         }
  441.     });
  442. }
  444. /**
  445.  * Creates a advanced index type selection dialog.
  446.  *
  447.  * @param array  source_array Array holding a particular type of indexes
  448.  * @param string index_choice Choice of index
  449.  * @param string col_index    Index of new column on form
  450.  *
  451.  * @return void
  452.  */
  453. export function PMA_indexTypeSelectionDialog (source_array, index_choice, col_index) {
  454.     var $single_column_radio = $('<input type="radio" id="single_column" name="index_choice"' +
  455.         ' checked="checked">' +
  456.         '<label for="single_column">' + PMA_messages.strCreateSingleColumnIndex + '</label>');
  457.     var $composite_index_radio = $('<input type="radio" id="composite_index"' +
  458.         ' name="index_choice">' +
  459.         '<label for="composite_index">' + PMA_messages.strCreateCompositeIndex + '</label>');
  460.     var $dialog_content = $('<fieldset id="advance_index_creator"></fieldset>');
  461.     $dialog_content.append('<legend>' + index_choice.toUpperCase() + '</legend>');
  464.     // For UNIQUE/INDEX type, show choice for single-column and composite index.
  465.     $dialog_content.append($single_column_radio);
  466.     $dialog_content.append($composite_index_radio);
  468.     var button_options = {};
  469.     // 'OK' operation.
  470.     button_options[PMA_messages.strGo] = function () {
  471.         if ($('#single_column').is(':checked')) {
  472.             var index = {
  473.                 'Key_name': (index_choice === 'primary' ? 'PRIMARY' : ''),
  474.                 'Index_choice': index_choice.toUpperCase()
  475.             };
  476.             PMA_showAddIndexDialog(source_array, (source_array.length), [col_index], col_index, index);
  477.         }
  479.         if ($('#composite_index').is(':checked')) {
  480.             if ($('input[name="composite_with"]').length !== 0 && $('input[name="composite_with"]:checked').length === 0
  481.             ) {
  482.                 PMA_ajaxShowMessage(
  483.                     '<div class="error"><img src="themes/dot.gif" title=""' +
  484.                     ' alt="" class="icon ic_s_error" /> ' +
  485.                     PMA_messages.strFormEmpty +
  486.                     ' </div>',
  487.                     false
  488.                 );
  489.                 return false;
  490.             }
  492.             var array_index = $('input[name="composite_with"]:checked').val();
  493.             var source_length = source_array[array_index].columns.length;
  494.             var target_columns = [];
  495.             for (var i = 0; i < source_length; i++) {
  496.                 target_columns.push(source_array[array_index].columns[i].col_index);
  497.             }
  498.             target_columns.push(col_index);
  500.             PMA_showAddIndexDialog(source_array, array_index, target_columns, col_index,
  501.                 source_array[array_index]);
  502.         }
  504.         $(this).remove();
  505.     };
  506.     button_options[PMA_messages.strCancel] = function () {
  507.         // Handle state on 'Cancel'.
  508.         var $select_list = $('select[name="field_key[' + col_index + ']"]');
  509.         if (! $select_list.attr('data-index').length) {
  510.             $select_list.find('option[value*="none"]').attr('selected', 'selected');
  511.         } else {
  512.             var previous_index = $select_list.attr('data-index').split(',');
  513.             $select_list.find('option[value*="' + previous_index[0].toLowerCase() + '"]')
  514.                 .attr('selected', 'selected');
  515.         }
  516.         $(this).remove();
  517.     };
  518.     var $dialog = $('<div/>').append($dialog_content).dialog({
  519.         minWidth: 525,
  520.         minHeight: 200,
  521.         modal: true,
  522.         title: PMA_messages.strAddIndex,
  523.         resizable: false,
  524.         buttons: button_options,
  525.         open: function () {
  526.             $('#composite_index').on('change', function () {
  527.                 if ($(this).is(':checked')) {
  528.                     $dialog_content.append(PMA_getCompositeIndexList(source_array, col_index));
  529.                 }
  530.             });
  531.             $('#single_column').on('change', function () {
  532.                 if ($(this).is(':checked')) {
  533.                     if ($('#composite_index_list').length) {
  534.                         $('#composite_index_list').remove();
  535.                     }
  536.                 }
  537.             });
  538.         },
  539.         close: function () {
  540.             $('#composite_index').off('change');
  541.             $('#single_column').off('change');
  542.             $(this).remove();
  543.         }
  544.     });
  545. }
  547. export function showIndexEditDialog ($outer) {
  548.     checkIndexType();
  549.     checkIndexName('index_frm');
  550.     var $indexColumns = $('#index_columns');
  551.     $indexColumns.find('td').each(function () {
  552.         $(this).css('width', $(this).width() + 'px');
  553.     });
  554.     $indexColumns.find('tbody').sortable({
  555.         axis: 'y',
  556.         containment: $indexColumns.find('tbody'),
  557.         tolerance: 'pointer'
  558.     });
  559.     PMA_showHints($outer);
  560.     PMA_init_slider();
  561.     // Add a slider for selecting how many columns to add to the index
  562.     $outer.find('.slider').slider({
  563.         animate: true,
  564.         value: 1,
  565.         min: 1,
  566.         max: 16,
  567.         slide: function (event, ui) {
  568.             $(this).closest('fieldset').find('input[type=submit]').val(
  569.                 PMA_sprintf(PMA_messages.strAddToIndex, ui.value)
  570.             );
  571.         }
  572.     });
  573.     $('div.add_fields').removeClass('hide');
  574.     // focus index size input on column picked
  575.     $outer.find('table#index_columns select').on('change', function () {
  576.         if ($(this).find('option:selected').val() === '') {
  577.             return true;
  578.         }
  579.         $(this).closest('tr').find('input').focus();
  580.     });
  581.     // Focus the slider, otherwise it looks nearly transparent
  582.     $('a.ui-slider-handle').addClass('ui-state-focus');
  583.     // set focus on index name input, if empty
  584.     var input = $outer.find('input#input_index_name');
  585.     if (! input.val()) {
  586.         input.focus();
  587.     }
  588. }
  590. export function indexEditorDialog (url, title, callback_success, callback_failure) {
  591.     /* Remove the hidden dialogs if there are*/
  592.     var $editIndexDialog = $('#edit_index_dialog');
  593.     if ($editIndexDialog.length !== 0) {
  594.         $editIndexDialog.remove();
  595.     }
  596.     var $div = $('<div id="edit_index_dialog"></div>');
  598.     /**
  599.      * @var button_options Object that stores the options
  600.      *                     passed to jQueryUI dialog
  601.      */
  602.     var button_options = {};
  603.     button_options[PMA_messages.strGo] = function () {
  604.         /**
  605.          * @var    the_form    object referring to the export form
  606.          */
  607.         var $form = $('#index_frm');
  608.         var $msgbox = PMA_ajaxShowMessage(PMA_messages.strProcessingRequest);
  609.         PMA_prepareForAjaxRequest($form);
  610.         // User wants to submit the form
  611.         $.post($form.attr('action'), $form.serialize() + PMA_commonParams.get('arg_separator') + 'do_save_data=1', function (data) {
  612.             var $sqlqueryresults = $('.sqlqueryresults');
  613.             if ($sqlqueryresults.length !== 0) {
  614.                 $sqlqueryresults.remove();
  615.             }
  616.             if (typeof data !== 'undefined' && data.success === true) {
  617.                 PMA_ajaxShowMessage(data.message);
  618.                 var $resultQuery = $('.result_query');
  619.                 if ($resultQuery.length) {
  620.                     $resultQuery.remove();
  621.                 }
  622.                 if (data.sql_query) {
  623.                     $('<div class="result_query"></div>')
  624.                         .html(data.sql_query)
  625.                         .prependTo('#page_content');
  626.                     PMA_highlightSQL($('#page_content'));
  627.                 }
  628.                 $('.result_query .notice').remove();
  629.                 $resultQuery.prepend(data.message);
  630.                 /* Reload the field form*/
  631.                 $('#table_index').remove();
  632.                 $('<div id=\'temp_div\'><div>')
  633.                     .append(data.index_table)
  634.                     .find('#table_index')
  635.                     .insertAfter('#index_header');
  636.                 var $editIndexDialog = $('#edit_index_dialog');
  637.                 if ($editIndexDialog.length > 0) {
  638.                     $editIndexDialog.dialog('close');
  639.                 }
  640.                 $('div.no_indexes_defined').hide();
  641.                 if (callback_success) {
  642.                     callback_success();
  643.                 }
  644.                 PMA_reloadNavigation();
  645.             } else {
  646.                 var $temp_div = $('<div id=\'temp_div\'><div>').append(data.error);
  647.                 var $error;
  648.                 if ($temp_div.find('.error code').length !== 0) {
  649.                     $error = $temp_div.find('.error code').addClass('error');
  650.                 } else {
  651.                     $error = $temp_div;
  652.                 }
  653.                 if (callback_failure) {
  654.                     callback_failure();
  655.                 }
  656.                 PMA_ajaxShowMessage($error, false);
  657.             }
  658.         }); // end $.post()
  659.     };
  660.     button_options[PMA_messages.strPreviewSQL] = function () {
  661.         // Function for Previewing SQL
  662.         var $form = $('#index_frm');
  663.         PMA_previewSQL($form);
  664.     };
  665.     button_options[PMA_messages.strCancel] = function () {
  666.         $(this).dialog('close');
  667.     };
  668.     var $msgbox = PMA_ajaxShowMessage();
  669.     $.get('tbl_indexes.php', url, function (data) {
  670.         if (typeof data !== 'undefined' && data.success === false) {
  671.             // in the case of an error, show the error message returned.
  672.             PMA_ajaxShowMessage(data.error, false);
  673.         } else {
  674.             PMA_ajaxRemoveMessage($msgbox);
  675.             // Show dialog if the request was successful
  676.             $div
  677.                 .append(data.message)
  678.                 .dialog({
  679.                     title: title,
  680.                     width: 'auto',
  681.                     open: PMA_verifyColumnsProperties,
  682.                     modal: true,
  683.                     buttons: button_options,
  684.                     close: function () {
  685.                         $(this).remove();
  686.                     }
  687.                 });
  688.             $div.find('.tblFooters').remove();
  689.             showIndexEditDialog($div);
  690.         }
  691.     }); // end $.get()
  692. }