prepare( "SELECT COUNT(*) as members FROM $wpdb->pmpro_memberships_users WHERE user_id IN (%s)", implode( "," , $userids ) ); $member_history = $wpdb->get_var( $sqlQuery ); // Make sure that there is actually PMPro content to delete for these users. if ( empty( $userids_have_levels ) && empty( $member_history ) ) { // No PMPro content to delete, so we don't need to add anything to the form. return; } $allowed_html = array( 'strong' => array() ); ?>

1 ) { echo '

' . wp_kses( __( 'Warning: One or more users for deletion have an active membership level.', 'paid-memberships-pro' ), $allowed_html ) . '

' ; } else { echo '

' . wp_kses( __( 'Warning: This user has an active membership level.', 'paid-memberships-pro' ), $allowed_html ) . '

'; } ?>

0 ) { ?>

delete( $wpdb->pmpro_memberships_categories, array( 'category_id' => $cat_id ), '%d' ); } add_action( 'delete_category', 'pmpro_delete_category' ); // deleting a post? remove any level associations function pmpro_delete_post( $post_id = null ) { global $wpdb; $wpdb->delete( $wpdb->pmpro_memberships_pages, array( 'page_id' => $post_id ), array( '%d' ) ); } add_action( 'delete_post', 'pmpro_delete_post' ); /** * Delete all membership data for a specific user from the membership users table. * * @param int $user_id The WordPress user ID. * @since 2.10 */ function pmpro_delete_membership_history( $user_id ) { if ( empty( $user_id ) ) { return false; } global $wpdb; $wpdb->delete( $wpdb->pmpro_memberships_users, array( 'user_id' => $user_id ), array( '%d' ) ); // we don't remove the orders because it would affect reporting }