if (ACCOUNT_DOB == 'true') $sql_data_array['affiliate_dob'] = smn_date_raw($affiliate_dob);
                    if (ACCOUNT_GENDER == 'true') $sql_data_array['affiliate_gender'] = $affiliate_gender;
                    if (ACCOUNT_COMPANY == 'true') {
                      $sql_data_array['affiliate_company'] = $affiliate_company;
                      $sql_data_array['affiliate_company_taxid'] =  $affiliate_company_taxid;
                    }
                    if (ACCOUNT_SUBURB == 'true') $sql_data_array['affiliate_suburb'] = $affiliate_suburb;
                    if (ACCOUNT_STATE == 'true') {
                      $sql_data_array['affiliate_state'] = $affiliate_state;
                      $sql_data_array['affiliate_zone_id'] = $affiliate_zone_id;
                    }
            
                    $sql_data_array['affiliate_date_account_last_modified'] = 'now()';*/
            $sql_data_array = array('affiliate_payment_check' => $affiliate_payment_check, 'affiliate_payment_paypal' => $affiliate_payment_paypal, 'affiliate_payment_bank_name' => $affiliate_payment_bank_name, 'affiliate_payment_bank_branch_number' => $affiliate_payment_bank_branch_number, 'affiliate_payment_bank_swift_code' => $affiliate_payment_bank_swift_code, 'affiliate_payment_bank_account_name' => $affiliate_payment_bank_account_name, 'affiliate_payment_bank_account_number' => $affiliate_payment_bank_account_number, 'affiliate_homepage' => $affiliate_homepage, 'affiliate_commission_percent' => $affiliate_commission_percent, 'affiliate_agb' => '1');
            if (ACCOUNT_COMPANY == 'true') {
                $sql_data_array['affiliate_company_taxid'] = $affiliate_company_taxid;
            }
            smn_db_perform(TABLE_AFFILIATE, $sql_data_array, 'update', "affiliate_id = '" . smn_db_input($affiliate_id) . "'");
            smn_redirect(smn_href_link(FILENAME_AFFILIATE, smn_get_all_get_params(array('acID', 'action')) . 'acID=' . $affiliate_id));
            break;
        case 'deleteconfirm':
            $affiliate_id = smn_db_prepare_input($_GET['acID']);
            affiliate_delete(smn_db_input($affiliate_id));
            smn_redirect(smn_href_link(FILENAME_AFFILIATE, smn_get_all_get_params(array('acID', 'action'))));
            break;
    }
}
$content_page = basename($_SERVER['PHP_SELF']);
require 'templates/default/layout.php';
require DIR_WS_INCLUDES . 'application_bottom.php';
                $sql_data_array['affiliate_company_taxid'] = $affiliate_company_taxid;
            }
            if (ACCOUNT_SUBURB == 'true') {
                $sql_data_array['affiliate_suburb'] = $affiliate_suburb;
            }
            if (ACCOUNT_STATE == 'true') {
                $sql_data_array['affiliate_state'] = $affiliate_state;
                $sql_data_array['affiliate_zone_id'] = $affiliate_zone_id;
            }
            $sql_data_array['affiliate_date_account_last_modified'] = 'now()';
            xtc_db_perform(TABLE_AFFILIATE, $sql_data_array, 'update', "affiliate_id = '" . xtc_db_input($affiliate_id) . "'");
            xtc_redirect(xtc_href_link(FILENAME_AFFILIATE, xtc_get_all_get_params(array('acID', 'action')) . 'acID=' . $affiliate_id));
            break;
        case 'deleteconfirm':
            $affiliate_id = xtc_db_prepare_input($_GET['acID']);
            affiliate_delete(xtc_db_input($affiliate_id));
            xtc_redirect(xtc_href_link(FILENAME_AFFILIATE, xtc_get_all_get_params(array('acID', 'action'))));
            break;
    }
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php 
echo HTML_PARAMS;
?>
>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php 
echo $_SESSION['language_charset'];
?>
">
                $sql_data_array['affiliate_company_taxid'] = $affiliate_company_taxid;
            }
            if (ACCOUNT_SUBURB == 'true') {
                $sql_data_array['affiliate_suburb'] = $affiliate_suburb;
            }
            if (ACCOUNT_STATE == 'true') {
                $sql_data_array['affiliate_state'] = $affiliate_state;
                $sql_data_array['affiliate_zone_id'] = $affiliate_zone_id;
            }
            $sql_data_array['affiliate_date_account_last_modified'] = 'now()';
            tep_db_perform(TABLE_AFFILIATE, $sql_data_array, 'update', "affiliate_id = '" . tep_db_input($affiliate_id) . "'");
            tep_redirect(tep_href_link(FILENAME_AFFILIATE, tep_get_all_get_params(array('acID', 'action')) . 'acID=' . $affiliate_id));
            break;
        case 'deleteconfirm':
            $affiliate_id = tep_db_prepare_input($HTTP_GET_VARS['acID']);
            affiliate_delete(tep_db_input($affiliate_id));
            tep_redirect(tep_href_link(FILENAME_AFFILIATE, tep_get_all_get_params(array('acID', 'action'))));
            break;
    }
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php 
echo HTML_PARAMS;
?>
>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php 
echo CHARSET;
?>
">
                $sql_data_array['affiliate_company_taxid'] = $affiliate_company_taxid;
            }
            if (ACCOUNT_SUBURB == 'true') {
                $sql_data_array['affiliate_suburb'] = $affiliate_suburb;
            }
            if (ACCOUNT_STATE == 'true') {
                $sql_data_array['affiliate_state'] = $affiliate_state;
                $sql_data_array['affiliate_zone_id'] = $affiliate_zone_id;
            }
            $sql_data_array['affiliate_date_account_last_modified'] = 'now()';
            vam_db_perform(TABLE_AFFILIATE, $sql_data_array, 'update', "affiliate_id = '" . vam_db_input($affiliate_id) . "'");
            vam_redirect(vam_href_link(FILENAME_AFFILIATE, vam_get_all_get_params(array('acID', 'action')) . 'acID=' . $affiliate_id));
            break;
        case 'deleteconfirm':
            $affiliate_id = vam_db_prepare_input($_GET['acID']);
            affiliate_delete(vam_db_input($affiliate_id));
            vam_redirect(vam_href_link(FILENAME_AFFILIATE, vam_get_all_get_params(array('acID', 'action'))));
            break;
    }
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html <?php 
echo HTML_PARAMS;
?>
>
<head>
<meta http-equiv="Content-Type" content="text/html; charset="<?php 
echo $_SESSION['language_charset'];
?>
">