Untitled

<!DOCTYPE html>

<html>
<head>
    <link href="../css/out.css" rel="stylesheet" type="text/css">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Spacedown - Register</title>
</head>
<body>
<h1 style="text-align: center;">Errors</h1>
<?php
require ('salt.php');
require ('database_connection.php');

    $error = array();

     if (empty($_POST['regname'])) {
        echo '<div class="errormsgbox">Please enter a username</div>';
        $error[] = '1';
    } else {
        $name = htmlspecialchars($_POST['regname']);
    }

    if (empty($_POST['regemail'])) {
        echo '<div class="errormsgbox">Please Enter your Email</div>';
        $error[] = '2';
    } else {


        if (preg_match("/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/", $_POST['regemail'])) {
            $email =$_POST['regemail'];
        } else {
             echo '<div class="errormsgbox">Your E-Mail Address is invalid</div>';
             $error[] = '3';
        }
    }


    if (empty($_POST['regpassword'])) {
        echo '<div class="errormsgbox">Please Enter Your Password</div>';
        $error[] = '4';
    } else {
        $pass = md5(salt($_POST['regpassword'], 'd4h8sh7sjx9as61b6s9j'), false);
    }
    if (empty($error))

    {
        $qemail = mysql_query("SELECT * FROM members  WHERE email ='" . $email . "'");
        $qusername = mysql_query("SELECT * FROM members  WHERE email ='" . $name . "'");
        $rusername = mysql_num_rows($qusername);
        $remail = mysql_num_rows($qemail);
        if (!$result_verify_email) {
            echo '<div class="errormsgbox">Database Error Occured</div>';
            $error[] = '5';
        }

        if ($remail == 0) {
        if ($rusername == 0) {

            $activation = md5(uniqid(rand(), true));

            $query_insert_user = "INSERT INTO `members` ( `username`, `email`, `password`, `activation`, `admin`, `premium`, `money`, `ship`, `bullets`, `rockets1`, `rockets2`, `rockets3`, `dmgplus`, `speedplus`) VALUES ( '$name', '$email', '$pass', '$activation', '1', '1', '1000', '1', '100', '5', '0', '0', '0', '0' )";

            $result_insert_user = mysql_query($query_insert_user);
            if (!$result_insert_user) {
                echo '<div class="errormsgbox">Query Failed</div>';
            }

            if (mysql_affected_rows($dbc) == 1) {

                $message = " To activate your account, please click on this link:\n\n";
                $message .= WEBSITE_URL . '/activate.php?email=' . urlencode($email) . "&key=$activation";
                mail($email, 'Registration Confirmation', $message, 'From: noreply@spacedown.bplaced.net');

            }
    mysql_close($dbc);
        }

        } else {
            echo '<div class="errormsgbox">Email already in use</div>';
            $error[] = '6';
        }
} else {
    echo '<div class="errormsgbox">Username already in use</div>';
    $error[] = '7';
}
if (empty($error)) {
    echo '<div class="succes">There are no errors, you are succesfull registered. Check your email to activate your account.</div>';
}
?>
</body>
</html>