Advanced Contact form 7 DB - Version 1.6.1

Version Description

  • We have upgraded with Security patched for shortcode.
Download this release

Release Info

Developer vsourz1td
Plugin Icon 128x128 Advanced Contact form 7 DB
Version 1.6.1
Comparing to
See all releases

Code changes from version 1.6.0 to 1.6.1

Files changed (3) hide show
  1. README.txt +6 -3
  2. advanced-cf7-db.php +2 -2
  3. public/partials/vsz_acf7_db_shortcode_display_front.php +7 -7
README.txt CHANGED
@@ -2,8 +2,8 @@
2
  Contributors: vsourz1td
3
  Tags: contact form 7 db, advanced cf7 db, contact form 7 database, contact form db, contact form 7, save form data, save contact form, save cf7, database, cf7db, save-contact-form, Save-Forms-Data, import-cf7, export-contact-data, view-cf7-entry
4
  Requires at least: 4.0
5
- Tested up to: 5.0
6
- Stable tag: 1.6.0
7
  License: GPLv2 or later
8
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
9
 
@@ -169,8 +169,11 @@ function vsz_restrict_form_data_submission($contact_form_ids){
169
 
170
  == Changelog ==
171
 
 
 
 
172
  = 1.6.0 =
173
- * We have upgraded with Security patched to securing user's uploaded data which managed on advanced-cf7-upload directory.
174
 
175
  = 1.5.1 =
176
  * Minor bug fixing related to variable mismatch for wordpress 5.0.1.
2
  Contributors: vsourz1td
3
  Tags: contact form 7 db, advanced cf7 db, contact form 7 database, contact form db, contact form 7, save form data, save contact form, save cf7, database, cf7db, save-contact-form, Save-Forms-Data, import-cf7, export-contact-data, view-cf7-entry
4
  Requires at least: 4.0
5
+ Tested up to: 5.1.1
6
+ Stable tag: 1.6.1
7
  License: GPLv2 or later
8
  License URI: http://www.gnu.org/licenses/gpl-2.0.html
9
 
169
 
170
  == Changelog ==
171
 
172
+ = 1.6.1 =
173
+ * We have upgraded with Security patched for shortcode.
174
+
175
  = 1.6.0 =
176
+ * We have upgraded with Security patched to securing user's uploaded data which managed on advanced-cf7-upload directory..
177
 
178
  = 1.5.1 =
179
  * Minor bug fixing related to variable mismatch for wordpress 5.0.1.
advanced-cf7-db.php CHANGED
@@ -9,7 +9,7 @@
9
  * Plugin Name: Advanced CF7 DB
10
  * Plugin URI: https://wordpress.org/plugins/advanced-cf7-db/
11
  * Description: Save all contact form 7 submitted data to the database, View, Export, ordering, Change field labels, Import data using CSV very easily.
12
- * Version: 1.6.0
13
  * Author: Vsourz Digital
14
  * Author URI: https://www.vsourz.com
15
  * License: GPL-2.0+
@@ -23,7 +23,7 @@ if ( ! defined( 'WPINC' ) ) {
23
  die;
24
  }
25
  global $vsz_cf7db_current_version;
26
- $vsz_cf7db_current_version = '1.6.0';
27
  /**
28
  * Defining all the table names and setting their prefix here
29
  */
9
  * Plugin Name: Advanced CF7 DB
10
  * Plugin URI: https://wordpress.org/plugins/advanced-cf7-db/
11
  * Description: Save all contact form 7 submitted data to the database, View, Export, ordering, Change field labels, Import data using CSV very easily.
12
+ * Version: 1.6.1
13
  * Author: Vsourz Digital
14
  * Author URI: https://www.vsourz.com
15
  * License: GPL-2.0+
23
  die;
24
  }
25
  global $vsz_cf7db_current_version;
26
+ $vsz_cf7db_current_version = '1.6.1';
27
  /**
28
  * Defining all the table names and setting their prefix here
29
  */
public/partials/vsz_acf7_db_shortcode_display_front.php CHANGED
@@ -30,7 +30,8 @@ $search = addslashes(addslashes(sanitize_text_field($search)));
30
  $formArr = explode(",", $formIds);
31
 
32
  foreach($formArr as $key=>$val){
33
- if(empty(trim($val))) unset($formArr[$key]);
 
34
  }
35
 
36
  //Get all existing contact form list
@@ -182,6 +183,9 @@ if(!empty($formArr)){
182
  }
183
  }
184
 
 
 
 
185
  $query = "SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = ".$fid." AND data_id IN(
186
  SELECT * FROM (
187
  SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid. ((!empty($search)) ? " AND `value` LIKE '%%".$search."%%'" : "") . ((!empty($search_date_query)) ? $search_date_query : "") ."
@@ -220,8 +224,7 @@ if(!empty($formArr)){
220
  $html .= !empty($headerForForm) ? '<h2>'.esc_html($headerForForm).'</h2>' : '<h2>'.esc_html($form->title()).'</h2>';
221
  $html .= '<table id="'.$table_id.'" class="'.$table_class.'" style="overflow: auto; '.$table_style.'">
222
  <thead>
223
- <tr>
224
- <td></td>';
225
 
226
  //Define table header section here
227
  foreach ($fields as $k => $v){
@@ -234,10 +237,7 @@ if(!empty($formArr)){
234
 
235
  foreach ($data_sorted as $k => $v) {
236
  $k = (int)$k;
237
- $html .= '<tr>
238
- <th class="check-column" scope="row">
239
- <input id="cb-select-'.$k.'" type="checkbox" title="Check" name="del_id[]" value="'.$k.'" />
240
- </th>';
241
  foreach ($fields as $k2 => $v2) {
242
  //Get fields related values
243
  $_value = ((isset($v[$k2])) ? $v[$k2] : '&nbsp;');
30
  $formArr = explode(",", $formIds);
31
 
32
  foreach($formArr as $key=>$val){
33
+ $val = (int) trim($val);
34
+ if(empty($val)) unset($formArr[$key]);
35
  }
36
 
37
  //Get all existing contact form list
183
  }
184
  }
185
 
186
+ // Make sure that $fid will contain integer value only.
187
+ $fid = (int) $fid;
188
+
189
  $query = "SELECT * FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE `cf7_id` = ".$fid." AND data_id IN(
190
  SELECT * FROM (
191
  SELECT data_id FROM `".VSZ_CF7_DATA_ENTRY_TABLE_NAME."` WHERE 1 = 1 AND `cf7_id` = ".$fid. ((!empty($search)) ? " AND `value` LIKE '%%".$search."%%'" : "") . ((!empty($search_date_query)) ? $search_date_query : "") ."
224
  $html .= !empty($headerForForm) ? '<h2>'.esc_html($headerForForm).'</h2>' : '<h2>'.esc_html($form->title()).'</h2>';
225
  $html .= '<table id="'.$table_id.'" class="'.$table_class.'" style="overflow: auto; '.$table_style.'">
226
  <thead>
227
+ <tr>';
 
228
 
229
  //Define table header section here
230
  foreach ($fields as $k => $v){
237
 
238
  foreach ($data_sorted as $k => $v) {
239
  $k = (int)$k;
240
+ $html .= '<tr>';
 
 
 
241
  foreach ($fields as $k2 => $v2) {
242
  //Get fields related values
243
  $_value = ((isset($v[$k2])) ? $v[$k2] : '&nbsp;');