Export WordPress data to XML/CSV - Version 1.3.5

Version Description

  • security improvements
  • improvement: update autoloader to support paths containing underscores
Download this release

Release Info

Developer soflyy
Plugin Icon 128x128 Export WordPress data to XML/CSV
Version 1.3.5
Comparing to
See all releases

Code changes from version 1.3.4 to 1.3.5

Files changed (4) hide show
  1. helpers/pmxe_functions.php +8 -1
  2. readme.txt +5 -2
  3. src/App/Service/VariationOptions/VariationOptions.php +1 -1
  4. wp-all-export.php +8 -6
helpers/pmxe_functions.php CHANGED
@@ -60,7 +60,14 @@
60
 
61
  global $wpdb;
62
  $table_prefix = $wpdb->prefix;
63
- $meta_keys = $wpdb->get_results("SELECT DISTINCT {$table_prefix}postmeta.meta_key FROM {$table_prefix}postmeta, {$table_prefix}posts WHERE {$table_prefix}postmeta.post_id = {$table_prefix}posts.ID AND {$table_prefix}posts.post_type IN ('" . implode('\',\'', $post_type) . "') AND {$table_prefix}postmeta.meta_key NOT LIKE '_edit%' AND {$table_prefix}postmeta.meta_key NOT LIKE '_oembed_%' LIMIT 1000");
 
 
 
 
 
 
 
64
 
65
  $_existing_meta_keys = array();
66
  if ( ! empty($meta_keys)){
60
 
61
  global $wpdb;
62
  $table_prefix = $wpdb->prefix;
63
+
64
+ $post_type = array_map(function($item) use ($wpdb) {
65
+ return $wpdb->prepare('%s', $item);
66
+ }, $post_type);
67
+
68
+ $post_type_in = implode(',', $post_type);
69
+
70
+ $meta_keys = $wpdb->get_results($wpdb->prepare("SELECT DISTINCT {$table_prefix}postmeta.meta_key FROM {$table_prefix}postmeta, {$table_prefix}posts WHERE {$table_prefix}postmeta.post_id = {$table_prefix}posts.ID AND {$table_prefix}posts.post_type IN ({$post_type_in}) AND {$table_prefix}postmeta.meta_key NOT LIKE '_edit%' AND {$table_prefix}postmeta.meta_key NOT LIKE '_oembed_%' LIMIT 1000"));
71
 
72
  $_existing_meta_keys = array();
73
  if ( ! empty($meta_keys)){
readme.txt CHANGED
@@ -1,8 +1,8 @@
1
  === Export any WordPress data to XML/CSV ===
2
  Contributors: soflyy, wpallimport
3
  Requires at least: 5.0
4
- Tested up to: 5.9.2
5
- Stable tag: 1.3.4
6
  Tags: export, wordpress csv export, wordpress xml export, export woocommerce, migrate, export csv from wordpress, export xml from wordpress, advanced xml export, advanced csv export, export data, bulk csv export, export custom post type, export woocommerce products, export woocommerce orders, migrate woocommerce, csv export, export csv, xml export, export xml, csv exporter, datafeed
7
 
8
  Easily export any data from WordPress. Drag & drop to create a completely custom spreadsheet, CSV, or XML file.
@@ -91,6 +91,9 @@ Either: -
91
 
92
  == Changelog ==
93
 
 
 
 
94
 
95
  = 1.3.4 =
96
  * improvement: UI updates
1
  === Export any WordPress data to XML/CSV ===
2
  Contributors: soflyy, wpallimport
3
  Requires at least: 5.0
4
+ Tested up to: 6.0
5
+ Stable tag: 1.3.5
6
  Tags: export, wordpress csv export, wordpress xml export, export woocommerce, migrate, export csv from wordpress, export xml from wordpress, advanced xml export, advanced csv export, export data, bulk csv export, export custom post type, export woocommerce products, export woocommerce orders, migrate woocommerce, csv export, export csv, xml export, export xml, csv exporter, datafeed
7
 
8
  Easily export any data from WordPress. Drag & drop to create a completely custom spreadsheet, CSV, or XML file.
91
 
92
  == Changelog ==
93
 
94
+ = 1.3.5 =
95
+ * security improvements
96
+ * improvement: update autoloader to support paths containing underscores
97
 
98
  = 1.3.4 =
99
  * improvement: UI updates
src/App/Service/VariationOptions/VariationOptions.php CHANGED
@@ -31,7 +31,7 @@ class VariationOptions implements VariationOptionsInterface
31
  $langQuery = '';
32
 
33
  if($this->isLanguageFilterEnabled()) {
34
- $langQuery .= " AND t.language_code = '".\XmlExportEngine::$exportOptions['wpml_lang']."' ";
35
  }
36
 
37
  if($closeBracket) {
31
  $langQuery = '';
32
 
33
  if($this->isLanguageFilterEnabled()) {
34
+ $langQuery .= $wpdb->prepare(" AND t.language_code = %s ", \XmlExportEngine::$exportOptions['wpml_lang']);
35
  }
36
 
37
  if($closeBracket) {
wp-all-export.php CHANGED
@@ -3,7 +3,7 @@
3
  Plugin Name: WP All Export
4
  Plugin URI: http://www.wpallimport.com/upgrade-to-wp-all-export-pro/?utm_source=export-plugin-free&utm_medium=wp-plugins-page&utm_campaign=upgrade-to-pro
5
  Description: Export any post type to a CSV or XML file. Edit the exported data, and then re-import it later using WP All Import.
6
- Version: 1.3.4
7
  Author: Soflyy
8
  */
9
 
@@ -59,7 +59,7 @@ else {
59
  */
60
  define('PMXE_PREFIX', 'pmxe_');
61
 
62
- define('PMXE_VERSION', '1.3.4');
63
 
64
  define('PMXE_ASSETS_VERSION', '-1.0.2');
65
 
@@ -618,11 +618,13 @@ else {
618
  require_once $path;
619
  return TRUE;
620
  }
621
- if ( ! $is_prefix) {
622
- $pathAlt = self::ROOT_DIR . '/' . $subdir . '/' . $filePathAlt;
623
- if(strpos($className, '_') !== false) {
624
- $pathAlt = $this->lreplace('_',DIRECTORY_SEPARATOR, $pathAlt);
625
  }
 
 
 
626
  if (is_file($pathAlt)) {
627
  require_once $pathAlt;
628
  return TRUE;
3
  Plugin Name: WP All Export
4
  Plugin URI: http://www.wpallimport.com/upgrade-to-wp-all-export-pro/?utm_source=export-plugin-free&utm_medium=wp-plugins-page&utm_campaign=upgrade-to-pro
5
  Description: Export any post type to a CSV or XML file. Edit the exported data, and then re-import it later using WP All Import.
6
+ Version: 1.3.5
7
  Author: Soflyy
8
  */
9
 
59
  */
60
  define('PMXE_PREFIX', 'pmxe_');
61
 
62
+ define('PMXE_VERSION', '1.3.5');
63
 
64
  define('PMXE_ASSETS_VERSION', '-1.0.2');
65
 
618
  require_once $path;
619
  return TRUE;
620
  }
621
+ if (!$is_prefix) {
622
+ if (strpos($className, '_') !== false) {
623
+ $filePathAlt = $this->lreplace('_', DIRECTORY_SEPARATOR, $filePathAlt);
 
624
  }
625
+
626
+ $pathAlt = self::ROOT_DIR . DIRECTORY_SEPARATOR . $subdir . DIRECTORY_SEPARATOR . $filePathAlt;
627
+
628
  if (is_file($pathAlt)) {
629
  require_once $pathAlt;
630
  return TRUE;