CUNY Academic Commons

<?php

global $wpdb;

$tables = $wpdb->get_col( "SHOW TABLES LIKE '%actionscheduler_logs%'" );

$as_plugins = [

	'easy-wp-smtp/easy-wp-smtp.php',

	'event-tickets/event-tickets.php',

	'pdf-embedder/pdf_embedder.php',

	'the-events-calendar/the-events-calendar.php',

	'widget-for-eventbright-api/widget-for-eventbright-api.php',

];

foreach ( $tables as $table ) {

	$matched = preg_match( '/^' . $wpdb->base_prefix . '([0-9]+)_/', $table, $matches );

	if ( ! $matched ) {

		continue;

	}

	$site_id = (int) $matches[1];

	$needs_as_tables = false;

	switch_to_blog( $site_id );

	foreach ( $as_plugins as $as_plugin ) {

		if ( is_plugin_active( $as_plugin ) ) {

			$needs_as_tables = true;

			break;

		}

	}

	restore_current_blog();

	if ( ! $needs_as_tables ) {

		WP_CLI::log( "Dropping Action Scheduler tables for site ID {$site_id}." );

	} else {

		WP_CLI::log( "Keeping Action Scheduler tables for site ID {$site_id}." );

	}

}