Може ли да направите по една проверка ако не е въведено име,парола и емайл да не може да се изпълни заявката да пише не си попълнил полетата или нещо от този род :/
Код:
<?php
require_once ('config.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Create Account</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="style.css" type="text/css" media="screen" />
<link rel="stylesheet" href="fx.slide.css" type="text/css" media="screen" />
<script type="text/javascript" src="js/mootools-1.2-core-yc.js"></script>
<script type="text/javascript" src="js/mootools-1.2-more.js"></script>
<script type="text/javascript" src="js/fx.slide.js"></script>
</head>
<body>
<div class="clearfix"></div>
<p> </p>
<div id="content" style="background-color:#FFFFFF">
<p>
<div class="yjsquare" style="width:100%;">
<div class="title_hold">
<div class="title_l">
<div class="title_r">
</div>
</div>
</div>
<div class="yjsquare_in">
<center><p class="textshadow"><img src="images/thumb_up.gif" width="16" height="16" border="0" alt="Thank you" /> Server Version 3.3.5 <img src="images/thumb_up.gif" width="16" height="16" border="0" alt="Thank you" /></p>
<center><p class="textshadow"><img src="images/thumb_up.gif" width="16" height="16" border="0" alt="Thank you" /> Server Rate: Very Hight <img src="images/thumb_up.gif" width="16" height="16" border="0" alt="Thank you" /></p>
<?php
if ($_SESSION["valid_user"])
{ echo "<font class=\"textshadow\"><b>You already have an account! Please log out first in order to create a new account. But why would you <img src=\"images/huh.gif\" width=\"15px\" height=\"15px\" border=\"0\" /> ?</b></font>"; } else {
$realmd = array(
'db_host'=> $host,
'db_username' => $user,
'db_password' => $pass,
'db_name'=> $mangosrealm,
);
function check_for_symbols($string){
$len=strlen($string);
$allowed_chars="abcdefghijklmnopqrstuvwxyzæøåABCDEFGHIJKLMNOPQRSTUVWXYZÆØÅ0123456789";
for($i=0;$i<$len;$i++)if(!strstr($allowed_chars,$string[$i]))return TRUE;
return FALSE;
}
function sha_password($username,$password){
$username = strtoupper($username);
$password = strtoupper($password);
return SHA1($username.':'.$password);
}
if ($_POST['registration']){
$realmd_bc_new_connect = mysql_connect($realmd[db_host],$realmd[db_username],$realmd[db_password]);
$selectdb = mysql_select_db($realmd[db_name],$realmd_bc_new_connect);
if (!$realmd_bc_new_connect || !$selectdb){
echo "Something went wrong while connecting to the database. Please make sure the config.php file is correct.";
die;
}
$username1 = $_POST['username'];
$password1 = sha_password($username1,$_POST['password']);
$email1 = $_POST['email'];
$client = $_POST['expansion'];
$qry_check_username = mysql_query("SELECT username FROM account WHERE username='$username'");
if (check_for_symbols($_POST[password]) == TRUE || check_for_symbols($username1) == TRUE || mysql_num_rows($qry_check_username) != 0){
echo "Something went wrong with creating an account for you. Either the Username is already taken or you are using unacceptable symbols. Please try again.";
}else{
mysql_query("INSERT INTO account (username,sha_pass_hash,email,expansion) VALUES
('$username1','$password1','$email1','$client')");
echo "<br><br><img src=\"images/green_check.gif\" /> Your account <b>".$username1."</b> has been successfully added to the database! Make sure you change your realmlist.wtf file to: <br /><br /> <b>".$realmlist."</b><br/><br/><br>Don't know how to change your realmlist.wtf file? <a href=\"how_to.php\">Click Here</a><br/><br/>Please contact one of the staff members if you're having difficulties loggin in after 5-10 minutes.";
}
}else{
?>
<table>
<form autocomplete="off" action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST">
<tr><br><br><img src="images/username.png" width="16" height="16" border="0" alt="Thank you" /> Username <img src="images/username.png" width="16" height="16" border="0" alt="Thank you" /><br><input type="text" name="username"></tr>
<br><img src="images/password.png" width="16" height="16" border="0" alt="Thank you" /> Password <img src="images/password.png" width="16" height="16" border="0" alt="Thank you" /><br><input type="password" name="password"></tr>
<tr><td> </td><td> </td></tr>
<br><img src="images/email.png" width="16" height="16" border="0" alt="Thank you" /> E-mail address <img src="images/email.png" width="16" height="16" border="0" alt="Thank you" /><br><input type="text" name="email"></tr>
<br><img src="images/world.png" width="16" height="16" border="0" alt="Thank you" /> Expansion Pack: <img src="images/world.png" width="16" height="16" border="0" alt="Thank you" /><br><br>
<select name="expansion">
<option value="2">Wotlk Client</option>
<option value="1">TBC Client</option>
<option value="0">Classic WoW</option>
</select>
<tr><td> </td><td><input type="submit" name="registration"></td></tr>
</form>
</table>
<?php
}
}
?>
</div>
</div>
</p>
</td></tr></table>
</div>
</div>
<div class="clearfix"></div>
</div>
</body>
</html>