1 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 * @fileoverview functions used in server privilege pages
4 * @name Server Privileges
8 * @requires js/functions.js
13 * Validates the "add a user" form
15 * @return boolean whether the form is validated or not
17 function checkAddUser (the_form) {
18 if (the_form.elements.pred_hostname.value === 'userdefined' && the_form.elements.hostname.value === '') {
19 alert(PMA_messages.strHostEmpty);
20 the_form.elements.hostname.focus();
24 if (the_form.elements.pred_username.value === 'userdefined' && the_form.elements.username.value === '') {
25 alert(PMA_messages.strUserEmpty);
26 the_form.elements.username.focus();
30 return PMA_checkPassword($(the_form));
31 } // end of the 'checkAddUser()' function
33 function checkPasswordStrength (value, meter_obj, meter_object_label, username) {
34 // List of words we don't want to appear in the password
43 if (username !== null) {
44 customDict.push(username);
46 var zxcvbn_obj = zxcvbn(value, customDict);
47 var strength = zxcvbn_obj.score;
48 strength = parseInt(strength);
49 meter_obj.val(strength);
51 case 0: meter_obj_label.html(PMA_messages.strExtrWeak);
53 case 1: meter_obj_label.html(PMA_messages.strVeryWeak);
55 case 2: meter_obj_label.html(PMA_messages.strWeak);
57 case 3: meter_obj_label.html(PMA_messages.strGood);
59 case 4: meter_obj_label.html(PMA_messages.strStrong);
64 * AJAX scripts for server_privileges page.
66 * Actions ajaxified here:
71 * Paginate table of users
75 * @name document.ready
80 * Unbind all event handlers before tearing down a page
82 AJAX.registerTeardown('server_privileges.js', function () {
83 $('#fieldset_add_user_login').off('change', 'input[name=\'username\']');
84 $(document).off('click', '#fieldset_delete_user_footer #buttonGo.ajax');
85 $(document).off('click', 'a.edit_user_group_anchor.ajax');
86 $(document).off('click', 'button.mult_submit[value=export]');
87 $(document).off('click', 'a.export_user_anchor.ajax');
88 $(document).off('click', '#initials_table a.ajax');
89 $('#checkbox_drop_users_db').off('click');
90 $(document).off('click', '.checkall_box');
91 $(document).off('change', '#checkbox_SSL_priv');
92 $(document).off('change', 'input[name="ssl_type"]');
93 $(document).off('change', '#select_authentication_plugin');
96 AJAX.registerOnload('server_privileges.js', function () {
98 * Display a warning if there is already a user by the name entered as the username.
100 $('#fieldset_add_user_login').on('change', 'input[name=\'username\']', function () {
101 var username = $(this).val();
102 var $warning = $('#user_exists_warning');
103 if ($('#select_pred_username').val() === 'userdefined' && username !== '') {
104 var href = $('form[name=\'usersForm\']').attr('action');
106 'ajax_request' : true,
107 'server' : PMA_commonParams.get('server'),
108 'validate_username' : true,
109 'username' : username
111 $.get(href, params, function (data) {
112 if (data.user_exists) {
124 * Indicating password strength
126 $('#text_pma_pw').on('keyup', function () {
127 meter_obj = $('#password_strength_meter');
128 meter_obj_label = $('#password_strength');
129 username = $('input[name="username"]');
130 username = username.val();
131 checkPasswordStrength($(this).val(), meter_obj, meter_obj_label, username);
135 * Automatically switching to 'Use Text field' from 'No password' once start writing in text area
137 $('#text_pma_pw').on('input', function () {
138 if ($('#text_pma_pw').val() !== '') {
139 $('#select_pred_password').val('userdefined');
143 $('#text_pma_change_pw').on('keyup', function () {
144 meter_obj = $('#change_password_strength_meter');
145 meter_obj_label = $('#change_password_strength');
146 checkPasswordStrength($(this).val(), meter_obj, meter_obj_label, PMA_commonParams.get('user'));
150 * Display a notice if sha256_password is selected
152 $(document).on('change', '#select_authentication_plugin', function () {
153 var selected_plugin = $(this).val();
154 if (selected_plugin === 'sha256_password') {
155 $('#ssl_reqd_warning').show();
157 $('#ssl_reqd_warning').hide();
162 * AJAX handler for 'Revoke User'
164 * @see PMA_ajaxShowMessage()
166 * @name revoke_user_click
168 $(document).on('click', '#fieldset_delete_user_footer #buttonGo.ajax', function (event) {
169 event.preventDefault();
171 var $thisButton = $(this);
172 var $form = $('#usersForm');
174 $thisButton.PMA_confirm(PMA_messages.strDropUserWarning, $form.attr('action'), function (url) {
175 var $drop_users_db_checkbox = $('#checkbox_drop_users_db');
176 if ($drop_users_db_checkbox.is(':checked')) {
177 var is_confirmed = confirm(PMA_messages.strDropDatabaseStrongWarning + '\n' + PMA_sprintf(PMA_messages.strDoYouReally, 'DROP DATABASE'));
178 if (! is_confirmed) {
179 // Uncheck the drop users database checkbox
180 $drop_users_db_checkbox.prop('checked', false);
184 PMA_ajaxShowMessage(PMA_messages.strRemovingSelectedUsers);
186 var argsep = PMA_commonParams.get('arg_separator');
187 $.post(url, $form.serialize() + argsep + 'delete=' + $thisButton.val() + argsep + 'ajax_request=true', function (data) {
188 if (typeof data !== 'undefined' && data.success === true) {
189 PMA_ajaxShowMessage(data.message);
190 // Refresh navigation, if we droppped some databases with the name
191 // that is the same as the username of the deleted user
192 if ($('#checkbox_drop_users_db:checked').length) {
193 PMA_reloadNavigation();
195 // Remove the revoked user from the users list
196 $form.find('input:checkbox:checked').parents('tr').slideUp('medium', function () {
197 var this_user_initial = $(this).find('input:checkbox').val().charAt(0).toUpperCase();
200 // If this is the last user with this_user_initial, remove the link from #initials_table
201 if ($('#tableuserrights').find('input:checkbox[value^="' + this_user_initial + '"], input:checkbox[value^="' + this_user_initial.toLowerCase() + '"]').length === 0) {
202 $('#initials_table').find('td > a:contains(' + this_user_initial + ')').parent('td').html(this_user_initial);
205 // Re-check the classes of each row
207 .find('tbody').find('tr:odd')
208 .removeClass('even').addClass('odd')
211 .removeClass('odd').addClass('even');
213 // update the checkall checkbox
214 $(checkboxes_sel).trigger('change');
217 PMA_ajaxShowMessage(data.error, false);
221 }); // end Revoke User
223 $(document).on('click', 'a.edit_user_group_anchor.ajax', function (event) {
224 event.preventDefault();
225 $(this).parents('tr').addClass('current_row');
226 var $msg = PMA_ajaxShowMessage();
228 $(this).attr('href'),
230 'ajax_request': true,
231 'edit_user_group_dialog': true
234 if (typeof data !== 'undefined' && data.success === true) {
235 PMA_ajaxRemoveMessage($msg);
236 var buttonOptions = {};
237 buttonOptions[PMA_messages.strGo] = function () {
238 var usrGroup = $('#changeUserGroupDialog')
239 .find('select[name="userGroup"]')
241 var $message = PMA_ajaxShowMessage();
242 var argsep = PMA_commonParams.get('arg_separator');
244 'server_privileges.php',
245 $('#changeUserGroupDialog').find('form').serialize() + argsep + 'ajax_request=1',
247 PMA_ajaxRemoveMessage($message);
248 if (typeof data !== 'undefined' && data.success === true) {
250 .find('.current_row')
251 .removeClass('current_row')
255 PMA_ajaxShowMessage(data.error, false);
257 .find('.current_row')
258 .removeClass('current_row');
262 $(this).dialog('close');
264 buttonOptions[PMA_messages.strClose] = function () {
265 $(this).dialog('close');
267 var $dialog = $('<div/>')
268 .attr('id', 'changeUserGroupDialog')
269 .append(data.message)
274 buttons: buttonOptions,
275 title: $('legend', $(data.message)).text(),
280 $dialog.find('legend').remove();
282 PMA_ajaxShowMessage(data.error, false);
284 .find('.current_row')
285 .removeClass('current_row');
292 * AJAX handler for 'Export Privileges'
294 * @see PMA_ajaxShowMessage()
296 * @name export_user_click
298 $(document).on('click', 'button.mult_submit[value=export]', function (event) {
299 event.preventDefault();
300 // can't export if no users checked
301 if ($(this.form).find('input:checked').length === 0) {
302 PMA_ajaxShowMessage(PMA_messages.strNoAccountSelected, 2000, 'success');
305 var $msgbox = PMA_ajaxShowMessage();
306 var button_options = {};
307 button_options[PMA_messages.strClose] = function () {
308 $(this).dialog('close');
310 var argsep = PMA_commonParams.get('arg_separator');
311 var serverId = PMA_commonParams.get('server');
312 var selectedUsers = $('#usersForm input[name*=\'selected_usr\']:checkbox').serialize();
313 var postStr = selectedUsers + '&submit_mult=export' + argsep + 'ajax_request=true&server=' + serverId;
315 $(this.form).prop('action'),
318 if (typeof data !== 'undefined' && data.success === true) {
319 var $ajaxDialog = $('<div />')
320 .append(data.message)
324 buttons: button_options,
329 PMA_ajaxRemoveMessage($msgbox);
330 // Attach syntax highlighted editor to export dialog
331 PMA_getSQLEditor($ajaxDialog.find('textarea'));
333 PMA_ajaxShowMessage(data.error, false);
338 // if exporting non-ajax, highlight anyways
339 PMA_getSQLEditor($('textarea.export'));
341 $(document).on('click', 'a.export_user_anchor.ajax', function (event) {
342 event.preventDefault();
343 var $msgbox = PMA_ajaxShowMessage();
345 * @var button_options Object containing options for jQueryUI dialog buttons
347 var button_options = {};
348 button_options[PMA_messages.strClose] = function () {
349 $(this).dialog('close');
351 $.get($(this).attr('href'), { 'ajax_request': true }, function (data) {
352 if (typeof data !== 'undefined' && data.success === true) {
353 var $ajaxDialog = $('<div />')
354 .append(data.message)
358 buttons: button_options,
363 PMA_ajaxRemoveMessage($msgbox);
364 // Attach syntax highlighted editor to export dialog
365 PMA_getSQLEditor($ajaxDialog.find('textarea'));
367 PMA_ajaxShowMessage(data.error, false);
370 }); // end export privileges
373 * AJAX handler to Paginate the Users Table
375 * @see PMA_ajaxShowMessage()
376 * @name paginate_users_table_click
379 $(document).on('click', '#initials_table a.ajax', function (event) {
380 event.preventDefault();
381 var $msgbox = PMA_ajaxShowMessage();
382 $.get($(this).attr('href'), { 'ajax_request' : true }, function (data) {
383 if (typeof data !== 'undefined' && data.success === true) {
384 PMA_ajaxRemoveMessage($msgbox);
385 // This form is not on screen when first entering Privileges
386 // if there are more than 50 users
387 $('div.notice').remove();
388 $('#usersForm').hide('medium').remove();
389 $('#fieldset_add_user').hide('medium').remove();
391 .prop('id', 'initials_table_old')
392 .after(data.message).show('medium')
393 .siblings('h2').not(':first').remove();
394 // prevent double initials table
395 $('#initials_table_old').remove();
397 PMA_ajaxShowMessage(data.error, false);
400 }); // end of the paginate users table
402 $(document).on('change', 'input[name="ssl_type"]', function (e) {
403 var $div = $('#specified_div');
404 if ($('#ssl_type_SPECIFIED').is(':checked')) {
405 $div.find('input').prop('disabled', false);
407 $div.find('input').prop('disabled', true);
411 $(document).on('change', '#checkbox_SSL_priv', function (e) {
412 var $div = $('#require_ssl_div');
413 if ($(this).is(':checked')) {
414 $div.find('input').prop('disabled', false);
415 $('#ssl_type_SPECIFIED').trigger('change');
417 $div.find('input').prop('disabled', true);
421 $('#checkbox_SSL_priv').trigger('change');
424 * Create submenu for simpler interface
426 var addOrUpdateSubmenu = function () {
427 var $topmenu2 = $('#topmenu2');
428 var $edit_user_dialog = $('#edit_user_dialog');
433 // if submenu exists yet, remove it first
434 if ($topmenu2.length > 0) {
438 // construct a submenu from the existing fieldsets
439 $topmenu2 = $('<ul/>').prop('id', 'topmenu2');
441 $('#edit_user_dialog .submenu-item').each(function () {
442 submenu_label = $(this).find('legend[data-submenu-label]').data('submenu-label');
444 submenu_link = $('<a/>')
446 .html(submenu_label);
449 .append(submenu_link)
450 .appendTo($topmenu2);
453 // click handlers for submenu
454 $topmenu2.find('a').click(function (e) {
456 // if already active, ignore click
457 if ($(this).hasClass('tabactive')) {
460 $topmenu2.find('a').removeClass('tabactive');
461 $(this).addClass('tabactive');
463 // which section to show now?
464 link_number = $topmenu2.find('a').index($(this));
465 // hide all sections but the one to show
466 $('#edit_user_dialog .submenu-item').hide().eq(link_number).show();
469 // make first menu item active
470 // TODO: support URL hash history
471 $topmenu2.find('> :first-child a').addClass('tabactive');
472 $edit_user_dialog.prepend($topmenu2);
474 // hide all sections but the first
475 $('#edit_user_dialog .submenu-item').hide().eq(0).show();
478 $('html, body').animate({ scrollTop: 0 }, 'fast');
481 $('input.autofocus').focus();
482 $(checkboxes_sel).trigger('change');
483 displayPasswordGenerateButton();
484 if ($('#edit_user_dialog').length > 0) {
485 addOrUpdateSubmenu();
488 var windowwidth = $(window).width();
489 $('.jsresponsive').css('max-width', (windowwidth - 35) + 'px');