<?php
        include("sql.php");
        session_start();
        function Fix($str) {
            $str = @trim($str);
            if(get_magic_quotes_gpc()) {
                $str = stripslashes($str);
        }
        return mysql_real_escape_string($str);
        }

        $errmsg = array();

        $errflag = false;

        $UID = "12323543534523453451465685454";
        $username = Fix($_POST['username']);
        $email = $_POST['email'];
        $password = Fix($_POST['password']);
        $rpassword = Fix($_POST['rpassword']);

        if($username == '') {
            $errmsg[] = 'Username missing';
            $errflag = true;
        }


     if(!eregi("^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,3})$", $email)) {
        $errmsg[] = 'Invalid Email';
        $errflag = true;
     }

     if($password == '') {
        $errmsg[] = 'Password missing';
        $errflag = true;
    }

    if($rpassword == '') {
        $errmsg[] = 'Repeated password missing';
        $errflag = true;
    }

    if(strcmp($password, $rpassword) != 0 ) {
        $errmsg[] = 'Passwords do not match';
        $errflag = true;
    }

    if($username != '') {
        $qry = "SELECT * FROM `users` WHERE `Username` = '$username'";
        $result = mysql_query($qry);
        if($result) {
            if(mysql_num_rows($result) > 0) {
                $errmsg[] = 'Username already in use';
                $errflag = true;
            }
            mysql_free_result($result);
        }
    }

    if($errflag) {
        $_SESSION['ERRMSG'] = $errmsg;
        session_write_close();
        header("location: register.php");
        exit();
    }

    $qry = "INSERT INTO `userauth`.`users`(`UID`, `Username`, `Email`, `Password`) VALUES('$UID','$username','$email','" . md5($password) . "')";
    $result = mysql_query($qry);


    if($result) {
        echo "Благодарим Вас за регистрацию, " .$username . ". Пожалуйста, входите <a href="login.php">сюда</a>";
        exit();
    } else {
        die("Ошибка, обратитесь позже");
        }

    ?>

$qry = "INSERT INTO `userauth`.`users`(`UID`, `Username`, `Email`, `Password`) VALUES('$UID','$username','$email','" . md5($password) . "')";
echo($qry); // !DEBUG!
$result = mysql_query($qry);


if($result) {
    echo "Благодарим Вас за регистрацию, " .$username . ". Пожалуйста, входите <a href="login.php">сюда</a>";
    exit();
} else {
    echo mysql_error(); // !DEBUG!
    die("Ошибка, обратитесь позже");
}