Signup
if(isset($_COOKIE["usNick"]) && isset($_COOKIE["usPass"])){ ?>
exit();}
if ($_POST['username']){
$username = $_POST['username'];
if( strtolower($_POST['code'])!= strtolower($_SESSION['texto'])){
$display_error = "* Security Code Error"; // error language
include ('error.php');
exit();
}else{
include('includes/config.inc.php');
$firstname = $_POST["firstname"];
$surname = $_POST["surname"];
$username = $_POST["username"];
$password = $_POST["password"];
$cpassword = $_POST["cpassword"];
$email = $_POST["email"];
$cemail = $_POST["cemail"];
$pemail = $_POST["pemail"];
$address1 = $_POST["address1"];
$address2 = $_POST["address2"];
$city = $_POST["city"];
$state = $_POST["state"];
$zip = $_POST["zip"];
$country = $_POST["country"];
if ($firstname==NULL|$surname==NULL|$username==NULL|$password==NULL|$cpassword==NULL|$email==NULL|$cemail==NULL|$pemail==NULL|$country==NULL){
$display_error = "* All fields are required"; // error language
include ('error.php');
exit();
}else{
$firstname = uc($firstname);
$surname = uc($surname);
$username = uc($username);
$password = uc($password);
$cpassword = uc($cpassword);
$email = limpiar($email);
$cemail = limpiar($cemail);
$pemail = limpiar($pemail);
$address1 = limpiar($address1);
$address2 = limpiar($address2);
$city = limpiar($city);
$state = limpiar($state);
$zip = limpiar($zip);
$country = limpiar($country);
$username=limitatexto($username,15);
$password=limitatexto($password,15);
$cpassword=limitatexto($cpassword,15);
$email=limitatexto($email,100);
$cemail=limitatexto($cemail,100);
$pemail=limitatexto($pemail,100);
$country=limitatexto($country,150);
minimo($username);
minimopass($password);
if ($password!=$cpassword) {
$display_error = "* Passwords Do Not Match"; // error language
include ('error.php');
exit();
}else{
if ($email!=$cemail) {
$display_error = "* Emails Do not Match"; // error language
include ('error.php');
exit();
}else{
ValidaMail($email);
ValidaMail($pemail);
$laip = getRealIP();
if($laip!="127.0.0.1"){
$myDb->connect();
$checkip = mysql_query("SELECT ip FROM yob_users WHERE ip='$laip'");
$ip_exist = mysql_num_rows($checkip);
$myDb->close();
}
if ($ip_exist>0) {
include ('header.php');
$display_error = "* You have already created an account"; // error language
include ('error.php');
exit();
}else{
$myDb->connect();
$checkuser = mysql_query("SELECT username FROM yob_users WHERE username='$username'");
$username_exist = mysql_num_rows($checkuser);
$checkemail = mysql_query("SELECT email FROM yob_users WHERE email='$email'");
$email_exist = mysql_num_rows($checkemail);
$checkpemail = mysql_query("SELECT pemail FROM yob_users WHERE pemail='$pemail'");
$pemail_exist = mysql_num_rows($checkpemail);
$myDb->close();
if ($email_exist>0|$username_exist>0) {
$display_error = "* Username or Email Already in Use"; // error language
include ('error.php');
exit();
}else{
if ($pemail_exist>0) {
$display_error = "* Your Payment Email is Already in Use"; // error language
include ('error.php');
exit();
}else{
if ($_POST["referer"] != "") {
$referer = limpiar($_POST["referer"]);
$referer=limitatexto($referer,15);
$myDb->connect();
$checkref = mysql_query("SELECT username FROM yob_users WHERE username='$referer'");
$referer_exist = mysql_num_rows($checkref);
$myDb->close();
if ($referer_exist<1) {
$display_error = "* The referrer you entered doesn't exist"; // error language
include ('error.php');
exit();
}else{
$myDb->connect();
$sqlz = "SELECT * FROM yob_users WHERE username='$referer'";
$resultz = mysql_query($sqlz);
$myrowz = mysql_fetch_array($resultz);
$myDb->close();
$numero=$myrowz["referals"];
$myDb->connect();
$sqlex = "UPDATE yob_users SET referals='$numero' +1 WHERE username='$referer'";
$resultex = mysql_query($sqlex);
$myDb->close();
}
}
$joindate = date("F j, Y");
$pass = sha1($password);
$myDb->connect();
$query = "INSERT INTO yob_users (firstname, surname, username, password, ip, email, pemail, referer, address1, address2, city, state, zip, country, joindate, paymentmethod) VALUES('$firstname','$surname','$username','$pass','$laip','$email','$pemail','$referer','$address1','$address2','$city','$state','$zip','$country','$joindate', 'Alertpay')";
mysql_query($query) or die(mysql_error());
$myDb->close();
$display_error = "* You have been registered correctly $username. Now you can login."; // error language
include ('error.php');
exit();
}
}
}
}
}
}
}
}else{
include ('header.php'); ?>
include ('footer.php'); ?>
<\html>
Postar um comentário