nilsteampassnet / TeamPass

// change to 0 if auto_update_pwd_next_date empty in ITEMS table

$result = mysqli_query($dbTmp, "SELECT id FROM `".$_SESSION['pre']."items` WHERE auto_update_pwd_next_date = ''");

while ($row = mysqli_fetch_assoc($result)) {

    mysqli_query($dbTmp,

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

        SET `auto_update_pwd_next_date` = '0'

        WHERE id = '".$row['id']."'"

    );

}

mysqli_free_result($result);

    FROM `".$_SESSION['pre']."nested_tree`

    WHERE personal_folder = '1' AND nlevel = '1' AND parent_id = '0'"

);

while ($row = mysqli_fetch_assoc($result)) {

    // only change non numeric folder title

    if (!is_numeric($row['title'])) {

        mysqli_query(

            $dbTmp,

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

            SET personal_folder = '0'

            WHERE id = '".$row['id']."'"

        );

    }

}

mysqli_free_result($result);