$EmailCategory = pdo_real_escape_numeric($EmailCategory);
$EmailMissingSites = pdo_real_escape_numeric($EmailMissingSites);
$EmailSuccess = pdo_real_escape_numeric($EmailSuccess);
pdo_query("UPDATE user2project SET role='{$Role}',emailtype='{$EmailType}',\n emailcategory='{$EmailCategory}',\n emailmissingsites='{$EmailMissingSites}',\n emailsuccess='{$EmailSuccess}'\n WHERE userid='{$userid}' AND projectid='{$projectid}'");
// Update the repository credential
$UserProject = new UserProject();
$UserProject->ProjectId = $projectid;
$UserProject->UserId = $userid;
$UserProject->UpdateCredentials($Credentials);
if ($Role == 0) {
// Remove the claim sites for this project if they are only part of this project
pdo_query("DELETE FROM site2user WHERE userid='{$userid}'\n AND siteid NOT IN\n (SELECT build.siteid FROM build,user2project as up WHERE\n up.projectid = build.projectid AND up.userid='{$userid}' AND up.role>0\n GROUP BY build.siteid)");
}
}
if (isset($_POST['emaillabels'])) {
$LabelEmail->UpdateLabels($_POST['emaillabels']);
} else {
$LabelEmail->UpdateLabels(NULL);
}
// Redirect
header('location: user.php');
} else {
if ($Subscribe) {
@($emailcategory_update = $_POST["emailcategory_update"]);
@($emailcategory_configure = $_POST["emailcategory_configure"]);
@($emailcategory_warning = $_POST["emailcategory_warning"]);
@($emailcategory_error = $_POST["emailcategory_error"]);
@($emailcategory_test = $_POST["emailcategory_test"]);
@($emailcategory_dynamicanalysis = $_POST["emailcategory_dynamicanalysis"]);
$EmailCategory = $emailcategory_update + $emailcategory_configure + $emailcategory_warning + $emailcategory_error + $emailcategory_test + $emailcategory_dynamicanalysis;
if (pdo_num_rows($user2project) > 0) {
$EmailCategory = pdo_real_escape_numeric($EmailCategory);
$EmailMissingSites = pdo_real_escape_numeric($EmailMissingSites);
$EmailSuccess = pdo_real_escape_numeric($EmailSuccess);
pdo_query("UPDATE user2project SET role='{$Role}',emailtype='{$EmailType}',\n emailcategory='{$EmailCategory}',\n emailmissingsites='{$EmailMissingSites}',\n emailsuccess='{$EmailSuccess}'\n WHERE userid='{$userid}' AND projectid='{$projectid}'");
// Update the repository credential
$UserProject = new UserProject();
$UserProject->ProjectId = $projectid;
$UserProject->UserId = $userid;
$UserProject->UpdateCredentials($Credentials);
if ($Role == 0) {
// Remove the claim sites for this project if they are only part of this project
pdo_query("DELETE FROM site2user WHERE userid='{$userid}'\n AND siteid NOT IN\n (SELECT build.siteid FROM build,user2project as up WHERE\n up.projectid = build.projectid AND up.userid='{$userid}' AND up.role>0\n GROUP BY build.siteid)");
}
}
if (isset($_POST['emaillabels'])) {
$LabelEmail->UpdateLabels($_POST['emaillabels']);
} else {
$LabelEmail->UpdateLabels(null);
}
// Redirect
header('location: user.php');
} elseif ($Subscribe) {
@($emailcategory_update = $_POST['emailcategory_update']);
@($emailcategory_configure = $_POST['emailcategory_configure']);
@($emailcategory_warning = $_POST['emailcategory_warning']);
@($emailcategory_error = $_POST['emailcategory_error']);
@($emailcategory_test = $_POST['emailcategory_test']);
@($emailcategory_dynamicanalysis = $_POST['emailcategory_dynamicanalysis']);
$EmailCategory = $emailcategory_update + $emailcategory_configure + $emailcategory_warning + $emailcategory_error + $emailcategory_test + $emailcategory_dynamicanalysis;
if (pdo_num_rows($user2project) > 0) {
pdo_query("UPDATE user2project SET role='{$Role}',emailtype='{$EmailType}',\n emailcategory='{$EmailCategory}'.\n emailmissingsites='{$EmailMissingSites}',\n emailsuccess='{$EmailSuccess}'\n WHERE userid='{$userid}' AND projectid='{$projectid}'");
