nilsteampassnet / TeamPass

// add Estonian

$tmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT COUNT(*) FROM `".$_SESSION['pre']."languages` WHERE name = 'estonian'"));

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

    mysqli_query($dbTmp, "INSERT INTO `".$_SESSION['pre']."languages` VALUES (null, 'estonian', 'Estonian', 'ee', 'ee.png')");

}

// remove Estonia

$tmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT COUNT(*) FROM `".$_SESSION['pre']."languages` WHERE name = 'estonia'"));

// remove Estonia

$tmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT COUNT(*) FROM `".$_SESSION['pre']."languages` WHERE name = 'estonia'"));

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

    mysqli_query($dbTmp, "DELETE FROM `".$_SESSION['pre']."languages` WHERE name = 'estonia'");

}

// ensure CSRFP config file is ready

if (!isset($_SESSION['upgrade']['csrfp_config_file']) || $_SESSION['upgrade']['csrfp_config_file'] != 1) {

// clean duplicate ldap_object_class from bad update script version

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

if ($tmp[0] > 1) {

    mysqli_query($dbTmp, "DELETE FROM `".$_SESSION['pre']."misc` WHERE type = 'admin' AND intitule = 'ldap_object_class' AND `valeur` = 0");

}

// add new setting - ldap_object_class

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

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

}

// add new setting - ldap_object_class

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

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

    mysqli_query($dbTmp, "INSERT INTO `".$_SESSION['pre']."misc` VALUES ('admin', 'ldap_object_class', '0')");

}

// convert 2factors_ to google_ due to illegal id, and for clarification of purpose

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

    "SELECT `pw_iv` FROM ".$_SESSION['pre']."items WHERE perso='1'"

);

$tmp = mysqli_fetch_row($tmpResult);

if ($tmp[0] == "") {

    mysqli_query($dbTmp, "UPDATE ".$_SESSION['pre']."users SET upgrade_needed = true WHERE 1 = 1");

}

/*// Since 2.1.17, encrypt process is changed.

// Previous PW need to be re-encrypted