WP eCommerce - Version 3.7.6.4

Version Description

  • Show Product Shipping and Base Shipping Costs on Packing Slip
  • Fix product and category permalinks problems that occurred in v3.7.6.3. Note: any 3.7.6.3 users that have edited products and/or categories, they will need to re-edit them after upgrading.
  • Fixed an issue with the currency converter
  • Renamed (removed the space in the filename) and updated the POT file for translators (wpsc-en_EN.pot)
  • Removed unused install_and_update file from plugin folder
  • Fixed some PHP warnings / notices
Download this release

Release Info

Developer jghazally
Plugin Icon 128x128 WP eCommerce
Version 3.7.6.4
Comparing to
See all releases

Code changes from version 3.7.6.3 to 3.7.6.4

Files changed (13) hide show
  1. admin-form-functions.php +7 -3
  2. currency_converter.inc.php +1 -1
  3. install_and_update.php +0 -844
  4. languages/{wpsc-en_EN .pot → wpsc-en_EN.pot} +284 -322
  5. readme.txt +15 -2
  6. wp-shopping-cart.php +7 -7
  7. wpsc-admin/ajax-and-init.php +1 -2
  8. wpsc-admin/display-groups.page.php +2 -3
  9. wpsc-admin/includes/product-functions.php +2 -3
  10. wpsc-includes/ajax.functions.php +16 -5
  11. wpsc-includes/category.functions.php +1 -2
  12. wpsc-includes/deprecated.functions.php +4 -0
  13. wpsc-includes/theme.functions.php +2 -2
admin-form-functions.php CHANGED
@@ -966,10 +966,14 @@ function wpsc_packing_slip($purchase_id) {
966
  }
967
  echo '<td>';
968
  echo '</tr>';
969
- }
970
- echo '<tr><td>Total Shipping</td><td>'.$purch_data['base_shipping'].'</td></tr>';
971
- echo '<tr><td>Total Price</td><td>'.$purch_data['totalprice'].'</td></tr>';
972
  echo "</table>";
 
 
 
 
 
 
973
 
974
  echo "</div>\n\r";
975
  } else {
966
  }
967
  echo '<td>';
968
  echo '</tr>';
969
+ }
 
 
970
  echo "</table>";
971
+
972
+ echo '<table class="packing-slip-totals">';
973
+ echo '<tr><th>Base Shipping</th><td>' . nzshpcrt_currency_display( $purch_data['base_shipping'], 1 ) . '</td></tr>';
974
+ echo '<tr><th>Total Shipping</th><td>' . nzshpcrt_currency_display( $purch_data['base_shipping'] + $total_shipping, 1 ) . '</td></tr>';
975
+ echo '<tr><th>Total Price</th><td>' . nzshpcrt_currency_display( $purch_data['totalprice'], 1 ) . '</td></tr>';
976
+ echo '</table>';
977
 
978
  echo "</div>\n\r";
979
  } else {
currency_converter.inc.php CHANGED
@@ -96,7 +96,7 @@
96
 
97
  $data = @preg_replace($search, $replace, $data);
98
  @preg_match_all("/(\d[^\.]*(\.\d+)?)/",$data,$mathces);
99
- $return=preg_replace("/[^\d\.]*/","",$mathces[0][1]);
100
  return (double)$return;
101
  }
102
  }
96
 
97
  $data = @preg_replace($search, $replace, $data);
98
  @preg_match_all("/(\d[^\.]*(\.\d+)?)/",$data,$mathces);
99
+ $return=preg_replace("/[^\d\.]*/","",$mathces[0][4]);
100
  return (double)$return;
101
  }
102
  }
install_and_update.php DELETED
@@ -1,844 +0,0 @@
1
- <?php
2
- function wpsc_auto_update() {
3
- global $wpdb;
4
- wpsc_create_or_update_tables();
5
- include_once('updates/updating_tasks.php');
6
- wpsc_create_upload_directories();
7
- wpsc_product_files_htaccess();
8
- wpsc_check_and_copy_files();
9
-
10
- if((get_option('wpsc_version') < WPSC_VERSION) || (get_option('wpsc_version') == WPSC_VERSION) && (get_option('wpsc_minor_version') < WPSC_MINOR_VERSION)) {
11
- update_option('wpsc_version', WPSC_VERSION);
12
- update_option('wpsc_minor_version', WPSC_MINOR_VERSION);
13
- }
14
- }
15
-
16
- function wpsc_install() {
17
- global $wpdb, $user_level, $wp_rewrite, $wp_version;
18
- $table_name = $wpdb->prefix . "wpsc_product_list";
19
-
20
- $first_install = false;
21
- $result = mysql_list_tables(DB_NAME);
22
- $tables = array();
23
- while($row = mysql_fetch_row($result)) {
24
- $tables[] = $row[0];
25
- }
26
- if(!in_array($table_name, $tables)) {
27
- $first_install = true;
28
- add_option('wpsc_purchaselogs_fixed',true);
29
- }
30
-
31
- if(get_option('wpsc_version') == null) {
32
- add_option('wpsc_version', WPSC_VERSION, 'wpsc_version', 'yes');
33
- }
34
-
35
- // run the create or update code here.
36
- wpsc_create_or_update_tables();
37
- wpsc_create_upload_directories();
38
-
39
- if(!wp_get_schedule("wpsc_hourly_cron_tasks")) {
40
- wp_schedule_event(time(), 'hourly', 'wpsc_hourly_cron_tasks');
41
- }
42
-
43
- if(!wp_get_schedule("wpsc_daily_cron_tasks")) {
44
- wp_schedule_event(time(), 'daily', 'wpsc_daily_cron_tasks');
45
- }
46
- //wp_get_schedule( $hook, $args )
47
-
48
-
49
- /* all code to add new database tables and columns must be above here */
50
- if((get_option('wpsc_version') < WPSC_VERSION) || (get_option('wpsc_version') == WPSC_VERSION) && (get_option('wpsc_minor_version') < WPSC_MINOR_VERSION)) {
51
- update_option('wpsc_version', WPSC_VERSION);
52
- update_option('wpsc_minor_version', WPSC_MINOR_VERSION);
53
- }
54
-
55
-
56
- $add_initial_category = $wpdb->get_results("SELECT COUNT(*) AS `count` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."`;",ARRAY_A);
57
- if($add_initial_category[0]['count'] == 0) {
58
- $wpdb->query("INSERT INTO `".WPSC_TABLE_CATEGORISATION_GROUPS."` (`id`, `name`, `description`, `active`, `default`) VALUES (1, 'Categories', 'Product Categories', '1', '1')");
59
- $wpdb->query("INSERT INTO `".WPSC_TABLE_CATEGORISATION_GROUPS."` (`id`, `name`, `description`, `active`, `default`) VALUES (2, 'Brands', 'Product Brands', '1', '0')");
60
- $wpdb->query("INSERT INTO `".WPSC_TABLE_PRODUCT_CATEGORIES."` (`group_id`, `name` , `description`, `active`) VALUES ('1', '".__('Example category', 'wpsc')."', '".__('Example details', 'wpsc')."', '1');");
61
- $wpdb->query("INSERT INTO `".WPSC_TABLE_PRODUCT_CATEGORIES."` (`group_id`, `name` , `description`, `active`) VALUES ('2', '".__('Example Brand', 'wpsc')."', '".__('Example details', 'wpsc')."', '1');");
62
- }
63
-
64
- $purchase_statuses_data = $wpdb->get_results("SELECT COUNT(*) AS `count` FROM `".WPSC_TABLE_PURCHASE_STATUSES."`",ARRAY_A);
65
- if($purchase_statuses_data[0]['count'] == 0) {
66
- $wpdb->query("INSERT INTO `".WPSC_TABLE_PURCHASE_STATUSES."` (`name` , `active` , `colour` )
67
- VALUES
68
- ('".__('Order Received', 'wpsc')."', '1', ''),
69
- ('".__('Accepted Payment', 'wpsc')."', '1', ''),
70
- ('".__('Job Dispatched', 'wpsc')."', '1', ''),
71
- ('".__('Closed Order', 'wpsc')."', '1', '');");
72
- }
73
-
74
- $check_category_assoc = $wpdb->get_results("SELECT COUNT(*) AS `count` FROM `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."`;",ARRAY_A);
75
- if($check_category_assoc[0]['count'] == 0) {
76
- $sql = "SELECT * FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `active`=1";
77
- $product_list = $wpdb->get_results($sql,ARRAY_A);
78
- foreach((array)$product_list as $product) {
79
- $results = $wpdb->query("INSERT INTO `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` (`product_id` , `category_id` ) VALUES ('".$product['id']."', '".$product['category']."');");
80
- }
81
- }
82
-
83
-
84
-
85
-
86
-
87
- add_option('show_thumbnails', 1, __('Show Thumbnails', 'wpsc'), "yes");
88
-
89
- add_option('product_image_width', '', __('product image width', 'wpsc'), 'yes');
90
- add_option('product_image_height', '', __('product image height', 'wpsc'), 'yes');
91
-
92
- add_option('category_image_width', '', __('product group image width', 'wpsc'), 'yes');
93
- add_option('category_image_height', '', __('product group image height', 'wpsc'), 'yes');
94
-
95
- add_option('product_list_url', '', __('The location of the product list', 'wpsc'), 'yes');
96
- add_option('shopping_cart_url', '', __('The location of the shopping cart', 'wpsc'), 'yes');
97
- add_option('checkout_url', '', __('The location of the checkout page', 'wpsc'), 'yes');
98
- add_option('transact_url', '', __('The location of the transaction detail page', 'wpsc'), 'yes');
99
- add_option('payment_gateway', '', __('The payment gateway to use', 'wpsc'), 'yes');
100
- if(function_exists('register_sidebar') ) {
101
- add_option('cart_location', '4', __('Cart Location', 'wpsc'), 'yes');
102
- } else {
103
- add_option('cart_location', '1', __('Cart Location', 'wpsc'), 'yes');
104
- }
105
-
106
- if ( function_exists('register_sidebar') ) {
107
- add_option('cart_location', '4', __('Cart Location', 'wpsc'), 'yes');
108
- } else {
109
- add_option('cart_location', '1', __('Cart Location', 'wpsc'), 'yes');
110
- }
111
-
112
- //add_option('show_categorybrands', '0', __('Display categories or brands or both', 'wpsc'), 'yes');
113
-
114
- add_option('currency_type', '156', __('Currency type', 'wpsc'), 'yes');
115
- add_option('currency_sign_location', '3', __('Currency sign location', 'wpsc'), 'yes');
116
-
117
- add_option('gst_rate', '1', __('the GST rate', 'wpsc'), 'yes');
118
-
119
- add_option('max_downloads', '1', __('the download limit', 'wpsc'), 'yes');
120
-
121
- add_option('display_pnp', '1', __('Display or hide postage and packaging', 'wpsc'), 'yes');
122
-
123
- add_option('display_specials', '1', __('Display or hide specials on the sidebar', 'wpsc'), 'yes');
124
- add_option('do_not_use_shipping', '1', 'do_not_use_shipping', 'no');
125
-
126
- add_option('postage_and_packaging', '0', __('Default postage and packaging', 'wpsc'), 'yes');
127
-
128
- add_option('purch_log_email', '', __('Email address that purchase log is sent to', 'wpsc'), 'yes');
129
- add_option('return_email', '', __('Email address that purchase reports are sent from', 'wpsc'), 'yes');
130
- add_option('terms_and_conditions', '', __('Checkout terms and conditions', 'wpsc'), 'yes');
131
-
132
- add_option('google_key', 'none', __('Google Merchant Key', 'wpsc'), 'yes');
133
- add_option('google_id', 'none', __('Google Merchant ID', 'wpsc'), 'yes');
134
-
135
- add_option('default_brand', 'none', __('Default Brand', 'wpsc'), 'yes');
136
- add_option('wpsc_default_category', 'all', __('Select what product group you want to display on the products page', 'wpsc'), 'yes');
137
-
138
- add_option('product_view', 'default', "", 'yes');
139
- add_option('add_plustax', 'default', "", '1');
140
-
141
-
142
- add_option('nzshpcrt_first_load', '0', "", 'yes');
143
-
144
- if(!((get_option('show_categorybrands') > 0) && (get_option('show_categorybrands') < 3))) {
145
- update_option('show_categorybrands', 2);
146
- }
147
- //add_option('show_categorybrands', '0', __('Display categories or brands or both', 'wpsc'), 'yes');
148
- /* PayPal options */
149
- add_option('paypal_business', '', __('paypal business', 'wpsc'), 'yes');
150
- add_option('paypal_url', '', __('paypal url', 'wpsc'), 'yes');
151
- add_option('paypal_ipn', '1', __('paypal url', 'wpsc'), 'yes');
152
- //update_option('paypal_url', "https://www.sandbox.paypal.com/xclick");
153
-
154
-
155
- add_option('paypal_multiple_business', '', __('paypal business', 'wpsc'), 'yes');
156
-
157
- if(get_option('paypal_multiple_url') == null) {
158
- add_option('paypal_multiple_url', __('paypal url', 'wpsc'), 'yes');
159
- update_option('paypal_multiple_url', "https://www.paypal.com/cgi-bin/webscr");
160
- }
161
-
162
- add_option('product_ratings', '0', __('Show Product Ratings', 'wpsc'), 'yes');
163
- 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');
164
- add_option('wpsc_email_admin', __('%product_list%%total_shipping%%total_price%', 'wpsc'), 'yes');
165
- if(get_option('wpsc_selected_theme') == '') {
166
- add_option('wpsc_selected_theme', 'default', 'Selected Theme', 'yes');
167
- update_option('wpsc_selected_theme', "default");
168
- }
169
-
170
- if(!get_option('product_image_height')) {
171
- update_option('product_image_height', '96');
172
- update_option('product_image_width', '96');
173
- }
174
-
175
- if(!get_option('category_image_height')) {
176
- update_option('category_image_height', '96');
177
- update_option('category_image_width', '96');
178
- }
179
-
180
- if(!get_option('single_view_image_height')) {
181
- update_option('single_view_image_height', '128');
182
- update_option('single_view_image_width', '128');
183
- }
184
-
185
- if(!get_option('wpsc_gallery_image_height')) {
186
- update_option('wpsc_gallery_image_height', '96');
187
- update_option('wpsc_gallery_image_width', '96');
188
- }
189
-
190
- if(!is_array(get_option('custom_gateway_options'))) {
191
- update_option('custom_gateway_options', array('testmode'));
192
- }
193
-
194
- add_option("wpsc_category_url_cache", array(), '', 'yes');
195
-
196
- wpsc_product_files_htaccess();
197
-
198
- /*
199
- * This part creates the pages and automatically puts their URLs into the options page.
200
- * 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.
201
- */
202
- $post_date =date("Y-m-d H:i:s");
203
- $post_date_gmt =gmdate("Y-m-d H:i:s");
204
-
205
- $num=0;
206
- $pages[$num]['name'] = 'products-page';
207
- $pages[$num]['title'] = __('Products Page', 'wpsc');
208
- $pages[$num]['tag'] = '[productspage]';
209
- $pages[$num]['option'] = 'product_list_url';
210
-
211
- $num++;
212
- $pages[$num]['name'] = 'checkout';
213
- $pages[$num]['title'] = __('Checkout', 'wpsc');
214
- $pages[$num]['tag'] = '[shoppingcart]';
215
- $pages[$num]['option'] = 'shopping_cart_url';
216
-
217
- // $num++;
218
- // $pages[$num]['name'] = 'enter-details';
219
- // $pages[$num]['title'] = __('Enter Your Details', 'wpsc');
220
- // $pages[$num]['tag'] = '[checkout]';
221
- // $pages[2$num]['option'] = 'checkout_url';
222
-
223
- $num++;
224
- $pages[$num]['name'] = 'transaction-results';
225
- $pages[$num]['title'] = __('Transaction Results', 'wpsc');
226
- $pages[$num]['tag'] = '[transactionresults]';
227
- $pages[$num]['option'] = 'transact_url';
228
-
229
- $num++;
230
- $pages[$num]['name'] = 'your-account';
231
- $pages[$num]['title'] = __('Your Account', 'wpsc');
232
- $pages[$num]['tag'] = '[userlog]';
233
- $pages[$num]['option'] = 'user_account_url';
234
-
235
- $newpages = false;
236
- $i = 0;
237
- $post_parent = 0;
238
- foreach($pages as $page) {
239
- $check_page = $wpdb->get_row("SELECT * FROM `".$wpdb->posts."` WHERE `post_content` LIKE '%".$page['tag']."%' AND `post_type` NOT IN('revision') LIMIT 1",ARRAY_A);
240
- if($check_page == null) {
241
- if($i == 0) {
242
- $post_parent = 0;
243
- } else {
244
- $post_parent = $first_id;
245
- }
246
-
247
- if($wp_version >= 2.1) {
248
- $sql ="INSERT INTO ".$wpdb->posts."
249
- (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_type)
250
- VALUES
251
- ('1', '$post_date', '$post_date_gmt', '".$page['tag']."', '', '".$page['title']."', '', 'publish', 'closed', 'closed', '', '".$page['name']."', '', '', '$post_date', '$post_date_gmt', '$post_parent', '0', 'page')";
252
- } else {
253
- $sql ="INSERT INTO ".$wpdb->posts."
254
- (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order)
255
- VALUES
256
- ('1', '$post_date', '$post_date_gmt', '".$page['tag']."', '', '".$page['title']."', '', 'static', 'closed', 'closed', '', '".$page['name']."', '', '', '$post_date', '$post_date_gmt', '$post_parent', '0')";
257
- }
258
- $wpdb->query($sql);
259
- $post_id = $wpdb->insert_id;
260
- if($i == 0) {
261
- $first_id = $post_id;
262
- }
263
- $wpdb->query("UPDATE $wpdb->posts SET guid = '" . get_permalink($post_id) . "' WHERE ID = '$post_id'");
264
- update_option($page['option'], get_permalink($post_id));
265
- if($page['option'] == 'shopping_cart_url') {
266
- update_option('checkout_url', get_permalink($post_id));
267
- }
268
- $newpages = true;
269
- $i++;
270
- }
271
- }
272
- if($newpages == true) {
273
- wp_cache_delete('all_page_ids', 'pages');
274
- $wp_rewrite->flush_rules();
275
- }
276
-
277
-
278
- /* adds nice names for permalinks for products */
279
- $check_product_names = $wpdb->get_results("SELECT `".WPSC_TABLE_PRODUCT_LIST."`.`id`, `".WPSC_TABLE_PRODUCT_LIST."`.`name`, `".WPSC_TABLE_PRODUCTMETA."`.`meta_key` FROM `".WPSC_TABLE_PRODUCT_LIST."` LEFT JOIN `".WPSC_TABLE_PRODUCTMETA."` ON `".WPSC_TABLE_PRODUCT_LIST."`.`id` = `".WPSC_TABLE_PRODUCTMETA."`.`product_id` WHERE (`".WPSC_TABLE_PRODUCTMETA."`.`meta_key` IN ('url_name') AND `".WPSC_TABLE_PRODUCTMETA."`.`meta_value` IN ('')) OR ISNULL(`".WPSC_TABLE_PRODUCTMETA."`.`meta_key`)", ARRAY_A);
280
- if($check_product_names != null) {
281
- foreach((array)$check_product_names as $datarow) {
282
- $tidied_name = trim($datarow['name']);
283
- $tidied_name = strtolower($tidied_name);
284
- $url_name = sanitize_title($tidied_name);
285
- $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);
286
- $extension_number = '';
287
- if($similar_names['count'] > 0) {
288
- $extension_number = (int)$similar_names['max_number']+1;
289
- }
290
- if(get_product_meta($datarow['id'], 'url_name') != false) {
291
- $current_url_name = get_product_meta($datarow['id'], 'url_name');
292
- if($current_url_name != $url_name) {
293
- $url_name .= $extension_number;
294
- update_product_meta($datarow['id'], 'url_name', $url_name);
295
- }
296
- } else {
297
- $url_name .= $extension_number;
298
- add_product_meta($datarow['id'], 'url_name', $url_name, true);
299
- }
300
- }
301
- }
302
-
303
-
304
- /* adds nice names for permalinks for categories */
305
- $check_category_names = $wpdb->get_results("SELECT DISTINCT `nice-name` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `nice-name` IN ('') AND `active` IN ('1')");
306
- if($check_category_names != null) {
307
- $sql_query = "SELECT `id`, `name` FROM `".WPSC_TABLE_PRODUCT_CATEGORIES."` WHERE `active` IN('1')";
308
- $sql_data = $wpdb->get_results($sql_query,ARRAY_A);
309
- foreach((array)$sql_data as $datarow) {
310
- $tidied_name = trim($datarow['name']);
311
- $tidied_name = strtolower($tidied_name);
312
- $url_name = sanitize_title($tidied_name);
313
- $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);
314
- $extension_number = '';
315
- if($similar_names['count'] > 0) {
316
- $extension_number = (int)$similar_names['max_number']+1;
317
- }
318
- $url_name .= $extension_number;
319
- $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_CATEGORIES."` SET `nice-name` = '$url_name' WHERE `id` = '".$datarow['id']."' LIMIT 1 ;");
320
- }
321
- $wp_rewrite->flush_rules();
322
- }
323
-
324
-
325
-
326
- /* Moves images to thumbnails directory */
327
- // this code should no longer be needed, as most people will be using a sufficiently new version
328
- $image_dir = WPSC_FILE_PATH."/images/";
329
- $product_images = WPSC_IMAGE_DIR;
330
- $product_thumbnails = WPSC_THUMBNAIL_DIR;
331
- if(!is_dir($product_thumbnails)) {
332
- @ mkdir($product_thumbnails, 0775);
333
- }
334
- $product_list = $wpdb->get_results("SELECT * FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `image` != ''",ARRAY_A);
335
- foreach((array)$product_list as $product) {
336
- if(!glob($product_thumbnails.$product['image'])) {
337
- $new_filename = $product['id']."_".$product['image'];
338
- if(file_exists($image_dir.$product['image'])) {
339
- copy($image_dir.$product['image'], $product_thumbnails.$new_filename);
340
- if(file_exists($product_images.$product['image'])) {
341
- copy($product_images.$product['image'], $product_images.$new_filename);
342
- }
343
- $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_LIST."` SET `image` = '".$new_filename."' WHERE `id`='".$product['id']."' LIMIT 1");
344
- } else {
345
- $imagedir = $product_thumbnails;
346
- $name = $new_filename;
347
- $new_image_path = $product_images.$product['image'];
348
- $imagepath = $product['image'];
349
- $height = get_option('product_image_height');
350
- $width = get_option('product_image_width');
351
- if(file_exists($product_images.$product['image'])) {
352
- include("extra_image_processing.php");
353
- copy($product_images.$product['image'], $product_images.$new_filename);
354
- $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_LIST."` SET `image` = '".$new_filename."' WHERE `id`='".$product['id']."' LIMIT 1");
355
- }
356
- }
357
- }
358
- } // */
359
-
360
- }
361
-
362
-
363
- function wpsc_product_files_htaccess() {
364
- if(!is_file(WPSC_FILE_DIR.".htaccess")) {
365
- $htaccess = "order deny,allow\n\r";
366
- $htaccess .= "deny from all\n\r";
367
- $htaccess .= "allow from none\n\r";
368
- $filename = WPSC_FILE_DIR.".htaccess";
369
- $file_handle = @ fopen($filename, 'w+');
370
- @ fwrite($file_handle, $htaccess);
371
- @ fclose($file_handle);
372
- @ chmod($file_handle, 0665);
373
- }
374
- }
375
-
376
-
377
-
378
- function wpsc_check_and_copy_files() {
379
- $upload_path = 'wp-content/plugins/'.WPSC_DIR_NAME;
380
-
381
- $wpsc_dirs['files']['old'] = ABSPATH."{$upload_path}/files/";
382
- $wpsc_dirs['files']['new'] = WPSC_FILE_DIR;
383
-
384
- $wpsc_dirs['previews']['old'] = ABSPATH."{$upload_path}/preview_clips/";
385
- $wpsc_dirs['previews']['new'] = WPSC_PREVIEW_DIR;
386
-
387
- // 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
388
- $wpsc_dirs['images']['old'] = ABSPATH."{$upload_path}/product_images/";
389
- $wpsc_dirs['images']['new'] = WPSC_IMAGE_DIR;
390
-
391
- $wpsc_dirs['categories']['old'] = ABSPATH."{$upload_path}/category_images/";
392
- $wpsc_dirs['categories']['new'] = WPSC_CATEGORY_DIR;
393
- $incomplete_file_transfer = false;
394
- exit('called');
395
- foreach($wpsc_dirs as $wpsc_dir) {
396
- if(is_dir($wpsc_dir['old'])) {
397
- $files_in_dir = glob($wpsc_dir['old']."*");
398
- $stat = stat($wpsc_dir['new']);
399
-
400
- if(count($files_in_dir) > 0) {
401
- foreach($files_in_dir as $file_in_dir) {
402
- $file_name = str_replace($wpsc_dir['old'], '', $file_in_dir);
403
- if( @ rename($wpsc_dir['old'].$file_name, $wpsc_dir['new'].$file_name) ) {
404
- if(is_dir($wpsc_dir['new'].$file_name)) {
405
- $perms = $stat['mode'] & 0000775;
406
- } else { $perms = $stat['mode'] & 0000665; }
407
-
408
- @ chmod( ($wpsc_dir['new'].$file_name), $perms );
409
- } else {
410
- $incomplete_file_transfer = true;
411
- }
412
- }
413
- }
414
- }
415
- }
416
- if($incomplete_file_transfer == true) {
417
- add_option('wpsc_incomplete_file_transfer', 'default', "", 'true');
418
- }
419
-
420
- }
421
-
422
-
423
- function wpsc_create_upload_directories() {
424
-
425
- // Create the required folders
426
- $folders = array(
427
- WPSC_UPLOAD_DIR,
428
- WPSC_FILE_DIR,
429
- WPSC_PREVIEW_DIR,
430
- WPSC_IMAGE_DIR,
431
- WPSC_THUMBNAIL_DIR,
432
- WPSC_CATEGORY_DIR,
433
- WPSC_USER_UPLOADS_DIR,
434
- WPSC_CACHE_DIR,
435
- WPSC_UPGRADES_DIR,
436
- WPSC_THEMES_PATH,
437
- );
438
- // exit('<pre>'.print_r($folders, true).'</pre>');
439
- foreach ($folders as $folder) {
440
- wp_mkdir_p($folder);
441
- @ chmod( $folder, 0775 );
442
- }
443
- //wpsc_copy_themes_to_uploads();
444
- }
445
-
446
-
447
- function wpsc_copy_themes_to_uploads() {
448
- $old_theme_path = WPSC_FILE_PATH . "/themes/";
449
- $new_theme_path = WPSC_THEMES_PATH;
450
- $new_dir = @ opendir($new_theme_path);
451
- $num = 0;
452
- $file_names = array();
453
- while(($file = @ readdir($new_dir)) !== false) {
454
- if(is_dir($new_theme_path.$file) && ($file != "..") && ($file != ".")){
455
- $file_names[] = $file;
456
- }
457
- }
458
- if(count($file_names) < 1) {
459
- $old_dir = @ opendir($old_theme_path);
460
- while(($file = @ readdir($old_dir)) !== false) {
461
- if(is_dir($old_theme_path.$file) && ($file != "..") && ($file != ".")){
462
- @ wpsc_recursive_copy($old_theme_path.$file, $new_theme_path.$file);
463
- }
464
- }
465
- }
466
- }
467
-
468
-
469
-
470
- /**
471
- *wpsc_update_remove_product_nulls function, converts values to decimal to satisfy mySQL strict mode
472
- * * @return boolean true on success, false on failure
473
- */
474
- function wpsc_update_remove_nulls($colname) {
475
- global $wpdb;
476
- //echo "UPDATE `".WPSC_TABLE_PRODUCT_LIST."` SET `$colname` = CONVERT(`$colname`, DECIMAL)";
477
- if($wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_LIST."` SET `$colname` = 0 WHERE `$colname` NOT REGEXP '^[0-9]+(\.)*[0-9]*'")) {
478
- return true;
479
- } else {
480
- return false;
481
- }
482
- }
483
-
484
- /**
485
- *wpsc_update_image_records function, moves product images to the images table
486
- * * @return boolean true on success, false on failure
487
- */
488
- function wpsc_update_image_records($colname) {
489
- global $wpdb;
490
- $product_data = $wpdb->get_results("SELECT `id`, `image` FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `image` NOT REGEXP '^[0-9]+$'", ARRAY_A);
491
-
492
- foreach((array)$product_data as $product_row) {
493
- if(file_exists(WPSC_IMAGE_DIR.$product_row['image'])) {
494
- $image_id = $wpdb->get_var("SELECT `id` FROM `".WPSC_TABLE_PRODUCT_IMAGES."` WHERE `product_id` = '{$product_row['id']}' AND `image` LIKE '{$product_row['image']}' LIMIT 1");
495
- if($image_id < 1) {
496
- $wpdb->query("INSERT INTO `".WPSC_TABLE_PRODUCT_IMAGES."` (`product_id`, `image`, `width`, `height`) VALUES ('{$product_row['id']}', '{$product_row['image']}', null, null )");
497
- $image_id = (int) $wpdb->insert_id;
498
- }
499
- if($image_id > 0) {
500
- $success_state[] = $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_LIST."` SET `image` = '{$image_id}' WHERE `id` = '{$product_row['id']}' LIMIT 1");
501
- }
502
- } else {
503
- $success_state[] = $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_LIST."` SET `image` = null WHERE `id` = '{$product_row['id']}' LIMIT 1");
504
- }
505
- }
506
- //echo "<pre>".print_r($success_state,true)."</pre>";
507
- //exit();
508
- // if() {
509
- // return true;
510
- // } else {
511
- // return false;
512
- // }
513
- }
514
-
515
-
516
- /**
517
- *wpsc_set_product_creation_dates function, converts values to decimal to satisfy mySQL strict mode
518
- * * @return boolean true on success, false on failure
519
- */
520
- function wpsc_set_product_creation_dates($colname) {
521
- global $wpdb;
522
- if($wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_LIST."` SET `$colname` = NOW() WHERE `$colname` = '0000-00-00 00:00:00'")) {
523
- return true;
524
- } else {
525
- return false;
526
- }
527
- }
528
-
529
-
530
- /**
531
- *wpsc_add_currency_list function, converts values to decimal to satisfy mySQL strict mode
532
- * * @return boolean true on success, false on failure
533
- */
534
- function wpsc_add_currency_list() {
535
- global $wpdb;
536
- require (dirname(__FILE__) . "/currency_list.php");
537
- $currency_data = $wpdb->get_var("SELECT COUNT(*) AS `count` FROM `".WPSC_TABLE_CURRENCY_LIST."`");
538
- if($currency_data == 0) {
539
- $currency_array = explode("\n",$currency_sql);
540
- foreach($currency_array as $currency_row) {
541
- $wpdb->query($currency_row);
542
- }
543
- }
544
- }
545
- /**
546
- *wpsc_add_region_list function, converts values to decimal to satisfy mySQL strict mode
547
- * * @return boolean true on success, false on failure
548
- */
549
- function wpsc_add_region_list() {
550
- global $wpdb;
551
- $add_regions = $wpdb->get_var("SELECT COUNT(*) AS `count` FROM `".WPSC_TABLE_REGION_TAX."`");
552
- // exit($add_regions);
553
- if($add_regions < 1) {
554
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Alberta', '', '0')");
555
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'British Columbia', '', '0')");
556
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Manitoba', '', '0')");
557
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'New Brunswick', '', '0')");
558
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Newfoundland', '', '0')");
559
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Northwest Territories', '', '0')");
560
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Nova Scotia', '', '0')");
561
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Nunavut', '', '0')");
562
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Ontario', '', '0')");
563
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Prince Edward Island', '', '0')");
564
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Quebec', '', '0')");
565
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Saskatchewan', '', '0')");
566
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '100', 'Yukon', '', '0')");
567
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Alabama', 'AL', '0')");
568
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Alaska', 'AK', '0')");
569
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Arizona', 'AZ', '0')");
570
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Arkansas', 'AR', '0')");
571
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'California', 'CA', '0')");
572
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Colorado', 'CO', '0')");
573
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Connecticut', 'CT', '0')");
574
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Delaware', 'DE', '0')");
575
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Florida', 'FL', '0')");
576
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Georgia', 'GA', '0')");
577
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Hawaii', 'HI', '0')");
578
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Idaho', 'ID', '0')");
579
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Illinois', 'IL', '0')");
580
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Indiana', 'IN', '0')");
581
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Iowa', 'IA', '0')");
582
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Kansas', 'KS', '0')");
583
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Kentucky', 'KY', '0')");
584
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Louisiana', 'LA', '0')");
585
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Maine', 'ME', '0')");
586
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Maryland', 'MD', '0')");
587
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Massachusetts', 'MA', '0')");
588
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Michigan', 'MI', '0')");
589
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Minnesota', 'MN', '0')");
590
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Mississippi', 'MS', '0')");
591
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Missouri', 'MO', '0')");
592
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Montana', 'MT', '0')");
593
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Nebraska', 'NE', '0')");
594
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Nevada', 'NV', '0')");
595
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'New Hampshire', 'NH', '0')");
596
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'New Jersey', 'NJ', '0')");
597
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'New Mexico', 'NM', '0')");
598
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'New York', 'NY', '0')");
599
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'North Carolina', 'NC', '0')");
600
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'North Dakota', 'ND', '0')");
601
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Ohio', 'OH', '0')");
602
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Oklahoma', 'OK', '0')");
603
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Oregon', 'OR', '0')");
604
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Pennsylvania', 'PA', '0')");
605
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Rhode Island', 'RI', '0')");
606
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'South Carolina', 'SC', '0')");
607
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'South Dakota', 'SD', '0')");
608
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Tennessee', 'TN', '0')");
609
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Texas', 'TX', '0')");
610
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Utah', 'UT', '0')");
611
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Vermont', 'VT', '0')");
612
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Virginia', 'VA', '0')");
613
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Washington', 'WA', '0')");
614
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Washington DC', 'DC', '0')");
615
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'West Virginia', 'WV', '0')");
616
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Wisconsin', 'WI', '0')");
617
- $wpdb->query("INSERT INTO `".WPSC_TABLE_REGION_TAX."` ( `country_id` , `name` ,`code`, `tax` ) VALUES ( '136', 'Wyoming', 'WY', '0')");
618
- }
619
-
620
- if($wpdb->get_var("SELECT COUNT(*) FROM `".WPSC_TABLE_REGION_TAX."` WHERE `code`=''") > 0){
621
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'AB' WHERE `name` IN('Alberta') LIMIT 1 ;");
622
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'BC' WHERE `name` IN('British Columbia') LIMIT 1 ;");
623
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'MB' WHERE `name` IN('Manitoba') LIMIT 1 ;");
624
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NK' WHERE `name` IN('New Brunswick') LIMIT 1 ;");
625
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NF' WHERE `name` IN('Newfoundland') LIMIT 1 ;");
626
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NT' WHERE `name` IN('Northwest Territories') LIMIT 1 ;");
627
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NS' WHERE `name` IN('Nova Scotia') LIMIT 1 ;");
628
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'ON' WHERE `name` IN('Ontario') LIMIT 1 ;");
629
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'PE' WHERE `name` IN('Prince Edward Island') LIMIT 1 ;");
630
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'PQ' WHERE `name` IN('Quebec') LIMIT 1 ;");
631
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'SN' WHERE `name` IN('Saskatchewan') LIMIT 1 ;");
632
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'YT' WHERE `name` IN('Yukon') LIMIT 1 ;");
633
- $wpdb->query("UPDATE `".WPSC_TABLE_REGION_TAX."` SET `code` = 'NU' WHERE `name` IN('Nunavut') LIMIT 1 ;");
634
- }
635
-
636
- }
637
-
638
-
639
- /**
640
- *wpsc_add_checkout_fields function, converts values to decimal to satisfy mySQL strict mode
641
- * * @return boolean true on success, false on failure
642
- */
643
- function wpsc_add_checkout_fields() {
644
- global $wpdb;
645
- $data_forms = $wpdb->get_results("SELECT COUNT(*) AS `count` FROM `".WPSC_TABLE_CHECKOUT_FORMS."`",ARRAY_A);
646
-
647
- if($data_forms[0]['count'] == 0) {
648
-
649
- $sql = " INSERT INTO `".WPSC_TABLE_CHECKOUT_FORMS."` ( `name`, `type`, `mandatory`, `display_log`, `default`, `active`, `order`, `unique_name`) VALUES ( '".__('1. Your billing/contact details', 'wpsc')."', 'heading', '0', '0', '', '1', 1,''),
650
- ( '".__('First Name', 'wpsc')."', 'text', '1', '1', '', '1', 2,'billingfirstname'),
651
- ( '".__('Last Name', 'wpsc')."', 'text', '1', '1', '', '1', 3,'billinglastname'),
652
- ( '".__('Address', 'wpsc')."', 'address', '1', '0', '', '1', 4,'billingaddress'),
653
- ( '".__('City', 'wpsc')."', 'city', '1', '0', '', '1', 5,'billingcity'),
654
- ( '".__('Country', 'wpsc')."', 'country', '1', '0', '', '1', 7,'billingcountry'),
655
- ( '".__('Postal Code', 'wpsc')."', 'text', '0', '0', '', '1', 8,'billingpostcode'),
656
- ( '".__('Email', 'wpsc')."', 'email', '1', '1', '', '1', 9,'billingemail'),
657
- ( '".__('2. Shipping details', 'wpsc')."', 'heading', '0', '0', '', '1', 10,'delivertoafriend'),
658
- ( '".__('First Name', 'wpsc')."', 'text', '0', '0', '', '1', 11,'shippingfirstname'),
659
- ( '".__('Last Name', 'wpsc')."', 'text', '0', '0', '', '1', 12,'shippinglastname'),
660
- ( '".__('Address', 'wpsc')."', 'address', '0', '0', '', '1', 13,'shippingaddress'),
661
- ( '".__('City', 'wpsc')."', 'city', '0', '0', '', '1', 14,'shippingcity'),
662
- ( '".__('State', 'wpsc')."', 'text', '0', '0', '', '1', 15,'shippingstate'),
663
- ( '".__('Country', 'wpsc')."', 'delivery_country', '0', '0', '', '1', 16,'shippingcountry'),
664
- ( '".__('Postal Code', 'wpsc')."', 'text', '0', '0', '', '1', 17,'shippingpostcode');";
665
- // exit($sql);
666
- $wpdb->query($sql);
667
- update_option('country_form_field', $country_form_id[0]['id']);
668
- update_option('email_form_field', $email_form_id[0]['id']);
669
- $wpdb->query("INSERT INTO `".WPSC_TABLE_CHECKOUT_FORMS."` ( `name`, `type`, `mandatory`, `display_log`, `default`, `active`, `order`, `unique_name` ) VALUES ( '".__('Phone', 'wpsc')."', 'text', '1', '0', '', '1', '8','billingphone');");
670
- }
671
-
672
- }
673
-
674
- /**
675
- * wpsc_create_or_update_tables count function,
676
- * * @return boolean true on success, false on failure
677
- */
678
- function wpsc_create_or_update_tables($debug = false) {
679
- global $wpdb;
680
- // creates or updates the structure of the shopping cart tables
681
-
682
- include('updates/database_template.php');
683
-
684
- $template_hash = sha1(serialize($wpsc_database_template));
685
-
686
- // 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
687
- $wpsc_database_template = apply_filters('wpsc_alter_database_template', $wpsc_database_template);
688
-
689
- if((get_option('wpsc_database_check') == $template_hash) && ($debug == false)) {
690
- //return true;
691
- }
692
-
693
- $failure_reasons = array();
694
- $upgrade_failed = false;
695
- foreach((array)$wpsc_database_template as $table_name => $table_data) {
696
- // 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.
697
- 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']}'")) )) {
698
- //if the table does not exixt, create the table
699
- $constructed_sql_parts = array();
700
- $constructed_sql = "CREATE TABLE `{$table_name}` (\n";
701
-
702
- // loop through the columns
703
- foreach((array)$table_data['columns'] as $column => $properties) {
704
- $constructed_sql_parts[] = "`$column` $properties";
705
- }
706
- // then through the indexes
707
- foreach((array)$table_data['indexes'] as $properties) {
708
- $constructed_sql_parts[] = "$properties";
709
- }
710
- $constructed_sql .= implode(",\n", $constructed_sql_parts);
711
- $constructed_sql .= "\n) ENGINE=MyISAM";
712
-
713
-
714
- // if mySQL is new enough, set the character encoding
715
- if( method_exists($wpdb, 'db_version') && version_compare($wpdb->db_version(), '4.1', '>=')) {
716
- $constructed_sql .= " CHARSET=utf8";
717
- }
718
- $constructed_sql .= ";";
719
-
720
- if(!$wpdb->query($constructed_sql)) {
721
- $upgrade_failed = true;
722
- $failure_reasons[] = $wpdb->last_error;
723
- }
724
-
725
- if(isset($table_data['actions']['after']['all']) && is_callable($table_data['actions']['after']['all'])) {
726
- $table_data['actions']['after']['all']();
727
- }
728
- //echo "<pre>$constructed_sql</pre>";
729
- } else {
730
- // check to see if the new table name is in use
731
- if(!$wpdb->get_var("SHOW TABLES LIKE '$table_name'") && (isset($table_data['previous_names']) && $wpdb->get_var("SHOW TABLES LIKE '{$table_data['previous_names']}'"))) {
732
- $wpdb->query("ALTER TABLE `{$table_data['previous_names']}` RENAME TO `{$table_name}`;");
733
- //$wpdb->query("RENAME TABLE `{$table_data['previous_names']}` TO `{$table_name}`;");
734
- $failure_reasons[] = $wpdb->last_error;
735
- }
736
-
737
- //check to see if the table needs updating
738
- $existing_table_columns = array();
739
- //check and possibly update the character encoding
740
- if( method_exists($wpdb, 'db_version') && version_compare($wpdb->db_version(), '4.1', '>=')) {
741
- $table_status_data = $wpdb->get_row("SHOW TABLE STATUS LIKE '$table_name'", ARRAY_A);
742
- if($table_status_data['Collation'] != 'utf8_general_ci') {
743
- $wpdb->query("ALTER TABLE `$table_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci");
744
- }
745
- }
746
- //get the column list
747
- $existing_table_column_data = $wpdb->get_results("SHOW FULL COLUMNS FROM `$table_name`", ARRAY_A);
748
-
749
- if(isset($table_data['actions']['before']['all']) && is_callable($table_data['actions']['before']['all'])) {
750
- $table_data['actions']['before']['all']();
751
- }
752
-
753
- foreach((array)$existing_table_column_data as $existing_table_column) {
754
- $column_name = $existing_table_column['Field'];
755
- $existing_table_columns[] = $column_name;
756
-
757
- $null_match = false;
758
- if($existing_table_column['Null'] = 'NO') {
759
- if(stristr($table_data['columns'][$column_name], "NOT NULL") !== false) {
760
- $null_match = true;
761
- }
762
- } else {
763
- if(stristr($table_data['columns'][$column_name], "NOT NULL") === false) {
764
- $null_match = true;
765
- }
766
- }
767
-
768
- if(isset($table_data['columns'][$column_name]) && ((stristr($table_data['columns'][$column_name], $existing_table_column['Type']) === false) || ($null_match != true))) {
769
- if(isset($table_data['actions']['before'][$column_name]) && is_callable($table_data['actions']['before'][$column_name])) {
770
- $table_data['actions']['before'][$column_name]($column_name);
771
- }
772
- if(!$wpdb->query("ALTER TABLE `$table_name` CHANGE `$column_name` `$column_name` {$table_data['columns'][$column_name]} ")) {
773
- $upgrade_failed = true;
774
- $failure_reasons[] = $wpdb->last_error;
775
- }
776
- }
777
-
778
- }
779
- $supplied_table_columns = array_keys($table_data['columns']);
780
-
781
- // compare the supplied and existing columns to find the differences
782
- $missing_or_extra_table_columns = array_diff($supplied_table_columns, $existing_table_columns);
783
-
784
- if(count($missing_or_extra_table_columns) > 0) {
785
- foreach((array)$missing_or_extra_table_columns as $missing_or_extra_table_column) {
786
- if(isset($table_data['columns'][$missing_or_extra_table_column])) {
787
- //table column is missing, add it
788
- $previous_column = $supplied_table_columns[array_search($missing_or_extra_table_column, $supplied_table_columns)-1];
789
- if($previous_column != '') {
790
- $previous_column = "AFTER `$previous_column`";
791
- }
792
- $constructed_sql = "ALTER TABLE `$table_name` ADD `$missing_or_extra_table_column` ".$table_data['columns'][$missing_or_extra_table_column]." $previous_column;";
793
- if(!$wpdb->query($constructed_sql)) {
794
- $upgrade_failed = true;
795
- $failure_reasons[] = $wpdb->last_error;
796
- }
797
- // run updating functions to do more complex work with default values and the like
798
- //exit($missing_or_extra_table_column);
799
- if(is_callable($table_data['actions']['after'][$missing_or_extra_table_column])) {
800
- $table_data['actions']['after'][$missing_or_extra_table_column]($missing_or_extra_table_column);
801
- }
802
- }
803
- }
804
- }
805
-
806
- if(isset($table_data['actions']['after']['all']) && is_callable($table_data['actions']['after']['all'])) {
807
- $table_data['actions']['after']['all']();
808
- }
809
- // get the list of existing indexes
810
- $existing_table_index_data = $wpdb->get_results("SHOW INDEX FROM `$table_name`", ARRAY_A);
811
- $existing_table_indexes = array();
812
- foreach($existing_table_index_data as $existing_table_index) {
813
- $existing_table_indexes[] = $existing_table_index['Key_name'];
814
- }
815
-
816
- $existing_table_indexes = array_unique($existing_table_indexes);
817
- $supplied_table_indexes = array_keys($table_data['indexes']);
818
-
819
- // compare the supplied and existing indxes to find the differences
820
- $missing_or_extra_table_indexes = array_diff($supplied_table_indexes, $existing_table_indexes);
821
-
822
- if(count($missing_or_extra_table_indexes) > 0) {
823
- foreach($missing_or_extra_table_indexes as $missing_or_extra_table_index) {
824
- if(isset($table_data['indexes'][$missing_or_extra_table_index])) {
825
- $constructed_sql = "ALTER TABLE `$table_name` ADD ".$table_data['indexes'][$missing_or_extra_table_index].";";
826
- if(!$wpdb->query($constructed_sql)) {
827
- $upgrade_failed = true;
828
- $failure_reasons[] = $wpdb->last_error;
829
- }
830
- }
831
- }
832
- }
833
- }
834
- }
835
-
836
- if($upgrade_failed !== true) {
837
- update_option('wpsc_database_check', $template_hash);
838
- return true;
839
- } else {
840
- return false;
841
- }
842
- //echo "<pre>".print_r($missing_or_extra_table_indexes,true)."</pre>";
843
- }
844
- ?>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
languages/{wpsc-en_EN .pot → wpsc-en_EN.pot} RENAMED
@@ -8,7 +8,7 @@ msgid ""
8
  msgstr ""
9
  "Project-Id-Version: \n"
10
  "Report-Msgid-Bugs-To: http://wordpress.org/tag/wp-e-commerce\n"
11
- "POT-Creation-Date: 2010-06-02 01:51+0000\n"
12
  "PO-Revision-Date: 2010-MO-DA HO:MI+ZONE\n"
13
  "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
14
  "Language-Team: LANGUAGE <LL@li.org>\n"
@@ -21,15 +21,15 @@ msgstr ""
21
  msgid "You are editing the &quot;[categorisation]&quot; Category"
22
  msgstr ""
23
 
24
- #: admin-form-functions.php:11 wpsc-admin/display-groups.page.php:760
25
  msgid "+ Add new category to the &quot;[categorisation]&quot; Group"
26
  msgstr ""
27
 
28
  #: admin-form-functions.php:25 admin-form-functions.php:279
29
  #: admin-form-functions.php:867 display-ecommerce-subs.php:9
30
  #: js/tinymce3/window.php:105 user-log.php:200 user-log.php:359
31
- #: wpsc-admin/display-groups.page.php:699
32
- #: wpsc-admin/display-groups.page.php:775
33
  #: wpsc-admin/display-upgrades.page.php:88
34
  #: wpsc-admin/display-variations.page.php:13
35
  #: wpsc-admin/display-variations.page.php:156
@@ -40,7 +40,7 @@ msgid "Name"
40
  msgstr ""
41
 
42
  #: admin-form-functions.php:34 js/tinymce3/window.php:109
43
- #: wpsc-admin/display-groups.page.php:783
44
  #: wpsc-admin/includes/display-items-functions.php:807
45
  msgid "Description"
46
  msgstr ""
@@ -54,8 +54,8 @@ msgid "Category&nbsp;Image"
54
  msgstr ""
55
 
56
  #: admin-form-functions.php:101 admin-form-functions.php:110
57
- #: admin-form-functions.php:198 wpsc-admin/display-groups.page.php:813
58
- #: wpsc-admin/display-groups.page.php:866
59
  #: wpsc-admin/includes/display-items-functions.php:675
60
  #: wpsc-admin/includes/settings-pages/presentation.php:864
61
  #: wpsc-admin/includes/settings-pages/presentation.php:875
@@ -65,8 +65,8 @@ msgid "Height"
65
  msgstr ""
66
 
67
  #: admin-form-functions.php:101 admin-form-functions.php:110
68
- #: admin-form-functions.php:199 wpsc-admin/display-groups.page.php:813
69
- #: wpsc-admin/display-groups.page.php:867
70
  #: wpsc-admin/includes/display-items-functions.php:687
71
  #: wpsc-admin/includes/settings-pages/presentation.php:865
72
  #: wpsc-admin/includes/settings-pages/presentation.php:875
@@ -76,7 +76,7 @@ msgid "Width"
76
  msgstr ""
77
 
78
  #: admin-form-functions.php:102 admin-form-functions.php:111
79
- #: wpsc-admin/display-groups.page.php:814
80
  msgid ""
81
  "You can upload thumbnail images for each group. To display Group details in "
82
  "your shop you must configure these settings under <a href=\"admin.php?"
@@ -102,18 +102,18 @@ msgid ""
102
  "\t\t\t"
103
  msgstr ""
104
 
105
- #: admin-form-functions.php:164 wpsc-admin/display-groups.page.php:823
106
  #: wpsc-admin/includes/settings-pages/presentation.php:57
107
  msgid "Presentation Settings"
108
  msgstr ""
109
 
110
- #: admin-form-functions.php:165 wpsc-admin/display-groups.page.php:824
111
  msgid ""
112
  "To over-ride the presentation settings for this group you can enter in your "
113
  "prefered settings here"
114
  msgstr ""
115
 
116
- #: admin-form-functions.php:171 wpsc-admin/display-groups.page.php:832
117
  #: wpsc-admin/includes/settings-pages/presentation.php:288
118
  msgid "Catalog View"
119
  msgstr ""
@@ -122,37 +122,37 @@ msgstr ""
122
  msgid "Please select"
123
  msgstr ""
124
 
125
- #: admin-form-functions.php:176 wpsc-admin/display-groups.page.php:836
126
  #: wpsc-admin/includes/settings-pages/presentation.php:346
127
  msgid "Default View"
128
  msgstr ""
129
 
130
  #: admin-form-functions.php:178 admin-form-functions.php:180
131
- #: wpsc-admin/display-groups.page.php:840
132
- #: wpsc-admin/display-groups.page.php:844
133
  #: wpsc-admin/includes/settings-pages/presentation.php:350
134
  #: wpsc-admin/includes/settings-pages/presentation.php:354
135
  msgid "List View"
136
  msgstr ""
137
 
138
  #: admin-form-functions.php:183 admin-form-functions.php:185
139
- #: wpsc-admin/display-groups.page.php:850
140
- #: wpsc-admin/display-groups.page.php:854
141
  #: wpsc-admin/includes/settings-pages/presentation.php:361
142
  #: wpsc-admin/includes/settings-pages/presentation.php:365
143
  msgid "Grid View"
144
  msgstr ""
145
 
146
- #: admin-form-functions.php:195 wpsc-admin/display-groups.page.php:864
147
  msgid "Thumbnail&nbsp;Size"
148
  msgstr ""
149
 
150
- #: admin-form-functions.php:208 wpsc-admin/display-groups.page.php:873
151
  #: wpsc-admin/display-sales-logs.php:317 wpsc-admin/display-sales-logs.php:318
152
  msgid "Checkout Settings"
153
  msgstr ""
154
 
155
- #: admin-form-functions.php:217 wpsc-admin/display-groups.page.php:879
156
  msgid "This category requires additional checkout form fields"
157
  msgstr ""
158
 
@@ -160,14 +160,14 @@ msgstr ""
160
  msgid "None"
161
  msgstr ""
162
 
163
- #: admin-form-functions.php:247 wpsc-admin/display-groups.page.php:907
164
  msgid "Products in this category use the billing address to calculate shipping"
165
  msgstr ""
166
 
167
  #: admin-form-functions.php:250 display-coupons.php:502
168
  #: display-coupons.php:526 merchants/chronopay.php:427
169
  #: merchants/paypal_multiple.php:478 merchants/paypal_multiple.php:486
170
- #: merchants/paypal_multiple.php:502 wpsc-admin/display-groups.page.php:909
171
  #: wpsc-admin/includes/display-items-functions.php:823
172
  #: wpsc-admin/includes/settings-pages/admin.php:38
173
  #: wpsc-admin/includes/settings-pages/admin.php:64
@@ -206,7 +206,7 @@ msgstr ""
206
  #: admin-form-functions.php:251 display-coupons.php:503
207
  #: display-coupons.php:527 merchants/chronopay.php:428
208
  #: merchants/paypal_multiple.php:479 merchants/paypal_multiple.php:487
209
- #: merchants/paypal_multiple.php:503 wpsc-admin/display-groups.page.php:910
210
  #: wpsc-admin/includes/display-items-functions.php:825
211
  #: wpsc-admin/includes/settings-pages/admin.php:39
212
  #: wpsc-admin/includes/settings-pages/admin.php:65
@@ -249,7 +249,7 @@ msgstr ""
249
  #: admin-form-functions.php:262 admin-form-functions.php:300
250
  #: admin-form-functions.php:319 shipping/tablerate.php:44
251
  #: shipping/weightrate.php:35 wpsc-admin/admin.php:347
252
- #: wpsc-admin/ajax-and-init.php:1898 wpsc-admin/display-groups.page.php:670
253
  #: wpsc-admin/display-items.page.php:276 wpsc-admin/display-items.page.php:400
254
  #: wpsc-admin/display-sales-logs.php:425 wpsc-admin/display-sales-logs.php:550
255
  #: wpsc-admin/display-variations.page.php:178
@@ -273,8 +273,8 @@ msgstr ""
273
 
274
  #: admin-form-functions.php:318 display-coupons.php:389
275
  #: display-coupons.php:450 wpsc-admin/display-groups.page.php:106
276
- #: wpsc-admin/display-groups.page.php:707
277
- #: wpsc-admin/display-groups.page.php:720
278
  #: wpsc-admin/display-variations.page.php:14
279
  #: wpsc-admin/display-variations.page.php:111
280
  #: wpsc-includes/variations.class.php:343 wpsc-includes/wpsc_query.php:226
@@ -482,7 +482,7 @@ msgstr ""
482
  msgid "Shipping"
483
  msgstr ""
484
 
485
- #: admin-form-functions.php:976
486
  msgid "This users cart was empty"
487
  msgstr ""
488
 
@@ -527,8 +527,8 @@ msgstr ""
527
  msgid "Display How Customer Found Us Survey"
528
  msgstr ""
529
 
530
- #: display-coupons.php:549 wpsc-admin/display-groups.page.php:643
531
- #: wpsc-admin/display-groups.page.php:668
532
  msgid "Submit"
533
  msgstr ""
534
 
@@ -553,9 +553,8 @@ msgstr ""
553
  msgid "User ID"
554
  msgstr ""
555
 
556
- #: display-ecommerce-subs.php:9 edit-profile.php:39 install_and_update.php:656
557
- #: user-log.php:362 wpsc-admin/admin.php:349
558
- #: wpsc-includes/install_and_update.functions.php:656
559
  msgid "Email"
560
  msgstr ""
561
 
@@ -571,8 +570,7 @@ msgstr ""
571
  msgid "Activate"
572
  msgstr ""
573
 
574
- #: edit-profile.php:31 install_and_update.php:650 install_and_update.php:658
575
- #: wpsc-includes/install_and_update.functions.php:650
576
  #: wpsc-includes/install_and_update.functions.php:658
577
  msgid "First Name"
578
  msgstr ""
@@ -581,8 +579,7 @@ msgstr ""
581
  msgid "Please enter a valid name"
582
  msgstr ""
583
 
584
- #: edit-profile.php:35 install_and_update.php:651 install_and_update.php:659
585
- #: wpsc-includes/install_and_update.functions.php:651
586
  #: wpsc-includes/install_and_update.functions.php:659
587
  msgid "Last Name"
588
  msgstr ""
@@ -607,8 +604,7 @@ msgstr ""
607
  msgid "Please enter a valid address"
608
  msgstr ""
609
 
610
- #: edit-profile.php:48 install_and_update.php:653 install_and_update.php:661
611
- #: wpsc-includes/install_and_update.functions.php:653
612
  #: wpsc-includes/install_and_update.functions.php:661
613
  msgid "City"
614
  msgstr ""
@@ -617,7 +613,7 @@ msgstr ""
617
  msgid "Please enter your town or city."
618
  msgstr ""
619
 
620
- #: edit-profile.php:52 install_and_update.php:669 user-log.php:361
621
  #: wpsc-includes/install_and_update.functions.php:669
622
  msgid "Phone"
623
  msgstr ""
@@ -626,8 +622,8 @@ msgstr ""
626
  msgid "Please enter a valid phone number"
627
  msgstr ""
628
 
629
- #: edit-profile.php:56 install_and_update.php:654 install_and_update.php:663
630
- #: wpsc-admin/admin.php:350 wpsc-includes/install_and_update.functions.php:654
631
  #: wpsc-includes/install_and_update.functions.php:663
632
  msgid "Country"
633
  msgstr ""
@@ -725,250 +721,6 @@ msgstr ""
725
  msgid "Your Categories:"
726
  msgstr ""
727
 
728
- #: install_and_update.php:60 wpsc-includes/install_and_update.functions.php:60
729
- msgid "Example category"
730
- msgstr ""
731
-
732
- #: install_and_update.php:60 install_and_update.php:61
733
- #: wpsc-includes/install_and_update.functions.php:60
734
- #: wpsc-includes/install_and_update.functions.php:61
735
- msgid "Example details"
736
- msgstr ""
737
-
738
- #: install_and_update.php:61 wpsc-includes/install_and_update.functions.php:61
739
- msgid "Example Brand"
740
- msgstr ""
741
-
742
- #: install_and_update.php:68 wp-shopping-cart.php:153
743
- #: wpsc-includes/install_and_update.functions.php:68
744
- msgid "Order Received"
745
- msgstr ""
746
-
747
- #: install_and_update.php:69 wpsc-includes/install_and_update.functions.php:69
748
- msgid "Accepted Payment"
749
- msgstr ""
750
-
751
- #: install_and_update.php:70 wpsc-includes/install_and_update.functions.php:70
752
- msgid "Job Dispatched"
753
- msgstr ""
754
-
755
- #: install_and_update.php:71 wp-shopping-cart.php:155
756
- #: wpsc-includes/install_and_update.functions.php:71
757
- msgid "Closed Order"
758
- msgstr ""
759
-
760
- #: install_and_update.php:87
761
- #: wpsc-admin/includes/settings-pages/presentation.php:892
762
- #: wpsc-includes/install_and_update.functions.php:87
763
- msgid "Show Thumbnails"
764
- msgstr ""
765
-
766
- #: install_and_update.php:89 wpsc-includes/install_and_update.functions.php:89
767
- msgid "product image width"
768
- msgstr ""
769
-
770
- #: install_and_update.php:90 wpsc-includes/install_and_update.functions.php:90
771
- msgid "product image height"
772
- msgstr ""
773
-
774
- #: install_and_update.php:92 wpsc-includes/install_and_update.functions.php:92
775
- msgid "product group image width"
776
- msgstr ""
777
-
778
- #: install_and_update.php:93 wpsc-includes/install_and_update.functions.php:93
779
- msgid "product group image height"
780
- msgstr ""
781
-
782
- #: install_and_update.php:95 wpsc-admin/includes/settings-pages/admin.php:167
783
- #: wpsc-includes/install_and_update.functions.php:95
784
- msgid "The location of the product list"
785
- msgstr ""
786
-
787
- #: install_and_update.php:96 wpsc-admin/includes/settings-pages/admin.php:175
788
- #: wpsc-includes/install_and_update.functions.php:96
789
- msgid "The location of the shopping cart"
790
- msgstr ""
791
-
792
- #: install_and_update.php:97 wpsc-includes/install_and_update.functions.php:97
793
- msgid "The location of the checkout page"
794
- msgstr ""
795
-
796
- #: install_and_update.php:98 wpsc-includes/install_and_update.functions.php:98
797
- msgid "The location of the transaction detail page"
798
- msgstr ""
799
-
800
- #: install_and_update.php:99 wpsc-includes/install_and_update.functions.php:99
801
- msgid "The payment gateway to use"
802
- msgstr ""
803
-
804
- #: install_and_update.php:101 install_and_update.php:103
805
- #: install_and_update.php:107 install_and_update.php:109
806
- #: wpsc-admin/includes/settings-pages/presentation.php:620
807
- #: wpsc-includes/install_and_update.functions.php:101
808
- #: wpsc-includes/install_and_update.functions.php:103
809
- #: wpsc-includes/install_and_update.functions.php:107
810
- #: wpsc-includes/install_and_update.functions.php:109
811
- msgid "Cart Location"
812
- msgstr ""
813
-
814
- #: install_and_update.php:114
815
- #: wpsc-admin/includes/display-items-functions.php:220
816
- #: wpsc-admin/includes/display-items-functions.php:259
817
- #: wpsc-admin/includes/settings-pages/general.php:119
818
- #: wpsc-includes/install_and_update.functions.php:114
819
- msgid "Currency type"
820
- msgstr ""
821
-
822
- #: install_and_update.php:115
823
- #: wpsc-admin/includes/settings-pages/general.php:143
824
- #: wpsc-includes/install_and_update.functions.php:115
825
- msgid "Currency sign location"
826
- msgstr ""
827
-
828
- #: install_and_update.php:117
829
- #: wpsc-includes/install_and_update.functions.php:117
830
- msgid "the GST rate"
831
- msgstr ""
832
-
833
- #: install_and_update.php:119
834
- #: wpsc-includes/install_and_update.functions.php:119
835
- msgid "the download limit"
836
- msgstr ""
837
-
838
- #: install_and_update.php:121
839
- #: wpsc-includes/install_and_update.functions.php:121
840
- msgid "Display or hide postage and packaging"
841
- msgstr ""
842
-
843
- #: install_and_update.php:123
844
- #: wpsc-includes/install_and_update.functions.php:123
845
- msgid "Display or hide specials on the sidebar"
846
- msgstr ""
847
-
848
- #: install_and_update.php:126
849
- #: wpsc-includes/install_and_update.functions.php:126
850
- msgid "Default postage and packaging"
851
- msgstr ""
852
-
853
- #: install_and_update.php:128
854
- #: wpsc-includes/install_and_update.functions.php:128
855
- msgid "Email address that purchase log is sent to"
856
- msgstr ""
857
-
858
- #: install_and_update.php:129
859
- #: wpsc-includes/install_and_update.functions.php:129
860
- msgid "Email address that purchase reports are sent from"
861
- msgstr ""
862
-
863
- #: install_and_update.php:130
864
- #: wpsc-includes/install_and_update.functions.php:130
865
- msgid "Checkout terms and conditions"
866
- msgstr ""
867
-
868
- #: install_and_update.php:132
869
- #: wpsc-includes/install_and_update.functions.php:132
870
- msgid "Google Merchant Key"
871
- msgstr ""
872
-
873
- #: install_and_update.php:133
874
- #: wpsc-includes/install_and_update.functions.php:133
875
- msgid "Google Merchant ID"
876
- msgstr ""
877
-
878
- #: install_and_update.php:135
879
- #: wpsc-includes/install_and_update.functions.php:135
880
- msgid "Default Brand"
881
- msgstr ""
882
-
883
- #: install_and_update.php:136
884
- #: wpsc-includes/install_and_update.functions.php:136
885
- msgid "Select what product group you want to display on the products page"
886
- msgstr ""
887
-
888
- #: install_and_update.php:149 install_and_update.php:155
889
- #: wpsc-includes/install_and_update.functions.php:149
890
- #: wpsc-includes/install_and_update.functions.php:155
891
- msgid "paypal business"
892
- msgstr ""
893
-
894
- #: install_and_update.php:150 install_and_update.php:151
895
- #: install_and_update.php:158
896
- #: wpsc-includes/install_and_update.functions.php:150
897
- #: wpsc-includes/install_and_update.functions.php:151
898
- #: wpsc-includes/install_and_update.functions.php:158
899
- msgid "paypal url"
900
- msgstr ""
901
-
902
- #: install_and_update.php:162
903
- #: wpsc-admin/includes/settings-pages/presentation.php:122
904
- #: wpsc-includes/install_and_update.functions.php:162
905
- msgid "Show Product Ratings"
906
- msgstr ""
907
-
908
- #: install_and_update.php:163 updates/updating_tasks.php:653
909
- #: updates/updating_tasks.php:660
910
- #: wpsc-includes/install_and_update.functions.php:163
911
- msgid ""
912
- "Thank you for purchasing with %shop_name%, any items to be shipped will be "
913
- "processed as soon as possible, any items that can be downloaded can be "
914
- "downloaded using the links on this page.All prices include tax and postage "
915
- "and packaging where applicable.You ordered these items:%product_list%%"
916
- "total_shipping%%total_price%"
917
- msgstr ""
918
-
919
- #: install_and_update.php:164 updates/updating_tasks.php:654
920
- #: updates/updating_tasks.php:667
921
- #: wpsc-includes/install_and_update.functions.php:164
922
- msgid "%product_list%%total_shipping%%total_price%"
923
- msgstr ""
924
-
925
- #: install_and_update.php:207
926
- #: wpsc-includes/install_and_update.functions.php:207
927
- msgid "Products Page"
928
- msgstr ""
929
-
930
- #: install_and_update.php:213 wpsc-admin/display-options-settings.page.php:105
931
- #: wpsc-includes/install_and_update.functions.php:213
932
- msgid "Checkout"
933
- msgstr ""
934
-
935
- #: install_and_update.php:225
936
- #: wpsc-includes/install_and_update.functions.php:225
937
- msgid "Transaction Results"
938
- msgstr ""
939
-
940
- #: install_and_update.php:231
941
- #: wpsc-includes/install_and_update.functions.php:231
942
- msgid "Your Account"
943
- msgstr ""
944
-
945
- #: install_and_update.php:649
946
- #: wpsc-includes/install_and_update.functions.php:649
947
- msgid "1. Your billing/contact details"
948
- msgstr ""
949
-
950
- #: install_and_update.php:652 install_and_update.php:660 user-log.php:360
951
- #: wpsc-includes/install_and_update.functions.php:652
952
- #: wpsc-includes/install_and_update.functions.php:660
953
- msgid "Address"
954
- msgstr ""
955
-
956
- #: install_and_update.php:655 install_and_update.php:664
957
- #: wpsc-includes/install_and_update.functions.php:655
958
- #: wpsc-includes/install_and_update.functions.php:664
959
- msgid "Postal Code"
960
- msgstr ""
961
-
962
- #: install_and_update.php:657
963
- #: wpsc-includes/install_and_update.functions.php:657
964
- msgid "2. Shipping details"
965
- msgstr ""
966
-
967
- #: install_and_update.php:662
968
- #: wpsc-includes/install_and_update.functions.php:662
969
- msgid "State"
970
- msgstr ""
971
-
972
  #: js/tinymce3/window.php:36 js/tinymce3/window.php:118
973
  msgid "Category"
974
  msgstr ""
@@ -1555,7 +1307,7 @@ msgstr ""
1555
  #: themes/default/shopping_cart_page.php:130
1556
  #: themes/iShop/shopping_cart_page.php:115
1557
  #: themes/marketplace/shopping_cart_page.php:114
1558
- #: wpsc-includes/ajax.functions.php:394
1559
  msgid "- Choose a Shipping Rate"
1560
  msgstr ""
1561
 
@@ -1730,6 +1482,21 @@ msgstr ""
1730
  msgid "Your Order from %shop_name% has been dispatched"
1731
  msgstr ""
1732
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1733
  #: user-downloads.php:41
1734
  msgid "File Names"
1735
  msgstr ""
@@ -1779,6 +1546,11 @@ msgstr ""
1779
  msgid "Final Total"
1780
  msgstr ""
1781
 
 
 
 
 
 
1782
  #: user-log.php:384
1783
  msgid "Purchase No."
1784
  msgstr ""
@@ -1806,7 +1578,7 @@ msgid "Admin Menu"
1806
  msgstr ""
1807
 
1808
  #: widgets/category_widget.27.php:19 wpsc-admin/admin.php:104
1809
- #: wpsc-admin/display-groups.page.php:566
1810
  #: wpsc-admin/includes/display-items-functions.php:404
1811
  #: wpsc-includes/category.functions.php:361
1812
  msgid "Categories"
@@ -1878,10 +1650,18 @@ msgstr ""
1878
  msgid "Show Description:"
1879
  msgstr ""
1880
 
1881
- #: wp-shopping-cart.php:152
1882
  msgid "Note: if this is blank, the image will not be resized"
1883
  msgstr ""
1884
 
 
 
 
 
 
 
 
 
1885
  #: wp-shopping-cart.php:526
1886
  msgid "Please Note"
1887
  msgstr ""
@@ -2072,96 +1852,96 @@ msgstr ""
2072
  msgid "The item has not been added"
2073
  msgstr ""
2074
 
2075
- #: wpsc-admin/display-groups.page.php:470
2076
  msgid "The product group has been edited."
2077
  msgstr ""
2078
 
2079
- #: wpsc-admin/display-groups.page.php:475
2080
  msgid "The group has been added."
2081
  msgstr ""
2082
 
2083
- #: wpsc-admin/display-groups.page.php:487
2084
  msgid "The group has been edited."
2085
  msgstr ""
2086
 
2087
- #: wpsc-admin/display-groups.page.php:543
2088
  msgid ""
2089
  "Are you sure you want to delete this category? If the category has any "
2090
  "subcategories, they will be deleted too."
2091
  msgstr ""
2092
 
2093
- #: wpsc-admin/display-groups.page.php:551
2094
  msgid ""
2095
  "Are you sure you want to delete this product group? All categories it "
2096
  "contains will be deleted too."
2097
  msgstr ""
2098
 
2099
- #: wpsc-admin/display-groups.page.php:574
2100
  msgid ""
2101
  "Categorizing your products into groups help your customers find them. For "
2102
  "instance if you sell hats and trousers you might want to setup a Group "
2103
  "called clothes and add hats and trousers to that group."
2104
  msgstr ""
2105
 
2106
- #: wpsc-admin/display-groups.page.php:589
2107
  msgid "Select a Group to Manage"
2108
  msgstr ""
2109
 
2110
- #: wpsc-admin/display-groups.page.php:607
2111
  msgid "or"
2112
  msgstr ""
2113
 
2114
- #: wpsc-admin/display-groups.page.php:609
2115
- #: wpsc-admin/display-groups.page.php:626
2116
  msgid "Add New Group"
2117
  msgstr ""
2118
 
2119
- #: wpsc-admin/display-groups.page.php:650
2120
  msgid "Edit Group"
2121
  msgstr ""
2122
 
2123
- #: wpsc-admin/display-groups.page.php:685
2124
  msgid "&quot;[categorisation]&quot; Group"
2125
  msgstr ""
2126
 
2127
- #: wpsc-admin/display-groups.page.php:695
2128
  msgid "Image"
2129
  msgstr ""
2130
 
2131
- #: wpsc-admin/display-groups.page.php:718
2132
  msgid "You are editing the &quot;[categorisation]&quot; Group"
2133
  msgstr ""
2134
 
2135
- #: wpsc-admin/display-groups.page.php:739
2136
- #: wpsc-admin/display-groups.page.php:743
2137
  msgid "You are editing an item in the &quot;[categorisation]&quot; Group"
2138
  msgstr ""
2139
 
2140
- #: wpsc-admin/display-groups.page.php:742
2141
  msgid "Edit Details"
2142
  msgstr ""
2143
 
2144
- #: wpsc-admin/display-groups.page.php:758
2145
- #: wpsc-admin/display-groups.page.php:921
2146
  msgid "Add Category"
2147
  msgstr ""
2148
 
2149
- #: wpsc-admin/display-groups.page.php:761
2150
  msgid ""
2151
  "Adding a new category here will make it available when you add or edit a "
2152
  "product."
2153
  msgstr ""
2154
 
2155
- #: wpsc-admin/display-groups.page.php:767
2156
- #: wpsc-admin/display-groups.page.php:770
2157
  msgid "You are adding a new item to the &quot;[categorisation]&quot; Group"
2158
  msgstr ""
2159
 
2160
- #: wpsc-admin/display-groups.page.php:792
2161
  msgid "Group Parent"
2162
  msgstr ""
2163
 
2164
- #: wpsc-admin/display-groups.page.php:800
2165
  msgid "Group&nbsp;Image"
2166
  msgstr ""
2167
 
@@ -2299,6 +2079,11 @@ msgstr ""
2299
  msgid "Import"
2300
  msgstr ""
2301
 
 
 
 
 
 
2302
  #: wpsc-admin/display-options-settings.page.php:176
2303
  msgid "To configure a shipping module select one on the left."
2304
  msgstr ""
@@ -2720,6 +2505,13 @@ msgstr ""
2720
  msgid "New Currency"
2721
  msgstr ""
2722
 
 
 
 
 
 
 
 
2723
  #: wpsc-admin/includes/display-items-functions.php:244
2724
  #: wpsc-admin/includes/display-items-functions.php:283
2725
  msgid "Delete Currency"
@@ -3125,6 +2917,16 @@ msgstr ""
3125
  msgid "URL Settings"
3126
  msgstr ""
3127
 
 
 
 
 
 
 
 
 
 
 
3128
  #: wpsc-admin/includes/settings-pages/admin.php:193
3129
  msgid "Transaction Details URL"
3130
  msgstr ""
@@ -3256,6 +3058,11 @@ msgstr ""
3256
  msgid "Currency Settings"
3257
  msgstr ""
3258
 
 
 
 
 
 
3259
  #: wpsc-admin/includes/settings-pages/general.php:194
3260
  msgid "Hide Decimals on Products Pages"
3261
  msgstr ""
@@ -3300,6 +3107,11 @@ msgstr ""
3300
  msgid "Product Settings"
3301
  msgstr ""
3302
 
 
 
 
 
 
3303
  #: wpsc-admin/includes/settings-pages/presentation.php:146
3304
  msgid "Display Fancy Purchase Notifications"
3305
  msgstr ""
@@ -3471,6 +3283,14 @@ msgstr ""
3471
  msgid "Shopping Cart Settings"
3472
  msgstr ""
3473
 
 
 
 
 
 
 
 
 
3474
  #: wpsc-admin/includes/settings-pages/presentation.php:649
3475
  #: wpsc-admin/includes/settings-pages/presentation.php:653
3476
  msgid "Sidebar"
@@ -3562,6 +3382,11 @@ msgstr ""
3562
  msgid "Single Product Image Size"
3563
  msgstr ""
3564
 
 
 
 
 
 
3565
  #: wpsc-admin/includes/settings-pages/presentation.php:918
3566
  msgid "Show Thumbnail Gallery"
3567
  msgstr ""
@@ -3681,45 +3506,45 @@ msgid ""
3681
  "server, you may need to contact your web hosting provider to get it set up. "
3682
  msgstr ""
3683
 
3684
- #: wpsc-includes/ajax.functions.php:93
3685
  msgid "You just added \"[product_name]\" to your cart."
3686
  msgstr ""
3687
 
3688
- #: wpsc-includes/ajax.functions.php:96
3689
  msgid "Sorry, but you cannot add zero items to your cart"
3690
  msgstr ""
3691
 
3692
- #: wpsc-includes/ajax.functions.php:98
3693
  msgid "Sorry, but there are only [number] of this item in stock."
3694
  msgstr ""
3695
 
3696
- #: wpsc-includes/ajax.functions.php:100
3697
  msgid "Sorry, but the item \"[product_name]\" is out of stock."
3698
  msgstr ""
3699
 
3700
- #: wpsc-includes/ajax.functions.php:582
3701
  msgid ""
3702
  "You must select a shipping method, otherwise we cannot process your order."
3703
  msgstr ""
3704
 
3705
- #: wpsc-includes/ajax.functions.php:587
3706
  msgid ""
3707
  "Please agree to the terms and conditions, otherwise we cannot process your "
3708
  "order."
3709
  msgstr ""
3710
 
3711
- #: wpsc-includes/ajax.functions.php:607
3712
  #, php-format
3713
  msgid ""
3714
  "Oops the product : %s cannot be shipped to %s. To continue with your "
3715
  "transaction please remove this product from the list above."
3716
  msgstr ""
3717
 
3718
- #: wpsc-includes/ajax.functions.php:630
3719
  msgid "Please enter a Zipcode and click calculate to proceed"
3720
  msgstr ""
3721
 
3722
- #: wpsc-includes/ajax.functions.php:969 wpsc-includes/ajax.functions.php:1028
3723
  msgid ""
3724
  "This download is no longer valid, Please contact the site administrator for "
3725
  "more information."
@@ -3784,6 +3609,143 @@ msgstr ""
3784
  msgid "No Product"
3785
  msgstr ""
3786
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
3787
  #: wpsc-includes/misc.functions.php:46
3788
  msgid "<strong>ERROR</strong>: Please enter a username."
3789
  msgstr ""
8
  msgstr ""
9
  "Project-Id-Version: \n"
10
  "Report-Msgid-Bugs-To: http://wordpress.org/tag/wp-e-commerce\n"
11
+ "POT-Creation-Date: 2010-06-08 02:28+0000\n"
12
  "PO-Revision-Date: 2010-MO-DA HO:MI+ZONE\n"
13
  "Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
14
  "Language-Team: LANGUAGE <LL@li.org>\n"
21
  msgid "You are editing the &quot;[categorisation]&quot; Category"
22
  msgstr ""
23
 
24
+ #: admin-form-functions.php:11 wpsc-admin/display-groups.page.php:759
25
  msgid "+ Add new category to the &quot;[categorisation]&quot; Group"
26
  msgstr ""
27
 
28
  #: admin-form-functions.php:25 admin-form-functions.php:279
29
  #: admin-form-functions.php:867 display-ecommerce-subs.php:9
30
  #: js/tinymce3/window.php:105 user-log.php:200 user-log.php:359
31
+ #: wpsc-admin/display-groups.page.php:698
32
+ #: wpsc-admin/display-groups.page.php:774
33
  #: wpsc-admin/display-upgrades.page.php:88
34
  #: wpsc-admin/display-variations.page.php:13
35
  #: wpsc-admin/display-variations.page.php:156
40
  msgstr ""
41
 
42
  #: admin-form-functions.php:34 js/tinymce3/window.php:109
43
+ #: wpsc-admin/display-groups.page.php:782
44
  #: wpsc-admin/includes/display-items-functions.php:807
45
  msgid "Description"
46
  msgstr ""
54
  msgstr ""
55
 
56
  #: admin-form-functions.php:101 admin-form-functions.php:110
57
+ #: admin-form-functions.php:198 wpsc-admin/display-groups.page.php:812
58
+ #: wpsc-admin/display-groups.page.php:865
59
  #: wpsc-admin/includes/display-items-functions.php:675
60
  #: wpsc-admin/includes/settings-pages/presentation.php:864
61
  #: wpsc-admin/includes/settings-pages/presentation.php:875
65
  msgstr ""
66
 
67
  #: admin-form-functions.php:101 admin-form-functions.php:110
68
+ #: admin-form-functions.php:199 wpsc-admin/display-groups.page.php:812
69
+ #: wpsc-admin/display-groups.page.php:866
70
  #: wpsc-admin/includes/display-items-functions.php:687
71
  #: wpsc-admin/includes/settings-pages/presentation.php:865
72
  #: wpsc-admin/includes/settings-pages/presentation.php:875
76
  msgstr ""
77
 
78
  #: admin-form-functions.php:102 admin-form-functions.php:111
79
+ #: wpsc-admin/display-groups.page.php:813
80
  msgid ""
81
  "You can upload thumbnail images for each group. To display Group details in "
82
  "your shop you must configure these settings under <a href=\"admin.php?"
102
  "\t\t\t"
103
  msgstr ""
104
 
105
+ #: admin-form-functions.php:164 wpsc-admin/display-groups.page.php:822
106
  #: wpsc-admin/includes/settings-pages/presentation.php:57
107
  msgid "Presentation Settings"
108
  msgstr ""
109
 
110
+ #: admin-form-functions.php:165 wpsc-admin/display-groups.page.php:823
111
  msgid ""
112
  "To over-ride the presentation settings for this group you can enter in your "
113
  "prefered settings here"
114
  msgstr ""
115
 
116
+ #: admin-form-functions.php:171 wpsc-admin/display-groups.page.php:831
117
  #: wpsc-admin/includes/settings-pages/presentation.php:288
118
  msgid "Catalog View"
119
  msgstr ""
122
  msgid "Please select"
123
  msgstr ""
124
 
125
+ #: admin-form-functions.php:176 wpsc-admin/display-groups.page.php:835
126
  #: wpsc-admin/includes/settings-pages/presentation.php:346
127
  msgid "Default View"
128
  msgstr ""
129
 
130
  #: admin-form-functions.php:178 admin-form-functions.php:180
131
+ #: wpsc-admin/display-groups.page.php:839
132
+ #: wpsc-admin/display-groups.page.php:843
133
  #: wpsc-admin/includes/settings-pages/presentation.php:350
134
  #: wpsc-admin/includes/settings-pages/presentation.php:354
135
  msgid "List View"
136
  msgstr ""
137
 
138
  #: admin-form-functions.php:183 admin-form-functions.php:185
139
+ #: wpsc-admin/display-groups.page.php:849
140
+ #: wpsc-admin/display-groups.page.php:853
141
  #: wpsc-admin/includes/settings-pages/presentation.php:361
142
  #: wpsc-admin/includes/settings-pages/presentation.php:365
143
  msgid "Grid View"
144
  msgstr ""
145
 
146
+ #: admin-form-functions.php:195 wpsc-admin/display-groups.page.php:863
147
  msgid "Thumbnail&nbsp;Size"
148
  msgstr ""
149
 
150
+ #: admin-form-functions.php:208 wpsc-admin/display-groups.page.php:872
151
  #: wpsc-admin/display-sales-logs.php:317 wpsc-admin/display-sales-logs.php:318
152
  msgid "Checkout Settings"
153
  msgstr ""
154
 
155
+ #: admin-form-functions.php:217 wpsc-admin/display-groups.page.php:878
156
  msgid "This category requires additional checkout form fields"
157
  msgstr ""
158
 
160
  msgid "None"
161
  msgstr ""
162
 
163
+ #: admin-form-functions.php:247 wpsc-admin/display-groups.page.php:906
164
  msgid "Products in this category use the billing address to calculate shipping"
165
  msgstr ""
166
 
167
  #: admin-form-functions.php:250 display-coupons.php:502
168
  #: display-coupons.php:526 merchants/chronopay.php:427
169
  #: merchants/paypal_multiple.php:478 merchants/paypal_multiple.php:486
170
+ #: merchants/paypal_multiple.php:502 wpsc-admin/display-groups.page.php:908
171
  #: wpsc-admin/includes/display-items-functions.php:823
172
  #: wpsc-admin/includes/settings-pages/admin.php:38
173
  #: wpsc-admin/includes/settings-pages/admin.php:64
206
  #: admin-form-functions.php:251 display-coupons.php:503
207
  #: display-coupons.php:527 merchants/chronopay.php:428
208
  #: merchants/paypal_multiple.php:479 merchants/paypal_multiple.php:487
209
+ #: merchants/paypal_multiple.php:503 wpsc-admin/display-groups.page.php:909
210
  #: wpsc-admin/includes/display-items-functions.php:825
211
  #: wpsc-admin/includes/settings-pages/admin.php:39
212
  #: wpsc-admin/includes/settings-pages/admin.php:65
249
  #: admin-form-functions.php:262 admin-form-functions.php:300
250
  #: admin-form-functions.php:319 shipping/tablerate.php:44
251
  #: shipping/weightrate.php:35 wpsc-admin/admin.php:347
252
+ #: wpsc-admin/ajax-and-init.php:1897 wpsc-admin/display-groups.page.php:669
253
  #: wpsc-admin/display-items.page.php:276 wpsc-admin/display-items.page.php:400
254
  #: wpsc-admin/display-sales-logs.php:425 wpsc-admin/display-sales-logs.php:550
255
  #: wpsc-admin/display-variations.page.php:178
273
 
274
  #: admin-form-functions.php:318 display-coupons.php:389
275
  #: display-coupons.php:450 wpsc-admin/display-groups.page.php:106
276
+ #: wpsc-admin/display-groups.page.php:706
277
+ #: wpsc-admin/display-groups.page.php:719
278
  #: wpsc-admin/display-variations.page.php:14
279
  #: wpsc-admin/display-variations.page.php:111
280
  #: wpsc-includes/variations.class.php:343 wpsc-includes/wpsc_query.php:226
482
  msgid "Shipping"
483
  msgstr ""
484
 
485
+ #: admin-form-functions.php:980
486
  msgid "This users cart was empty"
487
  msgstr ""
488
 
527
  msgid "Display How Customer Found Us Survey"
528
  msgstr ""
529
 
530
+ #: display-coupons.php:549 wpsc-admin/display-groups.page.php:642
531
+ #: wpsc-admin/display-groups.page.php:667
532
  msgid "Submit"
533
  msgstr ""
534
 
553
  msgid "User ID"
554
  msgstr ""
555
 
556
+ #: display-ecommerce-subs.php:9 edit-profile.php:39 user-log.php:362
557
+ #: wpsc-admin/admin.php:349 wpsc-includes/install_and_update.functions.php:656
 
558
  msgid "Email"
559
  msgstr ""
560
 
570
  msgid "Activate"
571
  msgstr ""
572
 
573
+ #: edit-profile.php:31 wpsc-includes/install_and_update.functions.php:650
 
574
  #: wpsc-includes/install_and_update.functions.php:658
575
  msgid "First Name"
576
  msgstr ""
579
  msgid "Please enter a valid name"
580
  msgstr ""
581
 
582
+ #: edit-profile.php:35 wpsc-includes/install_and_update.functions.php:651
 
583
  #: wpsc-includes/install_and_update.functions.php:659
584
  msgid "Last Name"
585
  msgstr ""
604
  msgid "Please enter a valid address"
605
  msgstr ""
606
 
607
+ #: edit-profile.php:48 wpsc-includes/install_and_update.functions.php:653
 
608
  #: wpsc-includes/install_and_update.functions.php:661
609
  msgid "City"
610
  msgstr ""
613
  msgid "Please enter your town or city."
614
  msgstr ""
615
 
616
+ #: edit-profile.php:52 user-log.php:361
617
  #: wpsc-includes/install_and_update.functions.php:669
618
  msgid "Phone"
619
  msgstr ""
622
  msgid "Please enter a valid phone number"
623
  msgstr ""
624
 
625
+ #: edit-profile.php:56 wpsc-admin/admin.php:350
626
+ #: wpsc-includes/install_and_update.functions.php:654
627
  #: wpsc-includes/install_and_update.functions.php:663
628
  msgid "Country"
629
  msgstr ""
721
  msgid "Your Categories:"
722
  msgstr ""
723
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
724
  #: js/tinymce3/window.php:36 js/tinymce3/window.php:118
725
  msgid "Category"
726
  msgstr ""
1307
  #: themes/default/shopping_cart_page.php:130
1308
  #: themes/iShop/shopping_cart_page.php:115
1309
  #: themes/marketplace/shopping_cart_page.php:114
1310
+ #: wpsc-includes/ajax.functions.php:405
1311
  msgid "- Choose a Shipping Rate"
1312
  msgstr ""
1313
 
1482
  msgid "Your Order from %shop_name% has been dispatched"
1483
  msgstr ""
1484
 
1485
+ #: updates/updating_tasks.php:653 updates/updating_tasks.php:660
1486
+ #: wpsc-includes/install_and_update.functions.php:163
1487
+ msgid ""
1488
+ "Thank you for purchasing with %shop_name%, any items to be shipped will be "
1489
+ "processed as soon as possible, any items that can be downloaded can be "
1490
+ "downloaded using the links on this page.All prices include tax and postage "
1491
+ "and packaging where applicable.You ordered these items:%product_list%%"
1492
+ "total_shipping%%total_price%"
1493
+ msgstr ""
1494
+
1495
+ #: updates/updating_tasks.php:654 updates/updating_tasks.php:667
1496
+ #: wpsc-includes/install_and_update.functions.php:164
1497
+ msgid "%product_list%%total_shipping%%total_price%"
1498
+ msgstr ""
1499
+
1500
  #: user-downloads.php:41
1501
  msgid "File Names"
1502
  msgstr ""
1546
  msgid "Final Total"
1547
  msgstr ""
1548
 
1549
+ #: user-log.php:360 wpsc-includes/install_and_update.functions.php:652
1550
+ #: wpsc-includes/install_and_update.functions.php:660
1551
+ msgid "Address"
1552
+ msgstr ""
1553
+
1554
  #: user-log.php:384
1555
  msgid "Purchase No."
1556
  msgstr ""
1578
  msgstr ""
1579
 
1580
  #: widgets/category_widget.27.php:19 wpsc-admin/admin.php:104
1581
+ #: wpsc-admin/display-groups.page.php:565
1582
  #: wpsc-admin/includes/display-items-functions.php:404
1583
  #: wpsc-includes/category.functions.php:361
1584
  msgid "Categories"
1650
  msgid "Show Description:"
1651
  msgstr ""
1652
 
1653
+ #: wp-shopping-cart.php:150
1654
  msgid "Note: if this is blank, the image will not be resized"
1655
  msgstr ""
1656
 
1657
+ #: wp-shopping-cart.php:151 wpsc-includes/install_and_update.functions.php:68
1658
+ msgid "Order Received"
1659
+ msgstr ""
1660
+
1661
+ #: wp-shopping-cart.php:153 wpsc-includes/install_and_update.functions.php:71
1662
+ msgid "Closed Order"
1663
+ msgstr ""
1664
+
1665
  #: wp-shopping-cart.php:526
1666
  msgid "Please Note"
1667
  msgstr ""
1852
  msgid "The item has not been added"
1853
  msgstr ""
1854
 
1855
+ #: wpsc-admin/display-groups.page.php:469
1856
  msgid "The product group has been edited."
1857
  msgstr ""
1858
 
1859
+ #: wpsc-admin/display-groups.page.php:474
1860
  msgid "The group has been added."
1861
  msgstr ""
1862
 
1863
+ #: wpsc-admin/display-groups.page.php:486
1864
  msgid "The group has been edited."
1865
  msgstr ""
1866
 
1867
+ #: wpsc-admin/display-groups.page.php:542
1868
  msgid ""
1869
  "Are you sure you want to delete this category? If the category has any "
1870
  "subcategories, they will be deleted too."
1871
  msgstr ""
1872
 
1873
+ #: wpsc-admin/display-groups.page.php:550
1874
  msgid ""
1875
  "Are you sure you want to delete this product group? All categories it "
1876
  "contains will be deleted too."
1877
  msgstr ""
1878
 
1879
+ #: wpsc-admin/display-groups.page.php:573
1880
  msgid ""
1881
  "Categorizing your products into groups help your customers find them. For "
1882
  "instance if you sell hats and trousers you might want to setup a Group "
1883
  "called clothes and add hats and trousers to that group."
1884
  msgstr ""
1885
 
1886
+ #: wpsc-admin/display-groups.page.php:588
1887
  msgid "Select a Group to Manage"
1888
  msgstr ""
1889
 
1890
+ #: wpsc-admin/display-groups.page.php:606
1891
  msgid "or"
1892
  msgstr ""
1893
 
1894
+ #: wpsc-admin/display-groups.page.php:608
1895
+ #: wpsc-admin/display-groups.page.php:625
1896
  msgid "Add New Group"
1897
  msgstr ""
1898
 
1899
+ #: wpsc-admin/display-groups.page.php:649
1900
  msgid "Edit Group"
1901
  msgstr ""
1902
 
1903
+ #: wpsc-admin/display-groups.page.php:684
1904
  msgid "&quot;[categorisation]&quot; Group"
1905
  msgstr ""
1906
 
1907
+ #: wpsc-admin/display-groups.page.php:694
1908
  msgid "Image"
1909
  msgstr ""
1910
 
1911
+ #: wpsc-admin/display-groups.page.php:717
1912
  msgid "You are editing the &quot;[categorisation]&quot; Group"
1913
  msgstr ""
1914
 
1915
+ #: wpsc-admin/display-groups.page.php:738
1916
+ #: wpsc-admin/display-groups.page.php:742
1917
  msgid "You are editing an item in the &quot;[categorisation]&quot; Group"
1918
  msgstr ""
1919
 
1920
+ #: wpsc-admin/display-groups.page.php:741
1921
  msgid "Edit Details"
1922
  msgstr ""
1923
 
1924
+ #: wpsc-admin/display-groups.page.php:757
1925
+ #: wpsc-admin/display-groups.page.php:920
1926
  msgid "Add Category"
1927
  msgstr ""
1928
 
1929
+ #: wpsc-admin/display-groups.page.php:760
1930
  msgid ""
1931
  "Adding a new category here will make it available when you add or edit a "
1932
  "product."
1933
  msgstr ""
1934
 
1935
+ #: wpsc-admin/display-groups.page.php:766
1936
+ #: wpsc-admin/display-groups.page.php:769
1937
  msgid "You are adding a new item to the &quot;[categorisation]&quot; Group"
1938
  msgstr ""
1939
 
1940
+ #: wpsc-admin/display-groups.page.php:791
1941
  msgid "Group Parent"
1942
  msgstr ""
1943
 
1944
+ #: wpsc-admin/display-groups.page.php:799
1945
  msgid "Group&nbsp;Image"
1946
  msgstr ""
1947
 
2079
  msgid "Import"
2080
  msgstr ""
2081
 
2082
+ #: wpsc-admin/display-options-settings.page.php:105
2083
+ #: wpsc-includes/install_and_update.functions.php:213
2084
+ msgid "Checkout"
2085
+ msgstr ""
2086
+
2087
  #: wpsc-admin/display-options-settings.page.php:176
2088
  msgid "To configure a shipping module select one on the left."
2089
  msgstr ""
2505
  msgid "New Currency"
2506
  msgstr ""
2507
 
2508
+ #: wpsc-admin/includes/display-items-functions.php:220
2509
+ #: wpsc-admin/includes/display-items-functions.php:259
2510
+ #: wpsc-admin/includes/settings-pages/general.php:119
2511
+ #: wpsc-includes/install_and_update.functions.php:114
2512
+ msgid "Currency type"
2513
+ msgstr ""
2514
+
2515
  #: wpsc-admin/includes/display-items-functions.php:244
2516
  #: wpsc-admin/includes/display-items-functions.php:283
2517
  msgid "Delete Currency"
2917
  msgid "URL Settings"
2918
  msgstr ""
2919
 
2920
+ #: wpsc-admin/includes/settings-pages/admin.php:167
2921
+ #: wpsc-includes/install_and_update.functions.php:95
2922
+ msgid "The location of the product list"
2923
+ msgstr ""
2924
+
2925
+ #: wpsc-admin/includes/settings-pages/admin.php:175
2926
+ #: wpsc-includes/install_and_update.functions.php:96
2927
+ msgid "The location of the shopping cart"
2928
+ msgstr ""
2929
+
2930
  #: wpsc-admin/includes/settings-pages/admin.php:193
2931
  msgid "Transaction Details URL"
2932
  msgstr ""
3058
  msgid "Currency Settings"
3059
  msgstr ""
3060
 
3061
+ #: wpsc-admin/includes/settings-pages/general.php:143
3062
+ #: wpsc-includes/install_and_update.functions.php:115
3063
+ msgid "Currency sign location"
3064
+ msgstr ""
3065
+
3066
  #: wpsc-admin/includes/settings-pages/general.php:194
3067
  msgid "Hide Decimals on Products Pages"
3068
  msgstr ""
3107
  msgid "Product Settings"
3108
  msgstr ""
3109
 
3110
+ #: wpsc-admin/includes/settings-pages/presentation.php:122
3111
+ #: wpsc-includes/install_and_update.functions.php:162
3112
+ msgid "Show Product Ratings"
3113
+ msgstr ""
3114
+
3115
  #: wpsc-admin/includes/settings-pages/presentation.php:146
3116
  msgid "Display Fancy Purchase Notifications"
3117
  msgstr ""
3283
  msgid "Shopping Cart Settings"
3284
  msgstr ""
3285
 
3286
+ #: wpsc-admin/includes/settings-pages/presentation.php:620
3287
+ #: wpsc-includes/install_and_update.functions.php:101
3288
+ #: wpsc-includes/install_and_update.functions.php:103
3289
+ #: wpsc-includes/install_and_update.functions.php:107
3290
+ #: wpsc-includes/install_and_update.functions.php:109
3291
+ msgid "Cart Location"
3292
+ msgstr ""
3293
+
3294
  #: wpsc-admin/includes/settings-pages/presentation.php:649
3295
  #: wpsc-admin/includes/settings-pages/presentation.php:653
3296
  msgid "Sidebar"
3382
  msgid "Single Product Image Size"
3383
  msgstr ""
3384
 
3385
+ #: wpsc-admin/includes/settings-pages/presentation.php:892
3386
+ #: wpsc-includes/install_and_update.functions.php:87
3387
+ msgid "Show Thumbnails"
3388
+ msgstr ""
3389
+
3390
  #: wpsc-admin/includes/settings-pages/presentation.php:918
3391
  msgid "Show Thumbnail Gallery"
3392
  msgstr ""
3506
  "server, you may need to contact your web hosting provider to get it set up. "
3507
  msgstr ""
3508
 
3509
+ #: wpsc-includes/ajax.functions.php:104
3510
  msgid "You just added \"[product_name]\" to your cart."
3511
  msgstr ""
3512
 
3513
+ #: wpsc-includes/ajax.functions.php:107
3514
  msgid "Sorry, but you cannot add zero items to your cart"
3515
  msgstr ""
3516
 
3517
+ #: wpsc-includes/ajax.functions.php:109
3518
  msgid "Sorry, but there are only [number] of this item in stock."
3519
  msgstr ""
3520
 
3521
+ #: wpsc-includes/ajax.functions.php:111
3522
  msgid "Sorry, but the item \"[product_name]\" is out of stock."
3523
  msgstr ""
3524
 
3525
+ #: wpsc-includes/ajax.functions.php:593
3526
  msgid ""
3527
  "You must select a shipping method, otherwise we cannot process your order."
3528
  msgstr ""
3529
 
3530
+ #: wpsc-includes/ajax.functions.php:598
3531
  msgid ""
3532
  "Please agree to the terms and conditions, otherwise we cannot process your "
3533
  "order."
3534
  msgstr ""
3535
 
3536
+ #: wpsc-includes/ajax.functions.php:618
3537
  #, php-format
3538
  msgid ""
3539
  "Oops the product : %s cannot be shipped to %s. To continue with your "
3540
  "transaction please remove this product from the list above."
3541
  msgstr ""
3542
 
3543
+ #: wpsc-includes/ajax.functions.php:641
3544
  msgid "Please enter a Zipcode and click calculate to proceed"
3545
  msgstr ""
3546
 
3547
+ #: wpsc-includes/ajax.functions.php:980 wpsc-includes/ajax.functions.php:1039
3548
  msgid ""
3549
  "This download is no longer valid, Please contact the site administrator for "
3550
  "more information."
3609
  msgid "No Product"
3610
  msgstr ""
3611
 
3612
+ #: wpsc-includes/install_and_update.functions.php:60
3613
+ msgid "Example category"
3614
+ msgstr ""
3615
+
3616
+ #: wpsc-includes/install_and_update.functions.php:60
3617
+ #: wpsc-includes/install_and_update.functions.php:61
3618
+ msgid "Example details"
3619
+ msgstr ""
3620
+
3621
+ #: wpsc-includes/install_and_update.functions.php:61
3622
+ msgid "Example Brand"
3623
+ msgstr ""
3624
+
3625
+ #: wpsc-includes/install_and_update.functions.php:69
3626
+ msgid "Accepted Payment"
3627
+ msgstr ""
3628
+
3629
+ #: wpsc-includes/install_and_update.functions.php:70
3630
+ msgid "Job Dispatched"
3631
+ msgstr ""
3632
+
3633
+ #: wpsc-includes/install_and_update.functions.php:89
3634
+ msgid "product image width"
3635
+ msgstr ""
3636
+
3637
+ #: wpsc-includes/install_and_update.functions.php:90
3638
+ msgid "product image height"
3639
+ msgstr ""
3640
+
3641
+ #: wpsc-includes/install_and_update.functions.php:92
3642
+ msgid "product group image width"
3643
+ msgstr ""
3644
+
3645
+ #: wpsc-includes/install_and_update.functions.php:93
3646
+ msgid "product group image height"
3647
+ msgstr ""
3648
+
3649
+ #: wpsc-includes/install_and_update.functions.php:97
3650
+ msgid "The location of the checkout page"
3651
+ msgstr ""
3652
+
3653
+ #: wpsc-includes/install_and_update.functions.php:98
3654
+ msgid "The location of the transaction detail page"
3655
+ msgstr ""
3656
+
3657
+ #: wpsc-includes/install_and_update.functions.php:99
3658
+ msgid "The payment gateway to use"
3659
+ msgstr ""
3660
+
3661
+ #: wpsc-includes/install_and_update.functions.php:117
3662
+ msgid "the GST rate"
3663
+ msgstr ""
3664
+
3665
+ #: wpsc-includes/install_and_update.functions.php:119
3666
+ msgid "the download limit"
3667
+ msgstr ""
3668
+
3669
+ #: wpsc-includes/install_and_update.functions.php:121
3670
+ msgid "Display or hide postage and packaging"
3671
+ msgstr ""
3672
+
3673
+ #: wpsc-includes/install_and_update.functions.php:123
3674
+ msgid "Display or hide specials on the sidebar"
3675
+ msgstr ""
3676
+
3677
+ #: wpsc-includes/install_and_update.functions.php:126
3678
+ msgid "Default postage and packaging"
3679
+ msgstr ""
3680
+
3681
+ #: wpsc-includes/install_and_update.functions.php:128
3682
+ msgid "Email address that purchase log is sent to"
3683
+ msgstr ""
3684
+
3685
+ #: wpsc-includes/install_and_update.functions.php:129
3686
+ msgid "Email address that purchase reports are sent from"
3687
+ msgstr ""
3688
+
3689
+ #: wpsc-includes/install_and_update.functions.php:130
3690
+ msgid "Checkout terms and conditions"
3691
+ msgstr ""
3692
+
3693
+ #: wpsc-includes/install_and_update.functions.php:132
3694
+ msgid "Google Merchant Key"
3695
+ msgstr ""
3696
+
3697
+ #: wpsc-includes/install_and_update.functions.php:133
3698
+ msgid "Google Merchant ID"
3699
+ msgstr ""
3700
+
3701
+ #: wpsc-includes/install_and_update.functions.php:135
3702
+ msgid "Default Brand"
3703
+ msgstr ""
3704
+
3705
+ #: wpsc-includes/install_and_update.functions.php:136
3706
+ msgid "Select what product group you want to display on the products page"
3707
+ msgstr ""
3708
+
3709
+ #: wpsc-includes/install_and_update.functions.php:149
3710
+ #: wpsc-includes/install_and_update.functions.php:155
3711
+ msgid "paypal business"
3712
+ msgstr ""
3713
+
3714
+ #: wpsc-includes/install_and_update.functions.php:150
3715
+ #: wpsc-includes/install_and_update.functions.php:151
3716
+ #: wpsc-includes/install_and_update.functions.php:158
3717
+ msgid "paypal url"
3718
+ msgstr ""
3719
+
3720
+ #: wpsc-includes/install_and_update.functions.php:207
3721
+ msgid "Products Page"
3722
+ msgstr ""
3723
+
3724
+ #: wpsc-includes/install_and_update.functions.php:225
3725
+ msgid "Transaction Results"
3726
+ msgstr ""
3727
+
3728
+ #: wpsc-includes/install_and_update.functions.php:231
3729
+ msgid "Your Account"
3730
+ msgstr ""
3731
+
3732
+ #: wpsc-includes/install_and_update.functions.php:649
3733
+ msgid "1. Your billing/contact details"
3734
+ msgstr ""
3735
+
3736
+ #: wpsc-includes/install_and_update.functions.php:655
3737
+ #: wpsc-includes/install_and_update.functions.php:664
3738
+ msgid "Postal Code"
3739
+ msgstr ""
3740
+
3741
+ #: wpsc-includes/install_and_update.functions.php:657
3742
+ msgid "2. Shipping details"
3743
+ msgstr ""
3744
+
3745
+ #: wpsc-includes/install_and_update.functions.php:662
3746
+ msgid "State"
3747
+ msgstr ""
3748
+
3749
  #: wpsc-includes/misc.functions.php:46
3750
  msgid "<strong>ERROR</strong>: Please enter a username."
3751
  msgstr ""
readme.txt CHANGED
@@ -4,7 +4,7 @@ Donate link: http://getshopped.org/
4
  Tags: e-commerce, shop, cart, dropshop, ajax, web2.0, paypal, authorize, exchange, stock control, ecommerce
5
  Requires at least: 2.7
6
  Tested up to: 2.9
7
- Stable tag: 3.7.6.3
8
 
9
  WP e-Commerce is a Web 2.0 application designed with usability, aesthetics, and presentation in mind.
10
 
@@ -36,7 +36,16 @@ If you experience database errors try de-activating and re-activating your plugi
36
 
37
 
38
  == Changelog ==
39
- =3.7.6.3 =
 
 
 
 
 
 
 
 
 
40
  * Bugfix release
41
  * Reset categoryAndShippingCountryConflist SESSION after each page load
42
  * Stock not freed up when items are removed from the cart
@@ -137,6 +146,10 @@ If you experience database errors try de-activating and re-activating your plugi
137
  * Changes to shipping to fix the bugs from 3.7.3 with shipping and the new shipping_discount feature
138
  * Fixes for variations under grid view
139
 
 
 
 
 
140
 
141
  == Frequently Asked Questions ==
142
 
4
  Tags: e-commerce, shop, cart, dropshop, ajax, web2.0, paypal, authorize, exchange, stock control, ecommerce
5
  Requires at least: 2.7
6
  Tested up to: 2.9
7
+ Stable tag: 3.7.6.4
8
 
9
  WP e-Commerce is a Web 2.0 application designed with usability, aesthetics, and presentation in mind.
10
 
36
 
37
 
38
  == Changelog ==
39
+
40
+ = 3.7.6.4 =
41
+ * Show Product Shipping and Base Shipping Costs on Packing Slip
42
+ * Fix product and category permalinks problems that occurred in v3.7.6.3. Note: any 3.7.6.3 users that have edited products and/or categories, they will need to re-edit them after upgrading.
43
+ * Fixed an issue with the currency converter
44
+ * Renamed (removed the space in the filename) and updated the POT file for translators (wpsc-en_EN.pot)
45
+ * Removed unused install_and_update file from plugin folder
46
+ * Fixed some PHP warnings / notices
47
+
48
+ = 3.7.6.3 =
49
  * Bugfix release
50
  * Reset categoryAndShippingCountryConflist SESSION after each page load
51
  * Stock not freed up when items are removed from the cart
146
  * Changes to shipping to fix the bugs from 3.7.3 with shipping and the new shipping_discount feature
147
  * Fixes for variations under grid view
148
 
149
+ == Upgrade Notice ==
150
+
151
+ = 3.7.6.4 =
152
+ Fixes product/category permalink problems introduced in v3.7.6.3. All users that upgraded to 3.7.6.3 are encouraged to upgrade as soon as possible.
153
 
154
  == Frequently Asked Questions ==
155
 
wp-shopping-cart.php CHANGED
@@ -3,7 +3,7 @@
3
  Plugin Name:WP Shopping Cart
4
  Plugin URI: http://www.getshopped.org
5
  Description: A plugin that provides a WordPress Shopping Cart. Visit the <a href='http://getshopped.org/forums'>getshopped forums</a> for support.
6
- Version: 3.7.6.3
7
  Author: Instinct
8
  Author URI: http://www.getshopped.org
9
  */
@@ -14,9 +14,9 @@ Author URI: http://www.getshopped.org
14
  // this is to make sure it sets up the table name constants correctly on activation
15
  global $wpdb;
16
  define('WPSC_VERSION', '3.7');
17
- define('WPSC_MINOR_VERSION', '53');
18
 
19
- define('WPSC_PRESENTABLE_VERSION', '3.7.6.3');
20
 
21
  define('WPSC_DEBUG', false);
22
  define('WPSC_GATEWAY_DEBUG', false);
@@ -117,7 +117,7 @@ require_once(WPSC_FILE_PATH.'/wpsc-includes/cart.class.php');
117
  require_once(WPSC_FILE_PATH.'/wpsc-includes/checkout.class.php');
118
  require_once(WPSC_FILE_PATH.'/wpsc-includes/display.functions.php');
119
  require_once(WPSC_FILE_PATH.'/wpsc-includes/pagination.class.php');
120
- require_once(WPSC_FILE_PATH.'/wpsc-includes/theme.functions.php');
121
  require_once(WPSC_FILE_PATH.'/wpsc-includes/shortcode.functions.php');
122
  require_once(WPSC_FILE_PATH.'/wpsc-includes/coupons.class.php');
123
  require_once(WPSC_FILE_PATH.'/wpsc-includes/purchaselogs.class.php');
@@ -128,8 +128,6 @@ require_once(WPSC_FILE_PATH."/wpsc-includes/merchant.class.php");
128
  require_once(WPSC_FILE_PATH."/wpsc-includes/meta.functions.php");
129
  require_once(WPSC_FILE_PATH."/wpsc-includes/productfeed.php");
130
 
131
- //Add deprecated functions in this file please
132
- require_once(WPSC_FILE_PATH."/wpsc-includes/deprecated.functions.php");
133
  //exit(print_r($v1,true));
134
  if($v1[0] >= 2.8){
135
  require_once(WPSC_FILE_PATH."/wpsc-includes/upgrades.php");
@@ -264,8 +262,10 @@ define('WPSC_CACHE_URL', $wpsc_cache_url);
264
  define('WPSC_UPGRADES_URL', $wpsc_upgrades_url);
265
 
266
  define('WPSC_THEMES_URL', $wpsc_themes_url);
 
267
 
268
-
 
269
 
270
  /*
271
  * This plugin gets the merchants from the merchants directory and
3
  Plugin Name:WP Shopping Cart
4
  Plugin URI: http://www.getshopped.org
5
  Description: A plugin that provides a WordPress Shopping Cart. Visit the <a href='http://getshopped.org/forums'>getshopped forums</a> for support.
6
+ Version: 3.7.6.4
7
  Author: Instinct
8
  Author URI: http://www.getshopped.org
9
  */
14
  // this is to make sure it sets up the table name constants correctly on activation
15
  global $wpdb;
16
  define('WPSC_VERSION', '3.7');
17
+ define('WPSC_MINOR_VERSION', '54');
18
 
19
+ define('WPSC_PRESENTABLE_VERSION', '3.7.6.4');
20
 
21
  define('WPSC_DEBUG', false);
22
  define('WPSC_GATEWAY_DEBUG', false);
117
  require_once(WPSC_FILE_PATH.'/wpsc-includes/checkout.class.php');
118
  require_once(WPSC_FILE_PATH.'/wpsc-includes/display.functions.php');
119
  require_once(WPSC_FILE_PATH.'/wpsc-includes/pagination.class.php');
120
+
121
  require_once(WPSC_FILE_PATH.'/wpsc-includes/shortcode.functions.php');
122
  require_once(WPSC_FILE_PATH.'/wpsc-includes/coupons.class.php');
123
  require_once(WPSC_FILE_PATH.'/wpsc-includes/purchaselogs.class.php');
128
  require_once(WPSC_FILE_PATH."/wpsc-includes/meta.functions.php");
129
  require_once(WPSC_FILE_PATH."/wpsc-includes/productfeed.php");
130
 
 
 
131
  //exit(print_r($v1,true));
132
  if($v1[0] >= 2.8){
133
  require_once(WPSC_FILE_PATH."/wpsc-includes/upgrades.php");
262
  define('WPSC_UPGRADES_URL', $wpsc_upgrades_url);
263
 
264
  define('WPSC_THEMES_URL', $wpsc_themes_url);
265
+ require_once(WPSC_FILE_PATH.'/wpsc-includes/theme.functions.php');
266
 
267
+ //Add deprecated functions in this file please
268
+ require_once(WPSC_FILE_PATH."/wpsc-includes/deprecated.functions.php");
269
 
270
  /*
271
  * This plugin gets the merchants from the merchants directory and
wpsc-admin/ajax-and-init.php CHANGED
@@ -1767,14 +1767,13 @@ global $wpdb, $wp_rewrite;
1767
  if($datarow['active'] == 1) {
1768
  $tidied_name = trim($datarow['name']);
1769
  $tidied_name = strtolower($tidied_name);
1770
- $url_name = apply_filters('editable_slug',$tidied_name);
1771
  $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)*$' AND `id` NOT IN ('{$datarow['id']}') ",ARRAY_A);
1772
  $extension_number = '';
1773
  if($similar_names['count'] > 0) {
1774
  $extension_number = (int)$similar_names['max_number']+2;
1775
  }
1776
  $url_name .= $extension_number;
1777
-
1778
  $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_CATEGORIES."` SET `nice-name` = '$url_name' WHERE `id` = '{$datarow['id']}' LIMIT 1 ;");
1779
  $updated;
1780
  } else if($datarow['active'] == 0) {
1767
  if($datarow['active'] == 1) {
1768
  $tidied_name = trim($datarow['name']);
1769
  $tidied_name = strtolower($tidied_name);
1770
+ $url_name = sanitize_title($tidied_name);
1771
  $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)*$' AND `id` NOT IN ('{$datarow['id']}') ",ARRAY_A);
1772
  $extension_number = '';
1773
  if($similar_names['count'] > 0) {
1774
  $extension_number = (int)$similar_names['max_number']+2;
1775
  }
1776
  $url_name .= $extension_number;
 
1777
  $wpdb->query("UPDATE `".WPSC_TABLE_PRODUCT_CATEGORIES."` SET `nice-name` = '$url_name' WHERE `id` = '{$datarow['id']}' LIMIT 1 ;");
1778
  $updated;
1779
  } else if($datarow['active'] == 0) {
wpsc-admin/display-groups.page.php CHANGED
@@ -158,7 +158,7 @@ function wpsc_display_groups_page() {
158
 
159
  //$tidied_name = sanitize_title();
160
  //$tidied_name = strtolower($tidied_name);
161
- $url_name = apply_filters('editable_slug',$_POST['name']);
162
  $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);
163
  $extension_number = '';
164
  if($similar_names['count'] > 0) {
@@ -326,9 +326,8 @@ function wpsc_display_groups_page() {
326
  /* creates and checks the tidy URL name */
327
  // $tidied_name = trim($category_name);
328
  // $tidied_name = strtolower($tidied_name);
329
- $url_name = apply_filters('editable_slug',$category_name);
330
  if($url_name != $category_data['nice-name']) {
331
- // exit('url name'.$url_name);
332
  $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);
333
  //exit("<pre>".print_r($similar_names,true)."</pre>");
334
  $extension_number = '';
158
 
159
  //$tidied_name = sanitize_title();
160
  //$tidied_name = strtolower($tidied_name);
161
+ $url_name = sanitize_title($_POST['name']);
162
  $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);
163
  $extension_number = '';
164
  if($similar_names['count'] > 0) {
326
  /* creates and checks the tidy URL name */
327
  // $tidied_name = trim($category_name);
328
  // $tidied_name = strtolower($tidied_name);
329
+ $url_name = sanitize_title($category_name);
330
  if($url_name != $category_data['nice-name']) {
 
331
  $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);
332
  //exit("<pre>".print_r($similar_names,true)."</pre>");
333
  $extension_number = '';
wpsc-admin/includes/product-functions.php CHANGED
@@ -214,9 +214,8 @@ function wpsc_insert_product($post_data, $wpsc_error = false) {
214
  $tidied_name = strtolower(trim(stripslashes($post_data['name'])));
215
  // convert " - " to "-", all other spaces to dashes, and remove all foward slashes.
216
  //$url_name = preg_replace(array("/(\s-\s)+/","/(\s)+/", "/(\/)+/"), array("-","-", ""), $tidied_name);
217
- //$url_name = sanitize_title($tidied_name);
218
- $url_name = apply_filters('editable_slug',$tidied_name);
219
-
220
  // Select all similar names, using an escaped version of the URL name
221
  $similar_names = (array)$wpdb->get_col("SELECT `meta_value` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `product_id` NOT IN('{$product_id}}') AND `meta_key` IN ('url_name') AND `meta_value` REGEXP '^(".$wpdb->escape(preg_quote($url_name))."){1}[[:digit:]]*$' ");
222
 
214
  $tidied_name = strtolower(trim(stripslashes($post_data['name'])));
215
  // convert " - " to "-", all other spaces to dashes, and remove all foward slashes.
216
  //$url_name = preg_replace(array("/(\s-\s)+/","/(\s)+/", "/(\/)+/"), array("-","-", ""), $tidied_name);
217
+ $url_name = sanitize_title($tidied_name);
218
+
 
219
  // Select all similar names, using an escaped version of the URL name
220
  $similar_names = (array)$wpdb->get_col("SELECT `meta_value` FROM `".WPSC_TABLE_PRODUCTMETA."` WHERE `product_id` NOT IN('{$product_id}}') AND `meta_key` IN ('url_name') AND `meta_value` REGEXP '^(".$wpdb->escape(preg_quote($url_name))."){1}[[:digit:]]*$' ");
221
 
wpsc-includes/ajax.functions.php CHANGED
@@ -7,6 +7,17 @@
7
  * @package wp-e-commerce
8
  * @since 3.7
9
  */
 
 
 
 
 
 
 
 
 
 
 
10
  function wpsc_special_widget(){
11
  global $wpdb;
12
 
@@ -230,7 +241,7 @@ function wpsc_empty_cart() {
230
 
231
 
232
  // execute on POST and GET
233
- if(($_REQUEST['wpsc_ajax_action'] == 'empty_cart') || ($_GET['sessionid'] > 0)) {
234
  add_action('init', 'wpsc_empty_cart');
235
  }
236
 
@@ -318,7 +329,7 @@ function wpsc_update_item_quantity() {
318
  }
319
 
320
  // execute on POST and GET
321
- if($_REQUEST['wpsc_update_quantity'] == 'true') {
322
  add_action('init', 'wpsc_update_item_quantity');
323
  }
324
 
@@ -446,7 +457,7 @@ function wpsc_get_rating_count() {
446
  exit();
447
  }
448
  // execute on POST and GET
449
- if(($_REQUEST['get_rating_count'] == 'true') && is_numeric($_POST['product_id'])) {
450
  add_action('init', 'wpsc_get_rating_count');
451
  }
452
 
@@ -470,7 +481,7 @@ function wpsc_update_product_price() {
470
  exit();
471
  }
472
  // execute on POST and GET
473
- if(($_REQUEST['update_product_price'] == 'true') && is_numeric($_POST['product_id'])) {
474
  add_action('init', 'wpsc_update_product_price');
475
  }
476
 
@@ -769,7 +780,7 @@ if($_REQUEST['wpsc_action'] == 'gateway_notification') {
769
  add_action('init', 'wpsc_gateway_notification');
770
  }
771
 
772
- if($_GET['termsandconds'] === 'true'){
773
  echo stripslashes(get_option('terms_and_conditions'));
774
  exit();
775
  }
7
  * @package wp-e-commerce
8
  * @since 3.7
9
  */
10
+ if(!isset($_REQUEST['wpsc_ajax_action'])){
11
+ $_REQUEST['wpsc_ajax_action'] = '';
12
+ }
13
+ if(!isset($_REQUEST['wpsc_ajax_actions'])){
14
+ $_REQUEST['wpsc_ajax_actions'] = '';
15
+ }
16
+
17
+ if(!isset($_REQUEST['wpsc_action'])){
18
+ $_REQUEST['wpsc_action'] = '';
19
+ }
20
+
21
  function wpsc_special_widget(){
22
  global $wpdb;
23
 
241
 
242
 
243
  // execute on POST and GET
244
+ if(($_REQUEST['wpsc_ajax_action'] == 'empty_cart') || (isset($_GET['sessionid']) && $_GET['sessionid'] > 0)) {
245
  add_action('init', 'wpsc_empty_cart');
246
  }
247
 
329
  }
330
 
331
  // execute on POST and GET
332
+ if(isset($_REQUEST['wpsc_update_quantity']) && $_REQUEST['wpsc_update_quantity'] == 'true') {
333
  add_action('init', 'wpsc_update_item_quantity');
334
  }
335
 
457
  exit();
458
  }
459
  // execute on POST and GET
460
+ if(isset($_REQUEST['get_rating_count']) && ($_REQUEST['get_rating_count'] == 'true') && is_numeric($_POST['product_id'])) {
461
  add_action('init', 'wpsc_get_rating_count');
462
  }
463
 
481
  exit();
482
  }
483
  // execute on POST and GET
484
+ if(isset($_REQUEST['update_product_price']) && ($_REQUEST['update_product_price'] == 'true') && is_numeric($_POST['product_id'])) {
485
  add_action('init', 'wpsc_update_product_price');
486
  }
487
 
780
  add_action('init', 'wpsc_gateway_notification');
781
  }
782
 
783
+ if(isset($_GET['termsandconds']) && $_GET['termsandconds'] === 'true'){
784
  echo stripslashes(get_option('terms_and_conditions'));
785
  exit();
786
  }
wpsc-includes/category.functions.php CHANGED
@@ -523,8 +523,7 @@ function wpsc_category_url($category_id, $permalink_compatibility = false) {
523
  $category_url = get_option('product_list_url');
524
  }
525
  }
526
- return $category_url;
527
- // return htmlentities($category_url, ENT_QUOTES);
528
  }
529
 
530
 
523
  $category_url = get_option('product_list_url');
524
  }
525
  }
526
+ return htmlentities($category_url, ENT_QUOTES);
 
527
  }
528
 
529
 
wpsc-includes/deprecated.functions.php CHANGED
@@ -5,7 +5,11 @@
5
  * Since 3.7.6rc2
6
  *
7
  */
 
 
 
8
  if(!wpsc_check_theme_versions()){
 
9
  include_once(WPSC_FILE_PATH.'/languages/EN_en.php');
10
  }
11
 
5
  * Since 3.7.6rc2
6
  *
7
  */
8
+
9
+ //// This language file is no longer used, but it is still included for
10
+ //// users that have old (non gettext) WPEC themes
11
  if(!wpsc_check_theme_versions()){
12
+
13
  include_once(WPSC_FILE_PATH.'/languages/EN_en.php');
14
  }
15
 
wpsc-includes/theme.functions.php CHANGED
@@ -244,7 +244,7 @@ function wpsc_user_dynamic_js() {
244
  exit();
245
  }
246
 
247
- if($_GET['wpsc_user_dynamic_js'] == 'true') {
248
  add_action("init", 'wpsc_user_dynamic_js');
249
  }
250
 
@@ -422,7 +422,7 @@ function wpsc_user_dynamic_css() {
422
  exit();
423
  }
424
 
425
- if($_GET['wpsc_user_dynamic_css'] == 'true') {
426
  add_action("init", 'wpsc_user_dynamic_css');
427
  }
428
 
244
  exit();
245
  }
246
 
247
+ if(isset($_GET['wpsc_user_dynamic_js']) && $_GET['wpsc_user_dynamic_js'] == 'true') {
248
  add_action("init", 'wpsc_user_dynamic_js');
249
  }
250
 
422
  exit();
423
  }
424
 
425
+ if(isset($_GET['wpsc_user_dynamic_css']) && $_GET['wpsc_user_dynamic_css'] == 'true') {
426
  add_action("init", 'wpsc_user_dynamic_css');
427
  }
428