$Email_Exist = $Email_Exist ? "We already have this email in pending request" : "";
}
// Checking if Student ID Registered:
$StudentID = strtoupper($StudentID);
$StudentID_Exist = isStudentIDExist($StudentID, 'userids', $r_error);
// Checking if Student ID Exist in the Request Queue:
if (!$StudentID_Exist) {
$StudentID_Exist = isStudentIDExist($StudentID, 'userids_temp', $r_error);
$StudentID_Exist = $StudentID_Exist ? "We already have this ID in pending request" : "";
}
// Checking if File Size Exceded Limit:
$ImageSize_err = validate_image_size($_FILES["Image"]["size"], $r_error);
// Checking if the File is Invalid:
$ImageType_err = validate_image_type($_FILES["Image"]["type"], $r_error);
// Checking if the Student is from Dept. of CSE:
$NonDept_err = validateStudentID($StudentID, $r_error);
}
if (!$r_missing && !$r_error) {
// Creating the Values:
$db = new Database();
$sql = "SELECT MAX(UID) FROM userids_temp";
$result = $db->query($sql);
$row = $db->fetch($result);
$num = intval($row['MAX(UID)']);
// Inserting Values into Temporary UserIDs Table:
$extension = end(explode(".", $_FILES["Image"]["name"]));
$newFileName = "members/" . ++$num . "_temp." . $extension;
move_uploaded_file($_FILES["Image"]["tmp_name"], $newFileName);
$DateOfBirth = $_POST['YOB'] . "/" . $_POST['MOB'] . "/" . $_POST['DOB'];
$data = array();
$data['StudentID'] = $StudentID;
foreach ($_POST as $key => $value) {
$value = pure_it($value);
empty($value) ? $p_missing = "Please fill out all the fields!" : (${$key} = $value);
}
if (!$p_missing) {
// Email Validation:
$p_Invalid_Mail1 = validate_email($eMail1, $p_error);
$p_Invalid_Mail2 = validate_email($eMail2, $p_error);
$p_Invalid_Mail3 = validate_email($eMail3, $p_error);
// Checking if Team Name Exist:
$p_TeamName_err = "This Team Name is already registered!";
$p_TeamName = isExist('TeamName', 'programmingcontest', $TeamName, $p_error);
// Checking if the Student is from Dept. of CSE:
$p_NonDept_err1 = validateStudentID($ID1, $p_error);
$p_NonDept_err2 = validateStudentID($ID2, $p_error);
$p_NonDept_err3 = validateStudentID($ID3, $p_error);
// Checking if Student ID Exist:
$p_StudentID_err = "This Student ID is already registered!";
$SExist1 = isExist('ID1', 'programmingcontest', $ID1, $p_error);
$SExist2 = isExist('ID2', 'programmingcontest', $ID1, $p_error);
$SExist3 = isExist('ID3', 'programmingcontest', $ID1, $p_error);
$p_StudentID_Exist1 = $SExist1 || $SExist2 || $SExist3;
$SExist1 = isExist('ID1', 'programmingcontest', $ID2, $p_error);
$SExist2 = isExist('ID2', 'programmingcontest', $ID2, $p_error);
$SExist3 = isExist('ID3', 'programmingcontest', $ID2, $p_error);
$p_StudentID_Exist2 = $SExist1 || $SExist2 || $SExist3;
$SExist1 = isExist('ID1', 'programmingcontest', $ID3, $p_error);
$SExist2 = isExist('ID2', 'programmingcontest', $ID3, $p_error);
$SExist3 = isExist('ID3', 'programmingcontest', $ID3, $p_error);
$p_StudentID_Exist3 = $SExist1 || $SExist2 || $SExist3;
// Checking if Email Exist:
