get_results( "SELECT key_id FROM {$wpdb->prefix}woocommerce_api_keys WHERE description = 'Advanced Gutenberg Blocks'", OBJECT ); if( count( $results ) == 0 ) { $consumer_key = 'ck_' . wc_rand_hash(); $consumer_secret = 'cs_' . wc_rand_hash(); $data = array( 'user_id' => 1, 'description' => "Advanced Gutenberg Blocks", 'permissions' => 'read', 'consumer_key' => wc_api_hash( $consumer_key ), 'consumer_secret' => $consumer_secret, 'truncated_key' => substr( $consumer_secret, -7 ), ); $wpdb->insert( $wpdb->prefix . 'woocommerce_api_keys', $data, array( '%d', '%s', '%s', '%s', '%s', '%s', ) ); update_option( 'AGB_woo_ck', $consumer_key ); update_option( 'AGB_woo_cs', $consumer_secret ); } } } }