PageRenderTime 39ms CodeModel.GetById 12ms RepoModel.GetById 1ms app.codeStats 0ms

/wp-content/plugins/wp-e-commerce/wpsc-core/wpsc-installer.php

https://github.com/AaronFernandes/aquestionof
PHP | 802 lines | 595 code | 129 blank | 78 comment | 125 complexity | d07546c449de00c292cb0e65e5b60ca1 MD5 | raw file
Possible License(s): AGPL-1.0, GPL-2.0 
    

  1. <?php
    2. 

  2. 

  3. function wpsc_auto_update() {
    4. 

  4. 	global $wpdb;
    5. 

  5. 

  6. 	include( WPSC_FILE_PATH . '/wpsc-updates/updating_tasks.php' );
    7. 

  7. 

  8. 	wpsc_create_or_update_tables();
    9. 

  9. 	wpsc_create_upload_directories();
    10. 

  10. 	wpsc_product_files_htaccess();
    11. 

  11. 	wpsc_check_and_copy_files();
    12. 

  12. 	
    13. 

  13. 	$wpsc_version = get_option( 'wpsc_version' );
    14. 

  14. 	$wpsc_minor_version = get_option( 'wspc_minor_version' );
    15. 

  15. 	
    16. 

  16. 	if ( $wpsc_version === false )
    17. 

  17. 		add_option( 'wpsc_version', WPSC_VERSION, '', 'yes' );
    18. 

  18. 	else
    19. 

  19. 		update_option( 'wpsc_version', WPSC_VERSION );
    20. 

  20. 		
    21. 

  21. 	if ( $wpsc_minor_version === false )
    22. 

  22. 		add_option( 'wpsc_minor_version', WPSC_MINOR_VERSION, '', 'yes' );
    23. 

  23. 	else
    24. 

  24. 		update_option( 'wpsc_minor_version', WPSC_MINOR_VERSION );
    25. 

  25. 	
    26. 

  26. 	if ( version_compare( $wpsc_version, '3.8', '<' ) )
    27. 

  27. 		update_option( 'wpsc_needs_update', true );
    28. 

  28. 	else
    29. 

  29. 		update_option( 'wpsc_needs_update', false );
    30. 

  30. }
    31. 

  31. 

  32. function wpsc_install() {
    33. 

  33. 	global $wpdb, $user_level, $wp_rewrite, $wp_version, $wpsc_page_titles;
    34. 

  34. 

  35. 	$table_name    = $wpdb->prefix . "wpsc_product_list";
    36. 

  36. 	$first_install = false;
    37. 

  37. 	$result        = mysql_list_tables( DB_NAME );
    38. 

  38. 	$tables        = array();
    39. 

  39. 

  40. 	while ( $row = mysql_fetch_row( $result ) )
    41. 

  41. 		$tables[] = $row[0];
    42. 

  42. 

  43. 	if ( !in_array( $table_name, $tables ) ) {
    44. 

  44. 		$first_install = true;
    45. 

  45. 		add_option( 'wpsc_purchaselogs_fixed', true );
    46. 

  46. 	}
    47. 

  47. 	
    48. 

  48. 	if ( !$first_install )
    49. 

  49. 		wpsc_regenerate_thumbnails();
    50. 

  50. 

  51. 	// run the create or update code here.
    52. 

  52. 	wpsc_create_or_update_tables();
    53. 

  53. 	wpsc_create_upload_directories();
    54. 

  54. 

  55. 	if ( !wp_get_schedule( "wpsc_hourly_cron_tasks" ) )
    56. 

  56. 		wp_schedule_event( time(), 'hourly', 'wpsc_hourly_cron_tasks' );
    57. 

  57. 

  58. 	if ( !wp_get_schedule( "wpsc_daily_cron_tasks" ) )
    59. 

  59. 		wp_schedule_event( time(), 'daily', 'wpsc_daily_cron_tasks' );
    60. 

  60. 

  61. 	// All code to add new database tables and columns must be above here
    62. 

  62. 	$wpsc_version = get_option( 'wpsc_version', 0 );
    63. 

  63. 	$wpsc_minor_version = get_option( 'wspc_minor_version', 0 );
    64. 

  64. 	
    65. 

  65. 	if ( $wpsc_version === false )
    66. 

  66. 		add_option( 'wpsc_version', WPSC_VERSION, '', 'yes' );
    67. 

  67. 	else
    68. 

  68. 		update_option( 'wpsc_version', WPSC_VERSION );
    69. 

  69. 		
    70. 

  70. 	if ( $wpsc_minor_version === false )
    71. 

  71. 		add_option( 'wpsc_minor_version', WPSC_MINOR_VERSION, '', 'yes' );
    72. 

  72. 	else
    73. 

  73. 		update_option( 'wpsc_minor_version', WPSC_MINOR_VERSION );
    74. 

  74. 

  75. 	if ( version_compare( $wpsc_version, '3.8', '<' ) )
    76. 

  76. 		update_option( 'wpsc_needs_update', true );
    77. 

  77. 	else
    78. 

  78. 		update_option( 'wpsc_needs_update', false );
    79. 

  79. 	
    80. 

  80. 	if('' == get_option('show_subcatsprods_in_cat'))
    81. 

  81. 		update_option('show_subcatsprods_in_cat',0);
    82. 

  82. 

  83. 	if('' == get_option('wpsc_share_this'))
    84. 

  84. 		update_option('wpsc_share_this',0);
    85. 

  85. 

  86. 	if('' == get_option('wpsc_crop_thumbnails'))
    87. 

  87. 		update_option('wpsc_crop_thumbnails',0);
    88. 

  88. 

  89. 	if('' == get_option('wpsc_products_per_page'))
    90. 

  90. 		update_option('wpsc_products_per_page',0);
    91. 

  91. 

  92. 	if('' == get_option('wpsc_force_ssl'))
    93. 

  93. 		update_option('wpsc_force_ssl',0);
    94. 

  94. 

  95. 	if('' == get_option('use_pagination'))
    96. 

  96. 		update_option('use_pagination',0);
    97. 

  97. 

  98. 	if('' == get_option('hide_name_link'))
    99. 

  99. 		update_option('hide_name_link',0);
    100. 

  100. 

  101. 	if('' == get_option('wpsc_enable_comments'))
    102. 

  102. 		update_option('wpsc_enable_comments',0);
    103. 

  103. 

  104. 	if('' == get_option('multi_add'))
    105. 

  105. 		update_option('multi_add',0);
    106. 

  106. 

  107. 	if('' == get_option('hide_addtocart_button'))
    108. 

  108. 		update_option('hide_addtocart_button',0);
    109. 

  109. 

  110. 	if('' == get_option('wpsc_addtocart_or_buynow'))
    111. 

  111. 		update_option('wpsc_addtocart_or_buynow',0);
    112. 

  112. 

  113. 	
    114. 

  114. 	add_option( 'show_thumbnails', 1, '', "yes" );
    115. 

  115. 	add_option( 'show_thumbnails_thickbox', 1, '', "yes" );
    116. 

  116. 

  117. 	add_option( 'product_list_url', '', '', 'yes' );
    118. 

  118. 	add_option( 'shopping_cart_url', '', '', 'yes' );
    119. 

  119. 	add_option( 'checkout_url', '', '', 'yes' );
    120. 

  120. 	add_option( 'transact_url', '', '', 'yes' );
    121. 

  121. 	add_option( 'payment_gateway', '','', 'yes' );
    122. 

  122. 	
    123. 

  123. 	$default_payment_gateways_names = array(
    124. 

  124. 		'chronopay'						=> '',
    125. 

  125. 		'google'						=> '',
    126. 

  126. 		'wpsc_merchant_paypal_express'	=> '',
    127. 

  127. 		'wpsc_merchant_paypal_pro'		=> '',
    128. 

  128. 		'wpsc_merchant_paypal_standard'	=> ''
    129. 

  129. 	);
    130. 

  130. 	$existing_payment_gateways_names = get_option( 'payment_gateway_names' );
    131. 

  131. 	$new_payment_gatewats_name = array_merge($default_payment_gateways_names, (array)$existing_payment_gateways_names);
    132. 

  132. 	update_option( 'payment_gateway_names', $new_payment_gatewats_name );
    133. 

  133. 

  134. 

  135. 	if ( function_exists( 'register_sidebar' ) )
    136. 

  136. 		add_option( 'cart_location', '4','', 'yes' );
    137. 

  137. 	else
    138. 

  138. 		add_option( 'cart_location', '1', '', 'yes' );
    139. 

  139. 

  140. 	add_option( 'currency_type', '156','', 'yes' );
    141. 

  141. 	add_option( 'currency_sign_location', '3', '', 'yes' );
    142. 

  142. 

  143. 	add_option( 'gst_rate', '1','', 'yes' );
    144. 

  144. 

  145. 	add_option( 'max_downloads', '1','', 'yes' );
    146. 

  146. 

  147. 	add_option( 'display_pnp', '1', '', 'yes' );
    148. 

  148. 

  149. 	add_option( 'display_specials', '1', '', 'yes' );
    150. 

  150. 	add_option( 'do_not_use_shipping', '1', '', 'yes' );
    151. 

  151. 

  152. 	add_option( 'postage_and_packaging', '0','', 'yes' );
    153. 

  153. 

  154. 	add_option( 'purch_log_email', '', '', 'yes' );
    155. 

  155. 	add_option( 'return_email', '', '', 'yes' );
    156. 

  156. 	add_option( 'terms_and_conditions', '', '', 'yes' );
    157. 

  157. 

  158. 	add_option( 'google_key', 'none', '', 'yes' );
    159. 

  159. 	add_option( 'google_id', 'none', '', 'yes' );
    160. 

  160. 

  161. 	add_option( 'default_brand', 'none', '', 'yes' );
    162. 

  162. 	add_option( 'wpsc_default_category', 'all', '', 'yes' );
    163. 

  163. 

  164. 	add_option( 'product_view', 'default', "", 'yes' );
    165. 

  165. 	add_option( 'add_plustax', 'default', "", '1' );
    166. 

  166. 

  167. 

  168. 	add_option( 'nzshpcrt_first_load', '0', "", 'yes' );
    169. 

  169. 

  170. 	if ( !((get_option( 'show_categorybrands' ) > 0) && (get_option( 'show_categorybrands' ) < 3)) )
    171. 

  171. 		update_option( 'show_categorybrands', 2 );
    172. 

  172. 

  173. 	// PayPal options
    174. 

  174. 	add_option( 'paypal_business', '', '', 'yes' );
    175. 

  175. 	add_option( 'paypal_url', '', '', 'yes' );
    176. 

  176. 	add_option( 'paypal_ipn', '1', '', 'yes' );
    177. 

  177. 

  178. 

  179. 	add_option( 'paypal_multiple_business', '', '', 'yes' );
    180. 

  180. 

  181. 	add_option( 'paypal_multiple_url', "https://www.paypal.com/cgi-bin/webscr" );
    182. 

  182. 

  183. 	add_option( 'product_ratings', '0', '', 'yes' );
    184. 

  184. 	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.
    185. 

  185. 	You ordered these items: 
    186. 

  186. 	%product_list%%total_shipping%%total_price%', 'wpsc' ), '', 'yes' );
    187. 

  187. 	add_option( 'wpsc_email_admin', __( '%product_list%%total_shipping%%total_price%', 'wpsc' ), '','yes' );
    188. 

  188. 

  189. 	add_option( 'wpsc_selected_theme', 'default', '', 'yes' );
    190. 

  190. 	
    191. 

  191. 	add_option( 'product_image_height', 148);
    192. 

  192. 	add_option( 'product_image_width', 148);
    193. 

  193. 

  194. 	add_option( 'category_image_height', 148 );
    195. 

  195. 	add_option( 'category_image_width', 148 );
    196. 

  196. 	
    197. 

  197. 	add_option( 'single_view_image_height', 148 );
    198. 

  198. 	add_option( 'single_view_image_width', 148 );
    199. 

  199. 

  200. 	add_option( 'wpsc_gallery_image_height', 31 );
    201. 

  201. 	add_option( 'wpsc_gallery_image_width', 31 );
    202. 

  202. 	
    203. 

  203. 	add_option( 'wpsc_thousands_separator', ',' );
    204. 

  204. 	add_option( 'wpsc_decimal_separator', '.' );
    205. 

  205. 

  206. 	add_option( 'custom_gateway_options', array('wpsc_merchant_testmode'), '', 'yes' );
    207. 

  207. 

  208. 	add_option( 'wpsc_category_url_cache', array(), '', 'yes' );
    209. 

  209. 

  210. 	// add in some default tax settings
    211. 

  211. 	add_option( 'wpec_taxes_inprice', 'exclusive' );
    212. 

  212. 	
    213. 

  213. 	add_option( 'wpec_taxes_product', 'replace' );
    214. 

  214. 

  215. 	add_option( 'wpec_taxes_logic', 'billing' );
    216. 

  216. 	
    217. 

  217. 	wpsc_product_files_htaccess();
    218. 

  218. 

  219. 	/*
    220. 

  220. 	 * This part creates the pages and automatically puts their URLs into the options page.
    221. 

  221. 	 * As you can probably see, it is very easily extendable, just pop in your page and the deafult content in the array and you are good to go.
    222. 

  222. 	 */
    223. 

  223. 	$post_date = date( "Y-m-d H:i:s" );
    224. 

  224. 	$post_date_gmt = gmdate( "Y-m-d H:i:s" );
    225. 

  225. 

  226. 	$pages = array(
    227. 

  227. 		'products-page' => array(
    228. 

  228. 			'name' => 'products-page',
    229. 

  229. 			'title' => __( 'Products Page', 'wpsc' ),
    230. 

  230. 			'tag' => '[productspage]',
    231. 

  231. 			'option' => 'product_list_url'
    232. 

  232. 		),
    233. 

  233. 		'checkout' => array(
    234. 

  234. 			'name' => 'checkout',
    235. 

  235. 			'title' => __( 'Checkout', 'wpsc' ),
    236. 

  236. 			'tag' => '[shoppingcart]',
    237. 

  237. 			'option' => 'shopping_cart_url'
    238. 

  238. 		),
    239. 

  239. 		'transaction-results' => array(
    240. 

  240. 			'name' => 'transaction-results',
    241. 

  241. 			'title' => __( 'Transaction Results', 'wpsc' ),
    242. 

  242. 			'tag' => '[transactionresults]',
    243. 

  243. 			'option' => 'transact_url'
    244. 

  244. 		),
    245. 

  245. 		'your-account' => array(
    246. 

  246. 			'name' => 'your-account',
    247. 

  247. 			'title' => __( 'Your Account', 'wpsc' ),
    248. 

  248. 			'tag' => '[userlog]',
    249. 

  249. 			'option' => 'user_account_url'
    250. 

  250. 		)
    251. 

  251. 	); 
    252. 

  252. 	
    253. 

  253. 	//indicator. if we will create any new pages we need to flush.. :)
    254. 

  254. 	$newpages = false;
    255. 

  255. 	
    256. 

  256. 	//get products page id. if there's no products page then create one
    257. 

  257. 	$products_page_id = $wpdb->get_var("SELECT id FROM `" . $wpdb->posts . "` WHERE `post_content` LIKE '%" . $pages['products-page']['tag'] . "%'	AND `post_type` != 'revision'");
    258. 

  258. 	if( empty($products_page_id) ){
    259. 

  259. 		$products_page_id = wp_insert_post( array(
    260. 

  260. 			'post_title' 	=>	$pages['products-page']['title'],
    261. 

  261. 			'post_type' 	=>	'page',
    262. 

  262. 			'post_name'		=>	$pages['products-page']['name'],
    263. 

  263. 			'comment_status'=>	'closed',
    264. 

  264. 			'ping_status' 	=>	'closed',
    265. 

  265. 			'post_content' 	=>	$pages['products-page']['tag'],
    266. 

  266. 			'post_status' 	=>	'publish',
    267. 

  267. 			'post_author' 	=>	1,
    268. 

  268. 			'menu_order'	=>	0
    269. 

  269. 		));
    270. 

  270. 		$newpages = true;
    271. 

  271. 	}
    272. 

  272. 	update_option( $pages['products-page']['option'], _get_page_link($products_page_id) );
    273. 

  273. 	//done. products page created. no we can unset products page data and create all other pages.
    274. 

  274. 	
    275. 

  275. 	//unset products page
    276. 

  276. 	unset($pages['products-page']);
    277. 

  277. 	
    278. 

  278. 	//create other pages
    279. 

  279. 	foreach( (array)$pages as $page ){
    280. 

  280. 		//check if page exists and get it's ID
    281. 

  281. 		$page_id = $wpdb->get_var("SELECT id FROM `" . $wpdb->posts . "` WHERE `post_content` LIKE '%" . $page['tag'] . "%'	AND `post_type` != 'revision'");
    282. 

  282. 		//if there's no page - create
    283. 

  283. 		if( empty($page_id) ){
    284. 

  284. 			$page_id = wp_insert_post( array(
    285. 

  285. 				'post_title' 	=>	$page['title'],
    286. 

  286. 				'post_type' 	=>	'page',
    287. 

  287. 				'post_name'		=>	$page['name'],
    288. 

  288. 				'comment_status'=>	'closed',
    289. 

  289. 				'ping_status' 	=>	'closed',
    290. 

  290. 				'post_content' 	=>	$page['tag'],
    291. 

  291. 				'post_status' 	=>	'publish',
    292. 

  292. 				'post_author' 	=>	1,
    293. 

  293. 				'menu_order'	=>	0,
    294. 

  294. 				'post_parent'	=>	$products_page_id
    295. 

  295. 			));
    296. 

  296. 			$newpages = true;
    297. 

  297. 		}
    298. 

  298. 		//update option
    299. 

  299. 		update_option( $page['option'], get_permalink( $page_id ) );
    300. 

  300. 		//also if this is shopping_cart, then update checkout url option
    301. 

  301. 		if ( $page['option'] == 'shopping_cart_url' )
    302. 

  302. 			update_option( 'checkout_url', get_permalink( $page_id ) );
    303. 

  303. 	}
    304. 

  304. 

  305. 	//if we have created any new pages, then flush... do we need to do this? probably should be removed
    306. 

  306. 	if ( $newpages ) {
    307. 

  307. 		wp_cache_delete( 'all_page_ids', 'pages' );
    308. 

  308. 		$wp_rewrite->flush_rules();
    309. 

  309. 	}
    310. 

  310. 	// Product categories, temporarily register them to create first default category if none exist
    311. 

  311. 	// @todo: investigate those require once lines and move them to right place (not from here, but from their original location, which seems to be wrong, since i cant access wpsc_register_post_types and wpsc_update_categorymeta here) - Vales <v.bakaitis@gmail.com>
    312. 

  312. 	require_once( WPSC_FILE_PATH . '/wpsc-core/wpsc-functions.php' );
    313. 

  313. 	wpsc_register_post_types();
    314. 

  314. 	$category_list = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0' );
    315. 

  315. 	if ( count( $category_list ) == 0 ) {
    316. 

  316. 		require_once( WPSC_FILE_PATH . '/wpsc-includes/meta.functions.php' );
    317. 

  317. 		
    318. 

  318. 		$new_category = wp_insert_term( __( 'Product Category', 'wpsc' ), 'wpsc_product_category', "parent=0" );
    319. 

  319. 		$category_id = $new_category['term_id'];
    320. 

  320. 		$term = get_term_by( 'id', $new_category['term_id'], 'wpsc_product_category' );
    321. 

  321. 		$url_name = $term->slug;
    322. 

  322. 

  323. 		$wp_rewrite->flush_rules();
    324. 

  324. 		wpsc_update_categorymeta( $category_id, 'nice-name', $url_name );
    325. 

  325. 		wpsc_update_categorymeta( $category_id, 'description', __( "This is a description", 'wpsc' ) );
    326. 

  326. 		wpsc_update_categorymeta( $category_id, 'image', '' );
    327. 

  327. 		wpsc_update_categorymeta( $category_id, 'fee', '0' );
    328. 

  328. 		wpsc_update_categorymeta( $category_id, 'active', '1' );
    329. 

  329. 		wpsc_update_categorymeta( $category_id, 'order', '0' );
    330. 

  330. 	}
    331. 

  331. }
    332. 

  332. 

  333. /*
    334. 

    335. 

  335. Code borrowed with much gratitude from Viper007Bond.  Thanks for writing a great plugin, Alex!
    336. 

  336. We've basically just removed the admin interface, we're just going to be hooking into the regeneration functions when new custom sizes are made or when the plugin is updated.  Fancy!
    337. 

    338. 

  338. **************************************************************************
    339. 

    340. 

  340. Plugin Name:  Regenerate Thumbnails
    341. 

  341. Plugin URI:   http://www.viper007bond.com/wordpress-plugins/regenerate-thumbnails/
    342. 

  342. Description:  Allows you to regenerate all thumbnails after changing the thumbnail sizes.
    343. 

  343. Version:      2.0.3
    344. 

  344. Author:       Viper007Bond
    345. 

  345. Author URI:   http://www.viper007bond.com/
    346. 

    347. 

  347. **************************************************************************
    348. 

    349. 

  349. Copyright (C) 2008 Viper007Bond
    350. 

    351. 

  351. *************************************************************************
    352. 

  352. */
    353. 

  353. 

  354. function wpsc_regenerate_thumbnails() {
    355. 

  355. global $wpdb;
    356. 

  356. 

  357. if( !ini_get('safe_mode') ) set_time_limit(250);
    358. 

  358. 

  359. if ( !function_exists( 'wp_generate_attachment_metadata' ) ) {
    360. 

  360. 	require_once ( ABSPATH . 'wp-admin/includes/image.php' );
    361. 

  361. }
    362. 

  362. 

  363. 		// Just query for the IDs (specifically those that have products for parents) only to reduce memory usage
    364. 

  364. 		$images = $wpdb->get_results( "SELECT ID, post_parent FROM $wpdb->posts WHERE post_type = 'attachment' AND post_mime_type LIKE 'image/%'" );
    365. 

  365. 		
    366. 

  366. 		foreach ( $images as $image ) {
    367. 

  367. 			$id = $image->ID;
    368. 

  368. 			$post_parent_type = get_post_type( $image->post_parent );
    369. 

  369. 			
    370. 

  370. 			if ("wpsc-product" == $post_parent_type) {
    371. 

  371. 				
    372. 

  372. 				$fullsizepath = get_attached_file( $id );
    373. 

  373. 				
    374. 

  374. 				if ( false === $fullsizepath || !file_exists($fullsizepath) )
    375. 

  375. 					die ("Could not find path specified!");
    376. 

  376. 	
    377. 

  377. 				if ( wp_update_attachment_metadata( $id, wp_generate_attachment_metadata( $id, $fullsizepath ) ) ) {
    378. 

  378. 					$success = true;
    379. 

  379. 					} else {
    380. 

  380. 					$success = false;
    381. 

  381. 				}
    382. 

  382. 			}
    383. 

  383. 	}	
    384. 

  384. }
    385. 

  385. 

  386. function wpsc_product_files_htaccess() {
    387. 

  387. 	if ( !is_file( WPSC_FILE_DIR . ".htaccess" ) ) {
    388. 

  388. 		$htaccess = "order deny,allow\n\r";
    389. 

  389. 		$htaccess .= "deny from all\n\r";
    390. 

  390. 		$htaccess .= "allow from none\n\r";
    391. 

  391. 		$filename = WPSC_FILE_DIR . ".htaccess";
    392. 

  392. 		$file_handle = @ fopen( $filename, 'w+' );
    393. 

  393. 		@ fwrite( $file_handle, $htaccess );
    394. 

  394. 		@ fclose( $file_handle );
    395. 

  395. 		@ chmod( $file_handle, 0665 );
    396. 

  396. 	}
    397. 

  397. }
    398. 

  398. 

  399. function wpsc_check_and_copy_files() {
    400. 

  400. 	$upload_path = 'wp-content/plugins/' . WPSC_DIR_NAME;
    401. 

  401. 

  402. 	$wpsc_dirs['files']['old'] = ABSPATH . "{$upload_path}/files/";
    403. 

  403. 	$wpsc_dirs['files']['new'] = WPSC_FILE_DIR;
    404. 

  404. 

  405. 	$wpsc_dirs['previews']['old'] = ABSPATH . "{$upload_path}/preview_clips/";
    406. 

  406. 	$wpsc_dirs['previews']['new'] = WPSC_PREVIEW_DIR;
    407. 

  407. 

  408. 	// I don't include the thumbnails directory in this list, as it is a subdirectory of the images directory and is moved along with everything else
    409. 

  409. 	$wpsc_dirs['images']['old'] = ABSPATH . "{$upload_path}/product_images/";
    410. 

  410. 	$wpsc_dirs['images']['new'] = WPSC_IMAGE_DIR;
    411. 

  411. 

  412. 	$wpsc_dirs['categories']['old'] = ABSPATH . "{$upload_path}/category_images/";
    413. 

  413. 	$wpsc_dirs['categories']['new'] = WPSC_CATEGORY_DIR;
    414. 

  414. 	$incomplete_file_transfer = false;
    415. 

  415. 

  416. 	foreach ( $wpsc_dirs as $wpsc_dir ) {
    417. 

  417. 		if ( is_dir( $wpsc_dir['old'] ) ) {
    418. 

  418. 			$files_in_dir = glob( $wpsc_dir['old'] . "*" );
    419. 

  419. 			$stat = stat( $wpsc_dir['new'] );
    420. 

  420. 

  421. 			if ( count( $files_in_dir ) > 0 ) {
    422. 

  422. 				foreach ( $files_in_dir as $file_in_dir ) {
    423. 

  423. 					$file_name = str_replace( $wpsc_dir['old'], '', $file_in_dir );
    424. 

  424. 					if ( @ rename( $wpsc_dir['old'] . $file_name, $wpsc_dir['new'] . $file_name ) ) {
    425. 

  425. 						if ( is_dir( $wpsc_dir['new'] . $file_name ) ) {
    426. 

  426. 							$perms = $stat['mode'] & 0000775;
    427. 

  427. 						} else {
    428. 

  428. 							$perms = $stat['mode'] & 0000665;
    429. 

  429. 						}
    430. 

  430. 

  431. 						@ chmod( ($wpsc_dir['new'] . $file_name ), $perms );
    432. 

  432. 					} else {
    433. 

  433. 						$incomplete_file_transfer = true;
    434. 

  434. 					}
    435. 

  435. 				}
    436. 

  436. 			}
    437. 

  437. 		}
    438. 

  438. 	}
    439. 

  439. 	if ( $incomplete_file_transfer == true ) {
    440. 

  440. 		add_option( 'wpsc_incomplete_file_transfer', 'default', "", 'true' );
    441. 

  441. 	}
    442. 

  442. }
    443. 

  443. 

  444. function wpsc_create_upload_directories() {
    445. 

  445. 

  446. 	// Create the required folders
    447. 

  447. 	$folders = array(
    448. 

  448. 		WPSC_UPLOAD_DIR,
    449. 

  449. 		WPSC_FILE_DIR,
    450. 

  450. 		WPSC_PREVIEW_DIR,
    451. 

  451. 		WPSC_IMAGE_DIR,
    452. 

  452. 		WPSC_THUMBNAIL_DIR,
    453. 

  453. 		WPSC_CATEGORY_DIR,
    454. 

  454. 		WPSC_USER_UPLOADS_DIR,
    455. 

  455. 		WPSC_CACHE_DIR,
    456. 

  456. 		WPSC_UPGRADES_DIR,
    457. 

  457. 		WPSC_THEMES_PATH
    458. 

  458. 	);
    459. 

  459. 	foreach ( $folders as $folder ) {
    460. 

  460. 		wp_mkdir_p( $folder );
    461. 

  461. 		@ chmod( $folder, 0775 );
    462. 

  462. 	}
    463. 

  463. }
    464. 

  464. 

  465. function wpsc_copy_themes_to_uploads() {
    466. 

  466. 	$old_theme_path = WPSC_CORE_THEME_PATH;
    467. 

  467. 	$new_theme_path = WPSC_THEMES_PATH;
    468. 

  468. 	$new_dir = @ opendir( $new_theme_path );
    469. 

  469. 	$num = 0;
    470. 

  470. 	$file_names = array( );
    471. 

  471. 	while ( ($file = @ readdir( $new_dir )) !== false ) {
    472. 

  472. 		if ( is_dir( $new_theme_path . $file ) && ($file != "..") && ($file != ".") ) {
    473. 

  473. 			$file_names[] = $file;
    474. 

  474. 		}
    475. 

  475. 	}
    476. 

  476. 	if ( count( $file_names ) < 1 ) {
    477. 

  477. 		$old_dir = @ opendir( $old_theme_path );
    478. 

  478. 		while ( ($file = @ readdir( $old_dir )) !== false ) {
    479. 

  479. 			if ( is_dir( $old_theme_path . $file ) && ($file != "..") && ($file != ".") ) {
    480. 

  480. 				@ wpsc_recursive_copy( $old_theme_path . $file, $new_theme_path . $file );
    481. 

  481. 			}
    482. 

  482. 		}
    483. 

  483. 	}
    484. 

  484. }
    485. 

  485. 

  486. /**
    487. 

  487.  * wpsc_create_or_update_tables count function,
    488. 

  488.  * * @return boolean true on success, false on failure
    489. 

  489.  */
    490. 

  490. function wpsc_create_or_update_tables( $debug = false ) {
    491. 

  491. 	global $wpdb;
    492. 

  492. 	// creates or updates the structure of the shopping cart tables
    493. 

  493. 

  494. 	include( WPSC_FILE_PATH . '/wpsc-updates/database_template.php' );
    495. 

  495. 

  496. 	$template_hash = sha1( serialize( $wpsc_database_template ) );
    497. 

  497. 

  498. 	// Filter for adding to or altering the wpsc database template, make sure you return the array your function gets passed, else you will break updating the database tables
    499. 

  499. 	$wpsc_database_template = apply_filters( 'wpsc_alter_database_template', $wpsc_database_template );
    500. 

  500. 

  501. 	$failure_reasons = array( );
    502. 

  502. 	$upgrade_failed = false;
    503. 

  503. 	foreach ( (array)$wpsc_database_template as $table_name => $table_data ) {
    504. 

  504. 		// check that the table does not exist under the correct name, then checkk if there was a previous name, if there was, check for the table under that name too.
    505. 

  505. 		if ( !$wpdb->get_var( "SHOW TABLES LIKE '$table_name'" ) && (!isset( $table_data['previous_names'] ) || (isset( $table_data['previous_names'] ) && !$wpdb->get_var( "SHOW TABLES LIKE '{$table_data['previous_names']}'" )) ) ) {
    506. 

  506. 			//if the table does not exixt, create the table
    507. 

  507. 			$constructed_sql_parts = array( );
    508. 

  508. 			$constructed_sql = "CREATE TABLE `{$table_name}` (\n";
    509. 

  509. 

  510. 			// loop through the columns
    511. 

  511. 			foreach ( (array)$table_data['columns'] as $column => $properties ) {
    512. 

  512. 				$constructed_sql_parts[] = "`$column` $properties";
    513. 

  513. 			}
    514. 

  514. 			// then through the indexes
    515. 

  515. 			foreach ( (array)$table_data['indexes'] as $properties ) {
    516. 

  516. 				$constructed_sql_parts[] = "$properties";
    517. 

  517. 			}
    518. 

  518. 			$constructed_sql .= implode( ",\n", $constructed_sql_parts );
    519. 

  519. 			$constructed_sql .= "\n) ENGINE=MyISAM";
    520. 

  520. 

  521. 

  522. 			// if mySQL is new enough, set the character encoding
    523. 

  523. 			if ( method_exists( $wpdb, 'db_version' ) && version_compare( $wpdb->db_version(), '4.1', '>=' ) ) {
    524. 

  524. 				$constructed_sql .= " CHARSET=utf8";
    525. 

  525. 			}
    526. 

  526. 			$constructed_sql .= ";";
    527. 

  527. 

  528. 			if ( !$wpdb->query( $constructed_sql ) ) {
    529. 

  529. 				$upgrade_failed = true;
    530. 

  530. 				$failure_reasons[] = $wpdb->last_error;
    531. 

  531. 			}
    532. 

  532. 

  533. 			if ( isset( $table_data['actions']['after']['all'] ) && is_callable( $table_data['actions']['after']['all'] ) ) {
    534. 

  534. 				$table_data['actions']['after']['all']();
    535. 

  535. 			}
    536. 

  536. 		} else {
    537. 

  537. 			// check to see if the new table name is in use
    538. 

  538. 			if ( !$wpdb->get_var( "SHOW TABLES LIKE '$table_name'" ) && (isset( $table_data['previous_names'] ) && $wpdb->get_var( "SHOW TABLES LIKE '{$table_data['previous_names']}'" )) ) {
    539. 

  539. 				$wpdb->query( "ALTER TABLE	`{$table_data['previous_names']}` RENAME TO `{$table_name}`;" );
    540. 

  540. 				$failure_reasons[] = $wpdb->last_error;
    541. 

  541. 			}
    542. 

  542. 

  543. 			//check to see if the table needs updating
    544. 

  544. 			$existing_table_columns = array( );
    545. 

  545. 			//check and possibly update the character encoding
    546. 

  546. 			if ( method_exists( $wpdb, 'db_version' ) && version_compare( $wpdb->db_version(), '4.1', '>=' ) ) {
    547. 

  547. 				$table_status_data = $wpdb->get_row( "SHOW TABLE STATUS LIKE '$table_name'", ARRAY_A );
    548. 

  548. 				if ( $table_status_data['Collation'] != 'utf8_general_ci' ) {
    549. 

  549. 					$wpdb->query( "ALTER TABLE `$table_name`	DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci" );
    550. 

  550. 				}
    551. 

  551. 			}
    552. 

  552. 			
    553. 

  553. 			if ( isset( $table_data['actions']['before']['all'] ) && is_callable( $table_data['actions']['before']['all'] ) ) {
    554. 

  554. 				$table_data['actions']['before']['all']();
    555. 

  555. 			}
    556. 

  556. 			
    557. 

  557. 			//get the column list
    558. 

  558. 			$existing_table_column_data = $wpdb->get_results( "SHOW FULL COLUMNS FROM `$table_name`", ARRAY_A );
    559. 

  559. 

  560. 			foreach ( (array)$existing_table_column_data as $existing_table_column ) {
    561. 

  561. 				$column_name = $existing_table_column['Field'];
    562. 

  562. 				$existing_table_columns[] = $column_name;
    563. 

  563. 

  564. 				$null_match = false;
    565. 

  565. 				if ( $existing_table_column['Null'] = 'NO' ) {
    566. 

  566. 					if ( stristr( $table_data['columns'][$column_name], "NOT NULL" ) !== false ) {
    567. 

  567. 						$null_match = true;
    568. 

  568. 					}
    569. 

  569. 				} else {
    570. 

  570. 					if ( stristr( $table_data['columns'][$column_name], "NOT NULL" ) === false ) {
    571. 

  571. 						$null_match = true;
    572. 

  572. 					}
    573. 

  573. 				}
    574. 

  574. 

  575. 				if ( isset( $table_data['columns'][$column_name] ) && ((stristr( $table_data['columns'][$column_name], $existing_table_column['Type'] ) === false) || ($null_match != true)) ) {
    576. 

  576. 					if ( isset( $table_data['actions']['before'][$column_name] ) && is_callable( $table_data['actions']['before'][$column_name] ) ) {
    577. 

  577. 						$table_data['actions']['before'][$column_name]( $column_name );
    578. 

  578. 					}
    579. 

  579. 					if ( !$wpdb->query( "ALTER TABLE `$table_name` CHANGE `$column_name` `$column_name` {$table_data['columns'][$column_name]} " ) ) {
    580. 

  580. 						$upgrade_failed = true;
    581. 

  581. 						$failure_reasons[] = $wpdb->last_error;
    582. 

  582. 					}
    583. 

  583. 				}
    584. 

  584. 			}
    585. 

  585. 			$supplied_table_columns = array_keys( $table_data['columns'] );
    586. 

  586. 

  587. 			// compare the supplied and existing columns to find the differences
    588. 

  588. 			$missing_or_extra_table_columns = array_diff( $supplied_table_columns, $existing_table_columns );
    589. 

  589. 

  590. 			if ( count( $missing_or_extra_table_columns ) > 0 ) {
    591. 

  591. 				foreach ( (array)$missing_or_extra_table_columns as $missing_or_extra_table_column ) {
    592. 

  592. 					if ( isset( $table_data['columns'][$missing_or_extra_table_column] ) ) {
    593. 

  593. 						//table column is missing, add it
    594. 

  594. 						$previous_column = $supplied_table_columns[array_search( $missing_or_extra_table_column, $supplied_table_columns ) - 1];
    595. 

  595. 						if ( $previous_column != '' ) {
    596. 

  596. 							$previous_column = "AFTER `$previous_column`";
    597. 

  597. 						}
    598. 

  598. 						$constructed_sql = "ALTER TABLE `$table_name` ADD `$missing_or_extra_table_column` " . $table_data['columns'][$missing_or_extra_table_column] . " $previous_column;";
    599. 

  599. 						if ( !$wpdb->query( $constructed_sql ) ) {
    600. 

  600. 							$upgrade_failed = true;
    601. 

  601. 							$failure_reasons[] = $wpdb->last_error;
    602. 

  602. 						}
    603. 

  603. 						// run updating functions to do more complex work with default values and the like
    604. 

  604. 						if ( is_callable( $table_data['actions']['after'][$missing_or_extra_table_column] ) ) {
    605. 

  605. 							$table_data['actions']['after'][$missing_or_extra_table_column]( $missing_or_extra_table_column );
    606. 

  606. 						}
    607. 

  607. 					}
    608. 

  608. 				}
    609. 

  609. 			}
    610. 

  610. 

  611. 			if ( isset( $table_data['actions']['after']['all'] ) && is_callable( $table_data['actions']['after']['all'] ) ) {
    612. 

  612. 				$table_data['actions']['after']['all']();
    613. 

  613. 			}
    614. 

  614. 			// get the list of existing indexes
    615. 

  615. 			$existing_table_index_data = $wpdb->get_results( "SHOW INDEX FROM `$table_name`", ARRAY_A );
    616. 

  616. 			$existing_table_indexes = array( );
    617. 

  617. 			foreach ( $existing_table_index_data as $existing_table_index ) {
    618. 

  618. 				$existing_table_indexes[] = $existing_table_index['Key_name'];
    619. 

  619. 			}
    620. 

  620. 

  621. 			$existing_table_indexes = array_unique( $existing_table_indexes );
    622. 

  622. 			$supplied_table_indexes = array_keys( $table_data['indexes'] );
    623. 

  623. 

  624. 			// compare the supplied and existing indxes to find the differences
    625. 

  625. 			$missing_or_extra_table_indexes = array_diff( $supplied_table_indexes, $existing_table_indexes );
    626. 

  626. 

  627. 			if ( count( $missing_or_extra_table_indexes ) > 0 ) {
    628. 

  628. 				foreach ( $missing_or_extra_table_indexes as $missing_or_extra_table_index ) {
    629. 

  629. 					if ( isset( $table_data['indexes'][$missing_or_extra_table_index] ) ) {
    630. 

  630. 						$constructed_sql = "ALTER TABLE `$table_name` ADD " . $table_data['indexes'][$missing_or_extra_table_index] . ";";
    631. 

  631. 						if ( !$wpdb->query( $constructed_sql ) ) {
    632. 

  632. 							$upgrade_failed = true;
    633. 

  633. 							$failure_reasons[] = $wpdb->last_error;
    634. 

  634. 						}
    635. 

  635. 					}
    636. 

  636. 				}
    637. 

  637. 			}
    638. 

  638. 		}
    639. 

  639. 	}
    640. 

  640. 

  641. 	if ( $upgrade_failed !== true ) {
    642. 

  642. 		update_option( 'wpsc_database_check', $template_hash );
    643. 

  643. 		return true;
    644. 

  644. 	} else {
    645. 

  645. 		return false;
    646. 

  646. 	}
    647. 

  647. }
    648. 

  648. 

  649. /**
    650. 

  650.  * The following functions are used exclusively in database_template.php
    651. 

  651.  */
    652. 

  652. 

  653. /**
    654. 

  654.  * wpsc_add_currency_list function,	converts values to decimal to satisfy mySQL strict mode
    655. 

  655.  * * @return boolean true on success, false on failure
    656. 

  656.  */
    657. 

  657. function wpsc_add_currency_list() {
    658. 

  658. 	global $wpdb;
    659. 

  659. 	require_once(WPSC_FILE_PATH . "/wpsc-updates/currency_list.php");
    660. 

  660. 	$currency_data = $wpdb->get_var( "SELECT COUNT(*) AS `count` FROM `" . WPSC_TABLE_CURRENCY_LIST . "`" );
    661. 

  661. 	if ( $currency_data == 0 ) {
    662. 

  662. 		$currency_array = explode( "\n", $currency_sql );
    663. 

  663. 		foreach ( $currency_array as $currency_row ) {
    664. 

  664. 			$wpdb->query( $currency_row );
    665. 

  665. 		}
    666. 

  666. 	}
    667. 

  667. }
    668. 

  668. 

  669. /**
    670. 

  670.  * wpsc_add_region_list function,	converts values to decimal to satisfy mySQL strict mode
    671. 

  671.  * * @return boolean true on success, false on failure
    672. 

  672.  */
    673. 

  673. function wpsc_add_region_list() {
    674. 

  674. 	global $wpdb;
    675. 

  675. 	$add_regions = $wpdb->get_var( "SELECT COUNT(*) AS `count` FROM `" . WPSC_TABLE_REGION_TAX . "`" );
    676. 

  676. 	if ( $add_regions < 1 ) {
    677. 

  677. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Alberta', '', '0')" );
    678. 

  678. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'British Columbia', '', '0')" );
    679. 

  679. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Manitoba', '', '0')" );
    680. 

  680. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'New Brunswick', '', '0')" );
    681. 

  681. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Newfoundland', '', '0')" );
    682. 

  682. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Northwest Territories', '', '0')" );
    683. 

  683. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Nova Scotia', '', '0')" );
    684. 

  684. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Nunavut', '', '0')" );
    685. 

  685. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Ontario', '', '0')" );
    686. 

  686. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Prince Edward Island', '', '0')" );
    687. 

  687. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Quebec', '', '0')" );
    688. 

  688. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Saskatchewan', '', '0')" );
    689. 

  689. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Yukon', '', '0')" );
    690. 

  690. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Alabama', 'AL', '0')" );
    691. 

  691. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Alaska', 'AK', '0')" );
    692. 

  692. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Arizona', 'AZ', '0')" );
    693. 

  693. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Arkansas', 'AR', '0')" );
    694. 

  694. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'California', 'CA', '0')" );
    695. 

  695. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Colorado', 'CO', '0')" );
    696. 

  696. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Connecticut', 'CT', '0')" );
    697. 

  697. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Delaware', 'DE', '0')" );
    698. 

  698. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Florida', 'FL', '0')" );
    699. 

  699. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Georgia', 'GA', '0')" );
    700. 

  700. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Hawaii', 'HI', '0')" );
    701. 

  701. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Idaho', 'ID', '0')" );
    702. 

  702. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Illinois', 'IL', '0')" );
    703. 

  703. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Indiana', 'IN', '0')" );
    704. 

  704. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Iowa', 'IA', '0')" );
    705. 

  705. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Kansas', 'KS', '0')" );
    706. 

  706. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Kentucky', 'KY', '0')" );
    707. 

  707. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Louisiana', 'LA', '0')" );
    708. 

  708. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Maine', 'ME', '0')" );
    709. 

  709. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Maryland', 'MD', '0')" );
    710. 

  710. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Massachusetts', 'MA', '0')" );
    711. 

  711. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Michigan', 'MI', '0')" );
    712. 

  712. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Minnesota', 'MN', '0')" );
    713. 

  713. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Mississippi', 'MS', '0')" );
    714. 

  714. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Missouri', 'MO', '0')" );
    715. 

  715. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Montana', 'MT', '0')" );
    716. 

  716. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Nebraska', 'NE', '0')" );
    717. 

  717. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Nevada', 'NV', '0')" );
    718. 

  718. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'New Hampshire', 'NH', '0')" );
    719. 

  719. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'New Jersey', 'NJ', '0')" );
    720. 

  720. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'New Mexico', 'NM', '0')" );
    721. 

  721. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'New York', 'NY', '0')" );
    722. 

  722. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'North Carolina', 'NC', '0')" );
    723. 

  723. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'North Dakota', 'ND', '0')" );
    724. 

  724. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Ohio', 'OH', '0')" );
    725. 

  725. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Oklahoma', 'OK', '0')" );
    726. 

  726. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Oregon', 'OR', '0')" );
    727. 

  727. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Pennsylvania', 'PA', '0')" );
    728. 

  728. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Rhode Island', 'RI', '0')" );
    729. 

  729. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'South Carolina', 'SC', '0')" );
    730. 

  730. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'South Dakota', 'SD', '0')" );
    731. 

  731. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Tennessee', 'TN', '0')" );
    732. 

  732. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Texas', 'TX', '0')" );
    733. 

  733. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Utah', 'UT', '0')" );
    734. 

  734. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Vermont', 'VT', '0')" );
    735. 

  735. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Virginia', 'VA', '0')" );
    736. 

  736. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Washington', 'WA', '0')" );
    737. 

  737. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Washington DC', 'DC', '0')" );
    738. 

  738. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'West Virginia', 'WV', '0')" );
    739. 

  739. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Wisconsin', 'WI', '0')" );
    740. 

  740. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_REGION_TAX . "` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Wyoming', 'WY', '0')" );
    741. 

  741. 	}
    742. 

  742. 

  743. 	if ( $wpdb->get_var( "SELECT COUNT(*) FROM `" . WPSC_TABLE_REGION_TAX . "` WHERE `code`=''" ) > 0 ) {
    744. 

  744. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'AB' WHERE `name` IN('Alberta') LIMIT 1 ;" );
    745. 

  745. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'BC' WHERE `name` IN('British Columbia') LIMIT 1 ;" );
    746. 

  746. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'MB' WHERE `name` IN('Manitoba') LIMIT 1 ;" );
    747. 

  747. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'NK' WHERE `name` IN('New Brunswick') LIMIT 1 ;" );
    748. 

  748. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'NF' WHERE `name` IN('Newfoundland') LIMIT 1 ;" );
    749. 

  749. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'NT' WHERE `name` IN('Northwest Territories') LIMIT 1 ;" );
    750. 

  750. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'NS' WHERE `name` IN('Nova Scotia') LIMIT 1 ;" );
    751. 

  751. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'ON' WHERE `name` IN('Ontario') LIMIT 1 ;" );
    752. 

  752. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'PE' WHERE `name` IN('Prince Edward Island') LIMIT 1 ;" );
    753. 

  753. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'PQ' WHERE `name` IN('Quebec') LIMIT 1 ;" );
    754. 

  754. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'SN' WHERE `name` IN('Saskatchewan') LIMIT 1 ;" );
    755. 

  755. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'YT' WHERE `name` IN('Yukon') LIMIT 1 ;" );
    756. 

  756. 		$wpdb->query( "UPDATE `" . WPSC_TABLE_REGION_TAX . "` SET `code` = 'NU' WHERE `name` IN('Nunavut') LIMIT 1 ;" );
    757. 

  757. 	}
    758. 

  758. }
    759. 

  759. 

  760. /**
    761. 

  761.  * wpsc_add_checkout_fields function,	converts values to decimal to satisfy mySQL strict mode
    762. 

  762.  * * @return boolean true on success, false on failure
    763. 

  763.  */
    764. 

  764. function wpsc_add_checkout_fields() {
    765. 

  765. 	global $wpdb;
    766. 

  766. 	$data_forms = $wpdb->get_results( "SELECT COUNT(*) AS `count` FROM `" . WPSC_TABLE_CHECKOUT_FORMS . "`", ARRAY_A );
    767. 

  767. 

  768. 	if ( $data_forms[0]['count'] == 0 ) {
    769. 

  769. 

  770. 		$sql = " INSERT INTO `" . WPSC_TABLE_CHECKOUT_FORMS . "` ( `name`, `type`, `mandatory`, `display_log`, `default`, `active`, `checkout_order`, `unique_name`) VALUES ( '" . __( 'Your billing/contact details', 'wpsc' ) . "', 'heading', '0', '0', '', '1', 1,''),
    771. 

  771. 	( '" . __( 'First Name', 'wpsc' ) . "', 'text', '1', '1', '', '1', 2,'billingfirstname'),
    772. 

  772. 	( '" . __( 'Last Name', 'wpsc' ) . "', 'text', '1', '1', '', '1', 3,'billinglastname'),
    773. 

  773. 	( '" . __( 'Address', 'wpsc' ) . "', 'address', '1', '0', '', '1', 4,'billingaddress'),
    774. 

  774. 	( '" . __( 'City', 'wpsc' ) . "', 'city', '1', '0', '', '1', 5,'billingcity'),
    775. 

  775. 	( '" . __( 'State', 'wpsc' ) . "', 'text', '0', '0', '', '1', 6,'billingstate'),
    776. 

  776. 	( '" . __( 'Country', 'wpsc' ) . "', 'country', '1', '0', '', '1', 7,'billingcountry'),
    777. 

  777. 	( '" . __( 'Postal Code', 'wpsc' ) . "', 'text', '0', '0', '', '1', 8,'billingpostcode'),
    778. 

  778. 	( '" . __( 'Email', 'wpsc' ) . "', 'email', '1', '1', '', '1', 9,'billingemail'),
    779. 

  779. 	( '" . __( 'Shipping Address', 'wpsc' ) . "', 'heading', '0', '0', '', '1', 10,'delivertoafriend'),
    780. 

  780. 	( '" . __( 'First Name', 'wpsc' ) . "', 'text', '0', '0', '', '1', 11,'shippingfirstname'),
    781. 

  781. 	( '" . __( 'Last Name', 'wpsc' ) . "', 'text', '0', '0', '', '1', 12,'shippinglastname'),
    782. 

  782. 	( '" . __( 'Address', 'wpsc' ) . "', 'address', '0', '0', '', '1', 13,'shippingaddress'),
    783. 

  783. 	( '" . __( 'City', 'wpsc' ) . "', 'city', '0', '0', '', '1', 14,'shippingcity'),
    784. 

  784. 	( '" . __( 'State', 'wpsc' ) . "', 'text', '0', '0', '', '1', 15,'shippingstate'),
    785. 

  785. 	( '" . __( 'Country', 'wpsc' ) . "', 'delivery_country', '0', '0', '', '1', 16,'shippingcountry'),
    786. 

  786. 	( '" . __( 'Postal Code', 'wpsc' ) . "', 'text', '0', '0', '', '1', 17,'shippingpostcode');";
    787. 

    788. 

  788. 		$wpdb->query( $sql );
    789. 

  789. 		$wpdb->query( "INSERT INTO `" . WPSC_TABLE_CHECKOUT_FORMS . "` ( `name`, `type`, `mandatory`, `display_log`, `default`, `active`, `checkout_order`, `unique_name` ) VALUES ( '" . __( 'Phone', 'wpsc' ) . "', 'text', '1', '0', '', '1', '8','billingphone');" );
    790. 

  790. 	}
    791. 

  791. }
    792. 

  792. function wpsc_rename_checkout_column(){
    793. 

  793. 	global $wpdb;
    794. 

  794. 	$sql = "SHOW COLUMNS FROM `" . WPSC_TABLE_CHECKOUT_FORMS . "` LIKE 'checkout_order'";
    795. 

  795. 	$col = $wpdb->get_results($sql);
    796. 

  796. 	if(empty($col)){
    797. 

  797. 		$sql = "ALTER TABLE  `" . WPSC_TABLE_CHECKOUT_FORMS . "` CHANGE  `order`  `checkout_order` INT( 10 ) UNSIGNED NOT NULL DEFAULT  '0'";
    798. 

  798. 		$wpdb->query($sql);
    799. 

  799. 	}
    800. 

  800. 

  801. }
    802. 

  802. ?>
    803. 

  803.