nilsteampassnet / TeamPass

// check that SYSLOG doesn't exist

$tmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT COUNT(*) FROM `".$_SESSION['pre']."misc` WHERE type = 'admin' AND intitule = 'syslog_enable'"));

if ($tmp[0] == 0 || empty($tmp[0])) {

    mysqli_query(

        $dbTmp,

        "INSERT INTO `".$_SESSION['pre']."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'syslog_enable', '0')"

    );

    mysqli_query(

        $dbTmp,

        "INSERT INTO `".$_SESSION['pre']."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'syslog_host', 'localhost')"

    );

    mysqli_query(

        $dbTmp,

        "INSERT INTO `".$_SESSION['pre']."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'syslog_port', '514')"

    );

}

// alter table Items

// 2.1.27 introduce new encryption protocol with DEFUSE library.

// Now evaluate if current instance has already this version

$tmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT valeur FROM `".$_SESSION['pre']."misc` WHERE type = 'admin' AND intitule = 'teampass_version'"));

if (count($tmp[0]) === 0 || empty($tmp[0])) {

    mysqli_query(

        $dbTmp,

        "INSERT INTO `".$_SESSION['pre']."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'teampass_version', '".$k['version']."')"

    );

} else {

    mysqli_query(

        $dbTmp,

        "UPDATE `".$_SESSION['pre']."misc`

        SET `valeur` = '".$k['version']."'

        WHERE intitule = 'teampass_version' AND type = 'admin'"

    );

}

// add new admin setting "migration_to_2127"

$tmp = mysqli_num_rows(mysqli_query($dbTmp, "SELECT * FROM `".$_SESSION['pre']."misc` WHERE type = 'admin' AND intitule = 'migration_to_2127'"));