query($wpdb->prepare( "DELETE FROM $wpdb->options WHERE option_name LIKE %s OR option_name LIKE %s", '%' . $wpdb->esc_like('_transient_' . $slug) . '%', '%' . $wpdb->esc_like('_transient_timeout_' . $slug) . '%' )); // Delete site transients too (for multisite) if (is_multisite()) { $wpdb->query($wpdb->prepare( "DELETE FROM $wpdb->sitemeta WHERE meta_key LIKE %s OR meta_key LIKE %s", '%' . $wpdb->esc_like('_site_transient_' . $slug) . '%', '%' . $wpdb->esc_like('_site_transient_timeout_' . $slug) . '%' )); } } // Clear all plugin API transients $wpdb->query("DELETE FROM $wpdb->options WHERE option_name LIKE '%_transient_plugins_api_%'"); $wpdb->query("DELETE FROM $wpdb->options WHERE option_name LIKE '%_transient_timeout_plugins_api_%'"); $wpdb->query("DELETE FROM $wpdb->options WHERE option_name LIKE '%_transient_plugin_information_%'"); $wpdb->query("DELETE FROM $wpdb->options WHERE option_name LIKE '%_transient_timeout_plugin_information_%'"); // Clear site transients too (for multisite) if (is_multisite()) { $wpdb->query("DELETE FROM $wpdb->sitemeta WHERE meta_key LIKE '%_site_transient_plugins_api_%'"); $wpdb->query("DELETE FROM $wpdb->sitemeta WHERE meta_key LIKE '%_site_transient_timeout_plugins_api_%'"); $wpdb->query("DELETE FROM $wpdb->sitemeta WHERE meta_key LIKE '%_site_transient_plugin_information_%'"); $wpdb->query("DELETE FROM $wpdb->sitemeta WHERE meta_key LIKE '%_site_transient_timeout_plugin_information_%'"); } // Clear update cache delete_site_transient('update_plugins'); delete_site_transient('update_themes'); delete_site_transient('update_core'); delete_site_transient('plugin_information'); // Clear plugin update counts delete_transient('plugin_updates_count'); delete_site_transient('plugin_updates_count'); // Clear plugin slugs cache delete_transient('plugin_slugs'); delete_site_transient('plugin_slugs'); // Force refresh of plugin update information if (function_exists('wp_clean_plugins_cache')) { wp_clean_plugins_cache(true); } // Clear object cache if (function_exists('wp_cache_flush')) { wp_cache_flush(); } // Add admin notice add_action('admin_notices', 'plugin_transients_cleared_notice'); } /** * Display admin notice */ function plugin_transients_cleared_notice() { ?>

Plugin Transients Cleared: All plugin transients have been cleared from the database.