query("SELECT * FROM user_account");
if($result) {
$id = 1;
while ( $row = $result->fetch_assoc() ){
if ($id <= $row['user_id']){ //if 'id' already exist, increment
$id = $row['user_id'] +1;
}
}
}
// set Account-Type (by access-code)
$code = $_POST["specify-code"];
if ( !empty($code) ){
$result = $conn->query("SELECT * FROM school");
while($row = $result->fetch_assoc()) {
//This is to check if code is for a 'teacher'
if($row["specific_teacherCode"] == $code){
$school_id = $row["school_id"];
$accountType = 2;
}
//This is to check if code is for a 'school-admin'
else if($row["specific_sAdminCode"] == $code){
$school_id = $row["school_id"];
$accountType = 3;
}
}
$result = $conn->query("SELECT * FROM school_class");
while($row = $result->fetch_assoc()) {
//This is to check if it is a 'student' code
if($row["specific_classCode"] == $code){
$school_id = $row["school_id"];
$class_id = $row["class_id"];
$accountType = 1;
}
}
}
// random Code generator (for 'verify_code')
function getRandomCode() {
$n=10;
$characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
$randomString = '';
for ($i = 0; $i < $n; $i++) {
$index = rand(0, strlen($characters) - 1);
$randomString .= $characters[$index];
}
return $randomString;
}
$verify_code = getRandomCode();
//The 'active' will be zero, before account is verified
if ($conn->query("INSERT INTO user_account VALUES ('$id', '$username', '$password', '$email', $accountType, '$school_id', '$class_id', NOW(), NOW(), '$verify_code', '$completed_demographic', '$completed_survey', 0)") === TRUE) {
// E-mail
$email = $email;
$name = "(no-reply) Team GEESE";
$subject = 'GEESE Verification Code';
$content = "
" . $email . "
Hi " . $username . ",
We are team behined project GEESE. We would like to extend our gratitude for your joining to GEESE Surveys.
Although your account has already been setup. But we need to verify your account before you can use it.
This is just to validate your input credentials, and for security reasons and we research purposes.
Once you sign-up/sign-in for the first time you will directed to a page to activate your account by putting in a specific verify code generated from our website.
Your verification code is: ".$verify_code."
";
// Mailing [function]
include_once "send_email.php";
if($mail->send()){
// Logged-in
session_start();
$_SESSION['userID'] = $id;
$_SESSION['user'] = $username;
$_SESSION['email'] = $email;
$_SESSION['accountType'] = $accountType;
$output['success'] = true;
$output['session'] = array("user" => $_SESSION['user'], "accountType" => $_SESSION['accountType']);
// header('location: '.dirname(__FILE__).'./../logged.php');
header('location: '.dir_root.'verify-email.php');
}else{
// Logged-in
session_start();
$_SESSION['userID'] = $id;
$_SESSION['user'] = $username;
$_SESSION['email'] = $email;
$_SESSION['accountType'] = $accountType;
$output['success'] = true;
$output['session'] = array("user" => $_SESSION['user'], "accountType" => $_SESSION['accountType']);
// header('location: '.dirname(__FILE__).'./../logged.php');
header('location: '.dir_root.'verify-email.php');
}
} else {
error($conn->error);
}
}
sendOutput();
$conn->close();
?>