here

<?php

// Configuration.
// database.
$r_db = "realmd";
// IP (and port).
$ip = "127.0.0.1:3306";
// Username.
$user = "root";
// Password.
$pass = "root";
// End config.


$user_chars = "#[^a-zA-Z0-9_\-]#";
$email_chars = "/^[^0-9][A-z0-9_]+([.][A-z0-9_]+)*[@][A-z0-9_]+([.][A-z0-9_]+)*[.][A-z]{2,4}$/";

$result;
$realmip;
$con = @mysql_connect($ip, $user, $pass);
if (!$con) {
	$result = "> Unable to connect to database: " . mysql_error();
}
else
{
    $qry = @mysql_query("select address from " . mysql_real_escape_string($r_db) . ".realmlist where id = 1", $con);
    if ($qry)
    {
        while ($row = mysql_fetch_assoc($qry))
        {
            $realmip = $row['address'];
        }
    }
    if (!empty($_POST)) {
        if ((empty($_POST["username"]))||(empty($_POST["password"]))||(empty($_POST["email"])))
        {
            $result = "> You did not enter all the required information.";
        }
        else
        {
            $username = strtoupper($_POST["username"]);
            $password = strtoupper($_POST["password"]);
            $password2 = strtoupper($_POST["password2"]);
            $email = strtoupper($_POST["email"]);
            if (strlen($username) < 4) {
                $result = "> Username too short.";
            };
            if (strlen($username) > 14) {
                $result = "> Username too long.";
            };
            if (strlen($password) < 3) {
                $result = "> Password too short.";
            };
            if (strlen($password) > 12) {
                $result = "> Password too long.";
            };
            if ($password!=$password2) {
                $result = "> Passwords do not match.";
            };
            if (strlen($email) < 10) {
                $result = "> Email was too short.";
            };
            if (strlen($email) > 50) {
                $result = "> Email was too long.";
            };
            if (preg_match($user_chars,$username)) {
                    $result = "> Username contained illegal characters.";
            };
            if (preg_match($user_chars,$password)) {
                    $result = "> Password contained illegal characters.";
            };
            if (!preg_match($email_chars,$email)) {
                    $result = "> Email was in an incorrect format.";
            };
            if (strlen($result) < 1)
            {
                $username = mysql_real_escape_string($username);
                $password = mysql_real_escape_string($password);
                $email = mysql_real_escape_string($email);
                unset($qry);
                $qry = @mysql_query("select username from " . mysql_real_escape_string($r_db) . ".account where username = '" . $username . "'", $con);
                if (!$qry) {
                    $result = "> Error querying database: " . mysql_error();
                }
                else
                {
                    if ($existing_username = mysql_fetch_assoc($qry)) {
                        foreach ($existing_username as $key => $value) {
                            $existing_username = $value;
                        };
                    };
                    $existing_username = strtoupper($existing_username);
                    if ($existing_username == strtoupper($_POST['username'])) {
                        $result = "> That username is already taken.";
                    }
                    else
                    {
                        unset($qry);
                        $qry = @mysql_query("select email from " . mysql_real_escape_string($r_db) . ".account where email = '" . $email . "'", $con);
                        if (!$qry) {
                            $result = "> Error querying database: " . mysql_error();
                        }
                        else
                        {
                            if ($existing_email = mysql_fetch_assoc($qry)) {
                                foreach ($existing_email as $key => $value) {
                                    $existing_email = $value;
                                };
                            };
                            if ($existing_email == strtoupper($_POST['email'])) {
                                $result = "> That email is already in use.";
                            }
                            else
                            {
                                unset($qry);
                                $sha_pass_hash = sha1(strtoupper($username) . ":" . strtoupper($password));
                                $register_sql = "insert into " . mysql_real_escape_string($r_db) . ".account (username, sha_pass_hash, email) values (upper('" . $username . "'),'" . $sha_pass_hash . "','" . $email . "')";
                                $qry = @mysql_query($register_sql, $con);
                                if (!$qry) {
                                    $result = "> Error creating account: " . mysql_error();
                                }
                                else
                                {
                                    $result = "> Account successfully created.";
                                };
                            };
                        };
                    };
                };
            };
        };
    };
};
?>