upgrade_ajax.php ➔ addColumnIfNotExist() - Code Metrics - Inspection of "2.1.27" - nilsteampassnet/TeamPass - Measure and Improve Code Quality continuously with Scrutinizer

Completed
Push — development ( 676bb1...171946 )

by Nils
created 2017-09-21 08:52 UTC
upgrade_ajax.php ➔ addColumnIfNotExist() A

↳ Parent: Project
Complexity

Conditions	4
Paths	5
Size

Total Lines	15
Code Lines	11
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	4
eloc	11
nc	5
nop	3
dl	0
loc	15
rs	9.2
c	0
b	0
f	0
<?php
/**
 * @file          upgrade.ajax.php
 * @author        Nils Laumaillé
 * @version       2.1.27
 * @copyright     (c) 2009-2017 Nils Laumaillé
 * @licensing     GNU AFFERO GPL 3.0
 * @link          http://www.teampass.net
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 */

require_once('../sources/SecureHandler.php');
session_start();
error_reporting(E_ERROR | E_PARSE);
$_SESSION['CPM'] = 1;

require_once '../includes/language/english.php';
require_once '../includes/config/include.php';

// manage settings.php file
if (!file_exists("../includes/config/settings.php")) {
    if (file_exists("../includes/settings.php")) {
        // since 2.1.27, this file has changed location
        if (copy("../includes/settings.php", "../includes/config/settings.php")) {
            unlink("../includes/settings.php");
        } else {
            echo 'document.getElementById("res_step1_error").innerHTML = '.
                '"Could not copy /includes/settings.php to /includes/config/settings.php! '.
                'Please do it manually and press button Launch.";';
            echo 'document.getElementById("loader").style.display = "none";';
            exit;
        }
    } else {
        echo 'document.getElementById("res_step1_error").innerHTML = '.
            '"File settings.php does not exist in folder includes/! '.
            'If it is an upgrade, it should be there, otherwise select install!";';
        echo 'document.getElementById("loader").style.display = "none";';
        exit;
    }
}
require_once '../includes/config/settings.php';
require_once '../sources/main.functions.php';


//define pbkdf2 iteration count
define('ITCOUNT', '2072');


// Prepare POST variables
$post_type = filter_input(INPUT_POST, 'type', FILTER_SANITIZE_STRING);
$post_data = filter_input(INPUT_POST, 'data', FILTER_SANITIZE_STRING);
$post_index = filter_input(INPUT_POST, 'index', FILTER_SANITIZE_NUMBER_INT);
$post_multiple = filter_input(INPUT_POST, 'multiple', FILTER_SANITIZE_STRING);
$post_login = filter_input(INPUT_POST, 'login', FILTER_SANITIZE_STRING);
$post_pwd = filter_input(INPUT_POST, 'pwd', FILTER_SANITIZE_STRING);
$post_fullurl = filter_input(INPUT_POST, 'fullurl', FILTER_SANITIZE_STRING);
$post_abspath = filter_input(INPUT_POST, 'abspath', FILTER_SANITIZE_STRING);
$post_no_previous_sk = filter_input(INPUT_POST, 'no_previous_sk', FILTER_SANITIZE_STRING);
$post_session_salt = filter_input(INPUT_POST, 'session_salt', FILTER_SANITIZE_STRING);
$post_previous_sk = filter_input(INPUT_POST, 'previous_sk', FILTER_SANITIZE_STRING);
$post_no_maintenance_mode = filter_input(INPUT_POST, 'no_maintenance_mode', FILTER_SANITIZE_STRING);
$post_prefix_before_convert = filter_input(INPUT_POST, 'prefix_before_convert', FILTER_SANITIZE_STRING);
$post_sk_path = filter_input(INPUT_POST, 'sk_path', FILTER_SANITIZE_STRING);
$post_url_path = filter_input(INPUT_POST, 'url_path', FILTER_SANITIZE_STRING);


// Test DB connexion
$pass = defuse_return_decrypted($pass);
if (mysqli_connect(
    $server,
    $user,
    $pass,
    $database,
    $port
)
) {
    $db_link = mysqli_connect(
        $server,
        $user,
        $pass,
        $database,
        $port
    );
    $res = "Connection is successful";
    echo 'document.getElementById("but_next").disabled = "";';
} else {
    $res = "Impossible to get connected to server. Error is: ".addslashes(mysqli_connect_error());
    echo 'document.getElementById("but_next").disabled = "disabled";';
    echo 'document.getElementById("res_".$post_type).innerHTML = "'.$res.'";';
    echo 'document.getElementById("loader").style.display = "none";';
    return false;
}


// Load libraries
require_once '../includes/libraries/protect/SuperGlobal/SuperGlobal.php';
$superGlobal = new protect\SuperGlobal\SuperGlobal();

// Set Session
$superGlobal->put("CPM", 1, "SESSION");
$superGlobal->put("db_encoding", "utf8", "SESSION");
$_SESSION['settings']['loaded'] = "";
if (empty($post_fullurl) === false) {
    $superGlobal->put("fullurl", $post_fullurl, "SESSION");
}
if (empty($abspath) === false) {
    $superGlobal->put("abspath", $abspath, "SESSION");
}

// Get Sessions
$session_url_path = $superGlobal->get("url_path", "SESSION");

################
## Function permits to get the value from a line
################
/**
 * @param string $val
 */
function getSettingValue($val)
/**
 * @ignore
 */
function getUser() {

}

function getUser($id, $realm) {

}
{
    $val = trim(strstr($val, "="));
    return trim(str_replace('"', '', substr($val, 1, strpos($val, ";") - 1)));
}

################
## Function permits to check if a column exists, and if not to add it
################
function addColumnIfNotExist($dbname, $column, $columnAttr = "VARCHAR(255) NULL")
{
    global $db_link;
    $exists = false;
    $columns = mysqli_query($db_link, "show columns from $dbname");
    while ($col = mysqli_fetch_assoc($columns)) {
        if ($col['Field'] == $column) {
            $exists = true;
            break;
        }
    }
    if (!$exists) {
        return mysqli_query($db_link, "ALTER TABLE `$dbname` ADD `$column`  $columnAttr");
    }
}

function addIndexIfNotExist($table, $index, $sql)

{
    global $db_link;

    $mysqli_result = mysqli_query($db_link, "SHOW INDEX FROM $table WHERE key_name LIKE \"$index\"");
    $res = mysqli_fetch_row($mysqli_result);

    // if index does not exist, then add it
    if (!$res) {
        $res = mysqli_query($db_link, "ALTER TABLE `$table` ".$sql);
    }

    return $res;
}

function tableExists($tablename)

{
    global $db_link, $database;

    $res = mysqli_query(
        $db_link,
        "SELECT COUNT(*) as count
        FROM information_schema.tables
        WHERE table_schema = '".$database."'
        AND table_name = '$tablename'"
    );

    if ($res > 0) {
        return true;
    } else {
        return false;
    }
}

if (isset($post_type)) {
    switch ($post_type) {
        case "step0":
            // erase session table
            $_SESSION = array();
            setcookie('pma_end_session');
            session_destroy();

            echo 'document.getElementById("res_step0").innerHTML = "";';
            require_once 'libs/aesctr.php';

            // check if path in settings.php are consistent
            if (!is_dir(SECUREPATH)) {
                echo 'document.getElementById("but_next").disabled = "disabled";';
                echo 'document.getElementById("res_step0").innerHTML = "Error in settings.php file!<br>Check correctness of path indicated in file `includes/config/settings.php`.<br>Reload this page and retry.";';
                echo 'document.getElementById("loader").style.display = "none";';
                break;
            }
            if (!file_exists(SECUREPATH."/sk.php")) {
                echo 'document.getElementById("but_next").disabled = "disabled";';
                echo 'document.getElementById("res_step0").innerHTML = "Error in settings.php file!<br>Check that file `sk.php` exists as defined in `includes/config/settings.php`.<br>Reload this page and retry.";';
                echo 'document.getElementById("loader").style.display = "none";';
                break;
            }

            $_SESSION['settings']['cpassman_dir'] = "..";
            require_once '../includes/libraries/PasswordLib/Random/Generator.php';
            require_once '../includes/libraries/PasswordLib/Random/Source.php';
            require_once '../includes/libraries/PasswordLib/Random/Source/MTRand.php';
            require_once '../includes/libraries/PasswordLib/Random/Source/Rand.php';
            require_once '../includes/libraries/PasswordLib/Random/Source/UniqID.php';
            require_once '../includes/libraries/PasswordLib/Random/Source/URandom.php';
            require_once '../includes/libraries/PasswordLib/Random/Source/MicroTime.php';
            require_once '../includes/libraries/PasswordLib/Random/Source/CAPICOM.php';
            require_once '../includes/libraries/PasswordLib/Random/Mixer.php';
            require_once '../includes/libraries/PasswordLib/Random/AbstractMixer.php';
            require_once '../includes/libraries/PasswordLib/Random/Mixer/Hash.php';
            require_once '../includes/libraries/PasswordLib/Password/AbstractPassword.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/Hash.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/Crypt.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/SHA256.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/SHA512.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/PHPASS.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/PHPBB.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/PBKDF.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/MediaWiki.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/MD5.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/Joomla.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/Drupal.php';
            require_once '../includes/libraries/PasswordLib/Password/Implementation/APR1.php';
            require_once '../includes/libraries/PasswordLib/PasswordLib.php';
            $pwdlib = new PasswordLib\PasswordLib();

            // Connect to db and check user is granted
            $user_info = mysqli_fetch_array(
                mysqli_query(
                    $db_link,
                    "SELECT pw, admin FROM ".$pre."users
                    WHERE login='".mysqli_escape_string($db_link, stripslashes($post_login))."'"
                )
            );

            if (empty($user_info['pw']) || $user_info['pw'] === null) {
                echo 'document.getElementById("but_next").disabled = "disabled";';
                echo 'document.getElementById("res_step0").innerHTML = "This user is not allowed!";';
                echo 'document.getElementById("user_granted").value = "0";';
                $superGlobal->put("user_granted", false, "SESSION");
            } else {
                if ($pwdlib->verifyPasswordHash(Encryption\Crypt\aesctr::decrypt(base64_decode($post_pwd), "cpm", 128), $user_info['pw']) === true && $user_info['admin'] === "1") {
function acceptsInteger($int) { }

$x = '123'; // string "123"

// Instead of
acceptsInteger($x);

// we recommend to use
acceptsInteger((integer) $x);
                    echo 'document.getElementById("but_next").disabled = "";';
                    echo 'document.getElementById("res_step0").innerHTML = "User is granted.";';
                    echo 'document.getElementById("step").value = "1";';
                    echo 'document.getElementById("user_granted").value = "1";';
                    $superGlobal->put("user_granted", true, "SESSION");
                } else {
                    echo 'document.getElementById("but_next").disabled = "disabled";';
                    echo 'document.getElementById("res_step0").innerHTML = "This user is not allowed!";';
                    echo 'document.getElementById("user_granted").value = "0";';
                    $superGlobal->put("user_granted", false, "SESSION");
                }
            }

            echo 'document.getElementById("loader").style.display = "none";';
            break;

        case "step1":
            $session_user_granted = $superGlobal->get("user_granted", "SESSION");

            if (intval($session_user_granted) !== 1) {
                echo 'document.getElementById("res_step1").innerHTML = "User not connected anymore!";';
                echo 'document.getElementById("loader").style.display = "none";';
                break;
            }

            $abspath = str_replace('\\', '/', $post_abspath);
            if (substr($abspath, strlen($abspath) - 1) == "/") {
                $abspath = substr($abspath, 0, strlen($abspath) - 1);
            }
            $okWritable = true;
            $okExtensions = true;
            $txt = "";
            $var_x = 1;
            $tab = array(
                $abspath."/includes/config/settings.php",
                $abspath."/includes/libraries/csrfp/libs/",
                $abspath."/install/",
                $abspath."/includes/",
                $abspath."/includes/config/",
                $abspath."/includes/avatars/",
                $abspath."/files/",
                $abspath."/upload/"
            );
            foreach ($tab as $elem) {
                // try to create it if not existing
                if (substr($elem, -1) === '/' && !is_dir($elem)) {
                    mkdir($elem);
                }
                // check if writable
                if (is_writable($elem)) {
                    $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">'.
                        $elem.'&nbsp;&nbsp;<img src=\"images/tick-circle.png\"></span><br />';
                } else {
                    $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">'.
                        $elem.'&nbsp;&nbsp;<img src=\"images/minus-circle.png\"></span><br />';
                    $okWritable = false;
                }
                $var_x++;
            }

            if (!extension_loaded('mcrypt')) {
                $okExtensions = false;
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"mcrypt\"'.
                    '&nbsp;&nbsp;<img src=\"images/minus-circle.png\"></span><br />';
            } else {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"mcrypt\"'.
                    '&nbsp;&nbsp;<img src=\"images/tick-circle.png\"></span><br />';
            }
            if (!extension_loaded('openssl')) {
                //$okExtensions = false;

                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"openssl\"'.
                    '&nbsp;&nbsp;<img src=\"images/minus-circle.png\"></span><br />';
            } else {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"openssl\"'.
                    '&nbsp;&nbsp;<img src=\"images/tick-circle.png\"></span><br />';
            }
            if (!extension_loaded('gd')) {
                //$okExtensions = false;

                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"gd\"'.
                    '&nbsp;&nbsp;<img src=\"images/minus-circle.png\"></span><br />';
            } else {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"gd\"'.
                    '&nbsp;&nbsp;<img src=\"images/tick-circle.png\"></span><br />';
            }
            if (!extension_loaded('mbstring')) {
                //$okExtensions = false;

                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"mbstring\"'.
                    '&nbsp;&nbsp;<img src=\"images/minus-circle.png\"></span><br />';
            } else {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"mbstring\"'.
                    '&nbsp;&nbsp;<img src=\"images/tick-circle.png\"></span><br />';
            }
            if (!extension_loaded('bcmath')) {
                //$okExtensions = false;

                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"bcmath\"'.
                    '&nbsp;&nbsp;<img src=\"images/minus-circle.png\"></span><br />';
            } else {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"bcmath\"'.
                    '&nbsp;&nbsp;<img src=\"images/tick-circle.png\"></span><br />';
            }
            if (!extension_loaded('iconv')) {
                //$okExtensions = false;

                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"iconv\"'.
                    '&nbsp;&nbsp;<img src=\"images/minus-circle.png\"></span><br />';
            } else {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"iconv\"'.
                    '&nbsp;&nbsp;<img src=\"images/tick-circle.png\"></span><br />';
            }
            if (!extension_loaded('xml')) {
                //$okExtensions = false;

                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"xml\"'.
                    '&nbsp;&nbsp;<img src=\"images/minus-circle.png\"></span><br />';
            } else {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"xml\"'.
                    '&nbsp;&nbsp;<img src=\"images/tick-circle.png\"></span><br />';
            }
            if (!extension_loaded('curl')) {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"curl\"'.
                    '&nbsp;&nbsp;<img src=\"images/minus-circle.png\"></span><br />';
            } else {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP extension \"curl\"'.
                    '&nbsp;&nbsp;<img src=\"images/tick-circle.png\"></span><br />';
            }
            if (ini_get('max_execution_time') < 60) {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP \"Maximum '.
                    'execution time\" is set to '.ini_get('max_execution_time').' seconds.'.
                    ' Please try to set to 60s at least until Upgrade is finished.&nbsp;'.
                    '&nbsp;<img src=\"images/minus-circle.png\"></span> <br />';
            } else {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP \"Maximum '.
                    'execution time\" is set to '.ini_get('max_execution_time').' seconds'.
                    '&nbsp;&nbsp;<img src=\"images/tick-circle.png\"></span><br />';
            }
            if (version_compare(phpversion(), '5.5.0', '<')) {
                $okVersion = false;
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP version '.
                    phpversion().' is not OK (minimum is 5.5.0) &nbsp;&nbsp;'.
                    '<img src=\"images/minus-circle.png\"></span><br />';
            } else {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">PHP version '.
                    phpversion().' is OK&nbsp;&nbsp;<img src=\"images/tick-circle.png\">'.
                    '</span><br />';
            }

            //get infos from SETTINGS.PHP file
            $filename = "../includes/config/settings.php";
            $events = "";
            if (file_exists($filename)) {
                //copy some constants from this existing file
                $settingsFile = file($filename);
                while (list($key, $val) = each($settingsFile)) {
                    if (substr_count($val, 'charset') > 0) {
                        $superGlobal->put("charset", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '@define(') > 0 && substr_count($val, 'SALT') > 0) {
                        $superGlobal->put("encrypt_key", substr($val, 17, strpos($val, "')") - 17), "SESSION");
                    } elseif (substr_count($val, '$smtp_server') > 0) {
                        $superGlobal->put("smtp_server", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$smtp_auth') > 0) {
                        $superGlobal->put("smtp_auth", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$smtp_auth_username') > 0) {
                        $superGlobal->put("smtp_auth_username", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$smtp_auth_password') > 0) {
                        $superGlobal->put("smtp_auth_password", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$smtp_port') > 0) {
                        $superGlobal->put("smtp_port", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$smtp_security') > 0) {
                        $superGlobal->put("smtp_security", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$email_from') > 0) {
                        $superGlobal->put("email_from", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$email_from_name') > 0) {
                        $superGlobal->put("email_from_name", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$server') > 0) {
                        $superGlobal->put("server", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$user') > 0) {
                        $superGlobal->put("user", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$pass') > 0) {
                        $superGlobal->put("pass", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$port') > 0) {
                        $superGlobal->put("port", getSettingValue($val), "SESSION");
                    } elseif (substr_count($val, '$database') > 0) {
                        $database = getSettingValue($val);
                    } elseif (substr_count($val, '$pre') > 0) {
                        $pre = getSettingValue($val);
                    } elseif (substr_count($val, "define('SECUREPATH',") > 0) {
                        $superGlobal->put("sk_file", substr($val, 23, strpos($val, ');')-24)."/sk.php", "SESSION");
                    }
                }
            }
            $session_sk_file = $superGlobal->get("sk_file", "SESSION");
            if (isset($session_sk_file) && !empty($session_sk_file)
                && file_exists($session_sk_file)
            ) {
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">sk.php file'.
                    ' found in \"'.addslashes($session_sk_file).'\"&nbsp;&nbsp;<img src=\"images/tick-circle.png\">'.
                    '</span><br />';
                //copy some constants from this existing file
                $skFile = file($session_sk_file);
if ( ! in_array($value, array('this-is-allowed', 'and-this-too'), true)) {
    throw new \InvalidArgumentException('This input is not allowed.');
}
                while (list($key, $val) = each($skFile)) {
                    if (substr_count($val, "@define('SALT'") > 0) {
                        $superGlobal->put("encrypt_key", substr($val, 17, strpos($val, "')") - 17), "SESSION");
                        $session_encrypt_key = $superGlobal->get("encrypt_key", "SESSION");
                        echo '$("#session_salt").val("'.$session_encrypt_key.'");';
// for HTML
$sanitized = htmlentities($tainted, ENT_QUOTES);

// for URLs
$sanitized = urlencode($tainted);
                    }
                }
            }

            if (!isset($session_encrypt_key) || empty($session_encrypt_key)) {
                // check if 2.1.27 already installed
                $defuse_file = substr($session_sk_file, 0, strrpos($session_sk_file, "/"))."/teampass-seckey.txt";
                if (file_exists($defuse_file)) {
                    $okEncryptKey = true;
                    $superGlobal->put("tp_defuse_installed", true, "SESSION");
                    $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">Defuse encryption key is defined&nbsp;&nbsp;<img src=\"images/tick-circle.png\">'.
                        '</span><br />';
                } else {
                    $okEncryptKey = false;
                    $superGlobal->put("tp_defuse_installed", false, "SESSION");
                    $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">Encryption Key (SALT) '.
                        ' could not be recovered &nbsp;&nbsp;'.
                        '<img src=\"images/minus-circle.png\"></span><br />';
                }
            } else {
                $okEncryptKey = true;
                $txt .= '<span style=\"padding-left:30px;font-size:13pt;\">Encryption Key (SALT) is available&nbsp;&nbsp;<img src=\"images/tick-circle.png\">'.
                    '</span><br />';
            }

            if ($okWritable === true && $okExtensions === true && $okEncryptKey === true) {
                echo 'document.getElementById("but_next").disabled = "";';
                echo 'document.getElementById("res_step1").innerHTML = "Elements are OK.";';
            } else {
                echo 'document.getElementById("but_next").disabled = "disabled";';
                echo 'document.getElementById("res_step1").innerHTML = "Correct the shown '.
                    'errors and click on button Launch to refresh";';
            }

            echo 'document.getElementById("res_step1").innerHTML = "'.$txt.'";';
// for HTML
$sanitized = htmlentities($tainted, ENT_QUOTES);

// for URLs
$sanitized = urlencode($tainted);
            echo 'document.getElementById("loader").style.display = "none";';
            break;

            #==========================
        case "step2":
            $res = "";
            $session_user_granted = $superGlobal->get("user_granted", "SESSION");

            if ($session_user_granted !== "1") {
                echo 'document.getElementById("res_step2").innerHTML = "User not connected anymore!";';
                echo 'document.getElementById("loader").style.display = "none";';
                break;
            }
            //decrypt the password
            // AES Counter Mode implementation
            require_once 'libs/aesctr.php';

            // check in db if previous saltk exists
            if ($post_no_previous_sk === "false" || $post_no_previous_sk === "previous_sk_sel") {
                $db_sk = mysqli_fetch_row(mysqli_query($db_link, "SELECT count(*) FROM ".$pre."misc
                WHERE type='admin' AND intitule = 'saltkey_ante_2127'"));
                if (!empty($post_previous_sk) || !empty($post_session_salt)) {
                    // get sk
                    if (!empty($post_session_salt)) {
                        $sk_val = filter_var($post_session_salt, FILTER_SANITIZE_STRING);
                    } else {
                        $sk_val = filter_var($post_previous_sk, FILTER_SANITIZE_STRING);
                    }

                    // Update
                    if (!empty($db_sk[0])) {
                        mysqli_query(
                            $db_link,
                            "UPDATE `".$pre."misc`
                            SET `valeur` = '".$sk_val."'
                            WHERE type = 'admin' AND intitule = 'saltkey_ante_2127'"
                        );
                    } else {
                        mysqli_query(
                            $db_link,
                            "INSERT INTO `".$pre."misc`
                            (`valeur`, `type`, `intitule`)
                            VALUES ('".$sk_val."', 'admin', 'saltkey_ante_2127')"
                        );
                    }
                } elseif (empty($db_sk[0])) {
                    $res = "Please provide Teampass instance history.";
                    echo 'document.getElementById("but_next").disabled = "disabled";';
                    echo 'document.getElementById("res_step2").innerHTML = "'.$res.'";';
                    echo 'document.getElementById("loader").style.display = "none";';
                    echo 'document.getElementById("no_encrypt_key").style.display = "";';
                }
            } else {
                // user said that database has not being used for an older version
                // no old sk is available
                    $tmp = mysqli_num_rows(mysqli_query(
                        $db_link,
                        "SELECT * FROM `".$pre."misc`
                        WHERE type = 'admin' AND intitule = 'saltkey_ante_2127'"
                    ));
                if ($tmp == 0) {
                    mysqli_query(
                        $db_link,
                        "INSERT INTO `".$pre."misc`
                        (`valeur`, `type`, `intitule`)
                        VALUES ('none', 'admin', 'saltkey_ante_2127')"
                    );
                } else {
                    mysqli_query(
                        $db_link,
                        "INSERT INTO `".$pre."misc`
                        (`valeur`, `type`, `intitule`)
                        VALUES ('none', 'admin', 'saltkey_ante_2127')"
                    );
                }
                $superGlobal->put("tp_defuse_installed", true, "SESSION");
            }

            //What CPM version
            if (mysqli_query(
                $db_link,
                "SELECT valeur FROM ".$pre."misc
                WHERE type='admin' AND intitule = 'cpassman_version'"
            )) {
                $tmpResult = mysqli_query(
                    $db_link,
                    "SELECT valeur FROM ".$pre."misc
                    WHERE type='admin' AND intitule = 'cpassman_version'"
                );
                $cpmVersion = mysqli_fetch_row($tmpResult);
                echo 'document.getElementById("actual_cpm_version").value = "'.
                    $cpmVersion[0].'";';
            } else {
                echo 'document.getElementById("actual_cpm_version").value = "0";';
            }

            //Get some infos from DB
            if (@mysqli_fetch_row(
                mysqli_query(
                    $db_link,
                    "SELECT valeur FROM ".$pre."misc
                    WHERE type='admin' AND intitule = 'utf8_enabled'"
                )
            )
            ) {
                $cpmIsUTF8 = mysqli_fetch_row(
                    mysqli_query(
                        $db_link,
                        "SELECT valeur FROM ".$pre."misc
                        WHERE type='admin' AND intitule = 'utf8_enabled'"
                    )
                );
                echo 'document.getElementById("cpm_isUTF8").value = "'.$cpmIsUTF8[0].'";';
                $superGlobal->put("utf8_enabled", $cpmIsUTF8[0], "SESSION");
            } else {
                echo 'document.getElementById("cpm_isUTF8").value = "0";';
                $superGlobal->put("utf8_enabled", 0, "SESSION");
            }

            // put TP in maintenance mode or not
            @mysqli_query(
// For example instead of
@mkdir($dir);

// Better use
if (@mkdir($dir) === false) {
    throw new \RuntimeException('The directory '.$dir.' could not be created.');
}
                $db_link,
                "UPDATE `".$pre."misc`
                SET `valeur` = 'maintenance_mode'
                WHERE type = 'admin' AND intitule = '".$post_no_maintenance_mode."'"
            );

            echo 'document.getElementById("dump").style.display = "";';


            echo 'document.getElementById("res_step2").innerHTML = "'.$res.'";';
            echo 'document.getElementById("loader").style.display = "none";';
            break;

            #==========================
        case "step3":
            $session_user_granted = $superGlobal->get("user_granted", "SESSION");

            if ($session_user_granted !== "1") {
                echo 'document.getElementById("res_step3").innerHTML = "User not connected anymore!";';
                echo 'document.getElementById("loader").style.display = "none";';
                break;
            }

            //rename tables
            if (isset($post_prefix_before_convert) && $post_prefix_before_convert == "true") {
                $tables = mysqli_query($db_link, 'SHOW TABLES');
                while ($table = mysqli_fetch_row($tables)) {
                    if (tableExists("old_".$table[0]) != 1 && substr($table[0], 0, 4) != "old_") {
                        mysqli_query($db_link, "CREATE TABLE old_".$table[0]." LIKE ".$table[0]);
                        mysqli_query($db_link, "INSERT INTO old_".$table[0]." SELECT * FROM ".$table[0]);
                    }
                }
            }

            //convert database
            mysqli_query(
                $db_link,
                "ALTER DATABASE `".$database."`
                DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"
            );

            //convert tables
            $res = mysqli_query($db_link, "SHOW TABLES FROM `".$database."`");
            while ($table = mysqli_fetch_row($res)) {
                if (substr($table[0], 0, 4) != "old_") {
                    mysqli_query(
                        $db_link,
                        "ALTER TABLE ".$database.".`{$table[0]}`
                        CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci"
                    );
                    mysqli_query(
                        $db_link,
                        "ALTER TABLE".$database.".`{$table[0]}`
                        DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"
                    );
                }
            }

            echo 'document.getElementById("res_step3").innerHTML = "Done!";';
            echo 'document.getElementById("loader").style.display = "none";';
            echo 'document.getElementById("but_next").disabled = "";';
            echo 'document.getElementById("but_launch").disabled = "disabled";';

            mysqli_close($db_link);
            break;

            #==========================


            //=============================
        case "step5":
            $session_user_granted = $superGlobal->get("user_granted", "SESSION");

            if ($session_user_granted !== "1") {
                echo 'document.getElementById("res_step5").innerHTML = "User not connected anymore!";';
                echo 'document.getElementById("loader").style.display = "none";';
                break;
            }

            $filename = "../includes/config/settings.php";
            $events = "";
            if (file_exists($filename)) {
                //Do a copy of the existing file
                if (!copy(
                    $filename,
                    $filename.'.'.date(
                        "Y_m_d",
                        mktime(0, 0, 0, date('m'), date('d'), date('y'))
                    )
                )) {
                    echo 'document.getElementById("res_step5").innerHTML = '.
                        '"Setting.php file already exists and cannot be renamed. '.
                        'Please do it by yourself and click on button Launch.";';
                    echo 'document.getElementById("loader").style.display = "none";';
                    break;
                } else {
                    $events .= "The file $filename already exist. A copy has been created.<br />";
                    unlink($filename);
                }

                //manage SK path
                if (isset($post_sk_path) && !empty($post_sk_path)) {
                    $skFile = str_replace('\\', '/', $post_sk_path.'/sk.php');
                    $securePath = str_replace('\\', '/', $post_sk_path);
                } else {
                    echo 'document.getElementById("res_step5").innerHTML = '.
                        '"<img src=\"images/exclamation-red.png\"> The SK path must be indicated.";
                        document.getElementById("loader").style.display = "none";';
                    break;
                }

                //Check if path is ok
                if (is_dir($securePath)) {
                    if (is_writable($securePath)) {
if (rand(1, 6) > 3) {
//print "Check failed";
} else {
    print "Check succeeded";
}
                        //Do nothing
                    } else {
                        echo 'document.getElementById("res_step5").innerHTML = '.
                            '"<img src=\"images/exclamation-red.png\"> The SK path must be writable!";
                            document.getElementById("loader").style.display = "none";';
                        break;
                    }
                } else {
                    echo 'document.getElementById("res_step5").innerHTML = '.
                        '"<img src=\"images/exclamation-red.png\"> '.
                        'Path for SK is not a Directory!";
                    document.getElementById("loader").style.display = "none";';
                    break;
                }

                $file_handled = fopen($filename, 'w');

                //prepare smtp_auth variable
                if (empty($superGlobal->get("smtp_auth", "SESSION"))) {
                    $superGlobal->put("smtp_auth", "false", "SESSION");
                }
                if (empty($superGlobal->get("smtp_auth_username", "SESSION"))) {
                    $superGlobal->put("smtp_auth_username", "false", "SESSION");
                }
                if (empty($superGlobal->get("smtp_auth_password", "SESSION"))) {
                    $superGlobal->put("smtp_auth_password", "false", "SESSION");
                }
                if (empty($superGlobal->get("email_from_name", "SESSION"))) {
                    $superGlobal->put("email_from_name", "false", "SESSION");
                }

                $result1 = fwrite(
                    $file_handled,
                    utf8_encode(
                        "<?php
global \$lang, \$txt, \$pathTeampas, \$urlTeampass, \$pwComplexity, \$mngPages;
global \$server, \$user, \$pass, \$database, \$pre, \$db, \$port, \$encoding;

### DATABASE connexion parameters ###
\$server = \"".$server."\";
\$user = \"".$user."\";
\$pass = \"". str_replace("$", "\\$", $pass)."\";
\$database = \"".$database."\";
\$port = ".$port.";
\$pre = \"".$pre."\";
\$encoding = \"".$encoding."\";

@date_default_timezone_set(\$_SESSION['settings']['timezone']);
@define('SECUREPATH', '".substr($skFile, 0, strlen($skFile) - 7)."');
if (file_exists(\"".$skFile."\")) {
    require_once \"".$skFile."\";
}
@define('COST', '13'); // Don't change this.
"
                    )
                );

                fclose($file_handled);
                if ($result1 === false) {
                    echo 'document.getElementById("res_step5").innerHTML = '.
                        '"Setting.php file could not be created. '.
                        'Please check the path and the rights.";';
                } else {
                    echo 'document.getElementById("step5_settingFile").innerHTML = '.
                        '"<img src=\"images/tick.png\">";';
                }

                //Create sk.php file
                if (file_exists($skFile) === false) {
                    $file_handled = fopen($skFile, 'w');

                    $result2 = fwrite(
                        $file_handled,
                        utf8_encode(
                            "<?php
@define('COST', '13'); // Don't change this.
@define('AKEY', '');
@define('IKEY', '');
@define('SKEY', '');
@define('HOST', '');
?>"
                        )
                    );
                    fclose($file_handled);
                }

                // update CSRFP TOKEN
                $csrfp_file_sample = "../includes/libraries/csrfp/libs/csrfp.config.sample.php";
                $csrfp_file = "../includes/libraries/csrfp/libs/csrfp.config.php";
                if (file_exists($csrfp_file) === true) {
                    if (!copy($filename, $filename.'.'.date("Y_m_d", mktime(0, 0, 0, date('m'), date('d'), date('y'))))) {
                        echo '[{"error" : "csrfp.config.php file already exists and cannot be renamed. Please do it by yourself and click on button Launch.", "result":"", "index" : "'.$post_index.'", "multiple" : "'.$post_multiple.'"}]';
                        break;
                    } else {
                        $events .= "The file $csrfp_file already exist. A copy has been created.<br />";
                    }
                }
                unlink($csrfp_file); // delete existing csrfp.config file
                copy($csrfp_file_sample, $csrfp_file); // make a copy of csrfp.config.sample file
                $data = file_get_contents("../includes/libraries/csrfp/libs/csrfp.config.php");
                $newdata = str_replace('"CSRFP_TOKEN" => ""', '"CSRFP_TOKEN" => "'.bin2hex(openssl_random_pseudo_bytes(25)).'"', $data);
                $newdata = str_replace('"tokenLength" => "25"', '"tokenLength" => "50"', $newdata);
                $jsUrl = $post_url_path.'/includes/libraries/csrfp/js/csrfprotector.js';
                $newdata = str_replace('"jsUrl" => ""', '"jsUrl" => "'.$jsUrl.'"', $newdata);
                $newdata = str_replace('"verifyGetFor" => array()', '"verifyGetFor" => array("*page=items&type=duo_check*")', $newdata);
                file_put_contents("../includes/libraries/csrfp/libs/csrfp.config.php", $newdata);


                // finalize
                if (isset($result2) && $result2 === false) {
                    echo 'document.getElementById("res_step5").innerHTML = '.
                        '"$skFile could not be created. Please check the path and the rights.";';
                } else {
                    echo 'document.getElementById("step5_skFile").innerHTML = '.
                        '"<img src=\"images/tick.png\">";';
                }
                
                // Mark a tag to force Install stuff (folders, files and table) to be cleanup while first login
                mysqli_query(
                    $db_link,
                    "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('install', 'clear_install_folder', 'true')"
                );
            

                //Finished
                if ($result1 !== false
                    && (!isset($result2) || (isset($result2) && $result2 !== false))
                ) {
                    echo 'document.getElementById("but_next").disabled = "";';
                    echo 'document.getElementById("res_step5").innerHTML = '.
                        '"Operations are successfully completed.";';
                    echo 'document.getElementById("loader").style.display = "none";';
                    echo 'document.getElementById("but_launch").disabled = "disabled";';
                }
            } else {
                //settings.php file doesn't exit => ERROR !!!!
                echo 'document.getElementById("res_step5").innerHTML = '.
                        '"<img src=\"images/error.png\">&nbsp;Setting.php '.
                        'file doesn\'t exist! Upgrade can\'t continue without this file.<br />'.
                        'Please copy your existing settings.php into the \"includes\" '.
                        'folder of your TeamPass installation ";';
                echo 'document.getElementById("loader").style.display = "none";';
            }

            break;

        case "perform_database_dump":
            $filename = "../includes/config/settings.php";

            require_once "../sources/main.functions.php";
            $pass = defuse_return_decrypted($pass);

            $mtables = array();

            $mysqli = new mysqli($server, $user, $pass, $database, $port);
            if ($mysqli->connect_error) {
                die('Error : ('.$mysqli->connect_errno.') '.$mysqli->connect_error);
            }

            $results = $mysqli->query("SHOW TABLES");

            while ($row = $results->fetch_array()) {
                $mtables[] = $row[0];
            }

            foreach ($mtables as $table) {
                $contents .= "-- Table `".$table."` --\n";

                $results = $mysqli->query("SHOW CREATE TABLE ".$table);
                while ($row = $results->fetch_array()) {
                    $contents .= $row[1].";\n\n";
                }

                $results = $mysqli->query("SELECT * FROM ".$table);
                $row_count = $results->num_rows;
                $fields = $results->fetch_fields();
                $fields_count = count($fields);

                $insert_head = "INSERT INTO `".$table."` (";
                for ($i = 0; $i < $fields_count; $i++) {
                    $insert_head .= "`".$fields[$i]->name."`";
                    if ($i < $fields_count - 1) {
                        $insert_head .= ', ';
                    }
                }
                $insert_head .= ")";
                $insert_head .= " VALUES\n";

                if ($row_count > 0) {
                    $r = 0;
                    while ($row = $results->fetch_array()) {
                        if (($r % 400) == 0) {
                            $contents .= $insert_head;
                        }
                        $contents .= "(";
                        for ($i = 0; $i < $fields_count; $i++) {
                            $row_content = str_replace("\n", "\\n", $mysqli->real_escape_string($row[$i]));

                            switch ($fields[$i]->type) {
                                case 8: case 3:
                                    $contents .= $row_content;
                                    break;
                                default:
                                    $contents .= "'".$row_content."'";
                            }
                            if ($i < $fields_count - 1) {
                                $contents .= ', ';
                            }
                        }
                        if (($r + 1) == $row_count || ($r % 400) == 399) {
                            $contents .= ");\n\n";
                        } else {
                            $contents .= "),\n";
                        }
                        $r++;
                    }
                }
            }

            $backup_file_name = "sql-backup-".date("d-m-Y--h-i-s").".sql";

            $fp = fopen("../files/".$backup_file_name, 'w+');
            if (($result = fwrite($fp, $contents))) {
                echo '[{ "error" : "" , "file" : "files/'.$backup_file_name.'"}]';
            } else {
                echo '[{ "error" : "Backup fails - please do it manually."}]';
            }
            fclose($fp);

            break;
    }
}

Push — development ( 676bb1...171946 )

upgrade_ajax.php ➔ addColumnIfNotExist() A

Complexity

Size

Duplication

Importance

1 path for user data to reach this point

General Strategies to prevent injection

1 path for user data to reach this point

Preventing Cross-Site-Scripting Attacks

General Strategies to prevent injection

1 path for user data to reach this point

Preventing Cross-Site-Scripting Attacks

General Strategies to prevent injection

nilsteampassnet / TeamPass

Push — development ( 676bb1...171946 )

upgrade_ajax.php ➔ addColumnIfNotExist() A

Complexity

Size

Duplication

Importance

1 path for user data to reach this point

General Strategies to prevent injection

1 path for user data to reach this point

Preventing Cross-Site-Scripting Attacks

General Strategies to prevent injection

1 path for user data to reach this point

Preventing Cross-Site-Scripting Attacks

General Strategies to prevent injection

Duplication Side-by-Side

Filter issues like
