CUNY Academic Commons

This is now done. Here are the steps I took:

1. Collected URLs of sites using the shortcode:

global $wpdb;

$site_ids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs LIMIT 1000" );

foreach ( $site_ids as $site_id ) {
    $prefix = $wpdb->get_blog_prefix( $site_id );
    $count = $wpdb->get_var( "SELECT COUNT(*) FROM {$prefix}posts WHERE post_content LIKE '%[cetsEmbedRSS%'" );
    if ( $count ) {
        echo get_blog_option( $site_id, 'home' ) . "\n";
    }
}

(run in batches of 1000 so as not to crash things)

2. Turned results into a set of WP-CLI statements:

wp --url=tags.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=kevinreiss.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=gdonovan.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=connections.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=french.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=wandt.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=madlibrarian.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=erac.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=podcasting.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=deletestein.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=breakstuff.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=lagccnetworks.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=cunymathblog.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=fairuse.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=research-backup.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=teachlearn.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=digitalfellows.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=qcexperiential.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=gcdigitallab.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=annesialamb.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=testpage.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=hannahmiller.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=emanuelb.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=cunysustainability.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=aleksphd.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=bcarchives1.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=weather.commons.gc.cuny.edu plugin activate cets_EmbedRSS  &&
wp --url=dining.commons.gc.cuny.edu plugin activate cets_EmbedRSS

3. Network deactivated plugin, then activated on sites using the above.

4. Prevent plugin from being activated on new sites in the future. https://github.com/cuny-academic-commons/cac/commit/73c4ca222054bed9071fe1339364b5194ba349f0