Changeset 3208898
- Timestamp:
- 12/17/2024 06:05:24 AM (16 months ago)
- Location:
- zoho-crm-forms/trunk
- Files:
-
- 3 edited
-
Readme.txt (modified) (2 diffs)
-
includes/crmshortcodefunctions.php (modified) (9 diffs)
-
index.php (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
zoho-crm-forms/trunk/Readme.txt
r3196493 r3208898 7 7 Author: Zoho CRM 8 8 Tested up to: 6.7 9 Stable tag: 1.8.0. 39 Stable tag: 1.8.0.4 10 10 License: GPLv2 or later 11 Version: 1.8.0. 311 Version: 1.8.0.4 12 12 License URI: http://www.gnu.org/licenses/gpl-2.0.html 13 13 … … 313 313 1.8.0.3 314 314 Php latest version compatibility checking 315 1.8.0.4 316 Bug Boundry issue has been fixed 315 317 316 318 == Upgrade notice == -
zoho-crm-forms/trunk/includes/crmshortcodefunctions.php
r3193765 r3208898 433 433 function zcfenableMandatoryFields($selectedfields, $shortcode_name) { 434 434 global $wpdb; 435 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id, fieldmanager.shortcode_id,fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager as fieldmanager INNER JOIN zcf_zohoshortcode_manager as shorcodemanager ON fieldmanager.shortcode_id=shorcodemanager.shortcode_id AND fieldmanager.field_id='$selectedfields' AND shorcodemanager.shortcode_name = '$shortcode_name'",$shortcode_name));435 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id, fieldmanager.shortcode_id, fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager AS fieldmanager INNER JOIN zcf_zohoshortcode_manager AS shorcodemanager ON fieldmanager.shortcode_id = shorcodemanager.shortcode_id AND fieldmanager.field_id = %s AND shorcodemanager.shortcode_name = %s",$selectedfields,$shortcode_name)); 436 436 $rel_id = $enable_showfields[0]->rel_id; 437 437 $shortcode_id = $enable_showfields[0]->shortcode_id; … … 443 443 function zcfdisableMandatoryFields($selectedfields, $shortcode_name) { 444 444 global $wpdb; 445 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id, fieldmanager.shortcode_id,fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager as fieldmanager INNER JOIN zcf_zohoshortcode_manager as shorcodemanager ON fieldmanager.shortcode_id=shorcodemanager.shortcode_id AND fieldmanager.field_id='$selectedfields' AND shorcodemanager.shortcode_name = '$shortcode_name'",$shortcode_name));445 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id, fieldmanager.shortcode_id, fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager AS fieldmanager INNER JOIN zcf_zohoshortcode_manager AS shorcodemanager ON fieldmanager.shortcode_id = shorcodemanager.shortcode_id AND fieldmanager.field_id = %s AND shorcodemanager.shortcode_name = %s",$selectedfields,$shortcode_name)); 446 446 $rel_id = $enable_showfields[0]->rel_id; 447 447 $shortcode_id = $enable_showfields[0]->shortcode_id; … … 453 453 function zcfsaveFieldLabelDisplay($fieldDisplayLabels, $selectedfields, $shortcode_name) { 454 454 global $wpdb; 455 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id,fieldmanager.shortcode_id,fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager as fieldmanager INNER JOIN zcf_zohoshortcode_manager as shorcodemanager ON fieldmanager.shortcode_id=shorcodemanager.shortcode_id AND fieldmanager.field_id='$selectedfields' AND shorcodemanager.shortcode_name = '$shortcode_name'", $shortcode_name)); 455 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id, fieldmanager.shortcode_id, fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager AS fieldmanager INNER JOIN zcf_zohoshortcode_manager AS shorcodemanager ON fieldmanager.shortcode_id = shorcodemanager.shortcode_id AND fieldmanager.field_id = %s AND shorcodemanager.shortcode_name = %s",$selectedfields,$shortcode_name)); 456 456 457 $rel_id = $enable_showfields[0]->rel_id; 457 458 $shortcode_id = $enable_showfields[0]->shortcode_id; … … 463 464 function zcfdefaultvalueFields($selectedfields, $shortcode_name, $defaultvalue) { 464 465 global $wpdb; 465 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id,fieldmanager.shortcode_id,fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager as fieldmanager INNER JOIN zcf_zohoshortcode_manager as shorcodemanager ON fieldmanager.shortcode_id=shorcodemanager.shortcode_id AND fieldmanager.field_id='$selectedfields' AND shorcodemanager.shortcode_name = '$shortcode_name'", $shortcode_name)); 466 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id, fieldmanager.shortcode_id, fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager AS fieldmanager INNER JOIN zcf_zohoshortcode_manager AS shorcodemanager ON fieldmanager.shortcode_id = shorcodemanager.shortcode_id AND fieldmanager.field_id = %s AND shorcodemanager.shortcode_name = %s",$selectedfields,$shortcode_name)); 467 466 468 $rel_id = $enable_showfields[0]->rel_id; 467 469 $shortcode_id = $enable_showfields[0]->shortcode_id; … … 473 475 function zcfenableFields($selectedfields, $shortcode_name) { 474 476 global $wpdb; 475 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id,fieldmanager.shortcode_id,fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager as fieldmanager INNER JOIN zcf_zohoshortcode_manager as shorcodemanager ON fieldmanager.shortcode_id=shorcodemanager.shortcode_id AND fieldmanager.field_id='$selectedfields' AND shorcodemanager.shortcode_name = '$shortcode_name'", $shortcode_name)); 477 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id, fieldmanager.shortcode_id, fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager AS fieldmanager INNER JOIN zcf_zohoshortcode_manager AS shorcodemanager ON fieldmanager.shortcode_id = shorcodemanager.shortcode_id AND fieldmanager.field_id = %s AND shorcodemanager.shortcode_name = %s",$selectedfields,$shortcode_name)); 478 476 479 $rel_id = $enable_showfields[0]->rel_id; 477 480 $shortcode_id = $enable_showfields[0]->shortcode_id; … … 483 486 function zcfdisableFields($selectedfields, $shortcode_name) { 484 487 global $wpdb; 485 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id,fieldmanager.shortcode_id,fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager as fieldmanager INNER JOIN zcf_zohoshortcode_manager as shorcodemanager ON fieldmanager.shortcode_id=shorcodemanager.shortcode_id AND fieldmanager.field_id='$selectedfields' AND shorcodemanager.shortcode_name = '$shortcode_name'", $shortcode_name)); 488 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id, fieldmanager.shortcode_id, fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager AS fieldmanager INNER JOIN zcf_zohoshortcode_manager AS shorcodemanager ON fieldmanager.shortcode_id = shorcodemanager.shortcode_id AND fieldmanager.field_id = %s AND shorcodemanager.shortcode_name = %s",$selectedfields,$shortcode_name)); 489 486 490 $rel_id = $enable_showfields[0]->rel_id; 487 491 $shortcode_id = $enable_showfields[0]->shortcode_id; … … 493 497 function zcfenableHiddenFields($selectedfields, $shortcode_name) { 494 498 global $wpdb; 495 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id,fieldmanager.shortcode_id,fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager as fieldmanager INNER JOIN zcf_zohoshortcode_manager as shorcodemanager ON fieldmanager.shortcode_id=shorcodemanager.shortcode_id AND fieldmanager.field_id='$selectedfields' AND shorcodemanager.shortcode_name = '$shortcode_name'", $shortcode_name)); 499 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id, fieldmanager.shortcode_id, fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager AS fieldmanager INNER JOIN zcf_zohoshortcode_manager AS shorcodemanager ON fieldmanager.shortcode_id = shorcodemanager.shortcode_id AND fieldmanager.field_id = %s AND shorcodemanager.shortcode_name = %s",$selectedfields,$shortcode_name)); 500 496 501 $rel_id = $enable_showfields[0]->rel_id; 497 502 $shortcode_id = $enable_showfields[0]->shortcode_id; … … 503 508 function zcfdisableHiddenFields($selectedfields, $shortcode_name) { 504 509 global $wpdb; 505 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id,fieldmanager.shortcode_id,fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager as fieldmanager INNER JOIN zcf_zohoshortcode_manager as shorcodemanager ON fieldmanager.shortcode_id=shorcodemanager.shortcode_id AND fieldmanager.field_id='$selectedfields' AND shorcodemanager.shortcode_name = '$shortcode_name'", $shortcode_name)); 510 $enable_showfields = $wpdb->get_results($wpdb->prepare("SELECT fieldmanager.field_id, fieldmanager.shortcode_id, fieldmanager.rel_id, shorcodemanager.shortcode_id FROM zcf_zohocrm_formfield_manager AS fieldmanager INNER JOIN zcf_zohoshortcode_manager AS shorcodemanager ON fieldmanager.shortcode_id = shorcodemanager.shortcode_id AND fieldmanager.field_id = %s AND shorcodemanager.shortcode_name = %s",$selectedfields,$shortcode_name)); 511 506 512 $rel_id = $enable_showfields[0]->rel_id; 507 513 $shortcode_id = $enable_showfields[0]->shortcode_id; … … 784 790 public function ZcfformatContactFields($thirdparty_form, $title, $shortcode) { 785 791 global $wpdb; 786 $enablequery = " 787 SELECT a.rel_id, a.zcf_field_mandatory, a.custom_field_type, a.custom_field_values, 788 a.display_label, a.field_id, c.field_name, a.defaultvalues, a.hiddenfield 789 FROM zcf_zohocrm_formfield_manager AS a 790 JOIN zcf_zohoshortcode_manager AS b ON b.shortcode_id = a.shortcode_id 791 JOIN zcf_zohocrmform_field_manager AS c ON c.field_id = a.field_id 792 WHERE b.shortcode_name = %s 793 AND a.state = 1 794 ORDER BY a.form_field_sequence 795 "; 792 $enablequery = "SELECT a.rel_id, a.zcf_field_mandatory, a.custom_field_type, a.custom_field_values, a.display_label, a.field_id, c.field_name, a.defaultvalues, a.hiddenfield FROM zcf_zohocrm_formfield_manager AS a JOIN zcf_zohoshortcode_manager AS b ON b.shortcode_id = a.shortcode_id JOIN zcf_zohocrmform_field_manager AS c ON c.field_id = a.field_id WHERE b.shortcode_name = %s AND a.state = 1 ORDER BY a.form_field_sequence"; 796 793 $word_form_enable_fields = $wpdb->get_results($wpdb->prepare($enablequery, $shortcode) ); 797 794 -
zoho-crm-forms/trunk/index.php
r3194673 r3208898 4 4 * Plugin Name: Zoho CRM Lead Magnet 5 5 * 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. 36 * Version: 1.8.0.4 7 7 * ***************************************************************************************** */ 8 8 if (!defined('ABSPATH')) 9 9 exit; 10 10 11 define( 'ZCF_VERSION', '1.8.0. 3' );11 define( 'ZCF_VERSION', '1.8.0.4' ); 12 12 define( 'ZCF_LBPLUGINFILE', __FILE__ ); 13 13 define( 'ZCF_LBPLUGIN_URL', untrailingslashit( plugins_url( '', ZCF_LBPLUGINFILE ) ) );
Note: See TracChangeset
for help on using the changeset viewer.