/Web/Maintenance/phpMyAdmin/js/querywindow.js
0,0 → 1,246
var querywindow = '';
 
/**
* sets current selected db
*
* @param string db name
*/
function setDb( new_db ) {
//alert('setDb(' + new_db + ')');
if ( new_db != db ) {
// db has changed
//alert( new_db + '(' + new_db.length + ') : ' + db );
db = new_db;
if ( window.frames[0].document.getElementById( db ) == null ) {
// db is unknown, reload complete left frame
refreshLeft();
}
// TODO: add code to expand db in lightview mode
// refresh querywindow
refreshQuerywindow();
}
}
 
/**
* sets current selected table (called from left.php)
*
* @param string table name
*/
function setTable( new_table ) {
//alert('setTable(' + new_table + ')');
if ( new_table != table ) {
// table has changed
//alert( new_table + '(' + new_table.length + ') : ' + table );
table = new_table;
if ( window.frames[0].document.getElementById( db + '.' + table ) == null ) {
// table is unknown, reload complete left frame
refreshLeft();
}
// TODO: add code to expand table in lightview mode
// refresh querywindow
refreshQuerywindow();
}
}
 
function refreshMain( url ) {
if ( ! url ) {
if ( db ) {
url = opendb_url;
} else {
url = 'main.php';
}
}
goTo( url + '?&server=' + server +
'&db=' + db +
'&table=' + table +
'&lang=' + lang +
'&collation_connection=' + collation_connection,
'main' );
}
 
function refreshLeft() {
goTo('left.php?&server=' + server +
'&db=' + db +
'&table=' + table +
'&lang=' + lang +
'&collation_connection=' + collation_connection
);
}
 
/**
* sets current selected server, table and db (called from libraries/footer.inc.php)
*/
function setAll( new_lang, new_collation_connection, new_server, new_db, new_table ) {
//alert('setAll( ' + new_lang + ', ' + new_collation_connection + ', ' + new_server + ', ' + new_db + ', ' + new_table + ' )');
if ( new_server != server || new_lang != lang
|| new_collation_connection != collation_connection ) {
// something important has changed
server = new_server;
db = new_db;
table = new_table;
collation_connection = new_collation_connection;
lang = new_lang;
refreshLeft();
}
else if ( new_db != db || new_table != table ) {
// save new db and table
db = new_db;
table = new_table;
if ( window.frames[0].document.getElementById( db ) == null
&& window.frames[0].document.getElementById( db + '.' + table ) == null ) {
// table or db is unknown, reload complete left frame
refreshLeft();
}
 
// TODO: add code to expand db in lightview mode
// refresh querywindow
refreshQuerywindow();
}
}
 
function reload_querywindow( db, table, sql_query ) {
if ( ! querywindow.closed && querywindow.location ) {
if ( ! querywindow.document.sqlform.LockFromUpdate
|| ! querywindow.document.sqlform.LockFromUpdate.checked ) {
querywindow.document.querywindow.db.value = db;
querywindow.document.querywindow.query_history_latest_db.value = db;
querywindow.document.querywindow.table.value = table;
querywindow.document.querywindow.query_history_latest_table.value = table;
if ( sql_query ) {
querywindow.document.querywindow.query_history_latest.value = sql_query;
}
 
querywindow.document.querywindow.submit();
}
}
}
 
function focus_querywindow( sql_query ) {
if ( querywindow && !querywindow.closed && querywindow.location) {
var querywindow = querywindow;
if ( querywindow.document.querywindow.querydisplay_tab != 'sql' ) {
querywindow.document.querywindow.querydisplay_tab.value = "sql";
querywindow.document.querywindow.query_history_latest.value = sql_query;
querywindow.document.querywindow.submit();
querywindow.focus();
} else {
querywindow.focus();
}
} else {
url = 'querywindow.php?' + common_query + '&db=' + db + '&table=' + table + '&sql_query=' + sql_query;
open_querywindow( url );
}
}
 
function open_querywindow( url ) {
if ( ! url ) {
url = 'querywindow.php?' + common_query + '&db=' + db + '&table=' + table;
}
 
if (!querywindow.closed && querywindow.location) {
goTo( url, 'query' );
querywindow.focus();
} else {
querywindow=window.open( url, '',
'toolbar=0,location=0,directories=0,status=1,menubar=0,' +
'scrollbars=yes,resizable=yes,' +
'width=' + querywindow_width + ',' +
'height=' + querywindow_height );
}
 
if ( ! querywindow.opener ) {
querywindow.opener = window.window;
}
 
if ( window.focus ) {
querywindow.focus();
}
 
return true;
}
 
function refreshQuerywindow( url ) {
 
if ( ! querywindow.closed && querywindow.location ) {
if ( ! querywindow.document.sqlform.LockFromUpdate
|| ! querywindow.document.sqlform.LockFromUpdate.checked ) {
open_querywindow( url )
}
}
}
 
/**
* opens new url in target frame, with default beeing left frame
* valid is 'main' and 'querywindow' all others leads to 'left'
*
* @param string targeturl new url to load
* @param string target frame where to load the new url
*/
function goTo( targeturl, target ) {
//alert('goto');
if ( target == 'main' ) {
if (text_dir == 'ltr') {
target = window.frames[1];
} else {
target = window.frames[0];
}
} else if ( target == 'query' ) {
target = querywindow;
//return open_querywindow( targeturl );
} else if ( ! target ) {
if (text_dir == 'ltr') {
target = window.frames[0];
} else {
target = window.frames[1];
}
}
 
if ( target ) {
if ( target.location.href == targeturl ) {
return true;
} else if ( target.location.href == pma_absolute_uri + targeturl ) {
return true;
}
if ( safari_browser ) {
target.location.href = targeturl;
} else {
target.location.replace(targeturl);
}
}
 
return true;
}
 
// opens selected db in main frame
function openDb( new_db ) {
//alert('opendb(' + new_db + ')');
setDb( new_db );
setTable( '' );
refreshMain( opendb_url );
return true;
}
 
function updateTableTitle( table_link_id, new_title ) {
//alert('updateTableTitle');
if ( window.parent.frames[0].document.getElementById(table_link_id) ) {
var left = window.parent.frames[0].document;
left.getElementById(table_link_id).title = new_title;
new_title = left.getElementById('icon_' + table_link_id).alt + ': ' + new_title;
left.getElementById('browse_' + table_link_id).title = new_title;
return true;
}
return false;
}