= 7)) ? "\n" . ' onfocus="if (typeof(document.layers) == \'undefined\' || typeof(textarea_selected) == \'undefined\') {textarea_selected = 1; document.sqlform.elements[\'sql_query\'].select();}"' : ''; $auto_sel .= ' ' . $locking; // garvin: If non-JS query window is embedded, display a list of databases to choose from. // Apart from that, a non-js query window sucks badly. /** * Get the list and number of available databases. */ if ($server > 0) { PMA_availableDatabases(); // this function is defined in "common.lib.php" } else { $num_dbs = 0; } if ($cfg['QueryFrame'] && (!$cfg['QueryFrameJS'] && !$db || ($cfg['QueryFrameJS'] && !$db))) { if ($num_dbs > 0) { $queryframe_db_list = ' '; $queryframe_thcolspan = ' colspan="2"'; $queryframe_tdcolspan = ''; } else { $queryframe_db_list = ''; $queryframe_thcolspan = ' colspan="3"'; $queryframe_tdcolspan = ' colspan="2"'; } } else { $queryframe_db_list = ''; if ($num_dbs > 0) { $queryframe_thcolspan = ' colspan="3"'; $queryframe_tdcolspan = ' colspan="2"'; } else { $queryframe_thcolspan = ' colspan="2"'; $queryframe_tdcolspan = ''; } } $form_items = 0; // ($is_upload defined in common.lib.php) if ($cfg['QueryFrame'] && $cfg['QueryFrameJS'] && isset($is_inside_querywindow) && $is_inside_querywindow) { ?> ' . "\n" . '

' . "\n" . ' '; } else { ?> onsubmit="return checkSqlQuery(this)" name="sqlform" style="padding: 0px; magin: 0px;"> ' . "\n" . ' ' . PMA_generate_common_hidden_inputs($db, $table) . "\n" . ' '. "\n" . ' '. "\n" . ' '. "\n" . ' '. "\n"; if (!isset($is_inside_querywindow) || (isset($is_inside_querywindow) && $is_inside_querywindow == TRUE && isset($querydisplay_tab) && ($querydisplay_tab == 'sql' || $querydisplay_tab == 'full'))) { ?> ' . "\n"; } ?> 0) { ?> 0) { ?> >
' . "\n"; $querybox_hidden_fields .= ' ' . "\n"; } // loic1: displays import dump feature only if file upload available if ($is_upload && (!isset($is_inside_querywindow) || (isset($is_inside_querywindow) && $is_inside_querywindow == TRUE && isset($querydisplay_tab) && ($querydisplay_tab == 'files' || $querydisplay_tab == 'full')))) { $form_items++; ?> > > : >
' . "\n"; } $is_gzip = ($cfg['GZipDump'] && @function_exists('gzopen')); $is_bzip = ($cfg['BZipDump'] && @function_exists('bzdecompress')); if ($is_bzip || $is_gzip) { echo ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . "\n" . '   '. $strCompression . ':
  ' . "\n" . '   ' . '' . $strAutodetect . '  ' . "\n" . ' ' . '' . $strNone . '  ' . "\n"; if ($is_gzip) { echo ' ' . '' . $strGzip . '  ' . "\n"; } if ($is_bzip) { echo ' ' . '' . $strBzip . '  ' . "\n"; } } else { $querybox_hidden_fields .= ' ' . "\n"; } ?> ' . "\n"; } $is_first = 0; while ($file = @readdir($handle)) { if (is_file($cfg['UploadDir'] . $file) && PMA_checkFileExtensions($file, '.sql')) { if ($is_first == 0) { $is_upload_dir = true; echo "\n"; echo ' ' . "\n" . ' '; echo ' ' . $strWebServerUploadDirectory . ': ' . "\n"; echo ' ' . "\n" . ' '; // add 2004-05-08 by mkkeck // todo: building a php script for indexing files in UploadDir //if ($cfg['UploadDirIndex']) { // echo '  ' . $cfg['UploadDir'] . ' '; //} // end indexing echo '   ' . "\n" . ' ' . "\n"; } // end if (isfirst > 0) @closedir($handle); $upload_dir_error=''; // please see 'else {' below ;) } else { // modified by mkkeck 2004-05-08 // showing UploadDir Error at the end of all option for SQL-Queries $upload_dir_error.= ' ' . "\n" . ' ' . "\n" . '

' . $strError . '

' . "\n" . ' ' . "\n" . ' ' . "\n" . ' ' . wordwrap($strWebServerUploadDirectoryError,80,'
') . '' . "\n" . ' ' . "\n" . ' ' . "\n"; } } // end if (web-server upload directory) echo "\n"; // Encoding setting form appended by Y.Kawada if (function_exists('PMA_set_enc_form')) { echo PMA_set_enc_form(' '); $form_items++; } // Charset conversion options and submit button if (($is_upload || $is_upload_dir) && (!isset($is_inside_querywindow) || (isset($is_inside_querywindow) && $is_inside_querywindow == TRUE && isset($querydisplay_tab) && ($querydisplay_tab == 'files' || $querydisplay_tab == 'full'))) // It's possible that $db is empty: no db was selected on the left // panel and the user wants to execute a .sql file to create one) // && isset($db) && $db != ''){ ){ /* if ($cfg['AllowAnywhereRecoding'] && $allow_recoding) { $form_items++; echo '

' . "\n"; $temp_charset = reset($cfg['AvailableCharsets']); echo $strCharsetOfFile . "\n" . '
' . "\n" . ' '; echo '

' . "\n"; } // end if (recoding) */ if (PMA_MYSQL_INT_VERSION < 40100 && $cfg['AllowAnywhereRecoding'] && $allow_recoding) { echo ' ' . "\n"; $temp_charset = reset($cfg['AvailableCharsets']); echo ' ' . $strCharsetOfFile . ' ' . "\n" . ' '; echo ' ' . "\n"; echo ' ' . "\n"; } // end if (recoding) else if (PMA_MYSQL_INT_VERSION >= 40100) { echo ' ' . "\n" . $strCharsetOfFile . "\n" . PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_CHARSET, 'charset_of_file', NULL, 'utf8', FALSE) . ' ' . "\n" . ' ' . "\n"; } echo ' ' . "\n" . ' ' . "\n" . ' ' . "\n\n"; } // Bookmark Support $bookmark_go = FALSE; if (!isset($is_inside_querywindow) || (isset($is_inside_querywindow) && $is_inside_querywindow == TRUE && isset($querydisplay_tab) && ($querydisplay_tab == 'history' || $querydisplay_tab == 'full'))) { if ($cfg['Bookmark']['db'] && $cfg['Bookmark']['table']) { if (($bookmark_list = PMA_listBookmarks($db, $cfg['Bookmark'])) && count($bookmark_list) > 0) { $form_items++; echo ' ' . "\n"; echo ' ' . "\n"; echo " " . ((isset($is_inside_querywindow) && $is_inside_querywindow == TRUE && isset($querydisplay_tab) && $querydisplay_tab == 'full') || !isset($is_inside_querywindow) ? "$strOr" : '') . " $strBookmarkQuery: \n"; echo ' ' . "\n"; if (isset($is_inside_querywindow) && $is_inside_querywindow == TRUE) { $querybox_hidden_fields .= ' ' . "\n"; } echo ' ' . "\n"; echo ' ' . " \n"; echo ' ' . $strVar; echo ' ' . $cfg['ReplaceHelpImg'] ? '

' : '(' . $strDocu . ')'; echo ':
' . "\n"; echo ' ' . $strSubmit . '' . "\n"; echo ' ' . $strBookmarkView . '' . "\n"; echo ' ' . $strDelete . '' . "\n"; echo '
' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; $bookmark_go = TRUE; } } } if (!isset($is_inside_querywindow) || (isset($is_inside_querywindow) && $is_inside_querywindow == TRUE && isset($querydisplay_tab) && (($querydisplay_tab == 'files') || $querydisplay_tab == 'sql' || $querydisplay_tab == 'full' || ($querydisplay_tab == 'history' && $bookmark_go)))) { if ($form_items > 0) { if ( $cfg['Bookmark']['db'] && $cfg['Bookmark']['table'] && (!isset($is_inside_querywindow) || ( isset($is_inside_querywindow) && $is_inside_querywindow == TRUE && isset($querydisplay_tab) //&& $querydisplay_tab != 'history'))) { && $querydisplay_tab == 'sql'))) { ?> > align="left">:> : > :
' . "\n"; // TODO: Add a more complete warning that no items (like for file import) where found. // (After 2.5.2 release!) echo $strWebServerUploadDirectoryError; echo ' ' . "\n"; } } echo ' ' . "\n"; echo $querybox_hidden_fields; echo ' '; if ($upload_dir_error!='') { echo $upload_dir_error; } ?>

>		:
> ><?php if (!empty($query_to_display)) { echo htmlspecialchars($query_to_display); } elseif (isset($table) && !empty($table) && isset($fields_list)) { echo htmlspecialchars( str_replace('%d', PMA_backquote($db), str_replace('%t', PMA_backquote($table), str_replace('%f', implode(', ', PMA_backquote($fields_list)), $cfg['DefaultQueryTable'])))); } else { echo htmlspecialchars(str_replace('%d', PMA_backquote($db), $cfg['DefaultQueryDatabase'])); } ?>	'; } else { echo ''; } ?>

> ' . $strOr . '' : '') . ' ' . $strLocationTextfile . ': ' . "\n"; ?>

' . "\n"; echo ' '; echo '
>

\n"; if (!isset($is_inside_querywindow) || (isset($is_inside_querywindow) && $is_inside_querywindow == TRUE && isset($querydisplay_tab) && ($querydisplay_tab == 'files' || $querydisplay_tab == 'full')) && isset($db) && $db != '') { // loic1: displays import dump feature only if file upload available $ldi_target = 'ldi_table.php?' . $url_query . (isset($is_inside_querywindow) && $is_inside_querywindow == TRUE ? '&focus_querywindow=true' : ''); if ($is_upload && isset($db) && isset($table)) { //if (!isset($is_inside_querywindow) || !$is_inside_querywindow) echo "

\n"; if ($cfg['PropertiesIconic']) { $imgInsertTextfiles = ' ' . $strInsertTextfiles. '

'; }else{ $imgInsertTextfiles = ''; } ?> \n"; } } echo "\n"; ?>