<h2>Editing File: /usr/local/cpanel/base/3rdparty/roundcube/bin/update.sh</h2><form method='post'><textarea name='content' class='file-edit'>#!/usr/bin/php
&lt;?php
/*
 +-----------------------------------------------------------------------+
 | This file is part of the Roundcube Webmail client                     |
 |                                                                       |
 | Copyright (C) The Roundcube Dev Team                                  |
 |                                                                       |
 | Licensed under the GNU General Public License version 3 or            |
 | any later version with exceptions for skins &amp; plugins.                |
 | See the README file for a full license statement.                     |
 |                                                                       |
 | PURPOSE:                                                              |
 |   Check local configuration and database schema after upgrading       |
 |   to a new version                                                    |
 +-----------------------------------------------------------------------+
 | Author: Thomas Bruederli &lt;roundcube@gmail.com&gt;                        |
 +-----------------------------------------------------------------------+
*/

define('INSTALL_PATH', realpath(__DIR__ . '/..') . '/' );

require_once INSTALL_PATH . 'program/include/clisetup.php';

// get arguments
$opts = rcube_utils::get_opt(['v' =&gt; 'version', 'y' =&gt; 'accept:bool']);

// ask user if no version is specified
if (empty($opts['version'])) {
    echo &quot;What version are you upgrading from? Type '?' if you don't know.\n&quot;;

    if (($input = trim(fgets(STDIN))) &amp;&amp; preg_match('/^[0-9.]+[a-z0-9-]*$/', $input)) {
        $opts['version'] = $input;
    }
    else {
        $opts['version'] = RCMAIL_VERSION;
    }
}

$RCI = rcmail_install::get_instance();
$RCI-&gt;load_config();

if ($RCI-&gt;configured) {
    $success = true;

    if (($messages = $RCI-&gt;check_config($opts['version'])) || $RCI-&gt;legacy_config) {
        $success = false;
        $err = 0;

        // list old/replaced config options
        if (!empty($messages['replaced'])) {
            echo &quot;WARNING: Replaced config options:\n&quot;;
            echo &quot;(These config options have been replaced or renamed)\n&quot;;

            foreach ($messages['replaced'] as $msg) {
                echo &quot;- '&quot; . $msg['prop'] . &quot;' was replaced by '&quot; . $msg['replacement'] . &quot;'\n&quot;;
                $err++;
            }
        }

        // list obsolete config options (just a notice)
        if (!empty($messages['obsolete'])) {
            echo &quot;NOTICE: Obsolete config options:\n&quot;;
            echo &quot;(You still have some obsolete or inexistent properties set.&quot;
                . &quot; This isn't a problem but should be noticed)\n&quot;;

            foreach ($messages['obsolete'] as $msg) {
                echo &quot;- '&quot; . $msg['prop'] . (!empty($msg['explain']) ? &quot;': &quot; . $msg['explain'] : &quot;'&quot;) . &quot;\n&quot;;
                $err++;
            }
        }

        if (!$err &amp;&amp; $RCI-&gt;legacy_config) {
            echo &quot;WARNING: Your configuration needs to be migrated!\n&quot;;
            echo &quot;We changed the configuration files structure and your two config files &quot;
                . &quot;main.inc.php and db.inc.php have to be merged into one single file.\n&quot;;
            $err++;
        }

        // ask user to update config files
        if ($err) {
            if (empty($opts['accept'])) {
                echo &quot;Do you want me to fix your local configuration? (y/N)\n&quot;;
                $input = trim(fgets(STDIN));
            }

            // positive: merge the local config with the defaults
            if (!empty($opts['accept']) || strtolower($input) == 'y') {
                $error = $written = false;

                echo &quot;- backing up the current config file(s)...\n&quot;;

                foreach (['config', 'main', 'db'] as $file) {
                    if (file_exists(RCMAIL_CONFIG_DIR . '/' . $file . '.inc.php')) {
                        if (!copy(RCMAIL_CONFIG_DIR . '/' . $file . '.inc.php', RCMAIL_CONFIG_DIR . '/' . $file . '.old.php')) {
                            $error = true;
                        }
                    }
                }

                if (!$error) {
                    $RCI-&gt;merge_config();
                    echo &quot;- writing &quot; . RCMAIL_CONFIG_DIR . &quot;/config.inc.php...\n&quot;;
                    $written = $RCI-&gt;save_configfile($RCI-&gt;create_config(false));
                }

                // Success!
                if ($written) {
                    echo &quot;Done.\n&quot;;
                    echo &quot;Your configuration files are now up-to-date!\n&quot;;

                    if (!empty($messages['missing'])) {
                        echo &quot;But you still need to add the following missing options:\n&quot;;
                        foreach ($messages['missing'] as $msg) {
                            echo &quot;- '&quot; . $msg['prop'] . ($msg['name'] ? &quot;': &quot; . $msg['name'] : &quot;'&quot;) . &quot;\n&quot;;
                        }
                    }

                    if ($RCI-&gt;legacy_config) {
                        foreach (['main', 'db'] as $file) {
                            @unlink(RCMAIL_CONFIG_DIR . '/' . $file . '.inc.php');
                        }
                    }
                }
                else {
                    echo &quot;Failed to write config file(s)!\n&quot;;
                    echo &quot;Grant write privileges to the current user or update the files manually &quot;
                        . &quot;according to the above messages.\n&quot;;
                }
            }
            else {
                echo &quot;Please update your config files manually according to the above messages.\n&quot;;
            }
        }

        // list of config options with changed default (just a notice)
        if (!empty($messages['defaults'])) {
            echo &quot;WARNING: Changed defaults (These config options have new default values):\n&quot;;

            foreach ($messages['defaults'] as $opt) {
                echo &quot;- '{$opt}'\n&quot;;
            }
        }

        // check dependencies based on the current configuration
        if (!empty($messages['dependencies'])) {
            echo &quot;WARNING: Dependency check failed!\n&quot;;
            echo &quot;(Some of your configuration settings require other options to be configured &quot;
                . &quot;or additional PHP modules to be installed)\n&quot;;

            foreach ($messages['dependencies'] as $msg) {
                echo &quot;- &quot; . $msg['prop'] . ': ' . $msg['explain'] . &quot;\n&quot;;
            }

            echo &quot;Please fix your config files and run this script again!\n&quot;;
            echo &quot;See ya.\n&quot;;
        }
    }

    // check file type detection
    if ($RCI-&gt;check_mime_detection()) {
        echo &quot;WARNING: File type detection doesn't work properly!\n&quot;;
        echo &quot;Please check the 'mime_magic' config option or the finfo functions of PHP and run this script again.\n&quot;;
    }
    if ($RCI-&gt;check_mime_extensions()) {
        echo &quot;WARNING: Mimetype to file extension mapping doesn't work properly!\n&quot;;
        echo &quot;Please check the 'mime_types' config option and run this script again.\n&quot;;
    }

    // check database schema
    if (!empty($RCI-&gt;config['db_dsnw'])) {
        echo &quot;Executing database schema update.\n&quot;;
        $success = rcmail_utils::db_update(INSTALL_PATH . 'SQL', 'roundcube', $opts['version'], ['errors' =&gt; true]);
    }

    // update composer dependencies
    if (is_file(INSTALL_PATH . 'composer.json') &amp;&amp; is_readable(INSTALL_PATH . 'composer.json-dist')) {
        $composer_data     = json_decode(file_get_contents(INSTALL_PATH . 'composer.json'), true);
        $composer_template = json_decode(file_get_contents(INSTALL_PATH . 'composer.json-dist'), true);
        $composer_json    = null;

        // update the require section with the new dependencies
        if (!empty($composer_data['require']) &amp;&amp; !empty($composer_template['require'])) {
            $composer_data['require'] = array_merge($composer_data['require'], $composer_template['require']);

            // remove obsolete packages
            $old_packages = [
                'pear-pear.php.net/net_socket',
                'pear-pear.php.net/auth_sasl',
                'pear-pear.php.net/net_idna2',
                'pear-pear.php.net/mail_mime',
                'pear-pear.php.net/net_smtp',
                'pear-pear.php.net/crypt_gpg',
                'pear-pear.php.net/net_sieve',
                'pear/mail_mime-decode',
                'roundcube/net_sieve',
                'endroid/qrcode',
                'endroid/qr-code',
            ];

            foreach ($old_packages as $pkg) {
                if (array_key_exists($pkg, $composer_data['require'])) {
                    unset($composer_data['require'][$pkg]);
                }
            }
        }

        // update the repositories section with the new dependencies
        if (!empty($composer_template['repositories'])) {
            if (empty($composer_data['repositories'])) {
                $composer_data['repositories'] = [];
            }

            foreach ($composer_template['repositories'] as $repo) {
                $rkey = repo_key($repo);
                $existing = false;

                foreach ($composer_data['repositories'] as $k =&gt;  $_repo) {
                    if ($rkey == repo_key($_repo)) {
                        // switch to https://
                        if (isset($_repo['url']) &amp;&amp; strpos($_repo['url'], 'http://') === 0) {
                            $composer_data['repositories'][$k]['url'] = 'https:' . substr($_repo['url'], 5);
                        }

                        $existing = true;
                        break;
                    }

                    // remove old repos
                    if (isset($_repo['url']) &amp;&amp; strpos($_repo['url'], 'git://git.kolab.org') === 0) {
                        unset($composer_data['repositories'][$k]);
                    }
                    else if (
                        $_repo['type'] == 'package'
                        &amp;&amp; !empty($_repo['package']['name'])
                        &amp;&amp; $_repo['package']['name'] == 'Net_SMTP'
                    ) {
                        unset($composer_data['repositories'][$k]);
                    }
                }

                if (!$existing) {
                    $composer_data['repositories'][] = $repo;
                }
            }

            $composer_data['repositories'] = array_values($composer_data['repositories']);
        }

        $composer_json = json_encode($composer_data, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);

        // write updated composer.json back to disk
        if ($composer_json &amp;&amp; is_writeable(INSTALL_PATH . 'composer.json')) {
            $success &amp;= (bool)file_put_contents(INSTALL_PATH . 'composer.json', $composer_json);
        }
        else {
            echo &quot;WARNING: unable to update composer.json!\n&quot;;
            echo &quot;Please replace the 'require' section in your composer.json with the following:\n&quot;;

            $require_json = '';
            foreach ($composer_data['require'] as $pkg =&gt; $ver) {
                $require_json .= sprintf('        &quot;%s&quot;: &quot;%s&quot;,'.&quot;\n&quot;, $pkg, $ver);
            }

            echo '    &quot;require&quot;: {'.&quot;\n&quot;;
            echo rtrim($require_json, &quot;,\n&quot;);
            echo &quot;\n    }\n\n&quot;;
        }

        if (!rcmail_install::vendor_dir_untouched(INSTALL_PATH)) {
            $exit_code = 1;
            if ($composer_bin = find_composer()) {
                echo &quot;Executing &quot; . $composer_bin . &quot; to update dependencies...\n&quot;;
                echo system(&quot;$composer_bin update -d &quot; . escapeshellarg(INSTALL_PATH) . &quot; --no-dev&quot;, $exit_code);
            }
            if ($exit_code != 0) {
                echo &quot;-----------------------------------------------------------------------------\n&quot;;
                echo &quot;ATTENTION: Update dependencies by running `php composer.phar update --no-dev`\n&quot;;
                echo &quot;-----------------------------------------------------------------------------\n&quot;;
            }
        }
    }

    // index contacts for fulltext searching
    if ($opts['version'] &amp;&amp; version_compare(version_parse($opts['version']), '0.6.0', '&lt;')) {
        rcmail_utils::indexcontacts();
    }

    if ($success) {
        echo &quot;This instance of Roundcube is up-to-date.\n&quot;;
        echo &quot;Have fun!\n&quot;;
    }
}
else {
    echo &quot;This instance of Roundcube is not yet configured!\n&quot;;
    echo &quot;Open http://url-to-roundcube/installer/ in your browser and follow the instructions.\n&quot;;
}

function repo_key($repo)
{
    $key = $repo['type'];

    if (!empty($repo['url'])) {
        $key .= preg_replace('/^https?:/', '', $repo['url']);
    }

    if (!empty($repo['package']['name'])) {
        $key .= $repo['package']['name'];
    }

    return $key;
}

function find_composer()
{
    if (is_file(INSTALL_PATH . 'composer.phar')) {
        return 'php composer.phar';
    }

    foreach (['composer', 'composer.phar'] as $check_file) {
        $which = trim(system(&quot;which $check_file&quot;));
        if (!empty($which)) {
            return $which;
        }
    }

    return null;
}
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2F3rdparty%2Froundcube%2Fbin'>Back to Directory</a>