<?php
ob_start();
error_reporting(E_ALL);
$dbhost = "155.133.24.50";
$dbuser = "root";
$dbpass = "****";
$dbname = "l2dc";

$conn = mysql_connect("$dbhost", "$dbuser", "$dbpass")
or die('Could not connect: ' . mysql_error());
$dbselect = mysql_select_db("$dbname")
or die ('Could not select database');


$pass = mysql_real_escape_string($_POST["sws_pass"]);
$email = mysql_real_escape_string($_POST["sws_email"]);
$user = mysql_real_escape_string($_POST["sws_name"]);


if(!preg_match('/^[a-zA-Z0-9]{5,20}$/',$user)) {
header("Location: http://l2rot.pl/register.php?code=1");
die();
 }

if(!preg_match('/^[a-zA-Z0-9]{5,20}$/',$pass)) {
header("Location: http://l2rot.pl/register.php?code=2");
die();
}
if (!filter_var($email, FILTER_VALIDATE_EMAIL))
{
header("Location: http://l2rot.pl/register.php?code=3");
die();

}

$hashed=base64_encode(pack("H*", sha1(utf8_encode($pass))));
$result = mysql_query("SELECT login FROM accounts WHERE login='$user'");
if(mysql_num_rows($result)>0)
{
header("Location: http://l2rot.pl/register.php?code=4");
}

else{
mysql_query("INSERT INTO accounts (login, password,lastactive ,accessLevel,failedAttempts) VALUES ('$user', '$hashed',0,0,0)");
mysql_query("INSERT INTO acc (login, password,email) VALUES ('$user', '$pass','$email')") or die ('Error: ' . mysql_error());
header("Location: http://l2rot.pl/register.php?code=5");


}
  ob_end_flush();
?>