WordPress.org
Get WordPress

Plugin Directory

Changeset 3210848


Ignore:
Timestamp:
12/20/2024 05:51:08 AM (16 months ago)
Author:
zohocrm
Message:

Bug Boundry issue has been fixed

Location:
zoho-crm-forms/trunk
Files:
5 edited

Legend:

Unmodified
Added
Removed

  • zoho-crm-forms/trunk/Readme.txt

    r3209626 r3210848  
    77Author: Zoho CRM
    88Tested up to: 6.7
    9 Stable tag: 1.8.0.5
     9Stable tag: 1.8.0.6
    1010License: GPLv2 or later
    11 Version: 1.8.0.5
     11Version: 1.8.0.6
    1212License URI: http://www.gnu.org/licenses/gpl-2.0.html
    1313
    … …  
    3173171.8.0.5
    318318Bug Boundry issue has been fixed
     3191.8.0.6
     320Bug Boundry issue has been fixed
    319321
    320322== Upgrade notice ==

  • zoho-crm-forms/trunk/includes/crmapiintergration.php

    r2735360 r3210848  
    4949                        ) ENGINE=InnoDB  DEFAULT CHARSET=utf8
    5050               ");
    51                $delete_moduleList = $wpdb->query("delete from zcf_zohocrm_moduleLists where modulename = '$module'");
    52               foreach($result_array['layouts'] as $value_array){
     51        $delete_moduleList = $wpdb->query($wpdb->prepare("DELETE FROM zcf_zohocrm_moduleLists WHERE modulename = %s",
     52        $module));             
     53        foreach($result_array['layouts'] as $value_array){
    5354                $layoutname = $value_array['name'];
    5455                $layoutId   = $value_array['id'];

  • zoho-crm-forms/trunk/includes/crmshortcodefunctions.php

    r3209626 r3210848  
    114114    function zcfformFields($options, $onAction, $editShortCodes, $formtype = "post", $module, $layoutname) {
    115115        global $wpdb;
    116         $fieldsquery = "
    117                 SELECT *
    118                 FROM zcf_zohocrmform_field_manager
    119                 WHERE module_type = %s
    120                 AND Layout_Name = %s
    121             ";
     116        $fieldsquery = "SELECT * FROM zcf_zohocrmform_field_manager WHERE module_type = %s AND Layout_Name = %s";
    122117        $fields = $wpdb->get_results($wpdb->prepare($fieldsquery, $module, $layoutname) );
    123118
    … …  
    437432        $shortcode_id = $enable_showfields[0]->shortcode_id;
    438433        $field_id = $enable_showfields[0]->field_id;
    439         $enable_crmfields = $wpdb->query("update zcf_zohocrm_formfield_manager set zcf_field_mandatory = '1' ,hiddenfield = '0',editupdate = '0' where rel_id ='$rel_id' and shortcode_id = '$shortcode_id'");
     434        $enable_crmfields = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET zcf_field_mandatory = '1', hiddenfield= '0', editupdate = '0' WHERE rel_id = %s AND shortcode_id = %s",$rel_id,$shortcode_id));
     435
    440436        $wpdb->query("update zcf_zohocrmform_field_manager set editupdate = '0' where field_id ='$field_id'");
    441437    }
    … …  
    447443        $shortcode_id = $enable_showfields[0]->shortcode_id;
    448444        $field_id = $enable_showfields[0]->field_id;
    449         $enable_crmfields = $wpdb->query("update zcf_zohocrm_formfield_manager set zcf_field_mandatory = '0',hiddenfield = '0',editupdate = '0' where rel_id ='$rel_id' and shortcode_id = '$shortcode_id'");
    450         $wpdb->query("update zcf_zohocrmform_field_manager set editupdate = '0' where field_id ='$field_id' ");
     445        $enable_crmfields = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET zcf_field_mandatory = '0', hiddenfield= '0', editupdate = '0' WHERE rel_id = %s AND shortcode_id = %s",$rel_id,$shortcode_id));
     446        $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrmform_field_manager SET editupdate = '0' WHERE field_id = %s",$field_id));
    451447    }
    452448
    … …  
    458454        $shortcode_id = $enable_showfields[0]->shortcode_id;
    459455        $field_id = $enable_showfields[0]->field_id;
    460         $enable_crmfields = $wpdb->query("update zcf_zohocrm_formfield_manager set display_label = '{$fieldDisplayLabels}' , editupdate = '0' where rel_id ='$rel_id' and shortcode_id = '$shortcode_id'");
    461         $wpdb->query("update zcf_zohocrmform_field_manager set editupdate = '0' where field_id ='$field_id'");
     456        $enable_crmfields = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET display_label = %s, editupdate = '0' WHERE rel_id = %s AND shortcode_id = %s",$fieldDisplayLabels,$rel_id,$shortcode_id));
     457        $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrmform_field_manager SET editupdate = '0' WHERE field_id = %s",$field_id));
    462458    }
    463459
    … …  
    469465        $shortcode_id = $enable_showfields[0]->shortcode_id;
    470466        $field_id = $enable_showfields[0]->field_id;
    471         $enable_crmfields = $wpdb->query("update zcf_zohocrm_formfield_manager set defaultvalues = '{$defaultvalue}' , editupdate = '0' where rel_id ='$rel_id' and shortcode_id = '$shortcode_id'");
    472         $wpdb->query("update zcf_zohocrmform_field_manager set editupdate = '0' where field_id ='$field_id'");
     467        $enable_crmfields = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET defaultvalues = %s, editupdate = '0'
     468         WHERE rel_id = %s AND shortcode_id = %s",$defaultvalue,$rel_id,$shortcode_id));
     469        $field_update_result = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrmform_field_manager SET editupdate = '0' WHERE field_id = %s",$field_id));
    473470    }
    474471
    … …  
    480477        $shortcode_id = $enable_showfields[0]->shortcode_id;
    481478        $field_id = $enable_showfields[0]->field_id;
    482         $enable_crmfields = $wpdb->query("update zcf_zohocrm_formfield_manager set state = '1' , editupdate = '0'  where rel_id ='$rel_id' and shortcode_id = '$shortcode_id'");
    483         $wpdb->query("update zcf_zohocrmform_field_manager set editupdate = '0' where field_id ='$field_id'");
     479        $enable_crmfields = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET state = '1', editupdate = '0' WHERE rel_id = %s AND shortcode_id = %s",$rel_id,$shortcode_id));
     480        $field_update_result = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrmform_field_manager SET editupdate = '0' WHERE field_id = %s",$field_id));
    484481    }
    485482
    … …  
    491488        $shortcode_id = $enable_showfields[0]->shortcode_id;
    492489        $field_id = $enable_showfields[0]->field_id;
    493         $enable_crmfields = $wpdb->query("update zcf_zohocrm_formfield_manager set state = '0' , editupdate = '0' where rel_id ='$rel_id' and shortcode_id = '$shortcode_id'");
    494         $wpdb->query("update zcf_zohocrmform_field_manager set editupdate = '0' where field_id ='$field_id'");
     490        $enable_crmfields = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET state = '0', editupdate = '0'
     491         WHERE rel_id = %s AND shortcode_id = %s",$rel_id,$shortcode_id));
     492        $field_update_result = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrmform_field_manager SET editupdate = '0' WHERE field_id = %s",$field_id));
    495493    }
    496494
    … …  
    502500        $shortcode_id = $enable_showfields[0]->shortcode_id;
    503501        $field_id = $enable_showfields[0]->field_id;
    504         $enable_crmfields = $wpdb->query("update zcf_zohocrm_formfield_manager set hiddenfield = '1' , editupdate = '0'  where rel_id ='$rel_id' and shortcode_id = '$shortcode_id'");
    505         $wpdb->query("update zcf_zohocrmform_field_manager set editupdate = '0' where field_id ='$field_id'");
     502        $enable_crmfields = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET hiddenfield = '1', editupdate = '0'
     503         WHERE rel_id = %s AND shortcode_id = %s",$rel_id,$shortcode_id));
     504        $field_update_result = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrmform_field_manager SET editupdate = '0' WHERE field_id = %s",
     505        $field_id));
    506506    }
    507507
    … …  
    513513        $shortcode_id = $enable_showfields[0]->shortcode_id;
    514514        $field_id = $enable_showfields[0]->field_id;
    515         $enable_crmfields = $wpdb->query("update zcf_zohocrm_formfield_manager set hiddenfield = '0' , editupdate = '0' where rel_id ='$rel_id' and shortcode_id = '$shortcode_id'");
    516         $wpdb->query("update zcf_zohocrmform_field_manager set editupdate = '0' where field_id ='$field_id'");
     515        $enable_crmfields = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET hiddenfield = '0', editupdate = '0'
     516         WHERE rel_id = %s AND shortcode_id = %s",$rel_id,$shortcode_id));
     517        $field_update_result = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrmform_field_manager SET editupdate = '0' WHERE field_id = %s",
     518        $field_id));
    517519    }
    518520
    … …  
    529531        $i = 0;
    530532        foreach ($get_existing_field_order as $key => $ffOrder) {
    531             $updates_orders = $wpdb->query("update zcf_zohocrm_formfield_manager set form_field_sequence ='" . $field_order[$ffOrder->field_id] . "' where rel_id ={$ffOrder->rel_id} ");
     533            $form_field_sequence = isset($field_order[$ffOrder->field_id]) ? intval($field_order[$ffOrder->field_id]) : 0;
     534            $rel_id = intval($ffOrder->rel_id);
     535            $updates_orders = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET form_field_sequence = %d
     536             WHERE rel_id = %d",$form_field_sequence,$rel_id));
    532537            $i++;
    533538        }
    … …  
    770775
    771776        $deleteid = $deletedata[0]->shortcode_id;
    772         $delete_shortcode = $wpdb->query("delete from zcf_zohoshortcode_manager where shortcode_id = '$deleteid'");
    773         $delete_shortcode_fields = $wpdb->query("delete from zcf_zohocrm_formfield_manager where shortcode_id = '$deleteid'");
     777        $delete_shortcode = $wpdb->query($wpdb->prepare("DELETE FROM zcf_zohoshortcode_manager WHERE shortcode_id = %d",
     778        $deleteid));       
     779        $delete_shortcode_fields = $wpdb->query($wpdb->prepare("DELETE FROM zcf_zohocrm_formfield_manager WHERE shortcode_id = %d",
     780        $deleteid));
    774781        return $deletedata;
    775782        exit;

  • zoho-crm-forms/trunk/includes/crmwebformsfieldsmapping.php

    r3185636 r3210848  
    104104        global $wpdb;
    105105        $submit_parameters['failure_count'] = $submit_parameters['total'] - $submit_parameters['success'];
    106 
    107         $update_form_submits = $wpdb->get_results("update zcf_zohoshortcode_manager set submit_count = '{$submit_parameters['total']}' , success_count = '{$submit_parameters['success']}' , failure_count = '{$submit_parameters['failure_count']}' where shortcode_name = '$shortcodename'");
     106        $total = intval($submit_parameters['total']);
     107        $success = intval($submit_parameters['success']);
     108        $failure_count = intval($submit_parameters['failure_count']);
     109        $shortcodename = sanitize_text_field($shortcodename);
     110        $update_form_submits = $wpdb->query($wpdb->prepare("UPDATE zcf_zohoshortcode_manager SET submit_count = %d, success_count = %d, failure_count = %d WHERE shortcode_name = %s",$total,$success,$failure_count,$shortcodename));
    108111    }
    109112
    … …  
    143146                ";
    144147
    145 $fields = $wpdb->get_results($wpdb->prepare($fieldsquery, $field_name, $module, $shortcodename, $crm_type) );
     148            $fields = $wpdb->get_results($wpdb->prepare($fieldsquery, $field_name, $module, $shortcodename, $crm_type) );
    146149            $rel_id = isset($fields[0]) ? $fields[0]->rel_id : "";
    147150            $field_id = isset($get_field_manager[0]) ? $get_field_manager[0]->field_id : "";
    … …  
    149152            if ($crm_type == $shortcodedata->crm_type && $module_type == $module) {
    150153                if (count($fields) == 0) {
    151 
    152                     $query = $wpdb->get_results("insert into zcf_zohocrm_formfield_manager( field_id , shortcode_id , display_label , custom_field_type , custom_field_values , zcf_field_mandatory , form_field_sequence , state ) VALUES ('$field_id', '$shortcode_id' , '$field_label', '$field_type', '$field_values' , $field_mandatory , $field_sequence , $publish )");
     154                    $query = $wpdb->query($wpdb->prepare("INSERT INTO zcf_zohocrm_formfield_manager (field_id, shortcode_id, display_label, custom_field_type, custom_field_values, zcf_field_mandatory, form_field_sequence, state)VALUES (%d, %d, %s, %s, %s, %d, %d, %d)",$field_id,$shortcode_id,$field_label,$field_type,$field_values,$field_mandatory,$field_sequence,$publish));
    153155                } else {
    154156                    $state = "";
    … …  
    158160                    }
    159161
    160                     $query = $wpdb->get_results("update zcf_zohocrm_formfield_manager set zcf_field_mandatory = '$field_mandatory' {$state} , custom_field_values = '$field_values' where rel_id = '{$rel_id}'");
     162                    $query = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET zcf_field_mandatory = %d, custom_field_values = %s {$state} WHERE rel_id = %d",$field_mandatory,$field_values,$rel_id));
    161163
    162164                    if ($field_type == 'picklist' || $field_type == 'multipicklist') {
    … …  
    247249                        $state = ", state = '1'";
    248250                    }
    249                     $query = $wpdb->get_results("update zcf_zohocrm_formfield_manager set zcf_field_mandatory = '$field_mandatory' {$state} , custom_field_values = '$field_values' ,editupdate=0 where field_id = '{$field_id}'");
     251        $query = $wpdb->query($wpdb->prepare("UPDATE zcf_zohocrm_formfield_manager SET zcf_field_mandatory = %d, custom_field_values = %s, editupdate = 0 {$state} WHERE field_id = %d",$field_mandatory,$field_values,$field_id));
    250252
    251253                    if ($field_type == 'picklist' || $field_type == 'multipicklist') {

  • zoho-crm-forms/trunk/index.php

    r3209626 r3210848  
    44 * Plugin Name: Zoho CRM Lead Magnet
    55 * Description: Websites are one of the most important sources of leads for your business. That means your CRM system should be well integrated with your website to contextually capture each and every visitor to turn them into a lead.Introducing the Zoho CRM Lead Capture plugin for Wordpress. This lets you create webforms, embed them in your website, and automatically capture leads directly into your CRM with zero attenuation.Not only is the integration easy to set-up but it's also easy on your wallet.
    6  * Version: 1.8.0.5
     6 * Version: 1.8.0.6
    77 * ***************************************************************************************** */
    88if (!defined('ABSPATH'))
    99    exit;
    1010
    11         define( 'ZCF_VERSION', '1.8.0.5' );
     11        define( 'ZCF_VERSION', '1.8.0.6' );
    1212        define( 'ZCF_LBPLUGINFILE', __FILE__ );
    1313        define( 'ZCF_LBPLUGIN_URL', untrailingslashit( plugins_url( '', ZCF_LBPLUGINFILE ) ) );
Note: See TracChangeset for help on using the changeset viewer.