mailpoet-multisite.php

<?php
/*
Plugin Name: Multisite Hacks for MailPoet
Version: 1.1
Description: Example but DOES NOT SEEM TO WORK WITH THE LATEST MAILPOET VERSION. My recommended alternative to MailPoet https://rsvpmaker.com/blog/2022/08/27/rsvpmaker-postmark-free-email-marketing/
*/

function mailpoet_site_subscribers () {
    if(!strpos($_SERVER['REQUEST_URI'],'mailpoet'))
        return;
    global $wpdb;
    $segment_table = $wpdb->prefix.'mailpoet_segments';
    $subscriber_segment_table = $wpdb->prefix.'mailpoet_subscriber_segment';
    $subscribers_table = $wpdb->prefix.'mailpoet_subscribers';
    $where = ' WHERE 1 ';

    $sql = "SELECT * FROM `$subscriber_segment_table` JOIN `$segment_table` ON `$subscriber_segment_table`.`segment_id`= `$segment_table`.id WHERE `$segment_table`.type != 'wp_users' ORDER BY `wpt_109_mailpoet_subscriber_segment`.`segment_id` ASC #toastmost";
 	$results = $wpdb->get_results($sql);
	if(empty($results))
		return;
	foreach($results as $row)
    {
        $sub[] = $row->subscriber_id;
        $where .= " AND id != ".$row->subscriber_id;
    }
    //update_option('mailpoet_club_subscribers',$sub);
    $sql = "DELETE FROM $subscribers_table ".$where.' #toastmost';
    $wpdb->query($sql);
    $sql = "SELECT * FROM $segment_table";
    $results = $wpdb->get_results($sql);
    $sw = ' WHERE 1 ';
    foreach($results as $row) {
        $sw .= ' AND segment_id !='.$row->id;
    }
    $sql = "DELETE FROM $subscriber_segment_table $sw  #toastmost";
    $wpdb->query($sql);
}

add_action('admin_notices','mailpoet_site_subscribers',1);

function mailpoet_toastmost_notice() {
	$uri = $_SERVER['REQUEST_URI'];
	if(!strpos($uri,'mailpoet') || strpos($uri,'plugins.php'))
		return;
	
	$timestamp = wp_next_scheduled( 'toastmost_email_list_cron' );
	if($timestamp)
		return; // don't show if invitations are going out now
	global $wpdb;
	$segments_table = $wpdb->prefix.'mailpoet_segments';
	$subscriber_table = $wpdb->prefix.'mailpoet_subscribers';
	$subscriber_segment_table = $wpdb->prefix.'mailpoet_subscriber_segment';
	$deleted = date('Y-m-d H:i:s');
	$sql = "DELETE FROM $segments_table WHERE type='wp_users' ";
	$wpdb->query($sql);
	$sql = "UPDATE $segments_table set description='For communication with club members' WHERE type='default'";
	$wpdb->query($sql);
	$results = $wpdb->get_results("SELECT * FROM $subscriber_table #toastmost");
	$current_list = array();
	foreach($results as $row) {
		$current_list[] = strtolower($row->email);
	}
	$unsub = get_option('rsvpmail_unsubscribed');
	if(is_array($unsub))
	foreach($unsub as $email)
		$current_list[] = $email;
	$members = get_site_users();
	$count = 0;
	$csv = '';
	foreach($members as $member) {
		$user = get_userdata($member->ID);
		if(in_array(strtolower($user->user_email),$current_list))
			continue;
		$subscriber = array('email' => $user->user_email, 'first_name' => $user->first_name, 'last_name' => $user->last_name);
		$csv .= "$user->user_email,$user->first_name,$user->last_name\n";
		$subscribers_to_add[] = $subscriber;
	}
	if(isset($_POST['add_club_members']))
	{
		wp_schedule_event( strtotime('+2 minutes'), 'doubleminute', 'toastmost_email_list_cron' );
		echo '<div class="notice notice-success">Email list invitations will be sent to members over the next several minutes.</div>';
		return;
	}
	if(!empty($subscribers_to_add))
		printf('<div class="notice notice-info"><form method="post" action="%s"><p><input type="hidden" name="add_club_members" value="1"><button>Update List</button> - updates Club Members email list. Members will need to confirm. %d members are not yet on the list.</p></form><pre>%s</pre></div>',site_url($uri),sizeof($subscribers_to_add),$csv);
}

add_action('admin_notices','mailpoet_toastmost_notice');

add_action('toastmost_email_list_cron','toastmost_email_list_cron');
function toastmost_email_list_cron() {
global $wpdb;
$subscriber_table = $wpdb->prefix.'mailpoet_subscribers';
$results = $wpdb->get_results("SELECT * FROM $subscriber_table");
$current_list = array();
foreach($results as $row) {
	$current_list[] = strtolower($row->email);
}
$unsub = get_option('rsvpmail_unsubscribed');
if(is_array($unsub))
foreach($unsub as $email)
	$current_list[] = $email;
$members = get_site_users();
$count = 0;
foreach($members as $member) {
	$user = get_userdata($member->ID);
	if(in_array(strtolower($user->user_email),$current_list))
		continue;
	$subscriber = array('email' => $user->user_email, 'first_name' => $user->first_name, 'last_name' => $user->last_name);
	$subscribers_to_add[] = $subscriber;
}
	if(empty($subscribers_to_add)) {
		$timestamp = wp_next_scheduled( 'toastmost_email_list_cron' );
		wp_unschedule_event( $timestamp, 'toastmost_email_list_cron' );
		return;
	}
	$list_ids = array(3);
	$mailpoet_api = \MailPoet\API\API::MP('v1');
	$count = 0;
	$subscribers_to_add = array_slice($subscribers_to_add,0,5);
	
	foreach($subscribers_to_add as $subscriber) {
		try {
			$get_subscriber = $mailpoet_api->getSubscriber($subscriber['email']);
		  } catch (\Exception $e) {}			
		  try {
			if (!$get_subscriber) {
			  // Subscriber doesn't exist let's create one
			  $mailpoet_api->addSubscriber($subscriber, $list_ids);
			  //printf('<div class="notice notice-success">%s added</div>',$subscriber['email']); 
			} else {
			  // In case subscriber exists just add him to new lists
			  $mailpoet_api->subscribeToLists($subscriber['email'], $list_ids);
			  //printf('<div class="notice notice-success">%s added</div>',$subscriber['email']); 
			}
		  } catch (\Exception $e) {
			$error_message = $e->getMessage();
			//printf('<div class="notice notice-error">%s</div>',$error_message); 
		  }
	}
}

function get_site_users( $blog_id = 0 ) {

	if ( empty( $blog_id ) ) {

		$blog_id = get_current_blog_id();
	}

	return get_users(
		array(
			'blog_id' => $blog_id,
			'orderby' => 'display_name',
		)
	);

}

I'm afraid so. I hadn't found a way to prevent MailPoet from adding the whole user table to your subscriber list, so I was trying to instead automate the process of removing those entries. It was a crude hack, and it seems to have broken with the latest update.

As I mentioned, I've been working on an alternative to MailPoet for my own clients that explicitly supports multisite.