wpDataTables Lite - Version 1.2.1

Version Description

  • Compatibility with WP 4.7 approved
  • Problem with PHPExcel components resolved
Download this release

Release Info

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

Code changes from version 1.2 to 1.2.1

Files changed (3) hide show
  1. controllers/wdt_functions.php +5 -1
  2. readme.txt +151 -0
  3. wpdatatables.php +2 -2
controllers/wdt_functions.php CHANGED
@@ -315,7 +315,11 @@ function wdt_get_table_by_id( $table_id ){
315
  WHERE id={$table_id}";
316
  $data = $wpdb->get_row( $query, ARRAY_A );
317
  $data['content'] = stripslashes($data['content']);
318
- $data['title'] = stripslashes($data['title']);
 
 
 
 
319
  if( !empty( $data['tabletools_config'] ) ){
320
  $data['tabletools_config'] = unserialize( $data['tabletools_config'] );
321
  }else{
315
  WHERE id={$table_id}";
316
  $data = $wpdb->get_row( $query, ARRAY_A );
317
  $data['content'] = stripslashes($data['content']);
318
+ if( isset($data['title'] ) ) {
319
+ $data['title'] = stripslashes($data['title']);
320
+ } else {
321
+ $data['title'] = '';
322
+ }
323
  if( !empty( $data['tabletools_config'] ) ){
324
  $data['tabletools_config'] = unserialize( $data['tabletools_config'] );
325
  }else{
readme.txt ADDED
@@ -0,0 +1,151 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ === wpDataTables Lite ===
2
+ Contributors: wpDataTables
3
+ Author URI: http://tms-plugins.com/
4
+ Plugin URI: http://wpdatatables.com/
5
+ Tags: tables, wpdatatables, tables from excel, tables from CSV, datatables
6
+ Requires at least: 3.0.1
7
+ Tested up to: 4.7
8
+ Stable tag: 1.2.1
9
+ License: GPLv2 or later
10
+ License URI: http://www.gnu.org/licenses/gpl-2.0.html
11
+
12
+ This plugin allows you to create interactive sortable tables on your site based on a number of input sources - Excel, CSV, XML, JSON, PHP array.
13
+
14
+ == Description ==
15
+
16
+ wpDataTables Lite is a basic version of a well-known premium table creator plugin. While some of premium features are cut, wpDataTables is still quite a handy tool which would allow you to quickly create interactive tables from a number of sources:
17
+
18
+ * Excel - [Video tutorial](http://wpdatatables.com/video-course/creating-wpdatatables-from-existing-data-sources/creating-wpdatatables-from-excel-video/) - [Text documentation](http://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-excel/)
19
+ * CSV - [Video tutorial](http://wpdatatables.com/video-course/creating-wpdatatables-from-existing-data-sources/creating-wpdatatables-from-csv-video/) - [Text documentation](http://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-csv/)
20
+ * JSON - [Video tutorial](http://wpdatatables.com/video-course/creating-wpdatatables-from-existing-data-sources/creating-wpdatatables-from-json-input-video/) - [Text documentation](http://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-json-input/)
21
+ * XML - [Video tutorial](http://wpdatatables.com/video-course/creating-wpdatatables-from-existing-data-sources/creating-wpdatatables-from-xml/) - [Text documentation](http://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-xml/)
22
+ * Serialized PHP array - [Video tutorial](http://wpdatatables.com/video-course/creating-wpdatatables-from-existing-data-sources/creating-wpdatatables-from-serialized-php-arrays/) - [Text documentation](http://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-serialized-php-array/)
23
+
24
+ Tables are created in several very basic steps:
25
+
26
+ 1. You prepare the data source (for example the CSV file)
27
+ 2. You create a new wpDataTable in the WP-admin panel and upload your file
28
+ 3. You optionally configure the columns of the table (rename, reorder, hide, change colors)
29
+ 4. Paste the generated shortcode in your post or page (you can also use the TinyMCE button that plugin adds)
30
+
31
+ All tables will become sortable and will have pagination by default.
32
+ Additionally, each table will have a search bar, and can have "Copy to Clipboard", "Export to CSV", "Export to PDF", "Export to XLS" functions.
33
+
34
+ Following column types are supported (most column types, except the images, have its own sorting rules):
35
+
36
+ * String - [Video tutorial](http://wpdatatables.com/video-course/column-types-and-features/column-types/) - [Text documentation](http://wpdatatables.com/documentation/column-features/string-columns/)
37
+ * Integer - [Video tutorial](http://wpdatatables.com/video-course/column-types-and-features/column-types/) - [Text documentation](http://wpdatatables.com/documentation/column-features/integer-columns/)
38
+ * Float - [Video tutorial](http://wpdatatables.com/video-course/column-types-and-features/column-types/) - [Text documentation](http://wpdatatables.com/documentation/column-features/float-columns/)
39
+ * Date - [Video tutorial](http://wpdatatables.com/video-course/column-types-and-features/column-types/) - [Text documentation](http://wpdatatables.com/documentation/column-features/date-columns/)
40
+ * DateTime - [Text documentation](http://wpdatatables.com/documentation/column-features/datetime-columns/)
41
+ * Time - [Text documentation](http://wpdatatables.com/documentation/column-features/time-columns/)
42
+ * Image - [Video tutorial](http://wpdatatables.com/video-course/column-types-and-features/column-types/) - [Text documentation](http://wpdatatables.com/documentation/column-features/image-columns/)
43
+ * URL link - [Video tutorial](http://wpdatatables.com/video-course/column-types-and-features/column-types/) - [Text documentation](http://wpdatatables.com/documentation/column-features/url-link-columns/)
44
+ * E-mail link - [Video tutorial](http://wpdatatables.com/video-course/column-types-and-features/column-types/) - [Text documentation](http://wpdatatables.com/documentation/column-features/e-mail-link-columns/)
45
+
46
+ Please note some limitations of the Lite version:
47
+
48
+ 1. Plugin will allow only tables up to 150 rows.
49
+ 2. MySQL-query based tables supprt is not included.
50
+ 3. Server-side processing for large tables is not included.
51
+ 4. Responsive mode for the tables is not included.
52
+ 5. Front-end editing is not included.
53
+ 6. Excel-like editing is not included
54
+ 7. Google Charts and HighCharts are not included.
55
+ 8. Table Constructor Wizard (step-by-step table generator) is not included.
56
+ 9. Access to our premium support system is not included.
57
+
58
+ You can get all of these features by purchasing the full version on plugin's site.
59
+
60
+ Please note that plugin requires PHP 5.4 or newer!
61
+
62
+ == Installation ==
63
+
64
+ Installation of the plugin is really simple.
65
+
66
+ 1. Upload the extracted plugin folder to the `/wp-content/plugins/` directory of your WordPress installation, or upload it directly from your plugins section in the WordPress admin panel.
67
+ 2. Activate the plugin through the 'Plugins' menu in WordPress.
68
+ 3. That's it!
69
+
70
+ == Frequently Asked Questions ==
71
+
72
+ = I added a table but see no sorting, filtering or pagination =
73
+
74
+ Usually this happens when PHP version older then 5.4 is installed. Please first check this, and upgrade to PHP 5.4 - 5.6 if that's the issue.
75
+
76
+ = How to hide “Showing X of X entries” in pagination? =
77
+
78
+ The easiest way to do this is to put this CSS block somewhere in your theme’s CSS file, or in inline CSS:
79
+ div.dataTables_info { display: none !important; }
80
+
81
+ If you wish to apply this code to all of your wpDataTables tables, you can put it in “Custom wpDataTables CSS” text area on wpDataTables Settings page,
82
+ or if you wish to apply it only on specific pages, you can put it in between style tags in for example html editor bellow tables short codes. E.g.
83
+
84
+ <style>
85
+ div.dataTables_info { display: none !important; }
86
+ </style>
87
+
88
+ = How to disable opening links in a popup? =
89
+
90
+ File that is responsible for rendering link columns is /source/class.link.wpdatacolumn.php
91
+ By opening that file you can see code for creating html anchor element with attribute “target=’_blank'”.
92
+ By changing ‘_blank’ value to ‘_self’ will cause link to open in same page instead of new window.
93
+
94
+ = How to hide “Show X entries” block from pagination? =
95
+
96
+ The easiest way to do this is to put this CSS block somewhere in your theme’s CSS file, or in inline CSS:
97
+ div.dataTables_length { display: none !important; }
98
+
99
+ If you wish to apply this code to all of your wpDataTables tables, you can put it in “Custom wpDataTables CSS” text area on wpDataTables Settings page,
100
+ or if you wish to apply it only on specific pages, you can put it in between style tags in for example html editor bellow tables short codes. E.g.
101
+
102
+ <style>
103
+ div.dataTables_length { display: none !important; }
104
+ </style>
105
+
106
+ = Adding text before/after column values without affecting sorting =
107
+
108
+ In wpDataTables table edit page in section ” Optional column setup”, for every table column there are text fields “Display text before” and “Display text after”.
109
+ Values from those text fields will be used for adding text before or/and after every cell content in a column.
110
+ This feature uses css for displaying entered text, therefore sorting of the columns will not be affected.
111
+
112
+ = How to change display date format of a date column? =
113
+
114
+ Display date format of a date column can be changed in wpDataTables Settings page from “Date format” drop-down menu.
115
+
116
+ = How to change thousand and decimal separators for number columns? =
117
+
118
+ This can be changed from “Number format” drop-down menu in the wpDataTables Settings page.
119
+
120
+ == Screenshots ==
121
+
122
+ 1. Front-end table preview.
123
+ 2. Back-end table editor preview.
124
+ 3. Table preview from the back-end
125
+ 4. Table browser example
126
+
127
+ == Changelog ==
128
+
129
+ = 1.2.1 =
130
+ * Compatibility with WP 4.7 approved
131
+ * Problem with PHPExcel components resolved
132
+
133
+ = 1.2 =
134
+ * DateTime column type added
135
+ * Time column type added
136
+ * Extended multisite support
137
+ * Improved Settings page
138
+ * Compatibility with WP 4.6.1 approved
139
+ * Numerous bugfixes
140
+
141
+ = 1.1 =
142
+ * Migrated Table Tools to use HTML5 instead of Adobe Flash
143
+ * Advanced settings for configuring Table Tools (individually per button)
144
+ * Wide tables can be configured to be horizontally scrollable
145
+ * Upgraded used libraries
146
+ * Compatibility with WP 4.5.2 approved
147
+ * Numerous bugfixes
148
+
149
+ = 1.0 =
150
+ * Launch of the Lite version
151
+
wpdatatables.php CHANGED
@@ -1,14 +1,14 @@
1
  <?php
2
  /**
3
  * @package wpDataTables
4
- * @version 1.7
5
  */
6
  /*
7
  Plugin Name: wpDataTables
8
  Plugin URI: http://tms-plugins.com
9
  Description: Add interactive tables easily from any input source
10
 
11
- Version: Lite 1.2
12
  Author: TMS-Plugins
13
  Author URI: http://tms-plugins.com
14
  Text Domain: wpdatatables
1
  <?php
2
  /**
3
  * @package wpDataTables
4
+ * @version lite
5
  */
6
  /*
7
  Plugin Name: wpDataTables
8
  Plugin URI: http://tms-plugins.com
9
  Description: Add interactive tables easily from any input source
10
 
11
+ Version: Lite 1.2.1
12
  Author: TMS-Plugins
13
  Author URI: http://tms-plugins.com
14
  Text Domain: wpdatatables