<?php
include "config.php";   

$link = mysql_connect("$host","$user","$pass")or die("Could not connect: " . mysql_error());
       mysql_select_db("$db1");

$email = get_magic_quotes_gpc() ? $_POST['email']    : mysql_escape_string($_POST['email']);
$user= get_magic_quotes_gpc() ? $_POST['user'] : mysql_escape_string($_POST['user']);
$pass= get_magic_quotes_gpc() ? $_POST['pass'] : mysql_escape_string($_POST['pass']);

if  (empty($_POST['user']) or empty($_POST['pass']) or empty($_POST['email'])){
   $cont='Заполните все поля.<br>Fill in all fields.';
}
elseif(!preg_match("/^[a-zA-Z0-9]+$/i", $pass)){
   $cont='Пароль должен состоять только из букв и цифр.<br>Passwords must contain only letters and numbers.';
}
elseif(!preg_match("/[0-9a-z_]+@[0-9a-z_^\.]+\.[a-z]{2,3}/i", $email)){
   $cont='Не правильный email.<br>Not a valid email.';
}
else   
{
$cont='Создание аккаунта успешно завершено!<br>Creating an account successfully completed!';

$q  = mysql_query("SELECT * FROM `account` WHERE `username` = '$user'");
$q2 = mysql_num_rows($q);

if($q2 == 0){$query = mysql_query("INSERT INTO `account` (`username`, `sha_pass_hash`, `email`, `expansion`) VALUES ('$user', SHA1(CONCAT(UPPER('$user'),':',UPPER('$pass'))), '$email', '$tbc')") ;
}
}
?>
<center>
<form name="form1" method="post"><table>
     <tr>   
     <td><b><? echo "$txt[7]"; ?></b><br></td>
     <td><input type="text" name="user" id="user"></td>
     </tr>
     <tr>   
     <td><b><? echo "$txt[8]"; ?></b></td>
     <td><input type="password" name="pass" id="pass"></td>
     </tr>
     <tr>   
     <td><b><? echo "$txt[9]"; ?></b></td>
     <td><input type="text" name="email" id="email"></td>
     </tr>   
   </table>
   <table>
     <tr>   
     <td><font color=blue /><b /><?php print $cont ?></td>
   </tr>   
     </table>
   <table>
   <tr>   
     <td><input type=submit value="<? echo "$txt[10]"; ?>"></td>
     </tr>
     </table></form></center>