| 250 |
kaklik |
1 |
<?php |
|
|
2 |
/* $Id: querywindow.php,v 2.34 2006/01/14 23:17:15 cybot_tm Exp $ */ |
|
|
3 |
// vim: expandtab sw=4 ts=4 sts=4: |
|
|
4 |
|
|
|
5 |
require_once('./libraries/common.lib.php'); |
|
|
6 |
|
|
|
7 |
/** |
|
|
8 |
* Gets the variables sent to this script, retains the db name that may have |
|
|
9 |
* been defined as startup option and include a core library |
|
|
10 |
*/ |
|
|
11 |
if (isset($db) && strlen($db)) { |
|
|
12 |
$db_start = $db; |
|
|
13 |
} |
|
|
14 |
|
|
|
15 |
|
|
|
16 |
/** |
|
|
17 |
* Gets a core script and starts output buffering work |
|
|
18 |
*/ |
|
|
19 |
require_once './libraries/sql_query_form.lib.php'; |
|
|
20 |
require_once('./libraries/ob.lib.php'); |
|
|
21 |
if ( $GLOBALS['cfg']['OBGzip'] ) { |
|
|
22 |
$ob_mode = PMA_outBufferModeGet(); |
|
|
23 |
if ( $ob_mode ) { |
|
|
24 |
PMA_outBufferPre( $ob_mode ); |
|
|
25 |
} |
|
|
26 |
} |
|
|
27 |
|
|
|
28 |
require_once('./libraries/relation.lib.php'); |
|
|
29 |
$cfgRelation = PMA_getRelationsParam(); |
|
|
30 |
|
|
|
31 |
|
|
|
32 |
// initialize some variables |
|
|
33 |
$_sql_history = array(); |
|
|
34 |
$_input_query_history = array(); |
|
|
35 |
|
|
|
36 |
/** |
|
|
37 |
* Get the list and number of available databases. |
|
|
38 |
* Skipped if no server selected: in this case no database should be displayed |
|
|
39 |
* before the user choose among available ones at the welcome screen. |
|
|
40 |
*/ |
|
|
41 |
if ($server > 0) { |
|
|
42 |
PMA_availableDatabases(); // this function is defined in "common.lib.php" |
|
|
43 |
} else { |
|
|
44 |
$num_dbs = 0; |
|
|
45 |
} |
|
|
46 |
|
|
|
47 |
// garvin: For re-usability, moved http-headers and stylesheets |
|
|
48 |
// to a seperate file. It can now be included by libraries/header.inc.php, |
|
|
49 |
// querywindow.php. |
|
|
50 |
|
|
|
51 |
require_once('./libraries/header_http.inc.php'); |
|
|
52 |
require_once('./libraries/header_meta_style.inc.php'); |
|
|
53 |
?> |
|
|
54 |
<script type="text/javascript" language="javascript"> |
|
|
55 |
//<![CDATA[ |
|
|
56 |
function query_auto_commit() { |
|
|
57 |
document.getElementById( 'sqlqueryform' ).target = window.opener.frames[1].name; |
|
|
58 |
document.getElementById( 'sqlqueryform' ).submit(); |
|
|
59 |
return; |
|
|
60 |
} |
|
|
61 |
|
|
|
62 |
function query_tab_commit(tab) { |
|
|
63 |
document.getElementById('hiddenqueryform').querydisplay_tab.value = tab; |
|
|
64 |
document.getElementById('hiddenqueryform').submit(); |
|
|
65 |
return false; |
|
|
66 |
} |
|
|
67 |
|
|
|
68 |
// js form validation stuff |
|
|
69 |
/**/ |
|
|
70 |
var errorMsg0 = '<?php echo str_replace('\'', '\\\'', $GLOBALS['strFormEmpty']); ?>'; |
|
|
71 |
var errorMsg1 = '<?php echo str_replace('\'', '\\\'', $GLOBALS['strNotNumber']); ?>'; |
|
|
72 |
var noDropDbMsg = '<?php echo !$GLOBALS['cfg']['AllowUserDropDatabase'] |
|
|
73 |
? str_replace('\'', '\\\'', $GLOBALS['strNoDropDatabases']) : ''; ?>'; |
|
|
74 |
var confirmMsg = '<?php echo $GLOBALS['cfg']['Confirm'] |
|
|
75 |
? str_replace('\'', '\\\'', $GLOBALS['strDoYouReally']) : ''; ?>'; |
|
|
76 |
/**/ |
|
|
77 |
|
|
|
78 |
<?php |
|
|
79 |
if ( empty( $querydisplay_tab ) ) { |
|
|
80 |
$onload = 'onload="resize();"'; |
|
|
81 |
?> |
|
|
82 |
function resize() { |
|
|
83 |
|
|
|
84 |
// for Gecko |
|
|
85 |
if ( typeof( self.sizeToContent ) == 'function' ) { |
|
|
86 |
self.sizeToContent(); |
|
|
87 |
//self.scrollbars.visible = false; |
|
|
88 |
// give some more space ... to prevent 'fli(pp/ck)ing' |
|
|
89 |
self.resizeBy( 10, 50 ); |
|
|
90 |
return; |
|
|
91 |
} |
|
|
92 |
|
|
|
93 |
// for IE, Opera |
|
|
94 |
if (document.getElementById && typeof(document.getElementById('querywindowcontainer')) != 'undefined' ) { |
|
|
95 |
|
|
|
96 |
// get content size |
|
|
97 |
var newWidth = document.getElementById('querywindowcontainer').offsetWidth; |
|
|
98 |
var newHeight = document.getElementById('querywindowcontainer').offsetHeight; |
|
|
99 |
|
|
|
100 |
// set size to contentsize |
|
|
101 |
// plus some offset for scrollbars, borders, statusbar, menus ... |
|
|
102 |
self.resizeTo( newWidth + 45, newHeight + 75 ); |
|
|
103 |
} |
|
|
104 |
} |
|
|
105 |
<?php |
|
|
106 |
} else { |
|
|
107 |
$onload = ''; |
|
|
108 |
} |
|
|
109 |
?> |
|
|
110 |
//]]> |
|
|
111 |
</script> |
|
|
112 |
<script src="./js/functions.js" type="text/javascript" language="javascript"></script> |
|
|
113 |
</head> |
|
|
114 |
|
|
|
115 |
<body id="bodyquerywindow" <?php echo $onload; ?> > |
|
|
116 |
<div id="querywindowcontainer"> |
|
|
117 |
<?php |
|
|
118 |
if ( !isset($no_js) ) { |
|
|
119 |
$querydisplay_tab = (isset($querydisplay_tab) ? $querydisplay_tab : $GLOBALS['cfg']['QueryWindowDefTab']); |
|
|
120 |
|
|
|
121 |
$tabs = array(); |
|
|
122 |
$tabs['sql']['icon'] = 'b_sql.png'; |
|
|
123 |
$tabs['sql']['text'] = $strSQL; |
|
|
124 |
$tabs['sql']['link'] = '#'; |
|
|
125 |
$tabs['sql']['attr'] = 'onclick="javascript:query_tab_commit(\'sql\');return false;"'; |
|
|
126 |
$tabs['sql']['active'] = (bool) ( $querydisplay_tab == 'sql' ); |
|
|
127 |
$tabs['import']['icon'] = 'b_import.png'; |
|
|
128 |
$tabs['import']['text'] = $strImportFiles; |
|
|
129 |
$tabs['import']['link'] = '#'; |
|
|
130 |
$tabs['import']['attr'] = 'onclick="javascript:query_tab_commit(\'files\');return false;"'; |
|
|
131 |
$tabs['import']['active'] = (bool) ( $querydisplay_tab == 'files' ); |
|
|
132 |
$tabs['history']['icon'] = 'b_bookmark.png'; |
|
|
133 |
$tabs['history']['text'] = $strQuerySQLHistory; |
|
|
134 |
$tabs['history']['link'] = '#'; |
|
|
135 |
$tabs['history']['attr'] = 'onclick="javascript:query_tab_commit(\'history\');return false;"'; |
|
|
136 |
$tabs['history']['active'] = (bool) ( $querydisplay_tab == 'history' ); |
|
|
137 |
|
|
|
138 |
if ( $GLOBALS['cfg']['QueryWindowDefTab'] == 'full' ) { |
|
|
139 |
$tabs['all']['text'] = $strAll; |
|
|
140 |
$tabs['all']['link'] = '#'; |
|
|
141 |
$tabs['all']['attr'] = 'onclick="javascript:query_tab_commit(\'full\');return false;"'; |
|
|
142 |
$tabs['all']['active'] = (bool) ( $querydisplay_tab == 'full' ); |
|
|
143 |
} |
|
|
144 |
|
|
|
145 |
echo PMA_getTabs( $tabs ); |
|
|
146 |
unset( $tabs ); |
|
|
147 |
} else { |
|
|
148 |
$querydisplay_tab = 'full'; |
|
|
149 |
} |
|
|
150 |
|
|
|
151 |
if ( true == $GLOBALS['cfg']['PropertiesIconic'] ) { |
|
|
152 |
$titles['Change'] = |
|
|
153 |
'<img class="icon" width="16" height="16" src="' . $pmaThemeImage |
|
|
154 |
. 'b_edit.png" alt="' . $strChange . '" title="' . $strChange |
|
|
155 |
. '" />'; |
|
|
156 |
|
|
|
157 |
if ( 'both' === $GLOBALS['cfg']['PropertiesIconic'] ) { |
|
|
158 |
$titles['Change'] .= $strChange; |
|
|
159 |
} |
|
|
160 |
} else { |
|
|
161 |
$titles['Change'] = $strChange; |
|
|
162 |
} |
|
|
163 |
|
|
|
164 |
// Hidden forms and query frame interaction stuff |
|
|
165 |
|
|
|
166 |
if ( ! empty( $query_history_latest ) && ! empty( $query_history_latest_db ) ) { |
|
|
167 |
if ( $GLOBALS['cfg']['QueryHistoryDB'] && $cfgRelation['historywork'] ) { |
|
|
168 |
PMA_setHistory((isset($query_history_latest_db) ? $query_history_latest_db : ''), |
|
|
169 |
(isset($query_history_latest_table) ? $query_history_latest_table : ''), |
|
|
170 |
$GLOBALS['cfg']['Server']['user'], |
|
|
171 |
$query_history_latest ); |
|
|
172 |
} |
|
|
173 |
|
|
|
174 |
$_input_query_history[$query_history_latest] = array( |
|
|
175 |
'db' => $query_history_latest_db, |
|
|
176 |
'table' => isset($query_history_latest_table) ? $query_history_latest_table : '', |
|
|
177 |
); |
|
|
178 |
|
|
|
179 |
$_sql_history[$query_history_latest] = array( |
|
|
180 |
'db' => $query_history_latest_db, |
|
|
181 |
'table' => isset($query_history_latest_table) ? $query_history_latest_table : '', |
|
|
182 |
); |
|
|
183 |
|
|
|
184 |
$sql_query = urldecode($query_history_latest); |
|
|
185 |
$db = $query_history_latest_db; |
|
|
186 |
$table = $query_history_latest_table; |
|
|
187 |
} elseif ( ! empty( $query_history_latest ) ) { |
|
|
188 |
$sql_query = urldecode($query_history_latest); |
|
|
189 |
} |
|
|
190 |
|
|
|
191 |
if (isset($sql_query)) { |
|
|
192 |
$show_query = 1; |
|
|
193 |
} |
|
|
194 |
|
|
|
195 |
if ( $GLOBALS['cfg']['QueryHistoryDB'] && $cfgRelation['historywork'] ) { |
|
|
196 |
|
|
|
197 |
$temp_history = PMA_getHistory( $GLOBALS['cfg']['Server']['user'] ); |
|
|
198 |
if (is_array($temp_history) && count($temp_history) > 0) { |
|
|
199 |
foreach ($temp_history AS $history_nr => $history_array) { |
|
|
200 |
if ( ! isset( $_sql_history[$history_array['sqlquery']] ) ) { |
|
|
201 |
$_sql_history[$history_array['sqlquery']] = array( |
|
|
202 |
'db' => $history_array['db'], |
|
|
203 |
'table' => isset( $history_array['table'] ) ? $history_array['table'] : '', |
|
|
204 |
); |
|
|
205 |
} |
|
|
206 |
} |
|
|
207 |
} |
|
|
208 |
|
|
|
209 |
} else { |
|
|
210 |
|
|
|
211 |
if (isset($query_history) && is_array($query_history)) { |
|
|
212 |
$current_index = count($query_history); |
|
|
213 |
foreach ($query_history AS $query_no => $query_sql) { |
|
|
214 |
if ( ! isset( $_input_query_history[$query_sql] ) ) { |
|
|
215 |
$_input_query_history[$query_sql] = array( |
|
|
216 |
'db' => $query_history_db[$query_no], |
|
|
217 |
'table' => isset($query_history_table[$query_no]) ? $query_history_table[$query_no] : '', |
|
|
218 |
); |
|
|
219 |
$_sql_history[$query_sql] = array( |
|
|
220 |
'db' => $query_history_db[$query_no], |
|
|
221 |
'table' => isset( $query_history_table[$query_no] ) ? $query_history_table[$query_no] : '', |
|
|
222 |
); |
|
|
223 |
} // end if check if this item exists |
|
|
224 |
} // end while print history |
|
|
225 |
} // end if history exists |
|
|
226 |
} // end if DB-based history |
|
|
227 |
|
|
|
228 |
$url_query = PMA_generate_common_url(isset($db) ? $db : '', isset($table) ? $table : ''); |
|
|
229 |
if (!isset($goto)) { |
|
|
230 |
$goto = ''; |
|
|
231 |
} |
|
|
232 |
|
|
|
233 |
require_once './libraries/bookmark.lib.php'; |
|
|
234 |
|
|
|
235 |
if (isset($no_js) && $no_js) { |
|
|
236 |
// ... we redirect to appropriate query sql page |
|
|
237 |
// works only full if $db and $table is also stored/grabbed from $_COOKIE |
|
|
238 |
if ( isset( $table ) && strlen($table) ) { |
|
|
239 |
require './tbl_properties.php'; |
|
|
240 |
} elseif ( isset($db) && strlen($db) ) { |
|
|
241 |
require './db_details.php'; |
|
|
242 |
} else { |
|
|
243 |
require './server_sql.php'; |
|
|
244 |
} |
|
|
245 |
exit; |
|
|
246 |
} |
|
|
247 |
|
|
|
248 |
/** |
|
|
249 |
* Defines the query to be displayed in the query textarea |
|
|
250 |
*/ |
|
|
251 |
if ( ! empty( $show_query ) ) { |
|
|
252 |
$query_to_display = $sql_query; |
|
|
253 |
} else { |
|
|
254 |
$query_to_display = ''; |
|
|
255 |
} |
|
|
256 |
unset( $sql_query ); |
|
|
257 |
|
|
|
258 |
PMA_sqlQueryForm( $query_to_display, $querydisplay_tab ); |
|
|
259 |
|
|
|
260 |
// Hidden forms and query frame interaction stuff |
|
|
261 |
if (isset($auto_commit) && $auto_commit == 'true') { |
|
|
262 |
?> |
|
|
263 |
<script type="text/javascript" language="javascript"> |
|
|
264 |
//<![CDATA[ |
|
|
265 |
query_auto_commit(); |
|
|
266 |
//]]> |
|
|
267 |
</script> |
|
|
268 |
<?php |
|
|
269 |
} |
|
|
270 |
|
|
|
271 |
if ( count( $_sql_history ) > 0 |
|
|
272 |
&& ( $querydisplay_tab == 'history' || $querydisplay_tab == 'full' ) ) { |
|
|
273 |
$tab = isset($querydisplay_tab) && $querydisplay_tab != 'full' ? 'sql' : 'full'; |
|
|
274 |
echo $strQuerySQLHistory . ':<br />' . "\n" |
|
|
275 |
.'<ul>'; |
|
|
276 |
foreach ( $_sql_history as $sql => $query ) { |
|
|
277 |
echo '<li>' . "\n"; |
|
|
278 |
// edit link |
|
|
279 |
echo '<a href="#" onclick="' |
|
|
280 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
281 |
.'querydisplay_tab.value = \'' . $tab . '\';' |
|
|
282 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
283 |
.'query_history_latest.value = \'' |
|
|
284 |
. preg_replace('/(\r|\n)+/i', '\\n', |
|
|
285 |
htmlentities( $sql, ENT_QUOTES ) ) . '\';' |
|
|
286 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
287 |
.'auto_commit.value = \'false\';' |
|
|
288 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
289 |
.'db.value = \'' . htmlspecialchars( $query['db'] ) . '\';' |
|
|
290 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
291 |
.'query_history_latest_db.value = \'' |
|
|
292 |
. htmlspecialchars( $query['db'] ) . '\';' |
|
|
293 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
294 |
.'table.value = \'' . htmlspecialchars( $query['table'] ) . '\';' |
|
|
295 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
296 |
.'query_history_latest_table.value = \'' |
|
|
297 |
. htmlspecialchars( $query['table'] ) . '\';' |
|
|
298 |
.' document.getElementById(\'hiddenqueryform\').submit();' |
|
|
299 |
.' return false;">' . $titles['Change'] . '</a>'; |
|
|
300 |
// execute link |
|
|
301 |
echo '<a href="#" onclick="' |
|
|
302 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
303 |
.'querydisplay_tab.value = \'' . $tab . '\';' |
|
|
304 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
305 |
.'query_history_latest.value = \'' |
|
|
306 |
. preg_replace('/(\r|\n)+/i', '\\r\\n', |
|
|
307 |
htmlentities( $sql, ENT_QUOTES ) ) . '\';' |
|
|
308 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
309 |
.'auto_commit.value = \'true\';' |
|
|
310 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
311 |
.'db.value = \'' . htmlspecialchars( $query['db'] ) . '\';' |
|
|
312 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
313 |
.'query_history_latest_db.value = \'' |
|
|
314 |
. htmlspecialchars( $query['db'] ) . '\';' |
|
|
315 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
316 |
.'table.value = \'' . htmlspecialchars( $query['table'] ) . '\';' |
|
|
317 |
.' document.getElementById(\'hiddenqueryform\').' |
|
|
318 |
.'query_history_latest_table.value = \'' |
|
|
319 |
. htmlspecialchars( $query['table'] ) . '\';' |
|
|
320 |
.' document.getElementById(\'hiddenqueryform\').submit();' |
|
|
321 |
.' return false;">[' . htmlspecialchars( $query['db'] ) . '] ' |
|
|
322 |
. urldecode( $sql ) . '</a>' . "\n"; |
|
|
323 |
|
|
|
324 |
echo '</li>' . "\n"; |
|
|
325 |
} |
|
|
326 |
unset( $tab, $_sql_history, $sql, $query ); |
|
|
327 |
echo '</ul>' . "\n"; |
|
|
328 |
} |
|
|
329 |
?> |
|
|
330 |
<form action="querywindow.php" method="post" name="querywindow" id="hiddenqueryform"> |
|
|
331 |
<?php |
|
|
332 |
echo PMA_generate_common_hidden_inputs('', '') . "\n"; |
|
|
333 |
foreach ( $_input_query_history as $sql => $history ) { |
|
|
334 |
echo '<input type="hidden" name="query_history[]" value="' |
|
|
335 |
. $sql . '" />' . "\n"; |
|
|
336 |
echo '<input type="hidden" name="query_history_db[]" value="' |
|
|
337 |
. htmlspecialchars( $history['db'] ) . '" />' . "\n"; |
|
|
338 |
echo '<input type="hidden" name="query_history_table[]" value="' |
|
|
339 |
. htmlspecialchars( $history['table'] ) . '" />' . "\n"; |
|
|
340 |
} |
|
|
341 |
unset( $_input_query_history, $sql, $history ); |
|
|
342 |
?> |
|
|
343 |
<input type="hidden" name="db" value="<?php echo (! isset($db) ? '' : htmlspecialchars($db)); ?>" /> |
|
|
344 |
<input type="hidden" name="table" value="<?php echo (! isset($table) ? '' : htmlspecialchars($table)); ?>" /> |
|
|
345 |
|
|
|
346 |
<input type="hidden" name="query_history_latest" value="" /> |
|
|
347 |
<input type="hidden" name="query_history_latest_db" value="" /> |
|
|
348 |
<input type="hidden" name="query_history_latest_table" value="" /> |
|
|
349 |
|
|
|
350 |
<input type="hidden" name="previous_db" value="<?php echo htmlspecialchars($db); ?>" /> |
|
|
351 |
|
|
|
352 |
<input type="hidden" name="auto_commit" value="false" /> |
|
|
353 |
<input type="hidden" name="querydisplay_tab" value="<?php echo $querydisplay_tab; ?>" /> |
|
|
354 |
</form> |
|
|
355 |
<?php |
|
|
356 |
?> |
|
|
357 |
</div> |
|
|
358 |
</body> |
|
|
359 |
</html> |
|
|
360 |
|
|
|
361 |
<?php |
|
|
362 |
|
|
|
363 |
/** |
|
|
364 |
* Close MySql connections |
|
|
365 |
*/ |
|
|
366 |
if (isset($controllink) && $controllink) { |
|
|
367 |
PMA_DBI_close($controllink); |
|
|
368 |
} |
|
|
369 |
if (isset($userlink) && $userlink) { |
|
|
370 |
PMA_DBI_close($userlink); |
|
|
371 |
} |
|
|
372 |
|
|
|
373 |
|
|
|
374 |
/** |
|
|
375 |
* Sends bufferized data |
|
|
376 |
*/ |
|
|
377 |
if ( $GLOBALS['cfg']['OBGzip'] && isset( $ob_mode ) && $ob_mode ) { |
|
|
378 |
PMA_outBufferPost($ob_mode); |
|
|
379 |
} |
|
|
380 |
?> |