Sign upLogin

MinnPost/object-sync-for-salesforce

View on GitHub
Star

Showing 364 of 364 total issues

Use placeholders and $wpdb->prepare(); found $order
Open

            $mappings = $this->wpdb->get_results( 'SELECT * FROM ' . $table . $order, ARRAY_A );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found interpolated variable $table at "SELECT id, label, wordpress_object, salesforce_object, salesforce_record_types_allowed, salesforce_record_type_default, fields, pull_trigger_field, sync_triggers, push_async, push_drafts, weight, version FROM $table"
Open

                    $mappings = $this->wpdb->get_results( "SELECT `id`, `label`, `wordpress_object`, `salesforce_object`, `salesforce_record_types_allowed`, `salesforce_record_type_default`, `fields`, `pull_trigger_field`, `sync_triggers`, `push_async`, `push_drafts`, `weight`, `version` FROM $table", ARRAY_A );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found interpolated variable $this at "DELETE FROM $this->object_map_table WHERE ID IN ($ids)"
Open

            $delete = $this->wpdb->query( "DELETE FROM $this->object_map_table WHERE ID IN ($ids)" );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found $where
Open

            $mappings = $this->wpdb->get_results( 'SELECT * FROM ' . $table . $where . $order, ARRAY_A );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found interpolated variable $table at "SELECT * FROM {$table} WHERE salesforce_id LIKE 'tmp_sf_%' OR wordpress_id LIKE 'tmp_wp_%' OR last_sync_status = 0 LIMIT {$offset}, {$items_per_page}"
Open

        $all_errors            = $this->wpdb->get_results( "SELECT * FROM {$table} WHERE salesforce_id LIKE 'tmp_sf_%' OR wordpress_id LIKE 'tmp_wp_%' OR last_sync_status = 0 LIMIT {$offset}, {$items_per_page}", ARRAY_A );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found interpolated variable $tax_table at "DESC {$tax_table}"
Open

            $taxonomy = $this->wpdb->get_col( "DESC {$tax_table}", 0 );
Severity: Minor
Found in classes/class-object-sync-sf-wordpress.php by phpcodesniffer

Equals sign not aligned correctly; expected 1 space but found 2 spaces
Open

        $headers  = array(
Severity: Minor
Found in classes/class-object-sync-sf-salesforce.php by phpcodesniffer

Assignments must be the first block of code on a line
Open

    if ( $var = getenv( 'WP_README_ENV' ) ) {
Severity: Minor
Found in bin/wp-readme.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found $where
Open

            $mappings = $this->wpdb->get_results( 'SELECT * FROM ' . $table . $where . ' ORDER BY `fieldmap_status`, `weight`', ARRAY_A );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found interpolated variable $table at "SELECT id, label, wordpress_object, salesforce_object, salesforce_record_types_allowed, salesforce_record_type_default, fields, pull_trigger_field, sync_triggers, push_async, push_drafts, pull_to_drafts, weight, version FROM $table"
Open

                    $mappings = $this->wpdb->get_results( "SELECT `id`, `label`, `wordpress_object`, `salesforce_object`, `salesforce_record_types_allowed`, `salesforce_record_type_default`, `fields`, `pull_trigger_field`, `sync_triggers`, `push_async`, `push_drafts`, `pull_to_drafts`, `weight`, `version` FROM $table", ARRAY_A );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found interpolated variable $items_per_page at "SELECT * FROM {$table} WHERE salesforce_id LIKE 'tmp_sf_%' OR wordpress_id LIKE 'tmp_wp_%' OR last_sync_status = 0 LIMIT {$offset}, {$items_per_page}"
Open

        $all_errors            = $this->wpdb->get_results( "SELECT * FROM {$table} WHERE salesforce_id LIKE 'tmp_sf_%' OR wordpress_id LIKE 'tmp_wp_%' OR last_sync_status = 0 LIMIT {$offset}, {$items_per_page}", ARRAY_A );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found interpolated variable $table at "SELECT COUNT(id) FROM {$table} WHERE salesforce_id LIKE 'tmp_sf_%' OR wordpress_id LIKE 'tmp_wp_%' OR last_sync_status = 0"
Open

        $errors_total          = $this->wpdb->get_var( "SELECT COUNT(`id`) FROM {$table} WHERE salesforce_id LIKE 'tmp_sf_%' OR wordpress_id LIKE 'tmp_wp_%' OR last_sync_status = 0" );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer

Equals sign not aligned with surrounding assignments; expected 1 space but found 2 spaces
Open

        $headers  = array(
Severity: Minor
Found in classes/class-object-sync-sf-salesforce.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found $table
Open

            $map        = $this->wpdb->get_row( 'SELECT * FROM ' . $table . ' WHERE id = ' . $id, ARRAY_A );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found $object_map_table
Open

        $this->wpdb->query( 'DROP TABLE IF EXISTS ' . $object_map_table );
Severity: Minor
Found in classes/class-object-sync-sf-deactivate.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found interpolated variable $content_table at "DESC {$content_table}"
Open

        $data_fields      = $this->wpdb->get_col( "DESC {$content_table}", 0 );
Severity: Minor
Found in classes/class-object-sync-sf-wordpress.php by phpcodesniffer

Equals sign not aligned with surrounding assignments; expected 5 spaces but found 6 spaces
Open

        $url      = $this->login_url . $this->token_path;
Severity: Minor
Found in classes/class-object-sync-sf-salesforce.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found interpolated variable $content_table at "DESC {$content_table}"
Open

        $data_field_types = $this->wpdb->get_col( "DESC {$content_table}", 1 ); // get the database field types.
Severity: Minor
Found in classes/class-object-sync-sf-wordpress.php by phpcodesniffer

Please spell "WordPress" correctly. Found 1 misspelling(s): wordpress
Open

         *         'wordpress' => array( // phpcs:ignore WordPress.WP.CapitalPDangit.Misspelled
Severity: Minor
Found in classes/class-object-sync-salesforce.php by phpcodesniffer

Use placeholders and $wpdb->prepare(); found $table
Open

            $mappings = $this->wpdb->get_results( 'SELECT * FROM ' . $table . $order, ARRAY_A );
Severity: Minor
Found in classes/class-object-sync-sf-mapping.php by phpcodesniffer
Severity
Category
Status
Source
Language