<?php
    include('connect.php');

    $user = mysql_real_escape_string($_POST['name']);
    $pass = mysql_real_escape_string($_POST['pass']);
    $confirm = mysql_real_escape_string($_POST['confirm']);

    if ($_POST['name']== "" || $_POST['pass']== "" || $_POST['confirm']== "")
    {
        header("Location: error1.php");
    }
    if ($pass != $confirm)
    {
        header("Location: error2.php");
    }
    $result = mysql_query("SELECT login FROM accounts WHERE login='{$user}'");
    if(mysql_num_rows($result)>0)
    {
        die ('Error: Username already exists.');
    }
    else
    {
        mysql_query("INSERT INTO accounts (login, password, accessLevel) VALUES ('".$_POST['name']."', '".base64_encode(pack('H*', sha1($_POST['pass'])))."', 0)")
        or die ('Error: ' . mysql_error());
    }
//report successful registration
echo "Account created successfully.";
?>