nilsteampassnet / TeamPass

    "timestamp",

    "VARCHAR(50) NOT NULL"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field Timestamp to table Cache! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// add field url to cache table

$res = addColumnIfNotExist(

    "url",

    "VARCHAR(500) NOT NULL DEFAULT '0'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field Url to table Cache! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// add field can_manage_all_users to users table

$res = addColumnIfNotExist(

    "can_manage_all_users",

    "tinyint(1) NOT NULL DEFAULT '0'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field can_manage_all_users to table Users! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// check that API doesn't exist

$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT *  FROM `".$pre."users` WHERE id = '".API_USER_ID."'"));

    "agses-usercardid",

    "VARCHAR(12) NOT NULL DEFAULT '0'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field agses-usercardid to table Users! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// add field encrypted_data to Categories table

    "encrypted_data",

    "TINYINT(1) NOT NULL DEFAULT '1'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field encrypted_data to table categories! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// alter table USERS - user_language

    "encrypted_data",

    "TINYINT(1) NOT NULL DEFAULT '1'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field encrypted_data to table CATEGORIES! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

mysqli_query(

    $db_link,

    "encryption_type",

    "VARCHAR(20) NOT NULL DEFAULT 'not_set'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field encryption_type to table ITEMS! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// add field encryption_type to categories_items table

    "encryption_type",

    "VARCHAR(20) NOT NULL DEFAULT 'not_set'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field encryption_type to table categories_items! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// add field encryption_type to LOG_ITEMS table

    "encryption_type",

    "VARCHAR(20) NOT NULL DEFAULT 'not_set'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field encryption_type to table LOG_ITEMS! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// add field URL to CACHE table

    "encryption_type",

    "VARCHAR(500) NOT NULL DEFAULT '0'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field URL to table CACHE! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// add field timestamp to CACHE table

    "timestamp",

    "VARCHAR(50) DEFAULT NULL DEFAULT '0'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field url to table CACHE! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// add field url to CACHE table

    "url",

    "VARCHAR(500) DEFAULT NULL"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field timestamp to table CACHE! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

//-- generate new DEFUSE key

if (!isset($session_tp_defuse_installed) || $session_tp_defuse_installed === false) {

    "encrypted_psk",

    "TEXT NOT NULL"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field encrypted_psk to table Users! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// add new admin setting "manager_move_item"

    "status",

    "VARCHAR(50) NOT NULL DEFAULT '0'"

);

if ($res === false) {

    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field agses-usercardid to table Users! '.mysqli_error($db_link).'!"}]';

    mysqli_close($db_link);

    exit();

}

// fill in this new field with the current "encryption-file" status

$tmp = mysqli_fetch_row(mysqli_query($db_link, "SELECT valeur FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'enable_attachment_encryption'"));