WordPress.org
Get WordPress

Plugin Directory

Changeset 2972531


Ignore:
Timestamp:
09/28/2023 08:23:40 AM (2 years ago)
Author:
moazsup
Message:

Compatibility with mysql databases

Location:
integrate-dynamics-365-crm
Files:
75 added
2 deleted
3 edited

Legend:

Unmodified
Added
Removed

  • integrate-dynamics-365-crm/trunk/Wrappers/dbWrapper.php

    r2819092 r2972531  
    2424        $sql = "CREATE TABLE $table_name (
    2525            id mediumint(9) NOT NULL AUTO_INCREMENT,
    26             cf7_form_id text NOT NULL,
     26            cf7_form_id varchar(200) NOT NULL,
    2727            form_fields text NOT NULL,
    2828            dynamics_object_id text NOT NULL,
    … …  
    6868
    6969        $db=$wpdb->dbname;
    70         $result=$wpdb->get_results($wpdb->prepare("SELECT `AUTO_INCREMENT` FROM  INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = %s AND TABLE_NAME = %s",$db,$table),ARRAY_A);
    71         $next_id=$result[0]['AUTO_INCREMENT'];
    72         return $next_id;
     70        $id = $wpdb->get_var($wpdb->prepare("SELECT id FROM %i ORDER BY id DESC LIMIT 1", $table));
     71        $id = $id ? $id : 0;
     72        $result = $wpdb->get_results($wpdb->prepare("ALTER TABLE %i AUTO_INCREMENT = %d", $table,$id), ARRAY_A);
     73           
     74        return $id+1;
    7375    }
    7476
    … …  
    8284        global $wpdb;
    8385        $table = $wpdb->prefix.dbConstants::CF7_OBJECT_MAPPING_TABLE;
    84         $result = $wpdb->get_results( $wpdb->prepare("SELECT id FROM %5s where id = %s",$table,$id));
     86        $result = $wpdb->get_results( $wpdb->prepare("SELECT id FROM %i where id = %d",$table,$id));
    8587        if(empty($result))
    8688            return false;
    … …  
    9395        global $wpdb;
    9496        $table = $wpdb->prefix.dbConstants::CF7_OBJECT_MAPPING_TABLE;
    95         $result = $wpdb->get_results($wpdb->prepare("SELECT * FROM %5s where id = %s",$table,$id), ARRAY_A );
     97        $result = $wpdb->get_results($wpdb->prepare("SELECT * FROM %i where id = %d",$table,$id), ARRAY_A );
    9698       
    9799        if(empty($result))
    … …  
    105107        global $wpdb;
    106108        $table = $wpdb->prefix.dbConstants::CF7_OBJECT_MAPPING_TABLE;
    107         $result = $wpdb->get_results($wpdb->prepare("SELECT  %5s FROM %5s where %5s = %s",$select, $table,$key, $id), ARRAY_A );
     109        $result = $wpdb->get_results($wpdb->prepare("SELECT  %i FROM %i where %d = %d",$select, $table,$key, $id), ARRAY_A );
    108110       
    109111        if(empty($result))
    … …  
    120122            return [];
    121123
    122         $result=$wpdb->get_results($wpdb->prepare("SELECT id, cf7_form_id, dynamics_object_id, field_map from %5s",$table),ARRAY_A);
     124        $result=$wpdb->get_results($wpdb->prepare("SELECT id, cf7_form_id, dynamics_object_id, field_map from %i",$table),ARRAY_A);
    123125        return $result;
    124126     }

  • integrate-dynamics-365-crm/trunk/integrate-dynamics-365-crm.php

    r2828956 r2972531  
    55Plugin URI: https://plugins.miniorange.com/
    66Description: This plugin will allow you to sync CRM Objects like contacts, accounts, leads, etc. between Dynamics 365 Sales and wordpress.
    7 Version: 1.0.3
     7Version: 1.0.4
    88Author: miniOrange
    99License: GPLv2 or later
    … …  
    2424define('MO_DCRM_PLUGIN_FILE',__FILE__);
    2525define('MO_DCRM_PLUGIN_DIR',__DIR__.DIRECTORY_SEPARATOR);
    26 define('PLUGIN_VERSION','1.0.3');
     26define('PLUGIN_VERSION','1.0.4');
    2727
    2828class MOdcrm{

  • integrate-dynamics-365-crm/trunk/readme.txt

    r2828956 r2972531  
    44Tags: crm, dynamics 365, dynamics crm, forms, Microsoft
    55Requires at least: 5.5
    6 Tested up to: 6.1
     6Tested up to: 6.3
    77Requires PHP: 7.0 or higher
    8 Stable tag: 1.0.3
     8Stable tag: 1.0.4
    99License: GPLv2 or later
    1010License URI: http://www.gnu.org/licenses/gpl-2.0.html
    … …  
    8282== ChangeLog ==
    8383
     84= 1.0.4 =
     85* BugFix for contact form 7 mapping table
     86
    8487= 1.0.3 =
    8588* Added data visulization tab to embed dynamics object into pages.
    … …  
    99102== Upgrade Notice ==
    100103
     104= 1.0.4 =
     105* BugFix for contact form 7 mapping table
     106
    101107= 1.0.3 =
    102108* Added data visulization tab to embed dynamics object into pages.
Note: See TracChangeset for help on using the changeset viewer.