function affiliate_insert($sql_data_array, $affiliate_parent = 0) { // LOCK TABLES smn_db_query("LOCK TABLES " . TABLE_AFFILIATE . " WRITE"); if ($affiliate_parent > 0) { $affiliate_root_query = smn_db_query("select affiliate_root, affiliate_rgt, affiliate_lft�from " . TABLE_AFFILIATE . " where affiliate_id = '" . $affiliate_parent . "' "); // Check if we have a parent affiliate if ($affiliate_root_array = smn_db_fetch_array($affiliate_root_query)) { smn_db_query("update " . TABLE_AFFILIATE . " SET affiliate_lft = affiliate_lft + 2 WHERE affiliate_root = '" . $affiliate_root_array['affiliate_root'] . "' and affiliate_lft > " . $affiliate_root_array['affiliate_rgt'] . " AND affiliate_rgt >= " . $affiliate_root_array['affiliate_rgt'] . " "); smn_db_query("update " . TABLE_AFFILIATE . " SET affiliate_rgt = affiliate_rgt + 2 WHERE affiliate_root = '" . $affiliate_root_array['affiliate_root'] . "' and affiliate_rgt >= " . $affiliate_root_array['affiliate_rgt'] . " "); $sql_data_array['affiliate_root'] = $affiliate_root_array['affiliate_root']; $sql_data_array['affiliate_lft'] = $affiliate_root_array['affiliate_rgt']; $sql_data_array['affiliate_rgt'] = $affiliate_root_array['affiliate_rgt'] + 1; smn_db_perform(TABLE_AFFILIATE, $sql_data_array); $affiliate_id = smn_db_insert_id(); } // no parent -> new root } else { $sql_data_array['affiliate_lft'] = '1'; $sql_data_array['affiliate_rgt'] = '2'; smn_db_perform(TABLE_AFFILIATE, $sql_data_array); $affiliate_id = smn_db_insert_id(); smn_db_query("update " . TABLE_AFFILIATE . " set affiliate_root = '" . $affiliate_id . "' where affiliate_id = '" . $affiliate_id . "' "); } // UNLOCK TABLES smn_db_query("UNLOCK TABLES"); return $affiliate_id; }
function create($customers_id = 0) { //if customer is 0, then is a new account...(needs to be added in for editing) //add data for table customers which hold most of the primary customers info $sql_data_array = array('customers_firstname' => $this->firstname, 'customers_lastname' => $this->lastname, 'customers_email_address' => $this->email_address, 'customers_telephone' => $this->telephone, 'customers_fax' => $this->fax, 'customers_newsletter' => $this->newsletter, 'customers_gender' => $this->gender, 'customers_dob' => $this->dob); if ($customers_id == 0) { $sql_data_array['customers_password'] = $this->password; smn_db_perform(TABLE_CUSTOMERS, $sql_data_array); $this->customer_id = smn_db_insert_id(); //primary KEY for customer } else { smn_db_perform(TABLE_CUSTOMERS, $sql_data_array, 'update', 'customers_id=' . (int) $customers_id); $this->customer_id = (int) $customers_id; } //start building array for adress book entries using the default address given on sign up $sql_data_array = array('customers_id' => $this->customer_id, 'entry_firstname' => $this->firstname, 'entry_lastname' => $this->lastname, 'entry_company' => $this->company, 'entry_street_address' => $this->street_address, 'entry_postcode' => $this->postcode, 'entry_city' => $this->city, 'entry_country_id' => $this->country_id, 'entry_gender' => $this->gender, 'entry_zone_id' => $this->zone_id, 'entry_state' => $this->state); if ($customers_id == 0) { smn_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array); $this->address_id = smn_db_insert_id(); smn_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int) $this->address_id . "' where customers_id = '" . (int) $this->customer_id . "'"); smn_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int) $this->customer_id . "', '0', now())"); } else { smn_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array, 'update', 'customers_id=' . (int) $customers_id); smn_db_query("update " . TABLE_CUSTOMERS_INFO . " set customers_info_date_account_last_modified = now() where customers_info_id = '" . (int) $customer_id . "'"); } if (SESSION_RECREATE == 'True') { smn_session_recreate(); } return $this->customer_id; }
function create_store($use_store_id = 0) { $this->store_id = $use_store_id; $sql_store_array = array('customer_id' => $this->get_customers_id(), 'store_status' => DISPLAY_STORE_IMMEDIATELY == 'true' ? 1 : 0, 'date_added' => date('Ymd'), 'store_type' => $this->store_type); if ($this->store_id == 0) { smn_db_perform(TABLE_STORE_MAIN, $sql_store_array); $this->store_id = smn_db_insert_id(); return $this->store_id; } else { smn_db_perform(TABLE_STORE_MAIN, $sql_store_array, 'update', 'store_id=' . $this->store_id); return $this->store_id; } }
$value_name = smn_db_prepare_input($value_name_array[$languages[$i]['id']]); smn_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . " (store_id, products_options_values_id, language_id, products_options_values_name) values ('" . (int) $store_id . "', '" . (int) $value_id . "', '" . (int) $languages[$i]['id'] . "', '" . smn_db_input($value_name) . "')"); } smn_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " (store_id, products_options_id, products_options_values_id) values ('" . (int) $store_id . "', '" . (int) $option_id . "', '" . (int) $value_id . "')"); smn_redirect(smn_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'add_product_attributes': $products_id = smn_db_prepare_input($_POST['products_id']); $options_id = smn_db_prepare_input($_POST['options_id']); $values_id = smn_db_prepare_input($_POST['values_id']); $value_price = smn_db_prepare_input($_POST['value_price']); $price_prefix = smn_db_prepare_input($_POST['price_prefix']); $sort_order = smn_db_prepare_input($_POST['sort_order']); smn_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('" . (int) $store_id . "', null, '" . (int) $products_id . "', '" . (int) $options_id . "', '" . (int) $values_id . "', '" . (double) smn_db_input($value_price) . "', '" . smn_db_input($price_prefix) . "', '" . (int) $sort_order . "')"); if (DOWNLOAD_ENABLED == 'true') { $products_attributes_id = smn_db_insert_id(); $products_attributes_filename = smn_db_prepare_input($_POST['products_attributes_filename']); $products_attributes_maxdays = smn_db_prepare_input($_POST['products_attributes_maxdays']); $products_attributes_maxcount = smn_db_prepare_input($_POST['products_attributes_maxcount']); if (smn_not_null($products_attributes_filename)) { smn_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " values ('" . (int) $store_id . "', " . (int) $products_attributes_id . ", '" . smn_db_input($products_attributes_filename) . "', '" . smn_db_input($products_attributes_maxdays) . "', '" . smn_db_input($products_attributes_maxcount) . "')"); } } smn_redirect(smn_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info)); break; case 'update_option_name': $option_name_array = $_POST['option_name']; $option_id = smn_db_prepare_input($_POST['option_id']); for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { $option_name = smn_db_prepare_input($option_name_array[$languages[$i]['id']]); smn_db_query("update " . TABLE_PRODUCTS_OPTIONS . " set products_options_name = '" . smn_db_input($option_name) . "' where products_options_id = '" . (int) $option_id . "' and language_id = '" . (int) $languages[$i]['id'] . "' and store_id = '" . $store_id . "'");
$categories_id = smn_db_prepare_input($_POST['categories_id']); if ($_POST['copy_as'] == 'link') { if ($categories_id != $current_category_id) { $check_query = smn_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$products_id . "' and categories_id = '" . (int)$categories_id . "' and store_id = '" . $store_id . "'"); $check = smn_db_fetch_array($check_query); if ($check['total'] < '1') { smn_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (store_id, products_id, categories_id) values ('" . (int)$store_id . "', '" . (int)$products_id . "', '" . (int)$categories_id . "')"); } } else { $messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error'); } } elseif ($_POST['copy_as'] == 'duplicate') { $product_query = smn_db_query("select store_id, products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'"); $product = smn_db_fetch_array($product_query); smn_db_query("insert into " . TABLE_PRODUCTS . " (store_id, products_quantity, products_model,products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . (int)$store_id . "', '" . smn_db_input($product['products_quantity']) . "', '" . smn_db_input($product['products_model']) . "', '" . smn_db_input($product['products_image']) . "', '" . smn_db_input($product['products_price']) . "', now(), '" . smn_db_input($product['products_date_available']) . "', '" . smn_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); $dup_products_id = smn_db_insert_id(); $description_query = smn_db_query("select language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'"); while ($description = smn_db_fetch_array($description_query)) { smn_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url, products_viewed) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . smn_db_input($description['products_name']) . "', '" . smn_db_input($description['products_description']) . "', '" . smn_db_input($description['products_head_title_tag']) . "', '" . smn_db_input($description['products_head_desc_tag']) . "', '" . smn_db_input($description['products_head_keywords_tag']) . "', '" . smn_db_input($description['products_url']) . "', '0')"); } smn_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (store_id, products_id, categories_id) values ('" . (int)$store_id . "', '" . (int)$dup_products_id . "', '" . (int)$categories_id . "')"); $products_id = $dup_products_id; } if (USE_CACHE == 'true') { smn_reset_cache_block('categories'); smn_reset_cache_block('also_purchased'); } } smn_redirect(html_entity_decode(smn_href_link(FILENAME_STORE_PRODUCT_CATEGORIES, 'cPath=' . $categories_id . '&ID='.$store_id.'&pID=' . $products_id))); break; case 'new_product_preview':
$affiliate_billing_query = smn_db_query($sql); $affiliate_billing = smn_db_fetch_array($affiliate_billing_query); // Get affiliate Informations $sql = "\n SELECT a.*, c.countries_id, c.countries_name, c.countries_iso_code_2, c.countries_iso_code_3, c.address_format_id \n from " . TABLE_AFFILIATE . " a \n left join " . TABLE_ZONES . " z on (a.affiliate_zone_id = z.zone_id) \n left join " . TABLE_COUNTRIES . " c on (a.affiliate_country_id = c.countries_id)\n WHERE affiliate_id = '" . $affiliate_payment['affiliate_id'] . "' \n "; $affiliate_query = smn_db_query($sql); $affiliate = smn_db_fetch_array($affiliate_query); // Get need tax informations for the affiliate $affiliate_tax_rate = smn_get_affiliate_tax_rate(AFFILIATE_TAX_ID, $affiliate['affiliate_country_id'], $affiliate['affiliate_zone_id']); $affiliate_tax = smn_round($affiliate_billing['affiliate_payment'] * $affiliate_tax_rate / 100, 2); // Netto-Provision $affiliate_payment_total = $affiliate_billing['affiliate_payment'] + $affiliate_tax; // Bill the order $affiliate['affiliate_state'] = smn_get_zone_code($affiliate['affiliate_country_id'], $affiliate['affiliate_zone_id'], $affiliate['affiliate_state']); $sql_data_array = array('affiliate_id' => $affiliate_payment['affiliate_id'], 'affiliate_payment' => $affiliate_billing['affiliate_payment'], 'affiliate_payment_tax' => $affiliate_tax, 'affiliate_payment_total' => $affiliate_payment_total, 'affiliate_payment_date' => 'now()', 'affiliate_payment_status' => '0', 'affiliate_firstname' => $affiliate['affiliate_firstname'], 'affiliate_lastname' => $affiliate['affiliate_lastname'], 'affiliate_street_address' => $affiliate['affiliate_street_address'], 'affiliate_suburb' => $affiliate['affiliate_suburb'], 'affiliate_city' => $affiliate['affiliate_city'], 'affiliate_country' => $affiliate['countries_name'], 'affiliate_postcode' => $affiliate['affiliate_postcode'], 'affiliate_company' => $affiliate['affiliate_company'], 'affiliate_state' => $affiliate['affiliate_state'], 'affiliate_address_format_id' => $affiliate['address_format_id']); smn_db_perform(TABLE_AFFILIATE_PAYMENT, $sql_data_array); $insert_id = smn_db_insert_id(); // Set the Sales to Final State smn_db_query("update " . TABLE_AFFILIATE_SALES . " set affiliate_payment_id = '" . $insert_id . "', affiliate_billing_status = 1, affiliate_payment_date = now() where affiliate_id = '" . $affiliate_payment['affiliate_id'] . "' and affiliate_billing_status = 99"); // Notify Affiliate if (AFFILIATE_NOTIFY_AFTER_BILLING == 'true') { $check_status_query = smn_db_query("select af.affiliate_email_address, ap.affiliate_lastname, ap.affiliate_firstname, ap.affiliate_payment_status, ap.affiliate_payment_date, ap.affiliate_payment_date from " . TABLE_AFFILIATE_PAYMENT . " ap, " . TABLE_AFFILIATE . " af where affiliate_payment_id = '" . $insert_id . "' and af.affiliate_id = ap.affiliate_id "); $check_status = smn_db_fetch_array($check_status_query); $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_AFFILIATE_PAYMENT_NUMBER . ' ' . $insert_id . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . smn_catalog_href_link(FILENAME_CATALOG_AFFILIATE_PAYMENT_INFO, 'payment_id=' . $insert_id, 'NONSSL') . "\n" . EMAIL_TEXT_PAYMENT_BILLED . ' ' . smn_date_long($check_status['affiliate_payment_date']) . "\n\n" . EMAIL_TEXT_NEW_PAYMENT; smn_mail($check_status['affiliate_firstname'] . ' ' . $check_status['affiliate_lastname'], $check_status['affiliate_email_address'], EMAIL_TEXT_SUBJECT, nl2br($email), STORE_OWNER, AFFILIATE_EMAIL_ADDRESS); } } $messageStack->add_session(SUCCESS_BILLING, 'success'); smn_redirect(smn_href_link(FILENAME_AFFILIATE_PAYMENT, smn_get_all_get_params(array('action')) . 'action=edit')); break; case 'update_payment': $pID = smn_db_prepare_input($_GET['pID']);
define('EMAIL_CONTACT', 'For help with any of our online services, please email the store-owner: ' . $store->get_store_owner_email_address() . '.' . "\n\n"); define('EMAIL_WARNING', '<b>Note:</b> This email address was given to us by one of our customers. If you did not signup to be a member, please send a email to ' . $store->get_store_owner_email_address() . '.' . "\n"); 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_CONTACT . EMAIL_WARNING; if (NEW_SIGNUP_GIFT_VOUCHER_AMOUNT > 0) { $coupon_code = create_coupon_code(); $insert_query = smn_db_query("insert into " . TABLE_COUPONS . " (coupon_code, coupon_type, coupon_amount, date_created) values ('" . $coupon_code . "', 'G', '" . NEW_SIGNUP_GIFT_VOUCHER_AMOUNT . "', now())"); $insert_id = smn_db_insert_id($insert_query); $insert_query = smn_db_query("insert into " . TABLE_COUPON_EMAIL_TRACK . " (coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent) values ('" . $insert_id . "', '0', 'Admin', '" . $email_address . "', now() )"); $email_text .= sprintf(EMAIL_GV_INCENTIVE_HEADER, $currencies->format(NEW_SIGNUP_GIFT_VOUCHER_AMOUNT)) . "\n\n" . sprintf(EMAIL_GV_REDEEM, $coupon_code) . "\n\n" . EMAIL_GV_LINK . smn_href_link(FILENAME_GV_REDEEM, 'gv_no=' . $coupon_code, 'NONSSL', false) . "\n\n"; } if (NEW_SIGNUP_DISCOUNT_COUPON != '') { $coupon_code = NEW_SIGNUP_DISCOUNT_COUPON; $coupon_query = smn_db_query("select * from " . TABLE_COUPONS . " where coupon_code = '" . $coupon_code . "'"); $coupon = smn_db_fetch_array($coupon_query); $coupon_id = $coupon['coupon_id']; $coupon_desc_query = smn_db_query("select * from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id = '" . $coupon_id . "' and language_id = '" . (int) $languages_id . "'"); $coupon_desc = smn_db_fetch_array($coupon_desc_query); $insert_query = smn_db_query("insert into " . TABLE_COUPON_EMAIL_TRACK . " (coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent) values ('" . $coupon_id . "', '0', 'Admin', '" . $email_address . "', now() )"); $email_text .= EMAIL_COUPON_INCENTIVE_HEADER . "\n" . sprintf("%s", $coupon_desc['coupon_description']) . "\n\n" . sprintf(EMAIL_COUPON_REDEEM, $coupon['coupon_code']) . "\n\n" . "\n\n"; } smn_mail($name, $email_address, EMAIL_SUBJECT, $email_text, $store->get_store_owner(), $store->get_store_owner_email_address()); smn_redirect(smn_href_link(FILENAME_CREATE_ACCOUNT_SUCCESS, '', 'NONSSL'));
$sql_data_array['entry_company'] = $company; } 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; } } if (!smn_session_is_registered('sendto')) { smn_session_register('sendto'); } smn_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array); $sendto = smn_db_insert_id(); if (smn_session_is_registered('shipping')) { smn_session_unregister('shipping'); } /*Unregister the session shipping_store,By Cimi*/ if (smn_session_is_registered('shipping_store')) { smn_session_unregister('shipping_store'); } smn_redirect(smn_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'NONSSL')); } // process the selected shipping destination } elseif (isset($_POST['address'])) { $reset_shipping = false; if (smn_session_is_registered('sendto')) { if ($sendto != $_POST['address']) { if (smn_session_is_registered('shipping')) {
} else { $stock_left = $stock_values['products_quantity']; } smn_db_query("update " . TABLE_PRODUCTS . " set products_quantity = '" . $stock_left . "' where products_id = '" . smn_get_prid($order->products[$i]['id']) . "'"); if ($stock_left < 1 && STOCK_ALLOW_CHECKOUT == 'false') { smn_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . smn_get_prid($order->products[$i]['id']) . "'"); } } } // Update products_ordered (for bestsellers list) smn_db_query("update " . TABLE_PRODUCTS . " set products_ordered = products_ordered + " . sprintf('%d', $order->products[$i]['qty']) . " where products_id = '" . smn_get_prid($order->products[$i]['id']) . "'"); if ($order->products[$i]['products_store_id'] == $store_list[$k]) { $sql_data_array = array('orders_id' => $insert_id, 'products_id' => smn_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); smn_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); } $order_products_id = smn_db_insert_id(); $order_total_modules->update_credit_account($i); $member_product = explode('_', $order->products[$i]['model']); if ($member_product[0] == 'mem' && $store_id == 1) { $start_day = getdate(); $day = $start_day['mday']; $month = $start_day['mon']; $year = $start_day['year']; $product_end_date = strftime('%Y', mktime(0, 0, 0, $month + (int) $member_product[1], $day, $year)) . '-' . strftime('%m', mktime(0, 0, 0, $month + (int) $member_product[1], $day, $year)) . '-' . strftime('%d', mktime(0, 0, 0, $month + (int) $member_product[1], $day, $year)); $sql_data_array = array('orders_id' => $insert_id, 'store_id' => $insert_id, 'products_id' => smn_get_prid($order->products[$i]['id']), 'customer_id' => $customer_id, 'products_end_date' => $product_end_date); $update_query = smn_db_query("select store_id from " . TABLE_MEMBER_ORDERS . " where customer_id = '" . (int) $customer_id . "'"); if (smn_db_num_rows($update_query)) { smn_db_perform(TABLE_MEMBER_ORDERS, $sql_data_array, 'update', "customer_id = '" . (int) $customer_id . "'"); } else { smn_db_perform(TABLE_MEMBER_ORDERS, $sql_data_array); }
$sql_data_array = array('admin_files_name' => smn_db_prepare_input($_GET['fileName']), 'admin_tabs_to_files' => smn_db_prepare_input($_GET['masterFileID']), 'admin_files_is_tab' => '1', 'admin_files_to_boxes' => smn_db_prepare_input($_GET['boxID'])); } else { $sql_data_array = array('admin_files_name' => smn_db_prepare_input($_GET['fileName']), 'admin_files_to_boxes' => smn_db_prepare_input($_GET['boxID'])); } smn_db_perform(TABLE_ADMIN_FILES, $sql_data_array); $masterFileID = smn_db_insert_id(); $tabDir = str_replace('.php', '', $_GET['fileName']); $directory = DIR_FS_TEMPLATES . 'content/tabs/' . $tabDir . '/'; $tabs = array(); if (is_dir($directory)) { $dir = dir($directory); while (($file = $dir->read()) !== false) { if ($file != '.' && $file != '..' && is_file($directory . $file)) { $sql_data_array = array('admin_files_name' => smn_db_prepare_input($file), 'admin_files_is_tab' => '1', 'admin_tabs_to_files' => $masterFileID, 'admin_files_to_boxes' => smn_db_prepare_input($_GET['boxID'])); smn_db_perform(TABLE_ADMIN_FILES, $sql_data_array); $fileID = smn_db_insert_id(); $tabs[] = '["' . $fileID . '", "' . $file . '"]'; } } } echo '{ success: true, file_id: "' . $masterFileID . '", tabs: [' . implode(',', $tabs) . '] }'; } else { $admin_files_name = smn_db_prepare_input($_GET['fileName']); $admin_boxes_id = smn_db_prepare_input($_GET['boxID']); $Qcheck = smn_db_query('select admin_files_id from ' . TABLE_ADMIN_FILES . ' where admin_files_is_boxes = "0" and admin_files_to_boxes = "' . $admin_boxes_id . '" and admin_files_name = "' . $admin_files_name . '"'); if (smn_db_num_rows($Qcheck)) { $check = smn_db_fetch_array($Qcheck);
function insert_data($data) { $prefix = $data['store_id']; smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', '1', '8', 'smn_cfg_select_option(array(\\'asc\\', \\'desc\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', '1', '9', 'smn_cfg_select_option(array(\\'products_name\\', \\'date_expected\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language\\'s currency when it is changed', '1', '10', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Use Search-Engine Safe URLs (still in development)', 'SEARCH_ENGINE_FRIENDLY_URLS', 'false', 'Use search-engine safe urls for all site links', '1', '12', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Display Cart After Adding Product', 'DISPLAY_CART', 'true', 'Display the shopping cart after adding a product (or return back to their origin)', '1', '14', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Allow Guest To Tell A Friend', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'false', 'Allow guests to tell a friend about a product', '1', '15', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Default Search Operator', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'Default search operators', '1', '17', 'smn_cfg_select_option(array(\\'and\\', \\'or\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Store Address and Phone', 'STORE_NAME_ADDRESS', '" . $data['store_name'] . "\n" . $data['street_address'] . "\n" . $data['city'] . "\n" . $data['postal_code'] . "\n', 'This is the Store Name, Address and Phone used on printable documents and displayed online', '1', '18', 'smn_cfg_textarea(', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', '', 'Send extra order emails to the following email addresses, in this format: Name 1 <email@address1>, Name 2 <email@address2>', '1', '19', '', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', '2', '12', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', '2', '13', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', '2', '14', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Best Sellers', 'MIN_DISPLAY_BESTSELLERS', '1', 'Minimum number of best sellers to display', '2', '15', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Also Purchased', 'MIN_DISPLAY_ALSO_PURCHASED', '1', 'Minimum number of products to display in the \\'This Customer Also Purchased\\' box', '2', '16', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '20', 'Amount of products to list', '3', '2', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of \\'number\\' links use for page-sets', '3', '3', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', '3', '4', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '9', 'Maximum number of new products to display in a category', '3', '5', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', '3', '6', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', '3', '7', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Manufacturers Select Size', 'MAX_MANUFACTURERS_LIST', '1', 'Used in manufacturers box; when this value is \\'1\\' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.', '3', '7', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', '3', '8', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Store List', 'MAX_DISPLAY_STORES_IN_A_LIST', '0', 'Used in store box; when the number of stores exceeds this number, a drop-down list will be displayed instead of the default list', '3', '7', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Store Select Size', 'MAX_STORE_LIST', '1', 'Used in store box; when this value is \\'1\\' the classic drop-down list will be used for the storess box. Otherwise, a list-box with the specified number of rows will be displayed.', '3', '7', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', '3', '9', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'How many records to select from to choose one random product review', '3', '10', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '10', 'How many records to select from to choose one random new product to display', '3', '11', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', '3', '12', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', '3', '13', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Maximum number of new products to display in new products page', '3', '14', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '10', 'Maximum number of best sellers to display', '3', '15', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Also Purchased', 'MAX_DISPLAY_ALSO_PURCHASED', '6', 'Maximum number of products to display in the \\'This Customer Also Purchased\\' box', '3', '16', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Customer Order History Box', 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX', '6', 'Maximum number of products to display in the customer order history box', '3', '17', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Order History', 'MAX_DISPLAY_ORDER_HISTORY', '10', 'Maximum number of orders to display in the order history page', '3', '18', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Small Image Width', 'SMALL_IMAGE_WIDTH', '100', 'The pixel width of small images', '4', '1', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Small Image Height', 'SMALL_IMAGE_HEIGHT', '80', 'The pixel height of small images', '4', '2', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Heading Image Width', 'HEADING_IMAGE_WIDTH', '57', 'The pixel width of heading images', '4', '3', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Heading Image Height', 'HEADING_IMAGE_HEIGHT', '40', 'The pixel height of heading images', '4', '4', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '100', 'The pixel width of subcategory images', '4', '5', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '57', 'The pixel height of subcategory images', '4', '6', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', 'true', 'Calculate the size of images?', '4', '7', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Image Required', 'IMAGE_REQUIRED', 'true', 'Enable to display broken images. Good for development.', '4', '8', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration VALUES (" . $prefix . ", '', 'Installed Modules', 'MODULE_PAYMENT_INSTALLED', '', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', 6, 0, now(), now(), NULL, NULL);"); smn_db_query("INSERT INTO configuration VALUES (" . $prefix . ", '', 'Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', '', 'List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)', 6, 0, now(), now(), NULL, NULL);"); smn_db_query("INSERT INTO configuration VALUES (" . $prefix . ", '', 'Installed Modules', 'MODULE_SHIPPING_INSTALLED', '', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', 6, 0, now(), now(), NULL, NULL);"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Default Template', 'TEMPLATE_ID', '1', 'Default Template Layout used for store vendor', '6', '0', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Default Currency', 'DEFAULT_CURRENCY', 'USD', 'Default Currency', '6', '0', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Default Language', 'DEFAULT_LANGUAGE', 'en', 'Default Language', '6', '0', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Default Order Status For New Orders', 'DEFAULT_ORDERS_STATUS_ID', '1', 'When a new order is created, this order status will be assigned to it.', '6', '0', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Enter the Maximum Package Weight you will ship', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', '7', '3', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '3', 'What is the weight of typical packaging of small to medium packages?', '7', '4', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', '7', '5', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Handling Fee', 'SHIPPING_HANDLING', '5.00', 'Enter the handling fee you may charge.', '7', '6', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Image', 'PRODUCT_LIST_IMAGE', '0', 'Do you want to display the Product Image?', '8', '1', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Manufaturer Name','PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', '8', '2', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model?', '8', '3', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Name', 'PRODUCT_LIST_NAME', '1', 'Do you want to display the Product Name?', '8', '4', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Price', 'PRODUCT_LIST_PRICE', '2', 'Do you want to display the Product Price', '8', '5', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Quantity', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', '8', '6', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Weight', 'PRODUCT_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', '8', '7', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '0', 'Do you want to display the Buy Now column?', '8', '8', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', '8', '9', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '2', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', '8', '10', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Check stock level', 'STOCK_CHECK', 'true', 'Check to see if sufficent stock is available', '9', '1', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Subtract stock', 'STOCK_LIMITED', 'true', 'Subtract product in stock by product orders', '9', '2', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Allow Checkout', 'STOCK_ALLOW_CHECKOUT', 'true', 'Allow customer to checkout even if there is insufficient stock', '9', '3', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Mark product out of stock', 'STOCK_MARK_PRODUCT_OUT_OF_STOCK', '***', 'Display something on screen so customer can see which product has insufficient stock', '9', '4', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Stock Re-order level', 'STOCK_REORDER_LEVEL', '5', 'Define when stock needs to be re-ordered', '9', '5', now());"); smn_db_query("INSERT INTO tax_class (store_id, tax_class_id, tax_class_title, tax_class_description, last_modified, date_added) VALUES (" . $prefix . ", '', 'Taxable Goods', 'The following types of products are included non-food, services, etc', now(), now());"); $tax_class_id = smn_db_insert_id(); smn_db_query("INSERT INTO geo_zones (store_id, geo_zone_id, geo_zone_name, geo_zone_description, date_added)�VALUES (" . $prefix . ", '','Florida','Florida local sales tax zone',now());"); $geo_zone_id = smn_db_insert_id(); smn_db_query("INSERT INTO tax_rates (store_id, tax_rates_id, tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, last_modified, date_added ) VALUES (" . $prefix . ", '', " . $geo_zone_id . ", " . $tax_class_id . ", 1, 7.0, 'FL TAX 7.0%', now(), now());"); $tax_rate_id = smn_db_insert_id(); smn_db_query("INSERT INTO zones_to_geo_zones (store_id, association_id, zone_country_id, zone_id, geo_zone_id, date_added)�VALUES (" . $prefix . ", '', 223, 18, " . $geo_zone_id . ", now());"); if ($db_error) { return $db_error; } else { return $store_data_inserted = 'true'; } }
case 'deleteRate': $tax_rates_id = smn_db_prepare_input($_GET['rate_id']); smn_db_query("delete from " . TABLE_TAX_RATES . " where tax_rates_id = '" . (int) $tax_rates_id . "' and store_id = '" . $store_id . "'"); echo '{ success:true }'; exit; break; case 'saveSubZone': $geo_zone_id = smn_db_prepare_input($_POST['geo_zone_id']); $zone_country_id = smn_db_prepare_input($_POST['zone_country_id']); $zone_id = smn_db_prepare_input($_POST['zone_id']); if ($_POST['hidden_action'] == 'edit' && $_POST['association_id'] > 0) { smn_db_query("update " . TABLE_ZONES_TO_GEO_ZONES . " set geo_zone_id = '" . (int) $geo_zone_id . "', zone_country_id = '" . (int) $zone_country_id . "', zone_id = " . (smn_not_null($zone_id) ? "'" . (int) $zone_id . "'" : 'null') . ", last_modified = now() where association_id = '" . (int) $_POST['association_id'] . "' and store_id = '" . $store_id . "'"); $association_id = $_POST['association_id']; } else { smn_db_query("insert into " . TABLE_ZONES_TO_GEO_ZONES . " (store_id, zone_country_id, zone_id, geo_zone_id, date_added) values ('" . (int) $store_id . "', '" . (int) $zone_country_id . "', '" . (int) $zone_id . "', '" . (int) $geo_zone_id . "', now())"); $association_id = smn_db_insert_id(); } $Qzone = smn_db_query('select * from ' . TABLE_ZONES_TO_GEO_ZONES . ' where association_id = "' . $association_id . '"'); $zone = smn_db_fetch_array($Qzone); echo '{ success: true, db: { association_id : "' . $zone['association_id'] . '", zone_country_id : "' . $zone['zone_country_id'] . '", zone_id : "' . $zone['zone_id'] . '", geo_zone_id : "' . $zone['geo_zone_id'] . '", last_modified : "' . $zone['last_modified'] . '", date_added : "' . $zone['date_added'] . '" } }'; exit;
function saveHelpPage() { if (isset($_POST['customHelp'])) { $helpContent = $_POST['customHelpContent']['catalog']; $customString = smn_db_prepare_input($_POST['customHelp']); $Qcheck = smn_db_query('select help_id from ' . TABLE_HELP . ' where help_custom = "' . $customString . '"'); if (smn_db_num_rows($Qcheck)) { $check = smn_db_fetch_array($Qcheck); smn_db_query('update ' . TABLE_HELP_CONTENT . ' set help_content = "' . $fullPageHelp . '" where help_id = "' . $check['help_id'] . '"'); } else { smn_db_query('insert into ' . TABLE_HELP . ' (help_file, help_file_tab, help_custom) values ("false", "false", "' . $customString . '")'); $helpID = smn_db_insert_id(); smn_db_query('insert into ' . TABLE_HELP_CONTENT . ' (help_id, help_content, language_id) values ("' . $helpID . '", "' . $helpContent . '", "1")'); } } else { $pageName = $_POST['helpFile']; $fullPageHelp = smn_db_prepare_input($_POST['fullPageHelp']['catalog']); $tabs = $_POST['tab']; $Qcheck = smn_db_query('select * from ' . TABLE_HELP . ' where help_file = "' . $pageName . '"'); if (smn_db_num_rows($Qcheck)) { $check = smn_db_fetch_array($Qcheck); smn_db_query('update ' . TABLE_HELP_CONTENT . ' set help_content = "' . $fullPageHelp . '" where help_id = "' . $check['help_id'] . '"'); } else { smn_db_query('insert into ' . TABLE_HELP . ' (help_file, help_file_tab, help_custom) values ("' . $pageName . '", "false", "false")'); $fullHelpID = smn_db_insert_id(); smn_db_query('insert into ' . TABLE_HELP_CONTENT . ' (help_id, help_content, language_id) values ("' . $fullHelpID . '", "' . $fullPageHelp . '", "1")'); } if (!empty($tabs)) { foreach ($tabs as $tabFile => $helpContent) { $Qcheck = smn_db_query('select * from ' . TABLE_HELP . ' where help_file = "' . $pageName . '" and help_file_tab = "' . $tabFile . '"'); if (smn_db_num_rows($Qcheck)) { $check = smn_db_fetch_array($Qcheck); smn_db_query('update ' . TABLE_HELP_CONTENT . ' set help_content = "' . $helpContent . '" where help_id = "' . $check['help_id'] . '"'); } else { smn_db_query('insert into ' . TABLE_HELP . ' (help_file, help_file_tab, help_custom) values ("' . $pageName . '", "' . $tabFile . '", "false")'); $tabHelpID = smn_db_insert_id(); smn_db_query('insert into ' . TABLE_HELP_CONTENT . ' (help_id, help_content, language_id) values ("' . $tabHelpID . '", "' . $helpContent . '", "1")'); } } } } $this->setJsonResponse('{ success: true }'); }
if (empty($banners_image_local) || $_POST['delete_current_image'] == '1') { $banners_image = new upload('banners_image'); $banners_image->set_destination(DIR_FS_CATALOG . 'images/' . $banners_image_target); if ($banners_image->parse() == false || $banners_image->save() == false) { $banner_error = true; } } } if ($banner_error == false) { $db_image_location = smn_not_null($banners_image_local) && $_POST['delete_current_image'] != 1 ? $banners_image_local : $banners_image_target . $banners_image->filename; $sql_data_array = array('banners_title' => $banners_title, 'banners_url' => $banners_url, 'banners_image' => $db_image_location, 'banners_group' => $banners_group, 'categories_id' => $categories_id, 'banners_html_text' => $banners_html_text); if ($action == 'insert') { $insert_sql_data = array('date_added' => 'now()', 'status' => '1'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); smn_db_perform(TABLE_BANNERS, $sql_data_array); $banners_id = smn_db_insert_id(); $messageStack->add_session(SUCCESS_BANNER_INSERTED, 'success'); } elseif ($action == 'update') { smn_db_perform(TABLE_BANNERS, $sql_data_array, 'update', "banners_id = '" . (int) $banners_id . "'"); $messageStack->add_session(SUCCESS_BANNER_UPDATED, 'success'); } if (smn_not_null($expires_date)) { list($day, $month, $year) = explode('/', $expires_date); $expires_date = $year . (strlen($month) == 1 ? '0' . $month : $month) . (strlen($day) == 1 ? '0' . $day : $day); smn_db_query("update " . TABLE_BANNERS . " set expires_date = '" . smn_db_input($expires_date) . "', expires_impressions = null where banners_id = '" . (int) $banners_id . "'"); } elseif (smn_not_null($expires_impressions)) { smn_db_query("update " . TABLE_BANNERS . " set expires_impressions = '" . smn_db_input($expires_impressions) . "', expires_date = null where banners_id = '" . (int) $banners_id . "'"); } if (smn_not_null($date_scheduled)) { list($day, $month, $year) = explode('/', $date_scheduled); $date_scheduled = $year . (strlen($month) == 1 ? '0' . $month : $month) . (strlen($day) == 1 ? '0' . $day : $day);
if (empty($title)) { $messageStack->add(ERROR_NEWSLETTER_TITLE, 'error'); $affiliate_newsletter_error = true; } if (empty($module)) { $messageStack->add(ERROR_NEWSLETTER_MODULE, 'error'); $affiliate_newsletter_error = true; } if ($affiliate_newsletter_error == false) { $sql_data_array = array('title' => $title, 'content' => $content, 'module' => $affiliate_newsletter_module); if ($action == 'insert') { $sql_data_array['date_added'] = 'now()'; $sql_data_array['status'] = '0'; $sql_data_array['locked'] = '0'; smn_db_perform(TABLE_AFFILIATE_NEWSLETTERS, $sql_data_array); $affiliate_newsletter_id = smn_db_insert_id(); } elseif ($action == 'update') { smn_db_perform(TABLE_AFFILIATE_NEWSLETTERS, $sql_data_array, 'update', "affiliate_newsletters_id = '" . (int) $affiliate_newsletter_id . "'"); } smn_redirect(smn_href_link(FILENAME_AFFILIATE_NEWSLETTERS, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . 'nID=' . $affiliate_newsletter_id)); } else { $action = 'new'; } break; case 'deleteconfirm': $affiliate_newsletter_id = smn_db_prepare_input($_GET['nID']); smn_db_query("delete from " . TABLE_AFFILIATE_NEWSLETTERS . " where affiliate_newsletters_id = '" . (int) $affiliate_newsletter_id . "'"); smn_redirect(smn_href_link(FILENAME_AFFILIATE_NEWSLETTERS, 'page=' . $_GET['page'])); break; case 'delete': case 'new':
function insert_data($data) { global $languages_id; $prefix = $data['store_id']; smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', '1', '8', 'smn_cfg_select_option(array(\\'asc\\', \\'desc\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', '1', '9', 'smn_cfg_select_option(array(\\'products_name\\', \\'date_expected\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language\\'s currency when it is changed', '1', '10', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Use Search-Engine Safe URLs (still in development)', 'SEARCH_ENGINE_FRIENDLY_URLS', 'false', 'Use search-engine safe urls for all site links', '1', '12', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Display Cart After Adding Product', 'DISPLAY_CART', 'true', 'Display the shopping cart after adding a product (or return back to their origin)', '1', '14', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Allow Guest To Tell A Friend', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'false', 'Allow guests to tell a friend about a product', '1', '15', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Default Search Operator', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'Default search operators', '1', '17', 'smn_cfg_select_option(array(\\'and\\', \\'or\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Store Address and Phone', 'STORE_NAME_ADDRESS', '" . $data['store_name'] . "\n" . $data['street_address'] . "\n" . $data['city'] . "\n" . $data['postal_code'] . "\n', 'This is the Store Name, Address and Phone used on printable documents and displayed online', '1', '18', 'smn_cfg_textarea(', now());"); /*Added the query to insert commission percentage,By Cimi*/ smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Commission Percentage', 'COMMISSION_PERCENTAGE', '3', 'This is the percentage of the sales sales amount the mall retains as commission', '1', '12', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', '', 'Send extra order emails to the following email addresses, in this format: Name 1 <email@address1>, Name 2 <email@address2>', '1', '19', '', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', '2', '12', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', '2', '13', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', '2', '14', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Best Sellers', 'MIN_DISPLAY_BESTSELLERS', '1', 'Minimum number of best sellers to display', '2', '15', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Also Purchased', 'MIN_DISPLAY_ALSO_PURCHASED', '1', 'Minimum number of products to display in the \\'This Customer Also Purchased\\' box', '2', '16', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '20', 'Amount of products to list', '3', '2', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of \\'number\\' links use for page-sets', '3', '3', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', '3', '4', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '9', 'Maximum number of new products to display in a category', '3', '5', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', '3', '6', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', '3', '7', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Manufacturers Select Size', 'MAX_MANUFACTURERS_LIST', '1', 'Used in manufacturers box; when this value is \\'1\\' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.', '3', '7', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', '3', '8', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Store List', 'MAX_DISPLAY_STORES_IN_A_LIST', '0', 'Used in store box; when the number of stores exceeds this number, a drop-down list will be displayed instead of the default list', '3', '7', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Store Select Size', 'MAX_STORE_LIST', '1', 'Used in store box; when this value is \\'1\\' the classic drop-down list will be used for the storess box. Otherwise, a list-box with the specified number of rows will be displayed.', '3', '7', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', '3', '9', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'How many records to select from to choose one random product review', '3', '10', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '10', 'How many records to select from to choose one random new product to display', '3', '11', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', '3', '12', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', '3', '13', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Maximum number of new products to display in new products page', '3', '14', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '10', 'Maximum number of best sellers to display', '3', '15', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Also Purchased', 'MAX_DISPLAY_ALSO_PURCHASED', '6', 'Maximum number of products to display in the \\'This Customer Also Purchased\\' box', '3', '16', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Customer Order History Box', 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX', '6', 'Maximum number of products to display in the customer order history box', '3', '17', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Order History', 'MAX_DISPLAY_ORDER_HISTORY', '10', 'Maximum number of orders to display in the order history page', '3', '18', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Small Image Width', 'SMALL_IMAGE_WIDTH', '100', 'The pixel width of small images', '4', '1', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Small Image Height', 'SMALL_IMAGE_HEIGHT', '80', 'The pixel height of small images', '4', '2', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Heading Image Width', 'HEADING_IMAGE_WIDTH', '57', 'The pixel width of heading images', '4', '3', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Heading Image Height', 'HEADING_IMAGE_HEIGHT', '40', 'The pixel height of heading images', '4', '4', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '100', 'The pixel width of subcategory images', '4', '5', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '57', 'The pixel height of subcategory images', '4', '6', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', 'true', 'Calculate the size of images?', '4', '7', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Image Required', 'IMAGE_REQUIRED', 'true', 'Enable to display broken images. Good for development.', '4', '8', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Installed Modules', 'MODULE_PAYMENT_INSTALLED', 'paypal.php', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', 6, 0, now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', 'ot_subtotal.php;ot_total.php', 'List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)', 6, 0, now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Installed Modules', 'MODULE_SHIPPING_INSTALLED', '', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', 6, 0, now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Default Template', 'TEMPLATE_ID', '1', 'Default Template Layout used for store vendor', '6', '0', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Default Currency', 'DEFAULT_CURRENCY', 'USD', 'Default Currency', '6', '0', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Default Language', 'DEFAULT_LANGUAGE', 'en', 'Default Language', '6', '0', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Default Order Status For New Orders', 'DEFAULT_ORDERS_STATUS_ID', '1', 'When a new order is created, this order status will be assigned to it.', '6', '0', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Enter the Maximum Package Weight you will ship', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', '7', '3', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '3', 'What is the weight of typical packaging of small to medium packages?', '7', '4', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', '7', '5', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Handling Fee', 'SHIPPING_HANDLING', '5.00', 'Enter the handling fee you may charge.', '7', '6', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Image', 'PRODUCT_LIST_IMAGE', '0', 'Do you want to display the Product Image?', '8', '1', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Manufaturer Name','PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', '8', '2', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model?', '8', '3', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Name', 'PRODUCT_LIST_NAME', '1', 'Do you want to display the Product Name?', '8', '4', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Price', 'PRODUCT_LIST_PRICE', '2', 'Do you want to display the Product Price', '8', '5', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Quantity', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', '8', '6', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Product Weight', 'PRODUCT_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', '8', '7', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '0', 'Do you want to display the Buy Now column?', '8', '8', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', '8', '9', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '2', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', '8', '10', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Check stock level', 'STOCK_CHECK', 'true', 'Check to see if sufficent stock is available', '9', '1', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Subtract stock', 'STOCK_LIMITED', 'true', 'Subtract product in stock by product orders', '9', '2', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (" . $prefix . ", 'Allow Checkout', 'STOCK_ALLOW_CHECKOUT', 'true', 'Allow customer to checkout even if there is insufficient stock', '9', '3', 'smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Mark product out of stock', 'STOCK_MARK_PRODUCT_OUT_OF_STOCK', '***', 'Display something on screen so customer can see which product has insufficient stock', '9', '4', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES (" . $prefix . ", 'Stock Re-order level', 'STOCK_REORDER_LEVEL', '5', 'Define when stock needs to be re-ordered', '9', '5', now());"); smn_db_query("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (" . $prefix . ", 'To offer a discount coupon', 'NEW_SIGNUP_DISCOUNT_COUPON', '', 'To offer a discount coupon to a new customer, enter the code of the coupon.<br><br>Leave empty if you do not want to offer discount coupon.<BR>', 1, 32, NULL, now(), NULL, NULL);"); /*smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Enable SEO URLs?', 'SEO_ENABLED', 'true', 'Enable the SEO URLs? This is a global setting and will turn them off completely.', 901, 0, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Add cPath to product URLs?', 'SEO_ADD_CPATH_TO_PRODUCT_URLS', 'false', 'This setting will append the cPath to the end of product URLs (i.e. - some-product-p-1.html?cPath=xx).', 901, 1, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Add category parent to begining of URLs?', 'SEO_ADD_CAT_PARENT', 'true', 'This setting will add the category parent name to the beginning of the category URLs (i.e. - parent-category-c-1.html).', 901, 101, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Filter Short Words', 'SEO_URLS_FILTER_SHORT_WORDS', '3', 'This setting will filter words less than or equal to the value from the URL.', 901, 2, NULL, now(), NULL, NULL);"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Output W3C valid URLs (parameter string)?', 'SEO_URLS_USE_W3C_VALID', 'true', 'This setting will output W3C valid URLs.', 901, 3, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Enable SEO cache to save queries?', 'USE_SEO_CACHE_GLOBAL', 'true', 'This is a global setting and will turn off caching completely.', 901, 4, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Enable product cache?', 'USE_SEO_CACHE_PRODUCTS', 'true', 'This will turn off caching for the products.', 901, 5, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Enable categories cache?', 'USE_SEO_CACHE_CATEGORIES', 'true', 'This will turn off caching for the categories.', 901, 6, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Enable manufacturers cache?', 'USE_SEO_CACHE_MANUFACTURERS', 'true', 'This will turn off caching for the manufacturers.', 901, 7, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Enable articles cache?', 'USE_SEO_CACHE_ARTICLES', 'true', 'This will turn off caching for the articles.', 901, 8, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Enable topics cache?', 'USE_SEO_CACHE_TOPICS', 'true', 'This will turn off caching for the article topics.', 901, 9, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Enable information cache?', 'USE_SEO_CACHE_INFO_PAGES', 'true', 'This will turn off caching for the information pages.', 901, 10, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Enable automatic redirects?', 'USE_SEO_REDIRECT', 'true', 'This will activate the automatic redirect code and send 301 headers for old to new URLs.', 901, 101, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Choose URL Rewrite Type', 'SEO_REWRITE_TYPE', 'Rewrite', 'Choose which SEO URL format to use.', 901, 11, NULL, now(), NULL, 'smn_cfg_select_option(array(''Rewrite''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Enter special character conversions', 'SEO_CHAR_CONVERT_SET', '', 'This setting will convert characters.<br><br>The format <b>MUST</b> be in the form: <b>char=>conv,char2=>conv2</b>', 901, 12, NULL, now(), NULL, NULL);"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Remove all non-alphanumeric characters?', 'SEO_REMOVE_ALL_SPEC_CHARS', 'false', 'This will remove all non-letters and non-numbers. This should be handy to remove all special characters with 1 setting.', 901, 13, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); smn_db_query ("INSERT INTO configuration (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (".$prefix.", 'Reset SEO URLs Cache', 'SEO_URLS_CACHE_RESET', 'false', 'This will reset the cache data for SEO', 901, 14, NULL, now(), NULL, 'smn_cfg_select_option(array(''true'', ''false''),');"); */ smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('" . $prefix . "', 'Enable PayPal Module', 'MODULE_PAYMENT_PAYPAL_STATUS', 'True', 'Do you want to accept PayPal payments?', '6', '3', 'smn_cfg_select_option(array(\\'True\\', \\'False\\'), ', now())"); smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('" . $prefix . "', 'PayPal E-Mail Address', 'MODULE_PAYMENT_PAYPAL_ID', '*****@*****.**', 'The e-mail address to use for the PayPal service', '6', '4', now())"); smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('" . $prefix . "', 'PayPal Transaction Currency', 'MODULE_PAYMENT_PAYPAL_CURRENCY', 'Selected Currency', 'The currency to use for credit card transactions', '6', '6', 'smn_cfg_select_option(array(\\'Selected Currency\\',\\'Only USD\\',\\'Only CAD\\',\\'Only EUR\\',\\'Only GBP\\',\\'Only JPY\\'), ', now())"); smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('" . $prefix . "', 'PayPal Sort order of display.', 'MODULE_PAYMENT_PAYPAL_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now())"); smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('" . $prefix . "', 'PayPal Payment Zone', 'MODULE_PAYMENT_PAYPAL_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', 'smn_get_zone_class_title', 'smn_cfg_pull_down_zone_classes(', now())"); smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) values ('" . $prefix . "', 'PayPal Set Order Status', 'MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', '6', '0', 'smn_cfg_pull_down_order_statuses(', 'smn_get_order_status_name', now())"); if ($prefix == 1) { smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('" . $prefix . "', 'For Single Checkout?', 'MODULE_PAYMENT_PAYPAL_SINGLE_CHECKOUT', 'False', 'Use this payment for single checkout?', '6', '2', 'smn_cfg_select_option(array(\\'True\\', \\'False\\'), ', now())"); } smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('" . $prefix . "', 'Display Sub-Total', 'MODULE_ORDER_TOTAL_SUBTOTAL_STATUS', 'true', 'Do you want to display the order sub-total cost?', '6', '1','smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now())"); smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('" . $prefix . "', 'Sort Order', 'MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER', '1', 'Sort order of display.', '6', '2', now())"); smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('" . $prefix . "', 'Display Total', 'MODULE_ORDER_TOTAL_TOTAL_STATUS', 'true', 'Do you want to display the total order value?', '6', '1','smn_cfg_select_option(array(\\'true\\', \\'false\\'), ', now())"); smn_db_query("insert into " . TABLE_CONFIGURATION . " (store_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('" . $prefix . "', 'Sort Order', 'MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER', '4', 'Sort order of display.', '6', '2', now())"); smn_db_query("INSERT INTO web_site_content (store_id, page_name, text_key, language_id, text_content, date_modified) VALUES (" . $prefix . ", 'ot_total', 'MODULE_ORDER_TOTAL_TOTAL_TITLE', " . (int) $languages_id . ", 'Total', now());"); smn_db_query("INSERT INTO web_site_content (store_id, page_name, text_key, language_id, text_content, date_modified) VALUES (" . $prefix . ", 'ot_total', 'MODULE_ORDER_TOTAL_TOTAL_DESCRIPTION', " . (int) $languages_id . ", 'Order Total', now());"); smn_db_query("INSERT INTO web_site_content (store_id, page_name, text_key, language_id, text_content, date_modified) VALUES (" . $prefix . ", 'ot_subtotal', 'MODULE_ORDER_TOTAL_SUBTOTAL_TITLE', " . (int) $languages_id . ", 'Sub-Total', now());"); smn_db_query("INSERT INTO web_site_content (store_id, page_name, text_key, language_id, text_content, date_modified) VALUES (" . $prefix . ", 'ot_subtotal', 'MODULE_ORDER_TOTAL_SUBTOTAL_DESCRIPTION', " . (int) $languages_id . ", 'Order Sub-Total', now());"); smn_db_query("INSERT INTO web_site_content (store_id, page_name, text_key, language_id, text_content, date_modified) VALUES (" . $prefix . ", 'paypal', 'MODULE_PAYMENT_PAYPAL_TEXT_TITLE', " . (int) $languages_id . ", 'PayPal', now());"); smn_db_query("INSERT INTO web_site_content (store_id, page_name, text_key, language_id, text_content, date_modified) VALUES (" . $prefix . ", 'paypal', 'MODULE_PAYMENT_PAYPAL_TEXT_DESCRIPTION', " . (int) $languages_id . ", 'PayPal', now());"); smn_db_query("INSERT INTO tax_class (store_id, tax_class_title, tax_class_description, last_modified, date_added) VALUES (" . $prefix . ", 'Taxable Goods', 'The following types of products are included non-food, services, etc', now(), now());"); $tax_class_id = smn_db_insert_id(); smn_db_query("INSERT INTO geo_zones (store_id, geo_zone_name, geo_zone_description, date_added)�VALUES (" . $prefix . ", 'Florida','Florida local sales tax zone',now());"); $geo_zone_id = smn_db_insert_id(); smn_db_query("INSERT INTO tax_rates (store_id, tax_zone_id, tax_class_id, tax_priority, tax_rate, tax_description, last_modified, date_added ) VALUES (" . $prefix . ", " . $geo_zone_id . ", " . $tax_class_id . ", 1, 7.0, 'FL TAX 7.0%', now(), now());"); $tax_rate_id = smn_db_insert_id(); smn_db_query("INSERT INTO zones_to_geo_zones (store_id, zone_country_id, zone_id, geo_zone_id, date_added)�VALUES (" . $prefix . ", 223, 18, " . $geo_zone_id . ", now());"); if ($db_error) { return $db_error; } else { return $store_data_inserted = 'true'; } }
function before_process() { global $_POST, $language; require DIR_WS_LANGUAGES . $language . "/modules/payment/surepay.php"; require DIR_WS_CLASSES . "sausurepay.php"; # Creditcard test AUTH: # cc number: 4012000033330026 any future exp date # $11 = AUTH $21 = "REF" $31 = "DCL" any other may give "ERR" # This test request uses total $1 shipping, and 1x$5 + 1x$5 goods, # total $11. Just change the item quantities to try the other status. # I have also found some bugs and weakneses in Surepays processing, here is a # couple of them: # # - Do not add % as character data, best off staying away from it totally. # This can cause surepays servlets to crash and gives a 500 server error. # # - Do not convert < > & ' " to the correct XML entities, surepays parser or # data collector rejects any characterdata like < and so on. # # - Phone numbers in address are limited length (stay 11 digits or less), they # claim to be "US domestic oriented" (?) # # - What is the correct way to handle ref? Should the script handle and check # avs and cvv2status responses to something automatically? If someone has # a guideline to this would be appreciated.. (sausurepay@sauen.com) ## Syntax: ## vobject_identifier: sausp ( ## boolean: live? ## ,string: merchant id ## ,string: password ## [,array: extra pp.request parameters ] ## ) // --- Create the SurePay request object. --- // --- This is where you can change some of the settings. --- $amount = $_POST['surepay_total']; $shipping_cost = $_POST['surepay_shipping_cost']; if ($this->test_mode == true) { // --- Fill in the info for the fake auth requests. --- $shipping_cost = '0.00USD'; $amount = '11.00USD'; // Use this amount if you want to test: card okay. $amount = '31.00USD'; // Use this amount if you want to test: card referred to voice center. $amount = '44.00USD'; // Use this amount if you want to test: card declined. // -- Random valid generator. if (rand() % 2 == 1) { $amount = '11.00USD'; } } // -- Figure out whether to use xml.test.surepay.com (test) or xml.surepay.com (live). $live = !$this->test_mode; $ssp = new sausp($live, $this->login, $this->password); if ($ssp->err) { die($ssp->err); } // --- Generate SurePay order id. --- // -- Note that this is not the same as the order_id in OS Commerce, which does // -- not exist until after a payment is approved. smn_db_perform(TABLE_SUREPAY_TRANSACTIONS, array(message => '')); $order_number = smn_db_insert_id(); // --- Add miscellanous auth request info. --- // -- ecommercecode specifies the level of encryption( default is 07 - NONSSL, ) // -- 05 - secure w/ cardholder & merchant cert, // -- 06 - secure w/ merchant cert // -- 07 - NONSSL // -- 08 - no security $auth = $ssp->add_auth(array('ordernumber' => $order_number, 'ecommerce' => 'true', 'ecommercecode' => '07', 'ipaddress' => $REMOTE_ADDR, 'shippingcost' => $shipping_cost, 'shippingcost2' => "0.00USD", 'taxamount' => $_POST['surepay_tax'], 'referringurl' => $HTTP_REFERER, 'browsertype' => $HTTP_USER_AGENT)); if ($ssp->err) { die($ssp->err); } // --- Add the shipping address using the order info. --- $ssp->add_shipping_address($auth, array('fullname' => $_POST['surepay_delivery_fullname'], 'address1' => $_POST['surepay_delivery_address'], 'address2' => '', 'city' => $_POST['surepay_delivery_city'], 'state' => $_POST['surepay_delivery_state'], 'zip' => $_POST['surepay_delivery_postcode'], 'country' => $_POST['surepay_delivery_country'], 'phone' => $_POST['surepay_phone'], 'email' => $_POST['surepay_email'])); if ($ssp->err) { die($ssp->err); } // --- Add the credit card info. --- ## Syntax: ## object_identifier: add_creditcard ( ## object_identifier: parent object ## ,string: card number ## ,string: expiration (mm/yy) ## ,int: cvv2 code from card ## [,int: cvv2status (security mode) (0|1|9) default is 1 (In Use), 0 = off, 9 = no code available ] ## [,array: billing address] ## ) $creditcard = $ssp->add_creditcard($auth, $this->cc_number, $this->cc_expires_month . "/" . $this->cc_expires_year, $this->cc_cvv2); // --- Add the billing address for the order. --- $ssp->add_billing_address($creditcard, array('fullname' => $_POST['surepay_fullname'], 'address1' => $_POST['surepay_address'], 'address2' => '', 'city' => $_POST['surepay_city'], 'state' => $_POST['surepay_state'], 'zip' => $_POST['surepay_postcode'], 'country' => $_POST['surepay_country'], 'phone' => $_POST['surepay_phone'], 'email' => $_POST['surepay_email'])); if ($ssp->err) { die($ssp->err); } // --- Add total as lineitem --- // -- We only add one lineitem with the total right now. If you wanted to, you could // -- rewrite this to use multiple lineitems to more accurately reflect the items // -- in the current order. ## Syntax: ## object_identifier: add_lineitem ( ## object_identifier: parent object (The AUTH object) ## ,int: quantity, ## ,string: sku, ## ,string: description, ## ,string: unit cost (currency) [d..d]d.ccUSD ## ,real: taxrate in decimal notation (0.08 = 8%) ## [,array: options ] ## ) $item = $ssp->add_lineitem($auth, '1', 'ORDER_TOTAL', 'Order total for this order.', $amount, $_POST['surepay_tax_rate']); if ($ssp->err) { die($ssp->err); } // --- Generate the XML request for SurePay. --- $ssp->prepare_request(); if ($ssp->err) { die($ssp->err); } // TODO: remove. debug info if ($surepay_debug_mode) { echo "server: " . $ssp->serverurl; echo "</PRE><h2>The request xml we send:</H2><PRE>" . htmlentities($ssp->xml_request, ENT_QUOTES) . "\n<hr>"; } // --- Send the request to SurePay. --- $ssp->submit_request(); if ($ssp->err) { die($ssp->err); } // TODO: remove debug info if ($surepay_debug_mode) { echo "</PRE><h2>The response xml we got back:</H2><PRE>" . htmlentities($ssp->xml_response, ENT_QUOTES) . "\n<hr>"; die("\n<br>end"); } $responsecount = $ssp->parse_response(); if ($ssp->err) { die($ssp->err); } if (!$responsecount) { die("Invalid response count.\n"); } // --- Check through the AUTH responses. --- $auths = $ssp->auths(); if ($ssp->err) { die($ssp->err); } while (list($key, $ssp_order) = each($auths)) { // -- Store the transaction record in the SurePay table. --- $sql_data_array = array('auth_code' => $ssp->auth_authcode($ssp_order), 'transaction_id' => $ssp->auth_trans_id($ssp_order), 'message' => $ssp->auth_text($ssp_order)); smn_db_perform(TABLE_SUREPAY_TRANSACTIONS, $sql_data_array, 'update', 'request_id = ' . $ssp_order); if ($ssp->auth_status($ssp_order) != 'AUTH') { // -- Redirect to error page. $err_msg = $ssp->auth_text($ssp_order); smn_redirect(smn_href_link(FILENAME_CHECKOUT_PAYMENT, 'payment_error=' . $this->code . '&error=' . stripslashes(MODULE_PAYMENT_SUREPAY_TEXT_ERROR_DECLINED), 'NONSSL', true, false)); } if ($ssp->err) { die($ssp->err); } } }
break; case 'insert_affiliate_news': //insert a new news article. if ($_POST['headline']) { /*Changed the insert query to add the news details to affiliate_news_content table by Cimi */ /* $sql_data_array = array('headline' => smn_db_prepare_input($_POST['headline']), 'content' => smn_db_prepare_input($_POST['content']), 'date_added' => 'now()', //uses the inbuilt mysql function 'now' 'status' => '1' ); smn_db_perform(TABLE_AFFILIATE_NEWS, $sql_data_array); $news_id = smn_db_insert_id();*/ //not actually used ATM -- just there in case $sql_data_array = array('date_added' => 'now()', //uses the inbuilt mysql function 'now' $sql_data_array = array('date_added' => 'now()', 'news_status' => '1'); smn_db_perform(TABLE_AFFILIATE_NEWS, $sql_data_array); $news_id = smn_db_insert_id(); //not actually used ATM -- just there in case $sql_data_array = array('affiliate_news_id' => $news_id, 'affiliate_news_languages_id' => $languages_id, 'affiliate_news_headlines' => $_POST['headline'], 'affiliate_news_contents' => $_POST['content']); smn_db_perform(TABLE_AFFILIATE_NEWS_CONTENTS, $sql_data_array); } smn_redirect(smn_href_link(FILENAME_AFFILIATE_NEWS)); break; case 'update_affiliate_news': //user wants to modify a news article. if ($_GET['affiliate_news_id']) { /*Changed the update query to update the news details to affiliate_news_content table by Cimi */ /* $sql_data_array = array('headline' => smn_db_prepare_input($_POST['headline']), 'content' => smn_db_prepare_input($_POST['content']) ); smn_db_perform(TABLE_AFFILIATE_NEWS, $sql_data_array, 'update', "news_id = '" . smn_db_prepare_input($_GET['affiliate_news_id']) . "'");*/ $sql_data_array = array('affiliate_news_headlines' => smn_db_prepare_input($_POST['headline']), 'affiliate_news_contents' => smn_db_prepare_input($_POST['content']));
if (empty($affiliate_html_text)) { if ($affiliate_banners_image && $affiliate_banners_image != 'none' && is_uploaded_file($affiliate_banners_image)) { $image_location = DIR_FS_CATALOG_IMAGES . $affiliate_banners_image_target . $affiliate_banners_image_name; copy($affiliate_banners_image, $image_location); } $db_image_location = !empty($affiliate_banners_image_local) ? $affiliate_banners_image_local : $affiliate_banners_image_target . $affiliate_banners_image_name; } if (!$affiliate_products_id) { $affiliate_products_id = "0"; } $sql_data_array = array('affiliate_banners_title' => $affiliate_banners_title, 'affiliate_products_id' => $affiliate_products_id, 'affiliate_banners_image' => $db_image_location, 'affiliate_banners_group' => $affiliate_banners_group); if ($_GET['action'] == 'insert') { $insert_sql_data = array('affiliate_date_added' => 'now()', 'affiliate_status' => '1'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); smn_db_perform(TABLE_AFFILIATE_BANNERS, $sql_data_array); $affiliate_banners_id = smn_db_insert_id(); // Banner ID 1 is generic Product Banner if ($affiliate_banners_id == 1) { smn_db_query("update " . TABLE_AFFILIATE_BANNERS . " set affiliate_banners_id = affiliate_banners_id + 1"); } $messageStack->add_session(SUCCESS_BANNER_INSERTED, 'success'); } elseif ($_GET['action'] == 'update') { $insert_sql_data = array('affiliate_date_status_change' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); smn_db_perform(TABLE_AFFILIATE_BANNERS, $sql_data_array, 'update', 'affiliate_banners_id = \'' . $affiliate_banners_id . '\''); $messageStack->add_session(SUCCESS_BANNER_UPDATED, 'success'); } smn_redirect(smn_href_link(FILENAME_AFFILIATE_BANNER_MANAGER, 'selected_box=affiliate&page=' . $_GET['page'] . '&abID=' . $affiliate_banners_id)); } else { $_GET['action'] = 'new'; }
require 'includes/application_top.php'; $action = isset($_GET['action']) ? $_GET['action'] : ''; if (smn_not_null($action)) { switch ($action) { case 'insert': case 'save': if (isset($_GET['mID'])) { $manufacturers_id = smn_db_prepare_input($_GET['mID']); } $manufacturers_name = smn_db_prepare_input($_POST['manufacturers_name']); $sql_data_array = array('manufacturers_name' => $manufacturers_name); if ($action == 'insert') { $insert_sql_data = array('date_added' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); smn_db_perform(TABLE_MANUFACTURERS, $sql_data_array); $manufacturers_id = smn_db_insert_id(); } elseif ($action == 'save') { $update_sql_data = array('last_modified' => 'now()'); $sql_data_array = array_merge($sql_data_array, $update_sql_data); smn_db_perform(TABLE_MANUFACTURERS, $sql_data_array, 'update', "manufacturers_id = '" . (int) $manufacturers_id . "'"); } if ($manufacturers_image = new upload('manufacturers_image', DIR_FS_CATALOG_IMAGES)) { smn_db_query("update " . TABLE_MANUFACTURERS . " set manufacturers_image = '" . $manufacturers_image->filename . "' where manufacturers_id = '" . (int) $manufacturers_id . "'"); } $languages = smn_get_languages(); for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { $manufacturers_url_array = $_POST['manufacturers_url']; $language_id = $languages[$i]['id']; $sql_data_array = array('manufacturers_url' => smn_db_prepare_input($manufacturers_url_array[$language_id])); if ($action == 'insert') { $insert_sql_data = array('manufacturers_id' => $manufacturers_id, 'languages_id' => $language_id);
break; case 'deleteconfirm_sub': $sID = smn_db_prepare_input($_GET['sID']); smn_db_query("delete from " . TABLE_ZONES_TO_GEO_ZONES . " where association_id = '" . (int) $sID . "' and store_id = '" . $store_id . "'"); smn_redirect(smn_href_link(FILENAME_GEO_ZONES, 'zpage=' . $_GET['zpage'] . '&zID=' . $_GET['zID'] . '&action=list&spage=' . $_GET['spage'])); break; } } $action = isset($_GET['action']) ? $_GET['action'] : ''; if (smn_not_null($action)) { switch ($action) { case 'insert_zone': $geo_zone_name = smn_db_prepare_input($_POST['geo_zone_name']); $geo_zone_description = smn_db_prepare_input($_POST['geo_zone_description']); smn_db_query("insert into " . TABLE_GEO_ZONES . " (store_id, geo_zone_name, geo_zone_description, date_added) values ('" . smn_db_input($store_id) . "', '" . smn_db_input($geo_zone_name) . "', '" . smn_db_input($geo_zone_description) . "', now())"); $new_zone_id = smn_db_insert_id(); smn_redirect(smn_href_link(FILENAME_GEO_ZONES, 'zpage=' . $_GET['zpage'] . '&zID=' . $new_zone_id)); break; case 'save_zone': $zID = smn_db_prepare_input($_GET['zID']); $geo_zone_name = smn_db_prepare_input($_POST['geo_zone_name']); $geo_zone_description = smn_db_prepare_input($_POST['geo_zone_description']); smn_db_query("update " . TABLE_GEO_ZONES . " set geo_zone_name = '" . smn_db_input($geo_zone_name) . "', geo_zone_description = '" . smn_db_input($geo_zone_description) . "', last_modified = now() where geo_zone_id = '" . (int) $zID . "' and store_id = '" . $store_id . "'"); smn_redirect(smn_href_link(FILENAME_GEO_ZONES, 'zpage=' . $_GET['zpage'] . '&zID=' . $_GET['zID'])); break; case 'deleteconfirm_zone': $zID = smn_db_prepare_input($_GET['zID']); smn_db_query("delete from " . TABLE_GEO_ZONES . " where geo_zone_id = '" . (int) $zID . "' and store_id = '" . $store_id . "'"); smn_db_query("delete from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . (int) $zID . "' and store_id = '" . $store_id . "'"); smn_redirect(smn_href_link(FILENAME_GEO_ZONES, 'zpage=' . $_GET['zpage'])); break;
$sql_data_array['entry_company'] = $company; } 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; } } if (!smn_session_is_registered('billto')) { smn_session_register('billto'); } smn_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array); $billto = smn_db_insert_id(); if (smn_session_is_registered('payment')) { smn_session_unregister('payment'); } smn_redirect(smn_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'NONSSL')); } // process the selected billing destination } elseif (isset($_POST['address'])) { $reset_payment = false; if (smn_session_is_registered('billto')) { if ($billto != $_POST['address']) { if (smn_session_is_registered('payment')) { $reset_payment = true; } } } else {
$messageStack->add(ERROR_NEWSLETTER_TITLE, 'error'); $newsletter_error = true; } if (empty($module)) { $messageStack->add(ERROR_NEWSLETTER_MODULE, 'error'); $newsletter_error = true; } if ($newsletter_error == false) { $sql_data_array = array('title' => $title, 'content' => $content, 'module' => $newsletter_module); if ($action == 'insert') { $sql_data_array['date_added'] = 'now()'; $sql_data_array['status'] = '0'; $sql_data_array['locked'] = '0'; $sql_data_array['store_id'] = $store_id; smn_db_perform(TABLE_NEWSLETTERS, $sql_data_array); $newsletter_id = smn_db_insert_id(); } elseif ($action == 'update') { smn_db_perform(TABLE_NEWSLETTERS, $sql_data_array, 'update', "newsletters_id = '" . (int) $newsletter_id . "'"); } smn_redirect(smn_href_link(FILENAME_NEWSLETTERS, (isset($HTTP_GET_VARS['page']) ? 'page=' . $HTTP_GET_VARS['page'] . '&' : '') . 'nID=' . $newsletter_id)); } else { $action = 'new'; } break; case 'deleteconfirm': $newsletter_id = smn_db_prepare_input($HTTP_GET_VARS['nID']); smn_db_query("delete from " . TABLE_NEWSLETTERS . " where newsletters_id = '" . (int) $newsletter_id . "'"); smn_redirect(smn_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'])); break; case 'delete': case 'new':
function copy_to_confirm() { if (isset($_POST['list_store_id']) && isset($_POST['store_categories_id'])) { $list_store_id = smn_db_prepare_input($_POST['list_store_id']); $store_categories_id = smn_db_prepare_input($_POST['store_categories_id']); if ($_POST['copy_as'] == 'link') { if ($store_categories_id != $current_store_category_id) { $check_query = smn_db_query("select count(*) as total from " . TABLE_STORE_TO_CATEGORIES . " where store_id = '" . (int) $list_store_id . "' and store_categories_id = '" . (int) $store_categories_id . "'"); $check = smn_db_fetch_array($check_query); if ($check['total'] < '1') { smn_db_query("insert into " . TABLE_STORE_TO_CATEGORIES . " (store_id, store_categories_id) values ('" . (int) $list_store_id . "', '" . (int) $store_categories_id . "')"); } } else { $messageStack->add_session(ERROR_CANNOT_LINK_TO_SAME_CATEGORY, 'error'); } } elseif ($_POST['copy_as'] == 'duplicate') { $store_query = smn_db_query("select store_image, store_status from " . TABLE_STORE_MAIN . " where store_id = '" . (int) $list_store_id . "'"); $store_arr = smn_db_fetch_array($store_query); smn_db_query("insert into " . TABLE_STORE_MAIN . " (store_image, date_added, store_status) values ('" . smn_db_input($store_arr['store_image']) . "', now(), '0')"); $dup_store_id = smn_db_insert_id(); $description_query = smn_db_query("select language_id, store_name, store_description from " . TABLE_STORE_DESCRIPTION . " where store_id = '" . (int) $list_store_id . "'"); while ($description = smn_db_fetch_array($description_query)) { smn_db_query("insert into " . TABLE_STORE_DESCRIPTION . " (store_id, language_id, store_name, store_description, store_viewed) values ('" . (int) $dup_store_id . "', '" . (int) $description['language_id'] . "', '" . smn_db_input($description['store_name']) . "', '" . smn_db_input($description['store_description']) . "', '0')"); } smn_db_query("insert into " . TABLE_STORE_TO_CATEGORIES . " (store_id, store_categories_id) values ('" . (int) $dup_store_id . "', '" . (int) $store_categories_id . "')"); $list_store_id = $dup_store_id; } if (USE_CACHE == 'true') { smn_reset_cache_block('store_categories'); smn_reset_cache_block('also_purchased'); } } smn_redirect(smn_href_link(FILENAME_MANAGEMENT, 'sPath=' . $store_categories_id . '&sID=' . $list_store_id)); }
// systemsmanager end $customer_zone_id = $zone_id > 0 ? (int) $zone_id : '0'; $customer_default_address_id = (int) $_GET['edit']; $sql_data_array = array('customers_firstname' => $firstname, 'customers_lastname' => $lastname, 'customers_default_address_id' => (int) $_GET['edit']); if (ACCOUNT_GENDER == 'true') { $sql_data_array['customers_gender'] = $gender; } smn_db_perform(TABLE_CUSTOMERS, $sql_data_array, 'update', "customers_id = '" . (int) $customer_id . "'"); } $messageStack->add_session('addressbook', SUCCESS_ADDRESS_BOOK_ENTRY_UPDATED, 'success'); } } else { if (tep_count_customer_address_book_entries() < MAX_ADDRESS_BOOK_ENTRIES) { $sql_data_array['customers_id'] = (int) $customer_id; smn_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array); $new_address_book_id = smn_db_insert_id(); // reregister session variables if (isset($_POST['primary']) && $_POST['primary'] == 'on') { $customer_first_name = $firstname; // systemsmanager begin - Dec 1, 2005 security patch // $customer_country_id = $country_id; $customer_country_id = $country; // systemsmanager end $customer_zone_id = $zone_id > 0 ? (int) $zone_id : '0'; if (isset($_POST['primary']) && $_POST['primary'] == 'on') { $customer_default_address_id = $new_address_book_id; } $sql_data_array = array('customers_firstname' => $firstname, 'customers_lastname' => $lastname); if (ACCOUNT_GENDER == 'true') { $sql_data_array['customers_gender'] = $gender; }
} if ($_POST['products_id']) { $affiliate_products_id = $_POST['products_id']; } if ($_GET['affiliate_banner_id']) { $affiliate_banner_id = $_GET['affiliate_banner_id']; } if ($_POST['affiliate_banner_id']) { $affiliate_banner_id = $_POST['affiliate_banner_id']; } if (!$link_to) { $link_to = "0"; } $sql_data_array = array('affiliate_id' => $affiliate_ref, 'affiliate_clientdate' => $affiliate_clientdate, 'affiliate_clientbrowser' => $affiliate_clientbrowser, 'affiliate_clientip' => $affiliate_clientip, 'affiliate_clientreferer' => $affiliate_clientreferer, 'affiliate_products_id' => $affiliate_products_id, 'affiliate_banner_id' => $affiliate_banner_id); smn_db_perform(TABLE_AFFILIATE_CLICKTHROUGHS, $sql_data_array); $affiliate_clickthroughs_id = smn_db_insert_id(); // Banner has been clicked, update stats: if ($affiliate_banner_id && $affiliate_ref) { $today = date('Y-m-d'); $sql = "select * from " . TABLE_AFFILIATE_BANNERS_HISTORY . " where affiliate_banners_id = '" . $affiliate_banner_id . "' and affiliate_banners_affiliate_id = '" . $affiliate_ref . "' and affiliate_banners_history_date = '" . $today . "'"; $banner_stats_query = smn_db_query($sql); // Banner has been shown today if (smn_db_fetch_array($banner_stats_query)) { smn_db_query("update " . TABLE_AFFILIATE_BANNERS_HISTORY . " set affiliate_banners_clicks = affiliate_banners_clicks + 1 where affiliate_banners_id = '" . $affiliate_banner_id . "' and affiliate_banners_affiliate_id = '" . $affiliate_ref . "' and affiliate_banners_history_date = '" . $today . "'"); // Initial entry if banner has not been shown } else { $sql_data_array = array('affiliate_banners_id' => $affiliate_banner_id, 'affiliate_banners_products_id' => $affiliate_products_id, 'affiliate_banners_affiliate_id' => $affiliate_ref, 'affiliate_banners_clicks' => '1', 'affiliate_banners_history_date' => $today); smn_db_perform(TABLE_AFFILIATE_BANNERS_HISTORY, $sql_data_array); } } // Set Cookie if the customer comes back and orders it counts
} elseif ($_GET['gID'] != 'edit_group') { $check_groups_name_query = smn_db_query("select admin_groups_name as group_name_new from " . TABLE_ADMIN_GROUPS . " where admin_groups_name like '%" . $name_replace . "%'"); $check_duplicate = smn_db_num_rows($check_groups_name_query); if ($check_duplicate > 0) { smn_redirect(smn_href_link(FILENAME_ADMIN_MEMBERS, 'gID=' . $_GET['gID'] . '&gName=used&action=new_group')); } else { $sql_product_data_array = array('products_quantity' => '1000', 'products_model' => 'mem_6_', 'products_price' => smn_db_prepare_input($_POST['admin_groups_cost']), 'products_date_available' => date('Y-m-d'), 'store_id' => 1, 'products_weight' => '0', 'products_status' => '1', 'products_tax_class_id' => '', 'products_date_added' => 'now()', 'products_image' => '', 'manufacturers_id' => ''); smn_db_perform(TABLE_PRODUCTS, $sql_product_data_array); $products_id = smn_db_insert_id(); smn_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int) $products_id . "', '1')"); $languages = smn_get_languages(); for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { $language_id = $languages[$i]['id']; $sql_data_array = array('products_id' => $products_id, 'products_name' => smn_db_prepare_input($admin_groups_name), 'language_id' => $language_id, 'products_url' => HTTP_CATALOG_SERVER); smn_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array); } $sql_data_array = array('admin_groups_name' => $admin_groups_name, 'admin_groups_store_type' => smn_db_prepare_input($_POST['admin_groups_store_types']), 'admin_groups_products_id' => $products_id, 'admin_sales_cost' => smn_db_prepare_input($_POST['admin_sales_cost']), 'admin_groups_max_products' => smn_db_prepare_input($_POST['admin_groups_max_products'])); smn_db_perform(TABLE_ADMIN_GROUPS, $sql_data_array); $admin_groups_id = smn_db_insert_id(); $set_groups_id = smn_db_prepare_input($_POST['set_groups_id']); $add_group_id = $set_groups_id . ',\'' . $admin_groups_id . '\''; smn_db_query("alter table " . TABLE_ADMIN_FILES . " change admin_groups_id admin_groups_id set( " . $add_group_id . ") NOT NULL DEFAULT '1' "); smn_redirect(smn_href_link(FILENAME_ADMIN_MEMBERS, 'gID=' . $admin_groups_id)); } } break; } } $content_page = basename($_SERVER['PHP_SELF']); require 'templates/default/layout.php'; require DIR_WS_INCLUDES . 'application_bottom.php';
case 'save': if (isset($_GET['cID'])) { $currency_id = smn_db_prepare_input($_GET['cID']); } $title = smn_db_prepare_input($_POST['title']); $code = smn_db_prepare_input($_POST['code']); $symbol_left = smn_db_prepare_input($_POST['symbol_left']); $symbol_right = smn_db_prepare_input($_POST['symbol_right']); $decimal_point = smn_db_prepare_input($_POST['decimal_point']); $thousands_point = smn_db_prepare_input($_POST['thousands_point']); $decimal_places = smn_db_prepare_input($_POST['decimal_places']); $value = smn_db_prepare_input($_POST['value']); $sql_data_array = array('title' => $title, 'code' => $code, 'symbol_left' => $symbol_left, 'symbol_right' => $symbol_right, 'decimal_point' => $decimal_point, 'thousands_point' => $thousands_point, 'decimal_places' => $decimal_places, 'value' => $value); if ($action == 'insert') { smn_db_perform(TABLE_CURRENCIES, $sql_data_array); $currency_id = smn_db_insert_id(); } elseif ($action == 'save') { smn_db_perform(TABLE_CURRENCIES, $sql_data_array, 'update', "currencies_id = '" . (int) $currency_id . "'"); } if (isset($_POST['default']) && $_POST['default'] == 'on') { smn_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '" . smn_db_input($code) . "' where configuration_key = 'DEFAULT_CURRENCY'"); } smn_redirect(smn_href_link(FILENAME_CURRENCIES, 'page=' . $_GET['page'] . '&cID=' . $currency_id)); break; case 'deleteconfirm': $currencies_id = smn_db_prepare_input($_GET['cID']); $currency_query = smn_db_query("select currencies_id from " . TABLE_CURRENCIES . " where code = '" . DEFAULT_CURRENCY . "'"); $currency = smn_db_fetch_array($currency_query); if ($currency['currencies_id'] == $currencies_id) { smn_db_query("update " . TABLE_CONFIGURATION . " set configuration_value = '' where configuration_key = 'DEFAULT_CURRENCY'"); }
$new_page_array[] = array('id' => $new_page['page_name'], 'text' => $page_name); } $pInfo = new objectInfo($new_page_array); break; case 'newsave': if ($_POST['use_current_catagory'] != '') { $page_name = smn_db_prepare_input($_POST['use_current_catagory']); $store_page_title = str_replace(' ', '_', $page_name); } elseif ($_POST['new_catagory'] != '') { $page_name = smn_db_prepare_input($_POST['new_catagory']); $store_page_title = str_replace(' ', '_', $page_name); } if ($_GET['type'] != 'site_text') { $sql_index_page_data_array = array('page_id' => '', 'page_name' => $store_page_title, 'store_id' => $store_id, 'page_type' => $_GET['type']); smn_db_perform(TABLE_DYNAMIC_PAGE_INDEX, $sql_index_page_data_array, 'insert'); $page_id = smn_db_insert_id(); $languages = smn_get_languages(); for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { $language_id = $languages[$i]['id']; if ($_POST['new_catagory'] != '') { $sql_navbar_data_array = array('page_name' => $store_page_title, 'language_id' => $language_id, 'store_id' => $store_id, 'text_key' => 'NAVBAR_TITLE', 'text_content' => smn_db_prepare_input($_POST['page_navbar'][$language_id]), 'date_modified' => 'now()'); $sql_heading_data_array = array('page_name' => $store_page_title, 'language_id' => $language_id, 'store_id' => $store_id, 'text_key' => 'HEADING_TITLE', 'text_content' => smn_db_prepare_input($_POST['page_header'][$language_id]), 'date_modified' => 'now()'); $sql_header_data_array = array('page_name' => $store_page_title, 'language_id' => $language_id, 'store_id' => $store_id, 'text_key' => 'HEADER_TITLE', 'text_content' => smn_db_prepare_input($_POST['page_heading'][$language_id]), 'date_modified' => 'now()'); smn_db_perform(TABLE_WEB_SITE_CONTENT, $sql_navbar_data_array, 'insert'); smn_db_perform(TABLE_WEB_SITE_CONTENT, $sql_heading_data_array, 'insert'); smn_db_perform(TABLE_WEB_SITE_CONTENT, $sql_header_data_array, 'insert'); } $sql_page_data_array = array('page_id' => $page_id, 'language_id' => $language_id, 'store_id' => $store_id, 'page_title' => smn_db_prepare_input($_POST['page_title'][$language_id]), 'text_content' => '', 'date_modified' => 'now()'); smn_db_perform($db_table, $sql_page_data_array, 'insert'); } } elseif ($_GET['type'] == 'site_text') {
function confirmation() { global $cartID, $cart_PayPal_IPN_ID, $customer_id, $languages_id, $order, $order_total_modules, $store_id, $cart; $insert_order = true; if ($insert_order == true) { $order_totals = array(); if (is_array($order_total_modules->modules)) { reset($order_total_modules->modules); while (list(, $value) = each($order_total_modules->modules)) { $class = substr($value, 0, strrpos($value, '.')); if ($GLOBALS[$class]->enabled) { for ($i = 0, $n = sizeof($GLOBALS[$class]->output); $i < $n; $i++) { if (smn_not_null($GLOBALS[$class]->output[$i]['title']) && smn_not_null($GLOBALS[$class]->output[$i]['text'])) { $order_totals[] = array('code' => $GLOBALS[$class]->code, 'title' => $GLOBALS[$class]->output[$i]['title'], 'text' => $GLOBALS[$class]->output[$i]['text'], 'value' => $GLOBALS[$class]->output[$i]['value'], 'sort_order' => $GLOBALS[$class]->sort_order); } } } } } if (ALLOW_STORE_PAYMENT == 'true') { $sql_data_array = array('store_id' => $store_id, 'customers_id' => $customer_id, 'customers_name' => $order->customer['firstname'] . ' ' . $order->customer['lastname'], 'customers_company' => $order->customer['company'], 'customers_street_address' => $order->customer['street_address'], 'customers_city' => $order->customer['city'], 'customers_postcode' => $order->customer['postcode'], 'customers_state' => $order->customer['state'], 'customers_country' => $order->customer['country']['title'], 'customers_telephone' => $order->customer['telephone'], 'customers_email_address' => $order->customer['email_address'], 'customers_address_format_id' => $order->customer['format_id'], 'delivery_name' => $order->delivery['firstname'] . ' ' . $order->delivery['lastname'], 'delivery_company' => $order->delivery['company'], 'delivery_street_address' => $order->delivery['street_address'], 'delivery_city' => $order->delivery['city'], 'delivery_postcode' => $order->delivery['postcode'], 'delivery_state' => $order->delivery['state'], 'delivery_country' => $order->delivery['country']['title'], 'delivery_address_format_id' => $order->delivery['format_id'], 'billing_name' => $order->billing['firstname'] . ' ' . $order->billing['lastname'], 'billing_company' => $order->billing['company'], 'billing_street_address' => $order->billing['street_address'], 'billing_city' => $order->billing['city'], 'billing_postcode' => $order->billing['postcode'], 'billing_state' => $order->billing['state'], 'billing_country' => $order->billing['country']['title'], 'billing_address_format_id' => $order->billing['format_id'], 'payment_method' => $order->info['payment_method'], 'cc_type' => $order->info['cc_type'], 'cc_owner' => $order->info['cc_owner'], 'cc_number' => $order->info['cc_number'], 'cc_expires' => $order->info['cc_expires'], 'date_purchased' => 'now()', 'orders_status' => $order->info['order_status'], 'currency' => $order->info['currency'], 'currency_value' => $order->info['currency_value']); //+1.4 if ($update_order) { smn_db_perform(TABLE_ORDERS, $sql_data_array, 'update', 'orders_id = "' . (int) $order_id . '"'); $insert_id = (int) $order_id; } else { //-1.4 smn_db_perform(TABLE_ORDERS, $sql_data_array); $insert_id = smn_db_insert_id(); } //1.4 $orders_invoice_id = $insert_id; for ($i = 0, $n = sizeof($order_totals); $i < $n; $i++) { $sql_data_array = array('orders_id' => $insert_id, 'title' => $order_totals[$i]['title'], 'text' => $order_totals[$i]['text'], 'value' => $order_totals[$i]['value'], 'class' => $order_totals[$i]['code'], 'sort_order' => $order_totals[$i]['sort_order']); smn_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array); } //+1.4 $sql_data_array = array('orders_id' => $insert_id, 'orders_status_id' => $order->info['order_status'], 'date_added' => 'now()', 'customer_notified' => '0', 'comments' => $order->info['comments']); smn_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array); //-1.4 for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { if ($order->products[$i]['products_store_id'] == $store_id) { $sql_data_array = array('orders_id' => $insert_id, 'products_id' => smn_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); smn_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); $order_products_id = smn_db_insert_id(); $attributes_exist = '0'; if (isset($order->products[$i]['attributes'])) { $attributes_exist = '1'; for ($j = 0, $n2 = sizeof($order->products[$i]['attributes']); $j < $n2; $j++) { if (DOWNLOAD_ENABLED == 'true') { $attributes_query = "select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pad.products_attributes_maxdays, pad.products_attributes_maxcount , pad.products_attributes_filename\n\t\t\t\t\t\t\t\t\t\t\t from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa\n\t\t\t\t\t\t\t\t\t\t\t left join " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad\n\t\t\t\t\t\t\t\t\t\t\t on pa.products_attributes_id=pad.products_attributes_id\n\t\t\t\t\t\t\t\t\t\t\t where pa.products_id = '" . $order->products[$i]['id'] . "'\n\t\t\t\t\t\t\t\t\t\t\t and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "'\n\t\t\t\t\t\t\t\t\t\t\t and pa.options_id = popt.products_options_id\n\t\t\t\t\t\t\t\t\t\t\t and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "'\n\t\t\t\t\t\t\t\t\t\t\t and pa.options_values_id = poval.products_options_values_id\n\t\t\t\t\t\t\t\t\t\t\t and popt.language_id = '" . $languages_id . "'\n\t\t\t\t\t\t\t\t\t\t\t and poval.language_id = '" . $languages_id . "'"; $attributes = smn_db_query($attributes_query); } else { $attributes = smn_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $order->products[$i]['id'] . "' and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"); } $attributes_values = smn_db_fetch_array($attributes); $sql_data_array = array('orders_id' => $insert_id, 'orders_products_id' => $order_products_id, 'products_options' => $attributes_values['products_options_name'], 'products_options_values' => $attributes_values['products_options_values_name'], 'options_values_price' => $attributes_values['options_values_price'], 'price_prefix' => $attributes_values['price_prefix']); smn_db_perform(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array); if (DOWNLOAD_ENABLED == 'true' && isset($attributes_values['products_attributes_filename']) && smn_not_null($attributes_values['products_attributes_filename'])) { $sql_data_array = array('orders_id' => $insert_id, 'orders_products_id' => $order_products_id, 'orders_products_filename' => $attributes_values['products_attributes_filename'], 'download_maxdays' => $attributes_values['products_attributes_maxdays'], 'download_count' => $attributes_values['products_attributes_maxcount']); smn_db_perform(TABLE_ORDERS_PRODUCTS_DOWNLOAD, $sql_data_array); } } } } } } else { $store_list = $cart->get_store_list(); $orders_invoice_id = ''; for ($k = 0; $k < sizeof($store_list); $k++) { $sql_data_array = array('store_id' => $store_list[$k], 'customers_id' => $customer_id, 'customers_name' => $order->customer['firstname'] . ' ' . $order->customer['lastname'], 'customers_company' => $order->customer['company'], 'customers_street_address' => $order->customer['street_address'], 'customers_city' => $order->customer['city'], 'customers_postcode' => $order->customer['postcode'], 'customers_state' => $order->customer['state'], 'customers_country' => $order->customer['country']['title'], 'customers_telephone' => $order->customer['telephone'], 'customers_email_address' => $order->customer['email_address'], 'customers_address_format_id' => $order->customer['format_id'], 'delivery_name' => $order->delivery['firstname'] . ' ' . $order->delivery['lastname'], 'delivery_company' => $order->delivery['company'], 'delivery_street_address' => $order->delivery['street_address'], 'delivery_city' => $order->delivery['city'], 'delivery_postcode' => $order->delivery['postcode'], 'delivery_state' => $order->delivery['state'], 'delivery_country' => $order->delivery['country']['title'], 'delivery_address_format_id' => $order->delivery['format_id'], 'billing_name' => $order->billing['firstname'] . ' ' . $order->billing['lastname'], 'billing_company' => $order->billing['company'], 'billing_street_address' => $order->billing['street_address'], 'billing_city' => $order->billing['city'], 'billing_postcode' => $order->billing['postcode'], 'billing_state' => $order->billing['state'], 'billing_country' => $order->billing['country']['title'], 'billing_address_format_id' => $order->billing['format_id'], 'payment_method' => $order->info['payment_method'], 'cc_type' => $order->info['cc_type'], 'cc_owner' => $order->info['cc_owner'], 'cc_number' => $order->info['cc_number'], 'cc_expires' => $order->info['cc_expires'], 'date_purchased' => 'now()', 'orders_status' => $order->info['order_status'], 'currency' => $order->info['currency'], 'currency_value' => $order->info['currency_value']); //+1.4 if ($update_order) { smn_db_perform(TABLE_ORDERS, $sql_data_array, 'update', 'orders_id = "' . (int) $order_id . '"'); $insert_id = (int) $order_id; } else { //-1.4 smn_db_perform(TABLE_ORDERS, $sql_data_array); $insert_id = smn_db_insert_id(); } //1.4 for ($i = 0, $n = sizeof($order_totals); $i < $n; $i++) { $sql_data_array = array('orders_id' => $insert_id, 'title' => $order_totals[$i]['title'], 'text' => $order_totals[$i]['text'], 'value' => $order_totals[$i]['value'], 'class' => $order_totals[$i]['code'], 'sort_order' => $order_totals[$i]['sort_order']); smn_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array); } //+1.4 $sql_data_array = array('orders_id' => $insert_id, 'orders_status_id' => $order->info['order_status'], 'date_added' => 'now()', 'customer_notified' => '0', 'comments' => $order->info['comments']); smn_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array); //-1.4 for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) { if ($order->products[$i]['products_store_id'] == $store_list[$k]) { $sql_data_array = array('orders_id' => $insert_id, 'products_id' => smn_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); smn_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array); $order_products_id = smn_db_insert_id(); $attributes_exist = '0'; if (isset($order->products[$i]['attributes'])) { $attributes_exist = '1'; for ($j = 0, $n2 = sizeof($order->products[$i]['attributes']); $j < $n2; $j++) { if (DOWNLOAD_ENABLED == 'true') { $attributes_query = "select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, pad.products_attributes_maxdays, pad.products_attributes_maxcount , pad.products_attributes_filename\n\t\t\t\t\t\t\t\t\t\t\t from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa\n\t\t\t\t\t\t\t\t\t\t\t left join " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " pad\n\t\t\t\t\t\t\t\t\t\t\t on pa.products_attributes_id=pad.products_attributes_id\n\t\t\t\t\t\t\t\t\t\t\t where pa.products_id = '" . $order->products[$i]['id'] . "'\n\t\t\t\t\t\t\t\t\t\t\t and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "'\n\t\t\t\t\t\t\t\t\t\t\t and pa.options_id = popt.products_options_id\n\t\t\t\t\t\t\t\t\t\t\t and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "'\n\t\t\t\t\t\t\t\t\t\t\t and pa.options_values_id = poval.products_options_values_id\n\t\t\t\t\t\t\t\t\t\t\t and popt.language_id = '" . $languages_id . "'\n\t\t\t\t\t\t\t\t\t\t\t and poval.language_id = '" . $languages_id . "'"; $attributes = smn_db_query($attributes_query); } else { $attributes = smn_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa where pa.products_id = '" . $order->products[$i]['id'] . "' and pa.options_id = '" . $order->products[$i]['attributes'][$j]['option_id'] . "' and pa.options_id = popt.products_options_id and pa.options_values_id = '" . $order->products[$i]['attributes'][$j]['value_id'] . "' and pa.options_values_id = poval.products_options_values_id and popt.language_id = '" . $languages_id . "' and poval.language_id = '" . $languages_id . "'"); } $attributes_values = smn_db_fetch_array($attributes); $sql_data_array = array('orders_id' => $insert_id, 'orders_products_id' => $order_products_id, 'products_options' => $attributes_values['products_options_name'], 'products_options_values' => $attributes_values['products_options_values_name'], 'options_values_price' => $attributes_values['options_values_price'], 'price_prefix' => $attributes_values['price_prefix']); smn_db_perform(TABLE_ORDERS_PRODUCTS_ATTRIBUTES, $sql_data_array); if (DOWNLOAD_ENABLED == 'true' && isset($attributes_values['products_attributes_filename']) && smn_not_null($attributes_values['products_attributes_filename'])) { $sql_data_array = array('orders_id' => $insert_id, 'orders_products_id' => $order_products_id, 'orders_products_filename' => $attributes_values['products_attributes_filename'], 'download_maxdays' => $attributes_values['products_attributes_maxdays'], 'download_count' => $attributes_values['products_attributes_maxcount']); smn_db_perform(TABLE_ORDERS_PRODUCTS_DOWNLOAD, $sql_data_array); } } } } } $sql_data_array = array('orders_invoice_id' => $orders_invoice_id, 'orders_id' => $insert_id); smn_db_perform(TABLE_ORDERS_INVOICE, $sql_data_array); $orders_invoice_id = smn_db_insert_id(); } } smn_session_register('cart_PayPal_IPN_ID'); // Terra register globals fix $_SESSION['cart_PayPal_IPN_ID'] = $cartID . '-' . $orders_invoice_id; } return false; }