New to the community? Start here

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.

  • Jude

    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

Thank NAME, for their help.

1 Point
5 Points
15 Points
Other

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.