+global\Installer::__checkConfiguration()

Complexity

Conditions	18
Paths	3744

Size

Total Lines	130
Code Lines	72

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
        private static function __checkConfiguration()
        {
            $errors = array();
            $fields = self::$POST['fields'];

            // Testing the database connection
            try {
                Symphony::Database()->connect(
                    $fields['database']['host'],
                    $fields['database']['user'],
                    $fields['database']['password'],
                    $fields['database']['port'],
                    $fields['database']['db']
                );
            } catch (DatabaseException $e) {
                // Invalid credentials
                // @link http://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html
                if ($e->getDatabaseErrorCode() === 1044 || $e->getDatabaseErrorCode() === 1045) {
                    $errors['database-invalid-credentials'] = array(
                        'msg' => 'Database credentials were denied',
                        'details' => __('Symphony was unable to access the database with these credentials.')
                    );
                }
                // Connection related
                else {
                    $errors['no-database-connection'] = array(
                        'msg' => 'Could not establish database connection.',
                        'details' => __('Symphony was unable to establish a valid database connection. You may need to modify host or port settings.')
                    );
                }
            }

            try {
                // Check the database table prefix is legal. #1815
                if (!preg_match('/^[0-9a-zA-Z\$_]*$/', $fields['database']['tbl_prefix'])) {
                    $errors['database-table-prefix']  = array(
                        'msg' => 'Invalid database table prefix: ‘' . $fields['database']['tbl_prefix'] . '’',
                        'details' =>  __('The table prefix %s is invalid. The table prefix must only contain numbers, letters or underscore characters.', array('<code>' . $fields['database']['tbl_prefix'] . '</code>'))
                    );
                }
                // Check the database credentials
                elseif (Symphony::Database()->isConnected()) {
                    // Incorrect MySQL version
                    $version = Symphony::Database()->fetchVar('version', 0, "SELECT VERSION() AS `version`;");
                    if (version_compare($version, '5.5', '<')) {
                        $errors['database-incorrect-version']  = array(
                            'msg' => 'MySQL Version is not correct. '. $version . ' detected.',
                            'details' => __('Symphony requires %1$s or greater to work, however version %2$s was detected. This requirement must be met before installation can proceed.', array('<code>MySQL 5.5</code>', '<code>' . $version . '</code>'))
                        );
                    } else {
                        // Existing table prefix
                        $tables = Symphony::Database()->fetch(sprintf(
                            "SHOW TABLES FROM `%s` LIKE '%s'",
                            mysqli_real_escape_string(Symphony::Database()->getConnectionResource(), $fields['database']['db']),
                            mysqli_real_escape_string(Symphony::Database()->getConnectionResource(), $fields['database']['tbl_prefix']) . '%'
                        ));

                        if (is_array($tables) && !empty($tables)) {
                            $errors['database-table-prefix']  = array(
                                'msg' => 'Database table prefix clash with ‘' . $fields['database']['db'] . '’',
                                'details' =>  __('The table prefix %s is already in use. Please choose a different prefix to use with Symphony.', array('<code>' . $fields['database']['tbl_prefix'] . '</code>'))
                            );
                        }
                    }
                }
            } catch (DatabaseException $e) {
                $errors['unknown-database']  = array(
                        'msg' => 'Database ‘' . $fields['database']['db'] . '’ not found.',
                        'details' =>  __('Symphony was unable to connect to the specified database.')
                    );
            }

            // Website name not entered
            if (trim($fields['general']['sitename']) == '') {
                $errors['general-no-sitename']  = array(
                    'msg' => 'No sitename entered.',
                    'details' => __('You must enter a Site name. This will be shown at the top of your backend.')
                );
            }

            // Username Not Entered
            if (trim($fields['user']['username']) == '') {
                $errors['user-no-username']  = array(
                    'msg' => 'No username entered.',
                    'details' => __('You must enter a Username. This will be your Symphony login information.')
                );
            }

            // Password Not Entered
            if (trim($fields['user']['password']) == '') {
                $errors['user-no-password']  = array(
                    'msg' => 'No password entered.',
                    'details' => __('You must enter a Password. This will be your Symphony login information.')
                );
            }

            // Password mismatch
            elseif ($fields['user']['password'] != $fields['user']['confirm-password']) {
                $errors['user-password-mismatch']  = array(
                    'msg' => 'Passwords did not match.',
                    'details' => __('The password and confirmation did not match. Please retype your password.')
                );
            }

            // No Name entered
            if (trim($fields['user']['firstname']) == '' || trim($fields['user']['lastname']) == '') {
                $errors['user-no-name']  = array(
                    'msg' => 'Did not enter First and Last names.',
                    'details' =>  __('You must enter your name.')
                );
            }

            // Invalid Email
            if (!preg_match('/^\w(?:\.?[\w%+-]+)*@\w(?:[\w-]*\.)+?[a-z]{2,}$/i', $fields['user']['email'])) {
                $errors['user-invalid-email']  = array(
                    'msg' => 'Invalid email address supplied.',
                    'details' =>  __('This is not a valid email address. You must provide an email address since you will need it if you forget your password.')
                );
            }

            // Admin path not entered
            if (trim($fields['symphony']['admin-path']) == '') {
                $errors['no-symphony-path']  = array(
                    'msg' => 'No Symphony path entered.',
                    'details' => __('You must enter a path for accessing Symphony, or leave the default. This will be used to access Symphony\'s backend.')
                );
            }

            return $errors;
        }