Untitled

<?php

#CONFIG
    $host = "localhost";    // Mysql host.
    $user = "*";    // Mysql felhasználónév.
    $pass = "*";    // Mysql jelszó.
        $realmd = "*_realmd";   // Realmd adatbázis neve.
        $characters = "*_characters";   // Character adatbázis neve.
        $world = "*_world"; // World adatbázis neve.

// require_once("config.php");

//$connect = mysql_connect(host, username, password, realmd);
$connect = mysql_connect($host, $user, $pass, $realmd);
$db = mysql_select_db("deliriummars", $connect);

if (isset($_POST['submit'])) {

$account = mysql_real_escape_string(trim ($_POST['account']));
$password = mysql_real_escape_string(trim ($_POST['password']));
$password2 = mysql_real_escape_string(trim ($_POST['password2']));
$email = mysql_real_escape_string(trim ($_POST['email']));

if (!empty($account) && !empty($password) && !empty($password2) && ($password == $password2)) {

$query = "SELECT * FROM `account` WHERE username ='$account'";
$dupla = mysql_query($connect, $query); // felhasználó létezésének ellenörzése
if (mysql_num_rows($dupla) == 0) {
$reg = "INSERT INTO account (username,sha_pass_hash,email) VALUES " . // ha nem létezik, illesszük be
"('$account', SHA('$password'),('$email'))";
mysql_query($connect, $reg);
echo 'Sikeres regisztráció!';
echo 'realmlist: wow.stormline.hu:3728';

mysql_close($connect);
exit();
}
else {
echo '<p class="error">Account már létezik kérlek válassz másikat</p>';
    $account = "";
    }
}
else {
echo '<p class ="error">Minden mezőt tölts ki!</p>';
    }
    }
mysql_close($connect);
?>
<html>
<head>
<link href="_css/style.css" rel="stylesheet" type="text/css">
<link href="images/favicon.ico" rel="shortcut icon">
<title>Regisztráció</title>
</head>
<body>
<body style="background-image: url('images/bg2.jpg')">
<form action="reg2.php" method="post">
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<div style="text-align: center;">Felhasználónév: <input name="account"
size="15" maxlength="30" type="text"><br>
E-mail cím: <input name="email" size="15" maxlength="30" type="text"><br>
Jelszó: <input name="password" size="15" maxlength="50" type="text"><br>
Jelszó(újra): <input name="password2" size="15" maxlength="50" type="text"><br>
</div>
<div align="center">
<div style="text-align: center;"> <input name="submit"
value="Regisztráció" type="submit"><br>
</div>
<br>
</div>
</form>
</body>
</html>