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: */ /** * for tbl_relation.php * */ function show_hide_clauses($thisDropdown) { if ($thisDropdown.val() === '') { $thisDropdown.parent().nextAll('span').hide(); } else { if ($thisDropdown.is('select[name^="destination_foreign_column"]')) { $thisDropdown.parent().nextAll('span').show(); } } } /** * Sets dropdown options to values */ function setDropdownValues($dropdown, values) { $dropdown.empty(); var optionsAsString = ''; // add an empty string to the beginning for empty selection values.unshift(''); $.each(values, function () { optionsAsString += "<option value='" + this + "'>" + this + "</option>"; }); $dropdown.append($(optionsAsString)); } /** * Retrieves and populates dropdowns to the left based on the selected value * * @param $dropdown the dropdown whose value got changed */ function getDropdownValues($dropdown) { var foreignDb = null, foreignTable = null; var $tableDd, $columnDd; var foreign = ''; // if the changed dropdown is for foreign key constraints if ($dropdown.is('select[name^="destination_foreign"]')) { $tableDd = $dropdown.parent().find('select[name^="destination_foreign_table"]'); $columnDd = $dropdown.parent().find('select[name^="destination_foreign_column"]'); foreign = '_foreign'; } else { // internal relations $tableDd = $dropdown.parent().find('select[name^="destination_table"]'); $columnDd = $dropdown.parent().find('select[name^="destination_column"]'); } // if the changed dropdown is a database selector if ($dropdown.is('select[name^="destination' + foreign + '_db"]')) { foreignDb = $dropdown.val(); // if no database is selected empty table and column dropdowns if (foreignDb === '') { setDropdownValues($tableDd, []); setDropdownValues($columnDd, []); return; } } else { // if a table selector foreignDb = $dropdown.parent() .find('select[name^="destination' + foreign + '_db"]').val(); foreignTable = $dropdown.val(); // if no table is selected empty the column dropdown if (foreignTable === '') { setDropdownValues($columnDd, []); return; } } var $msgbox = PMA_ajaxShowMessage(); var $form = $dropdown.parents('form'); var url = 'tbl_relation.php?getDropdownValues=true&ajax_request=true' + '&token=' + $form.find('input[name="token"]').val() + '&db=' + $form.find('input[name="db"]').val() + '&table=' + $form.find('input[name="table"]').val() + '&foreign=' + (foreign !== '') + '&foreignDb=' + encodeURIComponent(foreignDb) + (foreignTable !== null ? '&foreignTable=' + encodeURIComponent(foreignTable) : '' ); var $server = $form.find('input[name="server"]'); if ($server.length > 0) { url += '&server=' + $form.find('input[name="server"]').val(); } $.ajax({ url: url, datatype: 'json', success: function (data) { PMA_ajaxRemoveMessage($msgbox); if (data.success) { // if the changed dropdown is a database selector if (foreignTable === null) { // set values for table and column dropdowns setDropdownValues($tableDd, data.tables); setDropdownValues($columnDd, []); } else { // if a table selector // set values for the column dropdown setDropdownValues($columnDd, data.columns); } } else { PMA_ajaxShowMessage(data.error, false); } } }); } /** * Unbind all event handlers before tearing down a page */ AJAX.registerTeardown('tbl_relation.js', function () { $('select[name^="destination_foreign"]').unbind('change'); $('select[name^="destination_db"],' + ' select[name^="destination_table"],' + ' select[name^="destination_foreign_db"],' + ' select[name^="destination_foreign_table"]' ).unbind('change'); }); AJAX.registerOnload('tbl_relation.js', function () { // initial display $('select[name^="destination_foreign_column"]').each(function (index, one_dropdown) { show_hide_clauses($(one_dropdown)); }); // change $('select[name^="destination_foreign"]').change(function () { show_hide_clauses($(this)); }); $('select[name^="destination_db"],' + ' select[name^="destination_table"],' + ' select[name^="destination_foreign_db"],' + ' select[name^="destination_foreign_table"]' ).change(function () { getDropdownValues($(this)); }); }); |
:: Command execute :: | |
--[ c99shell v. 1.0 pre-release build #13 powered by Captain Crunch Security Team | http://ccteam.ru | Generation time: 0.0156 ]-- |