";
$randtext = generateRandomString(500);
$randtext = md5($randtext);
$xtm = time()+60*60*24*1;
$sql = "INSERT INTO `temp_token` (`easy_key`, `date_added`, `date_expired`, `ip_add`, `status`, `user_id`) VALUES ('$randtext', '$nowtime', '$xtm', '$ip_add', '1', '0')";
$res = mysqli_query($db, $sql);
if(empty($_POST) == false) {
$fields = array('username', 'password', 'password_again', 'email', 'name', 'captchavar');
foreach($_POST as $key=>$value) {
if(empty($value) && in_array($key, $fields) == true){
$errors[] = 'All fields are required';
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$_POST[username]', pass_word='$_POST[password]', email_add='$_POST[email]', error_msg='All Form Not Filled', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
break 1;
}
}
$email = $_POST['email'];
$email = str_replace(" ", "", $email);
$email = strtolower($email);
$ead = str_replace(".", "", $email);
$password = $_POST['password'];
$passwordagain = $_POST['password_again'];
$captcha = $_POST['captcha'];
$name = $_POST['name'];
$username = preg_replace('/[^a-zA-Z0-9]/', '', $_POST['username']);
////$username = $_POST['username'];
$username = strtolower($username);
$tkn = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*), easy_key, date_added, ip_add, status, user_id FROM temp_token WHERE easy_key='$captcha'"));
$udt = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM users WHERE email='$email'"));
$udv = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*) FROM users WHERE username='$username'"));
if($tkn[0]=='0')
{
$errors[] = 'Security Key Not Found!';
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password', email_add='$email', error_msg='Invalid Captcha', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
if($tkn[4]=='0')
{
$errors[] = 'Security key Already Used. Please Try Again!';
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password', email_add='$email', error_msg='security key $captcha already used by you or some one else $email', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
if($udt[0]=='1') {
$errors[] = "Sorry ! $email is already Registered
Try With another Email Address.
";
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password', email_add='$email', error_msg='$email is already Registered', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
if($udv[0]=='1') {
$errors[] = "Sorry ! $username is already Registered
Try With another Username.
";
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password|||$passwordagain', email_add='$email', error_msg='$username is already Registered', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
if($udt[0]=='0')
{
$eadcheck = mysqli_fetch_array(mysqli_query($db, "SELECT COUNT(*), email FROM users WHERE ead2='$ead'"));
if($eadcheck[0]>'0') {
$errors[] = "Account Already Exist !
You already have account with email $eadcheck[1]
";
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password|||$passwordagain', email_add='$email', error_msg='Trying To make multiple accounts with same email by adding DOT', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
}
if(strlen($username) < 8) {
$errors[] = 'Username too short, it must be between 8-20 characters!';
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password|||$passwordagain', email_add='$email', error_msg='Used Short Username', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
if(strlen($username) > 20) {
$errors[] = 'Username is too Long, it must be between 8-20 characters!';
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password|||$passwordagain', email_add='$email', error_msg='Used Long username', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
if(strlen($_POST['password']) < 10) {
$errors[] = 'Password too short, it must be at least 10 characters!';
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password|||$passwordagain', email_add='$email', error_msg='Used Short Password', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
if(strlen($_POST['password']) > 20) {
$errors[] = 'Password is too Long, it must be at least 10-20 characters!';
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password|||$passwordagain', email_add='$email', error_msg='Used Long Password', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
if($_POST['password'] !== $_POST['password_again']) {
$errors[] = 'Both of your entered passwords are not matching!';
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password|||$passwordagain', email_add='$email', error_msg='Passwords MisMatch', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
if(filter_var($email, FILTER_VALIDATE_EMAIL) == false) {
$errors[] = 'A valid email adress is required';
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password|||$passwordagain', email_add='$email', error_msg='Invalid Email', reg_time='$nowtime', reg_ip='$ip_add', reg_status='0'");
}
if(isset($errors))
{
echo "
Error Found!
";
}else{
$ymd = date('Y.m.d');
$ecode = md5("$email-$nowtime");
$mpassword = md5($password);
$timenew = time();
$xtm = time() + (60*60);
$subj = "$sitename | Activate your account*";
$prores = mysqli_query($db, "INSERT INTO registration_log SET user_name='$username', pass_word='$password', email_add='$email', error_msg='Done', reg_time='$nowtime', reg_ip='$ip_add', reg_status='1'");
echo "
You have been successfully Registered !
";
$ltoken6 = md5("$nowtime-$email");
$ltoken7 = strtoupper($ltoken6);
$mtoken1 = $email;
$mtoken2 = md5($mtoken1);
$mtoken3 = strtoupper($mtoken2);
$mtoken5 = "$mtoken3$randtext";
$mtoken6 = md5("$mtoken5");
$mtoken7 = strtoupper($mtoken6);
$prores = mysqli_query($db, "INSERT INTO users SET username='$username', password='$mpassword', email='$email', email_code='$ecode', name='$name', active='0', type='0', ip='$ip_add', date='$ymd', login_key='$ltoken7', auto_login='$mtoken7'");
$message = "
EMAIL VERIFICATION
Verify Your Email Account
Hello $name,$username We dont store your password in plane text format. its stored in encrypted format. \n\n
To activate your account, access the link below:
";
$res = mysqli_query($db, "UPDATE `users` SET `ead2` = '$ead' WHERE `email` = '$email' AND `ead2` IS NULL");
$sql = "UPDATE temp_token SET `use_for`='Registration', `date_used`='$nowtime', `status`='0' WHERE easy_key='$captcha'";
$db->query($sql);
$headers = "From: Account Activation <$esender>\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
mail($email, $subj, $message, $headers);
}
}
echo "