Verify и Signup Code

SuCcEsS · 26 Юни 2007

Някой може ли да ми каже как мога да поправя тези две грешки кажете какво ви трябва и ще ви го дам би трябвало грешките да са от SQL таблиците за Verify не изпраща e-mail за потвърждение, а за Signup Code това е кода който се показва рандом от 10000 до 99999 но за съжаление ми изписва, че кода е грешен, а регистрацията е преминала успешно

П.С.
Забравих да кажа, че сайта е http://dragonswords.freehostia.com

xainiken · 26 Юни 2007

Не праща мейл сигурно защото на хоста където ти е сайта нямя SMTP.
За потвърдителния код незнам от какво ще е обаче мисля, че си пускал други теми за този код.

jooorooo · 26 Юни 2007

http://web-tourist.net/forum/viewtopic.php?p=88615&highlight=#88615

с това не стана ли?

SuCcEsS · 26 Юни 2007

jooorooo каза:
http://web-tourist.net/forum/viewtopic.php?p=88615&highlight=#88615

с това не стана ли?

Ами не с това също не стана за съжаление ;(

jooorooo · 26 Юни 2007

добре, копирай ми данните от регистрацията да видя на кое поле какво записва в MySQL-а.

SuCcEsS · 26 Юни 2007

Код:

CREATE TABLE `userdb` (
  `id` mediumint(9) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `email` varchar(65) NOT NULL default '',
  `password` varchar(21) NOT NULL default '',
  `level` mediumint(9) NOT NULL default '1',
  `strength` decimal(10,2) NOT NULL default '3.00',
  `agility` decimal(10,2) NOT NULL default '3.00',
  `accuracy` decimal(10,2) NOT NULL default '50.00',
  `hp` bigint(20) NOT NULL default '15',
  `hp_left` bigint(20) NOT NULL default '15',
  `exp` bigint(20) NOT NULL default '0',
  `exp_lvl` bigint(20) NOT NULL default '200',
  `gold` bigint(20) NOT NULL default '2000',
  `lucky` bigint(20) NOT NULL default '0',
  `bullion` bigint(20) NOT NULL default '0',
  `crystals` bigint(20) NOT NULL default '0',
  `lcrystal` bigint(20) NOT NULL default '0',
  `scrystal` bigint(20) NOT NULL default '0',
  `mcrystal` bigint(20) NOT NULL default '0',
  `diamonds` bigint(20) NOT NULL default '0',
  `ldiamond` bigint(20) NOT NULL default '0',
  `sdiamond` bigint(20) NOT NULL default '0',
  `mdiamond` bigint(20) NOT NULL default '0',
  `emeralds` bigint(20) NOT NULL default '0',
  `lemerald` bigint(20) NOT NULL default '0',
  `semerald` bigint(20) NOT NULL default '0',
  `memerald` bigint(20) NOT NULL default '0',
  `rubys` bigint(20) NOT NULL default '0',
  `lruby` bigint(20) NOT NULL default '0',
  `sruby` bigint(20) NOT NULL default '0',
  `mruby` bigint(20) NOT NULL default '0',
  `pkeys` mediumint(9) NOT NULL default '0',
  `battleswon` bigint(20) NOT NULL default '0',
  `battleslost` bigint(20) NOT NULL default '0',
  `status` varchar(20) NOT NULL default 'Member',
  `job` varchar(35) default NULL,
  `topiccount` bigint(20) NOT NULL default '0',
  `ipaddress` varchar(20) NOT NULL default '',
  `clan` smallint(6) NOT NULL default '0',
  `clan_infl` int(10) NOT NULL default '0',
  `energy` int(3) unsigned NOT NULL default '200',
  `hacks` int(5) unsigned NOT NULL default '0',
  `mithril` int(5) unsigned NOT NULL default '0',
  `age` int(5) NOT NULL default '0',
  `active` varchar(50) NOT NULL default '',
  `active2` varchar(20) default NULL,
  `lastkill` varchar(70) NOT NULL default '',
  `lastkillby` varchar(70) NOT NULL default '',
  `xco` varchar(4) NOT NULL default '0',
  `yco` varchar(4) NOT NULL default '0',
  `wildlvl` varchar(4) NOT NULL default '',
  `lcheck` varchar(20) NOT NULL default '',
  `mcheck` timestamp(14) NOT NULL,
  `ccheck` varchar(20) NOT NULL default '',
  `belief` varchar(10) NOT NULL default '',
  `faith` int(5) NOT NULL default '0',
  `signature` text NOT NULL,
  `clan_days` int(4) NOT NULL default '0',
  `clan_exp` int(10) NOT NULL default '0',
  `clan_gold` int(10) NOT NULL default '0',
  `clan_recieve` int(10) NOT NULL default '0',
  `nectar` int(11) NOT NULL default '0',
  `style` int(3) NOT NULL default '0',
  `noattack` char(1) NOT NULL default 'N',
  `verifycode` varchar(10) NOT NULL default '',
  `verified` char(1) NOT NULL default 'N',
  `phrase` varchar(200) NOT NULL default '',
  `adminnotes` text NOT NULL,
  `chat` char(1) NOT NULL default 'V',
  `chatban` int(9) NOT NULL default '0',
  `mbban` int(9) NOT NULL default '0',
  `jailtime` int(3) NOT NULL default '0',
  `jail_by` varchar(50) NOT NULL default '',
  `jail_reason` varchar(255) NOT NULL default '',
  `chatdefcol` varchar(20) NOT NULL default 'FFFFFF',
  `referrer` int(7) NOT NULL default '0',
  `ref_credit` char(1) NOT NULL default 'N',
  `cleared` char(1) NOT NULL default 'N',
  `muse` int(1) NOT NULL default '0',
  `city` varchar(10) NOT NULL default 'black',
  `chatlines` varchar(10) NOT NULL default '',
  `donated` varchar(50) NOT NULL default '0',
  `justdonated` varchar(50) NOT NULL default '0',
  `subby_time` varchar(50) NOT NULL default '0',
  `cash` varchar(50) NOT NULL default '0',
  `rank` varchar(50) NOT NULL default '0',
  `stardrop` varchar(50) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  FULLTEXT KEY `STATUS` (`status`),
  FULLTEXT KEY `status_2` (`status`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;



INSERT INTO `userdb` VALUES (1, 'email', 'user', 'pass', 1, '3.00', '3.00', '50.00', 15, 15, 0, 200, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Manager', 'Owner/Coder', 0, '211.26.126.53', 0, 0, 200, 0, 0, 0, '18/05 08:35:26', '2004138083526', '', '', '0', '0', '0', '2004138083355', 20040518083526, '2004138083526', '', 0, '', 0, 0, 0, 0, 0, 5, 'N', '', 'Y', 'No?', '', 'V', 0, 0, 0, '', '', 'FFFFFF', 0, 'N', 'N', 0, 'black', '', '0', '0', '0', '0', '0', '0');

jooorooo · 26 Юни 2007

Код:

<html>
<head>
<?
$title = "DragonSwords - Join now!";
include("style5.css");
include("config.php");
include("money_fns.php");

if($ip == "67.112.143.111"){exit;}



?>

</head>

<BODY TOPMARGIN="0" LEFTMARGIN="0" bgcolor=000000>


<center><img src="image/top.gif" border=0><table width="700" border="0" cellspacing="0" cellpadding="0"><tr><td width="121" valign=top><table style="BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid;" width="121" border="0" cellspacing="0" cellpadding="0"><tr><td>

<img src="image/left-section.gif">
<DIV id="topmenucell"> 
User not logged in.
</div>
<? $coderan = rand(10000,99999); ?>
<? $code == $coderan; ?>
<img src="image/left-menu-top.gif"><br />
<font size=1 face=verdana><DIV id="topmenucell">
- <a href="index.php">Home</a><br />
- <a href="signup.php<? if ($ref) {echo "?ref=$ref";}?>">Signup</a><br />
- <a href="about.php">About</a><br />
- <a href="tos.php">ToS/Rules</a><br />
- <a href="staff2.php">Staff</a><br />
- <a href="help2.php">Help</a><br />
</div>

</td></tr></table><td width="*" valign=top><center><img src="image/content.gif"><table width="450" cellspacing="0" cellpadding="0" style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid;"><tr><td><font size=1 face=verdana><DIV id=bottommenucell>


                                     <font size=2>Fill in your details below to sign up...<p>
								<form action="signup.php?action=signup" method="post">
									<table>
									<tr>
										<td>
                                            	E-mail address:
										</td>
										<td>
											<input type="text" name="email" size="30" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">

                                        </td>
									</tr>
         <tr><td>
										  Firstname:
										</td>
										<td>
											<input type="text" name="firstname" size="14" style="border: 1px solid #FFFFFF; background-color: #0099CC; color: white">
										</td>
									</tr>
         <tr><td>
										  Lastname:
										</td>
										<td>
											<input type="text" name="lastname" size="14" style="border: 1px solid #FFFFFF; background-color: #0099CC; color: white">
										</td>
									</tr>
         
									<tr><td>
										   Username:
										</td>
										<td>
											<input type="text" name="username" size="30" style="border: 1px solid #FFFFFF; background-color: #0099CC; color: white">
										</td>
									</tr>


 <tr>
										<td>
											Gender:
										</td>
										<td>
                    <select name=gender>
                <option value=Male>Male</option>
                <option value=Female>Female</option>
                <option value=None>None</option>
                </select><br>
										</td>
									</tr>
                                      <tr>
										<td>
											Password:
										</td>
										<td>
											<input type="password" name="password" size="30" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">
										</td>
									</tr>

									<tr>
										<td>
											Verify Password:
										</td>
										<td>
											<input type="password" name="password2" size="30" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">
										</td>
									</tr>
                                    <tr>
										<td>
											Referral ID:
										</td>
										<td>
                                            <? if (!$ref){ ?>
											<input type="text" name="refferer" size="30" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">
                                            <?} else {echo"<b>$ref</b><input type=hidden name=\"refferer\" value=\"$ref\">";}?>
                                        </td>
									</tr>
                                    <tr>
										<td><? $coderan = rand(10000,99999); ?>
											Signup Code:     (Copy the random number generated on this page to sign up.)
                                        <? Echo "<center><b>$coderan</b></center>"; ?>
                                        </td>
										<td>

											<input type="text" name="codey" size="30" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">

                                        </td>
									</tr>
									<tr>
										<td>
											<input type="submit" value="Submit" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">
										</td>
										<td>
											<input type="reset" value="Reset" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">
										</td>
									</tr>
								</table>
							</form>




<?php

if($action == "signup"){

?>

<p>
<?php

$ip = $REMOTE_ADDR;

$username = htmlspecialchars($username);

if (empty($username) || empty($password) || empty($password2) || empty($email)){
	echo "<b>Error:</b> All fields were not completed<br>";
	$fieldcom = no;
}else{
	$fieldcom = yes;
}

if (!ereg("^[^@ ]+@[^@ ]+\.[^@ \.]+$",$email)){
	echo "<b>Error:</b> Your email address is incorrect<br>";
	$valcom = no;
}else{
	$valcom = yes;
}

if($password == $password2){
	$passcom = yes;
}else{
	echo "<b>Error:</b> Passwords don't match<br>";
	$passcom = no;
}

if($code == $codey){
	$codecom = yes;
}else{
	echo "<b>Error:</b> Signup code does not match -- <font color=red>Bypassed</font><br>";
	$codecom = yes;
}

if(substr($username,0,1) == " "){
	echo "<b>Error:</b> Your username cannot start with a space<br>";
	$usercom1 = no;
}else{
	$usercom1 = yes;
}

if((strlen($username) > 15) || (strlen($username) < 4)){
	echo "<b>Error:</b> Your username is too short, or too long<br>";
	$usercom = no;
}else{
	$usercom = yes;
}

if((strlen($password) > 15) || (strlen($password) < 4)){
	echo "<b>Error</b>: Your password is too short, or too long<br>";
	$passcom2 = no;
}else{
	$passcom2 = yes;
}

if((strlen($email) > 65) || (strlen($email) < 5)){
	echo "<b>Error</b>: Your email address is too short, or too long<br>";
	$emailcom = no;
}else{
	$emailcom = yes;
}

$usercheck = mysql_query("select * from userdb where username='$username'");
if(@mysql_numrows($usercheck) > 0){
	echo "<b>Error</b>: That username is already taken<br>";
	$userun = no;
}else{
	$userun = yes;
}

$emailcheck = mysql_query("select * from userdb where email = '$email'");
if(@mysql_numrows($emailcheck) > 0){
	echo "<b>Error</b>: That email address is already taken<br>";
	$emailun = no;
}else{
	$emailun = yes;
}

$emailcheck = mysql_query("select * from bannedip where email='$email'");
if(@mysql_numrows($emailcheck) > 0){
	echo "<b>Error</b>: You are banned!<br>";
	$banned = yes;
}else{
	$banned = no;
}

$ipbancheck = mysql_query("select * from bannedip where ipaddress='$ip'");
$ipmulti = mysql_query("select * from userdb where ipaddress='$ip'");
if( (@mysql_num_rows($ipbancheck) > 0) || (@mysql_num_rows($ipmulti) > 25) ){
	echo "<b>Error</b>: Your IP is banned, or there are too many users on your ip.<br>";
	$banned1 = yes;
}else{
	$banned1 = no;
}

if(($valcom == 'yes') && ($codecom == 'yes') && ($fieldcom == 'yes') && ($passcom == 'yes') && ($usercom1 == 'yes') && ($usercom == 'yes') && ($passcom2 == 'yes') && ($emailcom == 'yes') && ($userun == 'yes') && ($emailun == 'yes') && ($banned == 'no') && ($banned1 == 'no')){
	$repl = htmlspecialchars($username);
        $repl = eregi_replace("admin","loser",$repl);
	echo "<br><b>Success:</b> Character $username created. You will be receiving an e-mail shortly containing a verification id.  When you receive that, please log in <a href=index.php>here</a>.";

	while($x++ < 10){
		$step1 = rand(1,3);
		if($step1 == "1"){
			$step2 = chr(rand(48, 57));
		}elseif($step1 == "2"){
			$step2 = chr(rand(65, 90));
		}else{
			$step2 = chr(rand(97, 122));
		}
		$verifycode .= $step2;
	}

	$insert_user = mysql_query("INSERT INTO userdb (id, username, gender, firstname,lastname, email, password, ipaddress, energy, verifycode, verified, referrer, yco, xco) VALUES ('', '$repl','$gender','$firstname','$lastname', '$email', '$password', '$ip', '150', '$verifycode', 'Y', '$refferer', '0', '0')");

	send_mail($email);

}else{
	echo "You were not signed up due to the errors above, please complete the signup form again.";
}

}
?>

</div></td></tr></table></td><td width="121" valign=top><table style="BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid;" width="100" border="0" cellspacing="0" cellpadding="0"><tr><td>

<img src="image/right-section-top.gif"><br>
<font size=1 face=verdana><DIV id=bottommenucell>
</div>

</body>
</html>

SuCcEsS · 26 Юни 2007

Е-е-е-е-е jorooo що не каза че ще редактираш този код направо да ти дадях на БГ който е ся пак тр да го превеждам ;(

xainiken · 26 Юни 2007

SuCcEsS каза:
Е-е-е-е-е jorooo що не каза че ще редактираш този код направо да ти дадях на БГ който е ся пак тр да го превеждам ;(

Голяма работа, че пак ще превеждаш. Нали после кода ще ти работи...

jooorooo · 26 Юни 2007

SuCcEsS каза:
Е-е-е-е-е jorooo що не каза че ще редактираш този код направо да ти дадях на БГ който е ся пак тр да го превеждам ;(

Въпроса е дали е станал, ако е да, ще ти кажа какво редактирах, за да го оправиш.

$insert_user = mysql_query("INSERT INTO userdb (id, username, gender, firstname,lastname, email, password, ipaddress, energy, verifycode, verified, referrer, yco, xco) VALUES ('', '$repl','$gender','$firstname','$lastname', '$email', '$password', '$ip', '150', '$verifycode', 'N', '$refferer', '0', '0')");

Червеното N го направих на Y, което значи (според мен), че е активирал профила си.

$insert_user = mysql_query("INSERT INTO userdb (id, username, gender, firstname,lastname, email, password, ipaddress, energy, verifycode, verified, referrer, yco, xco) VALUES ('', '$repl','$gender','$firstname','$lastname', '$email', '$password', '$ip', '150', '$verifycode', 'Y', '$refferer', '0', '0')");

xainiken · 26 Юни 2007

N = No
Y = Yes

SuCcEsS · 26 Юни 2007

Ами пак не стана, ето кода на БГ вече

Код:

<html>
<head>
<?
$title = "DragonSwords - Join now!";
include("style5.css");
include("config.php");
include("money_fns.php");



?>
<meta http-equiv='Content-Type' content='text/html; charset=Windows-1251'>
</head>

<BODY TOPMARGIN="0" LEFTMARGIN="0" bgcolor=000000>
<div id="image1" style="position:absolute; overflow:hidden; left:0px; top:530px; width:1002px; height:238px; z-index:0"><img src="image/down_img.gif" border=0 width=1002 height=238></div>

<div id="text1" style="position:absolute; overflow:hidden; left:390px; top:664px; width:240px; height:19px; z-index:1">
<div class="wpmd">
<div><font color="#FFFFFF">Copyright © </font><a href="mailto:support@dragonswords.freehostia.com" title="support@dragonswords.freehostia.com">DragonSwords</a><font color="#FFFFFF"> 2007-2009.</font></div>
</div>
</div>

<center><img src="image/top.gif" border=0><table width="700" border="0" cellspacing="0" cellpadding="0"><tr><td width="121" valign=top><table style="BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid;" width="121" border="0" cellspacing="0" cellpadding="0"><tr><td>

<img src="image/left-section.gif">
<DIV id="topmenucell"> 
User not logged in.
</div>
<? $coderan = rand(10000,99999); ?>
<? $code == $coderan; ?>
<img src="image/left-menu-top.gif"><br />
<font size=1 face=verdana><DIV id="topmenucell">
- <a href="index.php">Начало</a><br />
- <a href="signup.php<? if ($ref) {echo "?ref=$ref";}?>">Регистрация</a><br />
- <a href="about.php">Информация</a><br />
- <a href="tos.php">Правила</a><br />
- <a href="staff2.php">Персонал</a><br />
- <a href="help2.php">Помощ</a><br />
</div>

</td></tr></table><td width="*" valign=top><center><img src="image/content.gif"><table width="450" cellspacing="0" cellpadding="0" style="BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid;"><tr><td><font size=1 face=verdana><DIV id=bottommenucell>


                                     <font size=2>Попълнете вашите детайли по-долу за да се регистрирате...<p>
								<form action="signup.php?action=signup" method="post">
									<table>
									<tr>
										<td>
                                            	E-mail address:
										</td>
										<td>
											<input type="text" name="email" size="30" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">

                                        </td>
									</tr>
         <tr><td>
										  Име:
										</td>
										<td>
											<input type="text" name="firstname" size="14" style="border: 1px solid #FFFFFF; background-color: #0099CC; color: white">
										</td>
									</tr>
         <tr><td>
										  Фамилия:
										</td>
										<td>
											<input type="text" name="lastname" size="14" style="border: 1px solid #FFFFFF; background-color: #0099CC; color: white">
										</td>
									</tr>
         
									<tr><td>
										   Потребител:
										</td>
										<td>
											<input type="text" name="username" size="30" style="border: 1px solid #FFFFFF; background-color: #0099CC; color: white">
										</td>
									</tr>


 <tr>
										<td>
											Пол:
										</td>
										<td>
                    <select name=gender>
                <option value=Male>Мъж</option>
                <option value=Female>Жена</option>
                <option value=None>Няма</option>
                </select><br>
										</td>
									</tr>
                                      <tr>
										<td>
											Парола:
										</td>
										<td>
											<input type="password" name="password" size="30" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">
										</td>
									</tr>

									<tr>
										<td>
											Повтори парола:
										</td>
										<td>
											<input type="password" name="password2" size="30" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">
										</td>
									</tr>
                                    <tr>
										<td>
											ID на приятел:
										</td>
										<td>
                                            <? if (!$ref){ ?>
											<input type="text" name="refferer" size="30" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">
                                            <?} else {echo"<b>$ref</b><input type=hidden name=\"refferer\" value=\"$ref\">";}?>
                                        </td>
									</tr>
                                    <tr>
										<td><? $coderan = rand(10000,99999); ?>
											Код:     (Кпирайте кода и го въведете, за да се регистрирате.)
                                        <? Echo "<center><b>$coderan</b></center>"; ?>
                                        </td>
										<td>

											<input type="text" name="codey" size="30" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">

                                        </td>
									</tr>
									<tr>
										<td>
											<input type="submit" value="Изпрати" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">
										</td>
										<td>
											<input type="reset" value="Изчисти" style="border: 1px solid #FFFFFF; background-color: #000020; color: white">
										</td>
									</tr>
								</table>
							</form>




<?php

if($action == "signup"){

?>

<p>
<?php

$ip = $REMOTE_ADDR;

$username = htmlspecialchars($username);

if (empty($username) || empty($password) || empty($password2) || empty($email)){
	echo "<b>Error:</b> All fields were not completed<br>";
	$fieldcom = no;
}else{
	$fieldcom = yes;
}

if (!ereg("^[^@ ]+@[^@ ]+\.[^@ \.]+$",$email)){
	echo "<b>Грешка:</b> Невалиден e-mail<br>";
	$valcom = no;
}else{
	$valcom = yes;
}

if($password == $password2){
	$passcom = yes;
}else{
	echo "<b>Грешка:</b> Паролата не съвпада<br>";
	$passcom = no;
}

if($code == $codey){
	$codecom = yes;
}else{
	echo "<b>Грешка:</b> Кода не съвпада -- <font color=red>Заобикалям</font><br>";
	$codecom = yes;
}

if(substr($username,0,1) == " "){
	echo "<b>Грешка:</b> Вашето потребителско име не може да започне с пространство<br>";
	$usercom1 = no;
}else{
	$usercom1 = yes;
}

if((strlen($username) > 15) || (strlen($username) < 4)){
	echo "<b>Грешка:</b> Вашето потребителско име е твърде кратко, или твърде дълго<br>";
	$usercom = no;
}else{
	$usercom = yes;
}

if((strlen($password) > 15) || (strlen($password) < 4)){
	echo "<b>Грешка</b>: Вашата парола е твърде кратка, или твърде дълга<br>";
	$passcom2 = no;
}else{
	$passcom2 = yes;
}

if((strlen($email) > 65) || (strlen($email) < 5)){
	echo "<b>Грешка</b>: Вашият е-mail е твърде кратък, или твърде дълъг<br>";
	$emailcom = no;
}else{
	$emailcom = yes;
}

$usercheck = mysql_query("select * from userdb where username='$username'");
if(@mysql_numrows($usercheck) > 0){
	echo "<b>Грешка</b>: Потребителското име е заето<br>";
	$userun = no;
}else{
	$userun = yes;
}

$emailcheck = mysql_query("select * from userdb where email = '$email'");
if(@mysql_numrows($emailcheck) > 0){
	echo "<b>Грешка</b>: Този e-mail вече се използва<br>";
	$emailun = no;
}else{
	$emailun = yes;
}

$emailcheck = mysql_query("select * from bannedip where email='$email'");
if(@mysql_numrows($emailcheck) > 0){
	echo "<b>Грешка</b>: Вие сте баннат!<br>";
	$banned = yes;
}else{
	$banned = no;
}

$ipbancheck = mysql_query("select * from bannedip where ipaddress='$ip'");
$ipmulti = mysql_query("select * from userdb where ipaddress='$ip'");
if( (@mysql_num_rows($ipbancheck) > 0) || (@mysql_num_rows($ipmulti) > 25) ){
	echo "<b>Грешка</b>: Вашето IP има бан или има прекалено много потребители с него.<br>";
	$banned1 = yes;
}else{
	$banned1 = no;
}

if(($valcom == 'yes') && ($codecom == 'yes') && ($fieldcom == 'yes') && ($passcom == 'yes') && ($usercom1 == 'yes') && ($usercom == 'yes') && ($passcom2 == 'yes') && ($emailcom == 'yes') && ($userun == 'yes') && ($emailun == 'yes') && ($banned == 'no') && ($banned1 == 'no')){
	$repl = htmlspecialchars($username);
        $repl = eregi_replace("admin","loser",$repl);
	echo "<br><b>Успешно</b> регистрирахте $username. Вие ще получите е-mail с код за идентификация и проверка. Кога го получите, моля влезте от <a href=index.php>тук</a>.";

	while($x++ < 10){
		$step1 = rand(1,3);
		if($step1 == "1"){
			$step2 = chr(rand(48, 57));
		}elseif($step1 == "2"){
			$step2 = chr(rand(65, 90));
		}else{
			$step2 = chr(rand(97, 122));
		}
		$verifycode .= $step2;
	}

	$insert_user = mysql_query("INSERT INTO userdb (id, username, gender, firstname,lastname, email, password, ipaddress, energy, verifycode, verified, referrer, yco, xco) VALUES ('', '$repl','$gender','$firstname','$lastname', '$email', '$password', '$ip', '150', '$verifycode', 'N', '$refferer', '0', '0')");

	send_mail($email);

}else{
	echo "Вие не бяхте регистриран поради грешките по-горе, моля попълнете формулярът за регистрация отново.";
}

}
?>

</div></td></tr></table></td><td width="121" valign=top><table style="BORDER-RIGHT: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-BOTTOM: #000000 1px solid;" width="100" border="0" cellspacing="0" cellpadding="0"><tr><td>

<img src="image/right-section-top.gif"><br>
<font size=1 face=verdana><DIV id=bottommenucell>
</div>

</td></tr></table></td></tr></table>
</center>
</body>
</html>

Verify и Signup Code

SuCcEsS

Registered

xainiken

Registered

jooorooo

Registered

SuCcEsS

Registered

jooorooo

Registered

SuCcEsS

Registered

jooorooo

Registered

SuCcEsS

Registered

xainiken

Registered

jooorooo

Registered

xainiken

Registered

SuCcEsS

Registered