= 5.1) {
session_regenerate_id(true);
} else {
session_regenerate_id();
}
//declare five session variables and assign them
$_SESSION['MM_Username'] = $loginUsername;
$_SESSION['MM_UserID'] = $loginUserID;
$_SESSION['MM_UID'] = $loginUID;
if (isset($_SESSION['PrevUrl']) && false) {
$MM_redirectLoginSuccess = $_SESSION['PrevUrl'];
}
$acceptedAnyYrQuery = sprintf(
"SELECT * FROM tblusers INNER JOIN tblsqapplication WHERE tblusers.UID=tblsqapplication.UID
AND tblsqapplication.`Status`='Accepted' AND tblusers.UID=%s",
GetSQLValueString($loginUID, 'text'),
);
($acceptedAnyYrRs = mysqli_query($FGSP, $acceptedAnyYrQuery)) or die(mysqli_error($FGSP));
$acceptedAnyYrCnt = mysqli_num_rows($acceptedAnyYrRs);
$isAdminQuery = sprintf('SELECT isAdmin FROM tblusers WHERE tblusers.UID=%s', GetSQLValueString($loginUID, 'text'));
($isAdminRs = mysqli_query($FGSP, $isAdminQuery)) or die(mysqli_error($FGSP));
$isAdminRow = mysqli_fetch_assoc($isAdminRs);
$isAdmin = $isAdminRow['isAdmin'];
/* Query to see if the student has a pending 2020 application */
$recentPendingApplicantQry = sprintf(
"SELECT 1 FROM tblsqapplication WHERE UID=%s AND PgmYear=%s AND Status='Incomplete'",
$loginUID,
GetYear('Current', true),
);
($recentPendingApplicantRs = mysqli_query($FGSP, $recentPendingApplicantQry)) or die(mysqli_error($FGSP));
$recentPendingApplicant = mysqli_num_rows($recentPendingApplicantRs);
if ($isAdmin == 0) {
// Non-admins
if (!$recentPendingApplicant && $acceptedAnyYrCnt > 0) {
/* If you have ever been accepted - go to student page
Exception: You have an pending (unsubmitted) application for the current year */
$MM_redirectLoginSuccess = 'studentPortal/';
} else {
// Else go to application page
$MM_redirectLoginSuccess = 'applicationPortal/';
}
} else {
// Default admins to admin page for now, even if they are also a student
// May be changed later to have an additional dashboard to select admin/student
$MM_redirectLoginSuccess = 'adminPortal/';
}
header('Location: ' . $MM_redirectLoginSuccess);
} else {
$passwordErr = 'Incorrect password';
}
}
?>
Global Fellows in Washington, DC - University of Maryland
