<h2>Editing File: /usr/local/cpanel/base/sharedjs/sqlui.js</h2><form method='post'><textarea name='content' class='file-edit'>/*
PAGE variables:
    db_prefix    - optional, string (indicates what the DB prefix is, if any)
    db_engine    - either &quot;mysql&quot; or &quot;postgresql&quot;
    rename_url   - used when renaming a PostgreSQL user
*/
(function(window) {
    &quot;use strict&quot;;

    var LOCALE = window.LOCALE;
    var CPANEL = window.CPANEL;
    var PAGE = window.PAGE;

    var HEADER_TEXT = {
        db: LOCALE.maketext(&quot;Rename Database&quot;),
        user: LOCALE.maketext(&quot;Rename Database User&quot;),
    };

    var PROGRESS_STATUS = {
        db: LOCALE.maketext(&quot;Renaming database …&quot;),
        user: LOCALE.maketext(&quot;Renaming database user …&quot;),
    };

    var API_FUNC;
    if (CPANEL.is_whm()) {
        API_FUNC = {
            mysql: {
                db: &quot;rename_mysql_database&quot;,
                user: &quot;rename_mysql_user&quot;,
            },
            postgresql: {
                db: &quot;rename_postgresql_database&quot;,
                user: &quot;rename_postgresql_user&quot;,
            },
        };
    } else {
        API_FUNC = {
            db: &quot;rename_database&quot;,
            user: &quot;rename_user&quot;,
        };

        API_FUNC = {
            mysql: API_FUNC,
            postgresql: JSON.parse(JSON.stringify(API_FUNC)),
        };

        // Since the password generator requires a modal,
        // and we're already in a modal for the rename. :(
        API_FUNC.postgresql.user = &quot;rename_user_no_password&quot;;
    }

    var VALIDATOR_MAKER = {
        mysql: {
            db: &quot;make_mysql_dbname_validator&quot;,
            user: &quot;make_mysql_username_validator&quot;,
        },
        postgresql: {
            db: &quot;make_postgresql_dbname_validator&quot;,
            user: &quot;make_postgresql_username_validator&quot;,
        },
    };

    var prefix_regexp = PAGE.db_prefix &amp;&amp; new RegExp(&quot;^&quot; + PAGE.db_prefix.regexp_encode());

    var rename_template = Handlebars.compile(DOM.get(&quot;sql_rename_template&quot;).text);

    /**
     * Shows a dialog box that handles a rename API call.
     *
     * @param {String} renamee_type Either &quot;db&quot; or &quot;user&quot;.
     * @param {DOM} source_el An element from which to show the dialog box.
     * @param {String} dbobj_name The name of the object to rename.
     */
    function show_rename_form(renamee_type, source_el, dbobj_name) {

        var is_pgsql_user_rename = (renamee_type === &quot;user&quot;) &amp;&amp; (PAGE.db_engine === &quot;postgresql&quot;);

        var newname;

        var make_newname = function(name) {
            return CPANEL.sql.add_prefix(name);
        };

        var dialog = new CPANEL.ajax.Common_Action_Dialog(&quot;rename_dialog&quot;, {
            close: true,
            clicked_element: source_el,
            header_html: HEADER_TEXT[renamee_type],
            strings: {
                &quot;close&quot;: LOCALE.maketext(&quot;Close&quot;),
            },
            errors_in_notice_box: true,
            show_status: true,
            form_template: rename_template({
                oldname: dbobj_name,
                oldname_no_prefix: prefix_regexp ? dbobj_name.replace(prefix_regexp, &quot;&quot;) : dbobj_name,
                is_postgresql_name: is_pgsql_user_rename,
            }),
            no_hide_after_success: true,
            success_function: function() {
                if (is_pgsql_user_rename) {
                    this.progress_overlay.set_status_now(LOCALE.maketext(&quot;Success! The browser is now redirecting …&quot;));
                    location.href = PAGE.rename_url + &quot;?&quot; + CPANEL.util.make_query_string({
                        user: newname,
                        action_context: &quot;rename&quot;,
                    });
                } else {
                    this.progress_overlay.set_status_now(LOCALE.maketext(&quot;Success! This page will now reload.&quot;));
                    location.reload();
                }
            },
            success_notice_options: {
                visible: false,
            },
            status_template: PROGRESS_STATUS[renamee_type],
            api_calls: [{
                api_version: CPANEL.is_whm() ? 1 : 3,
                api_module: (PAGE.db_engine === &quot;mysql&quot;) ? &quot;Mysql&quot; : &quot;Postgresql&quot;,
                api_function: API_FUNC[PAGE.db_engine][renamee_type],
                data: function() {
                    newname = make_newname(this.form.newname.value);

                    return {
                        oldname: dbobj_name,
                        newname: newname,
                    };
                },
            }],
        });
        dialog.beforeShowEvent.subscribe(function classer(evt) {
            this[evt + &quot;Event&quot;].unsubscribe(classer);
            DOM.addClass(this.element, &quot;rename-dialog&quot;);

            if (prefix_regexp &amp;&amp; !prefix_regexp.test(dbobj_name)) {
                var content = (renamee_type === &quot;db&quot;) ?
                    LOCALE.maketext(&quot;If you change this database’s name, you will be unable to rename it back to “[_1]”. This is because the old name lacks the username prefix ([_2]) that this system requires on the names of all new databases and database users. If you require a name without the prefix, you must contact your server administrator.&quot;, dbobj_name.html_encode(), PAGE.db_prefix.html_encode()) :
                    LOCALE.maketext(&quot;If you change this user’s name, you will be unable to rename it back to “[_1]”. This is because the old name lacks the username prefix ([_2]) that this system requires on the names of all new databases and database users. If you require a name without the prefix, you must contact your server administrator.&quot;, dbobj_name.html_encode(), PAGE.db_prefix.html_encode());

                (new CPANEL.widgets.Page_Notice({
                    level: &quot;warn&quot;,
                    content: content,
                    container: CPANEL.Y(this.element).one(&quot;.oldname-unprefixed-notice-area&quot;),
                    visible: false,
                })).show();
            }

            if ((renamee_type === &quot;db&quot;) &amp;&amp; (PAGE.db_engine === &quot;mysql&quot;)) {
                var backup_link = CPANEL.security_token + &quot;/getsqlbackup/&quot; + encodeURIComponent(dbobj_name) + &quot;.gz&quot;;

                (new CPANEL.widgets.Page_Notice({
                    level: &quot;warn&quot;,
                    content: LOCALE.maketext(&quot;It is a potentially dangerous operation to rename a database. You may want to [output,url,_1,back up this database] before renaming it.&quot;, backup_link),
                    container: CPANEL.Y(this.element).one(&quot;.rename-warning-area&quot;),
                    visible: false,
                })).show();
            }

            var validator_maker_name = VALIDATOR_MAKER[PAGE.db_engine][renamee_type];
            this._validator = CPANEL.sql[validator_maker_name](&quot;rename_newname&quot;);

            this._validator.add_for_submit(
                this.form.newname,
                function() {
                    return make_newname(dialog.form.newname.value) !== dbobj_name;
                },
                LOCALE.maketext(&quot;The new name must be different from the old name.&quot;)
            );
            bindValidationSync(this._validator, this.element);
        });
        dialog.beforeSubmitEvent.subscribe(function() {
            this._validator.verify_for_submit();
            return this._validator.is_valid();
        });
        dialog.animated_show();

        return dialog;
    }

    // Adapter code to show the results of the SQL CJT validations using the Paper Lantern validation markup.
    // Old CJT validation styles are deprecated / broken.
    // This code reuses the existing validation logic and solves the display problems.
    // see FB 117465
    function bindValidationSync(validator, dialog) {
        validator.validateFailure.subscribe(function(type, args) {
            if (args[0] &amp;&amp; args[0].is_submit_only_failure) {
                clearErrors(dialog);
            } else {
                syncErrors(dialog);
            }
        });
        validator.validateSuccess.subscribe(function() {
            clearErrors(dialog);
        });
    }

    // Grab the CJT error element, extract validation results from it and update the validation markup.
    function syncErrors(dialog) {
        var $dialog = $(dialog),
            $cjtError = $dialog.find(&quot;#rename_newname_error&quot;),
            $errorImg = $cjtError.find(&quot;img&quot;),
            $validationContainer = $dialog.find(&quot;#newname_validation_container&quot;),
            $validationMessage = $validationContainer.find(&quot;.validation_errors_li&quot;);
        if ($errorImg.length &amp;&amp; $errorImg.attr(&quot;alt&quot;) === &quot;error&quot;) {
            $validationContainer.removeClass(&quot;hide&quot;);
            $validationMessage.text($errorImg.attr(&quot;title&quot;));
        }
    }

    function clearErrors(dialog) {
        var $dialog = $(dialog),
            $validationContainer = $dialog.find(&quot;#newname_validation_container&quot;),
            $validationMessage = $validationContainer.find(&quot;.validation_errors_li&quot;);
        $validationContainer.addClass(&quot;hide&quot;);
        $validationMessage.text(&quot;&quot;);
    }

    window.SQLUI = {
        show_rename_form: show_rename_form,
    };

}(window));
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2Fsharedjs'>Back to Directory</a>