Changeset 2324103
- Timestamp:
- 06/15/2020 03:36:41 AM (6 years ago)
- Location:
- codistoconnect/trunk
- Files:
-
- 3 edited
-
changelog.txt (modified) (1 diff)
-
connect.php (modified) (5 diffs)
-
readme.txt (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
codistoconnect/trunk/changelog.txt
r2322799 r2324103 1 1 *** WooCommerce Amazon and eBay Integration *** 2 3 2020-06-15 - version 1.3.50 4 * Update - improve shipping tracking sync performance 2 5 3 6 2020-06-12 - version 1.3.49 -
codistoconnect/trunk/connect.php
r2324075 r2324103 4 4 * Plugin URI: http://wordpress.org/plugins/codistoconnect/ 5 5 * Description: WooCommerce Amazon & eBay Integration - Convert a WooCommerce store into a fully integrated Amazon & eBay store in minutes 6 * Author: Codisto 6 * Author: Codisto 7 7 * Author URI: https://codisto.com/ 8 * Version: 1.3. 498 * Version: 1.3.50 9 9 * Text Domain: codisto-linq 10 10 * Woo: 3545890:ba4772797f6c2c68c5b8e0b1c7f0c4e2 … … 15 15 * 16 16 * @package Codisto LINQ by Codisto 17 * @version 1.3. 4917 * @version 1.3.50 18 18 */ 19 19 … … 22 22 } 23 23 24 define( 'CODISTOCONNECT_VERSION', '1.3. 49' );24 define( 'CODISTOCONNECT_VERSION', '1.3.50' ); 25 25 define( 'CODISTOCONNECT_RESELLERKEY', '' ); 26 26 … … 940 940 ")". 941 941 ") AS id, ". 942 " ID AS post_id, post_status AS status FROM `{$wpdbsiteprefix}posts` AS P WHERE post_type = 'shop_order' AND ID IN (". 942 " ID AS post_id, post_status AS status FROM `{$wpdbsiteprefix}posts` AS P". 943 " WHERE post_type = 'shop_order'". 944 " AND post_date > DATE_SUB( CURRENT_TIMESTAMP(), INTERVAL 90 DAY )". 945 " AND ID IN (". 943 946 "SELECT post_id FROM `{$wpdbsiteprefix}postmeta` WHERE meta_key = '_codisto_orderid' AND (". 944 947 "EXISTS ( SELECT 1 FROM `{$wpdbsiteprefix}postmeta` WHERE meta_key = '_codisto_merchantid' AND meta_value = %d AND post_id = P.id ) ". … … 956 959 $total_count = $wpdb->get_var( 957 960 $wpdb->prepare( 958 "SELECT COUNT(*) FROM `{$wpdbsiteprefix}posts` AS P WHERE post_type = 'shop_order' AND ID IN ( SELECT post_id FROM `{$wpdbsiteprefix}postmeta` WHERE meta_key = '_codisto_orderid' AND ( EXISTS ( SELECT 1 FROM `{$wpdbsiteprefix}postmeta` WHERE meta_key = '_codisto_merchantid' AND meta_value = %d AND post_id = P.id ) OR NOT EXISTS (SELECT 1 FROM `{$wpdbsiteprefix}postmeta` WHERE meta_key = '_codisto_merchantid' AND post_id = P.id )))",961 "SELECT COUNT(*) FROM `{$wpdbsiteprefix}posts` AS P WHERE post_type = 'shop_order' AND post_date > DATE_SUB( CURRENT_TIMESTAMP(), INTERVAL 90 DAY ) AND ID IN ( SELECT post_id FROM `{$wpdbsiteprefix}postmeta` WHERE meta_key = '_codisto_orderid' AND ( EXISTS ( SELECT 1 FROM `{$wpdbsiteprefix}postmeta` WHERE meta_key = '_codisto_merchantid' AND meta_value = %d AND post_id = P.id ) OR NOT EXISTS (SELECT 1 FROM `{$wpdbsiteprefix}postmeta` WHERE meta_key = '_codisto_merchantid' AND post_id = P.id )))", 959 962 $merchantid 960 963 ) -
codistoconnect/trunk/readme.txt
r2322799 r2324103 97 97 == Changelog == 98 98 99 = 1.3.50 - 15/06/2020 = 100 * Update - improve shipping tracking sync performance 101 99 102 = 1.3.49 - 12/06/2020 = 100 103 * Update - menu support for new home page
Note: See TracChangeset
for help on using the changeset viewer.