get_results("SELECT `id` FROM `".$wpdb->prefix."also_bought_product`")) {
// inserts data on what was bought with what however many times
$product_ids = $wpdb->get_col("SELECT `id` FROM `".$wpdb->prefix."product_list` WHERE `active` IN('1')");
foreach((array)$product_ids as $prodid) {
$cart_ids = $wpdb->get_results("SELECT `purchaseid` FROM `".$wpdb->prefix."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 `".$wpdb->prefix."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 `".$wpdb->prefix."also_bought_product` ( `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 `{$wpdb->prefix}cart_contents`.`id`, `{$wpdb->prefix}cart_contents`.`pnp`, IF((`{$wpdb->prefix}purchase_logs`.`shipping_country` IN('$base_country')), `{$wpdb->prefix}product_list`.`pnp`, `{$wpdb->prefix}product_list`.`international_pnp`) AS `new_pnp` FROM `{$wpdb->prefix}cart_contents`, `{$wpdb->prefix}purchase_logs`, `{$wpdb->prefix}product_list` WHERE `{$wpdb->prefix}cart_contents`.`purchaseid` IN(`{$wpdb->prefix}purchase_logs`.`id`) AND `{$wpdb->prefix}cart_contents`.`prodid` IN(`{$wpdb->prefix}product_list`.`id`) ",ARRAY_A);
foreach((array)$results as $row) {
if((float)$row['pnp'] != (float)$row['new_pnp']) {
$wpdb->query("UPDATE `{$wpdb->prefix}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 ;"."
";
}
}
//exit();
update_option('wpsc_use_pnp_cols','true');
}
*/
/* adds nice names for permalinks for products */
$check_product_names = $wpdb->get_results("SELECT `".$wpdb->prefix."product_list`.`id`, `".$wpdb->prefix."product_list`.`name`, `".$wpdb->prefix."wpsc_productmeta`.`meta_key` FROM `".$wpdb->prefix."product_list` LEFT JOIN `".$wpdb->prefix."wpsc_productmeta` ON `".$wpdb->prefix."product_list`.`id` = `".$wpdb->prefix."wpsc_productmeta`.`product_id` WHERE (`".$wpdb->prefix."wpsc_productmeta`.`meta_key` IN ('url_name') AND `".$wpdb->prefix."wpsc_productmeta`.`meta_value` IN ('')) OR ISNULL(`".$wpdb->prefix."wpsc_productmeta`.`meta_key`)");
if($check_product_names != null) {
$sql_query = "SELECT `id`, `name` FROM `".$wpdb->prefix."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 = preg_replace(array("/(\s)+/","/[^\w-]+/"), array("-", ''), $tidied_name);
$similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`meta_value`, '$url_name', '')) AS `max_number` FROM `".$wpdb->prefix."wpsc_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 `".$wpdb->prefix."product_categories` WHERE `nice-name` NOT IN ('') AND `active` IN ('1')");
if($check_category_names == null) {
$sql_query = "SELECT `id`, `name` FROM `".$wpdb->prefix."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 = preg_replace(array("/(\s)+/","/[^\w-]+/"), array("-", ''), $tidied_name);
$similar_names = $wpdb->get_row("SELECT COUNT(*) AS `count`, MAX(REPLACE(`nice-name`, '$url_name', '')) AS `max_number` FROM `".$wpdb->prefix."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 `".$wpdb->prefix."product_categories` SET `nice-name` = '$url_name' WHERE `id` = '".$datarow['id']."' LIMIT 1 ;");
}
}
if(!$wpdb->get_results("SELECT `id` FROM `".$wpdb->prefix."also_bought_product`")) {
/* inserts data on what was bought with what however many times */
$product_ids = $wpdb->get_col("SELECT `id` FROM `".$wpdb->prefix."product_list` WHERE `active` IN('1')");
foreach((array)$product_ids as $prodid) {
$cart_ids = $wpdb->get_results("SELECT `purchaseid` FROM `".$wpdb->prefix."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 `".$wpdb->prefix."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 `".$wpdb->prefix."also_bought_product` ( `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 `".$wpdb->prefix."cart_item_variations` LIKE 'venue_id';",ARRAY_A)) {
$wpdb->query("ALTER TABLE `".$wpdb->prefix."cart_item_variations` CHANGE `venue_id` `value_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' ");
}
if($wpdb->get_results("SHOW FULL COLUMNS FROM `".$wpdb->prefix."region_tax` LIKE 'code';",ARRAY_A)) {
//$wpdb->query("ALTER TABLE `".$wpdb->prefix."region_tax` ADD `code` char(2) NOT NULL default '' AFTER `name`;");
if($wpdb->get_var("SELECT COUNT(*) FROM `".$wpdb->prefix."region_tax` WHERE `code` NOT IN ('')") < 51) {
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'AL' WHERE `name` IN('Alabama')LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'AK' WHERE `name` IN('Alaska') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'AZ' WHERE `name` IN('Arizona') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'AR' WHERE `name` IN('Arkansas') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'CA' WHERE `name` IN('California') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'CO' WHERE `name` IN('Colorado') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'CT' WHERE `name` IN('Connecticut') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'DE' WHERE `name` IN('Delaware') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'FL' WHERE `name` IN('Florida') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'GA' WHERE `name` IN('Georgia') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'HI' WHERE `name` IN('Hawaii') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'ID' WHERE`name` IN('Idaho') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'IL' WHERE `name` IN('Illinois') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'IN' WHERE `name` IN('Indiana') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'IA' WHERE `name` IN('Iowa') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'KS' WHERE `name` IN('Kansas') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'KY' WHERE `name` IN('Kentucky') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'LA' WHERE `name` IN('Louisiana') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'ME' WHERE `name` IN('Maine') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MD' WHERE `name` IN('Maryland') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MA' WHERE `name` IN('Massachusetts') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MI' WHERE `name` IN('Michigan') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MN' WHERE `name` IN('Minnesota') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MS' WHERE `name` IN('Mississippi') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MO' WHERE `name` IN('Missouri') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'MT' WHERE `name` IN('Montana') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NE' WHERE `name` IN('Nebraska') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NV' WHERE `name` IN('Nevada') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NH' WHERE `name` IN('New Hampshire') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NJ' WHERE `name` IN('New Jersey') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NM' WHERE `name` IN('New Mexico') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NY' WHERE `name` IN('New York') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'NC' WHERE `name` IN('North Carolina') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'ND' WHERE `name` IN('North Dakota') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'OH' WHERE `name` IN('Ohio') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'OK' WHERE `name` IN('Oklahoma') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'OR' WHERE `name` IN('Oregon') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'PA' WHERE `name` IN('Pennsylvania') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'RI' WHERE `name` IN('Rhode Island') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'SC' WHERE `name` IN('South Carolina') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'SD' WHERE `name` IN('South Dakota') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'TN' WHERE `name` IN('Tennessee') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'TX' WHERE `name` IN('Texas') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'UT' WHERE `name` IN('Utah') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'VT' WHERE `name` IN('Vermont') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'VA' WHERE `name` IN('Virginia') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'WA' WHERE `name` IN('Washington') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'DC' WHERE `name` IN('Washington DC') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'WV' WHERE `name` IN('West Virginia') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."region_tax` SET `code` = 'WI' WHERE `name` IN('Wisconsin') LIMIT 1 ;");
$wpdb->query("UPDATE `".$wpdb->prefix."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 `{$wpdb->prefix}wpsc_categorisation_groups`") < 1) {
$wpdb->query("INSERT INTO `{$wpdb->prefix}wpsc_categorisation_groups` (`id`, `name`, `description`, `active`, `default`) VALUES (1, 'Categories', 'Product Categories', '1', '1')");
$wpdb->query("INSERT INTO `{$wpdb->prefix}wpsc_categorisation_groups` (`id`, `name`, `description`, `active`, `default`) VALUES (2, 'Brands', 'Product Brands', '1', '0')");
}
$brand_group = $wpdb->get_row("SELECT * FROM `{$wpdb->prefix}wpsc_categorisation_groups` WHERE `name` IN ( 'Brands' ) ",ARRAY_A);
$converted_brand_count = $wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}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 = preg_replace(array("/(\s)+/","/[^\w-]+/"), array("-", ''), $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 `".$wpdb->prefix."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 `{$wpdb->prefix}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 `{$wpdb->prefix}product_categories` WHERE `group_id` IN ('0')");
if($unassociated_categories > 0) {
$wpdb->query("UPDATE `{$wpdb->prefix}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 `{$wpdb->prefix}wpsc_variation_combinations`") < 1) {
$variation_priceandstock = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}variation_priceandstock`",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 `{$wpdb->prefix}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 `{$wpdb->prefix}wpsc_variation_combinations` WHERE `priceandstock_id` = '{$variation_priceandstock_id}' AND `value_id` = '$key'") < 1) {
$variation_id = $wpdb->get_var("SELECT `variation_id` FROM `{$wpdb->prefix}variation_values` WHERE `id` = '{$key}'");
if($variation_id > 0) {
$wpdb->query("INSERT INTO `{$wpdb->prefix}wpsc_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 `".$wpdb->prefix."product_list` WHERE `active` IN('1')");
foreach($product_ids as $product_id) {
if($wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}wpsc_variation_combinations` WHERE `product_id` = '{$product_id}'") < 1 ) {
$variation_priceandstock = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}variation_priceandstock` 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 `{$wpdb->prefix}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 `{$wpdb->prefix}wpsc_variation_combinations` WHERE `priceandstock_id` = '{$variation_priceandstock_id}' AND `value_id` = '$key'") < 1) {
$variation_id = $wpdb->get_var("SELECT `variation_id` FROM `{$wpdb->prefix}variation_values` WHERE `id` = '{$key}'");
if($variation_id > 0) {
$wpdb->query("INSERT INTO `{$wpdb->prefix}wpsc_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 `{$wpdb->prefix}wpsc_variation_combinations` WHERE `all_variation_ids` IN ( '' )") > 0 ) {
$variation_priceandstock_ids = $wpdb->get_col("SELECT DISTINCT `priceandstock_id` FROM `{$wpdb->prefix}wpsc_variation_combinations`");
foreach($variation_priceandstock_ids as $variation_priceandstock_id) {
$variation_priceandstock_rows = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}wpsc_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 `{$wpdb->prefix}variation_values` WHERE `id` IN ('".implode("','",$all_value_array)."')");
asort($variation_ids);
$all_variation_ids = implode(",", $variation_ids);
$update_sql = "UPDATE `{$wpdb->prefix}wpsc_variation_combinations` SET `all_variation_ids` = '".$all_variation_ids."' WHERE `priceandstock_id` IN( '$variation_priceandstock_id' );";
//echo "".print_r($update_sql,true)."
";
$wpdb->query($update_sql);
}
}
if($wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}currency_list` WHERE `continent` NOT IN ('')") < 242) {
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='1'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='2'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='3'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='4'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='5'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='6'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='7'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='8'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='9'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='10'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='11'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='12'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='13'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='14'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='15'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='16'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='17'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='18'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='19'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='20'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='21'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='22'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='23'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='24'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='25'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='26'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='27'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='28'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='29'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='30'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='31'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='32'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='33'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='34'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='35'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='36'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='37'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='38'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='39'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='40'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='41'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='42'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='43'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='44'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='45'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='46'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='47'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='48'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='49'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='50'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='51'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='52'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='53'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='54'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='55'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='56'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='57'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='58'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='59'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='60'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='61'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='62'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='63'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='64'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='65'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='66'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='67'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='68'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='69'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='70'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='71'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='72'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='73'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='74'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='75'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='76'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='77'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='78'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='79'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='80'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='81'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='82'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='83'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='84'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='85'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamrica' WHERE id='86'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='87'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='88'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='89'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='90'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='91'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='92'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='93'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='94'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='95'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='96'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='97'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='98'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='99'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='100'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='101'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='102'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='103'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='104'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='105'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='106'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='107'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='108'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='109'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='110'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='111'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='112'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='113'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='114'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='115'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='116'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='117'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='118'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='119'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='120'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='121'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='122'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='123'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='124'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='125'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='126'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='127'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='antarctica' WHERE id='128'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='129'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='130'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='131'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='132'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='133'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='134'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='135'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='136'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='137'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='138'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='139'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='140'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='141'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='142'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='143'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='144'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='145'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='146'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='147'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='148'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='149'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='150'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='151'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='152'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='153'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='154'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='155'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='156'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='157'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='158'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='159'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='160'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='161'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='162'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='163'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='164'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='165'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='166'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='167'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='168'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='169'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='170'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='171'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='172'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='173'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='174'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='175'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='176'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='177'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='178'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='179'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='180'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='181'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='182'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='183'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='184'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='185'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='186'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='187'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='188'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='189'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='190'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='191'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='192'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='193'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='194'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='195'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='196'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='197'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='198'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='199'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='200'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='201'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='202'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='203'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='southamerica' WHERE id='204'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='' WHERE id='205'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='206'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='207'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='208'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='209'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='210'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='211'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='212'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='213'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='214'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='215'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='216'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='217'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='218'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='219'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='220'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='' WHERE id='221'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='222'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='223'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='224'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='225'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='226'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='227'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='' WHERE id='228'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='229'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='230'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='231'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='232'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='233'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='234'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='northamerica' WHERE id='235'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='236'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='237'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='asiapacific' WHERE id='238'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='239'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='240'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='africa' WHERE id='241'");
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET continent='europe' WHERE id='242'");
}
if($wpdb->get_var("SELECT COUNT(*) FROM `{$wpdb->prefix}currency_list` WHERE `continent` IN ('asiapasific')") > 0) {
$wpdb->query("UPDATE `{$wpdb->prefix}currency_list` SET `continent`='asiapacific' WHERE `continent`='asiapasific'");
}
add_option('wpsc_email_receipt', '', TXT_WPSC_DEFAULT_PURCHASE_RECEIPT, 'yes');
add_option('wpsc_email_admin', '', TXT_WPSC_DEFAULT_PURCHASE_REPORT, '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', TXT_WPSC_DEFAULT_PURCHASE_RECEIPT);
}
}
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', TXT_WPSC_DEFAULT_PURCHASE_REPORT);
}
}
$coldata = $wpdb->get_row("SHOW COLUMNS FROM `{$wpdb->prefix}variation_priceandstock` LIKE 'file'",ARRAY_A);
if($coldata['Type'] != "bigint(20) unsigned") {
$wpdb->query("ALTER TABLE `{$wpdb->prefix}variation_priceandstock` CHANGE `file` `file` bigint(20) unsigned DEFAULT '0' NOT NULL");
$variations_to_upgrade = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}variation_priceandstock` WHERE `file` IN ('1')",ARRAY_A);
foreach((array)$variations_to_upgrade as $variation) {
$new_file_id = (int)$wpdb->get_var("SELECT `file` FROM `{$wpdb->prefix}product_list` WHERE `id` IN ('{$variation['product_id']}') LIMIT 1");
$wpdb->query("UPDATE `{$wpdb->prefix}variation_priceandstock` SET `file` = '{$new_file_id}' WHERE `id` IN ('{$variation['id']}') LIMIT 1");
}
}
// echo "".print_r(geast_option('flat_rates'),true)."";
// 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 "".print_r($shipping,true)."
";
update_option('flat_rates',$shipping);
}
if(get_option('custom_shipping_options') == null ) {
update_option('custom_shipping_options',array('flatrate'));
}
?>