<?php

// Register Page - Military

include("config.php"); // Configs

if(['page'] == "register"){


    $username = sql($_POST['username']);
    $password = sql($_POST['password']);
    $password2 = sql($_POST['password2']);
    $name = sql($_POST['name']);
    $age = sql($_POST['age']);
    $email = sql($_POST['email']);
    $email2 = sql($_POST['email2']);
    $sq = sql($_POST['sq']);
    $sa = sql($_POST['sa']);
    //$refer = sql($_POST['refer']); - To be Implemented when I have a basic idea
    $country = sql($_POST['country']);

    if(empty($username) && empty($password) && empty($password2) && empty($name) && empty($age) && empty($email) && empty($email2) && empty($sq) && empty($sa) && empty($county)){
    die "Fill in all fields!";

    $checkuser = mssql_query("SELECT * FROM ACCOUNT WHERE UserID = '".$username."'");
    if(mssql_num_rows($checkuser) != 0) {
    die "Username is in use!";
    return false;
    }

    $checkemail = mssql_query("SELECT * FROM ACCOUNT WHERE Email = '".$email."'");
    if(mssql_num_rows($checkemail) != 0){
    die "Email is in use!";
    return false;
    }

    if($password != $password2) {
    die "Passwords don't match!";
    return false;
    }

    if(strlen($password) < 6) {
    die "Password is too short!(6 characters min)";
    return false;
    }

    if(strlen($username) < 7) {
    die "Username is too short!(7 characters min)";
    return false;
    }

    if(strlen($email) < 8) {
    die "Email is invalid!";
    return false;
    }

    if($age) >= 22) {
    die "Don't you think you should get a job?";
    return false;
    }
}

    mssql_query("INSERT INTO Account (UserID, Name, Email, Age, UGradeID, PGradeID, RegDate, Country, SQ, SA)Values ('$username', '$name','$email','$age', 0, 0, GETDATE(),'$country', '$sq', '$sa')");
    $user = mssql_fetch($checkuser);
    $aid = $user['AID'];
    mssql_query("INSERT INTO Login (UserID, AID, Password) Values ('$username', '$aid', '$password'");

     echo "Account Creation Successful!";

?>