<?php

global $wpdb, $bp;

$start = 3000;
$count = 500;
$blog_ids = $wpdb->get_col( $wpdb->prepare( "SELECT blog_id FROM {$wpdb->blogs} WHERE deleted = 0 AND archived = 0 AND spam = 0 LIMIT %d, %d", $start, $count ) );

$data  = array();
$stats = array();

$disabled_plugins = array(
	'_bp_rbe_imap_object_cache.php',
	'bp-external-activity/loader.php',
	'bp-groups-social-media/bp-groups-social-media.php',
	'bp-import-blog-activity/bp-import-blog-activity.php',
	'bp-lazyload-avatars/loader.php',
	'bp-lotsa-feeds/loader.php',
	'bp-rbe-inbound-forum-attachments/loader.php',
	'bp-relative-time/loader.php',
	'bp-reply-by-email/loader.php',
	'bp-social-media-profiles/loader.php',
//	'bp-system-report/bp-system-report.php',
//	'bp_tos_check/bp-tos-check.php',
	'btcnew/btcnew.php', // #10348
	'buddypress-docs-in-group/loader.php',
	'cac-advanced-profiles/cac-advanced-profiles.php',
	'cac-bp-blogs-directory-enhancements/cac-bp-blogs-directory-enhancements.php',
	'cac-group-announcements/cac-group-announcements.php',
	'cac-non-cuny-signup/loader.php',
	'cac-plugin-updates/cac-plugin-updates.php',
	'cacap-cac/cacap-cac.php',
	'cacap-notices/cacap-notices.php',
	'cacap-profiles-overlay/cacap-profiles-overlay.php',
	'cforms/cforms.php',
	'commentpress/commentpress.php',
	'cp-ajax-comments/cp-ajax-comments.php',
	'customizer-remove-all-parts/wp-crap.php',
	'daikosvideowidget.php', // #10348
	'dandyid-services/dandyid-services.php', // #10348
	'dd-formmailer/dd-formmailer.php', // #10348
	'dirt-directory-client/loader.php',
	//'email-users/email-users.php',
	'external-group-blogs/loader.php',
//	'fd-footnotes/fdfootnotes.php',
//	'firestats/firestats-wordpress.php',
//	'flickr-rss/flickrrss.php', // #10348
	'garees-twitter-stream/garees_twitter_stream.php', // #10344
//	'google-maps-embed/cets_EmbedGmaps.php',
	'kimili-flash-embed/kml_flashembed.php', // #10348
	'multisite-clone-duplicator/multisite-clone-duplicator.php',
	'oauth2-provider/wp-oauth-main.php',
	'page-tagger/page-tagger.php',
	'post-rich-videos-and-photos-galleries/wp-media-cincopa.php',
//	'share-this/sharethis.php',
	'sociable/sociable.php', // #10345
	//'social/social.php',
	'social-paper/social-paper.php',
	//'tantan-spam/plugin.php', // #10348
//	'tweetable/tweetable.php', // #10344
	'tubepress/tubepress.php', // #10348
	'twitter-mentions-as-comments/twitter-mentions-as-comments.php', // #10344
//	'twitter-tools/twitter-tools.php', // #10344
	//'wordtube/wordtube.php', // #10348
	'wp-rss-multi-importer/wp-rss-multi-importer.php',
	'wp-ui/wp-ui.php',
//	'wpng-calendar/wpng-calendar.php',
//	'wysija-newsletters/index.php',
	'unconfirmed/unconfirmed.php',
);

foreach ( $blog_ids as $blog_id ) {
	$active_plugins = get_blog_option( $blog_id, 'active_plugins' );
	$home = get_home_url( $blog_id );

	foreach ( $active_plugins as $p ) {
		if ( ! in_array( $p, $disabled_plugins, true ) ) {
			continue;
		}

		if ( is_plugin_active_for_network( $p ) ) {
			continue;
		}

		if ( ! isset( $stats[ $p ] ) ) {
			$stats[ $p ] = array();
		}

		$stats[ $p ][] = $home;

		$data[ $home ][] = $p;
	}
}

print_r( $stats );
print_r( $data );
