проверка дали съществува

lqlqlq · 24 Август 2010

Код:

<?php
define('IN_VALID', true);
require_once ('config.php');
?>

<?php
if ($_SESSION["valid_user"])
			{ echo "<font class=\"textshadow\"><b>Този акаунт вече съществува ?</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 "Грешка! Използвали сте невалидни символи при името на акаунта ви.";
}else{
mysql_query("INSERT INTO account (username,sha_pass_hash,email,expansion) VALUES
('$username1','$password1','$email1','$client')");
echo "Твоят акаунт<b>".$username1."</b> е създаден! Обедете се, че сте добавили нашият реалмлист: <br /><br /><b> ".$realmlist."</b><br/><br/>  Ако имате проблеми посетете нашият форум";
}


}else{
?>

<table>
<form autocomplete="off" action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post" />
<tr><td width="150px">Акаунт</td><td><input type="text" name="username"></td></tr>
<tr><td>Парола</td><td><input type="password" name="password"></td></tr>

<tr><td>Е-мейл адрес</td><td><input type="text" name="email" /></td></tr>
<tr><td valign="top">Експанжън:</td>
     <td>
     <select name="expansion">
      <option value="2">Wotlk клиент</option>
     </select></td></tr>

<tr><td> </td><td><input type="submit" name="registration" value="Създай"></td></tr>
</form>
</table>

<?php
}
			}
?>

Някои може ли да ми сложи проверка дали акаунта вече съществува ?
ПП: тази дето е сложена, не работи..

slideR · 24 Август 2010

<?php
define('IN_VALID', true);
require_once ('config.php');
?>

<?php
if ($_SESSION["valid_user"])
{ echo "<font class=\"textshadow\"><b>Този акаунт вече съществува ?</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='$username1'");

if (check_for_symbols($_POST[password]) == TRUE || check_for_symbols($username1) == TRUE || mysql_num_rows($qry_check_username) != 0){
echo "Грешка! Използвали сте невалидни символи при името на акаунта ви.";
}else{
mysql_query("INSERT INTO account (username,sha_pass_hash,email,expansion) VALUES
('$username1','$password1','$email1','$client')");
echo "Твоят акаунт<b>".$username1."</b> е създаден! Обедете се, че сте добавили нашият реалмлист: <br /><br /><b> ".$realmlist."</b><br/><br/> Ако имате проблеми посетете нашият форум";
}

}else{
?>

<table>
<form autocomplete="off" action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post" />
<tr><td width="150px">Акаунт</td><td><input type="text" name="username"></td></tr>
<tr><td>Парола</td><td><input type="password" name="password"></td></tr>

<tr><td>Е-мейл адрес</td><td><input type="text" name="email" /></td></tr>
<tr><td valign="top">Експанжън:</td>
<td>
<select name="expansion">
<option value="2">Wotlk клиент</option>
</select></td></tr>

<tr><td> </td><td><input type="submit" name="registration" value="Създай"></td></tr>
</form>
</table>

<?php
}
}
?>

lqlqlq · 24 Август 2010

Да, супер стана, но ми излиза това :

Грешка! Използвали сте невалидни символи при името на акаунта ви.
При направата на същия акаунт, можеш ли да го преправиш и да излиза:

Грешка! Този акаунт вече съществува.

slideR · 24 Август 2010

<?php
define('IN_VALID', true);
require_once ('config.php');
?>

<?php
if ($_SESSION["valid_user"])
{ echo "<font class=\"textshadow\"><b>Този акаунт вече съществува ?</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='$username1'");
if(mysql_num_rows($qry_check_username) != 0)
{
echo 'Грешка: Този акаунт вече съществува.';
}
else
{
if (check_for_symbols($_POST[password]) == TRUE || check_for_symbols($username1) == TRUE){
echo "Грешка! Използвали сте невалидни символи при името на акаунта ви.";
}else{
mysql_query("INSERT INTO account (username,sha_pass_hash,email,expansion) VALUES
('$username1','$password1','$email1','$client')");
echo "Твоят акаунт<b>".$username1."</b> е създаден! Обедете се, че сте добавили нашият реалмлист: <br /><br /><b> ".$realmlist."</b><br/><br/> Ако имате проблеми посетете нашият форум";
}
}
}else{
?>

<table>
<form autocomplete="off" action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post" />
<tr><td width="150px">Акаунт</td><td><input type="text" name="username"></td></tr>
<tr><td>Парола</td><td><input type="password" name="password"></td></tr>

<tr><td>Е-мейл адрес</td><td><input type="text" name="email" /></td></tr>
<tr><td valign="top">Експанжън:</td>
<td>
<select name="expansion">
<option value="2">Wotlk клиент</option>
</select></td></tr>

<tr><td> </td><td><input type="submit" name="registration" value="Създай"></td></tr>
</form>
</table>

<?php
}
}
?>

Така

lqlqlq · 24 Август 2010

проверка дали съществува

lqlqlq

Registered

slideR

Registered

lqlqlq

Registered

slideR

Registered

lqlqlq

Registered