20 || (strlen($pwd2) > 20))
{
$errs[] = CBE1_SIGNUP_ERR7;
}
elseif (stristr($pwd, ' '))
{
$errs[] = CBE1_SIGNUP_ERR8;
}
}
if (SIGNUP_CAPTCHA == 1)
{
if (!$captcha)
{
$errs[] = CBE1_SIGNUP_ERR2;
}
else
{
if (empty($_SESSION['captcha']) || strcasecmp($_SESSION['captcha'], $captcha) != 0)
{
$errs[] = CBE1_SIGNUP_ERR3;
}
}
}
if (!(isset($tos) && $tos == 1))
{
$errs[] = CBE1_SIGNUP_ERR9;
}
if (count($errs) == 0)
{
$query = "SELECT username FROM exchangerix_users WHERE username='$email' OR email='$email' LIMIT 1";
$result = smart_mysql_query($query);
if (mysqli_num_rows($result) != 0)
{
header ("Location: signup.php?msg=exists");
exit();
}
// check referral
if ($ref_id > 0)
{
$check_referral_query = "SELECT email FROM exchangerix_users WHERE user_id='$ref_id' LIMIT 1";
$check_referral_result = smart_mysql_query($check_referral_query);
if (mysqli_num_rows($check_referral_result) != 0)
$ref_id = $ref_id;
else
$ref_id = 0;
}
$unsubscribe_key = GenerateKey($username);
if (ACCOUNT_ACTIVATION == 1)
{
$activation_key = GenerateKey($username);
$insert_query = "INSERT INTO exchangerix_users SET username='$username', password='".PasswordEncryption($pwd)."', email='$email', fname='$fname', lname='$lname', country='$country', phone='$phone', reg_source='$reg_source', ref_id='$ref_id', newsletter='$newsletter', ip='$ip', status='inactive', activation_key='$activation_key', unsubscribe_key='$unsubscribe_key', created=NOW()";
}
else
{
$insert_query = "INSERT INTO exchangerix_users SET username='$username', password='".PasswordEncryption($pwd)."', email='$email', fname='$fname', lname='$lname', country='$country', phone='$phone', reg_source='$reg_source', ref_id='$ref_id', newsletter='$newsletter', ip='$ip', status='active', activation_key='', unsubscribe_key='$unsubscribe_key', last_login=NOW(), login_count='1', last_ip='$ip', created=NOW()";
}
smart_mysql_query($insert_query);
$new_user_id = mysqli_insert_id($conn);
if (ACCOUNT_ACTIVATION == 1)
{
//////////////////////////////// Send Message //////////////////////////////
$etemplate = GetEmailTemplate('activate');
$esubject = $etemplate['email_subject'];
$emessage = $etemplate['email_message'];
$activate_link = SITE_URL."activate.php?key=".$activation_key;
$emessage = str_replace("{first_name}", $fname, $emessage);
$emessage = str_replace("{username}", $email, $emessage);
$emessage = str_replace("{password}", $pwd, $emessage);
$emessage = str_replace("{activate_link}", $activate_link, $emessage);
$to_email = $fname.' '.$lname.' <'.$email.'>';
SendEmail($to_email, $esubject, $emessage, $noreply_mail = 1);
////////////////////////////////////////////////////////////////////////////////
// show activation message
header("Location: activate.php?msg=1");
exit();
}
else
{
//////////////////////////////// Send welcome message ////////////////
$etemplate = GetEmailTemplate('signup');
$esubject = $etemplate['email_subject'];
$emessage = $etemplate['email_message'];
$emessage = str_replace("{first_name}", $fname, $emessage);
$emessage = str_replace("{username}", $email, $emessage);
$emessage = str_replace("{password}", $pwd, $emessage);
$emessage = str_replace("{login_url}", SITE_URL."login.php", $emessage);
$to_email = $fname.' '.$lname.' <'.$email.'>';
SendEmail($to_email, $esubject, $emessage, $noreply_mail = 1);
/////////////////////////////////////////////////////////////////////////
if (!session_id()) session_start();
$_SESSION['userid'] = $new_user_id;
$_SESSION['FirstName'] = $fname;
if ($_SESSION['goto'])
{
$redirect_url = $_SESSION['goto'];
unset($_SESSION['goto'], $_SESSION['goto_created']);
}
else
{
// forward new user to account dashboard
$redirect_url = "myaccount.php?msg=welcome";
}
header("Location: ".$redirect_url);
exit();
}
}
else
{
$allerrors = "";
foreach ($errs as $errorname)
$allerrors .= $errorname."
";
}
}
/////////////// Page config ///////////////
$PAGE_TITLE = CBE1_SIGNUP_TITLE;
require_once ("inc/header.inc.php");
?>