Product Feed PRO for WooCommerce - Version 11.4.9

Version Description

Changed the wpdb::prepare query string

Download this release

Release Info

Developer jorisverwater
Plugin Icon 128x128 Product Feed PRO for WooCommerce
Version 11.4.9
Comparing to
See all releases

Code changes from version 11.4.8 to 11.4.9

Files changed (4) hide show
  1. classes/class-attributes.php +21 -6
  2. js/woosea_key.js +1 -1
  3. readme.txt +7 -1
  4. woocommerce-sea.php +2 -2
classes/class-attributes.php CHANGED
@@ -106,12 +106,27 @@ private function get_custom_attributes() {
106
  $value_display = str_replace("_", " ",$value);
107
  $list["custom_attributes_" . $value] = ucfirst($value_display);
108
  } else {
109
- $sql = "SELECT
110
- meta.meta_id,
111
- meta.meta_value as type
112
- FROM " . $wpdb->prefix . "postmeta" . " AS meta, " . $wpdb->prefix . "posts" . " AS posts
113
- WHERE meta.post_id = posts.id AND posts.post_type LIKE '%product%' AND meta.meta_key='_product_attributes' AND meta.meta_value NOT LIKE \"%{}\";";
114
- $data = $wpdb->get_results($sql);
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
115
  if (count($data)) {
116
  foreach ($data as $key => $value) {
117
  $product_attr = unserialize($value->type);
106
  $value_display = str_replace("_", " ",$value);
107
  $list["custom_attributes_" . $value] = ucfirst($value_display);
108
  } else {
109
+ $data = @$wpdb->get_results(
110
+ // $wpdb->prepare("
111
+ // SELECT
112
+ // meta.meta_id,
113
+ // meta.meta_value AS type
114
+ // FROM {$wpdb->prefix}postmeta AS meta,
115
+ // {$wpdb->prefix}posts AS posts
116
+ // WHERE meta.post_id = posts.id
117
+ // AND posts.post_type LIKE '%product%'
118
+ // AND meta.meta_key='_product_attributes' AND meta.meta_value NOT LIKE \"%{}\";")
119
+
120
+ $wpdb->prepare("
121
+ SELECT
122
+ meta.meta_id,
123
+ meta.meta_value AS type
124
+ FROM {$wpdb->prefix}postmeta AS meta,
125
+ {$wpdb->prefix}posts AS posts
126
+ WHERE meta.post_id = posts.id
127
+ AND posts.post_type LIKE '%s'
128
+ AND meta.meta_key='_product_attributes' AND meta.meta_value NOT LIKE \"%{}\"", array( '%product%' ))
129
+ );
130
  if (count($data)) {
131
  foreach ($data as $key => $value) {
132
  $product_attr = unserialize($value->type);
js/woosea_key.js CHANGED
@@ -26,7 +26,7 @@ jQuery(document).ready(function($) {
26
  var license_key = $('#license-key').val();
27
 
28
  jQuery.ajax({
29
- url: 'https://www.adtribes.io/check/license.php?key=' + license_key + '&email=' + license_email + '&domain=' + root_domain + '&version=11.4.8',
30
  jsonp: 'callback',
31
  dataType: 'jsonp',
32
  type: 'GET',
26
  var license_key = $('#license-key').val();
27
 
28
  jQuery.ajax({
29
+ url: 'https://www.adtribes.io/check/license.php?key=' + license_key + '&email=' + license_email + '&domain=' + root_domain + '&version=11.4.9',
30
  jsonp: 'callback',
31
  dataType: 'jsonp',
32
  type: 'GET',
readme.txt CHANGED
@@ -5,7 +5,7 @@ License URI: http://www.gnu.org/licenses/gpl.html
5
  Tags: Google Shopping Feed, WooCommerce Product Feed, Facebook Product Feed, Bing Shopping Feed, Bing Product Feed, Google Merchant Feed, Skroutz, Google Product Feed, Pinterest, Idealo, Facebook Pixel, Facebook Conversion API
6
  Requires at least: 4.5
7
  Tested up to: 5.9
8
- Stable tag: 11.4.8
9
 
10
  == Description ==
11
 
@@ -342,6 +342,9 @@ Questions left or unanswered? Please do not hesitate to contact us at support@ad
342
 
343
  === Changelog ===
344
 
 
 
 
345
  = 11.4.8 (2022-03-29) =
346
  * Implemented a rounding feature for WooCommerce bundled products
347
 
@@ -3673,6 +3676,9 @@ Questions left or unanswered? Please do not hesitate to contact us at support@ad
3673
 
3674
  == Upgrade Notice ==
3675
 
 
 
 
3676
  = 11.4.8 =
3677
  Implemented a rounding feature for WooCommerce bundled products
3678
 
5
  Tags: Google Shopping Feed, WooCommerce Product Feed, Facebook Product Feed, Bing Shopping Feed, Bing Product Feed, Google Merchant Feed, Skroutz, Google Product Feed, Pinterest, Idealo, Facebook Pixel, Facebook Conversion API
6
  Requires at least: 4.5
7
  Tested up to: 5.9
8
+ Stable tag: 11.4.9
9
 
10
  == Description ==
11
 
342
 
343
  === Changelog ===
344
 
345
+ = 11.4.9 (2022-03-30) =
346
+ * Changed the wpdb::prepare query string
347
+
348
  = 11.4.8 (2022-03-29) =
349
  * Implemented a rounding feature for WooCommerce bundled products
350
 
3676
 
3677
  == Upgrade Notice ==
3678
 
3679
+ = 11.4.9 =
3680
+ Changed the wpdb::prepare query string
3681
+
3682
  = 11.4.8 =
3683
  Implemented a rounding feature for WooCommerce bundled products
3684
 
woocommerce-sea.php CHANGED
@@ -1,7 +1,7 @@
1
  <?php
2
  /**
3
  * Plugin Name: Product Feed PRO for WooCommerce
4
- * Version: 11.4.8
5
  * Plugin URI: https://www.adtribes.io/support/?utm_source=wpadmin&utm_medium=plugin&utm_campaign=woosea_product_feed_pro
6
  * Description: Configure and maintain your WooCommerce product feeds for Google Shopping, Facebook, Remarketing, Bing, Skroutz, Yandex, Comparison shopping websites and over a 100 channels more.
7
  * Author: AdTribes.io
@@ -48,7 +48,7 @@ if (!defined('ABSPATH')) {
48
  * Plugin versionnumber, please do not override.
49
  * Define some constants
50
  */
51
- define( 'WOOCOMMERCESEA_PLUGIN_VERSION', '11.4.8' );
52
  define( 'WOOCOMMERCESEA_PLUGIN_NAME', 'woocommerce-product-feed-pro' );
53
  define( 'WOOCOMMERCESEA_PLUGIN_NAME_SHORT', 'woo-product-feed-pro' );
54
 
1
  <?php
2
  /**
3
  * Plugin Name: Product Feed PRO for WooCommerce
4
+ * Version: 11.4.9
5
  * Plugin URI: https://www.adtribes.io/support/?utm_source=wpadmin&utm_medium=plugin&utm_campaign=woosea_product_feed_pro
6
  * Description: Configure and maintain your WooCommerce product feeds for Google Shopping, Facebook, Remarketing, Bing, Skroutz, Yandex, Comparison shopping websites and over a 100 channels more.
7
  * Author: AdTribes.io
48
  * Plugin versionnumber, please do not override.
49
  * Define some constants
50
  */
51
+ define( 'WOOCOMMERCESEA_PLUGIN_VERSION', '11.4.9' );
52
  define( 'WOOCOMMERCESEA_PLUGIN_NAME', 'woocommerce-product-feed-pro' );
53
  define( 'WOOCOMMERCESEA_PLUGIN_NAME_SHORT', 'woo-product-feed-pro' );
54