Contact Form Entries – Contact Form 7, WPforms and more - Version 1.1.5

Version Description

  • fixed "float as string" mysql error.
Download this release

Release Info

Developer asif876
Plugin Icon 128x128 Contact Form Entries – Contact Form 7, WPforms and more
Version 1.1.5
Comparing to
See all releases

Code changes from version 1.1.4 to 1.1.5

contact-form-entries.php CHANGED
@@ -1,8 +1,8 @@
1
  <?php
2
  /**
3
  * Plugin Name: Contact Form Entries
4
- * Description: Save form submissions to the database from <a href="https://wordpress.org/plugins/contact-form-7/">Contact Form 7</a>, <a href="https://wordpress.org/plugins/ninja-forms/">Ninja Forms</a>, <a href="https://wordpress.org/plugins/formidable/">Formidable Forms</a>, <a href="https://elementor.com/widgets/form-widget/">Elementor Forms</a> and <a href="https://wordpress.org/plugins/wpforms-lite/">WP Forms</a>.
5
- * Version: 1.1.4
6
  * Requires at least: 3.8
7
  * Tested up to: 5.5
8
  * Author URI: https://www.crmperks.com
@@ -26,7 +26,7 @@ class vxcf_form {
26
  public static $type = "vxcf_form";
27
  public static $path = '';
28
 
29
- public static $version = '1.1.4';
30
  public static $upload_folder = 'crm_perks_uploads';
31
  public static $db_version='';
32
  public static $base_url='';
1
  <?php
2
  /**
3
  * Plugin Name: Contact Form Entries
4
+ * Description: Save form submissions to the database from <a href="https://wordpress.org/plugins/contact-form-7/">Contact Form 7</a>, <a href="https://wordpress.org/plugins/ninja-forms/">Ninja Forms</a>, <a href="https://elementor.com/widgets/form-widget/">Elementor Forms</a> and <a href="https://wordpress.org/plugins/wpforms-lite/">WP Forms</a>.
5
+ * Version: 1.1.5
6
  * Requires at least: 3.8
7
  * Tested up to: 5.5
8
  * Author URI: https://www.crmperks.com
26
  public static $type = "vxcf_form";
27
  public static $path = '';
28
 
29
+ public static $version = '1.1.5';
30
  public static $upload_folder = 'crm_perks_uploads';
31
  public static $db_version='';
32
  public static $base_url='';
includes/data.php CHANGED
@@ -165,7 +165,7 @@ public function get_lead_counts($form_id){
165
  if(is_array($form_id)){
166
  $search=" l.form_id in ('".implode("','",$form_id)."')";
167
  }else{
168
- $search=' l.form_id="'.$form_id.'"';
169
  }
170
  $res=array();
171
  $sql_all="SELECT count(distinct l.id) FROM {$leads} l where $search and l.status=0";
@@ -228,17 +228,17 @@ $main_fields=array('vxurl','vxscreen','vxbrowser','vxcreated','vxupdated');
228
  if(is_array($form_id)){
229
  $form_id_q=' l.form_id in ("'.implode('","',$form_id).'")';
230
  }else{
231
- $form_id_q=' l.form_id ="'.esc_sql($form_id).'"';
232
  }
233
  }else{
234
- $form_id_q=' l.form_id !=""';
235
  }
236
  $search=$form_id_q;
237
  $status_f=0;
238
  if($status == 'trash'){
239
  $status_f=1;
240
  }
241
- $search.=' and l.status ="'.$status_f.'"';
242
  if($status == 'unread'){
243
  $search.=' and l.is_read =0';
244
  }
165
  if(is_array($form_id)){
166
  $search=" l.form_id in ('".implode("','",$form_id)."')";
167
  }else{
168
+ $search=" l.form_id='".$form_id."'";
169
  }
170
  $res=array();
171
  $sql_all="SELECT count(distinct l.id) FROM {$leads} l where $search and l.status=0";
228
  if(is_array($form_id)){
229
  $form_id_q=' l.form_id in ("'.implode('","',$form_id).'")';
230
  }else{
231
+ $form_id_q=" l.form_id ='".esc_sql($form_id)."'";
232
  }
233
  }else{
234
+ $form_id_q=" l.form_id !=''";
235
  }
236
  $search=$form_id_q;
237
  $status_f=0;
238
  if($status == 'trash'){
239
  $status_f=1;
240
  }
241
+ $search.=' and l.status ='.$status_f.'';
242
  if($status == 'unread'){
243
  $search.=' and l.is_read =0';
244
  }
includes/plugin-pages.php CHANGED
@@ -29,10 +29,11 @@ global $pagenow;
29
  if(in_array($pagenow, array("admin-ajax.php"))){
30
  add_action('wp_ajax_actions_'.vxcf_form::$id, array($this, 'ajax_actions'));
31
  add_action('wp_ajax_print_'.vxcf_form::$id, array($this, 'print_page'));
 
32
  //update previous form's hidden fields
33
  add_filter( 'update_user_metadata',array($this,'update_hidden_cols'), 10, 5 );
34
  add_filter( 'set-screen-option', array($this,'set_per_page'), 10, 3 );
35
- }
36
  add_action( 'admin_notices', array( $this, 'admin_notices' ) );
37
  add_filter('plugin_action_links', array($this, 'plugin_action_links'), 10, 2);
38
 
@@ -694,6 +695,7 @@ vxcf_form::download_csv($form_id);
694
  if ( $option == vxcf_form::$id.'_per_page' ) {
695
  $save = (int) $value;
696
  }
 
697
  return $save;
698
  }
699
  public function screen_options(){
29
  if(in_array($pagenow, array("admin-ajax.php"))){
30
  add_action('wp_ajax_actions_'.vxcf_form::$id, array($this, 'ajax_actions'));
31
  add_action('wp_ajax_print_'.vxcf_form::$id, array($this, 'print_page'));
32
+ }
33
  //update previous form's hidden fields
34
  add_filter( 'update_user_metadata',array($this,'update_hidden_cols'), 10, 5 );
35
  add_filter( 'set-screen-option', array($this,'set_per_page'), 10, 3 );
36
+
37
  add_action( 'admin_notices', array( $this, 'admin_notices' ) );
38
  add_filter('plugin_action_links', array($this, 'plugin_action_links'), 10, 2);
39
 
695
  if ( $option == vxcf_form::$id.'_per_page' ) {
696
  $save = (int) $value;
697
  }
698
+
699
  return $save;
700
  }
701
  public function screen_options(){
readme.txt CHANGED
@@ -3,8 +3,8 @@ Contributors: crmperks, sbazzi
3
  Tags: contact form 7, contact form 7 database, contact form db, save contact form, wpforms database
4
  Requires at least: 3.8
5
  Tested up to: 5.5
6
- Stable tag: 1.1.4
7
- Version: 1.1.4
8
  Requires PHP: 5.3
9
  License: GPLv3
10
  License URI: http://www.gnu.org/licenses/gpl-3.0.html
@@ -227,6 +227,9 @@ Contact form 7 entries plugin allows you to save contact form 7 entries to local
227
 
228
  == Changelog ==
229
 
 
 
 
230
  = 1.1.4 =
231
  * fixed contact form 7 dropdown field.
232
 
3
  Tags: contact form 7, contact form 7 database, contact form db, save contact form, wpforms database
4
  Requires at least: 3.8
5
  Tested up to: 5.5
6
+ Stable tag: 1.1.5
7
+ Version: 1.1.5
8
  Requires PHP: 5.3
9
  License: GPLv3
10
  License URI: http://www.gnu.org/licenses/gpl-3.0.html
227
 
228
  == Changelog ==
229
 
230
+ = 1.1.5 =
231
+ * fixed "float as string" mysql error.
232
+
233
  = 1.1.4 =
234
  * fixed contact form 7 dropdown field.
235