Server IP : 85.214.239.14 / Your IP : 3.145.161.199 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/3/task/3/cwd/var/www/wordpress/phpMyAdmin/js/ |
Upload File : |
/* vim: set expandtab sw=4 ts=4 sts=4: */ /* This script handles PMA Drag Drop Import, loaded only when configuration is enabled.*/ /** * Class to handle PMA Drag and Drop Import * feature */ var DragDropImport = { /** * @var int, count of total uploads in this view */ uploadCount: 0, /** * @var int, count of live uploads */ liveUploadCount: 0, /** * @var string array, allowed extensions */ allowedExtensions: ['sql', 'xml', 'ldi', 'mediawiki', 'shp'], /** * @var string array, allowed extensions for compressed files */ allowedCompressedExtensions: ['gz', 'bz2', 'zip'], /** * @var obj array to store message returned by import_status.php */ importStatus: [], /** * Checks if any dropped file has valid extension or not * * @param file filename * * @return string, extension for valid extension, '' otherwise */ getExtension: function (file) { var arr = file.split('.'); var ext = arr[arr.length - 1]; // check if compressed if (jQuery.inArray(ext.toLowerCase(), DragDropImport.allowedCompressedExtensions) !== -1) { ext = arr[arr.length - 2]; } // Now check for extension if (jQuery.inArray(ext.toLowerCase(), DragDropImport.allowedExtensions) !== -1) { return ext; } return ''; }, /** * Shows upload progress for different sql uploads * * @param: hash (string), hash for specific file upload * @param: percent (float), file upload percentage * * @return void */ setProgress: function (hash, percent) { $('.pma_sql_import_status div li[data-hash="' + hash + '"]') .children('progress').val(percent); }, /** * Function to upload the file asynchronously * * @param formData FormData object for a specific file * @param hash hash of the current file upload * * @return void */ sendFileToServer: function (formData, hash) { var uploadURL = './import.php'; // Upload URL var jqXHR = $.ajax({ xhr: function () { var xhrobj = $.ajaxSettings.xhr(); if (xhrobj.upload) { xhrobj.upload.addEventListener('progress', function (event) { var percent = 0; var position = event.loaded || event.position; var total = event.total; if (event.lengthComputable) { percent = Math.ceil(position / total * 100); } // Set progress DragDropImport.setProgress(hash, percent); }, false); } return xhrobj; }, url: uploadURL, type: 'POST', contentType:false, processData: false, cache: false, data: formData, success: function (data) { DragDropImport.importFinished(hash, false, data.success); if (!data.success) { DragDropImport.importStatus[DragDropImport.importStatus.length] = { hash: hash, message: data.error }; } } }); // -- provide link to cancel the upload $('.pma_sql_import_status div li[data-hash="' + hash + '"] span.filesize').html('<span hash="' + hash + '" class="pma_drop_file_status" task="cancel">' + Messages.dropImportMessageCancel + '</span>'); // -- add event listener to this link to abort upload operation $('.pma_sql_import_status div li[data-hash="' + hash + '"] span.filesize span.pma_drop_file_status') .on('click', function () { if ($(this).attr('task') === 'cancel') { jqXHR.abort(); $(this).html('<span>' + Messages.dropImportMessageAborted + '</span>'); DragDropImport.importFinished(hash, true, false); } else if ($(this).children('span').html() === Messages.dropImportMessageFailed) { // -- view information var $this = $(this); $.each(DragDropImport.importStatus, function (key, value) { if (value.hash === hash) { $('.pma_drop_result:visible').remove(); var filename = $this.parent('span').attr('data-filename'); $('body').append('<div class="pma_drop_result"><h2>' + Messages.dropImportImportResultHeader + ' - ' + filename + '<span class="close">x</span></h2>' + value.message + '</div>'); $('.pma_drop_result').draggable(); // to make this dialog draggable } }); } }); }, /** * Triggered when an object is dragged into the PMA UI * * @param event obj * * @return void */ dragEnter : function (event) { // We don't want to prevent users from using // browser's default drag-drop feature on some page(s) if ($('.noDragDrop').length !== 0) { return; } event.stopPropagation(); event.preventDefault(); if (!DragDropImport.hasFiles(event)) { return; } if (CommonParams.get('db') === '') { $('.pma_drop_handler').html(Messages.dropImportSelectDB); } else { $('.pma_drop_handler').html(Messages.dropImportDropFiles); } $('.pma_drop_handler').fadeIn(); }, /** * Check if dragged element contains Files * * @param event the event object * * @return bool */ hasFiles: function (event) { return !(typeof event.originalEvent.dataTransfer.types === 'undefined' || $.inArray('Files', event.originalEvent.dataTransfer.types) < 0 || $.inArray( 'application/x-moz-nativeimage', event.originalEvent.dataTransfer.types ) >= 0); }, /** * Triggered when dragged file is being dragged over PMA UI * * @param event obj * * @return void */ dragOver: function (event) { // We don't want to prevent users from using // browser's default drag-drop feature on some page(s) if ($('.noDragDrop').length !== 0) { return; } event.stopPropagation(); event.preventDefault(); if (!DragDropImport.hasFiles(event)) { return; } $('.pma_drop_handler').fadeIn(); }, /** * Triggered when dragged objects are left * * @param event obj * * @return void */ dragLeave: function (event) { // We don't want to prevent users from using // browser's default drag-drop feature on some page(s) if ($('.noDragDrop').length !== 0) { return; } event.stopPropagation(); event.preventDefault(); var $dropHandler = $('.pma_drop_handler'); $dropHandler.clearQueue().stop(); $dropHandler.fadeOut(); $dropHandler.html(Messages.dropImportDropFiles); }, /** * Called when upload has finished * * @param string, unique hash for a certain upload * @param bool, true if upload was aborted * @param bool, status of sql upload, as sent by server * * @return void */ importFinished: function (hash, aborted, status) { $('.pma_sql_import_status div li[data-hash="' + hash + '"]') .children('progress').hide(); var icon = 'icon ic_s_success'; // -- provide link to view upload status if (!aborted) { if (status) { $('.pma_sql_import_status div li[data-hash="' + hash + '"] span.filesize span.pma_drop_file_status') .html('<span>' + Messages.dropImportMessageSuccess + '</a>'); } else { $('.pma_sql_import_status div li[data-hash="' + hash + '"] span.filesize span.pma_drop_file_status') .html('<span class="underline">' + Messages.dropImportMessageFailed + '</a>'); icon = 'icon ic_s_error'; } } else { icon = 'icon ic_s_notice'; } $('.pma_sql_import_status div li[data-hash="' + hash + '"] span.filesize span.pma_drop_file_status') .attr('task', 'info'); // Set icon $('.pma_sql_import_status div li[data-hash="' + hash + '"]') .prepend('<img src="./themes/dot.gif" title="finished" class="' + icon + '"> '); // Decrease liveUploadCount by one $('.pma_import_count').html(--DragDropImport.liveUploadCount); if (!DragDropImport.liveUploadCount) { $('.pma_sql_import_status h2 .close').fadeIn(); } }, /** * Triggered when dragged objects are dropped to UI * From this function, the AJAX Upload operation is initiated * * @param event object * * @return void */ drop: function (event) { // We don't want to prevent users from using // browser's default drag-drop feature on some page(s) if ($('.noDragDrop').length !== 0) { return; } var dbname = CommonParams.get('db'); var server = CommonParams.get('server'); // if no database is selected -- no if (dbname !== '') { var files = event.originalEvent.dataTransfer.files; if (!files || files.length === 0) { // No files actually transferred $('.pma_drop_handler').fadeOut(); event.stopPropagation(); event.preventDefault(); return; } $('.pma_sql_import_status').slideDown(); for (var i = 0; i < files.length; i++) { var ext = (DragDropImport.getExtension(files[i].name)); var hash = AJAX.hash(++DragDropImport.uploadCount); var $sqlImportStatusDiv = $('.pma_sql_import_status div'); $sqlImportStatusDiv.append('<li data-hash="' + hash + '">' + ((ext !== '') ? '' : '<img src="./themes/dot.gif" title="invalid format" class="icon ic_s_notice"> ') + Functions.escapeHtml(files[i].name) + '<span class="filesize" data-filename="' + Functions.escapeHtml(files[i].name) + '">' + (files[i].size / 1024).toFixed(2) + ' kb</span></li>'); // scroll the UI to bottom $sqlImportStatusDiv.scrollTop( $sqlImportStatusDiv.scrollTop() + 50 ); // 50 hardcoded for now if (ext !== '') { // Increment liveUploadCount by one $('.pma_import_count').html(++DragDropImport.liveUploadCount); $('.pma_sql_import_status h2 .close').fadeOut(); $('.pma_sql_import_status div li[data-hash="' + hash + '"]') .append('<br><progress max="100" value="2"></progress>'); // uploading var fd = new FormData(); fd.append('import_file', files[i]); fd.append('noplugin', Math.random().toString(36).substring(2, 12)); fd.append('db', dbname); fd.append('server', server); fd.append('token', CommonParams.get('token')); fd.append('import_type', 'database'); // todo: method to find the value below fd.append('MAX_FILE_SIZE', '4194304'); // todo: method to find the value below fd.append('charset_of_file','utf-8'); // todo: method to find the value below fd.append('allow_interrupt', 'yes'); fd.append('skip_queries', '0'); fd.append('format',ext); fd.append('sql_compatibility','NONE'); fd.append('sql_no_auto_value_on_zero','something'); fd.append('ajax_request','true'); fd.append('hash', hash); // init uploading DragDropImport.sendFileToServer(fd, hash); } else if (!DragDropImport.liveUploadCount) { $('.pma_sql_import_status h2 .close').fadeIn(); } } } $('.pma_drop_handler').fadeOut(); event.stopPropagation(); event.preventDefault(); } }; /** * Called when some user drags, dragover, leave * a file to the PMA UI * @param object Event data * @return void */ $(document).on('dragenter', DragDropImport.dragEnter); $(document).on('dragover', DragDropImport.dragOver); $(document).on('dragleave', '.pma_drop_handler', DragDropImport.dragLeave); // when file is dropped to PMA UI $(document).on('drop', 'body', DragDropImport.drop); // minimizing-maximising the sql ajax upload status $(document).on('click', '.pma_sql_import_status h2 .minimize', function () { if ($(this).attr('toggle') === 'off') { $('.pma_sql_import_status div').css('height','270px'); $(this).attr('toggle','on'); $(this).html('-'); // to minimize } else { $('.pma_sql_import_status div').css('height','0px'); $(this).attr('toggle','off'); $(this).html('+'); // to maximise } }); // closing sql ajax upload status $(document).on('click', '.pma_sql_import_status h2 .close', function () { $('.pma_sql_import_status').fadeOut(function () { $('.pma_sql_import_status div').html(''); DragDropImport.importStatus = []; // clear the message array }); }); // Closing the import result box $(document).on('click', '.pma_drop_result h2 .close', function () { $(this).parent('h2').parent('div').remove(); });