querywindow.php

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