$commission_types = array(array("", ""), array(0, NOT_AVAILABLE_MSG), array(1, PERCENT_PER_PROD_FULL_PRICE_MSG), array(2, FIXED_AMOUNT_PER_PROD_MSG), array(3, PERCENT_PER_PROD_SELL_PRICE_MSG), array(4, PERCENT_PER_PROD_SELL_BUY_MSG));
$active_values = array(array(1, ACTIVE_MSG), array(0, INACTIVE_MSG));
$points_price_types = array(array("", ""), array(0, POINTS_NOT_ALLOWED_MSG), array(1, POINTS_ALLOWED_MSG));
$zero_price_types = array(array(0, SHOW_ZERO_PRICE_MSG), array(1, HIDE_ZERO_PRICE_MSG), array(2, SHOW_ZERO_PRICE_MESSAGE_MSG));
$zero_product_actions = array(array(1, ALLOW_ADD_ZERO_PRODUCTS_MSG), array(2, SHOW_WARNING_FOR_ZERO_PRODUCTS_MSG));
$components_list_styles = array(array(1, AS_LIST_MSG), array(2, AS_TABLE_MSG));
$show_reward_credits = array(array(0, FOR_ALL_USERS_MSG), array(1, ONLY_FOR_LOGGED_IN_USERS_MSG));
$open_large_image = array(array(0, IN_POPUP_WINDOW_MSG), array(1, IN_ACTIVE_WINDOW_MSG));
$watermark_positions = array(array("", ""), array("TL", TOP_LEFT_MSG), array("TC", TOP_CENTER_MSG), array("TR", TOP_RIGHT_MSG), array("ML", MIDDLE_LEFT_MSG), array("C", CENTER_OF_IMAGE_MSG), array("MR", MIDDLE_RIGHT_MSG), array("BL", BOTTOM_LEFT_MSG), array("BC", BOTTOM_CENTER_MSG), array("BR", BOTTOM_RIGHT_MSG), array("RND", RANDOM_POSITION_MSG));
$google_base_export_types = array(array(0, MANUALLY_DOWNLOAD_XML_FILE_MSG), array(1, USE_FTP_TO_UPLOAD_TO_GOOGLE_MSG));
// Google tmp data
$google_base_country = array(array(0, NOT_SPECIFIED_GB), array(1, US_MSG_GB), array(2, UK_DE_FR_MSG_GB), array(3, JP_MSG_GB), array(4, GOOGLE_RECOMEND_GB));
//
$prod_image_types = array(array(0, DONT_SHOW_IMAGE_MSG), array(1, IMAGE_TINY_MSG), array(2, IMAGE_SMALL_MSG), array(3, IMAGE_LARGE_MSG));
// set up parameters
$r->add_select("quantity_control_list", TEXT, $product_controls);
$r->add_select("quantity_control_table", TEXT, $product_controls);
$r->add_select("quantity_control_grid", TEXT, $product_controls);
$r->add_select("quantity_control_details", TEXT, $product_controls);
$r->add_select("quantity_control_basket", TEXT, $controls);
$r->add_radio("confirm_add", TEXT, $confirm_add);
$r->add_radio("redirect_to_cart", TEXT, $basket_actions);
$r->add_checkbox("coupons_enable", INTEGER);
$r->add_select("user_registration", TEXT, $user_registration);
$r->add_select("subscription_page", TEXT, $subscription_page);
$r->add_select("display_products", TEXT, $display_products);
$r->add_checkbox("logout_cart_clear", INTEGER);
$r->add_radio("orders_currency", TEXT, $show_currency);
// run php code
$r->add_checkbox("php_in_products_short_desc", INTEGER);
$r->add_checkbox("php_in_products_full_desc", INTEGER);
$r->errors = $order_errors;
if ($payment_error == 1) {
$r->errors .= $error_message;
}
$r->add_where("order_id", INTEGER);
$r->add_textbox("cc_name", TEXT, CC_NAME_FIELD);
$r->add_textbox("cc_first_name", TEXT, CC_FIRST_NAME_FIELD);
$r->add_textbox("cc_last_name", TEXT, CC_LAST_NAME_FIELD);
$r->add_textbox("cc_number", TEXT, CC_NUMBER_FIELD);
$r->parameters["cc_number"][MIN_LENGTH] = 10;
$r->add_textbox("cc_start_date", DATETIME, CC_START_DATE_FIELD);
$r->change_property("cc_start_date", VALUE_MASK, array("MM", " / ", "YYYY"));
$r->add_textbox("cc_expiry_date", DATETIME, CC_EXPIRY_DATE_FIELD);
$r->change_property("cc_expiry_date", VALUE_MASK, array("MM", " / ", "YYYY"));
$credit_cards = get_db_values("SELECT credit_card_id, credit_card_name FROM " . $table_prefix . "credit_cards", array(array("", PLEASE_CHOOSE_MSG)));
$r->add_select("cc_type", INTEGER, $credit_cards, CC_TYPE_FIELD);
$issue_numbers = get_db_values("SELECT issue_number AS issue_value, issue_number AS issue_description FROM " . $table_prefix . "issue_numbers", array(array("", NOT_AVAILABLE_MSG)));
$r->add_select("cc_issue_number", INTEGER, $issue_numbers, CC_ISSUE_NUMBER_FIELD);
$r->add_textbox("cc_security_code", TEXT, CC_SECURITY_CODE_FIELD);
$r->add_textbox("pay_without_cc", TEXT, PAY_WITHOUT_CC_FIELD);
// 3D fields
$r->add_textbox("secure_3d_check", TEXT);
$r->add_textbox("secure_3d_status", TEXT);
$r->add_textbox("secure_3d_md", TEXT);
$r->add_textbox("secure_3d_xid", TEXT);
$r->add_textbox("secure_3d_eci", TEXT);
$r->add_textbox("secure_3d_cavv", TEXT);
$parameters_number = 0;
for ($i = 0; $i < sizeof($cc_parameters); $i++) {
$show_param = "show_" . $cc_parameters[$i];
if (isset($cc_info[$show_param]) && $cc_info[$show_param] == 1) {
$r->change_property("s_ne", TRIM, true);
$r->add_textbox("s_kw", TEXT);
$r->change_property("s_kw", TRIM, true);
$r->add_textbox("s_coupon", TEXT);
$r->change_property("s_coupon", TRIM, true);
$r->add_textbox("s_sku", TEXT);
$r->change_property("s_sku", TRIM, true);
$r->add_textbox("s_sd", DATE, FROM_DATE_MSG);
$r->change_property("s_sd", VALUE_MASK, $date_edit_format);
$r->change_property("s_sd", TRIM, true);
$r->add_textbox("s_ed", DATE, END_DATE_MSG);
$r->change_property("s_ed", VALUE_MASK, $date_edit_format);
$r->change_property("s_ed", TRIM, true);
$r->add_checkboxlist("s_os_list", INTEGER, $order_statuses);
array_unshift($order_statuses, array("", ""));
$r->add_select("s_os", INTEGER, $order_statuses);
$r->add_select("s_ci", TEXT, $countries);
$r->add_select("s_category", TEXT, $categories);
//Customization by Vital
$r->add_select("s_si", TEXT, $states);
$r->add_select("s_cct", TEXT, $credit_card_types);
$r->add_select("s_ex", TEXT, $export_options);
if ($sitelist) {
$r->add_select("s_sti", TEXT, $sites);
}
$r->get_form_parameters();
$r->validate();
$where = "";
$product_search = false;
if (!$r->errors) {
if (!$r->is_empty("s_on")) {
$r->change_property("affiliate_code_info", COLUMN_NAME, "affiliate_code");
if (!$affiliate_join) {
$r->change_property("affiliate_code_info", SHOW, false);
}
$login_params = array("affiliate_code_info");
$affiliate_code_name = "affiliate_code_info";
}
}
} elseif ($section_code == "personal") {
$r->add_textbox("name", TEXT, $section_name . ": " . NAME_MSG);
$r->change_property("name", USE_SQL_NULL, false);
$r->add_textbox("first_name", TEXT, $section_name . ": " . FIRST_NAME_FIELD);
$r->change_property("first_name", USE_SQL_NULL, false);
$r->add_textbox("last_name", TEXT, $section_name . ": " . LAST_NAME_FIELD);
$r->change_property("last_name", USE_SQL_NULL, false);
$r->add_select("company_id", INTEGER, $companies, $section_name . ": " . COMPANY_SELECT_FIELD);
$r->add_textbox("company_name", TEXT, $section_name . ": " . COMPANY_NAME_FIELD);
$r->add_textbox("email", TEXT, $section_name . ": " . EMAIL_FIELD);
$r->change_property("email", USE_SQL_NULL, false);
$r->change_property("email", REGEXP_MASK, EMAIL_REGEXP);
$r->change_property("email", UNIQUE, true);
$r->add_textbox("address1", TEXT, $section_name . ": " . STREET_FIRST_FIELD);
$r->add_textbox("address2", TEXT, $section_name . ": " . STREET_SECOND_FIELD);
$r->add_textbox("city", TEXT, $section_name . ": " . CITY_FIELD);
$r->add_textbox("province", TEXT, $section_name . ": " . PROVINCE_FIELD);
$r->add_select("state_id", INTEGER, $states, $section_name . ": " . STATE_FIELD);
$r->change_property("state_id", USE_SQL_NULL, false);
$r->add_textbox("state_code", TEXT);
$r->change_property("state_code", USE_SQL_NULL, false);
$r->add_textbox("zip", TEXT, $section_name . ": " . ZIP_FIELD);
$r->add_select("country_id", INTEGER, $countries, $section_name . ": " . COUNTRY_FIELD);
$r->add_textbox("total_points_amount", NUMBER);
$r->add_textbox("total_reward_points", NUMBER);
$r->add_textbox("total_reward_credits", NUMBER);
$r->add_textbox("order_placed_date", DATETIME);
$companies = get_db_values("SELECT company_id,company_name FROM " . $table_prefix . "companies ", array(array("", SELECT_COMPANY_MSG)));
$states = get_db_values("SELECT state_id,state_name FROM " . $table_prefix . "states WHERE show_for_user=1 ORDER BY state_name ", array(array("", SELECT_STATE_MSG)));
$countries = get_db_values("SELECT country_id,country_name FROM " . $table_prefix . "countries WHERE show_for_user=1 ORDER BY country_order, country_name ", array(array("", SELECT_COUNTRY_MSG)));
// get phone codes
$phone_codes = get_phone_codes();
$r->add_textbox("name", TEXT, NAME_MSG);
$r->change_property("name", USE_SQL_NULL, false);
$r->add_textbox("first_name", TEXT, FIRST_NAME_FIELD);
$r->change_property("first_name", USE_SQL_NULL, false);
$r->add_textbox("last_name", TEXT, LAST_NAME_FIELD);
$r->change_property("last_name", USE_SQL_NULL, false);
$r->add_select("company_id", INTEGER, $companies, COMPANY_SELECT_FIELD);
$r->add_textbox("company_name", TEXT, COMPANY_NAME_FIELD);
$r->add_textbox("email", TEXT, EMAIL_FIELD);
$r->change_property("email", USE_SQL_NULL, false);
$r->change_property("email", REGEXP_MASK, EMAIL_REGEXP);
$r->add_textbox("address1", TEXT, STREET_FIRST_FIELD);
$r->add_textbox("address2", TEXT, STREET_SECOND_FIELD);
$r->add_textbox("city", TEXT, CITY_FIELD);
$r->add_textbox("province", TEXT, PROVINCE_FIELD);
$r->add_select("state_id", INTEGER, $states, STATE_FIELD);
$r->change_property("state_id", USE_SQL_NULL, false);
$r->add_textbox("state_code", TEXT);
$r->add_textbox("zip", TEXT, ZIP_FIELD);
$r->add_select("country_id", INTEGER, $countries, COUNTRY_FIELD);
$r->change_property("country_id", USE_SQL_NULL, false);
$r->add_textbox("country_code", TEXT);
