From b8741540db58ef0638fa7d96240f583b364a24d2 Mon Sep 17 00:00:00 2001
From: Sebastian Mendel <cybot_tm@users.sourceforge.net>
Date: Tue, 27 Sep 2005 13:53:49 +0000
Subject: moved all code for queryboxes into libraries/sql_query_form.lib.php,
 replaced table with fieldsets, moved styles into css, minor interface changes
 related to queryboxes

---
 server_sql.php | 200 ++-------------------------------------------------------
 1 file changed, 6 insertions(+), 194 deletions(-)

(limited to 'server_sql.php')

diff --git a/server_sql.php b/server_sql.php
index bc0762f202..7b7ab60830 100644
--- a/server_sql.php
+++ b/server_sql.php
@@ -6,211 +6,23 @@
 /**
  * Does the common work
  */
-require('./server_common.inc.php');
+require_once './server_common.inc.php';
+require_once './libraries/sql_query_form.lib.php';
 
 
 /**
  * Displays the links
  */
-require('./server_links.inc.php');
-
+require './server_links.inc.php';
 
 
 /**
- * Database work
+ * Query box, bookmark, insert data from textfile
  */
-if (isset($show_query) && $show_query == '1') {
-    // This script has been called by read_dump.php
-    if (isset($sql_query_cpy)) {
-        $query_to_display = $sql_query_cpy;
-    }
-    // Other cases
-    else {
-        $query_to_display = $sql_query;
-    }
-} else {
-    $query_to_display     = '';
-}
-
-
-// loic1: defines wether file upload is available or not
-// (now defined in common.lib.php)
-
-$auto_sel  = ($cfg['TextareaAutoSelect']
-               // 2003-02-05 rabus: This causes big trouble with Opera 7 for
-               // Windows, so let's disable it there...
-               && !(PMA_USR_OS == 'Win' && PMA_USR_BROWSER_AGENT == 'OPERA' && PMA_USR_BROWSER_VER >= 7))
-           ? "\n" . '             onfocus="if (typeof(document.layers) == \'undefined\' || typeof(textarea_selected) == \'undefined\') {textarea_selected = 1; this.form.elements[\'sql_query\'].select();}"'
-           : '';
-
-
-// for better administration
-$strHiddenFields = '        <input type="hidden" name="is_js_confirmed" value="0" />'  ."\n"
-                 . '        ' .PMA_generate_common_hidden_inputs() . "\n"
-                 . '        <input type="hidden" name="pos" value="0" />' . "\n"
-                 . '        <input type="hidden" name="goto" value="server_sql.php" />' . "\n"
-                 . '        <input type="hidden" name="zero_rows" value="' . htmlspecialchars($strSuccess) . '" />' . "\n"
-                 . '        <input type="hidden" name="prev_sql_query" value="' . ((!empty($query_to_display)) ? htmlspecialchars($query_to_display) : '') . '" />' . "\n";
-?>
-<!-- Query box, sql file loader and bookmark support -->
-<form method="post" action="read_dump.php"<?php if ($is_upload) echo ' enctype="multipart/form-data"'; ?> onsubmit="return checkSqlQuery(this)" name="sqlform">
-<?php
-echo $strHiddenFields;
-?>
-<a name="querybox"></a>
-<table border="0" cellpadding="2" cellspacing="0">
-<tr><td class="tblHeaders" colspan="2">
-    <?php
-            echo '&nbsp;' . sprintf($strRunSQLQueryOnServer, htmlspecialchars($GLOBALS['cfg']['Servers'][$server]['host'])) . ':&nbsp;' . PMA_showMySQLDocu('Reference', 'SELECT');
-
-    ?>
-</td></tr>
-<tr align="center" bgcolor="<?php echo $cfg['BgcolorOne']; ?>"><td colspan="2">
-<textarea name="sql_query" cols="<?php echo $cfg['TextareaCols'] * 2; ?>" rows="<?php echo $cfg['TextareaRows']; ?>" dir="<?php echo $text_dir; ?>"<?php echo $auto_sel; ?>>
-<?php
-if (!empty($query_to_display)) {
-    echo htmlspecialchars($query_to_display);
-}
-?></textarea>
-</td></tr>
-<tr class="tblFooters">
-    <td>
-        <input type="checkbox" name="show_query" value="1" id="checkbox_show_query" checked="checked" /><label for="checkbox_show_query"><?php echo $strShowThisQuery; ?></label>
-    </td>
-    <td align="right"><input type="submit" name="SQL" value="<?php echo $strGo; ?>" /></td>
-</tr>
-<?php
-// loic1: displays import dump feature only if file upload available
-if ($is_upload) {
-?>
-<tr><td colspan="2"><img src="<?php echo $GLOBALS['pmaThemeImage'] . 'spacer.png'; ?>" width="1" height="1" border="0" alt="" /></td></tr>
-<tr>
-    <td colspan="2" class="tblHeaders">
-        <i><?php echo $strOr; ?></i>
-        <b><?php echo $strLocationTextfile; ?>:</b>
-    </td>
-</tr>
-<tr bgcolor="<?php echo $cfg['BgcolorOne']; ?>">
-  <td colspan="2" align="center">
-    <input type="file" name="sql_file" class="textfield" />&nbsp;
-    <?php
-    echo PMA_displayMaximumUploadSize($max_upload_size) . '<br />';
-    // some browsers should respect this :)
-    echo '    ' . PMA_generateHiddenMaxFileSize($max_upload_size) . "\n";
-    $is_gzip = ($cfg['GZipDump'] && @function_exists('gzopen'));
-    $is_bzip = ($cfg['BZipDump'] && @function_exists('bzdecompress'));
-    if ($is_bzip || $is_gzip) {
-        echo '    </td>' . "\n"
-           . '</tr>'   . "\n"
-           . '<tr bgcolor="' . $cfg['BgcolorOne'] . '">' . "\n"
-           . '    <td colspan="2">' . "\n";
-        echo '        &nbsp;&nbsp;' . $strCompression . ':<br />&nbsp;&nbsp;&nbsp;' . "\n"
-           . '            <input type="radio" id="radio_sql_file_compression_auto" name="sql_file_compression" value="" checked="checked" /><label for="radio_sql_file_compression_auto">' . $strAutodetect . '</label>&nbsp;&nbsp;' . "\n"
-           . '            <input type="radio" id="radio_sql_file_compression_plain" name="sql_file_compression" value="text/plain" /><label for="radio_sql_file_compression_plain">' . $strNone . '</label>&nbsp;&nbsp' . "\n";
-        if ($is_gzip) {
-            echo '            <input type="radio" id="radio_sql_file_compression_gzip" name="sql_file_compression" value="application/x-gzip" /><label for="radio_sql_file_compression_gzip">' . $strGzip . '</label>&nbsp;&nbsp;' . "\n";
-        }
-        if ($is_bzip) {
-            echo '            <input type="radio" id="radio_sql_file_compression_bzip" name="sql_file_compression" value="application/x-bzip" /><label for="radio_sql_file_compression_bzip">' . $strBzip . '</label>&nbsp;&nbsp;' . "\n";
-        }
-    } else {
-    ?>
-        <input type="hidden" name="sql_file_compression" value="text/plain" />
-    </td>
-</tr>
-    <?php
-    }
-} // end if (is upload)
-// web-server upload directory
-$is_upload_dir = false;
-if (!empty($cfg['UploadDir'])) {
-    if (substr($cfg['UploadDir'], -1) != '/') {
-        $cfg['UploadDir'] .= '/';
-    }
-    if ($handle = @opendir($cfg['UploadDir'])) {
-        $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 '    <tr><td colspan=2" bgcolor="' . $cfg['BgcolorTwo'] . '">' . "\n";
-                    echo '        &nbsp;<b>' . $strWebServerUploadDirectory . ':</b>&nbsp;' . "\n";
-                    echo '    </td></tr>' . "\n";
-                    echo '    <tr bgcolor="' . $cfg['BgcolorOne'] . '"><td colspan="2">' . "\n";
-                    // add 2004-05-08 by mkkeck
-                    // todo: building a php script for indexing files in UploadDir
-                    //if ($cfg['UploadDirIndex']) {
-                    //    echo '&nbsp;<a href="' . $cfg['UploadDir'] . '" target="_blank">' . $cfg['UploadDir'] . '</a>&nbsp;';
-                    //}
-                    // end indexing
-                    echo '        <select size="1" name="sql_localfile">' . "\n";
-                    echo '            <option value="" selected="selected"></option>' . "\n";
-                } // end if (is_first)
-                echo '            <option value="' . htmlspecialchars($file) . '">' . htmlspecialchars($file) . '</option>' . "\n";
-                $is_first++;
-            } // end if (is_file)
-        } // end while
-        if ($is_first > 0) {
-            echo '        </select>' . "\n"
-               . '    </td>'
-               . '    </tr>' . "\n\n";
-        } // end if (isfirst > 0)
-        @closedir($handle);
-    }
-    else {
-        $upload_dir_error = '<tr><td colspan="2"><img src="' .$GLOBALS['pmaThemeImage'] . 'spacer.png'  . '" width="1" height="1" border="0" alt="" /></td></tr>' . "\n"
-                          . '<tr><th colspan="2" class="tblHeadError"><div class="errorhead">' . $strError . '</div></th></tr>' . "\n"
-                          . '<tr><td colspan="2" class="tblError">' . $strWebServerUploadDirectoryError
-                          . '</td></tr>' . "\n";
-    }
-} // end if (web-server upload directory)
-// Charset conversion options
-if ($is_upload || $is_upload_dir) {
-    echo '    <tr class="tblFooters"><td>' . "\n";
-    if (PMA_MYSQL_INT_VERSION < 40100 && $cfg['AllowAnywhereRecoding'] && $allow_recoding) {
-        $temp_charset = reset($cfg['AvailableCharsets']);
-        echo '&nbsp;' . $strCharsetOfFile . "\n"
-             . '    <select name="charset_of_file" size="1">' . "\n"
-             . '            <option value="' . $temp_charset . '"';
-        if ($temp_charset == $charset) {
-            echo ' selected="selected"';
-        }
-        echo '>' . $temp_charset . '</option>' . "\n";
-        while ($temp_charset = next($cfg['AvailableCharsets'])) {
-            echo '            <option value="' . $temp_charset . '"';
-            if ($temp_charset == $charset) {
-                echo ' selected="selected"';
-            }
-            echo '>' . $temp_charset . '</option>' . "\n";
-        }
-        echo '        </select><br />' . "\n" . '    ';
-    } elseif (PMA_MYSQL_INT_VERSION >= 40100) {
-        echo $strCharsetOfFile . "\n";
-        echo PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_CHARSET, 'charset_of_file', NULL, 'utf8', FALSE);
-    } // end if (recoding)
-    echo '    </td>' . "\n";
-    echo '    <td align="right"><input type="submit" name="SQL" value="' . $strGo . '" /></td>' . "\n";
-    echo '    </tr>' . "\n";
-}
-
+PMA_sqlQueryForm();
 
-// Encoding setting form appended by Y.Kawada
-if (function_exists('PMA_set_enc_form')) {
-    echo PMA_set_enc_form('    ');
-}
-// modified by mkkeck 2004-05-08
-//   showing UploadDir Error at the end of all option for SQL-Queries
-if (isset($upload_dir_error)) {
-    echo $upload_dir_error;
-}
-?>
-</table>
-</form>
-<?php
 /**
  * Displays the footer
  */
-echo "\n";
-require_once('./footer.inc.php');
+require_once './footer.inc.php';
 ?>
-- 
cgit v1.2.3