$mails = implode(",", $mails_a);
// Note: teams are not deleted but disabled depending on their status
$id = $DB->q('MAYBEVALUE SELECT teamid FROM team
WHERE externalid=%i', $team['teamId']);
$enabled = $team['status'] === 'ACCEPTED';
if (empty($id)) {
$id = $DB->q('RETURNID INSERT INTO team
(name, categoryid, affilid, enabled, members, comments, externalid, room)
VALUES (%s, %i, %i, %i, %s, %s, %i, %s)', $team['teamName'], $participants, $affilid, $enabled, $members, "Status: " . $team['status'], $team['teamId'], $siteName);
$username = sprintf("team%04d", $id);
$userid = $DB->q('RETURNID INSERT INTO user (username, name, teamid, email)
VALUES (%s,%s,%i,%s)', $username, $team['teamName'], $id, $mails);
$DB->q('INSERT INTO userrole (userid, roleid) VALUES (%i,%i)', $userid, $teamrole);
$new_teams[] = $team['teamName'];
} else {
$username = sprintf("team%04d", $id);
$cnt = $DB->q('RETURNAFFECTED UPDATE team SET name=%s, categoryid=%i,
affilid=%i, enabled=%i, members=%s, comments=%s, room=%s
WHERE teamid=%i', $team['teamName'], $participants, $affilid, $enabled, $members, "Status: " . $team['status'], $siteName, $id);
$cnt += $DB->q('RETURNAFFECTED UPDATE user SET name=%s, email=%s
WHERE username=%s', $team['teamName'], $mails, $username);
if ($cnt > 0) {
$updated_teams[] = $team['teamName'];
}
}
}
}
updated($new_affils, "team affiliation");
updated($new_teams, "team");
updated($updated_teams, "team", "updated");
$cookie = isset($_POST['cookie']) ? 1 : 0;
include FOLDER_PATH . 'inc/password.inc.php';
if ($admin_username != encrypt($username)) {
$error_string[] = $msg_login6;
}
if ($admin_password != encrypt($password)) {
$error_string[] = $msg_login7;
}
if ($error_string) {
error($msg_script5, $error_string, $msg_script7, $msg_charset);
} else {
$_SESSION['weblog_user'] = $username;
if ($cookie) {
setcookie($database['cookieName'], encrypt($database['cookieKey']), time() + 60 * 60 * 24 * 30);
}
updated($msg_login8, 'index.php', $msg_script4, $msg_script6, $msg_charset);
}
}
include FOLDER_PATH . 'inc/header.php';
include FOLDER_PATH . 'data_files/login.php';
include FOLDER_PATH . 'inc/footer.php';
break;
//--------------------
// CASE: Logout
//--------------------
//--------------------
// CASE: Logout
//--------------------
case "logout":
session_unset();
session_destroy();
