WordPress.org
Get WordPress

Plugin Directory

Changeset 3011710


Ignore:
Timestamp:
12/19/2023 06:30:02 AM (2 years ago)
Author:
zorem
Message:

updated admin file

File:
1 edited

Legend:

Unmodified
Added
Removed

  • woo-advanced-shipment-tracking/trunk/includes/class-wc-advanced-shipment-tracking-admin.php

    r3011706 r3011710  
    11521152       
    11531153        if ( 0 == $shippment_provider ) {
    1154             // $shippment_provider = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %1s WHERE JSON_CONTAINS(api_provider_name, '[" . '"' . $tracking_provider . '"' . "]')", $this->table ) );
    1155             $shippment_provider = $wpdb->get_var(
     1154            $shippment_provider = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM %1s WHERE JSON_CONTAINS(api_provider_name, '[" . '"' . $tracking_provider . '"' . "]')", $this->table ) );
     1155            /*$shippment_provider = $wpdb->get_var(
    11561156                $wpdb->prepare(
    11571157                    'SELECT COUNT(*) FROM %s WHERE JSON_CONTAINS(api_provider_name, %s)',
    … …  
    11591159                    json_encode([$tracking_provider])
    11601160                )
    1161             );
     1161            );*/
    11621162        }   
    11631163       
    … …  
    21212121       
    21222122        if ( !$tracking_provider ) {           
    2123             // $tracking_provider = $wpdb->get_var(  $wpdb->prepare( "SELECT ts_slug FROM %1s WHERE JSON_CONTAINS(LOWER(api_provider_name), LOWER('[" . '"' . $tracking_provider_name . '"' . "]') )", $this->table ) );
    2124             $tracking_provider = $wpdb->get_var(
     2123            $tracking_provider = $wpdb->get_var(  $wpdb->prepare( "SELECT ts_slug FROM %1s WHERE JSON_CONTAINS(LOWER(api_provider_name), LOWER('[" . '"' . $tracking_provider_name . '"' . "]') )", $this->table ) );
     2124            /*$tracking_provider = $wpdb->get_var(
    21252125                $wpdb->prepare(
    21262126                    "SELECT ts_slug FROM %s WHERE JSON_CONTAINS(LOWER(api_provider_name), LOWER('[%s]'))",
    … …  
    21282128                    $tracking_provider_name
    21292129                )
    2130             );
     2130            );*/
    21312131        }
    21322132       
Note: See TracChangeset for help on using the changeset viewer.