$Query = "DROP TABLE `users`;";
$Result = mysql_query($Query);
$Query = "CREATE TABLE `users` (id INT UNSIGNED NOT NULL AUTO_INCREMENT,
login VARCHAR (256) NOT NULL UNIQUE, password VARCHAR (1024) NOT NULL, email VARCHAR (64) NOT NULL, active TINYINT NOT NULL, code INT UNSIGNED NOT NULL, DeleteTheEmail INT UNSIGNED NOT NULL, avatar INT UNSIGNED, PRIMARY KEY(id));";
$Result = mysql_query($Query);
if ($_SERVER["REQUEST_METHOD"] == "POST")
{//if ($_SERVER["REQUEST_METHOD"] == "POST")
if (isset($_POST["Login"]))
{//if (isset($_POST["Login"]))
$Login = addslashes($_POST["Login"]);
}//if (isset($_POST["Login"]))
else
{//if (isset($_POST["Login"])) else
$Login = "";
}//if (isset($_POST["Login"])) else
if (isset($_POST["Password"]))
{//if (isset($_POST["Password"]))
$Password = addslashes($_POST["Password"]);
}//if (isset($_POST["Password"]))
else
{//if (isset($_POST["Password"])) else
$Password = "";
}//if (isset($_POST["Password"])) else
if (isset($_POST["Email"]))
{//if (isset($_POST["Email"]))
$Email = addslashes($_POST["Email"]);
}//if (isset($_POST["Email"]))
else
{//if (isset($_POST["Email"])) else
$Email = "";
}//if (isset($_POST["Email"])) else
}//if ($_SERVER["REQUEST_METHOD"] == "POST")
else
{//if ($_SERVER["REQUEST_METHOD"] == "POST") else
$Login = "";
$Password = "";
$Email = "";
}//if ($_SERVER["REQUEST_METHOD"] == "POST") else
echo "<form action=\"\" method=\"post\">\n";
echo "<table border=1 cellspacing=0 bordercolor=\"black\">\n";
echo "<tr>\n";
echo "<td>\n";
echo "<p>Login:</p>\n";
echo "</td>\n";
echo "<td>\n";
echo "<input type=\"text\" name=\"Login\" value=\"";
echo $Login;
echo "\">\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<p>Password:</p>\n";
echo "</td>\n";
echo "<td>\n";
echo "<input type=\"password\" name=\"Password\" value=\"";
echo $Password;
echo "\">\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<p>e-mail:</p>\n";
echo "</td>\n";
echo "<td>\n";
echo "<input type=\"text\" name=\"Email\" value=\"";
echo $Email;
echo "\">\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td colspan=2 valign=\"top\">\n";
echo "<center><input type=\"submit\" value=\"Войти\"></center>\n";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</form>";
if ($Email != "")
{//if ($Email != "")
if (filter_var($Email, FILTER_VALIDATE_EMAIL))
{//if (filter_var($Email, FILTER_VALIDATE_EMAIL))
$Query = "INSERT INTO `users` SET login='".$Login."', password='".$Password."', email='".$Email."', active=0, code=RAND()*2147483647, DeleteTheEmail=RAND()*2147483647;";
$Result = mysql_query($Query);
$Id = mysql_insert_id();
$Query = "SELECT * FROM `users` WHERE (id='".$Id."');";
$Result = mysql_query($Query);
$Count = mysql_num_rows($Result);
if ($Count > 0)
{//if ($Count > 0)
$Code = mysql_result ($Result, 0, "code");
$DeleteTheEmail = mysql_result ($Result, 0, "DeleteTheEmail");
$Link1 = "http://".$domain."/activation.php?id=".$Id."&code=".$Code;
$Link2 = "http://".$domain."/activation.php?id=".$Id."&DeleteTheEmail=".$DeleteTheEmail;
echo $Email;
echo "<br>";
echo $domain;
echo "<br>";
echo $Login;
echo "<br>";
echo $Password;
echo "<br>";
echo $Link1;
echo "<br>";
echo $Link2;
echo "<br>";
$Message = "<p>Вы получили это письмо, так как ".$Email." указан в качестве e-mail при регистрааии на ".$domain.". <h1><center>Ваши данные на сервере</center></h1><p>Login:".$Login."</p><p>Password:".$Password.".</p><p>Для активации перейдите по ссылке: <a href=".$Link1.">".$Link1."</a>.</p><p>Если не это не Вы, то пройдите по ссылке: <a href=".$Link2.">".$Link2."</a></p>";
echo $Message;
echo "<br>";
$Headers = "From: atavin-ta@mail.ru <codesite@yandex.ru>\r\nMIME-Version: 1.0\r\nContent-type: text/plain; charset=utf-8\r\nContent-Transfer-Encoding: 8bit";
echo $Headers;
echo "<br>";
mail($Email, "=?utf-8?B?".base64_encode("Регистрация"), $Message, $Headers);
}//if ($Count > 0)
else
{//if ($Count > 0) else
$Query = "SELECT * FROM `users` WHERE (login='".$Login."');";
$Result = mysql_query($Query);
if (mysql_num_rows($Result)>0)
{//if (mysql_num_rows($Result)>0)
echo "<p>Такой login уже есть.</p>";
}//if (mysql_num_rows($Result)>0)
else
{//if (mysql_num_rows($Result)>0) else
echo "<p>Не известная ошибка.</p>";
}//if (mysql_num_rows($Result)>0) else
}//if ($Count > 0) else
}//if (filter_var($Email, FILTER_VALIDATE_EMAIL))
else
{//if (filter_var($Email, FILTER_VALIDATE_EMAIL)) else
echo "<p>Проверьте e-mail!</p>";
}//if (filter_var($Email, FILTER_VALIDATE_EMAIL)) else
}//if ($Email != "")
