' . "\n"; return $html; } /** * Prints Html For Import Javascript * * @param int $upload_id The selected upload id * * @return string */ function PMA_getHtmlForImportJS($upload_id) { global $SESSION_KEY; $html = ''; $html .= ''; return $html; } /** * Prints Html For Display Export options * * @param String $import_type Import type: server, database, table * @param String $db Selected DB * @param String $table Selected Table * * @return string */ function PMA_getHtmlForImportOptions($import_type, $db, $table) { $html = ' '; return $html; } /** * Prints Html For Display Import options : Compressions * * @return string */ function PMA_getHtmlForImportCompressions() { global $cfg; $html = ''; // zip, gzip and bzip2 encode features $compressions = array(); if ($cfg['GZipDump'] && @function_exists('gzopen')) { $compressions[] = 'gzip'; } if ($cfg['BZipDump'] && @function_exists('bzopen')) { $compressions[] = 'bzip2'; } if ($cfg['ZipDump'] && @function_exists('zip_open')) { $compressions[] = 'zip'; } // We don't have show anything about compression, when no supported if ($compressions != array()) { $html .= '
'; $compress_str = sprintf( __('File may be compressed (%s) or uncompressed.'), implode(", ", $compressions) ); $html .= $compress_str; $html .= '
'; $html .= __( 'A compressed file\'s name must end in .[format].[compression]. ' . 'Example: .sql.zip' ); $html .= '
'; } return $html; } /** * Prints Html For Display Import charset * * @return string */ function PMA_getHtmlForImportCharset() { global $cfg; $html = '
'; // charset of file if ($GLOBALS['PMA_recoding_engine'] != PMA_CHARSET_NONE) { $html .= ''; reset($cfg['AvailableCharsets']); $html .= '
'; } else { $html .= '' . "\n"; $html .= PMA_generateCharsetDropdownBox( PMA_CSDROPDOWN_CHARSET, 'charset_of_file', 'charset_of_file', 'utf8', false ); } // end if (recoding) $html .= '
'; return $html; } /** * Prints Html For Display Import options : file property * * @param int $max_upload_size Max upload size * @param Array $import_list import list * * @return string */ function PMA_getHtmlForImportOptionsFile($max_upload_size, $import_list) { global $cfg; $html = '
'; $html .= '

' . __('File to Import:') . '

'; $html .= PMA_getHtmlForImportCompressions(); $html .= '
'; if ($GLOBALS['is_upload'] && !empty($cfg['UploadDir'])) { $html .= ' '; } elseif ($GLOBALS['is_upload']) { $html .= PMA_Util::getBrowseUploadFileBlock($max_upload_size); $html .= '
' . __('You may also drag and drop a file on any page.'); } elseif (!$GLOBALS['is_upload']) { $html .= PMA_Message::notice( __('File uploads are not allowed on this server.') )->getDisplay(); } elseif (!empty($cfg['UploadDir'])) { $html .= PMA_Util::getSelectUploadFileBlock($import_list, $cfg['UploadDir']); } // end if (web-server upload directory) $html .= '
'; $html .= PMA_getHtmlForImportCharset(); $html .= '
'; return $html; } /** * Prints Html For Display Import options : Partial Import * * @param String $timeout_passed timeout passed * @param String $offset timeout offset * * @return string */ function PMA_getHtmlForImportOptionsPartialImport($timeout_passed, $offset) { $html = '
'; $html .= '

' . __('Partial Import:') . '

'; if (isset($timeout_passed) && $timeout_passed) { $html .= '
' . "\n"; $html .= ''; $html .= sprintf( __( 'Previous import timed out, after resubmitting ' . 'will continue from position %d.' ), $offset ); $html .= '
' . "\n"; } $html .= '
'; $html .= ' '; $html .= '
'; $html .= '
'; if (! (isset($timeout_passed) && $timeout_passed)) { $html .= '
'; $html .= ' '; $html .= ' '; $html .= '
'; } else { // If timeout has passed, // do not show the Skip dialog to avoid the risk of someone // entering a value here that would interfere with "skip" $html .= ' '; } $html .= '
'; return $html; } /** * Prints Html For Display Import options : Format * * @param Array $import_list import list * * @return string */ function PMA_getHtmlForImportOptionsFormat($import_list) { $html = '
'; $html .= '

' . __('Format:') . '

'; $html .= PMA_pluginGetChoice('Import', 'format', $import_list); $html .= '
'; $html .= '
'; $html .= '
'; $html .= '

' . __('Format-Specific Options:') . '

'; $html .= '

' . 'Scroll down to fill in the options for the selected format ' . 'and ignore the options for other formats.

'; $html .= PMA_pluginGetOptions('Import', $import_list); $html .= '
'; $html .= '
'; // Encoding setting form appended by Y.Kawada if (function_exists('PMA_Kanji_encodingForm')) { $html .= '
'; $html .= '

' . __('Encoding Conversion:') . '

'; $html .= PMA_Kanji_encodingForm(); $html .= '
'; } $html .= "\n"; return $html; } /** * Prints Html For Display Import options : submit * * @return string */ function PMA_getHtmlForImportOptionsSubmit() { $html = '
'; $html .= ' '; $html .= '
'; return $html; } /** * Prints Html For Display Import * * @param int $upload_id The selected upload id * @param String $import_type Import type: server, database, table * @param String $db Selected DB * @param String $table Selected Table * @param int $max_upload_size Max upload size * @param Array $import_list Import list * @param String $timeout_passed Timeout passed * @param String $offset Timeout offset * * @return string */ function PMA_getHtmlForImport( $upload_id, $import_type, $db, $table, $max_upload_size, $import_list, $timeout_passed, $offset ) { global $SESSION_KEY; $html = ''; $html .= ''; $html .= ''; $html .= '
'; $html .= ' ajax clock'; $html .= PMA_getHtmlForImportJS($upload_id); $html .= '
'; $html .= PMA_getHtmlForHiddenInputs($import_type, $db, $table); $html .= PMA_getHtmlForImportOptions($import_type, $db, $table); $html .= PMA_getHtmlForImportOptionsFile($max_upload_size, $import_list); $html .= PMA_getHtmlForImportOptionsPartialImport($timeout_passed, $offset); $html .= PMA_getHtmlForImportOptionsFormat($import_list); $html .= PMA_getHtmlForImportOptionsSubmit(); $html .= '
'; $html .= '
'; return $html; } /** * Prints javascript for upload with plugin, upload process bar * * @param int $upload_id The selected upload id * * @return string */ function PMA_getHtmlForImportWithPlugin($upload_id) { //some variable for javascript $ajax_url = "import_status.php?id=" . $upload_id . "&" . PMA_URL_getCommon(array('import_status'=>1), 'text'); $promot_str = PMA_jsFormat( __( 'The file being uploaded is probably larger than ' . 'the maximum allowed size or this is a known bug in webkit ' . 'based (Safari, Google Chrome, Arora etc.) browsers.' ), false ); $statustext_str = PMA_escapeJsString(__('%s of %s')); $upload_str = PMA_jsFormat(__('Uploading your import fileā€¦'), false); $second_str = PMA_jsFormat(__('%s/sec.'), false); $remaining_min = PMA_jsFormat(__('About %MIN min. %SEC sec. remaining.'), false); $remaining_second = PMA_jsFormat(__('About %SEC sec. remaining.'), false); $processed_str = PMA_jsFormat( __('The file is being processed, please be patient.'), false ); $import_url = PMA_URL_getCommon(array('import_status'=>1), 'text'); //start output $html = 'var finished = false; '; $html .= 'var percent = 0.0; '; $html .= 'var total = 0; '; $html .= 'var complete = 0; '; $html .= 'var original_title = ' . 'parent && parent.document ? parent.document.title : false; '; $html .= 'var import_start; '; $html .= 'var perform_upload = function () { '; $html .= 'new $.getJSON( '; $html .= ' "' . $ajax_url . '", '; $html .= ' {}, '; $html .= ' function(response) { '; $html .= ' finished = response.finished; '; $html .= ' percent = response.percent; '; $html .= ' total = response.total; '; $html .= ' complete = response.complete; '; $html .= ' if (total==0 && complete==0 && percent==0) { '; $img_tag = 'ajax clock ' . $promot_str . '\'); '; $html .= ' $("#upload_form_status").css("display", "none"); '; $html .= ' } else { '; $html .= ' var now = new Date(); '; $html .= ' now = Date.UTC( '; $html .= ' now.getFullYear(), '; $html .= ' now.getMonth(), '; $html .= ' now.getDate(), '; $html .= ' now.getHours(), '; $html .= ' now.getMinutes(), '; $html .= ' now.getSeconds()) '; $html .= ' + now.getMilliseconds() - 1000; '; $html .= ' var statustext = PMA_sprintf('; $html .= ' "' . $statustext_str . '", '; $html .= ' formatBytes( '; $html .= ' complete, 1, PMA_messages.strDecimalSeparator'; $html .= ' ), '; $html .= ' formatBytes('; $html .= ' total, 1, PMA_messages.strDecimalSeparator'; $html .= ' ) '; $html .= ' ); '; $html .= ' if ($("#importmain").is(":visible")) { '; // show progress UI $html .= ' $("#importmain").hide(); '; $html .= ' $("#import_form_status") '; $html .= ' .html(\'
' . '
' . '
' . '
' . 'ajax clock ' . $upload_str . '
\') '; $html .= ' .show(); '; $html .= ' import_start = now; '; $html .= ' } '; $html .= ' else if (percent > 9 || complete > 2000000) { '; // calculate estimated time $html .= ' var used_time = now - import_start; '; $html .= ' var seconds = ' . 'parseInt(((total - complete) / complete) * used_time / 1000); '; $html .= ' var speed = PMA_sprintf("' . $second_str . '"'; $html .= ' , formatBytes(complete / used_time * 1000, 1,' . ' PMA_messages.strDecimalSeparator)); '; $html .= ' var minutes = parseInt(seconds / 60); '; $html .= ' seconds %= 60; '; $html .= ' var estimated_time; '; $html .= ' if (minutes > 0) { '; $html .= ' estimated_time = "' . $remaining_min . '"'; $html .= ' .replace("%MIN", minutes)'; $html .= ' .replace("%SEC", seconds); '; $html .= ' } '; $html .= ' else { '; $html .= ' estimated_time = "' . $remaining_second . '"'; $html .= ' .replace("%SEC", seconds); '; $html .= ' } '; $html .= ' statustext += "
" + speed + "

" ' . '+ estimated_time; '; $html .= ' } '; $html .= ' var percent_str = Math.round(percent) + "%"; '; $html .= ' $("#status").animate({width: percent_str}, 150); '; $html .= ' $(".percentage").text(percent_str); '; // show percent in window title $html .= ' if (original_title !== false) { '; $html .= ' parent.document.title '; $html .= ' = percent_str + " - " + original_title; '; $html .= ' } '; $html .= ' else { '; $html .= ' document.title '; $html .= ' = percent_str + " - " + original_title; '; $html .= ' } '; $html .= ' $("#statustext").html(statustext); '; $html .= ' } '; $html .= ' if (finished == true) { '; $html .= ' if (original_title !== false) { '; $html .= ' parent.document.title = original_title; '; $html .= ' } '; $html .= ' else { '; $html .= ' document.title = original_title; '; $html .= ' } '; $html .= ' $("#importmain").hide(); '; // loads the message, either success or mysql error $html .= ' $("#import_form_status") '; $html .= ' .html(\'ajax clock ' . $processed_str . '\')'; $html .= ' .show(); '; $html .= ' $("#import_form_status").load("import_status.php?' . 'message=true&' . $import_url . '"); '; $html .= ' PMA_reloadNavigation(); '; // if finished $html .= ' } '; $html .= ' else { '; $html .= ' setTimeout(perform_upload, 1000); '; $html .= ' } '; $html .= '}); '; $html .= '}; '; $html .= 'setTimeout(perform_upload, 1000); '; return $html; } ?>