phpmyadmin working

1 files changed, 494 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/js/server/privileges.js b/srcs/phpmyadmin/js/server/privileges.js
new file mode 100644
index 0000000..d3bac3e
--- /dev/null
+++ b/srcs/phpmyadmin/js/server/privileges.js
@@ -0,0 +1,494 @@
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * @fileoverview    functions used in server privilege pages
+ * @name            Server Privileges
+ *
+ * @requires    jQuery
+ * @requires    jQueryUI
+ * @requires    js/functions.js
+ *
+ */
+
+/* global checkboxesSel */ // js/functions.js
+/* global zxcvbn */ // js/vendor/zxcvbn.js
+
+/**
+ * Validates the "add a user" form
+ *
+ * @return boolean  whether the form is validated or not
+ */
+// eslint-disable-next-line no-unused-vars
+function checkAddUser (theForm) {
+    if (theForm.elements.pred_hostname.value === 'userdefined' && theForm.elements.hostname.value === '') {
+        alert(Messages.strHostEmpty);
+        theForm.elements.hostname.focus();
+        return false;
+    }
+
+    if (theForm.elements.pred_username.value === 'userdefined' && theForm.elements.username.value === '') {
+        alert(Messages.strUserEmpty);
+        theForm.elements.username.focus();
+        return false;
+    }
+
+    return Functions.checkPassword($(theForm));
+} // end of the 'checkAddUser()' function
+
+function checkPasswordStrength (value, meterObject, meterObjectLabel, username) {
+    // List of words we don't want to appear in the password
+    var customDict = [
+        'phpmyadmin',
+        'mariadb',
+        'mysql',
+        'php',
+        'my',
+        'admin',
+    ];
+    if (username !== null) {
+        customDict.push(username);
+    }
+    var zxcvbnObject = zxcvbn(value, customDict);
+    var strength = zxcvbnObject.score;
+    strength = parseInt(strength);
+    meterObject.val(strength);
+    switch (strength) {
+    case 0: meterObjectLabel.html(Messages.strExtrWeak);
+        break;
+    case 1: meterObjectLabel.html(Messages.strVeryWeak);
+        break;
+    case 2: meterObjectLabel.html(Messages.strWeak);
+        break;
+    case 3: meterObjectLabel.html(Messages.strGood);
+        break;
+    case 4: meterObjectLabel.html(Messages.strStrong);
+    }
+}
+
+/**
+ * AJAX scripts for server_privileges page.
+ *
+ * Actions ajaxified here:
+ * Add user
+ * Revoke a user
+ * Edit privileges
+ * Export privileges
+ * Paginate table of users
+ * Flush privileges
+ *
+ * @memberOf    jQuery
+ * @name        document.ready
+ */
+
+
+/**
+ * Unbind all event handlers before tearing down a page
+ */
+AJAX.registerTeardown('server/privileges.js', function () {
+    $('#fieldset_add_user_login').off('change', 'input[name=\'username\']');
+    $(document).off('click', '#fieldset_delete_user_footer #buttonGo.ajax');
+    $(document).off('click', 'a.edit_user_group_anchor.ajax');
+    $(document).off('click', 'button.mult_submit[value=export]');
+    $(document).off('click', 'a.export_user_anchor.ajax');
+    $(document).off('click',  '#initials_table a.ajax');
+    $('#checkbox_drop_users_db').off('click');
+    $(document).off('click', '.checkall_box');
+    $(document).off('change', '#checkbox_SSL_priv');
+    $(document).off('change', 'input[name="ssl_type"]');
+    $(document).off('change', '#select_authentication_plugin');
+});
+
+AJAX.registerOnload('server/privileges.js', function () {
+    /**
+     * Display a warning if there is already a user by the name entered as the username.
+     */
+    $('#fieldset_add_user_login').on('change', 'input[name=\'username\']', function () {
+        var username = $(this).val();
+        var $warning = $('#user_exists_warning');
+        if ($('#select_pred_username').val() === 'userdefined' && username !== '') {
+            var href = $('form[name=\'usersForm\']').attr('action');
+            var params = {
+                'ajax_request' : true,
+                'server' : CommonParams.get('server'),
+                'validate_username' : true,
+                'username' : username
+            };
+            $.get(href, params, function (data) {
+                if (data.user_exists) {
+                    $warning.show();
+                } else {
+                    $warning.hide();
+                }
+            });
+        } else {
+            $warning.hide();
+        }
+    });
+
+    /**
+     * Indicating password strength
+     */
+    $('#text_pma_pw').on('keyup', function () {
+        var meterObj = $('#password_strength_meter');
+        var meterObjLabel = $('#password_strength');
+        var username = $('input[name="username"]');
+        username = username.val();
+        checkPasswordStrength($(this).val(), meterObj, meterObjLabel, username);
+    });
+
+    /**
+     * Automatically switching to 'Use Text field' from 'No password' once start writing in text area
+     */
+    $('#text_pma_pw').on('input', function () {
+        if ($('#text_pma_pw').val() !== '') {
+            $('#select_pred_password').val('userdefined');
+        }
+    });
+
+    $('#text_pma_change_pw').on('keyup', function () {
+        var meterObj = $('#change_password_strength_meter');
+        var meterObjLabel = $('#change_password_strength');
+        checkPasswordStrength($(this).val(), meterObj, meterObjLabel, CommonParams.get('user'));
+    });
+
+    /**
+     * Display a notice if sha256_password is selected
+     */
+    $(document).on('change', '#select_authentication_plugin', function () {
+        var selectedPlugin = $(this).val();
+        if (selectedPlugin === 'sha256_password') {
+            $('#ssl_reqd_warning').show();
+        } else {
+            $('#ssl_reqd_warning').hide();
+        }
+    });
+
+    /**
+     * AJAX handler for 'Revoke User'
+     *
+     * @see         Functions.ajaxShowMessage()
+     * @memberOf    jQuery
+     * @name        revoke_user_click
+     */
+    $(document).on('click', '#fieldset_delete_user_footer #buttonGo.ajax', function (event) {
+        event.preventDefault();
+
+        var $thisButton = $(this);
+        var $form = $('#usersForm');
+
+        $thisButton.confirm(Messages.strDropUserWarning, $form.attr('action'), function (url) {
+            var $dropUsersDbCheckbox = $('#checkbox_drop_users_db');
+            if ($dropUsersDbCheckbox.is(':checked')) {
+                var isConfirmed = confirm(Messages.strDropDatabaseStrongWarning + '\n' + Functions.sprintf(Messages.strDoYouReally, 'DROP DATABASE'));
+                if (! isConfirmed) {
+                    // Uncheck the drop users database checkbox
+                    $dropUsersDbCheckbox.prop('checked', false);
+                }
+            }
+
+            Functions.ajaxShowMessage(Messages.strRemovingSelectedUsers);
+
+            var argsep = CommonParams.get('arg_separator');
+            $.post(url, $form.serialize() + argsep + 'delete=' + $thisButton.val() + argsep + 'ajax_request=true', function (data) {
+                if (typeof data !== 'undefined' && data.success === true) {
+                    Functions.ajaxShowMessage(data.message);
+                    // Refresh navigation, if we droppped some databases with the name
+                    // that is the same as the username of the deleted user
+                    if ($('#checkbox_drop_users_db:checked').length) {
+                        Navigation.reload();
+                    }
+                    // Remove the revoked user from the users list
+                    $form.find('input:checkbox:checked').parents('tr').slideUp('medium', function () {
+                        var thisUserInitial = $(this).find('input:checkbox').val().charAt(0).toUpperCase();
+                        $(this).remove();
+
+                        // If this is the last user with this_user_initial, remove the link from #initials_table
+                        if ($('#tableuserrights').find('input:checkbox[value^="' + thisUserInitial + '"], input:checkbox[value^="' + thisUserInitial.toLowerCase() + '"]').length === 0) {
+                            $('#initials_table').find('td > a:contains(' + thisUserInitial + ')').parent('td').html(thisUserInitial);
+                        }
+
+                        // Re-check the classes of each row
+                        $form
+                            .find('tbody').find('tr:odd')
+                            .removeClass('even').addClass('odd')
+                            .end()
+                            .find('tr:even')
+                            .removeClass('odd').addClass('even');
+
+                        // update the checkall checkbox
+                        $(checkboxesSel).trigger('change');
+                    });
+                } else {
+                    Functions.ajaxShowMessage(data.error, false);
+                }
+            }); // end $.post()
+        });
+    }); // end Revoke User
+
+    $(document).on('click', 'a.edit_user_group_anchor.ajax', function (event) {
+        event.preventDefault();
+        $(this).parents('tr').addClass('current_row');
+        var $msg = Functions.ajaxShowMessage();
+        $.get(
+            $(this).attr('href'),
+            {
+                'ajax_request': true,
+                'edit_user_group_dialog': true
+            },
+            function (data) {
+                if (typeof data !== 'undefined' && data.success === true) {
+                    Functions.ajaxRemoveMessage($msg);
+                    var buttonOptions = {};
+                    buttonOptions[Messages.strGo] = function () {
+                        var usrGroup = $('#changeUserGroupDialog')
+                            .find('select[name="userGroup"]')
+                            .val();
+                        var $message = Functions.ajaxShowMessage();
+                        var argsep = CommonParams.get('arg_separator');
+                        $.post(
+                            'server_privileges.php',
+                            $('#changeUserGroupDialog').find('form').serialize() + argsep + 'ajax_request=1',
+                            function (data) {
+                                Functions.ajaxRemoveMessage($message);
+                                if (typeof data !== 'undefined' && data.success === true) {
+                                    $('#usersForm')
+                                        .find('.current_row')
+                                        .removeClass('current_row')
+                                        .find('.usrGroup')
+                                        .text(usrGroup);
+                                } else {
+                                    Functions.ajaxShowMessage(data.error, false);
+                                    $('#usersForm')
+                                        .find('.current_row')
+                                        .removeClass('current_row');
+                                }
+                            }
+                        );
+                        $(this).dialog('close');
+                    };
+                    buttonOptions[Messages.strClose] = function () {
+                        $(this).dialog('close');
+                    };
+                    var $dialog = $('<div></div>')
+                        .attr('id', 'changeUserGroupDialog')
+                        .append(data.message)
+                        .dialog({
+                            width: 500,
+                            minWidth: 300,
+                            modal: true,
+                            buttons: buttonOptions,
+                            title: $('legend', $(data.message)).text(),
+                            close: function () {
+                                $(this).remove();
+                            }
+                        });
+                    $dialog.find('legend').remove();
+                } else {
+                    Functions.ajaxShowMessage(data.error, false);
+                    $('#usersForm')
+                        .find('.current_row')
+                        .removeClass('current_row');
+                }
+            }
+        );
+    });
+
+    /**
+     * AJAX handler for 'Export Privileges'
+     *
+     * @see         Functions.ajaxShowMessage()
+     * @memberOf    jQuery
+     * @name        export_user_click
+     */
+    $(document).on('click', 'button.mult_submit[value=export]', function (event) {
+        event.preventDefault();
+        // can't export if no users checked
+        if ($(this.form).find('input:checked').length === 0) {
+            Functions.ajaxShowMessage(Messages.strNoAccountSelected, 2000, 'success');
+            return;
+        }
+        var $msgbox = Functions.ajaxShowMessage();
+        var buttonOptions = {};
+        buttonOptions[Messages.strClose] = function () {
+            $(this).dialog('close');
+        };
+        var argsep = CommonParams.get('arg_separator');
+        var serverId = CommonParams.get('server');
+        var selectedUsers = $('#usersForm input[name*=\'selected_usr\']:checkbox').serialize();
+        var postStr = selectedUsers + '&submit_mult=export' + argsep + 'ajax_request=true&server=' + serverId;
+        $.post(
+            $(this.form).prop('action'),
+            postStr,
+            function (data) {
+                if (typeof data !== 'undefined' && data.success === true) {
+                    var $ajaxDialog = $('<div></div>')
+                        .append(data.message)
+                        .dialog({
+                            title: data.title,
+                            width: 500,
+                            buttons: buttonOptions,
+                            close: function () {
+                                $(this).remove();
+                            }
+                        });
+                    Functions.ajaxRemoveMessage($msgbox);
+                    // Attach syntax highlighted editor to export dialog
+                    Functions.getSqlEditor($ajaxDialog.find('textarea'));
+                } else {
+                    Functions.ajaxShowMessage(data.error, false);
+                }
+            }
+        ); // end $.post
+    });
+    // if exporting non-ajax, highlight anyways
+    Functions.getSqlEditor($('textarea.export'));
+
+    $(document).on('click', 'a.export_user_anchor.ajax', function (event) {
+        event.preventDefault();
+        var $msgbox = Functions.ajaxShowMessage();
+        /**
+         * @var button_options  Object containing options for jQueryUI dialog buttons
+         */
+        var buttonOptions = {};
+        buttonOptions[Messages.strClose] = function () {
+            $(this).dialog('close');
+        };
+        $.get($(this).attr('href'), { 'ajax_request': true }, function (data) {
+            if (typeof data !== 'undefined' && data.success === true) {
+                var $ajaxDialog = $('<div></div>')
+                    .append(data.message)
+                    .dialog({
+                        title: data.title,
+                        width: 500,
+                        buttons: buttonOptions,
+                        close: function () {
+                            $(this).remove();
+                        }
+                    });
+                Functions.ajaxRemoveMessage($msgbox);
+                // Attach syntax highlighted editor to export dialog
+                Functions.getSqlEditor($ajaxDialog.find('textarea'));
+            } else {
+                Functions.ajaxShowMessage(data.error, false);
+            }
+        }); // end $.get
+    }); // end export privileges
+
+    /**
+     * AJAX handler to Paginate the Users Table
+     *
+     * @see         Functions.ajaxShowMessage()
+     * @name        paginate_users_table_click
+     * @memberOf    jQuery
+     */
+    $(document).on('click', '#initials_table a.ajax', function (event) {
+        event.preventDefault();
+        var $msgbox = Functions.ajaxShowMessage();
+        $.get($(this).attr('href'), { 'ajax_request' : true }, function (data) {
+            if (typeof data !== 'undefined' && data.success === true) {
+                Functions.ajaxRemoveMessage($msgbox);
+                // This form is not on screen when first entering Privileges
+                // if there are more than 50 users
+                $('div.notice').remove();
+                $('#usersForm').hide('medium').remove();
+                $('#fieldset_add_user').hide('medium').remove();
+                $('#initials_table')
+                    .prop('id', 'initials_table_old')
+                    .after(data.message).show('medium')
+                    .siblings('h2').not(':first').remove();
+                // prevent double initials table
+                $('#initials_table_old').remove();
+            } else {
+                Functions.ajaxShowMessage(data.error, false);
+            }
+        }); // end $.get
+    }); // end of the paginate users table
+
+    $(document).on('change', 'input[name="ssl_type"]', function () {
+        var $div = $('#specified_div');
+        if ($('#ssl_type_SPECIFIED').is(':checked')) {
+            $div.find('input').prop('disabled', false);
+        } else {
+            $div.find('input').prop('disabled', true);
+        }
+    });
+
+    $(document).on('change', '#checkbox_SSL_priv', function () {
+        var $div = $('#require_ssl_div');
+        if ($(this).is(':checked')) {
+            $div.find('input').prop('disabled', false);
+            $('#ssl_type_SPECIFIED').trigger('change');
+        } else {
+            $div.find('input').prop('disabled', true);
+        }
+    });
+
+    $('#checkbox_SSL_priv').trigger('change');
+
+    /*
+     * Create submenu for simpler interface
+     */
+    var addOrUpdateSubmenu = function () {
+        var $topmenu2 = $('#topmenu2');
+        var $editUserDialog = $('#edit_user_dialog');
+        var submenuLabel;
+        var submenuLink;
+        var linkNumber;
+
+        // if submenu exists yet, remove it first
+        if ($topmenu2.length > 0) {
+            $topmenu2.remove();
+        }
+
+        // construct a submenu from the existing fieldsets
+        $topmenu2 = $('<ul></ul>').prop('id', 'topmenu2');
+
+        $('#edit_user_dialog .submenu-item').each(function () {
+            submenuLabel = $(this).find('legend[data-submenu-label]').data('submenu-label');
+
+            submenuLink = $('<a></a>')
+                .prop('href', '#')
+                .html(submenuLabel);
+
+            $('<li></li>')
+                .append(submenuLink)
+                .appendTo($topmenu2);
+        });
+
+        // click handlers for submenu
+        $topmenu2.find('a').on('click', function (e) {
+            e.preventDefault();
+            // if already active, ignore click
+            if ($(this).hasClass('tabactive')) {
+                return;
+            }
+            $topmenu2.find('a').removeClass('tabactive');
+            $(this).addClass('tabactive');
+
+            // which section to show now?
+            linkNumber = $topmenu2.find('a').index($(this));
+            // hide all sections but the one to show
+            $('#edit_user_dialog .submenu-item').hide().eq(linkNumber).show();
+        });
+
+        // make first menu item active
+        // TODO: support URL hash history
+        $topmenu2.find('> :first-child a').addClass('tabactive');
+        $editUserDialog.prepend($topmenu2);
+
+        // hide all sections but the first
+        $('#edit_user_dialog .submenu-item').hide().eq(0).show();
+
+        // scroll to the top
+        $('html, body').animate({ scrollTop: 0 }, 'fast');
+    };
+
+    $('input.autofocus').trigger('focus');
+    $(checkboxesSel).trigger('change');
+    Functions.displayPasswordGenerateButton();
+    if ($('#edit_user_dialog').length > 0) {
+        addOrUpdateSubmenu();
+    }
+
+    var windowWidth = $(window).width();
+    $('.jsresponsive').css('max-width', (windowWidth - 35) + 'px');
+});