| blob | 12c6a653c70c43541dfd8e2774c7eb5ea84144e9 |
1 /* vim: set expandtab sw=4 ts=4 sts=4: */
2 /**
3 * general function, usually for data manipulation pages
4 *
5 */
7 /**
8 * @var sql_box_locked lock for the sqlbox textarea in the querybox/querywindow
9 */
10 var sql_box_locked = false;
12 /**
13 * @var array holds elements which content should only selected once
14 */
15 var only_once_elements = new Array();
17 /**
18 * @var int ajax_message_count Number of AJAX messages shown since page load
19 */
20 var ajax_message_count = 0;
22 /**
23 * @var codemirror_editor object containing CodeMirror editor
24 */
25 var codemirror_editor = false;
27 /**
28 * @var chart_activeTimeouts object active timeouts that refresh the charts. When disabling a realtime chart, this can be used to stop the continuous ajax requests
29 */
30 var chart_activeTimeouts = new Object();
32 /**
33 * Returns browser's viewport size, without accounting for scrollbars
34 *
35 * @param window wnd
36 */
37 function getWindowSize(wnd) {
38 var vp = wnd || window;
39 return {
40 // most browsers || IE6-8 strict || failsafe
41 width: vp.innerWidth || (vp.documentElement !== undefined ? vp.documentElement.clientWidth : false) || $(vp).width(),
42 height: vp.innerHeight || (vp.documentElement !== undefined ? vp.documentElement.clientHeight : false) || $(vp).height()
43 };
44 }
46 /**
47 * Make sure that ajax requests will not be cached
48 * by appending a random variable to their parameters
49 */
50 $.ajaxPrefilter(function (options, originalOptions, jqXHR) {
51 var nocache = new Date().getTime() + "" + Math.floor(Math.random() * 1000000);
52 if (typeof options.data == "string") {
53 options.data += "&_nocache=" + nocache;
54 } else if (typeof options.data == "object") {
55 options.data = $.extend(originalOptions.data, {'_nocache':nocache});
56 }
57 });
59 /**
60 * Add a hidden field to the form to indicate that this will be an
61 * Ajax request (only if this hidden field does not exist)
62 *
63 * @param object the form
64 */
65 function PMA_prepareForAjaxRequest($form)
66 {
67 if (! $form.find('input:hidden').is('#ajax_request_hidden')) {
68 $form.append('<input type="hidden" id="ajax_request_hidden" name="ajax_request" value="true" />');
69 }
70 }
72 /**
73 * Generate a new password and copy it to the password input areas
74 *
75 * @param object the form that holds the password fields
76 *
77 * @return boolean always true
78 */
79 function suggestPassword(passwd_form)
80 {
81 // restrict the password to just letters and numbers to avoid problems:
82 // "editors and viewers regard the password as multiple words and
83 // things like double click no longer work"
84 var pwchars = "abcdefhjmnpqrstuvwxyz23456789ABCDEFGHJKLMNPQRSTUVWYXZ";
85 var passwordlength = 16; // do we want that to be dynamic? no, keep it simple :)
86 var passwd = passwd_form.generated_pw;
87 passwd.value = '';
89 for ( i = 0; i < passwordlength; i++ ) {
90 passwd.value += pwchars.charAt( Math.floor( Math.random() * pwchars.length ) )
91 }
92 passwd_form.text_pma_pw.value = passwd.value;
93 passwd_form.text_pma_pw2.value = passwd.value;
94 return true;
95 }
97 /**
98 * Version string to integer conversion.
99 */
100 function parseVersionString (str)
101 {
102 if (typeof(str) != 'string') { return false; }
103 var add = 0;
104 // Parse possible alpha/beta/rc/
105 var state = str.split('-');
106 if (state.length >= 2) {
107 if (state[1].substr(0, 2) == 'rc') {
108 add = - 20 - parseInt(state[1].substr(2));
109 } else if (state[1].substr(0, 4) == 'beta') {
110 add = - 40 - parseInt(state[1].substr(4));
111 } else if (state[1].substr(0, 5) == 'alpha') {
112 add = - 60 - parseInt(state[1].substr(5));
113 } else if (state[1].substr(0, 3) == 'dev') {
114 /* We don't handle dev, it's git snapshot */
115 add = 0;
116 }
117 }
118 // Parse version
119 var x = str.split('.');
120 // Use 0 for non existing parts
121 var maj = parseInt(x[0]) || 0;
122 var min = parseInt(x[1]) || 0;
123 var pat = parseInt(x[2]) || 0;
124 var hotfix = parseInt(x[3]) || 0;
125 return maj * 100000000 + min * 1000000 + pat * 10000 + hotfix * 100 + add;
126 }
128 /**
129 * Indicates current available version on main page.
130 */
131 function PMA_current_version()
132 {
133 var current = parseVersionString(pmaversion);
134 var latest = parseVersionString(PMA_latest_version);
135 var version_information_message = PMA_messages['strLatestAvailable'] + ' ' + PMA_latest_version;
136 if (latest > current) {
137 var message = $.sprintf(PMA_messages['strNewerVersion'], PMA_latest_version, PMA_latest_date);
138 if (Math.floor(latest / 10000) == Math.floor(current / 10000)) {
139 /* Security update */
140 klass = 'error';
141 } else {
142 klass = 'notice';
143 }
144 $('#maincontainer').after('<div class="' + klass + '">' + message + '</div>');
145 }
146 if (latest == current) {
147 version_information_message = ' (' + PMA_messages['strUpToDate'] + ')';
148 }
149 $('#li_pma_version').append(version_information_message);
150 }
152 /**
153 * for libraries/display_change_password.lib.php
154 * libraries/user_password.php
155 *
156 */
158 function displayPasswordGenerateButton()
159 {
160 $('#tr_element_before_generate_password').parent().append('<tr><td>' + PMA_messages['strGeneratePassword'] + '</td><td><input type="button" id="button_generate_password" value="' + PMA_messages['strGenerate'] + '" onclick="suggestPassword(this.form)" /><input type="text" name="generated_pw" id="generated_pw" /></td></tr>');
161 $('#div_element_before_generate_password').parent().append('<div class="item"><label for="button_generate_password">' + PMA_messages['strGeneratePassword'] + ':</label><span class="options"><input type="button" id="button_generate_password" value="' + PMA_messages['strGenerate'] + '" onclick="suggestPassword(this.form)" /></span><input type="text" name="generated_pw" id="generated_pw" /></div>');
162 }
164 /*
165 * Adds a date/time picker to an element
166 *
167 * @param object $this_element a jQuery object pointing to the element
168 */
169 function PMA_addDatepicker($this_element, options)
170 {
171 var showTimeOption = false;
172 if ($this_element.is('.datetimefield')) {
173 showTimeOption = true;
174 }
176 var defaultOptions = {
177 showOn: 'button',
178 buttonImage: themeCalendarImage, // defined in js/messages.php
179 buttonImageOnly: true,
180 stepMinutes: 1,
181 stepHours: 1,
182 showSecond: true,
183 showTimepicker: showTimeOption,
184 showButtonPanel: false,
185 dateFormat: 'yy-mm-dd', // yy means year with four digits
186 timeFormat: 'hh:mm:ss',
187 altFieldTimeOnly: false,
188 showAnim: '',
189 beforeShow: function(input, inst) {
190 // Remember that we came from the datepicker; this is used
191 // in tbl_change.js by verificationsAfterFieldChange()
192 $this_element.data('comes_from', 'datepicker');
194 // Fix wrong timepicker z-index, doesn't work without timeout
195 setTimeout(function() {
196 $('#ui-timepicker-div').css('z-index',$('#ui-datepicker-div').css('z-index'))
197 },0);
198 }
199 };
201 $this_element.datetimepicker($.extend(defaultOptions, options));
202 }
204 /**
205 * selects the content of a given object, f.e. a textarea
206 *
207 * @param object element element of which the content will be selected
208 * @param var lock variable which holds the lock for this element
209 * or true, if no lock exists
210 * @param boolean only_once if true this is only done once
211 * f.e. only on first focus
212 */
213 function selectContent( element, lock, only_once )
214 {
215 if ( only_once && only_once_elements[element.name] ) {
216 return;
217 }
219 only_once_elements[element.name] = true;
221 if ( lock ) {
222 return;
223 }
225 element.select();
226 }
228 /**
229 * Displays a confirmation box before submitting a "DROP/DELETE/ALTER" query.
230 * This function is called while clicking links
231 *
232 * @param object the link
233 * @param object the sql query to submit
234 *
235 * @return boolean whether to run the query or not
236 */
237 function confirmLink(theLink, theSqlQuery)
238 {
239 // Confirmation is not required in the configuration file
240 // or browser is Opera (crappy js implementation)
241 if (PMA_messages['strDoYouReally'] == '' || typeof(window.opera) != 'undefined') {
242 return true;
243 }
245 var is_confirmed = confirm(PMA_messages['strDoYouReally'] + ' :\n' + theSqlQuery);
246 if (is_confirmed) {
247 if ( $(theLink).hasClass('formLinkSubmit') ) {
248 var name = 'is_js_confirmed';
249 if ($(theLink).attr('href').indexOf('usesubform') != -1) {
250 name = 'subform[' + $(theLink).attr('href').substr('#').match(/usesubform\[(\d+)\]/i)[1] + '][is_js_confirmed]';
251 }
253 $(theLink).parents('form').append('<input type="hidden" name="' + name + '" value="1" />');
254 } else if ( typeof(theLink.href) != 'undefined' ) {
255 theLink.href += '&is_js_confirmed=1';
256 } else if ( typeof(theLink.form) != 'undefined' ) {
257 theLink.form.action += '?is_js_confirmed=1';
258 }
259 }
261 return is_confirmed;
262 } // end of the 'confirmLink()' function
264 /**
265 * Displays an error message if a "DROP DATABASE" statement is submitted
266 * while it isn't allowed, else confirms a "DROP/DELETE/ALTER" query before
267 * sumitting it if required.
268 * This function is called by the 'checkSqlQuery()' js function.
269 *
270 * @param object the form
271 * @param object the sql query textarea
272 *
273 * @return boolean whether to run the query or not
274 *
275 * @see checkSqlQuery()
276 */
277 function confirmQuery(theForm1, sqlQuery1)
278 {
279 // Confirmation is not required in the configuration file
280 if (PMA_messages['strDoYouReally'] == '') {
281 return true;
282 }
284 // "DROP DATABASE" statement isn't allowed
285 if (PMA_messages['strNoDropDatabases'] != '') {
286 var drop_re = new RegExp('(^|;)\\s*DROP\\s+(IF EXISTS\\s+)?DATABASE\\s', 'i');
287 if (drop_re.test(sqlQuery1.value)) {
288 alert(PMA_messages['strNoDropDatabases']);
289 theForm1.reset();
290 sqlQuery1.focus();
291 return false;
292 } // end if
293 } // end if
295 // Confirms a "DROP/DELETE/ALTER/TRUNCATE" statement
296 //
297 // TODO: find a way (if possible) to use the parser-analyser
298 // for this kind of verification
299 // For now, I just added a ^ to check for the statement at
300 // beginning of expression
302 var do_confirm_re_0 = new RegExp('^\\s*DROP\\s+(IF EXISTS\\s+)?(TABLE|DATABASE|PROCEDURE)\\s', 'i');
303 var do_confirm_re_1 = new RegExp('^\\s*ALTER\\s+TABLE\\s+((`[^`]+`)|([A-Za-z0-9_$]+))\\s+DROP\\s', 'i');
304 var do_confirm_re_2 = new RegExp('^\\s*DELETE\\s+FROM\\s', 'i');
305 var do_confirm_re_3 = new RegExp('^\\s*TRUNCATE\\s', 'i');
307 if (do_confirm_re_0.test(sqlQuery1.value)
308 || do_confirm_re_1.test(sqlQuery1.value)
309 || do_confirm_re_2.test(sqlQuery1.value)
310 || do_confirm_re_3.test(sqlQuery1.value)) {
311 var message = (sqlQuery1.value.length > 100)
312 ? sqlQuery1.value.substr(0, 100) + '\n ...'
313 : sqlQuery1.value;
314 var is_confirmed = confirm(PMA_messages['strDoYouReally'] + ' :\n' + message);
315 // statement is confirmed -> update the
316 // "is_js_confirmed" form field so the confirm test won't be
317 // run on the server side and allows to submit the form
318 if (is_confirmed) {
319 theForm1.elements['is_js_confirmed'].value = 1;
320 return true;
321 }
322 // statement is rejected -> do not submit the form
323 else {
324 window.focus();
325 sqlQuery1.focus();
326 return false;
327 } // end if (handle confirm box result)
328 } // end if (display confirm box)
330 return true;
331 } // end of the 'confirmQuery()' function
334 /**
335 * Displays a confirmation box before disabling the BLOB repository for a given database.
336 * This function is called while clicking links
337 *
338 * @param object the database
339 *
340 * @return boolean whether to disable the repository or not
341 */
342 function confirmDisableRepository(theDB)
343 {
344 // Confirmation is not required in the configuration file
345 // or browser is Opera (crappy js implementation)
346 if (PMA_messages['strDoYouReally'] == '' || typeof(window.opera) != 'undefined') {
347 return true;
348 }
350 var is_confirmed = confirm(PMA_messages['strBLOBRepositoryDisableStrongWarning'] + '\n' + PMA_messages['strBLOBRepositoryDisableAreYouSure']);
352 return is_confirmed;
353 } // end of the 'confirmDisableBLOBRepository()' function
356 /**
357 * Displays an error message if the user submitted the sql query form with no
358 * sql query, else checks for "DROP/DELETE/ALTER" statements
359 *
360 * @param object the form
361 *
362 * @return boolean always false
363 *
364 * @see confirmQuery()
365 */
366 function checkSqlQuery(theForm)
367 {
368 var sqlQuery = theForm.elements['sql_query'];
369 var isEmpty = 1;
371 var space_re = new RegExp('\\s+');
372 if (typeof(theForm.elements['sql_file']) != 'undefined' &&
373 theForm.elements['sql_file'].value.replace(space_re, '') != '') {
374 return true;
375 }
376 if (typeof(theForm.elements['sql_localfile']) != 'undefined' &&
377 theForm.elements['sql_localfile'].value.replace(space_re, '') != '') {
378 return true;
379 }
380 if (isEmpty && typeof(theForm.elements['id_bookmark']) != 'undefined' &&
381 (theForm.elements['id_bookmark'].value != null || theForm.elements['id_bookmark'].value != '') &&
382 theForm.elements['id_bookmark'].selectedIndex != 0
383 ) {
384 return true;
385 }
386 // Checks for "DROP/DELETE/ALTER" statements
387 if (sqlQuery.value.replace(space_re, '') != '') {
388 if (confirmQuery(theForm, sqlQuery)) {
389 return true;
390 } else {
391 return false;
392 }
393 }
394 theForm.reset();
395 isEmpty = 1;
397 if (isEmpty) {
398 sqlQuery.select();
399 alert(PMA_messages['strFormEmpty']);
400 sqlQuery.focus();
401 return false;
402 }
404 return true;
405 } // end of the 'checkSqlQuery()' function
407 /**
408 * Check if a form's element is empty.
409 * An element containing only spaces is also considered empty
410 *
411 * @param object the form
412 * @param string the name of the form field to put the focus on
413 *
414 * @return boolean whether the form field is empty or not
415 */
416 function emptyCheckTheField(theForm, theFieldName)
417 {
418 var theField = theForm.elements[theFieldName];
419 var space_re = new RegExp('\\s+');
420 return (theField.value.replace(space_re, '') == '') ? 1 : 0;
421 } // end of the 'emptyCheckTheField()' function
424 /**
425 * Check whether a form field is empty or not
426 *
427 * @param object the form
428 * @param string the name of the form field to put the focus on
429 *
430 * @return boolean whether the form field is empty or not
431 */
432 function emptyFormElements(theForm, theFieldName)
433 {
434 var theField = theForm.elements[theFieldName];
435 var isEmpty = emptyCheckTheField(theForm, theFieldName);
438 return isEmpty;
439 } // end of the 'emptyFormElements()' function
442 /**
443 * Ensures a value submitted in a form is numeric and is in a range
444 *
445 * @param object the form
446 * @param string the name of the form field to check
447 * @param integer the minimum authorized value
448 * @param integer the maximum authorized value
449 *
450 * @return boolean whether a valid number has been submitted or not
451 */
452 function checkFormElementInRange(theForm, theFieldName, message, min, max)
453 {
454 var theField = theForm.elements[theFieldName];
455 var val = parseInt(theField.value);
457 if (typeof(min) == 'undefined') {
458 min = 0;
459 }
460 if (typeof(max) == 'undefined') {
461 max = Number.MAX_VALUE;
462 }
464 // It's not a number
465 if (isNaN(val)) {
466 theField.select();
467 alert(PMA_messages['strNotNumber']);
468 theField.focus();
469 return false;
470 }
471 // It's a number but it is not between min and max
472 else if (val < min || val > max) {
473 theField.select();
474 alert(message.replace('%d', val));
475 theField.focus();
476 return false;
477 }
478 // It's a valid number
479 else {
480 theField.value = val;
481 }
482 return true;
484 } // end of the 'checkFormElementInRange()' function
487 function checkTableEditForm(theForm, fieldsCnt)
488 {
489 // TODO: avoid sending a message if user just wants to add a line
490 // on the form but has not completed at least one field name
492 var atLeastOneField = 0;
493 var i, elm, elm2, elm3, val, id;
495 for (i=0; i<fieldsCnt; i++)
496 {
497 id = "#field_" + i + "_2";
498 elm = $(id);
499 val = elm.val()
500 if (val == 'VARCHAR' || val == 'CHAR' || val == 'BIT' || val == 'VARBINARY' || val == 'BINARY') {
501 elm2 = $("#field_" + i + "_3");
502 val = parseInt(elm2.val());
503 elm3 = $("#field_" + i + "_1");
504 if (isNaN(val) && elm3.val() != "") {
505 elm2.select();
506 alert(PMA_messages['strNotNumber']);
507 elm2.focus();
508 return false;
509 }
510 }
512 if (atLeastOneField == 0) {
513 id = "field_" + i + "_1";
514 if (!emptyCheckTheField(theForm, id)) {
515 atLeastOneField = 1;
516 }
517 }
518 }
519 if (atLeastOneField == 0) {
520 var theField = theForm.elements["field_0_1"];
521 alert(PMA_messages['strFormEmpty']);
522 theField.focus();
523 return false;
524 }
526 // at least this section is under jQuery
527 if ($("input.textfield[name='table']").val() == "") {
528 alert(PMA_messages['strFormEmpty']);
529 $("input.textfield[name='table']").focus();
530 return false;
531 }
534 return true;
535 } // enf of the 'checkTableEditForm()' function
537 $(document).ready(function() {
538 /**
539 * Row marking in horizontal mode (use "live" so that it works also for
540 * next pages reached via AJAX); a tr may have the class noclick to remove
541 * this behavior.
542 */
543 $('table:not(.noclick) tr.odd:not(.noclick), table:not(.noclick) tr.even:not(.noclick)').live('click',function(e) {
544 // do not trigger when clicked on anchor
545 if ($(e.target).is('a, img, a *')) {
546 return;
547 }
548 var $tr = $(this);
550 // make the table unselectable (to prevent default highlighting when shift+click)
551 //$tr.parents('table').noSelect();
553 if (!e.shiftKey || last_clicked_row == -1) {
554 // usual click
556 // XXX: FF fires two click events for <label> (label and checkbox), so we need to handle this differently
557 var $checkbox = $tr.find(':checkbox');
558 if ($checkbox.length) {
559 // checkbox in a row, add or remove class depending on checkbox state
560 var checked = $checkbox.attr('checked');
561 if (!$(e.target).is(':checkbox, label')) {
562 checked = !checked;
563 $checkbox.attr('checked', checked);
564 }
565 if (checked) {
566 $tr.addClass('marked');
567 } else {
568 $tr.removeClass('marked');
569 }
570 last_click_checked = checked;
571 } else {
572 // normaln data table, just toggle class
573 $tr.toggleClass('marked');
574 last_click_checked = false;
575 }
577 // remember the last clicked row
578 last_clicked_row = last_click_checked ? $('tr.odd:not(.noclick), tr.even:not(.noclick)').index(this) : -1;
579 last_shift_clicked_row = -1;
580 } else {
581 // handle the shift click
582 PMA_clearSelection();
583 var start, end;
585 // clear last shift click result
586 if (last_shift_clicked_row >= 0) {
587 if (last_shift_clicked_row >= last_clicked_row) {
588 start = last_clicked_row;
589 end = last_shift_clicked_row;
590 } else {
591 start = last_shift_clicked_row;
592 end = last_clicked_row;
593 }
594 $tr.parent().find('tr.odd:not(.noclick), tr.even:not(.noclick)')
595 .slice(start, end + 1)
596 .removeClass('marked')
597 .find(':checkbox')
598 .attr('checked', false);
599 }
601 // handle new shift click
602 var curr_row = $('tr.odd:not(.noclick), tr.even:not(.noclick)').index(this);
603 if (curr_row >= last_clicked_row) {
604 start = last_clicked_row;
605 end = curr_row;
606 } else {
607 start = curr_row;
608 end = last_clicked_row;
609 }
610 $tr.parent().find('tr.odd:not(.noclick), tr.even:not(.noclick)')
611 .slice(start, end + 1)
612 .addClass('marked')
613 .find(':checkbox')
614 .attr('checked', true);
616 // remember the last shift clicked row
617 last_shift_clicked_row = curr_row;
618 }
619 });
621 /**
622 * Add a date/time picker to each element that needs it
623 * (only when timepicker.js is loaded)
624 */
625 if ($.timepicker != undefined) {
626 $('.datefield, .datetimefield').each(function() {
627 PMA_addDatepicker($(this));
628 });
629 }
630 });
632 /**
633 * True if last click is to check a row.
634 */
635 var last_click_checked = false;
637 /**
638 * Zero-based index of last clicked row.
639 * Used to handle the shift + click event in the code above.
640 */
641 var last_clicked_row = -1;
643 /**
644 * Zero-based index of last shift clicked row.
645 */
646 var last_shift_clicked_row = -1;
648 /**
649 * Row highlighting in horizontal mode (use "live"
650 * so that it works also for pages reached via AJAX)
651 */
652 /*$(document).ready(function() {
653 $('tr.odd, tr.even').live('hover',function(event) {
654 var $tr = $(this);
655 $tr.toggleClass('hover',event.type=='mouseover');
656 $tr.children().toggleClass('hover',event.type=='mouseover');
657 });
658 })*/
660 /**
661 * This array is used to remember mark status of rows in browse mode
662 */
663 var marked_row = new Array;
665 /**
666 * marks all rows and selects its first checkbox inside the given element
667 * the given element is usaly a table or a div containing the table or tables
668 *
669 * @param container DOM element
670 */
671 function markAllRows( container_id )
672 {
674 $("#"+container_id).find("input:checkbox:enabled").attr('checked', 'checked')
675 .parents("tr").addClass("marked");
676 return true;
677 }
679 /**
680 * marks all rows and selects its first checkbox inside the given element
681 * the given element is usaly a table or a div containing the table or tables
682 *
683 * @param container DOM element
684 */
685 function unMarkAllRows( container_id )
686 {
688 $("#"+container_id).find("input:checkbox:enabled").removeAttr('checked')
689 .parents("tr").removeClass("marked");
690 return true;
691 }
693 /**
694 * Checks/unchecks all checkbox in given conainer (f.e. a form, fieldset or div)
695 *
696 * @param string container_id the container id
697 * @param boolean state new value for checkbox (true or false)
698 * @return boolean always true
699 */
700 function setCheckboxes( container_id, state )
701 {
703 if(state) {
704 $("#"+container_id).find("input:checkbox").attr('checked', 'checked');
705 }
706 else {
707 $("#"+container_id).find("input:checkbox").removeAttr('checked');
708 }
710 return true;
711 } // end of the 'setCheckboxes()' function
713 /**
714 * Checks/unchecks all options of a <select> element
715 *
716 * @param string the form name
717 * @param string the element name
718 * @param boolean whether to check or to uncheck options
719 *
720 * @return boolean always true
721 */
722 function setSelectOptions(the_form, the_select, do_check)
723 {
724 $("form[name='"+ the_form +"'] select[name='"+the_select+"']").find("option").attr('selected', do_check);
725 return true;
726 } // end of the 'setSelectOptions()' function
728 /**
729 * Sets current value for query box.
730 */
731 function setQuery(query)
732 {
733 if (codemirror_editor) {
734 codemirror_editor.setValue(query);
735 } else {
736 document.sqlform.sql_query.value = query;
737 }
738 }
741 /**
742 * Create quick sql statements.
743 *
744 */
745 function insertQuery(queryType)
746 {
747 if (queryType == "clear") {
748 setQuery('');
749 return;
750 }
752 var myQuery = document.sqlform.sql_query;
753 var query = "";
754 var myListBox = document.sqlform.dummy;
755 var table = document.sqlform.table.value;
757 if (myListBox.options.length > 0) {
758 sql_box_locked = true;
759 var chaineAj = "";
760 var valDis = "";
761 var editDis = "";
762 var NbSelect = 0;
763 for (var i=0; i < myListBox.options.length; i++) {
764 NbSelect++;
765 if (NbSelect > 1) {
766 chaineAj += ", ";
767 valDis += ",";
768 editDis += ",";
769 }
770 chaineAj += myListBox.options[i].value;
771 valDis += "[value-" + NbSelect + "]";
772 editDis += myListBox.options[i].value + "=[value-" + NbSelect + "]";
773 }
774 if (queryType == "selectall") {
775 query = "SELECT * FROM `" + table + "` WHERE 1";
776 } else if (queryType == "select") {
777 query = "SELECT " + chaineAj + " FROM `" + table + "` WHERE 1";
778 } else if (queryType == "insert") {
779 query = "INSERT INTO `" + table + "`(" + chaineAj + ") VALUES (" + valDis + ")";
780 } else if (queryType == "update") {
781 query = "UPDATE `" + table + "` SET " + editDis + " WHERE 1";
782 } else if(queryType == "delete") {
783 query = "DELETE FROM `" + table + "` WHERE 1";
784 }
785 setQuery(query);
786 sql_box_locked = false;
787 }
788 }
791 /**
792 * Inserts multiple fields.
793 *
794 */
795 function insertValueQuery()
796 {
797 var myQuery = document.sqlform.sql_query;
798 var myListBox = document.sqlform.dummy;
800 if(myListBox.options.length > 0) {
801 sql_box_locked = true;
802 var chaineAj = "";
803 var NbSelect = 0;
804 for(var i=0; i<myListBox.options.length; i++) {
805 if (myListBox.options[i].selected) {
806 NbSelect++;
807 if (NbSelect > 1) {
808 chaineAj += ", ";
809 }
810 chaineAj += myListBox.options[i].value;
811 }
812 }
814 /* CodeMirror support */
815 if (codemirror_editor) {
816 codemirror_editor.replaceSelection(chaineAj);
817 //IE support
818 } else if (document.selection) {
819 myQuery.focus();
820 sel = document.selection.createRange();
821 sel.text = chaineAj;
822 document.sqlform.insert.focus();
823 }
824 //MOZILLA/NETSCAPE support
825 else if (document.sqlform.sql_query.selectionStart || document.sqlform.sql_query.selectionStart == "0") {
826 var startPos = document.sqlform.sql_query.selectionStart;
827 var endPos = document.sqlform.sql_query.selectionEnd;
828 var chaineSql = document.sqlform.sql_query.value;
830 myQuery.value = chaineSql.substring(0, startPos) + chaineAj + chaineSql.substring(endPos, chaineSql.length);
831 } else {
832 myQuery.value += chaineAj;
833 }
834 sql_box_locked = false;
835 }
836 }
838 /**
839 * listbox redirection
840 */
841 function goToUrl(selObj, goToLocation)
842 {
843 eval("document.location.href = '" + goToLocation + "pos=" + selObj.options[selObj.selectedIndex].value + "'");
844 }
846 /**
847 * Refresh the WYSIWYG scratchboard after changes have been made
848 */
849 function refreshDragOption(e)
850 {
851 var elm = $('#' + e);
852 if (elm.css('visibility') == 'visible') {
853 refreshLayout();
854 TableDragInit();
855 }
856 }
858 /**
859 * Refresh/resize the WYSIWYG scratchboard
860 */
861 function refreshLayout()
862 {
863 var elm = $('#pdflayout')
864 var orientation = $('#orientation_opt').val();
865 if($('#paper_opt').length==1){
866 var paper = $('#paper_opt').val();
867 }else{
868 var paper = 'A4';
869 }
870 if (orientation == 'P') {
871 posa = 'x';
872 posb = 'y';
873 } else {
874 posa = 'y';
875 posb = 'x';
876 }
877 elm.css('width', pdfPaperSize(paper, posa) + 'px');
878 elm.css('height', pdfPaperSize(paper, posb) + 'px');
879 }
881 /**
882 * Show/hide the WYSIWYG scratchboard
883 */
884 function ToggleDragDrop(e)
885 {
886 var elm = $('#' + e);
887 if (elm.css('visibility') == 'hidden') {
888 PDFinit(); /* Defined in pdf_pages.php */
889 elm.css('visibility', 'visible');
890 elm.css('display', 'block');
891 $('#showwysiwyg').val('1')
892 } else {
893 elm.css('visibility', 'hidden');
894 elm.css('display', 'none');
895 $('#showwysiwyg').val('0')
896 }
897 }
899 /**
900 * PDF scratchboard: When a position is entered manually, update
901 * the fields inside the scratchboard.
902 */
903 function dragPlace(no, axis, value)
904 {
905 var elm = $('#table_' + no);
906 if (axis == 'x') {
907 elm.css('left', value + 'px');
908 } else {
909 elm.css('top', value + 'px');
910 }
911 }
913 /**
914 * Returns paper sizes for a given format
915 */
916 function pdfPaperSize(format, axis)
917 {
918 switch (format.toUpperCase()) {
919 case '4A0':
920 if (axis == 'x') return 4767.87; else return 6740.79;
921 break;
922 case '2A0':
923 if (axis == 'x') return 3370.39; else return 4767.87;
924 break;
925 case 'A0':
926 if (axis == 'x') return 2383.94; else return 3370.39;
927 break;
928 case 'A1':
929 if (axis == 'x') return 1683.78; else return 2383.94;
930 break;
931 case 'A2':
932 if (axis == 'x') return 1190.55; else return 1683.78;
933 break;
934 case 'A3':
935 if (axis == 'x') return 841.89; else return 1190.55;
936 break;
937 case 'A4':
938 if (axis == 'x') return 595.28; else return 841.89;
939 break;
940 case 'A5':
941 if (axis == 'x') return 419.53; else return 595.28;
942 break;
943 case 'A6':
944 if (axis == 'x') return 297.64; else return 419.53;
945 break;
946 case 'A7':
947 if (axis == 'x') return 209.76; else return 297.64;
948 break;
949 case 'A8':
950 if (axis == 'x') return 147.40; else return 209.76;
951 break;
952 case 'A9':
953 if (axis == 'x') return 104.88; else return 147.40;
954 break;
955 case 'A10':
956 if (axis == 'x') return 73.70; else return 104.88;
957 break;
958 case 'B0':
959 if (axis == 'x') return 2834.65; else return 4008.19;
960 break;
961 case 'B1':
962 if (axis == 'x') return 2004.09; else return 2834.65;
963 break;
964 case 'B2':
965 if (axis == 'x') return 1417.32; else return 2004.09;
966 break;
967 case 'B3':
968 if (axis == 'x') return 1000.63; else return 1417.32;
969 break;
970 case 'B4':
971 if (axis == 'x') return 708.66; else return 1000.63;
972 break;
973 case 'B5':
974 if (axis == 'x') return 498.90; else return 708.66;
975 break;
976 case 'B6':
977 if (axis == 'x') return 354.33; else return 498.90;
978 break;
979 case 'B7':
980 if (axis == 'x') return 249.45; else return 354.33;
981 break;
982 case 'B8':
983 if (axis == 'x') return 175.75; else return 249.45;
984 break;
985 case 'B9':
986 if (axis == 'x') return 124.72; else return 175.75;
987 break;
988 case 'B10':
989 if (axis == 'x') return 87.87; else return 124.72;
990 break;
991 case 'C0':
992 if (axis == 'x') return 2599.37; else return 3676.54;
993 break;
994 case 'C1':
995 if (axis == 'x') return 1836.85; else return 2599.37;
996 break;
997 case 'C2':
998 if (axis == 'x') return 1298.27; else return 1836.85;
999 break;
1000 case 'C3':
1001 if (axis == 'x') return 918.43; else return 1298.27;
1002 break;
1003 case 'C4':
1004 if (axis == 'x') return 649.13; else return 918.43;
1005 break;
1006 case 'C5':
1007 if (axis == 'x') return 459.21; else return 649.13;
1008 break;
1009 case 'C6':
1010 if (axis == 'x') return 323.15; else return 459.21;
1011 break;
1012 case 'C7':
1013 if (axis == 'x') return 229.61; else return 323.15;
1014 break;
1015 case 'C8':
1016 if (axis == 'x') return 161.57; else return 229.61;
1017 break;
1018 case 'C9':
1019 if (axis == 'x') return 113.39; else return 161.57;
1020 break;
1021 case 'C10':
1022 if (axis == 'x') return 79.37; else return 113.39;
1023 break;
1024 case 'RA0':
1025 if (axis == 'x') return 2437.80; else return 3458.27;
1026 break;
1027 case 'RA1':
1028 if (axis == 'x') return 1729.13; else return 2437.80;
1029 break;
1030 case 'RA2':
1031 if (axis == 'x') return 1218.90; else return 1729.13;
1032 break;
1033 case 'RA3':
1034 if (axis == 'x') return 864.57; else return 1218.90;
1035 break;
1036 case 'RA4':
1037 if (axis == 'x') return 609.45; else return 864.57;
1038 break;
1039 case 'SRA0':
1040 if (axis == 'x') return 2551.18; else return 3628.35;
1041 break;
1042 case 'SRA1':
1043 if (axis == 'x') return 1814.17; else return 2551.18;
1044 break;
1045 case 'SRA2':
1046 if (axis == 'x') return 1275.59; else return 1814.17;
1047 break;
1048 case 'SRA3':
1049 if (axis == 'x') return 907.09; else return 1275.59;
1050 break;
1051 case 'SRA4':
1052 if (axis == 'x') return 637.80; else return 907.09;
1053 break;
1054 case 'LETTER':
1055 if (axis == 'x') return 612.00; else return 792.00;
1056 break;
1057 case 'LEGAL':
1058 if (axis == 'x') return 612.00; else return 1008.00;
1059 break;
1060 case 'EXECUTIVE':
1061 if (axis == 'x') return 521.86; else return 756.00;
1062 break;
1063 case 'FOLIO':
1064 if (axis == 'x') return 612.00; else return 936.00;
1065 break;
1066 } // end switch
1068 return 0;
1069 }
1071 /**
1072 * for playing media from the BLOB repository
1073 *
1074 * @param var
1075 * @param var url_params main purpose is to pass the token
1076 * @param var bs_ref BLOB repository reference
1077 * @param var m_type type of BLOB repository media
1078 * @param var w_width width of popup window
1079 * @param var w_height height of popup window
1080 */
1081 function popupBSMedia(url_params, bs_ref, m_type, is_cust_type, w_width, w_height)
1082 {
1083 // if width not specified, use default
1084 if (w_width == undefined) {
1085 w_width = 640;
1086 }
1088 // if height not specified, use default
1089 if (w_height == undefined) {
1090 w_height = 480;
1091 }
1093 // open popup window (for displaying video/playing audio)
1094 var mediaWin = window.open('bs_play_media.php?' + url_params + '&bs_reference=' + bs_ref + '&media_type=' + m_type + '&custom_type=' + is_cust_type, 'viewBSMedia', 'width=' + w_width + ', height=' + w_height + ', resizable=1, scrollbars=1, status=0');
1095 }
1097 /**
1098 * popups a request for changing MIME types for files in the BLOB repository
1099 *
1100 * @param var db database name
1101 * @param var table table name
1102 * @param var reference BLOB repository reference
1103 * @param var current_mime_type current MIME type associated with BLOB repository reference
1104 */
1105 function requestMIMETypeChange(db, table, reference, current_mime_type)
1106 {
1107 // no mime type specified, set to default (nothing)
1108 if (undefined == current_mime_type) {
1109 current_mime_type = "";
1110 }
1112 // prompt user for new mime type
1113 var new_mime_type = prompt("Enter custom MIME type", current_mime_type);
1115 // if new mime_type is specified and is not the same as the previous type, request for mime type change
1116 if (new_mime_type && new_mime_type != current_mime_type) {
1117 changeMIMEType(db, table, reference, new_mime_type);
1118 }
1119 }
1121 /**
1122 * changes MIME types for files in the BLOB repository
1123 *
1124 * @param var db database name
1125 * @param var table table name
1126 * @param var reference BLOB repository reference
1127 * @param var mime_type new MIME type to be associated with BLOB repository reference
1128 */
1129 function changeMIMEType(db, table, reference, mime_type)
1130 {
1131 // specify url and parameters for jQuery POST
1132 var mime_chg_url = 'bs_change_mime_type.php';
1133 var params = {bs_db: db, bs_table: table, bs_reference: reference, bs_new_mime_type: mime_type};
1135 // jQuery POST
1136 jQuery.post(mime_chg_url, params);
1137 }
1139 /**
1140 * Jquery Coding for inline editing SQL_QUERY
1141 */
1142 $(document).ready(function(){
1143 $(".inline_edit_sql").live('click', function(){
1144 var $form = $(this).prev();
1145 var sql_query = $form.find("input[name='sql_query']").val();
1146 var $inner_sql = $(this).parent().prev().find('.inner_sql');
1147 var old_text = $inner_sql.html();
1149 var new_content = "<textarea name=\"sql_query_edit\" id=\"sql_query_edit\">" + sql_query + "</textarea>\n";
1150 new_content += "<input type=\"button\" class=\"btnSave\" value=\"" + PMA_messages['strGo'] + "\">\n";
1151 new_content += "<input type=\"button\" class=\"btnDiscard\" value=\"" + PMA_messages['strCancel'] + "\">\n";
1152 $inner_sql.replaceWith(new_content);
1153 $(".btnSave").click(function(){
1154 var sql_query = $(this).prev().val();
1155 var $fake_form = $('<form>', {action: 'import.php', method: 'post'})
1156 .append($form.find("input[name=server], input[name=db], input[name=table], input[name=token]").clone())
1157 .append($('<input>', {type: 'hidden', name: 'show_query', value: 1}))
1158 .append($('<input>', {type: 'hidden', name: 'sql_query', value: sql_query}));
1159 $fake_form.appendTo($('body')).submit();
1160 });
1161 $(".btnDiscard").click(function(){
1162 $(this).closest(".sql").html("<span class=\"syntax\"><span class=\"inner_sql\">" + old_text + "</span></span>");
1163 });
1164 return false;
1165 });
1167 $('.sqlbutton').click(function(evt){
1168 insertQuery(evt.target.id);
1169 return false;
1170 });
1172 $("#export_type").change(function(){
1173 if($("#export_type").val()=='svg'){
1174 $("#show_grid_opt").attr("disabled","disabled");
1175 $("#orientation_opt").attr("disabled","disabled");
1176 $("#with_doc").attr("disabled","disabled");
1177 $("#show_table_dim_opt").removeAttr("disabled");
1178 $("#all_table_same_wide").removeAttr("disabled");
1179 $("#paper_opt").removeAttr("disabled","disabled");
1180 $("#show_color_opt").removeAttr("disabled","disabled");
1181 //$(this).css("background-color","yellow");
1182 }else if($("#export_type").val()=='dia'){
1183 $("#show_grid_opt").attr("disabled","disabled");
1184 $("#with_doc").attr("disabled","disabled");
1185 $("#show_table_dim_opt").attr("disabled","disabled");
1186 $("#all_table_same_wide").attr("disabled","disabled");
1187 $("#paper_opt").removeAttr("disabled","disabled");
1188 $("#show_color_opt").removeAttr("disabled","disabled");
1189 $("#orientation_opt").removeAttr("disabled","disabled");
1190 }else if($("#export_type").val()=='eps'){
1191 $("#show_grid_opt").attr("disabled","disabled");
1192 $("#orientation_opt").removeAttr("disabled");
1193 $("#with_doc").attr("disabled","disabled");
1194 $("#show_table_dim_opt").attr("disabled","disabled");
1195 $("#all_table_same_wide").attr("disabled","disabled");
1196 $("#paper_opt").attr("disabled","disabled");
1197 $("#show_color_opt").attr("disabled","disabled");
1199 }else if($("#export_type").val()=='pdf'){
1200 $("#show_grid_opt").removeAttr("disabled");
1201 $("#orientation_opt").removeAttr("disabled");
1202 $("#with_doc").removeAttr("disabled","disabled");
1203 $("#show_table_dim_opt").removeAttr("disabled","disabled");
1204 $("#all_table_same_wide").removeAttr("disabled","disabled");
1205 $("#paper_opt").removeAttr("disabled","disabled");
1206 $("#show_color_opt").removeAttr("disabled","disabled");
1207 }else{
1208 // nothing
1209 }
1210 });
1212 $('#sqlquery').focus().keydown(function (e) {
1213 if (e.ctrlKey && e.keyCode == 13) {
1214 $("#sqlqueryform").submit();
1215 }
1216 });
1218 if ($('#input_username')) {
1219 if ($('#input_username').val() == '') {
1220 $('#input_username').focus();
1221 } else {
1222 $('#input_password').focus();
1223 }
1224 }
1225 });
1227 /**
1228 * Show a message on the top of the page for an Ajax request
1229 *
1230 * Sample usage:
1231 *
1232 * 1) var $msg = PMA_ajaxShowMessage();
1233 * This will show a message that reads "Loading...". Such a message will not
1234 * disappear automatically and cannot be dismissed by the user. To remove this
1235 * message either the PMA_ajaxRemoveMessage($msg) function must be called or
1236 * another message must be show with PMA_ajaxShowMessage() function.
1237 *
1238 * 2) var $msg = PMA_ajaxShowMessage(PMA_messages['strProcessingRequest']);
1239 * This is a special case. The behaviour is same as above,
1240 * just with a different message
1241 *
1242 * 3) var $msg = PMA_ajaxShowMessage('The operation was successful');
1243 * This will show a message that will disappear automatically and it can also
1244 * be dismissed by the user.
1245 *
1246 * 4) var $msg = PMA_ajaxShowMessage('Some error', false);
1247 * This will show a message that will not disappear automatically, but it
1248 * can be dismissed by the user after he has finished reading it.
1249 *
1250 * @param string message string containing the message to be shown.
1251 * optional, defaults to 'Loading...'
1252 * @param mixed timeout number of milliseconds for the message to be visible
1253 * optional, defaults to 5000. If set to 'false', the
1254 * notification will never disappear
1255 * @return jQuery object jQuery Element that holds the message div
1256 * this object can be passed to PMA_ajaxRemoveMessage()
1257 * to remove the notification
1258 */
1259 function PMA_ajaxShowMessage(message, timeout)
1260 {
1261 /**
1262 * @var self_closing Whether the notification will automatically disappear
1263 */
1264 var self_closing = true;
1265 /**
1266 * @var dismissable Whether the user will be able to remove
1267 * the notification by clicking on it
1268 */
1269 var dismissable = true;
1270 // Handle the case when a empty data.message is passed.
1271 // We don't want the empty message
1272 if (message == '') {
1273 return true;
1274 } else if (! message) {
1275 // If the message is undefined, show the default
1276 message = PMA_messages['strLoading'];
1277 dismissable = false;
1278 self_closing = false;
1279 } else if (message == PMA_messages['strProcessingRequest']) {
1280 // This is another case where the message should not disappear
1281 dismissable = false;
1282 self_closing = false;
1283 }
1284 // Figure out whether (or after how long) to remove the notification
1285 if (timeout == undefined) {
1286 timeout = 5000;
1287 } else if (timeout === false) {
1288 self_closing = false;
1289 }
1290 // Create a parent element for the AJAX messages, if necessary
1291 if ($('#loading_parent').length == 0) {
1292 $('<div id="loading_parent"></div>')
1293 .prependTo("body");
1294 }
1295 // Update message count to create distinct message elements every time
1296 ajax_message_count++;
1297 // Remove all old messages, if any
1298 $(".ajax_notification[id^=ajax_message_num]").remove();
1299 /**
1300 * @var $retval a jQuery object containing the reference
1301 * to the created AJAX message
1302 */
1303 var $retval = $(
1304 '<span class="ajax_notification" id="ajax_message_num_'
1305 + ajax_message_count +
1306 '"></span>'
1307 )
1308 .hide()
1309 .appendTo("#loading_parent")
1310 .html(message)
1311 .fadeIn('medium');
1312 // If the notification is self-closing we should create a callback to remove it
1313 if (self_closing) {
1314 $retval
1315 .delay(timeout)
1316 .fadeOut('medium', function() {
1317 if ($(this).is('.dismissable')) {
1318 // Here we should destroy the qtip instance, but
1319 // due to a bug in qtip's implementation we can
1320 // only hide it without throwing JS errors.
1321 $(this).qtip('hide');
1322 }
1323 // Remove the notification
1324 $(this).remove();
1325 });
1326 }
1327 // If the notification is dismissable we need to add the relevant class to it
1328 // and add a tooltip so that the users know that it can be removed
1329 if (dismissable) {
1330 $retval.addClass('dismissable').css('cursor', 'pointer');
1331 /**
1332 * @var qOpts Options for "Dismiss notification" tooltip
1333 */
1334 var qOpts = {
1335 show: {
1336 effect: { length: 0 },
1337 delay: 0
1338 },
1339 hide: {
1340 effect: { length: 0 },
1341 delay: 0
1342 }
1343 };
1344 /**
1345 * Add a tooltip to the notification to let the user know that (s)he
1346 * can dismiss the ajax notification by clicking on it.
1347 */
1348 PMA_createqTip($retval, PMA_messages['strDismiss'], qOpts);
1349 }
1351 return $retval;
1352 }
1354 /**
1355 * Removes the message shown for an Ajax operation when it's completed
1356 *
1357 * @param jQuery object jQuery Element that holds the notification
1358 *
1359 * @return nothing
1360 */
1361 function PMA_ajaxRemoveMessage($this_msgbox)
1362 {
1363 if ($this_msgbox != undefined && $this_msgbox instanceof jQuery) {
1364 $this_msgbox
1365 .stop(true, true)
1366 .fadeOut('medium');
1367 if ($this_msgbox.is('.dismissable')) {
1368 // Here we should destroy the qtip instance, but
1369 // due to a bug in qtip's implementation we can
1370 // only hide it without throwing JS errors.
1371 $this_msgbox.qtip('hide');
1372 } else {
1373 $this_msgbox.remove();
1374 }
1375 }
1376 }
1378 $(document).ready(function() {
1379 /**
1380 * Allows the user to dismiss a notification
1381 * created with PMA_ajaxShowMessage()
1382 */
1383 $('.ajax_notification.dismissable').live('click', function () {
1384 PMA_ajaxRemoveMessage($(this));
1385 });
1386 /**
1387 * The below two functions hide the "Dismiss notification" tooltip when a user
1388 * is hovering a link or button that is inside an ajax message
1389 */
1390 $('.ajax_notification a, .ajax_notification button, .ajax_notification input')
1391 .live('mouseover', function () {
1392 $(this).parents('.ajax_notification').qtip('hide');
1393 });
1394 $('.ajax_notification a, .ajax_notification button, .ajax_notification input')
1395 .live('mouseout', function () {
1396 $(this).parents('.ajax_notification').qtip('show');
1397 });
1398 });
1400 /**
1401 * Hides/shows the "Open in ENUM/SET editor" message, depending on the data type of the column currently selected
1402 */
1403 function PMA_showNoticeForEnum(selectElement)
1404 {
1405 var enum_notice_id = selectElement.attr("id").split("_")[1];
1406 enum_notice_id += "_" + (parseInt(selectElement.attr("id").split("_")[2]) + 1);
1407 var selectedType = selectElement.val();
1408 if (selectedType == "ENUM" || selectedType == "SET") {
1409 $("p[id='enum_notice_" + enum_notice_id + "']").show();
1410 } else {
1411 $("p[id='enum_notice_" + enum_notice_id + "']").hide();
1412 }
1413 }
1415 /**
1416 * Generates a dialog box to pop up the create_table form
1417 */
1418 function PMA_createTableDialog( $div, url , target)
1419 {
1420 /**
1421 * @var button_options Object that stores the options passed to jQueryUI
1422 * dialog
1423 */
1424 var button_options = {};
1425 // in the following function we need to use $(this)
1426 button_options[PMA_messages['strCancel']] = function() {$(this).closest('.ui-dialog-content').dialog('close').remove();}
1428 var button_options_error = {};
1429 button_options_error[PMA_messages['strOK']] = function() {$(this).closest('.ui-dialog-content').dialog('close').remove();}
1431 var $msgbox = PMA_ajaxShowMessage();
1433 $.get( target , url , function(data) {
1434 //in the case of an error, show the error message returned.
1435 if (data.success != undefined && data.success == false) {
1436 $div
1437 .append(data.error)
1438 .dialog({
1439 height: 230,
1440 width: 900,
1441 open: PMA_verifyColumnsProperties,
1442 buttons : button_options_error
1443 })// end dialog options
1444 //remove the redundant [Back] link in the error message.
1445 .find('fieldset').remove();
1446 } else {
1447 var size = getWindowSize();
1448 var timeout;
1449 $div
1450 .append(data)
1451 .dialog({
1452 dialogClass: 'create-table',
1453 resizable: false,
1454 draggable: false,
1455 modal: true,
1456 stack: false,
1457 position: ['left','top'],
1458 width: size.width-10,
1459 height: size.height-10,
1460 open: function() {
1461 var dialog_id = $(this).attr('id');
1462 $(window).bind('resize.dialog-resizer', function() {
1463 clearTimeout(timeout);
1464 timeout = setTimeout(function() {
1465 var size = getWindowSize();
1466 $('#'+dialog_id).dialog('option', {
1467 width: size.width-10,
1468 height: size.height-10
1469 });
1470 }, 50);
1471 });
1473 var $wrapper = $('<div>', {'id': 'content-hide'}).hide();
1474 $('body > *:not(.ui-dialog)').wrapAll($wrapper);
1476 $(this)
1477 .scrollTop(0) // for Chrome
1478 .closest('.ui-dialog').css({
1479 left: 0,
1480 top: 0
1481 });
1483 PMA_verifyColumnsProperties();
1485 // move the Cancel button next to the Save button
1486 var $button_pane = $('.ui-dialog-buttonpane');
1487 var $cancel_button = $button_pane.find('.ui-button');
1488 var $save_button = $('#create_table_form').find("input[name='do_save_data']");
1489 $cancel_button.insertAfter($save_button);
1490 $button_pane.hide();
1491 },
1492 close: function() {
1493 $(window).unbind('resize.dialog-resizer');
1494 $('#content-hide > *').unwrap();
1495 },
1496 buttons: button_options
1497 }); // end dialog options
1498 }
1499 PMA_convertFootnotesToTooltips($div);
1500 PMA_ajaxRemoveMessage($msgbox);
1501 }); // end $.get()
1503 }
1505 /**
1506 * Creates a highcharts chart in the given container
1507 *
1508 * @param var settings object with highcharts properties that should be applied. (See also http://www.highcharts.com/ref/)
1509 * requires at least settings.chart.renderTo and settings.series to be set.
1510 * In addition there may be an additional property object 'realtime' that allows for realtime charting:
1511 * realtime: {
1512 * url: adress to get the data from (will always add token, ajax_request=1 and chart_data=1 to the GET request)
1513 * type: the GET request will also add type=[value of the type property] to the request
1514 * callback: Callback function that should draw the point, it's called with 4 parameters in this order:
1515 * - the chart object
1516 * - the current response value of the GET request, JSON parsed
1517 * - the previous response value of the GET request, JSON parsed
1518 * - the number of added points
1519 * error: Callback function when the get request fails. TODO: Apply callback on timeouts aswell
1520 * }
1521 *
1522 * @return object The created highcharts instance
1523 */
1524 function PMA_createChart(passedSettings)
1525 {
1526 var container = passedSettings.chart.renderTo;
1528 var settings = {
1529 chart: {
1530 type: 'spline',
1531 marginRight: 10,
1532 backgroundColor: 'none',
1533 events: {
1534 /* Live charting support */
1535 load: function() {
1536 var thisChart = this;
1537 var lastValue = null, curValue = null;
1538 var numLoadedPoints = 0, otherSum = 0;
1539 var diff;
1541 // No realtime updates for graphs that are being exported, and disabled when realtime is not set
1542 // Also don't do live charting if we don't have the server time
1543 if(thisChart.options.chart.forExport == true ||
1544 ! thisChart.options.realtime ||
1545 ! thisChart.options.realtime.callback ||
1546 ! server_time_diff) return;
1548 thisChart.options.realtime.timeoutCallBack = function() {
1549 thisChart.options.realtime.postRequest = $.post(
1550 thisChart.options.realtime.url,
1551 thisChart.options.realtime.postData,
1552 function(data) {
1553 try {
1554 curValue = jQuery.parseJSON(data);
1555 } catch (err) {
1556 if(thisChart.options.realtime.error)
1557 thisChart.options.realtime.error(err);
1558 return;
1559 }
1561 if (lastValue==null) {
1562 diff = curValue.x - thisChart.xAxis[0].getExtremes().max;
1563 } else {
1564 diff = parseInt(curValue.x - lastValue.x);
1565 }
1567 thisChart.xAxis[0].setExtremes(
1568 thisChart.xAxis[0].getExtremes().min+diff,
1569 thisChart.xAxis[0].getExtremes().max+diff,
1570 false
1571 );
1573 thisChart.options.realtime.callback(thisChart,curValue,lastValue,numLoadedPoints);
1575 lastValue = curValue;
1576 numLoadedPoints++;
1578 // Timeout has been cleared => don't start a new timeout
1579 if (chart_activeTimeouts[container] == null) {
1580 return;
1581 }
1583 chart_activeTimeouts[container] = setTimeout(
1584 thisChart.options.realtime.timeoutCallBack,
1585 thisChart.options.realtime.refreshRate
1586 );
1587 });
1588 }
1590 chart_activeTimeouts[container] = setTimeout(thisChart.options.realtime.timeoutCallBack, 5);
1591 }
1592 }
1593 },
1594 plotOptions: {
1595 series: {
1596 marker: {
1597 radius: 3
1598 }
1599 }
1600 },
1601 credits: {
1602 enabled:false
1603 },
1604 xAxis: {
1605 type: 'datetime'
1606 },
1607 yAxis: {
1608 min: 0,
1609 title: {
1610 text: PMA_messages['strTotalCount']
1611 },
1612 plotLines: [{
1613 value: 0,
1614 width: 1,
1615 color: '#808080'
1616 }]
1617 },
1618 tooltip: {
1619 formatter: function() {
1620 return '<b>' + this.series.name +'</b><br/>' +
1621 Highcharts.dateFormat('%Y-%m-%d %H:%M:%S', this.x) + '<br/>' +
1622 Highcharts.numberFormat(this.y, 2);
1623 }
1624 },
1625 exporting: {
1626 enabled: true
1627 },
1628 series: []
1629 }
1631 /* Set/Get realtime chart default values */
1632 if(passedSettings.realtime) {
1633 if(!passedSettings.realtime.refreshRate) {
1634 passedSettings.realtime.refreshRate = 5000;
1635 }
1637 if(!passedSettings.realtime.numMaxPoints) {
1638 passedSettings.realtime.numMaxPoints = 30;
1639 }
1641 // Allow custom POST vars to be added
1642 passedSettings.realtime.postData = $.extend(false,{ ajax_request: true, chart_data: 1, type: passedSettings.realtime.type },passedSettings.realtime.postData);
1644 if(server_time_diff) {
1645 settings.xAxis.min = new Date().getTime() - server_time_diff - passedSettings.realtime.numMaxPoints * passedSettings.realtime.refreshRate;
1646 settings.xAxis.max = new Date().getTime() - server_time_diff + passedSettings.realtime.refreshRate;
1647 }
1648 }
1650 // Overwrite/Merge default settings with passedsettings
1651 $.extend(true,settings,passedSettings);
1653 return new Highcharts.Chart(settings);
1654 }
1657 /*
1658 * Creates a Profiling Chart. Used in sql.php and server_status.js
1659 */
1660 function PMA_createProfilingChart(data, options)
1661 {
1662 return PMA_createChart($.extend(true, {
1663 chart: {
1664 renderTo: 'profilingchart',
1665 type: 'pie'
1666 },
1667 title: { text:'', margin:0 },
1668 series: [{
1669 type: 'pie',
1670 name: PMA_messages['strQueryExecutionTime'],
1671 data: data
1672 }],
1673 plotOptions: {
1674 pie: {
1675 allowPointSelect: true,
1676 cursor: 'pointer',
1677 dataLabels: {
1678 enabled: true,
1679 distance: 35,
1680 formatter: function() {
1681 return '<b>'+ this.point.name +'</b><br/>'+ Highcharts.numberFormat(this.percentage, 2) +' %';
1682 }
1683 }
1684 }
1685 },
1686 tooltip: {
1687 formatter: function() {
1688 return '<b>'+ this.point.name +'</b><br/>'+PMA_prettyProfilingNum(this.y)+'<br/>('+Highcharts.numberFormat(this.percentage, 2) +' %)';
1689 }
1690 }
1691 },options));
1692 }
1694 /**
1695 * Formats a profiling duration nicely (in us and ms time). Used in PMA_createProfilingChart() and server_status.js
1696 *
1697 * @param integer Number to be formatted, should be in the range of microsecond to second
1698 * @param integer Acuracy, how many numbers right to the comma should be
1699 * @return string The formatted number
1700 */
1701 function PMA_prettyProfilingNum(num, acc)
1702 {
1703 if (!acc) {
1704 acc = 2;
1705 }
1706 acc = Math.pow(10,acc);
1707 if (num * 1000 < 0.1) {
1708 num = Math.round(acc * (num * 1000 * 1000)) / acc + 'µ';
1709 } else if (num < 0.1) {
1710 num = Math.round(acc * (num * 1000)) / acc + 'm';
1711 } else {
1712 num = Math.round(acc * num) / acc;
1713 }
1715 return num + 's';
1716 }
1719 /**
1720 * Formats a SQL Query nicely with newlines and indentation. Depends on Codemirror and MySQL Mode!
1721 *
1722 * @param string Query to be formatted
1723 * @return string The formatted query
1724 */
1725 function PMA_SQLPrettyPrint(string)
1726 {
1727 var mode = CodeMirror.getMode({},"text/x-mysql");
1728 var stream = new CodeMirror.StringStream(string);
1729 var state = mode.startState();
1730 var token, tokens = [];
1731 var output = '';
1732 var tabs = function(cnt) {
1733 var ret = '';
1734 for (var i=0; i<4*cnt; i++)
1735 ret += " ";
1736 return ret;
1737 };
1739 // "root-level" statements
1740 var statements = {
1741 'select': ['select', 'from','on','where','having','limit','order by','group by'],
1742 'update': ['update', 'set','where'],
1743 'insert into': ['insert into', 'values']
1744 };
1745 // don't put spaces before these tokens
1746 var spaceExceptionsBefore = { ';':true, ',': true, '.': true, '(': true };
1747 // don't put spaces after these tokens
1748 var spaceExceptionsAfter = { '.': true };
1750 // Populate tokens array
1751 var str='';
1752 while (! stream.eol()) {
1753 stream.start = stream.pos;
1754 token = mode.token(stream, state);
1755 if(token != null) {
1756 tokens.push([token, stream.current().toLowerCase()]);
1757 }
1758 }
1760 var currentStatement = tokens[0][1];
1762 if(! statements[currentStatement]) {
1763 return string;
1764 }
1765 // Holds all currently opened code blocks (statement, function or generic)
1766 var blockStack = [];
1767 // Holds the type of block from last iteration (the current is in blockStack[0])
1768 var previousBlock;
1769 // If a new code block is found, newBlock contains its type for one iteration and vice versa for endBlock
1770 var newBlock, endBlock;
1771 // How much to indent in the current line
1772 var indentLevel = 0;
1773 // Holds the "root-level" statements
1774 var statementPart, lastStatementPart = statements[currentStatement][0];
1776 blockStack.unshift('statement');
1778 // Iterate through every token and format accordingly
1779 for (var i = 0; i < tokens.length; i++) {
1780 previousBlock = blockStack[0];
1782 // New block => push to stack
1783 if (tokens[i][1] == '(') {
1784 if (i < tokens.length - 1 && tokens[i+1][0] == 'statement-verb') {
1785 blockStack.unshift(newBlock = 'statement');
1786 } else if (i > 0 && tokens[i-1][0] == 'builtin') {
1787 blockStack.unshift(newBlock = 'function');
1788 } else {
1789 blockStack.unshift(newBlock = 'generic');
1790 }
1791 } else {
1792 newBlock = null;
1793 }
1795 // Block end => pop from stack
1796 if (tokens[i][1] == ')') {
1797 endBlock = blockStack[0];
1798 blockStack.shift();
1799 } else {
1800 endBlock = null;
1801 }
1803 // A subquery is starting
1804 if (i > 0 && newBlock == 'statement') {
1805 indentLevel++;
1806 output += "\n" + tabs(indentLevel) + tokens[i][1] + ' ' + tokens[i+1][1].toUpperCase() + "\n" + tabs(indentLevel + 1);
1807 currentStatement = tokens[i+1][1];
1808 i++;
1809 continue;
1810 }
1812 // A subquery is ending
1813 if (endBlock == 'statement' && indentLevel > 0) {
1814 output += "\n" + tabs(indentLevel);
1815 indentLevel--;
1816 }
1818 // One less indentation for statement parts (from, where, order by, etc.) and a newline
1819 statementPart = statements[currentStatement].indexOf(tokens[i][1]);
1820 if (statementPart != -1) {
1821 if (i > 0) output += "\n";
1822 output += tabs(indentLevel) + tokens[i][1].toUpperCase();
1823 output += "\n" + tabs(indentLevel + 1);
1824 lastStatementPart = tokens[i][1];
1825 }
1826 // Normal indentatin and spaces for everything else
1827 else {
1828 if (! spaceExceptionsBefore[tokens[i][1]]
1829 && ! (i > 0 && spaceExceptionsAfter[tokens[i-1][1]])
1830 && output.charAt(output.length -1) != ' ' ) {
1831 output += " ";
1832 }
1833 if (tokens[i][0] == 'keyword') {
1834 output += tokens[i][1].toUpperCase();
1835 } else {
1836 output += tokens[i][1];
1837 }
1838 }
1840 // split columns in select and 'update set' clauses, but only inside statements blocks
1841 if (( lastStatementPart == 'select' || lastStatementPart == 'where' || lastStatementPart == 'set')
1842 && tokens[i][1]==',' && blockStack[0] == 'statement') {
1844 output += "\n" + tabs(indentLevel + 1);
1845 }
1847 // split conditions in where clauses, but only inside statements blocks
1848 if (lastStatementPart == 'where'
1849 && (tokens[i][1]=='and' || tokens[i][1]=='or' || tokens[i][1]=='xor')) {
1851 if (blockStack[0] == 'statement') {
1852 output += "\n" + tabs(indentLevel + 1);
1853 }
1854 // Todo: Also split and or blocks in newlines & identation++
1855 //if(blockStack[0] == 'generic')
1856 // output += ...
1857 }
1858 }
1859 return output;
1860 }
1862 /**
1863 * jQuery function that uses jQueryUI's dialogs to confirm with user. Does not
1864 * return a jQuery object yet and hence cannot be chained
1865 *
1866 * @param string question
1867 * @param string url URL to be passed to the callbackFn to make
1868 * an Ajax call to
1869 * @param function callbackFn callback to execute after user clicks on OK
1870 */
1872 jQuery.fn.PMA_confirm = function(question, url, callbackFn) {
1873 if (PMA_messages['strDoYouReally'] == '') {
1874 return true;
1875 }
1877 /**
1878 * @var button_options Object that stores the options passed to jQueryUI
1879 * dialog
1880 */
1881 var button_options = {};
1882 button_options[PMA_messages['strOK']] = function(){
1883 $(this).dialog("close").remove();
1885 if($.isFunction(callbackFn)) {
1886 callbackFn.call(this, url);
1887 }
1888 };
1889 button_options[PMA_messages['strCancel']] = function() {$(this).dialog("close").remove();}
1891 $('<div id="confirm_dialog"></div>')
1892 .prepend(question)
1893 .dialog({buttons: button_options});
1894 };
1896 /**
1897 * jQuery function to sort a table's body after a new row has been appended to it.
1898 * Also fixes the even/odd classes of the table rows at the end.
1899 *
1900 * @param string text_selector string to select the sortKey's text
1901 *
1902 * @return jQuery Object for chaining purposes
1903 */
1904 jQuery.fn.PMA_sort_table = function(text_selector) {
1905 return this.each(function() {
1907 /**
1908 * @var table_body Object referring to the table's <tbody> element
1909 */
1910 var table_body = $(this);
1911 /**
1912 * @var rows Object referring to the collection of rows in {@link table_body}
1913 */
1914 var rows = $(this).find('tr').get();
1916 //get the text of the field that we will sort by
1917 $.each(rows, function(index, row) {
1918 row.sortKey = $.trim($(row).find(text_selector).text().toLowerCase());
1919 })
1921 //get the sorted order
1922 rows.sort(function(a,b) {
1923 if(a.sortKey < b.sortKey) {
1924 return -1;
1925 }
1926 if(a.sortKey > b.sortKey) {
1927 return 1;
1928 }
1929 return 0;
1930 })
1932 //pull out each row from the table and then append it according to it's order
1933 $.each(rows, function(index, row) {
1934 $(table_body).append(row);
1935 row.sortKey = null;
1936 })
1938 //Re-check the classes of each row
1939 $(this).find('tr:odd')
1940 .removeClass('even').addClass('odd')
1941 .end()
1942 .find('tr:even')
1943 .removeClass('odd').addClass('even');
1944 })
1945 }
1947 /**
1948 * jQuery coding for 'Create Table'. Used on db_operations.php,
1949 * db_structure.php and db_tracking.php (i.e., wherever
1950 * libraries/display_create_table.lib.php is used)
1951 *
1952 * Attach Ajax Event handlers for Create Table
1953 */
1954 $(document).ready(function() {
1956 /**
1957 * Attach event handler to the submit action of the create table minimal form
1958 * and retrieve the full table form and display it in a dialog
1959 */
1960 $("#create_table_form_minimal.ajax").live('submit', function(event) {
1961 event.preventDefault();
1962 $form = $(this);
1963 PMA_prepareForAjaxRequest($form);
1965 /*variables which stores the common attributes*/
1966 var url = $form.serialize();
1967 var action = $form.attr('action');
1968 var $div = $('<div id="create_table_dialog"></div>');
1970 /*Calling to the createTableDialog function*/
1971 PMA_createTableDialog($div, url, action);
1973 // empty table name and number of columns from the minimal form
1974 $form.find('input[name=table],input[name=num_fields]').val('');
1975 });
1977 /**
1978 * Attach event handler for submission of create table form (save)
1979 *
1980 * @uses PMA_ajaxShowMessage()
1981 * @uses $.PMA_sort_table()
1982 *
1983 */
1984 // .live() must be called after a selector, see http://api.jquery.com/live
1985 $("#create_table_form input[name=do_save_data]").live('click', function(event) {
1986 event.preventDefault();
1988 /**
1989 * @var the_form object referring to the create table form
1990 */
1991 var $form = $("#create_table_form");
1993 /*
1994 * First validate the form; if there is a problem, avoid submitting it
1995 *
1996 * checkTableEditForm() needs a pure element and not a jQuery object,
1997 * this is why we pass $form[0] as a parameter (the jQuery object
1998 * is actually an array of DOM elements)
1999 */
2001 if (checkTableEditForm($form[0], $form.find('input[name=orig_num_fields]').val())) {
2002 // OK, form passed validation step
2003 if ($form.hasClass('ajax')) {
2004 PMA_ajaxShowMessage(PMA_messages['strProcessingRequest']);
2005 PMA_prepareForAjaxRequest($form);
2006 //User wants to submit the form
2007 $.post($form.attr('action'), $form.serialize() + "&do_save_data=" + $(this).val(), function(data) {
2008 if(data.success == true) {
2009 $('#properties_message')
2010 .removeClass('error')
2011 .html('');
2012 PMA_ajaxShowMessage(data.message);
2013 // Only if the create table dialog (distinct panel) exists
2014 if ($("#create_table_dialog").length > 0) {
2015 $("#create_table_dialog").dialog("close").remove();
2016 }
2018 /**
2019 * @var tables_table Object referring to the <tbody> element that holds the list of tables
2020 */
2021 var tables_table = $("#tablesForm").find("tbody").not("#tbl_summary_row");
2022 // this is the first table created in this db
2023 if (tables_table.length == 0) {
2024 if (window.parent && window.parent.frame_content) {
2025 window.parent.frame_content.location.reload();
2026 }
2027 } else {
2028 /**
2029 * @var curr_last_row Object referring to the last <tr> element in {@link tables_table}
2030 */
2031 var curr_last_row = $(tables_table).find('tr:last');
2032 /**
2033 * @var curr_last_row_index_string String containing the index of {@link curr_last_row}
2034 */
2035 var curr_last_row_index_string = $(curr_last_row).find('input:checkbox').attr('id').match(/\d+/)[0];
2036 /**
2037 * @var curr_last_row_index Index of {@link curr_last_row}
2038 */
2039 var curr_last_row_index = parseFloat(curr_last_row_index_string);
2040 /**
2041 * @var new_last_row_index Index of the new row to be appended to {@link tables_table}
2042 */
2043 var new_last_row_index = curr_last_row_index + 1;
2044 /**
2045 * @var new_last_row_id String containing the id of the row to be appended to {@link tables_table}
2046 */
2047 var new_last_row_id = 'checkbox_tbl_' + new_last_row_index;
2049 data.new_table_string = data.new_table_string.replace(/checkbox_tbl_/, new_last_row_id);
2050 //append to table
2051 $(data.new_table_string)
2052 .appendTo(tables_table);
2054 //Sort the table
2055 $(tables_table).PMA_sort_table('th');
2057 // Adjust summary row
2058 PMA_adjustTotals();
2059 }
2061 //Refresh navigation frame as a new table has been added
2062 if (window.parent && window.parent.frame_navigation) {
2063 window.parent.frame_navigation.location.reload();
2064 }
2065 } else {
2066 $('#properties_message')
2067 .addClass('error')
2068 .html(data.error);
2069 // scroll to the div containing the error message
2070 $('#properties_message')[0].scrollIntoView();
2071 }
2072 }) // end $.post()
2073 } // end if ($form.hasClass('ajax')
2074 else {
2075 // non-Ajax submit
2076 $form.append('<input type="hidden" name="do_save_data" value="save" />');
2077 $form.submit();
2078 }
2079 } // end if (checkTableEditForm() )
2080 }) // end create table form (save)
2082 /**
2083 * Attach event handler for create table form (add fields)
2084 *
2085 * @uses PMA_ajaxShowMessage()
2086 * @uses $.PMA_sort_table()
2087 * @uses window.parent.refreshNavigation()
2088 *
2089 */
2090 // .live() must be called after a selector, see http://api.jquery.com/live
2091 $("#create_table_form.ajax input[name=submit_num_fields]").live('click', function(event) {
2092 event.preventDefault();
2094 /**
2095 * @var the_form object referring to the create table form
2096 */
2097 var $form = $("#create_table_form");
2099 var $msgbox = PMA_ajaxShowMessage(PMA_messages['strProcessingRequest']);
2100 PMA_prepareForAjaxRequest($form);
2102 //User wants to add more fields to the table
2103 $.post($form.attr('action'), $form.serialize() + "&submit_num_fields=" + $(this).val(), function(data) {
2104 // if 'create_table_dialog' exists
2105 if ($("#create_table_dialog").length > 0) {
2106 $("#create_table_dialog").html(data);
2107 }
2108 // if 'create_table_div' exists
2109 if ($("#create_table_div").length > 0) {
2110 $("#create_table_div").html(data);
2111 }
2112 PMA_verifyColumnsProperties();
2113 PMA_ajaxRemoveMessage($msgbox);
2114 }) //end $.post()
2116 }) // end create table form (add fields)
2118 }, 'top.frame_content'); //end $(document).ready for 'Create Table'
2120 /**
2121 * jQuery coding for 'Change Table' and 'Add Column'. Used on tbl_structure.php *
2122 * Attach Ajax Event handlers for Change Table
2123 */
2124 $(document).ready(function() {
2125 /**
2126 *Ajax action for submitting the "Column Change" and "Add Column" form
2127 **/
2128 $("#append_fields_form input[name=do_save_data]").live('click', function(event) {
2129 event.preventDefault();
2130 /**
2131 * @var the_form object referring to the export form
2132 */
2133 var $form = $("#append_fields_form");
2135 /*
2136 * First validate the form; if there is a problem, avoid submitting it
2137 *
2138 * checkTableEditForm() needs a pure element and not a jQuery object,
2139 * this is why we pass $form[0] as a parameter (the jQuery object
2140 * is actually an array of DOM elements)
2141 */
2142 if (checkTableEditForm($form[0], $form.find('input[name=orig_num_fields]').val())) {
2143 // OK, form passed validation step
2144 if ($form.hasClass('ajax')) {
2145 PMA_prepareForAjaxRequest($form);
2146 //User wants to submit the form
2147 $.post($form.attr('action'), $form.serialize()+"&do_save_data=Save", function(data) {
2148 if ($("#sqlqueryresults").length != 0) {
2149 $("#sqlqueryresults").remove();
2150 } else if ($(".error").length != 0) {
2151 $(".error").remove();
2152 }
2153 if (data.success == true) {
2154 PMA_ajaxShowMessage(data.message);
2155 $("<div id='sqlqueryresults'></div>").insertAfter("#floating_menubar");
2156 $("#sqlqueryresults").html(data.sql_query);
2157 $("#result_query .notice").remove();
2158 $("#result_query").prepend((data.message));
2159 if ($("#change_column_dialog").length > 0) {
2160 $("#change_column_dialog").dialog("close").remove();
2161 } else if ($("#add_columns").length > 0) {
2162 $("#add_columns").dialog("close").remove();
2163 }
2164 /*Reload the field form*/
2165 $.post($("#fieldsForm").attr('action'), $("#fieldsForm").serialize()+"&ajax_request=true", function(form_data) {
2166 $("#fieldsForm").remove();
2167 $("#addColumns").remove();
2168 var $temp_div = $("<div id='temp_div'><div>").append(form_data);
2169 if ($("#sqlqueryresults").length != 0) {
2170 $temp_div.find("#fieldsForm").insertAfter("#sqlqueryresults");
2171 } else {
2172 $temp_div.find("#fieldsForm").insertAfter(".error");
2173 }
2174 $temp_div.find("#addColumns").insertBefore("iframe.IE_hack");
2175 /*Call the function to display the more options in table*/
2176 displayMoreTableOpts();
2177 });
2178 } else {
2179 var $temp_div = $("<div id='temp_div'><div>").append(data);
2180 var $error = $temp_div.find(".error code").addClass("error");
2181 PMA_ajaxShowMessage($error, false);
2182 }
2183 }) // end $.post()
2184 } else {
2185 // non-Ajax submit
2186 $form.append('<input type="hidden" name="do_save_data" value="Save" />');
2187 $form.submit();
2188 }
2189 }
2190 }) // end change table button "do_save_data"
2192 }, 'top.frame_content'); //end $(document).ready for 'Change Table'
2194 /**
2195 * jQuery coding for 'Table operations'. Used on tbl_operations.php
2196 * Attach Ajax Event handlers for Table operations
2197 */
2198 $(document).ready(function() {
2199 /**
2200 *Ajax action for submitting the "Alter table order by"
2201 **/
2202 $("#alterTableOrderby.ajax").live('submit', function(event) {
2203 event.preventDefault();
2204 var $form = $(this);
2206 PMA_prepareForAjaxRequest($form);
2207 /*variables which stores the common attributes*/
2208 $.post($form.attr('action'), $form.serialize()+"&submitorderby=Go", function(data) {
2209 if ($("#sqlqueryresults").length != 0) {
2210 $("#sqlqueryresults").remove();
2211 }
2212 if ($("#result_query").length != 0) {
2213 $("#result_query").remove();
2214 }
2215 if (data.success == true) {
2216 PMA_ajaxShowMessage(data.message);
2217 $("<div id='sqlqueryresults'></div>").insertAfter("#floating_menubar");
2218 $("#sqlqueryresults").html(data.sql_query);
2219 $("#result_query .notice").remove();
2220 $("#result_query").prepend((data.message));
2221 } else {
2222 var $temp_div = $("<div id='temp_div'></div>")
2223 $temp_div.html(data.error);
2224 var $error = $temp_div.find("code").addClass("error");
2225 PMA_ajaxShowMessage($error, false);
2226 }
2227 }) // end $.post()
2228 });//end of alterTableOrderby ajax submit
2230 /**
2231 *Ajax action for submitting the "Copy table"
2232 **/
2233 $("#copyTable.ajax input[name='submit_copy']").live('click', function(event) {
2234 event.preventDefault();
2235 var $form = $("#copyTable");
2236 if($form.find("input[name='switch_to_new']").attr('checked')) {
2237 $form.append('<input type="hidden" name="submit_copy" value="Go" />');
2238 $form.removeClass('ajax');
2239 $form.find("#ajax_request_hidden").remove();
2240 $form.submit();
2241 } else {
2242 PMA_prepareForAjaxRequest($form);
2243 /*variables which stores the common attributes*/
2244 $.post($form.attr('action'), $form.serialize()+"&submit_copy=Go", function(data) {
2245 if ($("#sqlqueryresults").length != 0) {
2246 $("#sqlqueryresults").remove();
2247 }
2248 if ($("#result_query").length != 0) {
2249 $("#result_query").remove();
2250 }
2251 if (data.success == true) {
2252 PMA_ajaxShowMessage(data.message);
2253 $("<div id='sqlqueryresults'></div>").insertAfter("#floating_menubar");
2254 $("#sqlqueryresults").html(data.sql_query);
2255 $("#result_query .notice").remove();
2256 $("#result_query").prepend((data.message));
2257 $("#copyTable").find("select[name='target_db'] option").filterByValue(data.db).attr('selected', 'selected');
2259 //Refresh navigation frame when the table is coppied
2260 if (window.parent && window.parent.frame_navigation) {
2261 window.parent.frame_navigation.location.reload();
2262 }
2263 } else {
2264 var $temp_div = $("<div id='temp_div'></div>");
2265 $temp_div.html(data.error);
2266 var $error = $temp_div.find("code").addClass("error");
2267 PMA_ajaxShowMessage($error, false);
2268 }
2269 }) // end $.post()
2270 }
2271 });//end of copyTable ajax submit
2273 /**
2274 *Ajax events for actions in the "Table maintenance"
2275 **/
2276 $("#tbl_maintenance.ajax li a.maintain_action").live('click', function(event) {
2277 event.preventDefault();
2278 var $link = $(this);
2279 var href = $link.attr("href");
2280 href = href.split('?');
2281 if ($("#sqlqueryresults").length != 0) {
2282 $("#sqlqueryresults").remove();
2283 }
2284 if ($("#result_query").length != 0) {
2285 $("#result_query").remove();
2286 }
2287 //variables which stores the common attributes
2288 $.post(href[0], href[1]+"&ajax_request=true", function(data) {
2289 if (data.success == undefined) {
2290 var $temp_div = $("<div id='temp_div'></div>");
2291 $temp_div.html(data);
2292 var $success = $temp_div.find("#result_query .success");
2293 PMA_ajaxShowMessage($success);
2294 $("<div id='sqlqueryresults' class='ajax'></div>").insertAfter("#floating_menubar");
2295 $("#sqlqueryresults").html(data);
2296 PMA_init_slider();
2297 $("#sqlqueryresults").children("fieldset").remove();
2298 } else if (data.success == true ) {
2299 PMA_ajaxShowMessage(data.message);
2300 $("<div id='sqlqueryresults' class='ajax'></div>").insertAfter("#floating_menubar");
2301 $("#sqlqueryresults").html(data.sql_query);
2302 } else {
2303 var $temp_div = $("<div id='temp_div'></div>");
2304 $temp_div.html(data.error);
2305 var $error = $temp_div.find("code").addClass("error");
2306 PMA_ajaxShowMessage($error, false);
2307 }
2308 }) // end $.post()
2309 });//end of table maintanance ajax click
2311 }, 'top.frame_content'); //end $(document).ready for 'Table operations'
2314 /**
2315 * Attach Ajax event handlers for Drop Database. Moved here from db_structure.js
2316 * as it was also required on db_create.php
2317 *
2318 * @uses $.PMA_confirm()
2319 * @uses PMA_ajaxShowMessage()
2320 * @uses window.parent.refreshNavigation()
2321 * @uses window.parent.refreshMain()
2322 * @see $cfg['AjaxEnable']
2323 */
2324 $(document).ready(function() {
2325 $("#drop_db_anchor").live('click', function(event) {
2326 event.preventDefault();
2328 //context is top.frame_content, so we need to use window.parent.db to access the db var
2329 /**
2330 * @var question String containing the question to be asked for confirmation
2331 */
2332 var question = PMA_messages['strDropDatabaseStrongWarning'] + '\n' + PMA_messages['strDoYouReally'] + ' :\n' + 'DROP DATABASE ' + escapeHtml(window.parent.db);
2334 $(this).PMA_confirm(question, $(this).attr('href') ,function(url) {
2336 PMA_ajaxShowMessage(PMA_messages['strProcessingRequest']);
2337 $.get(url, {'is_js_confirmed': '1', 'ajax_request': true}, function(data) {
2338 //Database deleted successfully, refresh both the frames
2339 window.parent.refreshNavigation();
2340 window.parent.refreshMain();
2341 }) // end $.get()
2342 }); // end $.PMA_confirm()
2343 }); //end of Drop Database Ajax action
2344 }) // end of $(document).ready() for Drop Database
2346 /**
2347 * Attach Ajax event handlers for 'Create Database'. Used wherever libraries/
2348 * display_create_database.lib.php is used, ie main.php and server_databases.php
2349 *
2350 * @uses PMA_ajaxShowMessage()
2351 * @see $cfg['AjaxEnable']
2352 */
2353 $(document).ready(function() {
2355 $('#create_database_form.ajax').live('submit', function(event) {
2356 event.preventDefault();
2358 $form = $(this);
2360 PMA_ajaxShowMessage(PMA_messages['strProcessingRequest']);
2361 PMA_prepareForAjaxRequest($form);
2363 $.post($form.attr('action'), $form.serialize(), function(data) {
2364 if(data.success == true) {
2365 PMA_ajaxShowMessage(data.message);
2367 //Append database's row to table
2368 $("#tabledatabases")
2369 .find('tbody')
2370 .append(data.new_db_string)
2371 .PMA_sort_table('.name')
2372 .find('#db_summary_row')
2373 .appendTo('#tabledatabases tbody')
2374 .removeClass('odd even');
2376 var $databases_count_object = $('#databases_count');
2377 var databases_count = parseInt($databases_count_object.text());
2378 $databases_count_object.text(++databases_count);
2379 //Refresh navigation frame as a new database has been added
2380 if (window.parent && window.parent.frame_navigation) {
2381 window.parent.frame_navigation.location.reload();
2382 }
2383 }
2384 else {
2385 PMA_ajaxShowMessage(data.error, false);
2386 }
2387 }) // end $.post()
2388 }) // end $().live()
2389 }) // end $(document).ready() for Create Database
2391 /**
2392 * Attach Ajax event handlers for 'Change Password' on main.php
2393 */
2394 $(document).ready(function() {
2396 /**
2397 * Attach Ajax event handler on the change password anchor
2398 * @see $cfg['AjaxEnable']
2399 */
2400 $('#change_password_anchor.dialog_active').live('click',function(event) {
2401 event.preventDefault();
2402 return false;
2403 });
2404 $('#change_password_anchor.ajax').live('click', function(event) {
2405 event.preventDefault();
2406 $(this).removeClass('ajax').addClass('dialog_active');
2407 /**
2408 * @var button_options Object containing options to be passed to jQueryUI's dialog
2409 */
2410 var button_options = {};
2411 button_options[PMA_messages['strCancel']] = function() {$(this).dialog('close').remove();}
2412 $.get($(this).attr('href'), {'ajax_request': true}, function(data) {
2413 $('<div id="change_password_dialog"></div>')
2414 .dialog({
2415 title: PMA_messages['strChangePassword'],
2416 width: 600,
2417 close: function(ev,ui) {$(this).remove();},
2418 buttons : button_options,
2419 beforeClose: function(ev,ui){ $('#change_password_anchor.dialog_active').removeClass('dialog_active').addClass('ajax')}
2420 })
2421 .append(data);
2422 displayPasswordGenerateButton();
2423 }) // end $.get()
2424 }) // end handler for change password anchor
2426 /**
2427 * Attach Ajax event handler for Change Password form submission
2428 *
2429 * @uses PMA_ajaxShowMessage()
2430 * @see $cfg['AjaxEnable']
2431 */
2432 $("#change_password_form.ajax").find('input[name=change_pw]').live('click', function(event) {
2433 event.preventDefault();
2435 /**
2436 * @var the_form Object referring to the change password form
2437 */
2438 var the_form = $("#change_password_form");
2440 /**
2441 * @var this_value String containing the value of the submit button.
2442 * Need to append this for the change password form on Server Privileges
2443 * page to work
2444 */
2445 var this_value = $(this).val();
2447 var $msgbox = PMA_ajaxShowMessage(PMA_messages['strProcessingRequest']);
2448 $(the_form).append('<input type="hidden" name="ajax_request" value="true" />');
2450 $.post($(the_form).attr('action'), $(the_form).serialize() + '&change_pw='+ this_value, function(data) {
2451 if(data.success == true) {
2452 $("#floating_menubar").after(data.sql_query);
2453 $("#change_password_dialog").hide().remove();
2454 $("#edit_user_dialog").dialog("close").remove();
2455 $('#change_password_anchor.dialog_active').removeClass('dialog_active').addClass('ajax');
2456 PMA_ajaxRemoveMessage($msgbox);
2457 }
2458 else {
2459 PMA_ajaxShowMessage(data.error, false);
2460 }
2461 }) // end $.post()
2462 }) // end handler for Change Password form submission
2463 }) // end $(document).ready() for Change Password
2465 /**
2466 * Toggle the hiding/showing of the "Open in ENUM/SET editor" message when
2467 * the page loads and when the selected data type changes
2468 */
2469 $(document).ready(function() {
2470 // is called here for normal page loads and also when opening
2471 // the Create table dialog
2472 PMA_verifyColumnsProperties();
2473 //
2474 // needs live() to work also in the Create Table dialog
2475 $("select[class='column_type']").live('change', function() {
2476 PMA_showNoticeForEnum($(this));
2477 });
2478 $(".default_type").live('change', function() {
2479 PMA_hideShowDefaultValue($(this));
2480 });
2481 });
2483 function PMA_verifyColumnsProperties()
2484 {
2485 $("select[class='column_type']").each(function() {
2486 PMA_showNoticeForEnum($(this));
2487 });
2488 $(".default_type").each(function() {
2489 PMA_hideShowDefaultValue($(this));
2490 });
2491 }
2493 /**
2494 * Hides/shows the default value input field, depending on the default type
2495 */
2496 function PMA_hideShowDefaultValue($default_type)
2497 {
2498 if ($default_type.val() == 'USER_DEFINED') {
2499 $default_type.siblings('.default_value').show().focus();
2500 } else {
2501 $default_type.siblings('.default_value').hide();
2502 }
2503 }
2505 /**
2506 * @var $enum_editor_dialog An object that points to the jQuery
2507 * dialog of the ENUM/SET editor
2508 */
2509 var $enum_editor_dialog = null;
2510 /**
2511 * Opens the ENUM/SET editor and controls its functions
2512 */
2513 $(document).ready(function() {
2514 $("a.open_enum_editor").live('click', function() {
2515 // Get the name of the column that is being edited
2516 var colname = $(this).closest('tr').find('input:first').val();
2517 // And use it to make up a title for the page
2518 if (colname.length < 1) {
2519 var title = PMA_messages['enum_newColumnVals'];
2520 } else {
2521 var title = PMA_messages['enum_columnVals'].replace(
2522 /%s/,
2523 '"' + decodeURIComponent(colname) + '"'
2524 );
2525 }
2526 // Get the values as a string
2527 var inputstring = $(this)
2528 .closest('td')
2529 .find("input")
2530 .val();
2531 // Escape html entities
2532 inputstring = $('<div/>')
2533 .text(inputstring)
2534 .html();
2535 // Parse the values, escaping quotes and
2536 // slashes on the fly, into an array
2537 //
2538 // There is a PHP port of the below parser in enum_editor.php
2539 // If you are fixing something here, you need to also update the PHP port.
2540 var values = [];
2541 var in_string = false;
2542 var curr, next, buffer = '';
2543 for (var i=0; i<inputstring.length; i++) {
2544 curr = inputstring.charAt(i);
2545 next = i == inputstring.length ? '' : inputstring.charAt(i+1);
2546 if (! in_string && curr == "'") {
2547 in_string = true;
2548 } else if (in_string && curr == "\\" && next == "\\") {
2549 buffer += "\";
2550 i++;
2551 } else if (in_string && next == "'" && (curr == "'" || curr == "\\")) {
2552 buffer += "'";
2553 i++;
2554 } else if (in_string && curr == "'") {
2555 in_string = false;
2556 values.push(buffer);
2557 buffer = '';
2558 } else if (in_string) {
2559 buffer += curr;
2560 }
2561 }
2562 if (buffer.length > 0) {
2563 // The leftovers in the buffer are the last value (if any)
2564 values.push(buffer);
2565 }
2566 var fields = '';
2567 // If there are no values, maybe the user is about to make a
2568 // new list so we add a few for him/her to get started with.
2569 if (values.length == 0) {
2570 values.push('','','','');
2571 }
2572 // Add the parsed values to the editor
2573 var drop_icon = PMA_getImage('b_drop.png');
2574 for (var i=0; i<values.length; i++) {
2575 fields += "<tr><td>"
2576 + "<input type='text' value='" + values[i] + "'/>"
2577 + "</td><td class='drop'>"
2578 + drop_icon
2579 + "</td></tr>";
2580 }
2581 /**
2582 * @var dialog HTML code for the ENUM/SET dialog
2583 */
2584 var dialog = "<div id='enum_editor'>"
2585 + "<fieldset>"
2586 + "<legend>" + title + "</legend>"
2587 + "<p>" + PMA_getImage('s_notice.png')
2588 + PMA_messages['enum_hint'] + "</p>"
2589 + "<table class='values'>" + fields + "</table>"
2590 + "</fieldset><fieldset class='tblFooters'>"
2591 + "<table class='add'><tr><td>"
2592 + "<div class='slider'></div>"
2593 + "</td><td>"
2594 + "<form><div><input type='submit' class='add_value' value='"
2595 + PMA_messages['enum_addValue'].replace(/%d/, 1)
2596 + "'/></div></form>"
2597 + "</td></tr></table>"
2598 + "<input type='hidden' value='" // So we know which column's data is being edited
2599 + $(this).closest('td').find("input").attr("id")
2600 + "' />"
2601 + "</fieldset>";
2602 + "</div>";
2603 /**
2604 * @var Defines functions to be called when the buttons in
2605 * the buttonOptions jQuery dialog bar are pressed
2606 */
2607 var buttonOptions = {};
2608 buttonOptions[PMA_messages['strGo']] = function () {
2609 // When the submit button is clicked,
2610 // put the data back into the original form
2611 var value_array = new Array();
2612 $(this).find(".values input").each(function(index, elm) {
2613 var val = elm.value.replace(/\\/g, '\\\\').replace(/'/g, "''");
2614 value_array.push("'" + val + "'");
2615 });
2616 // get the Length/Values text field where this value belongs
2617 var values_id = $(this).find("input[type='hidden']").attr("value");
2618 $("input[id='" + values_id + "']").attr("value", value_array.join(","));
2619 $(this).dialog("close");
2620 };
2621 buttonOptions[PMA_messages['strClose']] = function () {
2622 $(this).dialog("close");
2623 };
2624 // Show the dialog
2625 var width = parseInt(
2626 (parseInt($('html').css('font-size'), 10)/13)*340,
2627 10
2628 );
2629 if (! width) {
2630 width = 340;
2631 }
2632 $enum_editor_dialog = $(dialog).dialog({
2633 minWidth: width,
2634 modal: true,
2635 title: PMA_messages['enum_editor'],
2636 buttons: buttonOptions,
2637 open: function() {
2638 // Focus the "Go" button after opening the dialog
2639 $(this).closest('.ui-dialog').find('.ui-dialog-buttonpane button:first').focus();
2640 },
2641 close: function() {
2642 $(this).remove();
2643 }
2644 });
2645 // slider for choosing how many fields to add
2646 $enum_editor_dialog.find(".slider").slider({
2647 animate: true,
2648 range: "min",
2649 value: 1,
2650 min: 1,
2651 max: 9,
2652 slide: function( event, ui ) {
2653 $(this).closest('table').find('input[type=submit]').val(
2654 PMA_messages['enum_addValue'].replace(/%d/, ui.value)
2655 );
2656 }
2657 });
2658 // Focus the slider, otherwise it looks nearly transparent
2659 $('.ui-slider-handle').addClass('ui-state-focus');
2660 return false;
2661 });
2663 // When "add a new value" is clicked, append an empty text field
2664 $("input.add_value").live('click', function(e) {
2665 e.preventDefault();
2666 var num_new_rows = $enum_editor_dialog.find("div.slider").slider('value');
2667 while (num_new_rows--) {
2668 $enum_editor_dialog.find('.values')
2669 .append(
2670 "<tr style='display: none;'><td>"
2671 + "<input type='text' />"
2672 + "</td><td class='drop'>"
2673 + PMA_getImage('b_drop.png')
2674 + "</td></tr>"
2675 )
2676 .find('tr:last')
2677 .show('fast');
2678 }
2679 });
2681 // Removes the specified row from the enum editor
2682 $("#enum_editor td.drop").live('click', function() {
2683 $(this).closest('tr').hide('fast', function () {
2684 $(this).remove();
2685 });
2686 });
2687 });
2689 /**
2690 * Hides certain table structure actions, replacing them
2691 * with the word "More". They are displayed in a dropdown
2692 * menu when the user hovers over the word "More."
2693 */
2694 $(document).ready(function() {
2695 displayMoreTableOpts();
2696 });
2698 function displayMoreTableOpts()
2699 {
2700 // Remove the actions from the table cells (they are available by default for JavaScript-disabled browsers)
2701 // if the table is not a view or information_schema (otherwise there is only one action to hide and there's no point)
2702 if($("input[type='hidden'][name='table_type']").val() == "table") {
2703 var $table = $("table[id='tablestructure']");
2704 $table.find("td[class='browse']").remove();
2705 $table.find("td[class='primary']").remove();
2706 $table.find("td[class='unique']").remove();
2707 $table.find("td[class='index']").remove();
2708 $table.find("td[class='fulltext']").remove();
2709 $table.find("td[class='spatial']").remove();
2710 $table.find("th[class='action']").attr("colspan", 3);
2712 // Display the "more" text
2713 $table.find("td[class='more_opts']").show();
2715 // Position the dropdown
2716 $(".structure_actions_dropdown").each(function() {
2717 // Optimize DOM querying
2718 var $this_dropdown = $(this);
2719 // The top offset must be set for IE even if it didn't change
2720 var cell_right_edge_offset = $this_dropdown.parent().position().left + $this_dropdown.parent().innerWidth();
2721 var left_offset = cell_right_edge_offset - $this_dropdown.innerWidth();
2722 var top_offset = $this_dropdown.parent().position().top + $this_dropdown.parent().innerHeight();
2723 $this_dropdown.offset({ top: top_offset, left: left_offset });
2724 });
2726 // A hack for IE6 to prevent the after_field select element from being displayed on top of the dropdown by
2727 // positioning an iframe directly on top of it
2728 var $after_field = $("select[name='after_field']");
2729 $("iframe[class='IE_hack']")
2730 .width($after_field.width())
2731 .height($after_field.height())
2732 .offset({
2733 top: $after_field.offset().top,
2734 left: $after_field.offset().left
2735 });
2737 // When "more" is hovered over, show the hidden actions
2738 $table.find("td[class='more_opts']")
2739 .mouseenter(function() {
2740 if($.browser.msie && $.browser.version == "6.0") {
2741 $("iframe[class='IE_hack']")
2742 .show()
2743 .width($after_field.width()+4)
2744 .height($after_field.height()+4)
2745 .offset({
2746 top: $after_field.offset().top,
2747 left: $after_field.offset().left
2748 });
2749 }
2750 $(".structure_actions_dropdown").hide(); // Hide all the other ones that may be open
2751 $(this).children(".structure_actions_dropdown").show();
2752 // Need to do this again for IE otherwise the offset is wrong
2753 if($.browser.msie) {
2754 var left_offset_IE = $(this).offset().left + $(this).innerWidth() - $(this).children(".structure_actions_dropdown").innerWidth();
2755 var top_offset_IE = $(this).offset().top + $(this).innerHeight();
2756 $(this).children(".structure_actions_dropdown").offset({
2757 top: top_offset_IE,
2758 left: left_offset_IE });
2759 }
2760 })
2761 .mouseleave(function() {
2762 $(this).children(".structure_actions_dropdown").hide();
2763 if($.browser.msie && $.browser.version == "6.0") {
2764 $("iframe[class='IE_hack']").hide();
2765 }
2766 });
2767 }
2769 }
2770 $(document).ready(function(){
2771 PMA_convertFootnotesToTooltips();
2772 });
2774 /**
2775 * Ensures indexes names are valid according to their type and, for a primary
2776 * key, lock index name to 'PRIMARY'
2777 * @param string form_id Variable which parses the form name as
2778 * the input
2779 * @return boolean false if there is no index form, true else
2780 */
2781 function checkIndexName(form_id)
2782 {
2783 if ($("#"+form_id).length == 0) {
2784 return false;
2785 }
2787 // Gets the elements pointers
2788 var $the_idx_name = $("#input_index_name");
2789 var $the_idx_type = $("#select_index_type");
2791 // Index is a primary key
2792 if ($the_idx_type.find("option:selected").attr("value") == 'PRIMARY') {
2793 $the_idx_name.attr("value", 'PRIMARY');
2794 $the_idx_name.attr("disabled", true);
2795 }
2797 // Other cases
2798 else {
2799 if ($the_idx_name.attr("value") == 'PRIMARY') {
2800 $the_idx_name.attr("value", '');
2801 }
2802 $the_idx_name.attr("disabled", false);
2803 }
2805 return true;
2806 } // end of the 'checkIndexName()' function
2808 /**
2809 * function to convert the footnotes to tooltips
2810 *
2811 * @param jquery-Object $div a div jquery object which specifies the
2812 * domain for searching footnootes. If we
2813 * ommit this parameter the function searches
2814 * the footnotes in the whole body
2815 **/
2816 function PMA_convertFootnotesToTooltips($div)
2817 {
2818 // Hide the footnotes from the footer (which are displayed for
2819 // JavaScript-disabled browsers) since the tooltip is sufficient
2821 if ($div == undefined || ! $div instanceof jQuery || $div.length == 0) {
2822 $div = $("body");
2823 }
2825 $footnotes = $div.find(".footnotes");
2827 $footnotes.hide();
2828 $footnotes.find('span').each(function() {
2829 $(this).children("sup").remove();
2830 });
2831 // The border and padding must be removed otherwise a thin yellow box remains visible
2832 $footnotes.css("border", "none");
2833 $footnotes.css("padding", "0px");
2835 // Replace the superscripts with the help icon
2836 $div.find("sup.footnotemarker").hide();
2837 $div.find("img.footnotemarker").show();
2839 $div.find("img.footnotemarker").each(function() {
2840 var img_class = $(this).attr("class");
2841 /** img contains two classes, as example "footnotemarker footnote_1".
2842 * We split it by second class and take it for the id of span
2843 */
2844 img_class = img_class.split(" ");
2845 for (i = 0; i < img_class.length; i++) {
2846 if (img_class[i].split("_")[0] == "footnote") {
2847 var span_id = img_class[i].split("_")[1];
2848 }
2849 }
2850 /**
2851 * Now we get the #id of the span with span_id variable. As an example if we
2852 * initially get the img class as "footnotemarker footnote_2", now we get
2853 * #2 as the span_id. Using that we can find footnote_2 in footnotes.
2854 * */
2855 var tooltip_text = $footnotes.find("span[id='footnote_" + span_id + "']").html();
2856 $(this).qtip({
2857 content: tooltip_text,
2858 show: { delay: 0 },
2859 hide: { delay: 1000 },
2860 style: { background: '#ffffcc' }
2861 });
2862 });
2863 }
2865 /**
2866 * This function handles the resizing of the content frame
2867 * and adjusts the top menu according to the new size of the frame
2868 */
2869 function menuResize()
2870 {
2871 var $cnt = $('#topmenu');
2872 var wmax = $cnt.innerWidth() - 5; // 5 px margin for jumping menu in Chrome
2873 var $submenu = $cnt.find('.submenu');
2874 var submenu_w = $submenu.outerWidth(true);
2875 var $submenu_ul = $submenu.find('ul');
2876 var $li = $cnt.find('> li');
2877 var $li2 = $submenu_ul.find('li');
2878 var more_shown = $li2.length > 0;
2880 // Calculate the total width used by all the shown tabs
2881 var total_len = more_shown ? submenu_w : 0;
2882 for (var i = 0; i < $li.length-1; i++) {
2883 total_len += $($li[i]).outerWidth(true);
2884 }
2886 // Now hide menu elements that don't fit into the menubar
2887 var i = $li.length-1;
2888 var hidden = false; // Whether we have hidden any tabs
2889 while (total_len >= wmax && --i >= 0) { // Process the tabs backwards
2890 hidden = true;
2891 var el = $($li[i]);
2892 var el_width = el.outerWidth(true);
2893 el.data('width', el_width);
2894 if (! more_shown) {
2895 total_len -= el_width;
2896 el.prependTo($submenu_ul);
2897 total_len += submenu_w;
2898 more_shown = true;
2899 } else {
2900 total_len -= el_width;
2901 el.prependTo($submenu_ul);
2902 }
2903 }
2905 // If we didn't hide any tabs, then there might be some space to show some
2906 if (! hidden) {
2907 // Show menu elements that do fit into the menubar
2908 for (var i = 0; i < $li2.length; i++) {
2909 total_len += $($li2[i]).data('width');
2910 // item fits or (it is the last item
2911 // and it would fit if More got removed)
2912 if (total_len < wmax
2913 || (i == $li2.length - 1 && total_len - submenu_w < wmax)
2914 ) {
2915 $($li2[i]).insertBefore($submenu);
2916 } else {
2917 break;
2918 }
2919 }
2920 }
2922 // Show/hide the "More" tab as needed
2923 if ($submenu_ul.find('li').length > 0) {
2924 $submenu.addClass('shown');
2925 } else {
2926 $submenu.removeClass('shown');
2927 }
2929 if ($cnt.find('> li').length == 1) {
2930 // If there is only the "More" tab left, then we need
2931 // to align the submenu to the left edge of the tab
2932 $submenu_ul.removeClass().addClass('only');
2933 } else {
2934 // Otherwise we align the submenu to the right edge of the tab
2935 $submenu_ul.removeClass().addClass('notonly');
2936 }
2938 if ($submenu.find('.tabactive').length) {
2939 $submenu.addClass('active').find('> a').removeClass('tab').addClass('tabactive');
2940 } else {
2941 $submenu.removeClass('active').find('> a').addClass('tab').removeClass('tabactive');
2942 }
2943 }
2945 $(function() {
2946 var topmenu = $('#topmenu');
2947 if (topmenu.length == 0) {
2948 return;
2949 }
2950 // create submenu container
2951 var link = $('<a />', {href: '#', 'class': 'tab'})
2952 .text(PMA_messages['strMore'])
2953 .click(function(e) {
2954 e.preventDefault();
2955 });
2956 var img = topmenu.find('li:first-child img');
2957 if (img.length) {
2958 $(PMA_getImage('b_more.png').toString()).prependTo(link);
2959 }
2960 var submenu = $('<li />', {'class': 'submenu'})
2961 .append(link)
2962 .append($('<ul />'))
2963 .mouseenter(function() {
2964 if ($(this).find('ul .tabactive').length == 0) {
2965 $(this).addClass('submenuhover').find('> a').addClass('tabactive');
2966 }
2967 })
2968 .mouseleave(function() {
2969 if ($(this).find('ul .tabactive').length == 0) {
2970 $(this).removeClass('submenuhover').find('> a').removeClass('tabactive');
2971 }
2972 });
2973 topmenu.append(submenu);
2975 // populate submenu and register resize event
2976 menuResize();
2977 $(window).resize(menuResize);
2978 });
2980 /**
2981 * Get the row number from the classlist (for example, row_1)
2982 */
2983 function PMA_getRowNumber(classlist)
2984 {
2985 return parseInt(classlist.split(/\s+row_/)[1]);
2986 }
2988 /**
2989 * Changes status of slider
2990 */
2991 function PMA_set_status_label($element)
2992 {
2993 var text = $element.css('display') == 'none'
2994 ? '+ '
2995 : '- ';
2996 $element.closest('.slide-wrapper').prev().find('span').text(text);
2997 }
2999 /**
3000 * Initializes slider effect.
3001 */
3002 function PMA_init_slider()
3003 {
3004 $('.pma_auto_slider').each(function() {
3005 var $this = $(this);
3007 if ($this.hasClass('slider_init_done')) {
3008 return;
3009 }
3010 $this.addClass('slider_init_done');
3012 var $wrapper = $('<div>', {'class': 'slide-wrapper'});
3013 $wrapper.toggle($this.is(':visible'));
3014 $('<a>', {href: '#'+this.id})
3015 .text(this.title)
3016 .prepend($('<span>'))
3017 .insertBefore($this)
3018 .click(function() {
3019 var $wrapper = $this.closest('.slide-wrapper');
3020 var visible = $this.is(':visible');
3021 if (!visible) {
3022 $wrapper.show();
3023 }
3024 $this[visible ? 'hide' : 'show']('blind', function() {
3025 $wrapper.toggle(!visible);
3026 PMA_set_status_label($this);
3027 });
3028 return false;
3029 });
3030 $this.wrap($wrapper);
3031 PMA_set_status_label($this);
3032 });
3033 }
3035 /**
3036 * var toggleButton This is a function that creates a toggle
3037 * sliding button given a jQuery reference
3038 * to the correct DOM element
3039 */
3040 var toggleButton = function ($obj) {
3041 // In rtl mode the toggle switch is flipped horizontally
3042 // so we need to take that into account
3043 if ($('.text_direction', $obj).text() == 'ltr') {
3044 var right = 'right';
3045 } else {
3046 var right = 'left';
3047 }
3048 /**
3049 * var h Height of the button, used to scale the
3050 * background image and position the layers
3051 */
3052 var h = $obj.height();
3053 $('img', $obj).height(h);
3054 $('table', $obj).css('bottom', h-1);
3055 /**
3056 * var on Width of the "ON" part of the toggle switch
3057 * var off Width of the "OFF" part of the toggle switch
3058 */
3059 var on = $('.toggleOn', $obj).width();
3060 var off = $('.toggleOff', $obj).width();
3061 // Make the "ON" and "OFF" parts of the switch the same size
3062 // + 2 pixels to avoid overflowed
3063 $('.toggleOn > div', $obj).width(Math.max(on, off) + 2);
3064 $('.toggleOff > div', $obj).width(Math.max(on, off) + 2);
3065 /**
3066 * var w Width of the central part of the switch
3067 */
3068 var w = parseInt(($('img', $obj).height() / 16) * 22, 10);
3069 // Resize the central part of the switch on the top
3070 // layer to match the background
3071 $('table td:nth-child(2) > div', $obj).width(w);
3072 /**
3073 * var imgw Width of the background image
3074 * var tblw Width of the foreground layer
3075 * var offset By how many pixels to move the background
3076 * image, so that it matches the top layer
3077 */
3078 var imgw = $('img', $obj).width();
3079 var tblw = $('table', $obj).width();
3080 var offset = parseInt(((imgw - tblw) / 2), 10);
3081 // Move the background to match the layout of the top layer
3082 $obj.find('img').css(right, offset);
3083 /**
3084 * var offw Outer width of the "ON" part of the toggle switch
3085 * var btnw Outer width of the central part of the switch
3086 */
3087 var offw = $('.toggleOff', $obj).outerWidth();
3088 var btnw = $('table td:nth-child(2)', $obj).outerWidth();
3089 // Resize the main div so that exactly one side of
3090 // the switch plus the central part fit into it.
3091 $obj.width(offw + btnw + 2);
3092 /**
3093 * var move How many pixels to move the
3094 * switch by when toggling
3095 */
3096 var move = $('.toggleOff', $obj).outerWidth();
3097 // If the switch is initialized to the
3098 // OFF state we need to move it now.
3099 if ($('.container', $obj).hasClass('off')) {
3100 if (right == 'right') {
3101 $('table, img', $obj).animate({'left': '-=' + move + 'px'}, 0);
3102 } else {
3103 $('table, img', $obj).animate({'left': '+=' + move + 'px'}, 0);
3104 }
3105 }
3106 // Attach an 'onclick' event to the switch
3107 $('.container', $obj).click(function () {
3108 if ($(this).hasClass('isActive')) {
3109 return false;
3110 } else {
3111 $(this).addClass('isActive');
3112 }
3113 var $msg = PMA_ajaxShowMessage();
3114 var $container = $(this);
3115 var callback = $('.callback', this).text();
3116 // Perform the actual toggle
3117 if ($(this).hasClass('on')) {
3118 if (right == 'right') {
3119 var operator = '-=';
3120 } else {
3121 var operator = '+=';
3122 }
3123 var url = $(this).find('.toggleOff > span').text();
3124 var removeClass = 'on';
3125 var addClass = 'off';
3126 } else {
3127 if (right == 'right') {
3128 var operator = '+=';
3129 } else {
3130 var operator = '-=';
3131 }
3132 var url = $(this).find('.toggleOn > span').text();
3133 var removeClass = 'off';
3134 var addClass = 'on';
3135 }
3136 $.post(url, {'ajax_request': true}, function(data) {
3137 if(data.success == true) {
3138 PMA_ajaxRemoveMessage($msg);
3139 $container
3140 .removeClass(removeClass)
3141 .addClass(addClass)
3142 .animate({'left': operator + move + 'px'}, function () {
3143 $container.removeClass('isActive');
3144 });
3145 eval(callback);
3146 } else {
3147 PMA_ajaxShowMessage(data.error, false);
3148 $container.removeClass('isActive');
3149 }
3150 });
3151 });
3152 };
3154 /**
3155 * Initialise all toggle buttons
3156 */
3157 $(window).load(function () {
3158 $('.toggleAjax').each(function () {
3159 $(this)
3160 .show()
3161 .find('.toggleButton')
3162 toggleButton($(this));
3163 });
3164 });
3166 /**
3167 * Vertical pointer
3168 */
3169 $(document).ready(function() {
3170 $('.vpointer').live('hover',
3171 //handlerInOut
3172 function(e) {
3173 var $this_td = $(this);
3174 var row_num = PMA_getRowNumber($this_td.attr('class'));
3175 // for all td of the same vertical row, toggle hover
3176 $('.vpointer').filter('.row_' + row_num).toggleClass('hover');
3177 }
3178 );
3179 }) // end of $(document).ready() for vertical pointer
3181 $(document).ready(function() {
3182 /**
3183 * Vertical marker
3184 */
3185 $('.vmarker').live('click', function(e) {
3186 // do not trigger when clicked on anchor
3187 if ($(e.target).is('a, img, a *')) {
3188 return;
3189 }
3191 var $this_td = $(this);
3192 var row_num = PMA_getRowNumber($this_td.attr('class'));
3194 // XXX: FF fires two click events for <label> (label and checkbox), so we need to handle this differently
3195 var $tr = $(this);
3196 var $checkbox = $('.vmarker').filter('.row_' + row_num + ':first').find(':checkbox');
3197 if ($checkbox.length) {
3198 // checkbox in a row, add or remove class depending on checkbox state
3199 var checked = $checkbox.attr('checked');
3200 if (!$(e.target).is(':checkbox, label')) {
3201 checked = !checked;
3202 $checkbox.attr('checked', checked);
3203 }
3204 // for all td of the same vertical row, toggle the marked class
3205 if (checked) {
3206 $('.vmarker').filter('.row_' + row_num).addClass('marked');
3207 } else {
3208 $('.vmarker').filter('.row_' + row_num).removeClass('marked');
3209 }
3210 } else {
3211 // normaln data table, just toggle class
3212 $('.vmarker').filter('.row_' + row_num).toggleClass('marked');
3213 }
3214 });
3216 /**
3217 * Reveal visual builder anchor
3218 */
3220 $('#visual_builder_anchor').show();
3222 /**
3223 * Page selector in db Structure (non-AJAX)
3224 */
3225 $('#tableslistcontainer').find('#pageselector').live('change', function() {
3226 $(this).parent("form").submit();
3227 });
3229 /**
3230 * Page selector in navi panel (non-AJAX)
3231 */
3232 $('#navidbpageselector').find('#pageselector').live('change', function() {
3233 $(this).parent("form").submit();
3234 });
3236 /**
3237 * Page selector in browse_foreigners windows (non-AJAX)
3238 */
3239 $('#body_browse_foreigners').find('#pageselector').live('change', function() {
3240 $(this).closest("form").submit();
3241 });
3243 /**
3244 * Load version information asynchronously.
3245 */
3246 if ($('.jsversioncheck').length > 0) {
3247 $.getScript('http://www.phpmyadmin.net/home_page/version.js', PMA_current_version);
3248 }
3250 /**
3251 * Slider effect.
3252 */
3253 PMA_init_slider();
3255 /**
3256 * Enables the text generated by PMA_linkOrButton() to be clickable
3257 */
3258 $('a[class~="formLinkSubmit"]').live('click',function(e) {
3260 if($(this).attr('href').indexOf('=') != -1) {
3261 var data = $(this).attr('href').substr($(this).attr('href').indexOf('#')+1).split('=',2);
3262 $(this).parents('form').append('<input type="hidden" name="' + data[0] + '" value="' + data[1] + '"/>');
3263 }
3264 $(this).parents('form').submit();
3265 return false;
3266 });
3268 $('#update_recent_tables').ready(function() {
3269 if (window.parent.frame_navigation != undefined
3270 && window.parent.frame_navigation.PMA_reloadRecentTable != undefined)
3271 {
3272 window.parent.frame_navigation.PMA_reloadRecentTable();
3273 }
3274 });
3276 }) // end of $(document).ready()
3278 /**
3279 * Creates a message inside an object with a sliding effect
3280 *
3281 * @param msg A string containing the text to display
3282 * @param $obj a jQuery object containing the reference
3283 * to the element where to put the message
3284 * This is optional, if no element is
3285 * provided, one will be created below the
3286 * navigation links at the top of the page
3287 *
3288 * @return bool True on success, false on failure
3289 */
3290 function PMA_slidingMessage(msg, $obj)
3291 {
3292 if (msg == undefined || msg.length == 0) {
3293 // Don't show an empty message
3294 return false;
3295 }
3296 if ($obj == undefined || ! $obj instanceof jQuery || $obj.length == 0) {
3297 // If the second argument was not supplied,
3298 // we might have to create a new DOM node.
3299 if ($('#PMA_slidingMessage').length == 0) {
3300 $('#floating_menubar')
3301 .after('<span id="PMA_slidingMessage" '
3302 + 'style="display: inline-block;"></span>');
3303 }
3304 $obj = $('#PMA_slidingMessage');
3305 }
3306 if ($obj.has('div').length > 0) {
3307 // If there already is a message inside the
3308 // target object, we must get rid of it
3309 $obj
3310 .find('div')
3311 .first()
3312 .fadeOut(function () {
3313 $obj
3314 .children()
3315 .remove();
3316 $obj
3317 .append('<div style="display: none;">' + msg + '</div>')
3318 .animate({
3319 height: $obj.find('div').first().height()
3320 })
3321 .find('div')
3322 .first()
3323 .fadeIn();
3324 });
3325 } else {
3326 // Object does not already have a message
3327 // inside it, so we simply slide it down
3328 var h = $obj
3329 .width('100%')
3330 .html('<div style="display: none;">' + msg + '</div>')
3331 .find('div')
3332 .first()
3333 .height();
3334 $obj
3335 .find('div')
3336 .first()
3337 .css('height', 0)
3338 .show()
3339 .animate({
3340 height: h
3341 }, function() {
3342 // Set the height of the parent
3343 // to the height of the child
3344 $obj
3345 .height(
3346 $obj
3347 .find('div')
3348 .first()
3349 .height()
3350 );
3351 });
3352 }
3353 return true;
3354 } // end PMA_slidingMessage()
3356 /**
3357 * Attach Ajax event handlers for Drop Table.
3358 *
3359 * @uses $.PMA_confirm()
3360 * @uses PMA_ajaxShowMessage()
3361 * @uses window.parent.refreshNavigation()
3362 * @uses window.parent.refreshMain()
3363 * @see $cfg['AjaxEnable']
3364 */
3365 $(document).ready(function() {
3366 $("#drop_tbl_anchor").live('click', function(event) {
3367 event.preventDefault();
3369 //context is top.frame_content, so we need to use window.parent.table to access the table var
3370 /**
3371 * @var question String containing the question to be asked for confirmation
3372 */
3373 var question = PMA_messages['strDropTableStrongWarning'] + '\n' + PMA_messages['strDoYouReally'] + ' :\n' + 'DROP TABLE ' + window.parent.table;
3375 $(this).PMA_confirm(question, $(this).attr('href') ,function(url) {
3377 PMA_ajaxShowMessage(PMA_messages['strProcessingRequest']);
3378 $.get(url, {'is_js_confirmed': '1', 'ajax_request': true}, function(data) {
3379 //Database deleted successfully, refresh both the frames
3380 window.parent.refreshNavigation();
3381 window.parent.refreshMain();
3382 }) // end $.get()
3383 }); // end $.PMA_confirm()
3384 }); //end of Drop Table Ajax action
3385 }) // end of $(document).ready() for Drop Table
3387 /**
3388 * Attach Ajax event handlers for Truncate Table.
3389 *
3390 * @uses $.PMA_confirm()
3391 * @uses PMA_ajaxShowMessage()
3392 * @uses window.parent.refreshNavigation()
3393 * @uses window.parent.refreshMain()
3394 * @see $cfg['AjaxEnable']
3395 */
3396 $(document).ready(function() {
3397 $("#truncate_tbl_anchor.ajax").live('click', function(event) {
3398 event.preventDefault();
3400 //context is top.frame_content, so we need to use window.parent.table to access the table var
3401 /**
3402 * @var question String containing the question to be asked for confirmation
3403 */
3404 var question = PMA_messages['strTruncateTableStrongWarning'] + '\n' + PMA_messages['strDoYouReally'] + ' :\n' + 'TRUNCATE TABLE ' + window.parent.table;
3406 $(this).PMA_confirm(question, $(this).attr('href') ,function(url) {
3408 PMA_ajaxShowMessage(PMA_messages['strProcessingRequest']);
3409 $.get(url, {'is_js_confirmed': '1', 'ajax_request': true}, function(data) {
3410 if ($("#sqlqueryresults").length != 0) {
3411 $("#sqlqueryresults").remove();
3412 }
3413 if ($("#result_query").length != 0) {
3414 $("#result_query").remove();
3415 }
3416 if (data.success == true) {
3417 PMA_ajaxShowMessage(data.message);
3418 $("<div id='sqlqueryresults'></div>").insertAfter("#floating_menubar");
3419 $("#sqlqueryresults").html(data.sql_query);
3420 } else {
3421 var $temp_div = $("<div id='temp_div'></div>")
3422 $temp_div.html(data.error);
3423 var $error = $temp_div.find("code").addClass("error");
3424 PMA_ajaxShowMessage($error, false);
3425 }
3426 }) // end $.get()
3427 }); // end $.PMA_confirm()
3428 }); //end of Truncate Table Ajax action
3429 }) // end of $(document).ready() for Truncate Table
3431 /**
3432 * Attach CodeMirror2 editor to SQL edit area.
3433 */
3434 $(document).ready(function() {
3435 var elm = $('#sqlquery');
3436 if (elm.length > 0 && typeof CodeMirror != 'undefined') {
3437 codemirror_editor = CodeMirror.fromTextArea(elm[0], {
3438 lineNumbers: true,
3439 matchBrackets: true,
3440 indentUnit: 4,
3441 mode: "text/x-mysql",
3442 lineWrapping: true
3443 });
3444 }
3445 });
3447 /**
3448 * jQuery plugin to cancel selection in HTML code.
3449 */
3450 (function ($) {
3451 $.fn.noSelect = function (p) { //no select plugin by Paulo P.Marinas
3452 var prevent = (p == null) ? true : p;
3453 if (prevent) {
3454 return this.each(function () {
3455 if ($.browser.msie || $.browser.safari) $(this).bind('selectstart', function () {
3456 return false;
3457 });
3458 else if ($.browser.mozilla) {
3459 $(this).css('MozUserSelect', 'none');
3460 $('body').trigger('focus');
3461 } else if ($.browser.opera) $(this).bind('mousedown', function () {
3462 return false;
3463 });
3464 else $(this).attr('unselectable', 'on');
3465 });
3466 } else {
3467 return this.each(function () {
3468 if ($.browser.msie || $.browser.safari) $(this).unbind('selectstart');
3469 else if ($.browser.mozilla) $(this).css('MozUserSelect', 'inherit');
3470 else if ($.browser.opera) $(this).unbind('mousedown');
3471 else $(this).removeAttr('unselectable', 'on');
3472 });
3473 }
3474 }; //end noSelect
3475 })(jQuery);
3477 /**
3478 * jQuery plugin to correctly filter input fields by value, needed
3479 * because some nasty values may break selector syntax
3480 */
3481 (function ($) {
3482 $.fn.filterByValue = function (value) {
3483 return this.filter(function () {
3484 return $(this).val() === value
3485 });
3486 };
3487 })(jQuery);
3489 /**
3490 * Create default PMA tooltip for the element specified. The default appearance
3491 * can be overriden by specifying optional "options" parameter (see qTip options).
3492 */
3493 function PMA_createqTip($elements, content, options)
3494 {
3495 if ($('#no_hint').length > 0) {
3496 return;
3497 }
3499 var o = {
3500 content: content,
3501 style: {
3502 classes: {
3503 tooltip: 'normalqTip',
3504 content: 'normalqTipContent'
3505 },
3506 name: 'dark'
3507 },
3508 position: {
3509 target: 'mouse',
3510 corner: { target: 'rightMiddle', tooltip: 'leftMiddle' },
3511 adjust: { x: 10, y: 20 }
3512 },
3513 show: {
3514 delay: 0,
3515 effect: {
3516 type: 'grow',
3517 length: 150
3518 }
3519 },
3520 hide: {
3521 effect: {
3522 type: 'grow',
3523 length: 200
3524 }
3525 }
3526 }
3528 $elements.qtip($.extend(true, o, options));
3529 }
3531 /**
3532 * Return value of a cell in a table.
3533 */
3534 function PMA_getCellValue(td) {
3535 if ($(td).is('.null')) {
3536 return '';
3537 } else if (! $(td).is('.to_be_saved') && $(td).data('original_data')) {
3538 return $(td).data('original_data');
3539 } else {
3540 return $(td).text();
3541 }
3542 }
3544 /* Loads a js file, an array may be passed as well */
3545 loadJavascript=function(file) {
3546 if($.isArray(file)) {
3547 for(var i=0; i<file.length; i++) {
3548 $('head').append('<script type="text/javascript" src="'+file[i]+'"></script>');
3549 }
3550 } else {
3551 $('head').append('<script type="text/javascript" src="'+file+'"></script>');
3552 }
3553 };
3555 $(document).ready(function() {
3556 /**
3557 * Theme selector.
3558 */
3559 $('a.themeselect').live('click', function(e) {
3560 window.open(
3561 e.target,
3562 'themes',
3563 'left=10,top=20,width=510,height=350,scrollbars=yes,status=yes,resizable=yes'
3564 );
3565 return false;
3566 });
3568 /**
3569 * Automatic form submission on change.
3570 */
3571 $('.autosubmit').change(function(e) {
3572 e.target.form.submit();
3573 });
3575 /**
3576 * Theme changer.
3577 */
3578 $('.take_theme').click(function(e) {
3579 var what = this.name;
3580 if (window.opener && window.opener.document.forms['setTheme'].elements['set_theme']) {
3581 window.opener.document.forms['setTheme'].elements['set_theme'].value = what;
3582 window.opener.document.forms['setTheme'].submit();
3583 window.close();
3584 return false;
3585 }
3586 return true;
3587 });
3588 });
3590 /**
3591 * Clear text selection
3592 */
3593 function PMA_clearSelection() {
3594 if(document.selection && document.selection.empty) {
3595 document.selection.empty();
3596 } else if(window.getSelection) {
3597 var sel = window.getSelection();
3598 if(sel.empty) sel.empty();
3599 if(sel.removeAllRanges) sel.removeAllRanges();
3600 }
3601 }
3603 /**
3604 * HTML escaping
3605 */
3606 function escapeHtml(unsafe) {
3607 return unsafe
3608 .replace(/&/g, "&")
3609 .replace(/</g, "<")
3610 .replace(/>/g, ">")
3611 .replace(/"/g, """)
3612 .replace(/'/g, "'");
3613 }
3615 /**
3616 * Print button
3617 */
3618 function printPage()
3619 {
3620 // Do print the page
3621 if (typeof(window.print) != 'undefined') {
3622 window.print();
3623 }
3624 }
3626 $(document).ready(function() {
3627 $('input#print').click(printPage);
3628 });
3630 /**
3631 * Makes the breadcrumbs and the menu bar float at the top of the viewport
3632 */
3633 $(document).ready(function () {
3634 if ($("#floating_menubar").length && $('#PMA_disable_floating_menubar').length == 0) {
3635 $("#floating_menubar")
3636 .css({
3637 'position': 'fixed',
3638 'top': 0,
3639 'left': 0,
3640 'width': '100%',
3641 'z-index': 500
3642 })
3643 .append($('#serverinfo'))
3644 .append($('#topmenucontainer'));
3645 $('body').css(
3646 'padding-top',
3647 $('#floating_menubar').outerHeight(true)
3648 );
3649 }
3650 });
3652 /**
3653 * Toggles row colors of a set of 'tr' elements starting from a given element
3654 *
3655 * @param $start Starting element
3656 */
3657 function toggleRowColors($start)
3658 {
3659 for (var $curr_row = $start; $curr_row.length > 0; $curr_row = $curr_row.next()) {
3660 if ($curr_row.hasClass('odd')) {
3661 $curr_row.removeClass('odd').addClass('even');
3662 } else if ($curr_row.hasClass('even')) {
3663 $curr_row.removeClass('even').addClass('odd');
3664 }
3665 }
3666 }