$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}'");