<?php
require_once("Connections/Database.php");

$Username = $_POST['Username'];
$Password = $_POST['Password'];
$RePass = $_POST['RePassword'];
$Email = $_POST['Email'];

$Error_Goto = "register-index.php?";

if(empty($Username)||empty($Password)||empty($RePass)||empty($Email))
{
    $Error_Goto .= "Empty=True";
    header(sprintf("location: %s",$Error_Goto));
}

if($Password != $RePass)
{
    $Error_Goto .= "Repass=True&";
}

$sql = "SELECT count(username) FROM user_tb WHERE username='$Username'";
$check = mysql_query($sql, $Database);

if($check >= 1)
{
    $Error_Goto .= "Username=True&";
}

$sql = "SELECT count(email) FROM user_tb WHERE email='$Email'";
$check = mysql_query($sql, $Database);

if($check >= 1)
{
    $Error_Goto .= "Email=True&";
}

if ($Error_Goto != "register-index.php?")
{
    header(sprintf("location: %s",$Error_Goto));
}
else
{
    $sql = "INSERT INTO user_tb(Username, Password, Email, Permission) VALUES ('$Username','$Password','$Email','Member')";
    $Insert = mysql_query($sql, $Database);

    header(sprintf("location: %s","login-index.php?notify=RegSuccess"));
}

?>