wpDataTables Lite - Version 2.1.45

Version Description

  • Bugfix: Fixed errors in console after saving table
  • Compatibility with WordPress 6.1 approved. Other small bug fixes and stability improvements.
Download this release

Release Info

Developer wpDataTables
Plugin Icon 128x128 wpDataTables Lite
Version 2.1.45
Comparing to
See all releases

Code changes from version 2.1.44 to 2.1.45

Files changed (5) hide show
  1. assets/js/wpdatatables/admin/table-settings/main.js +1 -0
  2. config/config.inc.php +2 -2
  3. readme.txt +7 -2
  4. source/class.wpdatatablecache.php +9 -9
  5. wpdatatables.php +1 -1
assets/js/wpdatatables/admin/table-settings/main.js CHANGED
@@ -950,6 +950,7 @@
950
  $('#wdt-error-modal .modal-body').html( data.error );
951
  $('#wdt-error-modal').modal( 'show' );
952
  $('.wdt-preload-layer').animateFadeOut();
 
953
  }else{
954
  // Reinitialize table with returned data
955
  wpdatatable_config.initFromJSON( data.table );
950
  $('#wdt-error-modal .modal-body').html( data.error );
951
  $('#wdt-error-modal').modal( 'show' );
952
  $('.wdt-preload-layer').animateFadeOut();
953
+ return;
954
  }else{
955
  // Reinitialize table with returned data
956
  wpdatatable_config.initFromJSON( data.table );
config/config.inc.php CHANGED
@@ -9,7 +9,7 @@ defined('ABSPATH') or die("Cannot access pages directly.");
9
 
10
  // Current version
11
 
12
- define('WDT_CURRENT_VERSION', '2.1.44');
13
 
14
  // Number of active plugin installs for wpDataTables
15
  define('WDT_NUMBER_OF_ACTIVE_INSTALLS', '66,000+');
@@ -50,7 +50,7 @@ define('WDT_STORE_API_URL', 'https://store.tms-plugins.com/api/');
50
 
51
 
52
  /**
53
- * MySQL settings for query-based tables
54
  */
55
  define('WDT_ENABLE_MYSQL', true); // Whether to use MySQL in wpDataTables. Disable if you are not going to access MySQL directly from wpDataTables.
56
  if (get_option('wdtUseSeparateCon')) {
9
 
10
  // Current version
11
 
12
+ define('WDT_CURRENT_VERSION', '2.1.45');
13
 
14
  // Number of active plugin installs for wpDataTables
15
  define('WDT_NUMBER_OF_ACTIVE_INSTALLS', '66,000+');
50
 
51
 
52
  /**
53
+ * MySQL's settings for query-based tables
54
  */
55
  define('WDT_ENABLE_MYSQL', true); // Whether to use MySQL in wpDataTables. Disable if you are not going to access MySQL directly from wpDataTables.
56
  if (get_option('wdtUseSeparateCon')) {
readme.txt CHANGED
@@ -4,9 +4,9 @@ Author URI: https://tms-outsource.com
4
  Plugin URI: https://wpdatatables.com/
5
  Tags: table, table builder, data tables, tables, charts, datatables, csv, excel, json, nested json, json authentication, json API, simple table, tables from csv, tables from excel, dynamic tables, merge cells, cache, cache tables, caching, auto update, auto update tables, pricing tables, responsive tables, responsive charts, grouping data, pricing table, row grouping, chart, pie charts, mysql tables, table plugin, wp table, wordpress table plugin, wordpress tables, editing charts, google charts, chartjs, xml, php array, line chart, donut, bar chart, histogram, area chart, bubble chart, gauge chart, scatter chart, candlestick, waterfall, polar, radar
6
  Requires at least: 4.0
7
- Tested up to: 6.0.3
8
  Requires PHP: 5.6
9
- Stable tag: 2.1.44
10
  License: GPLv2 or later
11
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
12
 
@@ -369,6 +369,11 @@ This can be changed from the “Number format” drop-down menu in the wpDataTab
369
 
370
  == Changelog ==
371
 
 
 
 
 
 
372
  = 2.1.44 =
373
  * Feature: Create table from New data source type: [Nested JSON](https://wpdatatables.com/documentation/creating-wpdatatables/creating-wordpress-tables-from-nested-json-data-with-json-authentication/)
374
  * Feature: [JSON authentication](https://wpdatatables.com/documentation/creating-wpdatatables/creating-wordpress-tables-from-nested-json-data-with-json-authentication/#json-authentication)
4
  Plugin URI: https://wpdatatables.com/
5
  Tags: table, table builder, data tables, tables, charts, datatables, csv, excel, json, nested json, json authentication, json API, simple table, tables from csv, tables from excel, dynamic tables, merge cells, cache, cache tables, caching, auto update, auto update tables, pricing tables, responsive tables, responsive charts, grouping data, pricing table, row grouping, chart, pie charts, mysql tables, table plugin, wp table, wordpress table plugin, wordpress tables, editing charts, google charts, chartjs, xml, php array, line chart, donut, bar chart, histogram, area chart, bubble chart, gauge chart, scatter chart, candlestick, waterfall, polar, radar
6
  Requires at least: 4.0
7
+ Tested up to: 6.1
8
  Requires PHP: 5.6
9
+ Stable tag: 2.1.45
10
  License: GPLv2 or later
11
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
12
 
369
 
370
  == Changelog ==
371
 
372
+ = 2.1.45 =
373
+ * Bugfix: Fixed errors in console after saving table
374
+ * Compatibility with WordPress 6.1 approved.
375
+ Other small bug fixes and stability improvements.
376
+
377
  = 2.1.44 =
378
  * Feature: Create table from New data source type: [Nested JSON](https://wpdatatables.com/documentation/creating-wpdatatables/creating-wordpress-tables-from-nested-json-data-with-json-authentication/)
379
  * Feature: [JSON authentication](https://wpdatatables.com/documentation/creating-wpdatatables/creating-wordpress-tables-from-nested-json-data-with-json-authentication/#json-authentication)
source/class.wpdatatablecache.php CHANGED
@@ -44,7 +44,7 @@ class WPDataTableCache
44
  $wpdb->update(
45
  $wpdb->prefix . "wpdatatables_cache",
46
  array(
47
- 'data' => json_encode($sourceData),
48
  'updated_time' => current_time('mysql'),
49
  ),
50
  array('table_id' => $tableID)
@@ -90,11 +90,11 @@ class WPDataTableCache
90
  $wpdb->insert(
91
  $wpdb->prefix . "wpdatatables_cache",
92
  array(
93
- 'table_id' => $tableID,
94
- 'table_type' => $tableType,
95
  'table_content' => $tableContent,
96
- 'auto_update' => $autoUpdate,
97
- 'data' => json_encode($sourceData)
98
  )
99
  );
100
  if ($wpdb->last_error !== '')
@@ -187,11 +187,11 @@ class WPDataTableCache
187
  if ($tableID) {
188
  $logMessage = $logMessage . ' Table ID=' . $tableID;
189
  if ($autoUpdate) {
190
- $logError = current_time('mysql') . ' - ' . $title . ' ' . $log . '<br>';
191
  $wpdb->query(
192
  $wpdb->prepare(
193
  "UPDATE " . $wpdb->prefix . "wpdatatables_cache
194
- SET log_errors = CONCAT(log_errors, %s) WHERE table_id = %d",
195
  $logError,
196
  $tableID
197
  )
@@ -275,7 +275,7 @@ class WPDataTableCache
275
  continue;
276
  }
277
 
278
- if ($cacheTable['data'] === json_encode($result['data'])) continue;
279
 
280
  self::updateData($cacheTable['table_id'], $result['data']);
281
  }
@@ -292,7 +292,7 @@ class WPDataTableCache
292
  ];
293
  }
294
  try {
295
- if (in_array($source_type, ['xls', 'csv'])) {
296
  $tableData = WDTConfigController::loadTableFromDB($table_id);
297
  $params = array(
298
  'dateInputFormat' => array(),
44
  $wpdb->update(
45
  $wpdb->prefix . "wpdatatables_cache",
46
  array(
47
+ 'data' => json_encode($sourceData, JSON_NUMERIC_CHECK),
48
  'updated_time' => current_time('mysql'),
49
  ),
50
  array('table_id' => $tableID)
90
  $wpdb->insert(
91
  $wpdb->prefix . "wpdatatables_cache",
92
  array(
93
+ 'table_id' => $tableID,
94
+ 'table_type' => $tableType,
95
  'table_content' => $tableContent,
96
+ 'auto_update' => $autoUpdate,
97
+ 'data' => json_encode($sourceData, JSON_NUMERIC_CHECK)
98
  )
99
  );
100
  if ($wpdb->last_error !== '')
187
  if ($tableID) {
188
  $logMessage = $logMessage . ' Table ID=' . $tableID;
189
  if ($autoUpdate) {
190
+ $logError = current_time('mysql') . ' - ' . $title . ' ' . $log;
191
  $wpdb->query(
192
  $wpdb->prepare(
193
  "UPDATE " . $wpdb->prefix . "wpdatatables_cache
194
+ SET log_errors = %s WHERE table_id = %d",
195
  $logError,
196
  $tableID
197
  )
275
  continue;
276
  }
277
 
278
+ if ($cacheTable['data'] === json_encode($result['data'], JSON_NUMERIC_CHECK)) continue;
279
 
280
  self::updateData($cacheTable['table_id'], $result['data']);
281
  }
292
  ];
293
  }
294
  try {
295
+ if (in_array($source_type, ['xlsx','ods', 'xls', 'csv'])) {
296
  $tableData = WDTConfigController::loadTableFromDB($table_id);
297
  $params = array(
298
  'dateInputFormat' => array(),
wpdatatables.php CHANGED
@@ -3,7 +3,7 @@
3
  Plugin Name: wpDataTables - Tables & Table Charts
4
  Plugin URI: https://wpdatatables.com
5
  Description: Create responsive, sortable tables & charts from Excel, CSV or PHP. Add tables & charts to any post in minutes with DataTables.
6
- Version: 2.1.44
7
  Author: TMS-Plugins
8
  Author URI: https://tms-outsource.com
9
  Text Domain: wpdatatables
3
  Plugin Name: wpDataTables - Tables & Table Charts
4
  Plugin URI: https://wpdatatables.com
5
  Description: Create responsive, sortable tables & charts from Excel, CSV or PHP. Add tables & charts to any post in minutes with DataTables.
6
+ Version: 2.1.45
7
  Author: TMS-Plugins
8
  Author URI: https://tms-outsource.com
9
  Text Domain: wpdatatables