Software: Apache. PHP/5.5.15 uname -a: Windows NT SVR-DMZ 6.1 build 7600 (Windows Server 2008 R2 Enterprise Edition) i586 SYSTEM Safe-mode: OFF (not secure) E:\copia nuevo\phpMyAdmin\js\ drwxrwxrwx |
Viewing file: Select action/file-type: /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * @fileoverview functions used on the table structure page * @name Table Structure * * @requires jQuery * @requires jQueryUI * @required js/functions.js */ /** * AJAX scripts for tbl_structure.php * * Actions ajaxified here: * Drop Column * Add Primary Key * Drop Primary Key/Index * */ /** * This function returns the horizontal space available for the menu in pixels. * To calculate this value we start we the width of the main panel, then we * substract the margin of the page content, then we substract any cellspacing * that the table may have (original theme only) and finally we substract the * width of all columns of the table except for the last one (which is where * the menu will go). What we should end up with is the distance between the * start of the last column on the table and the edge of the page, again this * is the space available for the menu. * * In the case where the table cell where the menu will be displayed is already * off-screen (the table is wider than the page), a negative value will be returned, * but this will be treated as a zero by the menuResizer plugin. * * @return int */ function PMA_tbl_structure_menu_resizer_callback() { var pagewidth = $('body').width(); var $page = $('#page_content'); pagewidth -= $page.outerWidth(true) - $page.outerWidth(); var columnsWidth = 0; var $columns = $('#tablestructure').find('tr:eq(1)').find('td,th'); $columns.not(':last').each(function () { columnsWidth += $(this).outerWidth(true); }); var totalCellSpacing = $('#tablestructure').width(); $columns.each(function () { totalCellSpacing -= $(this).outerWidth(true); }); return pagewidth - columnsWidth - totalCellSpacing - 15; // 15px extra margin } /** * Reload fields table */ function reloadFieldForm() { $.post($("#fieldsForm").attr('action'), $("#fieldsForm").serialize() + "&ajax_request=true", function (form_data) { var $temp_div = $("<div id='temp_div'><div>").append(form_data.message); $("#fieldsForm").replaceWith($temp_div.find("#fieldsForm")); $("#addColumns").replaceWith($temp_div.find("#addColumns")); $('#move_columns_dialog ul').replaceWith($temp_div.find("#move_columns_dialog ul")); $("#moveColumns").removeClass("move-active"); /* reinitialise the more options in table */ $('#fieldsForm ul.table-structure-actions').menuResizer(PMA_tbl_structure_menu_resizer_callback); }); $('#page_content').show(); } /** * Unbind all event handlers before tearing down a page */ AJAX.registerTeardown('tbl_structure.js', function () { $("a.change_column_anchor.ajax").die('click'); $("button.change_columns_anchor.ajax, input.change_columns_anchor.ajax").die('click'); $("a.drop_column_anchor.ajax").die('click'); $("a.add_primary_key_anchor.ajax").die('click'); $("a.add_index_anchor.ajax").die('click'); $("a.add_unique_anchor.ajax").die('click'); $("#move_columns_anchor").die('click'); $(".append_fields_form.ajax").unbind('submit'); }); AJAX.registerOnload('tbl_structure.js', function () { /** *Ajax action for submitting the "Column Change" and "Add Column" form */ $(".append_fields_form.ajax").die().live('submit', function (event) { event.preventDefault(); /** * @var the_form object referring to the export form */ var $form = $(this); /* * First validate the form; if there is a problem, avoid submitting it * * checkTableEditForm() needs a pure element and not a jQuery object, * this is why we pass $form[0] as a parameter (the jQuery object * is actually an array of DOM elements) */ if (checkTableEditForm($form[0], $form.find('input[name=orig_num_fields]').val())) { // OK, form passed validation step PMA_prepareForAjaxRequest($form); //User wants to submit the form $msg = PMA_ajaxShowMessage(); $.post($form.attr('action'), $form.serialize() + '&do_save_data=1', function (data) { if ($("#sqlqueryresults").length !== 0) { $("#sqlqueryresults").remove(); } else if ($(".error:not(.tab)").length !== 0) { $(".error:not(.tab)").remove(); } if (data.success === true) { $("#page_content") .empty() .append(data.message) .append(data.sql_query) .show(); PMA_highlightSQL($('#page_content')); $("#result_query .notice").remove(); reloadFieldForm(); $form.remove(); PMA_ajaxRemoveMessage($msg); PMA_init_slider(); PMA_reloadNavigation(); } else { PMA_ajaxShowMessage(data.error, false); } }); // end $.post() } }); // end change table button "do_save_data" /** * Attach Event Handler for 'Change Column' */ $("a.change_column_anchor.ajax").live('click', function (event) { event.preventDefault(); var $msg = PMA_ajaxShowMessage(); $('#page_content').hide(); $.get($(this).attr('href'), {'ajax_request': true}, function (data) { PMA_ajaxRemoveMessage($msg); if (data.success) { $('<div id="change_column_dialog" class="margin"></div>') .html(data.message) .insertBefore('#page_content'); PMA_highlightSQL($('#page_content')); PMA_showHints(); PMA_verifyColumnsProperties(); } else { PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest + " : " + data.error, false); } }); }); /** * Attach Event Handler for 'Change multiple columns' */ $("button.change_columns_anchor.ajax, input.change_columns_anchor.ajax").live('click', function (event) { event.preventDefault(); var $msg = PMA_ajaxShowMessage(); $('#page_content').hide(); var $form = $(this).closest('form'); var params = $form.serialize() + "&ajax_request=true&submit_mult=change"; $.post($form.prop("action"), params, function (data) { PMA_ajaxRemoveMessage($msg); if (data.success) { $('#page_content') .empty() .append( $('<div id="change_column_dialog"></div>') .html(data.message) ) .show(); PMA_highlightSQL($('#page_content')); PMA_showHints(); PMA_verifyColumnsProperties(); } else { $('#page_content').show(); PMA_ajaxShowMessage(data.error); } }); }); /** * Attach Event Handler for 'Drop Column' */ $("a.drop_column_anchor.ajax").live('click', function (event) { event.preventDefault(); /** * @var curr_table_name String containing the name of the current table */ var curr_table_name = $(this).closest('form').find('input[name=table]').val(); /** * @var curr_row Object reference to the currently selected row (i.e. field in the table) */ var $curr_row = $(this).parents('tr'); /** * @var curr_column_name String containing name of the field referred to by {@link curr_row} */ var curr_column_name = $curr_row.children('th').children('label').text(); curr_column_name = escapeHtml(curr_column_name); /** * @var $after_field_item Corresponding entry in the 'After' field. */ var $after_field_item = $("select[name='after_field'] option[value='" + curr_column_name + "']"); /** * @var question String containing the question to be asked for confirmation */ var question = $.sprintf(PMA_messages.strDoYouReally, 'ALTER TABLE `' + escapeHtml(curr_table_name) + '` DROP `' + escapeHtml(curr_column_name) + '`;'); $(this).PMA_confirm(question, $(this).attr('href'), function (url) { var $msg = PMA_ajaxShowMessage(PMA_messages.strDroppingColumn, false); $.get(url, {'is_js_confirmed' : 1, 'ajax_request' : true, 'ajax_page_request' : true}, function (data) { if (data.success === true) { PMA_ajaxRemoveMessage($msg); if ($('#result_query').length) { $('#result_query').remove(); } if (data.sql_query) { $('<div id="result_query"></div>') .html(data.sql_query) .prependTo('#page_content'); PMA_highlightSQL($('#page_content')); } toggleRowColors($curr_row.next()); // Adjust the row numbers for (var $row = $curr_row.next(); $row.length > 0; $row = $row.next()) { var new_val = parseInt($row.find('td:nth-child(2)').text(), 10) - 1; $row.find('td:nth-child(2)').text(new_val); } $after_field_item.remove(); $curr_row.hide("medium").remove(); //refresh table stats if (data.tableStat) { $('#tablestatistics').html(data.tableStat); } // refresh the list of indexes (comes from sql.php) $('.index_info').replaceWith(data.indexes_list); PMA_reloadNavigation(); } else { PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest + " : " + data.error, false); } }); // end $.get() }); // end $.PMA_confirm() }); //end of Drop Column Anchor action /** * Ajax Event handler for 'Add Primary Key' */ $("a.add_primary_key_anchor.ajax").live('click', function (event) { event.preventDefault(); /** * @var curr_table_name String containing the name of the current table */ var curr_table_name = $(this).closest('form').find('input[name=table]').val(); /** * @var curr_column_name String containing name of the field referred to by {@link curr_row} */ var curr_column_name = $(this).parents('tr').children('th').children('label').text(); /** * @var question String containing the question to be asked for confirmation */ var question = $.sprintf(PMA_messages.strDoYouReally, 'ALTER TABLE `' + escapeHtml(curr_table_name) + '` ADD PRIMARY KEY(`' + escapeHtml(curr_column_name) + '`);'); $(this).PMA_confirm(question, $(this).attr('href'), function (url) { var $msg = PMA_ajaxShowMessage(PMA_messages.strAddingPrimaryKey, false); $.get(url , {'is_js_confirmed' : 1, 'ajax_request' : true, 'index_change' : true} , function (data) { if (data.success === true) { PMA_ajaxRemoveMessage($msg); $(this).remove(); if (typeof data.reload != 'undefined') { PMA_commonActions.refreshMain(false, function () { if ($('#result_query').length) { $('#result_query').remove(); } if (data.sql_query) { $('<div id="result_query"></div>') .html(data.sql_query) .prependTo('#page_content'); PMA_highlightSQL($('#page_content')); } }); PMA_reloadNavigation(); } if (data.indexes_list) { $('.index_info').replaceWith(data.indexes_list); } } else { PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest + " : " + data.error, false); } }); // end $.get() }); // end $.PMA_confirm() }); //end Add Primary Key /** * Ajax Event handler for 'Add Index' */ $("a.add_index_anchor.ajax").live('click', function (event) { event.preventDefault(); /** * @var curr_table_name String containing the name of the current table */ var curr_table_name = $(this).closest('form').find('input[name=table]').val(); /** * @var curr_column_name String containing name of the field referred to by {@link curr_row} */ var curr_column_name = $(this).parents('tr').children('th').children('label').text(); /** * @var question String containing the question to be asked for confirmation */ var question = $.sprintf(PMA_messages.strDoYouReally, 'ALTER TABLE `' + escapeHtml(curr_table_name) + '` ADD INDEX(`' + escapeHtml(curr_column_name) + '`);'); $(this).PMA_confirm(question, $(this).attr('href'), function (url) { var $msg = PMA_ajaxShowMessage(PMA_messages.strAddingIndex, false); $.get(url , {'is_js_confirmed' : 1, 'ajax_request' : true, 'index_change' : true} , function (data) { if (data.success === true) { PMA_ajaxRemoveMessage($msg); if ($('#result_query').length) { $('#result_query').remove(); } if (data.sql_query) { $('<div id="result_query"></div>') .html(data.sql_query) .prependTo('#page_content'); PMA_highlightSQL($('#page_content')); } if (data.indexes_list) { $('.index_info').replaceWith(data.indexes_list); } PMA_reloadNavigation(); } else { PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest + " : " + data.error, false); } }); // end $.get() }); // end $.PMA_confirm() }); //end Add Index /** * Ajax Event handler for 'Add Unique' */ $("a.add_unique_anchor.ajax").live('click', function (event) { event.preventDefault(); /** * @var curr_table_name String containing the name of the current table */ var curr_table_name = $(this).closest('form').find('input[name=table]').val(); /** * @var curr_column_name String containing name of the field referred to by {@link curr_row} */ var curr_column_name = $(this).parents('tr').children('th').children('label').text(); /** * @var question String containing the question to be asked for confirmation */ var question = $.sprintf(PMA_messages.strDoYouReally, 'ALTER TABLE `' + escapeHtml(curr_table_name) + '` ADD UNIQUE(`' + escapeHtml(curr_column_name) + '`);'); $(this).PMA_confirm(question, $(this).attr('href'), function (url) { var $msg = PMA_ajaxShowMessage(PMA_messages.strAddingUnique, false); $.get(url , {'is_js_confirmed' : 1, 'ajax_request' : true, 'index_change' : true} , function (data) { if (data.success === true) { PMA_ajaxRemoveMessage($msg); if ($('#result_query').length) { $('#result_query').remove(); } if (data.sql_query) { $('<div id="result_query"></div>') .html(data.sql_query) .prependTo('#page_content'); PMA_highlightSQL($('#page_content')); } if (data.indexes_list) { $('.index_info').replaceWith(data.indexes_list); } PMA_reloadNavigation(); } else { PMA_ajaxShowMessage(PMA_messages.strErrorProcessingRequest + " : " + data.error, false); } }); // end $.get() }); // end $.PMA_confirm() }); //end Add Unique /** * Inline move columns **/ $("#move_columns_anchor").live('click', function (e) { e.preventDefault(); if ($(this).hasClass("move-active")) { return; } /** * @var button_options Object that stores the options passed to jQueryUI * dialog */ var button_options = {}; button_options[PMA_messages.strGo] = function (event) { event.preventDefault(); var $msgbox = PMA_ajaxShowMessage(); var $this = $(this); var $form = $this.find("form"); var serialized = $form.serialize(); // check if any columns were moved at all if (serialized == $form.data("serialized-unmoved")) { PMA_ajaxRemoveMessage($msgbox); $this.dialog('close'); return; } $.post($form.prop("action"), serialized + "&ajax_request=true", function (data) { if (data.success === false) { PMA_ajaxRemoveMessage($msgbox); $this .clone() .html(data.error) .dialog({ title: $(this).prop("title"), height: 230, width: 900, modal: true, buttons: button_options_error }); // end dialog options } else { $('#fieldsForm ul.table-structure-actions').menuResizer('destroy'); // sort the fields table var $fields_table = $("table#tablestructure tbody"); // remove all existing rows and remember them var $rows = $fields_table.find("tr").remove(); // loop through the correct order for (var i in data.columns) { var the_column = data.columns[i]; var $the_row = $rows .find("input:checkbox[value=" + the_column + "]") .closest("tr"); // append the row for this column to the table $fields_table.append($the_row); } var $firstrow = $fields_table.find("tr").eq(0); // Adjust the row numbers and colors for (var $row = $firstrow; $row.length > 0; $row = $row.next()) { $row .find('td:nth-child(2)') .text($row.index() + 1) .end() .removeClass("odd even") .addClass($row.index() % 2 === 0 ? "odd" : "even"); } PMA_ajaxShowMessage(data.message); $this.dialog('close'); $('#fieldsForm ul.table-structure-actions').menuResizer(PMA_tbl_structure_menu_resizer_callback); } }); }; button_options[PMA_messages.strCancel] = function () { $(this).dialog('close'); }; var button_options_error = {}; button_options_error[PMA_messages.strOK] = function () { $(this).dialog('close').remove(); }; var columns = []; $("#tablestructure tbody tr").each(function () { var col_name = $(this).find("input:checkbox").eq(0).val(); var hidden_input = $("<input/>") .prop({ name: "move_columns[]", type: "hidden" }) .val(col_name); columns[columns.length] = $("<li/>") .addClass("placeholderDrag") .text(col_name) .append(hidden_input); }); var col_list = $("#move_columns_dialog ul") .find("li").remove().end(); for (var i in columns) { col_list.append(columns[i]); } col_list.sortable({ axis: 'y', containment: $("#move_columns_dialog div"), tolerance: 'pointer' }).disableSelection(); var $form = $("#move_columns_dialog form"); $form.data("serialized-unmoved", $form.serialize()); $("#move_columns_dialog").dialog({ modal: true, buttons: button_options, beforeClose: function () { $("#move_columns_anchor").removeClass("move-active"); } }); }); }); /** Handler for "More" dropdown in structure table rows */ AJAX.registerOnload('tbl_structure.js', function () { if ($('#fieldsForm').hasClass('HideStructureActions')) { $('#fieldsForm ul.table-structure-actions').menuResizer(PMA_tbl_structure_menu_resizer_callback); } }); AJAX.registerTeardown('tbl_structure.js', function () { $('#fieldsForm ul.table-structure-actions').menuResizer('destroy'); }); $(function () { $(window).resize($.throttle(function () { var $list = $('#fieldsForm ul.table-structure-actions'); if ($list.length) { $list.menuResizer('resize'); } })); }); |
:: Command execute :: | |
--[ c99shell v. 1.0 pre-release build #13 powered by Captain Crunch Security Team | http://ccteam.ru | Generation time: 0.0312 ]-- |