/wp-content/plugins/wp-e-commerce/updates/updating_tasks.php
PHP | 721 lines | 541 code | 69 blank | 111 comment | 70 complexity | 382a43677b07ae7240fa1107cdbe1369 MD5 | raw file
- <?php
-
-
- /**
- // cannot currently add due to high risk of things breaking
-
- if(!$wpdb->get_results("SELECT `id` FROM `".WPSC_TABLE_ALSO_BOUGHT."`")) {
- // inserts data on what was bought with what however many times
- $product_ids = $wpdb->get_col("SELECT `id` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN('1')");
- foreach((array)$product_ids as $prodid) {
- $cart_ids = $wpdb->get_results("SELECT `purchaseid` FROM `".WPSC_TABLE_CART_CONTENTS."` WHERE `prodid` IN ('$prodid')", ARRAY_A);
- $popular_array = array();
- foreach((array)$cart_ids as $cart_id) {
- $purchase_data = $wpdb->get_results("SELECT `prodid` FROM `".WPSC_TABLE_CART_CONTENTS."` WHERE `purchaseid` IN ('".$cart_id['purchaseid']."') AND `prodid` NOT IN('$prodid')", ARRAY_A);
- foreach((array)$purchase_data as $purchase_row) {
- if(isset($popular_array[$purchase_row['prodid']])) {
- $popular_array[$purchase_row['prodid']]++;
- } else {
- $popular_array[$purchase_row['prodid']] = 1;
- }
- }
- }
- foreach((array)$popular_array as $assoc_prodid => $quantity) {
- $wpdb->query("INSERT INTO `".WPSC_TABLE_ALSO_BOUGHT."` ( `id` , `selected_product` , `associated_product` , `quantity` ) VALUES ('', '$prodid', '".$assoc_prodid."', '".$quantity."' );");
- }
- }
- }
-
-
-
-
- add_option('wpsc_use_pnp_cols', '', "", 'yes');
- if(get_option('wpsc_use_pnp_cols') != 'true') {
- $base_country = get_option('base_country');
- $results = $wpdb->get_results("SELECT `".WPSC_TABLE_CART_CONTENTS."`.`id`, `".WPSC_TABLE_CART_CONTENTS."`.`pnp`, IF((`".WPSC_TABLE_PURCHASE_LOGS."`.`shipping_country` IN('$base_country')), `".WPSC_TABLE_PRODUCT_LIST."`.`pnp`, `".WPSC_TABLE_PRODUCT_LIST."`.`international_pnp`) AS `new_pnp` FROM `".WPSC_TABLE_CART_CONTENTS."`, `".WPSC_TABLE_PURCHASE_LOGS."`, `".WPSC_TABLE_PRODUCT_LIST."` WHERE `".WPSC_TABLE_CART_CONTENTS."`.`purchaseid` IN(`".WPSC_TABLE_PURCHASE_LOGS."`.`id`) AND `".WPSC_TABLE_CART_CONTENTS."`.`prodid` IN(`".WPSC_TABLE_PRODUCT_LIST."`.`id`) ",ARRAY_A);
- foreach((array)$results as $row) {
- if((float)$row['pnp'] != (float)$row['new_pnp']) {
- $wpdb->query("UPDATE `".WPSC_TABLE_CART_CONTENTS."` SET `pnp` = '".((float)$row['new_pnp'])."' WHERE `id` = '".$row['id']."' AND `pnp` IN('0');");
- //echo "UPDATE `wp_cart_contents` SET `pnp` = '".((float)$row['new_pnp'])."' WHERE `id` = '".$row['id']."' LIMIT 1 ;"."<br />";
- }
- }
- //exit();
- update_option('wpsc_use_pnp_cols','true');
- }
-
-
-
-
-
- */
- if(get_option('wpsc_trackingid_message') == ''){
- update_option('wpsc_trackingid_message', __('Your purchase from %shop_name% has just been dispatched. It should arrive soon. To keep track of your products status a tracking id has been attached. \r\n your tracking id is: %trackid%', 'wpsc'));
- }
- if(get_option('wpsc_trackingid_subject') == ''){
- update_option('wpsc_trackingid_subject', __('Your Order from %shop_name% has been dispatched', 'wpsc'));
- }
- /* adds nice names for permalinks for products */
- $check_product_names = $wpdb->get_results("SELECT `products`.`id`, `products`.`name`, `meta`.`meta_key` FROM `".WPSC_TABLE_PRODUCT_LIST."` AS `products` LEFT JOIN `".WPSC_TABLE_PRODUCTMETA."` AS `meta` ON `products`.`id` = `meta`.`product_id` WHERE `products`.`active` IN ('1') AND ((`meta`.`meta_key` IN ('url_name') AND `meta`.`meta_value` IN ('')) OR ISNULL(`meta`.`meta_key`))");
- if($check_product_names != null) {
- $sql_query = "SELECT `id`, `name` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN('1')";
- $sql_data = $wpdb->get_results($sql_query,ARRAY_A);
- foreach((array)$sql_data as $datarow) {
- $tidied_name = trim($datarow['name']);
- $tidied_name = strtolower($tidied_name);
- $url_name = sanitize_title($tidied_name);
- $similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`meta_value`, '$url_name', '')) AS `max_number` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `meta_key` LIKE 'url_name' AND `meta_value` REGEXP '^($url_name){1}(\d)*$' ",ARRAY_A);
- $extension_number = '';
- if($similar_names['count'] > 0) {
- $extension_number = (int)$similar_names['max_number']+1;
- }
- if(get_product_meta($datarow['id'], 'url_name') != false) {
- $current_url_name = get_product_meta($datarow['id'], 'url_name');
- if($current_url_name != $url_name) {
- $url_name .= $extension_number;
- // Buggy, sometimes results in the url name swapping on every page load.
- // update_product_meta($datarow['id'], 'url_name', $url_name);
- }
- } else {
- $url_name .= $extension_number;
- add_product_meta($datarow['id'], 'url_name', $url_name, true);
- }
- }
- }
-
-
- /* adds nice names for permalinks for categories */
- $check_category_names = $wpdb->get_results("SELECT DISTINCT `nice-name` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `nice-name` NOT IN ('') AND `active` IN ('1')");
- if($check_category_names == null) {
- $sql_query = "SELECT `id`, `name` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `active` IN('1')";
- $sql_data = $wpdb->get_results($sql_query,ARRAY_A);
- foreach((array)$sql_data as $datarow) {
- $tidied_name = trim($datarow['name']);
- $tidied_name = strtolower($tidied_name);
- $url_name = sanitize_title($tidied_name);
- $similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`nice-name`, '$url_name', '')) AS `max_number` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `nice-name` REGEXP '^($url_name){1}(\d)*$' ",ARRAY_A);
- $extension_number = '';
- if($similar_names['count'] > 0) {
- $extension_number = (int)$similar_names['max_number']+1;
- }
- $url_name .= $extension_number;
- $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_CATEGORIES."` SET `nice-name` = '$url_name' WHERE `id` = '".$datarow['id']."' LIMIT 1 ;");
- }
- }
-
-
- if(!$wpdb->get_results("SELECT `id` FROM `".WPSC_TABLE_ALSO_BOUGHT."`")) {
- /* inserts data on what was bought with what however many times */
- $product_ids = $wpdb->get_col("SELECT `id` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN('1')");
- foreach((array)$product_ids as $prodid) {
- $cart_ids = $wpdb->get_results("SELECT `purchaseid` FROM `".WPSC_TABLE_CART_CONTENTS."` WHERE `prodid` IN ('$prodid')", ARRAY_A);
- $popular_array = array();
- foreach((array)$cart_ids as $cart_id) {
- $purchase_data = $wpdb->get_results("SELECT `prodid` FROM `".WPSC_TABLE_CART_CONTENTS."` WHERE `purchaseid` IN ('".$cart_id['purchaseid']."') AND `prodid` NOT IN('$prodid')", ARRAY_A);
- foreach((array)$purchase_data as $purchase_row) {
- if(isset($popular_array[$purchase_row['prodid']])) {
- $popular_array[$purchase_row['prodid']]++;
- } else {
- $popular_array[$purchase_row['prodid']] = 1;
- }
- }
- }
- foreach((array)$popular_array as $assoc_prodid => $quantity) {
- $wpdb->query("INSERT INTO `".WPSC_TABLE_ALSO_BOUGHT."` ( `id` , `selected_product` , `associated_product` , `quantity` ) VALUES ('', '$prodid', '".$assoc_prodid."', '".$quantity."' );");
- }
- }
- }
- // accidentally used venue_id in an old version, it should be value id, this makes that so.
- if($wpdb->get_results("SHOW FULL COLUMNS FROM `".WPSC_TABLE_CART_ITEM_VARIATIONS."` LIKE 'venue_id';",ARRAY_A)) {
- $wpdb->query("ALTER TABLE `".WPSC_TABLE_CART_ITEM_VARIATIONS."` CHANGE `venue_id` `value_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' ");
- }
- if($wpdb->get_results("SHOW FULL COLUMNS FROM `".WPSC_TABLE_REGION_TAX."` LIKE 'code';",ARRAY_A)) {
- //$wpdb->query("ALTER TABLE `".WPSC_TABLE_REGION_TAX."` ADD `code` char(2) NOT NULL default '' AFTER `name`;");
- if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_REGION_TAX."` WHERE `code` NOT IN ('')") < 51) {
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'AL' WHERE `name` IN('Alabama')LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'AK' WHERE `name` IN('Alaska') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'AZ' WHERE `name` IN('Arizona') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'AR' WHERE `name` IN('Arkansas') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'CA' WHERE `name` IN('California') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'CO' WHERE `name` IN('Colorado') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'CT' WHERE `name` IN('Connecticut') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'DE' WHERE `name` IN('Delaware') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'FL' WHERE `name` IN('Florida') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'GA' WHERE `name` IN('Georgia') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'HI' WHERE `name` IN('Hawaii') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'ID' WHERE`name` IN('Idaho') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'IL' WHERE `name` IN('Illinois') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'IN' WHERE `name` IN('Indiana') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'IA' WHERE `name` IN('Iowa') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'KS' WHERE `name` IN('Kansas') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'KY' WHERE `name` IN('Kentucky') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'LA' WHERE `name` IN('Louisiana') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'ME' WHERE `name` IN('Maine') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MD' WHERE `name` IN('Maryland') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MA' WHERE `name` IN('Massachusetts') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MI' WHERE `name` IN('Michigan') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MN' WHERE `name` IN('Minnesota') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MS' WHERE `name` IN('Mississippi') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MO' WHERE `name` IN('Missouri') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MT' WHERE `name` IN('Montana') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NE' WHERE `name` IN('Nebraska') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NV' WHERE `name` IN('Nevada') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NH' WHERE `name` IN('New Hampshire') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NJ' WHERE `name` IN('New Jersey') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NM' WHERE `name` IN('New Mexico') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NY' WHERE `name` IN('New York') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NC' WHERE `name` IN('North Carolina') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'ND' WHERE `name` IN('North Dakota') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'OH' WHERE `name` IN('Ohio') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'OK' WHERE `name` IN('Oklahoma') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'OR' WHERE `name` IN('Oregon') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'PA' WHERE `name` IN('Pennsylvania') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'RI' WHERE `name` IN('Rhode Island') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'SC' WHERE `name` IN('South Carolina') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'SD' WHERE `name` IN('South Dakota') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'TN' WHERE `name` IN('Tennessee') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'TX' WHERE `name` IN('Texas') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'UT' WHERE `name` IN('Utah') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'VT' WHERE `name` IN('Vermont') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'VA' WHERE `name` IN('Virginia') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'WA' WHERE `name` IN('Washington') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'DC' WHERE `name` IN('Washington DC') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'WV' WHERE `name` IN('West Virginia') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'WI' WHERE `name` IN('Wisconsin') LIMIT 1 ;");
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'WY' WHERE `name` IN('Wyoming') LIMIT 1 ;");
-
- }
- }
-
-
-
-
-
-
- // if there are no default product categorisations, add them
- if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_CATEGORISATION_GROUPS."`") < 1) {
- $wpdb->query("INSERT INTO `".WPSC_TABLE_CATEGORISATION_GROUPS."` (`id`, `name`, `description`, `active`, `default`) VALUES (1, 'Categories', 'Product Categories', '1', '1')");
- $wpdb->query("INSERT INTO `".WPSC_TABLE_CATEGORISATION_GROUPS."` (`id`, `name`, `description`, `active`, `default`) VALUES (2, 'Brands', 'Product Brands', '1', '0')");
- }
- $brand_group = $wpdb->get_row("SELECT * FROM `".WPSC_TABLE_CATEGORISATION_GROUPS."` WHERE `name` IN ( 'Brands' ) ",ARRAY_A);
- $converted_brand_count = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `group_id` IN({$brand_group['id']}) AND `active` IN('1') ");
- if(($converted_brand_count <= 0) && ($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->prefix}product_brands'") == ($wpdb->prefix."product_brands"))) {
- $brands = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}product_brands` ",ARRAY_A);
- if(count($brands) > 0 ) {
- foreach($brands as $brand) {
-
- $tidied_name = trim($brand['name']);
- $tidied_name = strtolower($tidied_name);
- $url_name = sanitize_title($tidied_name);
- if($url_name != $category_data['nice-name']) {
- $similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`nice-name`, '$url_name', '')) AS `max_number` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `nice-name` REGEXP '^($url_name){1}(0-9)*$' AND `id` NOT IN ('".(int)$category_data['id']."') ",ARRAY_A);
-
- $extension_number = '';
- if($similar_names['count'] > 0) {
- $extension_number = (int)$similar_names['max_number']+1;
- }
- $url_name .= $extension_number;
- }
-
- $wpdb->query( "INSERT INTO `".WPSC_TABLE_PRODUCT_CATEGORIES."` ( `group_id`, `name`, `nice-name`, `description`, `image`, `fee`, `active`, `category_parent`, `order`) VALUES ( {$brand_group['id']}, '{$brand['name']}', '{$url_name}', '{$brand['description']}', '', '0', '1', 0, 0)");
- }
- }
- }
- $unassociated_categories = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `group_id` IN ('0')");
- if($unassociated_categories > 0) {
- $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_CATEGORIES."` SET `group_id` = '1' WHERE `group_id` IN ('0')");
- }
- // here is the code to update the payment gateway options.
- $selected_gateways = array();
- $current_gateway = get_option('payment_gateway');
- $selected_gateways = get_option('custom_gateway_options');
- if($current_gateway == '') {
- // set the gateway to Manual Payment if it is not set.
- $current_gateway = 'testmode';
- }
- if(get_option('payment_method') != null) {
- switch(get_option('payment_method')) {
- case 2:
- // mode 2 is credit card and manual payment / test mode
- if($current_gateway == 'testmode') {
- $current_gateway = 'paypal_multiple';
- }
- $selected_gateways[] = 'testmode';
- $selected_gateways[] = $current_gateway;
- break;
-
- case 3;
- // mode 3 is manual payment / test mode
- $current_gateway = 'testmode';
- case 1:
- // mode 1 is whatever gateway is currently selected.
- default:
- $selected_gateways[] = $current_gateway;
- break;
- }
- update_option('custom_gateway_options', $selected_gateways);
- update_option('payment_method', null);
- }
- // here is the code to update the payment gateway options.
- $selected_gateways = array();
- $current_gateway = get_option('payment_gateway');
- $selected_gateways = get_option('custom_gateway_options');
- if($current_gateway == '') {
- // set the gateway to Manual Payment if it is not set.
- $current_gateway = 'testmode';
- }
- if(get_option('payment_method') != null) {
- switch(get_option('payment_method')) {
- case 2:
- // mode 2 is credit card and manual payment / test mode
- if($current_gateway == 'testmode') {
- $current_gateway = 'paypal_multiple';
- }
- $selected_gateways[] = 'testmode';
- $selected_gateways[] = $current_gateway;
- break;
-
- case 3;
- // mode 3 is manual payment / test mode
- $current_gateway = 'testmode';
- case 1:
- // mode 1 is whatever gateway is currently selected.
- default:
- $selected_gateways[] = $current_gateway;
- break;
- }
- update_option('custom_gateway_options', $selected_gateways);
- update_option('payment_method', null);
- }
- // switch this variable over to our own option name, seems default_category was used by wordpress
- if(get_option('wpsc_default_category') == null) {
- update_option('wpsc_default_category', get_option('default_category'));
- }
- // Move the variation ids for the combinations to the new table
- if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."`") < 1) {
- $variation_priceandstock = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_VARIATION_PROPERTIES."`",ARRAY_A);
-
- foreach((array)$variation_priceandstock_items as $variation_priceandstock_item) {
- $keys = array();
- $keys[] = $variation_priceandstock_item['variation_id_1'];
- $keys[] = $variation_priceandstock_item['variation_id_2'];
-
- asort($keys);
- $all_value_ids = implode(",", $keys);
-
-
- $variation_ids = $wpdb->get_col("SELECT `variation_id` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` IN ('".implode("','",$keys)."')");
- asort($variation_ids);
- $all_variation_ids = implode(",", $variation_ids);
-
- $variation_priceandstock_id = $variation_priceandstock_item['id'];
- $product_id = $variation_priceandstock_item['product_id'];
- foreach((array)$keys as $key) {
- if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `priceandstock_id` = '{$variation_priceandstock_id}' AND `value_id` = '$key'") < 1) {
- $variation_id = $wpdb->get_var("SELECT `variation_id` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` = '{$key}'");
- if($variation_id > 0) {
- $wpdb->query("INSERT INTO `".WPSC_TABLE_VARIATION_COMBINATIONS."` ( `product_id` , `priceandstock_id` , `value_id`, `variation_id`, `all_value_ids` ) VALUES ( '$product_id', '{$variation_priceandstock_id}', '$key', '$variation_id', '$all_variation_ids' )");
- }
- }
- }
- }
- }
- /*
- $product_ids = $wpdb->get_col("SELECT `id` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN('1')");
- foreach($product_ids as $product_id) {
- if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `product_id` = '{$product_id}'") < 1 ) {
- $variation_priceandstock = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_VARIATION_PROPERTIES."` WHERE `product_id` = '{$product_id}'",ARRAY_A);
-
-
- foreach((array)$variation_priceandstock as $variation_priceandstock_item) {
- $keys = array();
- $keys[] = $variation_priceandstock_item['variation_id_1'];
- $keys[] = $variation_priceandstock_item['variation_id_2'];
-
- asort($keys);
- $all_value_ids = implode(",", $keys);
-
- $variation_ids = $wpdb->get_col("SELECT `variation_id` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` IN ('".implode("','",$keys)."')");
- asort($variation_ids);
- $all_variation_ids = implode(",", $variation_ids);
-
- $variation_priceandstock_id = $variation_priceandstock_item['id'];
- $product_id = $variation_priceandstock_item['product_id'];
-
- foreach((array)$keys as $key) {
- if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `priceandstock_id` = '{$variation_priceandstock_id}' AND `value_id` = '$key'") < 1) {
- $variation_id = $wpdb->get_var("SELECT `variation_id` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` = '{$key}'");
- if($variation_id > 0) {
- $wpdb->query("INSERT INTO `".WPSC_TABLE_VARIATION_COMBINATIONS."` ( `product_id` , `priceandstock_id` , `value_id`, `variation_id`, `all_variation_ids` ) VALUES ( '$product_id', '{$variation_priceandstock_id}', '$key', '$variation_id', '$all_variation_ids' )");
- }
- }
- }
- }
- }
- }
- */
- // Update the variation combinations table to have the all_variation_ids column
- if($wpdb->get_var("SELECT COUNT( * ) FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `all_variation_ids` IN ( '' )") == $wpdb->get_var("SELECT COUNT( * ) FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."`")) {
- $variation_priceandstock_ids = $wpdb->get_col("SELECT DISTINCT `priceandstock_id` FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."`");
- foreach($variation_priceandstock_ids as $variation_priceandstock_id) {
- $variation_priceandstock_rows = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `priceandstock_id` IN ('$variation_priceandstock_id')", ARRAY_A);
- $all_value_array = array();
- foreach($variation_priceandstock_rows as $variation_priceandstock_row) {
- $all_value_array[] = $variation_priceandstock_row['variation_id'];
- }
- asort($all_value_array);
-
- $variation_ids = $wpdb->get_col("SELECT `variation_id` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` IN ('".implode("','",$all_value_array)."')");
- asort($variation_ids);
- $all_variation_ids = implode(",", $variation_ids);
-
- $update_sql = "UPDATE `".WPSC_TABLE_VARIATION_COMBINATIONS."` SET `all_variation_ids` = '".$all_variation_ids."' WHERE `priceandstock_id` IN( '$variation_priceandstock_id' ) AND `all_variation_ids` IN( '' );";
-
- //echo "<pre>".print_r($update_sql,true)."</pre>";
- //$wpdb->query($update_sql);
- }
- }
- if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_CURRENCY_LIST."` WHERE `continent` NOT IN ('')") <230) {
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='1'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='2'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='3'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='4'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='5'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='6'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='7'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='8'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='9'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='10'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='11'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='12'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='13'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='14'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='15'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='16'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='17'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='18'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='19'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='20'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='21'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='22'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='23'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='24'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='25'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='26'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='27'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='28'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='29'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='30'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='31'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='32'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='33'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='34'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='35'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='36'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='37'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='38'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='39'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='40'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='41'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='42'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='43'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='44'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='45'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='46'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='47'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='48'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='49'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='50'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='51'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='52'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='53'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='54'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='55'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='56'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='57'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='58'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='59'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='60'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='61'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='62'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='63'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='64'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='65'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='66'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='67'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='68'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='69'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='70'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='71'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='72'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='73'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='74'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='75'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='76'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='77'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='78'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='79'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='80'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='81'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='82'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='83'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='84'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='85'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamrica' WHERE id='86'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='87'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='88'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='89'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='90'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='91'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='92'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='93'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='94'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='95'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='96'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='97'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='98'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='99'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='100'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='101'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='102'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='103'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='104'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='105'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='106'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='107'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='108'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='109'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='110'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='111'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='112'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='113'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='114'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='115'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='116'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='117'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='118'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='119'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='120'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='121'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='122'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='123'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='124'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='125'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='126'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='127'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='antarctica' WHERE id='128'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='129'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='130'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='131'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='132'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='133'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='134'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='135'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='136'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='137'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='138'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='139'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='140'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='141'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='142'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='143'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='144'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='145'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='146'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='147'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='148'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='149'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='150'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='151'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='152'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='153'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='154'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='155'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='156'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='157'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='158'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='159'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='160'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='161'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='162'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='163'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='164'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='165'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='166'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='167'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='168'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='169'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='170'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='171'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='172'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='173'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='174'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='175'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='176'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='177'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='178'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='179'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='180'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='181'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='182'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='183'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='184'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='185'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='186'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='187'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='188'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='189'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='190'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='191'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='192'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='193'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='194'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='195'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='196'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='197'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='198'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='199'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='200'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='201'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='202'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='203'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='204'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='' WHERE id='205'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='206'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='207'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='208'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='209'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='210'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='211'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='212'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='213'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='214'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='215'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='216'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='217'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='218'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='219'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='220'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='' WHERE id='221'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='222'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='223'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='224'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='225'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='226'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='227'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='' WHERE id='228'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='229'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='230'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='231'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='232'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='233'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='234'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='235'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='236'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='237'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='238'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='239'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='240'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='241'");
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='242'");
- }
- if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_CURRENCY_LIST."` WHERE `continent` IN ('asiapasific')") > 0) {
- $wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET `continent`='asiapacific' WHERE `continent`='asiapasific'");
- }
- add_option('wpsc_email_receipt', '', __('Thank you for purchasing with %shop_name%, any items to be shipped will be processed as soon as possible, any items that can be downloaded can be downloaded using the links on this page.All prices include tax and postage and packaging where applicable.You ordered these items:%product_list%%total_shipping%%total_price%', 'wpsc'), 'yes');
- add_option('wpsc_email_admin', '', __('%product_list%%total_shipping%%total_price%', 'wpsc'), 'yes');
- if(get_option('wpsc_email_receipt') == '') {
- if(get_option('email_receipt') != '') {
- update_option('wpsc_email_receipt', get_option('email_receipt'));
- } else {
- update_option('wpsc_email_receipt', __('Thank you for purchasing with %shop_name%, any items to be shipped will be processed as soon as possible, any items that can be downloaded can be downloaded using the links on this page.All prices include tax and postage and packaging where applicable.You ordered these items:%product_list%%total_shipping%%total_price%', 'wpsc'));
- }
- }
- if(get_option('wpsc_email_admin') == '') {
- if(get_option('email_admin') != '') {
- update_option('wpsc_email_admin', get_option('email_admin'));
- } else {
- update_option('wpsc_email_admin', __('%product_list%%total_shipping%%total_price%', 'wpsc'));
- }
- }
- if($wpdb->get_var("SELECT `option_id` FROM `{$wpdb->options}` WHERE `option_name` LIKE 'custom_gateway_options'") < 1) {
- update_option('custom_gateway_options', array('testmode'));
- }
- $coldata = $wpdb->get_row("SHOW COLUMNS FROM `".WPSC_TABLE_VARIATION_PROPERTIES."` LIKE 'file'",ARRAY_A);
- if($coldata['Type'] != "bigint(20) unsigned") {
- $wpdb->query("ALTER TABLE `".WPSC_TABLE_VARIATION_PROPERTIES."` CHANGE `file` `file` bigint(20) unsigned DEFAULT '0' NOT NULL");
- $variations_to_upgrade = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_VARIATION_PROPERTIES."` WHERE `file` IN ('1')",ARRAY_A);
- foreach((array)$variations_to_upgrade as $variation) {
- $new_file_id = (int)$wpdb->get_var("SELECT `file` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id` IN ('{$variation['product_id']}') LIMIT 1");
- $wpdb->query("UPDATE `".WPSC_TABLE_VARIATION_PROPERTIES."` SET `file` = '{$new_file_id}' WHERE `id` IN ('{$variation['id']}') LIMIT 1");
- }
-
- }
- // echo "<pre>".print_r(geast_option('flat_rates'),true)."</pre>";
- // update_option('base_local_shipping',8);
- // update_option('base_international_shipping',12);
- if((get_option('flat_rates') == null) || (count(get_option('flat_rates')) < 1)) {
- $local_shipping = get_option('base_local_shipping');
- $international_shipping = get_option('base_international_shipping');
- // echo $international_shipping;
- // Local Shipping Settings
- $shipping['local'] = $local_shipping;
-
- $shipping['southisland'] = $local_shipping;
- $shipping['northisland'] = $local_shipping;
-
- // International Shipping Settings
- $shipping['continental'] = $international_shipping;
- $shipping['all'] = $international_shipping;
- $shipping['canada'] = $international_shipping;
-
- $shipping['northamerica'] = $international_shipping;
- $shipping['southamerica'] = $international_shipping;
- $shipping['asiapacific'] = $international_shipping;
- $shipping['europe'] = $international_shipping;
- $shipping['africa'] = $international_shipping;
-
- //echo "<pre>".print_r($shipping,true)."</pre>";
-
- update_option('flat_rates',$shipping);
- }
- if(get_option('custom_shipping_options') == null ) {
- update_option('custom_shipping_options',array('flatrate'));
- }
- if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PURC