PageRenderTime 30ms CodeModel.GetById 9ms RepoModel.GetById 0ms app.codeStats 0ms

/wp-content/plugins/wp-e-commerce/updates/updating_tasks.php

https://gitlab.com/endomorphosis/reservationtelco
PHP | 721 lines | 541 code | 69 blank | 111 comment | 70 complexity | 382a43677b07ae7240fa1107cdbe1369 MD5 | raw file
    

  1. <?php
    2. 

  2. 

  3.   
    4. 

  4.      
    5. 

  5. /**     
    6. 

  6. // cannot currently add due to high risk of things breaking
    7. 

  7.      
    8. 

  8. if(!$wpdb->get_results("SELECT `id` FROM `".WPSC_TABLE_ALSO_BOUGHT."`")) {
    9. 

  9.   // inserts data on what was bought with what however many times 
    10. 

  10.   $product_ids = $wpdb->get_col("SELECT `id` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN('1')");
    11. 

  11.   foreach((array)$product_ids as $prodid) {
    12. 

  12.     $cart_ids = $wpdb->get_results("SELECT `purchaseid` FROM `".WPSC_TABLE_CART_CONTENTS."` WHERE `prodid` IN ('$prodid')", ARRAY_A);
    13. 

  13.     $popular_array = array();
    14. 

  14.     foreach((array)$cart_ids as $cart_id) {
    15. 

  15.       $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);
    16. 

  16.       foreach((array)$purchase_data as $purchase_row) {
    17. 

  17.         if(isset($popular_array[$purchase_row['prodid']])) {
    18. 

  18.           $popular_array[$purchase_row['prodid']]++;
    19. 

  19.         } else {
    20. 

  20.           $popular_array[$purchase_row['prodid']] = 1;
    21. 

  21.         }
    22. 

  22.       }      
    23. 

  23.     }
    24. 

  24.     foreach((array)$popular_array as $assoc_prodid => $quantity) {
    25. 

  25.       $wpdb->query("INSERT INTO `".WPSC_TABLE_ALSO_BOUGHT."` ( `id` , `selected_product` , `associated_product` , `quantity` ) VALUES ('', '$prodid', '".$assoc_prodid."', '".$quantity."' );");
    26. 

  26.     }
    27. 

  27.   }
    28. 

  28. }     
    29. 

  29.      
    30. 

  30.      
    31. 

  31.      
    32. 

  32.      
    33. 

  33. add_option('wpsc_use_pnp_cols', '', "", 'yes');
    34. 

  34. if(get_option('wpsc_use_pnp_cols') != 'true') {
    35. 

  35.   $base_country = get_option('base_country');
    36. 

  36.   $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);
    37. 

  37.   foreach((array)$results as $row) {
    38. 

  38.     if((float)$row['pnp'] != (float)$row['new_pnp']) {
    39. 

  39.       $wpdb->query("UPDATE `".WPSC_TABLE_CART_CONTENTS."` SET `pnp` = '".((float)$row['new_pnp'])."' WHERE `id` = '".$row['id']."' AND `pnp` IN('0');");
    40. 

  40.       //echo "UPDATE `wp_cart_contents` SET `pnp` = '".((float)$row['new_pnp'])."' WHERE `id` = '".$row['id']."' LIMIT 1 ;"."<br />";
    41. 

  41.       }      
    42. 

  42.     }  
    43. 

  43.     //exit();
    44. 

  44.   update_option('wpsc_use_pnp_cols','true');
    45. 

  45. }
    46. 

  46.        
    47. 

  47.      
    48. 

  48.      
    49. 

  49.      
    50. 

  50.      
    51. 

  51.  */    
    52. 

  52. if(get_option('wpsc_trackingid_message') == ''){
    53. 

  53. 	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'));
    54. 

  54. }     
    55. 

  55. if(get_option('wpsc_trackingid_subject') == ''){
    56. 

  56. 	update_option('wpsc_trackingid_subject', __('Your Order from %shop_name% has been dispatched', 'wpsc'));
    57. 

  57. }     
    58. 

  58. /* adds nice names for permalinks for products */
    59. 

  59. 

  60. $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`))");  
    61. 

  61. if($check_product_names != null) {
    62. 

  62.   $sql_query = "SELECT `id`, `name` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN('1')";
    63. 

  63.   $sql_data = $wpdb->get_results($sql_query,ARRAY_A);    
    64. 

  64.   foreach((array)$sql_data as $datarow) {
    65. 

  65.     $tidied_name = trim($datarow['name']);
    66. 

  66.     $tidied_name = strtolower($tidied_name);
    67. 

  67. 		$url_name = sanitize_title($tidied_name);
    68. 

  68.     $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);
    69. 

  69.     $extension_number = '';
    70. 

  70.     if($similar_names['count'] > 0) {
    71. 

  71.       $extension_number = (int)$similar_names['max_number']+1;
    72. 

  72. 		}
    73. 

  73.     if(get_product_meta($datarow['id'], 'url_name') != false) {
    74. 

  74.       $current_url_name = get_product_meta($datarow['id'], 'url_name');
    75. 

  75.       if($current_url_name != $url_name) {
    76. 

  76.         $url_name .= $extension_number;
    77. 

  77.         // Buggy, sometimes results in the url name swapping on every page load.
    78. 

  78.         // update_product_meta($datarow['id'], 'url_name', $url_name);
    79. 

  79. 			}
    80. 

  80. 		} else {
    81. 

  81.       $url_name .= $extension_number;
    82. 

  82.       add_product_meta($datarow['id'], 'url_name', $url_name, true);
    83. 

  83. 		}
    84. 

  84. 	}
    85. 

  85. }
    86. 

  86.      
    87. 

  87.   
    88. 

  88. /* adds nice names for permalinks for categories */
    89. 

  89. $check_category_names = $wpdb->get_results("SELECT DISTINCT `nice-name` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `nice-name` NOT IN ('')  AND `active` IN ('1')");
    90. 

  90. if($check_category_names == null) {
    91. 

  91.   $sql_query = "SELECT `id`, `name` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `active` IN('1')";
    92. 

  92.   $sql_data = $wpdb->get_results($sql_query,ARRAY_A);    
    93. 

  93.   foreach((array)$sql_data as $datarow) {
    94. 

  94.     $tidied_name = trim($datarow['name']);
    95. 

  95.     $tidied_name = strtolower($tidied_name);
    96. 

  96. 		$url_name = sanitize_title($tidied_name);     
    97. 

  97.     $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);
    98. 

  98.     $extension_number = '';
    99. 

  99.     if($similar_names['count'] > 0) {
    100. 

  100.       $extension_number = (int)$similar_names['max_number']+1;
    101. 

  101.     }
    102. 

  102.     $url_name .= $extension_number;
    103. 

  103.     $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_CATEGORIES."` SET `nice-name` = '$url_name' WHERE `id` = '".$datarow['id']."' LIMIT 1 ;");
    104. 

  104.   }
    105. 

  105. }
    106. 

  106.   
    107. 

  107. 

  108. 

  109. 

  110.   
    111. 

  111. if(!$wpdb->get_results("SELECT `id` FROM `".WPSC_TABLE_ALSO_BOUGHT."`")) {
    112. 

  112.   /* inserts data on what was bought with what however many times */
    113. 

  113.   $product_ids = $wpdb->get_col("SELECT `id` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN('1')");
    114. 

  114.   foreach((array)$product_ids as $prodid) {
    115. 

  115.     $cart_ids = $wpdb->get_results("SELECT `purchaseid` FROM `".WPSC_TABLE_CART_CONTENTS."` WHERE `prodid` IN ('$prodid')", ARRAY_A);
    116. 

  116.     $popular_array = array();
    117. 

  117.     foreach((array)$cart_ids as $cart_id) {
    118. 

  118.       $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);
    119. 

  119.       foreach((array)$purchase_data as $purchase_row) {
    120. 

  120.         if(isset($popular_array[$purchase_row['prodid']])) {
    121. 

  121.           $popular_array[$purchase_row['prodid']]++;
    122. 

  122.         } else {
    123. 

  123.           $popular_array[$purchase_row['prodid']] = 1;
    124. 

  124.         }
    125. 

  125.       }      
    126. 

  126.     }
    127. 

  127.     foreach((array)$popular_array as $assoc_prodid => $quantity) {
    128. 

  128.       $wpdb->query("INSERT INTO `".WPSC_TABLE_ALSO_BOUGHT."` ( `id` , `selected_product` , `associated_product` , `quantity` ) VALUES ('', '$prodid', '".$assoc_prodid."', '".$quantity."' );");
    129. 

  129.     }
    130. 

  130.   }
    131. 

  131. }
    132. 

  132. 

  133. 

  134. // accidentally used venue_id in an old version, it should be value id, this makes that so.
    135. 

  135. if($wpdb->get_results("SHOW FULL COLUMNS FROM `".WPSC_TABLE_CART_ITEM_VARIATIONS."` LIKE 'venue_id';",ARRAY_A)) {
    136. 

  136. 	$wpdb->query("ALTER TABLE `".WPSC_TABLE_CART_ITEM_VARIATIONS."` CHANGE `venue_id` `value_id` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' ");
    137. 

  137. }
    138. 

  138. 

  139. 

  140. if($wpdb->get_results("SHOW FULL COLUMNS FROM `".WPSC_TABLE_REGION_TAX."` LIKE 'code';",ARRAY_A)) {
    141. 

  141. 	//$wpdb->query("ALTER TABLE `".WPSC_TABLE_REGION_TAX."` ADD `code` char(2) NOT NULL default '' AFTER `name`;");    
    142. 

  142. 

  143.   if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_REGION_TAX."` WHERE `code` NOT IN ('')") < 51) {
    144. 

  144.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'AL' WHERE `name` IN('Alabama')LIMIT 1 ;");
    145. 

  145.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'AK' WHERE `name` IN('Alaska') LIMIT 1 ;");
    146. 

  146.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'AZ' WHERE `name` IN('Arizona') LIMIT 1 ;");
    147. 

  147.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'AR' WHERE `name` IN('Arkansas') LIMIT 1 ;");
    148. 

  148.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'CA' WHERE `name` IN('California') LIMIT 1 ;");
    149. 

  149.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'CO' WHERE `name` IN('Colorado') LIMIT 1 ;");
    150. 

  150.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'CT' WHERE `name` IN('Connecticut') LIMIT 1 ;");
    151. 

  151.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'DE' WHERE `name` IN('Delaware') LIMIT 1 ;");
    152. 

  152.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'FL' WHERE `name` IN('Florida') LIMIT 1 ;");
    153. 

  153.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'GA' WHERE `name` IN('Georgia')  LIMIT 1 ;");
    154. 

  154.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'HI' WHERE `name` IN('Hawaii')  LIMIT 1 ;");
    155. 

  155.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'ID' WHERE`name` IN('Idaho')  LIMIT 1 ;");
    156. 

  156.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'IL' WHERE `name` IN('Illinois')  LIMIT 1 ;");
    157. 

  157.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'IN' WHERE `name` IN('Indiana')  LIMIT 1 ;");
    158. 

  158.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'IA' WHERE `name` IN('Iowa')  LIMIT 1 ;");
    159. 

  159.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'KS' WHERE `name` IN('Kansas')  LIMIT 1 ;");
    160. 

  160.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'KY' WHERE `name` IN('Kentucky') LIMIT 1 ;");
    161. 

  161.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'LA' WHERE `name` IN('Louisiana') LIMIT 1 ;");
    162. 

  162.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'ME' WHERE `name` IN('Maine') LIMIT 1 ;");
    163. 

  163.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MD' WHERE `name` IN('Maryland') LIMIT 1 ;");
    164. 

  164.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MA' WHERE `name` IN('Massachusetts') LIMIT 1 ;");
    165. 

  165.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MI' WHERE `name` IN('Michigan') LIMIT 1 ;");
    166. 

  166.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MN' WHERE `name` IN('Minnesota') LIMIT 1 ;");
    167. 

  167.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MS' WHERE `name` IN('Mississippi') LIMIT 1 ;");
    168. 

  168.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MO' WHERE `name` IN('Missouri') LIMIT 1 ;");
    169. 

  169.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MT' WHERE `name` IN('Montana') LIMIT 1 ;");
    170. 

  170.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NE' WHERE `name` IN('Nebraska') LIMIT 1 ;");
    171. 

  171.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NV' WHERE `name` IN('Nevada') LIMIT 1 ;");
    172. 

  172.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NH' WHERE `name` IN('New Hampshire') LIMIT 1 ;");
    173. 

  173.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NJ' WHERE `name` IN('New Jersey') LIMIT 1 ;");
    174. 

  174.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NM' WHERE `name` IN('New Mexico') LIMIT 1 ;");
    175. 

  175.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NY' WHERE `name` IN('New York') LIMIT 1 ;");
    176. 

  176.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NC' WHERE `name` IN('North Carolina') LIMIT 1 ;");
    177. 

  177.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'ND' WHERE `name` IN('North Dakota') LIMIT 1 ;");
    178. 

  178.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'OH' WHERE `name` IN('Ohio') LIMIT 1 ;");
    179. 

  179.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'OK' WHERE `name` IN('Oklahoma') LIMIT 1 ;");
    180. 

  180.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'OR' WHERE `name` IN('Oregon') LIMIT 1 ;");
    181. 

  181.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'PA' WHERE `name` IN('Pennsylvania') LIMIT 1 ;");
    182. 

  182.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'RI' WHERE `name` IN('Rhode Island') LIMIT 1 ;");
    183. 

  183.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'SC' WHERE `name` IN('South Carolina') LIMIT 1 ;");
    184. 

  184.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'SD' WHERE `name` IN('South Dakota') LIMIT 1 ;");
    185. 

  185.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'TN' WHERE `name` IN('Tennessee') LIMIT 1 ;");
    186. 

  186.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'TX' WHERE `name` IN('Texas') LIMIT 1 ;");
    187. 

  187.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'UT' WHERE `name` IN('Utah') LIMIT 1 ;");
    188. 

  188.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'VT' WHERE `name` IN('Vermont') LIMIT 1 ;");
    189. 

  189.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'VA' WHERE `name` IN('Virginia') LIMIT 1 ;");
    190. 

  190.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'WA' WHERE `name` IN('Washington') LIMIT 1 ;");
    191. 

  191.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'DC' WHERE `name` IN('Washington DC') LIMIT 1 ;");
    192. 

  192.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'WV' WHERE `name` IN('West Virginia') LIMIT 1 ;");
    193. 

  193.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'WI' WHERE `name` IN('Wisconsin') LIMIT 1 ;");
    194. 

  194.     $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'WY' WHERE `name` IN('Wyoming') LIMIT 1 ;");
    195. 

  195.     
    196. 

  196. 

  197.   }
    198. 

  198. }
    199. 

  199.      
    200. 

  200.      
    201. 

  201.    
    202. 

  202.      
    203. 

  203.      
    204. 

  204.      
    205. 

  205. // if there are no default product categorisations, add them
    206. 

  206. if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_CATEGORISATION_GROUPS."`") < 1) {
    207. 

  207.   $wpdb->query("INSERT INTO `".WPSC_TABLE_CATEGORISATION_GROUPS."` (`id`, `name`, `description`, `active`, `default`) VALUES (1, 'Categories', 'Product Categories', '1', '1')");
    208. 

  208.   $wpdb->query("INSERT INTO `".WPSC_TABLE_CATEGORISATION_GROUPS."` (`id`, `name`, `description`, `active`, `default`) VALUES (2, 'Brands', 'Product Brands', '1', '0')");
    209. 

  209. }
    210. 

  210. 

  211. 

  212. $brand_group = $wpdb->get_row("SELECT * FROM `".WPSC_TABLE_CATEGORISATION_GROUPS."` WHERE `name` IN ( 'Brands' ) ",ARRAY_A);
    213. 

  213. $converted_brand_count = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `group_id` IN({$brand_group['id']}) AND `active` IN('1') ");
    214. 

  214. 

  215. 

  216. if(($converted_brand_count <= 0) && ($wpdb->get_var("SHOW TABLES LIKE '{$wpdb->prefix}product_brands'") == ($wpdb->prefix."product_brands"))) {
    217. 

  217. 	$brands = $wpdb->get_results("SELECT * FROM `{$wpdb->prefix}product_brands` ",ARRAY_A);
    218. 

  218. 	if(count($brands) > 0 ) {
    219. 

  219. 		foreach($brands as $brand) {
    220. 

  220. 			
    221. 

  221. 			$tidied_name = trim($brand['name']);
    222. 

  222. 			$tidied_name = strtolower($tidied_name);
    223. 

  223. 			$url_name = sanitize_title($tidied_name);
    224. 

  224. 			if($url_name != $category_data['nice-name']) {
    225. 

  225. 				$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);
    226. 

  226. 				
    227. 

  227. 				$extension_number = '';
    228. 

  228. 				if($similar_names['count'] > 0) {
    229. 

  229. 					$extension_number = (int)$similar_names['max_number']+1;
    230. 

  230. 				}
    231. 

  231. 				$url_name .= $extension_number;   
    232. 

  232. 			}
    233. 

  233. 			
    234. 

  234. 			$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)");
    235. 

  235. 		}  
    236. 

  236. 	}
    237. 

  237. }
    238. 

  238. 

  239. $unassociated_categories = $wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `group_id` IN ('0')");
    240. 

  240. if($unassociated_categories > 0) {
    241. 

  241.   $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_CATEGORIES."` SET `group_id` = '1' WHERE `group_id` IN ('0')");
    242. 

  242. }
    243. 

  243. 

  244. 

  245. // here is the code to update the payment gateway options.
    246. 

  246. $selected_gateways = array();
    247. 

  247. $current_gateway = get_option('payment_gateway');
    248. 

  248. $selected_gateways = get_option('custom_gateway_options');
    249. 

  249. if($current_gateway == '') {
    250. 

  250.   // set the gateway to Manual Payment if it is not set.
    251. 

  251.   $current_gateway = 'testmode'; 
    252. 

  252. }
    253. 

  253. if(get_option('payment_method') != null) {
    254. 

  254. 	switch(get_option('payment_method')) {
    255. 

  255. 		case 2:
    256. 

  256. 		// mode 2 is credit card and manual payment / test mode
    257. 

  257. 		if($current_gateway == 'testmode') {
    258. 

  258. 			$current_gateway = 'paypal_multiple';
    259. 

  259. 		}
    260. 

  260. 		$selected_gateways[] = 'testmode';
    261. 

  261. 		$selected_gateways[] = $current_gateway;
    262. 

  262. 		break;
    263. 

  263. 		
    264. 

  264. 		case 3;
    265. 

  265. 		// mode 3 is manual payment / test mode
    266. 

  266. 		$current_gateway = 'testmode';
    267. 

  267. 		case 1:
    268. 

  268. 		// mode 1 is whatever gateway is currently selected.
    269. 

  269. 		default:
    270. 

  270. 		$selected_gateways[] = $current_gateway;
    271. 

  271. 		break;
    272. 

  272. 	}
    273. 

  273. 	update_option('custom_gateway_options', $selected_gateways);
    274. 

  274. 	update_option('payment_method', null);
    275. 

  275. }
    276. 

  276. 

  277. 

  278. // here is the code to update the payment gateway options.
    279. 

  279. $selected_gateways = array();
    280. 

  280. $current_gateway = get_option('payment_gateway');
    281. 

  281. $selected_gateways = get_option('custom_gateway_options');
    282. 

  282. if($current_gateway == '') {
    283. 

  283.   // set the gateway to Manual Payment if it is not set.
    284. 

  284.   $current_gateway = 'testmode';
    285. 

  285. }
    286. 

  286. if(get_option('payment_method') != null) {
    287. 

  287. 	switch(get_option('payment_method')) {
    288. 

  288. 		case 2:
    289. 

  289. 		// mode 2 is credit card and manual payment / test mode
    290. 

  290. 		if($current_gateway == 'testmode') {
    291. 

  291. 			$current_gateway = 'paypal_multiple';
    292. 

  292. 		}
    293. 

  293. 		$selected_gateways[] = 'testmode';
    294. 

  294. 		$selected_gateways[] = $current_gateway;
    295. 

  295. 		break;
    296. 

  296. 		
    297. 

  297. 		case 3;
    298. 

  298. 		// mode 3 is manual payment / test mode
    299. 

  299. 		$current_gateway = 'testmode';
    300. 

  300. 		case 1:
    301. 

  301. 		// mode 1 is whatever gateway is currently selected.
    302. 

  302. 		default:
    303. 

  303. 		$selected_gateways[] = $current_gateway;
    304. 

  304. 		break;
    305. 

  305. 	}
    306. 

  306. 	update_option('custom_gateway_options', $selected_gateways);
    307. 

  307. 	update_option('payment_method', null);
    308. 

  308. }
    309. 

  309. 

  310. 

  311. // switch this variable over to our own option name, seems default_category was used by wordpress
    312. 

  312. if(get_option('wpsc_default_category') == null) {
    313. 

  313.   update_option('wpsc_default_category', get_option('default_category'));
    314. 

  314. }
    315. 

  315. 

  316. // Move the variation ids for the combinations to the new table
    317. 

  317. 

  318. if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."`") < 1) {
    319. 

  319.   $variation_priceandstock = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_VARIATION_PROPERTIES."`",ARRAY_A);
    320. 

  320.   
    321. 

  321.   foreach((array)$variation_priceandstock_items as $variation_priceandstock_item) {
    322. 

  322.     $keys = array();
    323. 

  323.     $keys[] = $variation_priceandstock_item['variation_id_1'];
    324. 

  324.     $keys[] = $variation_priceandstock_item['variation_id_2'];
    325. 

  325.     
    326. 

  326.     asort($keys);    
    327. 

  327.     $all_value_ids = implode(",", $keys);
    328. 

  328. 			
    329. 

  329. 			
    330. 

  330. 		$variation_ids = $wpdb->get_col("SELECT `variation_id` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` IN ('".implode("','",$keys)."')");
    331. 

  331. 		asort($variation_ids);
    332. 

  332. 		$all_variation_ids = implode(",", $variation_ids);
    333. 

  333.     
    334. 

  334.     $variation_priceandstock_id = $variation_priceandstock_item['id'];
    335. 

  335.     $product_id = $variation_priceandstock_item['product_id'];
    336. 

  336.     foreach((array)$keys as $key) {
    337. 

  337.       if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `priceandstock_id` = '{$variation_priceandstock_id}' AND `value_id` = '$key'") < 1) {
    338. 

  338.         $variation_id = $wpdb->get_var("SELECT `variation_id` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` = '{$key}'");
    339. 

  339.         if($variation_id > 0) {
    340. 

  340.           $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' )");
    341. 

  341.         }
    342. 

  342.       }
    343. 

  343.     }
    344. 

  344.   }
    345. 

  345. }
    346. 

  346. 

  347. /*
    348. 

  348. $product_ids = $wpdb->get_col("SELECT `id` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active` IN('1')");
    349. 

  349. foreach($product_ids as $product_id) {
    350. 

  350.   if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `product_id` = '{$product_id}'") < 1 ) {
    351. 

  351. 		$variation_priceandstock = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_VARIATION_PROPERTIES."` WHERE `product_id` = '{$product_id}'",ARRAY_A);
    352. 

  352. 		
    353. 

  353.   
    354. 

  354. 		foreach((array)$variation_priceandstock as $variation_priceandstock_item) {
    355. 

  355. 			$keys = array();
    356. 

  356. 			$keys[] = $variation_priceandstock_item['variation_id_1'];
    357. 

  357. 			$keys[] = $variation_priceandstock_item['variation_id_2'];
    358. 

  358. 			
    359. 

  359. 			asort($keys);    
    360. 

  360. 			$all_value_ids = implode(",", $keys);
    361. 

  361. 			
    362. 

  362. 			$variation_ids = $wpdb->get_col("SELECT `variation_id` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` IN ('".implode("','",$keys)."')");
    363. 

  363. 			asort($variation_ids);
    364. 

  364. 			$all_variation_ids = implode(",", $variation_ids);
    365. 

  365. 			
    366. 

  366. 			$variation_priceandstock_id = $variation_priceandstock_item['id'];
    367. 

  367. 			$product_id = $variation_priceandstock_item['product_id'];
    368. 

  368. 			
    369. 

  369. 			foreach((array)$keys as $key) {
    370. 

  370. 				if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `priceandstock_id` = '{$variation_priceandstock_id}' AND `value_id` = '$key'") < 1) {
    371. 

  371. 					$variation_id = $wpdb->get_var("SELECT `variation_id` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` = '{$key}'");
    372. 

  372. 					if($variation_id > 0) {
    373. 

  373. 						$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' )");
    374. 

  374. 					}
    375. 

  375. 				}
    376. 

  376. 			}
    377. 

  377. 		}
    378. 

  378. 	}
    379. 

  379. }
    380. 

  380. */
    381. 

  381. // Update the variation combinations table to have the all_variation_ids column
    382. 

  382. 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."`")) {
    383. 

  383.   $variation_priceandstock_ids = $wpdb->get_col("SELECT DISTINCT `priceandstock_id` FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."`");
    384. 

  384.   foreach($variation_priceandstock_ids as $variation_priceandstock_id) {
    385. 

  385.     $variation_priceandstock_rows = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_VARIATION_COMBINATIONS."` WHERE `priceandstock_id` IN ('$variation_priceandstock_id')", ARRAY_A);
    386. 

  386.     $all_value_array = array();
    387. 

  387.     foreach($variation_priceandstock_rows as $variation_priceandstock_row) {
    388. 

  388.       $all_value_array[] = $variation_priceandstock_row['variation_id'];
    389. 

  389.     }
    390. 

  390.     asort($all_value_array);    
    391. 

  391.     
    392. 

  392. 		$variation_ids = $wpdb->get_col("SELECT `variation_id` FROM `".WPSC_TABLE_VARIATION_VALUES."` WHERE `id` IN ('".implode("','",$all_value_array)."')");
    393. 

  393. 		asort($variation_ids);
    394. 

  394. 		$all_variation_ids = implode(",", $variation_ids);
    395. 

  395. 		
    396. 

  396.     $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( '' );";
    397. 

  397.     
    398. 

  398.     //echo "<pre>".print_r($update_sql,true)."</pre>";
    399. 

  399.     //$wpdb->query($update_sql);
    400. 

  400.   }
    401. 

  401. }
    402. 

  402. 

  403. if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_CURRENCY_LIST."` WHERE `continent` NOT IN ('')") <230) {
    404. 

  404. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='1'");
    405. 

  405. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='2'");
    406. 

  406. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='3'");
    407. 

  407. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='4'");
    408. 

  408. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='5'");
    409. 

  409. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='6'");
    410. 

  410. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='7'");
    411. 

  411. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='8'");
    412. 

  412. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='9'");
    413. 

  413. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='10'");
    414. 

  414. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='11'");
    415. 

  415. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='12'");
    416. 

  416. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='13'");
    417. 

  417. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='14'");
    418. 

  418. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='15'");
    419. 

  419. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='16'");
    420. 

  420. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='17'");
    421. 

  421. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='18'");
    422. 

  422. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='19'");
    423. 

  423. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='20'");
    424. 

  424. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='21'");
    425. 

  425. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='22'");
    426. 

  426. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='23'");
    427. 

  427. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='24'");
    428. 

  428. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='25'");
    429. 

  429. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='26'");
    430. 

  430. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='27'");
    431. 

  431. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='28'");
    432. 

  432. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='29'");
    433. 

  433. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='30'");
    434. 

  434. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='31'");
    435. 

  435. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='32'");
    436. 

  436. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='33'");
    437. 

  437. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='34'");
    438. 

  438. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='35'");
    439. 

  439. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='36'");
    440. 

  440. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='37'");
    441. 

  441. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='38'");
    442. 

  442. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='39'");
    443. 

  443. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='40'");
    444. 

  444. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='41'");
    445. 

  445. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='42'");
    446. 

  446. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='43'");
    447. 

  447. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='44'");
    448. 

  448. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='45'");
    449. 

  449. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='46'");
    450. 

  450. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='47'");
    451. 

  451. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='48'");
    452. 

  452. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='49'");
    453. 

  453. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='50'");
    454. 

  454. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='51'");
    455. 

  455. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='52'");
    456. 

  456. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='53'");
    457. 

  457. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='54'");
    458. 

  458. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='55'");
    459. 

  459. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='56'");
    460. 

  460. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='57'");
    461. 

  461. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='58'");
    462. 

  462. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='59'");
    463. 

  463. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='60'");
    464. 

  464. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='61'");
    465. 

  465. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='62'");
    466. 

  466. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='63'");
    467. 

  467. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='64'");
    468. 

  468. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='65'");
    469. 

  469. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='66'");
    470. 

  470. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='67'");
    471. 

  471. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='68'");
    472. 

  472. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='69'");
    473. 

  473. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='70'");
    474. 

  474. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='71'");
    475. 

  475. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='72'");
    476. 

  476. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='73'");
    477. 

  477. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='74'");
    478. 

  478. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='75'");
    479. 

  479. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='76'");
    480. 

  480. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='77'");
    481. 

  481. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='78'");
    482. 

  482. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='79'");
    483. 

  483. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='80'");
    484. 

  484. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='81'");
    485. 

  485. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='82'");
    486. 

  486. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='83'");
    487. 

  487. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='84'");
    488. 

  488. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='85'");
    489. 

  489. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamrica' WHERE id='86'");
    490. 

  490. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='87'");
    491. 

  491. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='88'");
    492. 

  492. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='89'");
    493. 

  493. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='90'");
    494. 

  494. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='91'");
    495. 

  495. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='92'");
    496. 

  496. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='93'");
    497. 

  497. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='94'");
    498. 

  498. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='95'");
    499. 

  499. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='96'");
    500. 

  500. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='97'");
    501. 

  501. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='98'");
    502. 

  502. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='99'");
    503. 

  503. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='100'");
    504. 

  504. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='101'");
    505. 

  505. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='102'");
    506. 

  506. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='103'");
    507. 

  507. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='104'");
    508. 

  508. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='105'");
    509. 

  509. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='106'");
    510. 

  510. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='107'");
    511. 

  511. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='108'");
    512. 

  512. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='109'");
    513. 

  513. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='110'");
    514. 

  514. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='111'");
    515. 

  515. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='112'");
    516. 

  516. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='113'");
    517. 

  517. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='114'");
    518. 

  518. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='115'");
    519. 

  519. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='116'");
    520. 

  520. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='117'");
    521. 

  521. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='118'");
    522. 

  522. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='119'");
    523. 

  523. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='120'");
    524. 

  524. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='121'");
    525. 

  525. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='122'");
    526. 

  526. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='123'");
    527. 

  527. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='124'");
    528. 

  528. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='125'");
    529. 

  529. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='126'");
    530. 

  530. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='127'");
    531. 

  531. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='antarctica' WHERE id='128'");
    532. 

  532. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='129'");
    533. 

  533. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='130'");
    534. 

  534. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='131'");
    535. 

  535. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='132'");
    536. 

  536. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='133'");
    537. 

  537. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='134'");
    538. 

  538. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='135'");
    539. 

  539. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='136'");
    540. 

  540. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='137'");
    541. 

  541. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='138'");
    542. 

  542. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='139'");
    543. 

  543. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='140'");
    544. 

  544. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='141'");
    545. 

  545. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='142'");
    546. 

  546. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='143'");
    547. 

  547. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='144'");
    548. 

  548. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='145'");
    549. 

  549. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='146'");
    550. 

  550. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='147'");
    551. 

  551. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='148'");
    552. 

  552. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='149'");
    553. 

  553. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='150'");
    554. 

  554. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='151'");
    555. 

  555. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='152'");
    556. 

  556. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='153'");
    557. 

  557. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='154'");
    558. 

  558. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='155'");
    559. 

  559. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='156'");
    560. 

  560. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='157'");
    561. 

  561. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='158'");
    562. 

  562. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='159'");
    563. 

  563. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='160'");
    564. 

  564. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='161'");
    565. 

  565. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='162'");
    566. 

  566. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='163'");
    567. 

  567. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='164'");
    568. 

  568. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='165'");
    569. 

  569. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='166'");
    570. 

  570. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='167'");
    571. 

  571. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='168'");
    572. 

  572. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='169'");
    573. 

  573. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='170'");
    574. 

  574. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='171'");
    575. 

  575. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='172'");
    576. 

  576. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='173'");
    577. 

  577. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='174'");
    578. 

  578. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='175'");
    579. 

  579. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='176'");
    580. 

  580. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='177'");
    581. 

  581. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='178'");
    582. 

  582. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='179'");
    583. 

  583. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='180'");
    584. 

  584. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='181'");
    585. 

  585. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='182'");
    586. 

  586. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='183'");
    587. 

  587. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='184'");
    588. 

  588. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='185'");
    589. 

  589. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='186'");
    590. 

  590. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='187'");
    591. 

  591. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='188'");
    592. 

  592. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='189'");
    593. 

  593. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='190'");
    594. 

  594. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='191'");
    595. 

  595. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='192'");
    596. 

  596. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='193'");
    597. 

  597. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='194'");
    598. 

  598. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='195'");
    599. 

  599. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='196'");
    600. 

  600. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='197'");
    601. 

  601. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='198'");
    602. 

  602. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='199'");
    603. 

  603. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='200'");
    604. 

  604. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='201'");
    605. 

  605. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='202'");
    606. 

  606. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='203'");
    607. 

  607. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='southamerica' WHERE id='204'");
    608. 

  608. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='' WHERE id='205'");
    609. 

  609. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='206'");
    610. 

  610. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='207'");
    611. 

  611. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='208'");
    612. 

  612. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='209'");
    613. 

  613. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='210'");
    614. 

  614. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='211'");
    615. 

  615. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='212'");
    616. 

  616. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='213'");
    617. 

  617. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='214'");
    618. 

  618. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='215'");
    619. 

  619. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='216'");
    620. 

  620. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='217'");
    621. 

  621. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='218'");
    622. 

  622. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='219'");
    623. 

  623. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='220'");
    624. 

  624. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='' WHERE id='221'");
    625. 

  625. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='222'");
    626. 

  626. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='223'");
    627. 

  627. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='224'");
    628. 

  628. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='225'");
    629. 

  629. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='226'");
    630. 

  630. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='227'");
    631. 

  631. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='' WHERE id='228'");
    632. 

  632. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='229'");
    633. 

  633. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='230'");
    634. 

  634. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='231'");
    635. 

  635. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='232'");
    636. 

  636. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='233'");
    637. 

  637. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='234'");
    638. 

  638. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='northamerica' WHERE id='235'");
    639. 

  639. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='236'");
    640. 

  640. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='237'");
    641. 

  641. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='asiapacific' WHERE id='238'");
    642. 

  642. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='239'");
    643. 

  643. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='240'");
    644. 

  644. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='africa' WHERE id='241'");
    645. 

  645. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET continent='europe' WHERE id='242'");
    646. 

  646. }
    647. 

  647. 

  648. 

  649. if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_CURRENCY_LIST."` WHERE `continent` IN ('asiapasific')") > 0) {
    650. 

  650. 	$wpdb->query("UPDATE `".WPSC_TABLE_CURRENCY_LIST."` SET `continent`='asiapacific' WHERE `continent`='asiapasific'");
    651. 

  651. }
    652. 

  652. 

  653. 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');
    654. 

  654. add_option('wpsc_email_admin', '', __('%product_list%%total_shipping%%total_price%', 'wpsc'), 'yes');
    655. 

  655. 

  656. if(get_option('wpsc_email_receipt') == '') {
    657. 

  657. 	if(get_option('email_receipt') != '') {
    658. 

  658. 		update_option('wpsc_email_receipt', get_option('email_receipt'));
    659. 

  659. 	} else {
    660. 

  660. 		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'));
    661. 

  661. 	}
    662. 

  662. }
    663. 

  663. if(get_option('wpsc_email_admin') == '') {
    664. 

  664.   if(get_option('email_admin') != '') {
    665. 

  665. 		update_option('wpsc_email_admin', get_option('email_admin'));
    666. 

  666. 	} else {
    667. 

  667. 		update_option('wpsc_email_admin', __('%product_list%%total_shipping%%total_price%', 'wpsc'));
    668. 

  668. 	}
    669. 

  669. }
    670. 

  670. 

  671. if($wpdb->get_var("SELECT `option_id` FROM `{$wpdb->options}` WHERE `option_name` LIKE 'custom_gateway_options'") < 1) {
    672. 

  672. 		update_option('custom_gateway_options', array('testmode'));
    673. 

  673. }
    674. 

  674. 

  675. $coldata  = $wpdb->get_row("SHOW COLUMNS FROM `".WPSC_TABLE_VARIATION_PROPERTIES."` LIKE 'file'",ARRAY_A);
    676. 

  676. if($coldata['Type'] != "bigint(20) unsigned")	{
    677. 

  677.   $wpdb->query("ALTER TABLE `".WPSC_TABLE_VARIATION_PROPERTIES."` CHANGE `file` `file` bigint(20) unsigned DEFAULT '0' NOT NULL");
    678. 

  678.   $variations_to_upgrade = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_VARIATION_PROPERTIES."` WHERE `file` IN ('1')",ARRAY_A);
    679. 

  679.   foreach((array)$variations_to_upgrade as $variation) {
    680. 

  680.     $new_file_id = (int)$wpdb->get_var("SELECT `file` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id` IN ('{$variation['product_id']}') LIMIT 1");
    681. 

  681.     $wpdb->query("UPDATE `".WPSC_TABLE_VARIATION_PROPERTIES."` SET `file` = '{$new_file_id}' WHERE `id` IN ('{$variation['id']}') LIMIT 1");
    682. 

  682.   }
    683. 

  683.    
    684. 

  684. }
    685. 

  685. 

  686. //   echo "<pre>".print_r(geast_option('flat_rates'),true)."</pre>";
    687. 

  687. 

  688. 

  689. // update_option('base_local_shipping',8);
    690. 

  690. // 	update_option('base_international_shipping',12);
    691. 

  691. 

  692. if((get_option('flat_rates') == null) || (count(get_option('flat_rates')) < 1)) {
    693. 

  693. 	$local_shipping = get_option('base_local_shipping');
    694. 

  694. 	$international_shipping = get_option('base_international_shipping');  
    695. 

  695. // 	echo $international_shipping;
    696. 

  696. 	// Local Shipping Settings
    697. 

  697. 	$shipping['local'] = $local_shipping;
    698. 

  698. 	
    699. 

  699. 	$shipping['southisland'] = $local_shipping;
    700. 

  700. 	$shipping['northisland'] = $local_shipping;	
    701. 

  701. 	
    702. 

  702. 	// International Shipping Settings
    703. 

  703. 	$shipping['continental'] = $international_shipping;
    704. 

  704. 	$shipping['all'] = $international_shipping;
    705. 

  705. 	$shipping['canada'] = $international_shipping;
    706. 

  706. 	
    707. 

  707. 	$shipping['northamerica'] = $international_shipping;
    708. 

  708. 	$shipping['southamerica'] = $international_shipping;
    709. 

  709. 	$shipping['asiapacific'] = $international_shipping;
    710. 

  710. 	$shipping['europe'] = $international_shipping;
    711. 

  711. 	$shipping['africa'] = $international_shipping;
    712. 

  712. 	
    713. 

  713. 	//echo "<pre>".print_r($shipping,true)."</pre>";
    714. 

  714. 	
    715. 

  715. 	update_option('flat_rates',$shipping);
    716. 

  716. }
    717. 

  717. 

  718. if(get_option('custom_shipping_options') == null ) {
    719. 

  719. 	update_option('custom_shipping_options',array('flatrate'));
    720. 

  720. }
    721. 

  721. if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_PURC
    722.