Affiliate Signup.php:
<?php
/*
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
OSC-Affiliate
Contribution based on:
Enterprise Shopping Cart
http://www.enterprisecart.com
Copyright (c) 2004 Enterprise Shopping Cart Software. Portions Copyright (c) 2001-2004 osCommerce: http://www.oscommerce.com
Released under the GNU General Public License
*/
require('includes/application_top.php');
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_AFFILIATE_SIGNUP);
if (isset($HTTP_POST_VARS['action'])) {
$a_gender = escs_db_prepare_input($HTTP_POST_VARS['a_gender']);
$a_firstname = escs_db_prepare_input($HTTP_POST_VARS['a_firstname']);
$a_lastname = escs_db_prepare_input($HTTP_POST_VARS['a_lastname']);
$a_dob = escs_db_prepare_input($HTTP_POST_VARS['a_dob']);
$a_email_address = escs_db_prepare_input($HTTP_POST_VARS['a_email_address']);
$a_company = escs_db_prepare_input($HTTP_POST_VARS['a_company']);
$a_company_taxid = escs_db_prepare_input($HTTP_POST_VARS['a_company_taxid']);
$a_payment_check = escs_db_prepare_input($HTTP_POST_VARS['a_payment_check']);
$a_payment_paypal = escs_db_prepare_input($HTTP_POST_VARS['a_payment_paypal']);
$a_payment_bank_name = escs_db_prepare_input($HTTP_POST_VARS['a_payment_bank_name']);
$a_payment_bank_branch_number = escs_db_prepare_input($HTTP_POST_VARS['a_payment_bank_branch_number']);
$a_payment_bank_swift_code = escs_db_prepare_input($HTTP_POST_VARS['a_payment_bank_swift_code']);
$a_payment_bank_account_name = escs_db_prepare_input($HTTP_POST_VARS['a_payment_bank_account_name']);
$a_payment_bank_account_number = escs_db_prepare_input($HTTP_POST_VARS['a_payment_bank_account_number']);
$a_street_address = escs_db_prepare_input($HTTP_POST_VARS['a_street_address']);
$a_suburb = escs_db_prepare_input($HTTP_POST_VARS['a_suburb']);
$a_postcode = escs_db_prepare_input($HTTP_POST_VARS['a_postcode']);
$a_city = escs_db_prepare_input($HTTP_POST_VARS['a_city']);
$a_country=escs_db_prepare_input($HTTP_POST_VARS['a_country']);
$a_zone_id = escs_db_prepare_input($HTTP_POST_VARS['a_zone_id']);
$a_state = escs_db_prepare_input($HTTP_POST_VARS['a_state']);
$a_telephone = escs_db_prepare_input($HTTP_POST_VARS['a_telephone']);
$a_fax = escs_db_prepare_input($HTTP_POST_VARS['a_fax']);
$a_homepage = escs_db_prepare_input($HTTP_POST_VARS['a_homepage']);
$a_password = escs_db_prepare_input($HTTP_POST_VARS['a_password']);
$error = false; // reset error flag
if (ACCOUNT_GENDER == 'true') {
if (($a_gender == 'm') || ($a_gender == 'f')) {
$entry_gender_error = false;
} else {
$error = true;
$entry_gender_error = true;
}
}
if (strlen($a_firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) {
$error = true;
$entry_firstname_error = true;
} else {
$entry_firstname_error = false;
}
if (strlen($a_lastname) < ENTRY_LAST_NAME_MIN_LENGTH) {
$error = true;
$entry_lastname_error = true;
} else {
$entry_lastname_error = false;
}
if (ACCOUNT_DOB == 'true') {
if (checkdate(substr(escs_date_raw($a_dob), 4, 2), substr(escs_date_raw($a_dob), 6, 2), substr(escs_date_raw($a_dob), 0, 4))) {
$entry_date_of_birth_error = false;
} else {
$error = true;
$entry_date_of_birth_error = true;
}
}
if (strlen($a_email_address) < ENTRY_EMAIL_ADDRESS_MIN_LENGTH) {
$error = true;
$entry_email_address_error = true;
} else {
$entry_email_address_error = false;
}
if (!escs_validate_email($a_email_address)) {
$error = true;
$entry_email_address_check_error = true;
} else {
$entry_email_address_check_error = false;
}
if (strlen($a_street_address) < ENTRY_STREET_ADDRESS_MIN_LENGTH) {
$error = true;
$entry_street_address_error = true;
} else {
$entry_street_address_error = false;
}
if (strlen($a_postcode) < ENTRY_POSTCODE_MIN_LENGTH) {
$error = true;
$entry_post_code_error = true;
} else {
$entry_post_code_error = false;
}
if (strlen($a_city) < ENTRY_CITY_MIN_LENGTH) {
$error = true;
$entry_city_error = true;
} else {
$entry_city_error = false;
}
if (!$a_country) {
$error = true;
$entry_country_error = true;
} else {
$entry_country_error = false;
}
if (ACCOUNT_STATE == 'true') {
if ($entry_country_error) {
$entry_state_error = true;
} else {
$a_zone_id = 0;
$entry_state_error = false;
$check_query = escs_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = '" . escs_db_input($a_country) . "'");
$check_value = escs_db_fetch_array($check_query);
$entry_state_has_zones = ($check_value['total'] > 0);
if ($entry_state_has_zones) {
$zone_query = escs_db_query("select zone_id from " . TABLE_ZONES . " where zone_country_id = '" . escs_db_input($a_country) . "' and zone_name = '" . escs_db_input($a_state) . "'");
if (escs_db_num_rows($zone_query) == 1) {
$zone_values = escs_db_fetch_array($zone_query);
$a_zone_id = $zone_values['zone_id'];
} else {
$zone_query = escs_db_query("select zone_id from " . TABLE_ZONES . " where zone_country_id = '" . escs_db_input($a_country) . "' and zone_code = '" . escs_db_input($a_state) . "'");
if (escs_db_num_rows($zone_query) == 1) {
$zone_values = escs_db_fetch_array($zone_query);
$a_zone_id = $zone_values['zone_id'];
} else {
$error = true;
$entry_state_error = true;
}
}
} else {
if (!$a_state) {
$error = true;
$entry_state_error = true;
}
}
}
}
if (strlen($a_telephone) < ENTRY_TELEPHONE_MIN_LENGTH) {
$error = true;
$entry_telephone_error = true;
} else {
$entry_telephone_error = false;
}
$passlen = strlen($a_password);
if ($passlen < ENTRY_PASSWORD_MIN_LENGTH) {
$error = true;
$entry_password_error = true;
} else {
$entry_password_error = false;
}
if ($a_password != $a_confirmation) {
$error = true;
$entry_password_error = true;
}
$check_email = escs_db_query("select affiliate_email_address from " . TABLE_AFFILIATE . " where affiliate_email_address = '" . escs_db_input($a_email_address) . "'");
if (escs_db_num_rows($check_email)) {
$error = true;
$entry_email_address_exists = true;
} else {
$entry_email_address_exists = false;
}
// Check Suburb
$entry_suburb_error = false;
// Check Fax
$entry_fax_error = false;
if (!affiliate_check_url($a_homepage)) {
$error = true;
$entry_homepage_error = true;
} else {
$entry_homepage_error = false;
}
if (!$a_agb) {
$error=true;
$entry_agb_error=true;
}
// Check Company
$entry_company_error = false;
$entry_company_taxid_error = false;
// Check Payment
$entry_payment_check_error = false;
$entry_payment_paypal_error = false;
$entry_payment_bank_name_error = false;
$entry_payment_bank_branch_number_error = false;
$entry_payment_bank_swift_code_error = false;
$entry_payment_bank_account_name_error = false;
$entry_payment_bank_account_number_error = false;
if (!$error) {
$sql_data_array = array('affiliate_firstname' => $a_firstname,
'affiliate_lastname' => $a_lastname,
'affiliate_email_address' => $a_email_address,
'affiliate_payment_check' => $a_payment_check,
'affiliate_payment_paypal' => $a_payment_paypal,
'affiliate_payment_bank_name' => $a_payment_bank_name,
'affiliate_payment_bank_branch_number' => $a_payment_bank_branch_number,
'affiliate_payment_bank_swift_code' => $a_payment_bank_swift_code,
'affiliate_payment_bank_account_name' => $a_payment_bank_account_name,
'affiliate_payment_bank_account_number' => $a_payment_bank_account_number,
'affiliate_street_address' => $a_street_address,
'affiliate_postcode' => $a_postcode,
'affiliate_city' => $a_city,
'affiliate_country_id' => $a_country,
'affiliate_telephone' => $a_telephone,
'affiliate_fax' => $a_fax,
'affiliate_homepage' => $a_homepage,
'affiliate_password' => escs_encrypt_password($a_password),
'affiliate_agb' => '1');
if (ACCOUNT_GENDER == 'true') $sql_data_array['affiliate_gender'] = $a_gender;
if (ACCOUNT_DOB == 'true') $sql_data_array['affiliate_dob'] = escs_date_raw($a_dob);
if (ACCOUNT_COMPANY == 'true') {
$sql_data_array['affiliate_company'] = $a_company;
$sql_data_array['affiliate_company_taxid'] = $a_company_taxid;
}
if (ACCOUNT_SUBURB == 'true') $sql_data_array['affiliate_suburb'] = $a_suburb;
if (ACCOUNT_STATE == 'true') {
if ($a_zone_id > 0) {
$sql_data_array['affiliate_zone_id'] = $a_zone_id;
$sql_data_array['affiliate_state'] = '';
} else {
$sql_data_array['affiliate_zone_id'] = '0';
$sql_data_array['affiliate_state'] = $a_state;
}
}
$sql_data_array['affiliate_date_account_created'] = 'now()';
$affiliate_id = affiliate_insert ($sql_data_array, $HTTP_SESSION_VARS['affiliate_ref'] );
$aemailbody = MAIL_AFFILIATE_HEADER . "\n"
. MAIL_AFFILIATE_ID . $affiliate_id . "\n"
. MAIL_AFFILIATE_USERNAME . $a_email_address . "\n"
. MAIL_AFFILIATE_PASSWORD . $a_password . "\n\n"
. MAIL_AFFILIATE_LINK
. HTTP_SERVER . DIR_WS_CATALOG . FILENAME_AFFILIATE . "\n\n"
. MAIL_AFFILIATE_FOOTER;
escs_mail($a_firstname . ' ' . $a_lastname, $a_email_address, MAIL_AFFILIATE_SUBJECT, nl2br($aemailbody), STORE_OWNER, AFFILIATE_EMAIL_ADDRESS);
escs_session_register('affiliate_id');
$affiliate_email = $a_email_address;
$affiliate_name = $a_firstname . ' ' . $a_lastname;
escs_session_register('affiliate_email');
escs_session_register('affiliate_name');
escs_redirect(escs_href_link(FILENAME_AFFILIATE_SIGNUP_OK, '', 'SSL'));
}
}
$breadcrumb->add(NAVBAR_TITLE, escs_href_link(FILENAME_AFFILIATE_SIGNUP, '', 'SSL'));
$content = affiliate_signup;
require(DIR_WS_TEMPLATES . TEMPLATENAME_MAIN_PAGE);
require(DIR_WS_INCLUDES . 'application_bottom.php');
?>
Other E Commerce Scripts:
