I know it was asked a long time ago. But just a tip for others who see this.
You can use global $wpdb in any wordpress file to access the pre-defined class. If you know sql you can create a custom query to find active or inactive memberships from one of the memberpress tables.
For reaccuring memberships: $wpdb->prefix.’mepr_subscriptions’
For non-reaccuring: The table is $wpdb->prefix.’mepr_transactions’. It has all the past and current transactions for every user, so you would have to ensure your query only grabs the most current one.
You should consider staging the site and using phpmyadmin to set up the query.
goodluck.
Related Posts:
- When unit testing a plugin, does the plugin need to be in the wp-content/plugins directory of the WordPress tests install?
- WordPress sharding: which multi-DB plugin to use?
- How do I disable a plugin enforced by my host (in mu-plugins)?
- Need to create a Theme demo site that features multiple themes
- Is there a plugin to show the code tag button on the visual editor?
- Do Plugins effect site loading time?
- Adding Featured Image in Post List
- How do I check what plugins are enabled via the database?
- Posts wont expire
- Should I use RIPS tool to test my themes and plugins?
- Add Top-Level Menu that opens URL
- How to disable autocomplete for inputs in contact form 7? [closed]
- How Restrict access to admin dashboard by specific static ip?
- Override Theme CSS with CSS from a plugin
- How to limit 1 image per post on homepage only?
- Building WordPress Plugin Using FPDF – How do you get post content from currently viewed post?
- Storing Email Account Passwords for SMTP Mailing for a WordPress Plugin
- action-scheduler vs wp-background-processing
- How to get images from EDD post?
- Popup Cookie WordPress select language and section (Elementor)
- Remove filter from WordPress Plugin
- Gutenberg List Extension Block
- Do you clean up your self-written plugins’ at deactivation?
- Will Flutter work with WordPress 3.0?
- Regenerate images with automatic ALT and TITLE attributes
- Function to see how many plugins on a site need updating
- How many SQL queries WP Super Cache make to serve cached page?
- How to make an interface similar to multi-site for switching between multiple (single) sites for administrators?
- Advice for a voting / multiple rating plugin for post types other than GD Star Rating [closed]
- Any hook for pre-plugin-update -either bulk or single plugin update
- wp_create_nonce function doesn’t work inside a plugin?
- Is there an easy way to flag posts in the admin area?
- When to load auto-login code?
- Events Plugin that works with existing categories?
- Custom post type – no layout section of Document tab, and no author choice
- Creating a custom post type, adding custom meta fields, preventing all future editability of posts of this type
- WordPress shows error related to allow_url_fopen
- Delete mobile menu button [closed]
- Widgets Scripts don’t load – but load when I reload the page
- Error when using plugin QuickCache with plugin Mobile Smart ? [closed]
- URL rewrite of independent plugin?
- How do post a Photo to Facebook when a post is published? [closed]
- Opening a link automatically on page load?
- How to display number of page views on a post?
- What is a reasonable memory limit for WordPress
- Get plugin download URL from slug
- Using add_action before add_filter on a plugin?
- How can a wordpress plugin generate pages without posts?
- Calling the_excerpt from inside a plugin template file
- How to multiply a post to test internal search results?
- Is there a plugin for automatically adding a word or symbol after a trigger word? I.e. Like a search and replace but more like search and add? [closed]
- Product count in archive page Title in WooCommerce [closed]
- wp-admin send 404 error
- 5 PHP Fatal error: Uncaught ArgumentCountError (Cannot Find)
- Blog previews on custom page with more buttons
- Customize Menu | Styling LESS/SCSS code formats
- How I update WordPress theme and plugins
- WordPress Mailerlite – How to include mailerlite SDK in plugin
- How to Use the Filter “sidebar_login_widget_form_args”
- Plugin option default value
- Posts 2 Posts: Display custom types connected to the same other custom type but with another connection
- Post via git repository
- restrict subscribers to admin area. They have their own profile on fron-end
- Woocommerce Export and import Orders
- acf backend error handling
- How to get the custom field value using SQL query
- Add a Custom email notification to WC actions
- specific rows style for in custom list table using WP_List_Table
- How to turn my WordPress site into a ready to deploy template?
- How to fetch WordPress database values in JavaScript widget
- Homepage to serve the content of page created from a plugin [duplicate]
- WordPress: Can’t connect to the Akismet servers
- Conditionally load public and admin code with AJAX working on both sides
- Disabling drift plugin from homepage
- return bbp_get_topic_author_id as integer
- Modify function output in a plugin
- Why can’t I call a function from inside my registered AJAX function?
- Problem in functions.php file
- I want add repository theme folder
- WordPress Widget: Is it possible to make the form dynamic without updating?
- Quick Edit in custom posts no show columns after save
- How to hide the form after successful php execution
- WP Rest API v2.0 user profile update issue
- Change default url to plugin custom post type
- Site is continuously accessing by several IPs
- Moving to WordPress Premium versus a hosting provider
- Is there a way to upload an external folder in WordPress?
- How to find an option in the database?
- Need Help Creating a Multi-Step, Video-Guided Enrollment Site
- woocommerce_payment_complete hook only called after accepting payment?
- how to sort results by last day update at search result in plugin installer?
- User specific content (posts) / limiting visibility
- Carrying information from button click into form [closed]
- ajax sends data to plugin
- Making a Custom Post Type Publish Loop
- Want to add post to user dashboard
- WordPress Plugin: Demon Image Annotation
- Facebook like plugin with Multi Option-Needed [closed]
- woocommerce create subscription for user using functions / hooks provided
- Someone Comment 1000 times in a Day in My WordPress Site, What Can i Do