querywindow.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * this file is register_globals safe
   5  *
   6  * @todo    move JavaScript out of here into .js files
   7  * @package PhpMyAdmin
   8  */
   9
  10 /**
  11  *
  12  */
  13 require_once './libraries/common.inc.php';
  14
  15 $is_superuser = PMA_isSuperuser();
  16
  17 /**
  18  * Gets a core script and starts output buffering work
  19  */
  20 require_once './libraries/sql_query_form.lib.php';
  21
  22 /**
  23  * starts output buffering if requested and supported
  24  */
  25 require_once './libraries/ob.lib.php';
  26 PMA_outBufferPre();
  27
  28 /**
  29  * load relation params
  30  */
  31 $cfgRelation = PMA_getRelationsParam();
  32
  33 /**
  34  * load bookmark support
  35  */
  36 require_once './libraries/bookmark.lib.php';
  37
  38 $querydisplay_tabs = array(
  39     'sql',
  40     'files',
  41     'history',
  42     'full',
  43 );
  44
  45 if (isset($_REQUEST['querydisplay_tab'])
  46  && in_array($_REQUEST['querydisplay_tab'], $querydisplay_tabs)) {
  47     $querydisplay_tab = $_REQUEST['querydisplay_tab'];
  48 } else {
  49     $querydisplay_tab = $GLOBALS['cfg']['QueryWindowDefTab'];
  50 }
  51
  52 /**
  53  * $_REQUEST['no_js'] is set if open new window by JavaScript failed
  54  * so this page is loaded in main frame
  55  */
  56 $no_js = PMA_ifSetOr($_REQUEST['no_js'], false);
  57
  58 if ($no_js) {
  59     $querydisplay_tab = 'full';
  60     $tabs = false;
  61 } else {
  62     $tabs = array();
  63     $tabs['sql']['icon']   = 'b_sql.png';
  64     $tabs['sql']['text']   = __('SQL');
  65     $tabs['sql']['fragment']   = '#';
  66     $tabs['sql']['attr']   = 'onclick="PMA_querywindowCommit(\'sql\');return false;"';
  67     $tabs['sql']['active'] = (bool) ($querydisplay_tab == 'sql');
  68     $tabs['import']['icon']   = 'b_import.png';
  69     $tabs['import']['text']   = __('Import files');
  70     $tabs['import']['fragment']   = '#';
  71     $tabs['import']['attr']   = 'onclick="PMA_querywindowCommit(\'files\');return false;"';
  72     $tabs['import']['active'] = (bool) ($querydisplay_tab == 'files');
  73     $tabs['history']['icon']   = 'b_bookmark.png';
  74     $tabs['history']['text']   = __('SQL history');
  75     $tabs['history']['fragment']   = '#';
  76     $tabs['history']['attr']   = 'onclick="PMA_querywindowCommit(\'history\');return false;"';
  77     $tabs['history']['active'] = (bool) ($querydisplay_tab == 'history');
  78
  79     if ($GLOBALS['cfg']['QueryWindowDefTab'] == 'full') {
  80         $tabs['all']['text']   = __('All');
  81         $tabs['all']['fragment']   = '#';
  82         $tabs['all']['attr']   = 'onclick="PMA_querywindowCommit(\'full\');return false;"';
  83         $tabs['all']['active'] = (bool) ($querydisplay_tab == 'full');
  84     }
  85 }
  86
  87 $titles['Change'] = PMA_getIcon('b_edit.png', __('Change'));
  88 $url_query = PMA_generate_common_url($db, $table);
  89
  90 if (! empty($sql_query)) {
  91     $show_query = 1;
  92 }
  93
  94 if ($no_js) {
  95     // ... we redirect to appropriate query sql page
  96     // works only full if $db and $table is also stored/grabbed from $_COOKIE
  97     if (strlen($table)) {
  98         include './tbl_sql.php';
  99     } elseif (strlen($db)) {
 100         include './db_sql.php';
 101     } else {
 102         include './server_sql.php';
 103     }
 104     exit;
 105 }
 106
 107 /**
 108  * Defines the query to be displayed in the query textarea
 109  */
 110 if (! empty($show_query)) {
 111     $query_to_display = $sql_query;
 112 } else {
 113     $query_to_display = '';
 114 }
 115 $sql_query = '';
 116
 117 /**
 118  * prepare JavaScript functionality
 119  */
 120 $js_include[] = 'common.js';
 121 $js_include[] = 'querywindow.js';
 122 $js_include[] = 'codemirror/lib/codemirror.js';
 123 $js_include[] = 'codemirror/mode/mysql/mysql.js';
 124
 125 if (PMA_isValid($_REQUEST['auto_commit'], 'identical', 'true')) {
 126     $js_events[] = array(
 127         'event'     => 'load',
 128         'function'  => 'PMA_queryAutoCommit',
 129     );
 130 }
 131 if (PMA_isValid($_REQUEST['init'])) {
 132     $js_events[] = array(
 133         'event'     => 'load',
 134         'function'  => 'PMA_querywindowResize',
 135     );
 136 }
 137 // always set focus to the textarea
 138 if ($querydisplay_tab == 'sql' || $querydisplay_tab == 'full') {
 139     $js_events[] = array(
 140         'event'     => 'load',
 141         'function'  => 'PMA_querywindowSetFocus',
 142     );
 143 }
 144
 145 /**
 146  * start HTTP/HTML output
 147  */
 148 require_once './libraries/header_http.inc.php';
 149 require_once './libraries/header_meta_style.inc.php';
 150 require_once './libraries/header_scripts.inc.php';
 151 ?>
 152 </head>
 153
 154 <body id="bodyquerywindow">
 155 <div id="querywindowcontainer">
 156 <?php
 157
 158 if ($tabs) {
 159     echo PMA_generate_html_tabs($tabs, array());
 160     unset($tabs);
 161 }
 162
 163 PMA_sqlQueryForm($query_to_display, $querydisplay_tab);
 164
 165 // Hidden forms and query frame interaction stuff
 166
 167 $_sql_history = PMA_getHistory($GLOBALS['cfg']['Server']['user']);
 168 if (! empty($_sql_history)
 169  && ($querydisplay_tab == 'history' || $querydisplay_tab == 'full')) {
 170     $tab = $querydisplay_tab != 'full' ? 'sql' : 'full';
 171     echo __('SQL history') . ':<br />'
 172         . '<ul>';
 173     foreach ($_sql_history as $query) {
 174         echo '<li>' . "\n";
 175
 176         // edit link
 177         $url_params = array(
 178             'querydisplay_tab' => $tab,
 179             'sql_query' => $query['sqlquery'],
 180             'db' => $query['db'],
 181             'table' => $query['table'],
 182         );
 183         echo '<a href="querywindow.php' . PMA_generate_common_url($url_params)
 184             . '">' . $titles['Change'] . '</a>';
 185
 186         // execute link
 187         $url_params['auto_commit'] = 'true';
 188         echo '<a href="import.php' . PMA_generate_common_url($url_params) . '"'
 189             . ' target="frame_content">';
 190
 191         if (! empty($query['db'])) {
 192             echo '[';
 193             echo htmlspecialchars(PMA_backquote($query['db']));
 194             if (! empty($query['table'])) {
 195                 echo '.' . htmlspecialchars(PMA_backquote($query['table']));
 196             }
 197             echo  '] ';
 198         }
 199         if (strlen($query['sqlquery']) > 120) {
 200             echo '<span title="' . htmlspecialchars($query['sqlquery']) . '">';
 201             echo htmlspecialchars(substr($query['sqlquery'], 0, 50)) . ' [...] ';
 202             echo htmlspecialchars(substr($query['sqlquery'], -50));
 203             echo '</span>';
 204         } else {
 205             echo htmlspecialchars($query['sqlquery']);
 206         }
 207         echo '</a>' . "\n";
 208         echo '</li>' . "\n";
 209     }
 210     unset($tab, $_sql_history, $query);
 211     echo '</ul>' . "\n";
 212 }
 213 ?>
 214 <form action="querywindow.php" method="post" name="hiddenqueryform"
 215     id="hiddenqueryform">
 216     <?php echo PMA_generate_common_hidden_inputs('', ''); ?>
 217     <input type="hidden" name="db" value="<?php echo htmlspecialchars($db); ?>" />
 218     <input type="hidden" name="table" value="<?php echo htmlspecialchars($table); ?>" />
 219     <input type="hidden" name="sql_query" value="" />
 220     <input type="hidden" name="querydisplay_tab" value="<?php echo $querydisplay_tab; ?>" />
 221 </form>
 222 </div>
 223 </body>
 224 </html>