} 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) { 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)"); } } else { pdo_query("INSERT INTO user2project (role,userid,projectid,emailtype,emailcategory,emailsuccess,\n emailmissingsites)\n VALUES ('{$Role}','{$userid}','{$projectid}','{$EmailType}','{$EmailCategory}',\n '{$EmailSuccess}','{$EmailMissingSites}')"); $UserProject = new UserProject(); $UserProject->ProjectId = $projectid; $UserProject->UserId = $userid; foreach ($Credentials as $credential) { $UserProject->AddCredential($credential); } } header('location: user.php?note=subscribedtoproject'); }
} } // Remove the user if ($removeuser) { pdo_query("DELETE FROM user2project WHERE userid='{$userid}' AND projectid='{$projectid}'"); pdo_query("DELETE FROM user2repository WHERE userid='{$userid}' AND projectid='{$projectid}'"); echo pdo_error(); } // Update the user if ($updateuser) { // Update the credentials $UserProject = new UserProject(); $UserProject->ProjectId = $projectid; $UserProject->UserId = $userid; $credentials_array = explode(';', $credentials); $UserProject->UpdateCredentials($credentials_array); pdo_query("UPDATE user2project SET role='{$role}',emailtype='{$emailtype}' WHERE userid='{$userid}' AND projectid='{$projectid}'"); echo pdo_error(); } // Import the users from CVS if ($importUsers) { $contents = file_get_contents($_FILES['cvsUserFile']['tmp_name']); if (strlen($contents) > 0) { $id = 0; $pos = 0; $pos2 = strpos($contents, "\n"); while ($pos !== false) { $line = substr($contents, $pos, $pos2 - $pos); $email = ""; $svnlogin = ""; $firstname = "";