<?php
/*
  $Id: create_account.html,v 1.65 2003/06/09 23:03:54 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/

  require('includes/application_top.html');


  if ($session_started == false) {
    //tep_redirect(tep_href_link(FILENAME_COOKIE_USAGE));
  }
if($_SERVER['SERVER_PORT'] == 80 && ENABLE_SSL === true) {
    header("Location: https://{$_SERVER['HTTP_HOST']}{$_SERVER['REQUEST_URI']}"); exit;
  }

// needs to be included earlier to set the success message in the messageStack
  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATE_ACCOUNT);

  $process = false;
  // +Country-State Selector
  $refresh = false;
  if (isset($HTTP_POST_VARS['action']) && (($HTTP_POST_VARS['action'] == 'process') || ($HTTP_POST_VARS['action'] == 'refresh'))) {
    if ($HTTP_POST_VARS['action'] == 'process')  $process = true;
	 if ($HTTP_POST_VARS['action'] == 'refresh') $refresh = true;
  // -Country-State Selector

    if (ACCOUNT_GENDER == 'true') {
      if (isset($HTTP_POST_VARS['gender'])) {
        $gender = tep_db_prepare_input($HTTP_POST_VARS['gender']);
      } else {
        $gender = false;
      }
    }
    $firstname = tep_db_prepare_input($HTTP_POST_VARS['firstname']);
    $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);
    if (ACCOUNT_DOB == 'true') $dob = tep_db_prepare_input($HTTP_POST_VARS['dob']);
    $email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']);
    if (ACCOUNT_COMPANY == 'true') $company = tep_db_prepare_input($HTTP_POST_VARS['company']);
    $street_address = tep_db_prepare_input($HTTP_POST_VARS['street_address']);
    $street_address2 = tep_db_prepare_input($HTTP_POST_VARS['street_address2']);
    if (ACCOUNT_SUBURB == 'true') $suburb = tep_db_prepare_input($HTTP_POST_VARS['suburb']);
    $postcode = tep_db_prepare_input($HTTP_POST_VARS['postcode']);
    $city = tep_db_prepare_input($HTTP_POST_VARS['city']);
    if (ACCOUNT_STATE == 'true') {
      $state = tep_db_prepare_input($HTTP_POST_VARS['state']);
      if (isset($HTTP_POST_VARS['zone_id'])) {
        $zone_id = tep_db_prepare_input($HTTP_POST_VARS['zone_id']);
      } else {
        $zone_id = false;
      }
    }
    $country = tep_db_prepare_input($HTTP_POST_VARS['country']);
    $telephone = tep_db_prepare_input($HTTP_POST_VARS['telephone']);
    $fax = tep_db_prepare_input($HTTP_POST_VARS['fax']);

    if (isset($HTTP_POST_VARS['newsletter'])) {
      $newsletter = tep_db_prepare_input($HTTP_POST_VARS['newsletter']);
    } else {
      $newsletter = false;
    }
    if (isset($HTTP_POST_VARS['customers_referral'])) {
      $customers_referral = tep_db_prepare_input($HTTP_POST_VARS['customers_referral']);
    } else {
      $customers_referral = false;
    }

    $password = tep_db_prepare_input($HTTP_POST_VARS['password']);
    $confirmation = tep_db_prepare_input($HTTP_POST_VARS['confirmation']);

    // +Country-State Selector
    if ($process) {
    // -Country-State Selector
    $error = false;

    if (ACCOUNT_GENDER == 'true') {
      if ( ($gender != 'm') && ($gender != 'f') ) {
        $error = true;

        $messageStack->add('create_account', ENTRY_GENDER_ERROR);
      }
    }

    if (strlen($firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) {
      $error = true;

      $messageStack->add('create_account', ENTRY_FIRST_NAME_ERROR);
    }

    if (strlen($lastname) < ENTRY_LAST_NAME_MIN_LENGTH) {
      $error = true;

      $messageStack->add('create_account', ENTRY_LAST_NAME_ERROR);
    }

    if (ACCOUNT_DOB == 'true') {
      if (checkdate(substr(tep_date_raw($dob), 4, 2), substr(tep_date_raw($dob), 6, 2), substr(tep_date_raw($dob), 0, 4)) == false) {
        $error = true;

        $messageStack->add('create_account', ENTRY_DATE_OF_BIRTH_ERROR);
      }
    }

    if (strlen($email_address) < ENTRY_EMAIL_ADDRESS_MIN_LENGTH) {
      $error = true;

      $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR);
    } elseif (tep_validate_email($email_address) == false) {
      $error = true;

      $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_CHECK_ERROR);
    } else {
      $check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
      $check_email = tep_db_fetch_array($check_email_query);
      if ($check_email['total'] > 0) {
        $error = true;

        $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS);
      }
    }

    if (strlen($street_address) < ENTRY_STREET_ADDRESS_MIN_LENGTH) {
      $error = true;

      $messageStack->add('create_account', ENTRY_STREET_ADDRESS_ERROR);
    }

    if (strlen($postcode) < ENTRY_POSTCODE_MIN_LENGTH) {
      $error = true;

      $messageStack->add('create_account', ENTRY_POST_CODE_ERROR);
    }

    if (strlen($city) < ENTRY_CITY_MIN_LENGTH) {
      $error = true;

      $messageStack->add('create_account', ENTRY_CITY_ERROR);
    }

    if (is_numeric($country) == false) {
      $error = true;

      $messageStack->add('create_account', ENTRY_COUNTRY_ERROR);
    }

    if (ACCOUNT_STATE == 'true') {
      // +Country-State Selector
      if ($zone_id == 0) {
      // -Country-State Selector
        if (strlen($state) < ENTRY_STATE_MIN_LENGTH) {
          $error = true;

          $messageStack->add('create_account', ENTRY_STATE_ERROR);
        }
      }
    }

    if (strlen($telephone) < '0') {
     $error = true;

      $messageStack->add('create_account', ENTRY_TELEPHONE_NUMBER_ERROR);
    }

    if (strlen($fax) < ENTRY_FAX_MIN_LENGTH) {
      $error = true;

      $messageStack->add('create_account', ENTRY_FAX_NUMBER_ERROR);
    }

    if (strlen($password) < ENTRY_PASSWORD_MIN_LENGTH) {
      $error = true;

      $messageStack->add('create_account', ENTRY_PASSWORD_ERROR);
    } elseif ($password != $confirmation) {
      $error = true;

      $messageStack->add('create_account', ENTRY_PASSWORD_ERROR_NOT_MATCHING);
    }

    if ($error == false) {
      $sql_data_array = array('customers_firstname' => $firstname,
                              'customers_lastname' => $lastname,
                              'customers_email_address' => $email_address,
                              'customers_telephone' => $telephone,
                              'customers_fax' => $fax,
                              'customers_newsletter' => $newsletter,
                              'customers_referral' => $customers_referral,
                              'customers_password' => tep_encrypt_password($password));

      if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $gender;
      if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($dob);

	//hack here Rich - 2019-05-26 - check where post comes from
	if ($_SERVER['REQUEST_URI'] != "/create_account.html")
	{
		echo '<h2>Unknown Error 1</h2>';
		echo '<p><a href="create_account.html">Try Again</a></p>';
		exit();
	} 
	//hack here Rich - 2019-05-26 - check where post comes from

	//hack here Rich - 2019-05-26 - check if email contains rr.com
	$pos = strpos($email_address, ".rr.com");
	$pos2 = strpos($email_address, "mail.ru");
	$pos3 = strpos($email_address, "bieweryorkis.de");
	$pos4 = strpos($email_address, "wanadoo.fr");
	$pos5 = strpos($email_address, "yandex.ru");
	$pos6 = strpos($email_address, "yandex.com");
	$pos7 = strpos($email_address, "taidar.ru");
	$pos8 = strpos($email_address, "mmry.ru");
	$pos9 = strpos($email_address, "@mail.com");
	
	if (strripos($email_address, "angelajanel") !== false) {
		echo '<h2>Unknown Error 3</h2>';
		echo '<p><a href="create_account.html">Try Again</a></p>';
		exit();
	}

	//echo "[$pos][" . $_SERVER['REMOTE_ADDR'] . "]";

	if ($pos OR $pos2 OR $pos3 OR $pos4 OR $pos5 OR $pos6 OR $pos7 OR $pos8 OR $pos9)
	{
		echo '<h2>Unknown Error 2</h2>';
		echo '<p><a href="create_account.html">Try Again</a></p>';
		exit();
	} 
	//hack here Rich - 2019-05-26 - check if email contains rr.com


	//hack here Rich - 2019-05-26 - check if account IP has already been used START

	$customer_ip = $_SERVER['REMOTE_ADDR'];

	$sql = "SELECT CustID 
			FROM customers_ips 
			WHERE customer_ip = '$customer_ip' 
			LIMIT 1";

	$results = tep_db_query($sql);

	$NumberRows = mysql_num_rows($results);

	/*if ($NumberRows)
	{
		echo '<h2>Unknown Error 3</h2>';
		echo '<p><a href="create_account.html">Try Again</a></p>';
		exit();
	}*/

	//hack here Rich - 2019-05-26 - check if account IP has already been used FINI
	
	
	//matt's check for "google" company START
	if($company == "google"){
		echo '<h2>Unknown Error 4</h2>';
		echo '<p><a href="create_account.html">Try Again</a></p>';
		exit();
	}
	//matt's check for "google" company END
	
	
	//matt's check for recaptcha scores START
	if (isset($_POST['recaptcha_response'])) {
		// Build POST request:
		$recaptcha_url = 'https://www.google.com/recaptcha/api/siteverify';
		$recaptcha_secret = '6LclKKYUAAAAAG0heIDElmUuw0zAlsUJXkM730PJ';
		$recaptcha_response = $_POST['recaptcha_response'];
		// Make and decode POST request:
		
		$ch = curl_init();

		curl_setopt_array($ch, [
			CURLOPT_URL => 'https://www.google.com/recaptcha/api/siteverify',
			CURLOPT_POST => true,
			CURLOPT_POSTFIELDS => [
				'secret' => $recaptcha_secret,
				'response' => $recaptcha_response,
				'remoteip' => $_SERVER['REMOTE_ADDR']
			],
			CURLOPT_RETURNTRANSFER => true
		]);

		$output = curl_exec($ch);
		curl_close($ch);

		$json = json_decode($output);
		
		if ($json->score >= 0.4) {
			//score is good so proceed
		} else {
			echo '<h2>There was a problem with your submission. Please contact us for assistance. [1]['.$json->score.']</h2>';
			echo '<p>Telephone: 1-856 424-4818 or 1-800 320-1510</p>';
			echo '<p>Customer Service E-mail: <a href="mailto:service@garrettspecialties.com">service@garrettspecialties.com</a></p>';
			echo '<p><a href="create_account.html">Try Again</a></p>';
			exit();
		}
	}else{
		echo '<h2>There was a problem with your submission. Please contact us for assistance. [2]</h2>';
		echo '<p>Telephone: 1-856 424-4818 or 1-800 320-1510</p>';
		echo '<p>Customer Service E-mail: <a href="mailto:service@garrettspecialties.com">service@garrettspecialties.com</a></p>';
		echo '<p><a href="create_account.html">Try Again</a></p>';
		exit();
	}
	//matt's check for recaptcha scores END


	  tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);

      $customer_id = tep_db_insert_id();


//Insert IP to new table START

	$sql = "INSERT INTO `customers_ips` (
			`CustID`, 
			`customers_id`, 
			`customer_ip`) 
		VALUES ('', 
				'$customer_id', 
				'$customer_ip'
	)";


	//$results = tep_db_query($sql);

//Insert IP to new table FINI


      $sql_data_array = array('customers_id' => $customer_id,
                              'entry_firstname' => $firstname,
                              'entry_lastname' => $lastname,
                              'entry_street_address' => $street_address,
                              'entry_street_address2' => $street_address2,
                              'entry_postcode' => $postcode,
                              'entry_city' => $city,
                              'entry_country_id' => $country);

      if (ACCOUNT_GENDER == 'true') $sql_data_array['entry_gender'] = $gender;
      if (ACCOUNT_COMPANY == 'true') $sql_data_array['entry_company'] = $company;
      if (ACCOUNT_SUBURB == 'true') $sql_data_array['entry_suburb'] = $suburb;
      if (ACCOUNT_STATE == 'true') {
        if ($zone_id > 0) {
          $sql_data_array['entry_zone_id'] = $zone_id;
          $sql_data_array['entry_state'] = '';
        } else {
          $sql_data_array['entry_zone_id'] = '0';
          $sql_data_array['entry_state'] = $state;
        }
      }

      tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);

      $address_id = tep_db_insert_id();

      tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$address_id . "' where customers_id = '" . (int)$customer_id . "'");

      tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int)$customer_id . "', '0', now())");

      if (SESSION_RECREATE == 'True') {
        tep_session_recreate();
      }

      $customer_first_name = $firstname;
      $customer_default_address_id = $address_id;
      $customer_country_id = $country;
      $customer_zone_id = $zone_id;
      tep_session_register('customer_id');
      tep_session_register('customer_first_name');
      tep_session_register('customer_default_address_id');
      tep_session_register('customer_country_id');
      tep_session_register('customer_zone_id');


// restore cart contents
      $cart->restore_contents();

// build the message content
      $name = $firstname . ' ' . $lastname;

      if (ACCOUNT_GENDER == 'true') {
         if ($gender == 'm') {
           $email_text = sprintf(EMAIL_GREET_MR, $lastname);
         } else {
           $email_text = sprintf(EMAIL_GREET_MS, $lastname);
         }
      } else {
        $email_text = sprintf(EMAIL_GREET_NONE, $firstname);
      }

      $email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;
      tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);      
      tep_mail('Arleen Harry', 'aharry@garrettspecialties.com', 'New Account Created', "$name, $email_address, has created an account", STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, "\r\n");  
      tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT_SUCCESS, '', 'SSL'));
    }
  }

  // +Country-State Selector
 }
 if ($HTTP_POST_VARS['action'] == 'refresh') {$state = '';}
 if (!isset($country)) $country = DEFAULT_COUNTRY;
 // -Country-State Selector

 $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CREATE_ACCOUNT,   '', 'SSL'));
  require('includes/categories_sidebar.php');
 require('templates/create_account.tpl.php');
 require(DIR_WS_INCLUDES . 'application_bottom.html');
?>