<?
//MSSQL settings
$user = 'sa';
$haslo = '@wmfxm1024$';
$nazwabazy = "Account";
$hostbazy = "127.0.0.1";

$reg_open = true;
?>

<?php
include 'travia_config.php';
$tabelka = '<table>
<form action=travia_do_account.php method=post>
<tr><td>Login</td><td><input type=text name=login value="'.$_POST['login'].'"></td></tr>
<tr><td>Password</td><td><input type=password name=pass></td></tr>
<tr><td>Repead password</td><td><input type=password name=cpass></td></tr>
<tr><td>E-Mail</td><td><input type=text name=mail value="'.$_POST['mail'].'"></td></tr>
<tr><td><input type=submit value="Register"></td><td><input type=reset value="Clear fields"></td></tr>
</form>
</table>';

if($reg_open AND isset($_POST['login']))
{
$conn=@mssql_connect($hostbazy,$user,$haslo) or die("<b>Critical Error</b><br>MSSQL server is offline OR I can't Access to it !");
@mssql_select_db($nazwabazy, $conn) or die("<b>Critical Error</b><br>Database don't exists OR I can't Access to it !");

$login = $_POST['login'];
$pw = $_POST['pass'];
$cpw = $_POST['cpass'];
$email = $_POST['mail'];

$login = trim($login);
$pw = trim($pw);
$cpw = trim($cpw);

if(ereg("[^0-9a-zA-Z_-]", $login, $str))
	{
	echo 'Login zawiera niedozwolone znaki';
	echo '<br>'.$tabelka;
	}
elseif(ereg("[^0-9a-zA-Z_-]", $pw, $str))
	{
	echo 'Hasіo zawiera niedozwolone znaki';
	echo '<br>'.$tabelka;
	}
elseif (empty($login) || empty($email) || empty($pw) || empty($cpw)) 
	{
	echo 'Јaskawie wypeіnij pola<br>'.$tabelka;
	}
elseif (strpos('\'',$email)) 
	{
	echo 'Naprawde uwaїasz їe '.$email.' to poprawny mail?<br>'.$tabelka;
	}
else
	{
	$login_test = strtolower($login);
	$resultx = mssql_query("SELECT LOWER(UT_USERID) FROM usertable 
	WHERE LOWER(UT_USERID) = ('$login_test')") or die;

	if (mssql_num_rows($resultx)) 
  {
  echo 'Konto `'.$login.'` juї istnieje<br>'.$tabelka;
  }
	elseif (strlen($login) < 4) 
  {
  echo 'Login minimum 4 znaki<br>'.$tabelka;
  }
	elseif (strlen($pw) < 4) 
  {
  echo 'Hasіo minimum 4 znaki<br>'.$tabelka;
  }
	elseif (strlen($pw) > 10) 
  {
  echo 'Hasіo max 10 znakow<br>'.$tabelka;
  } 
	elseif (strlen($login) > 10) 
  {
  echo 'Login max 10 znakow<br>'.$tabelka;
  } 
	elseif ($pw != $cpw) 
  {
  echo 'Wpisaіeњ dwa rуїne hasіa<br>'.$tabelka;
  }
	else 
  {
  mssql_query("INSERT INTO usertable (UT_USERID,UT_PASSWORD,UT_ACCOUNTID,UT_DIV,UT_EMAIL) VALUES ('".$login."','".$pw."',convert(binary,'".$login."'),0,'".$email."')") or die('error, account exists');
  echo "Аккаунт зарегестирован";
  }
	}
}
elseif($reg_open)
{
echo $tabelka;
}
else 
{
echo 'Przykro mi ale rejestracja naprawde jest zamknieta';
}
?>