Fix changed plugin filename across a network

fix-changed-plugin-filename.php

<?php
// Use: $ wp eval-file fix-changed-plugin-filename.php

global $wpdb;
$blog_ids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs" );
 
$p = 'list-category-posts/list_cat_posts.php';
$new_p = 'list-category-posts/list-category-posts.php';
 
foreach ( $blog_ids as $blog_id ) {
         $bplugins = (array) get_blog_option( $blog_id, 'active_plugins' );
         $ploc = array_search( $p, $bplugins );
         if ( false !== $ploc && ! in_array( $p_new, $bplugins ) ) {
                 unset( $bplugins[ $ploc ] );
                 $bplugins[] = $new_p;
                 sort( $bplugins );
                 update_blog_option( $blog_id, 'active_plugins', $bplugins );
                 echo "Reactivated plugin on $blog_id\n";
         }
}
  }