Can you rerun the subscription pings

Is there an easy way to rerun the subscription pings? We weren't able to get them working properly before launch so there are a number of accounts that didn't go through that process. It would be nice to be able to rerun them.

Vaughan
- Support/SLS MockingJay: Earn your WPMU DEV membership
- 3,094 pts: Hero points 22,938 pts: Rep. points LEVEL 30
Hi @Cagle Webmaster,

Hope you're well?

I'm not sure this is possible out of the box, as the pings are fired on a specific action, so i'm not sure how that process works exactly, let me just ask one of the developers to clarify this for you & see if there's a possible quick solution.

Thanks
Cagle Webmaster
- The Incredible Code Injector: Earn your WPMU DEV membership
- 114 pts: Hero points 321 pts: Rep. points LEVEL 5
I would presume I could just loop through the subscribers (though I'm not sure how to get the query just right for that) and fire the pings if I knew which code to run to do that. So I guess the secondary question for your dev team is what is the best way to get a list of subscribers and how do I fire off the ping. Knowing that I could handle the rest.

Jude

DEV MAN: Earn your WPMU DEV membership

1,218 pts: Hero points 11,004 pts: Rep. points LEVEL 28

Hi again @Cagle Webmaster,

Hope you're doing great.

Here is a function that does this with some commetnts

// Function to get a list of users based on date joined / subscription type / level etc and refire pings

	function refire_pings()
	{
		global $wpdb;
	   		$query = "SELECT  ID , sub_id, level_id, user_email, user_login ,display_name
				                           FROM  wp_m_membership_relationships
	                  			INNER JOIN  wp_users ON wp_m_membership_relationships.user_id = wp_users.ID
	                  			WHERE  startdate
	                  			BETWEEN  '2015-01-30 23:59:59'
	                   			AND  '2015-02-01 23:59:59'"

	  		$new_users = $wpdb->get_results($query);

	  		// Loop through the each user and fire respective ping
	    	foreach ($new_users as $user) {
	    		// Get the level for each user (perform conditionals here if needed)
	    		$level = Membership_Plugin::factory()->get_level( $user->level_id );

				// Get the Joining ping (can be any other ping type)
				$joiningping_id = $level->get_meta( 'joining_ping' );
					// Fire the pings
					if ( !empty( $joiningping_id ) ) {
						$ping = new M_Ping( $joiningping_id );
						$ping->send_ping( false, $user->level_id, $user->ID);
					}
	    	}
	   	return ;
	}

You can find some SQL variants here

Cheers
Jude