Version Description
- fixed "float as string" mysql error.
Download this release
Release Info
Developer | asif876 |
Plugin | 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 +3 -3
- includes/data.php +4 -4
- includes/plugin-pages.php +3 -1
- readme.txt +5 -2
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://
|
5 |
-
* Version: 1.1.
|
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.
|
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=
|
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=
|
232 |
}
|
233 |
}else{
|
234 |
-
$form_id_q=
|
235 |
}
|
236 |
$search=$form_id_q;
|
237 |
$status_f=0;
|
238 |
if($status == 'trash'){
|
239 |
$status_f=1;
|
240 |
}
|
241 |
-
$search.=' and l.status =
|
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.
|
7 |
-
Version: 1.1.
|
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 |
|