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:
- Override WordPress user with Oauth2 account
- Custom Filter in WordPress to modify footer information via plugin?
- Is it heavyweight plugins or lots of plugins that make a site slow?
- Why does wp_enqueue_style() in plugin not load stylesheet?
- Admin plugin, how can I output a different content-type?
- Editor access to plugin settings
- Network-Wide Plugin Settings Management
- Has anyone been able to get the aweber plugin to work
- Use Media Uploader in Plugin
- wp_nav_menu(); Outside WordPress installation
- Install plugin remotely
- Woocommerce: Changing the variations select default value? [closed]
- Best Apache Log Analyzer Plugin? [closed]
- Akismet plugin is deleting spam despite preferences
- Star rating for custom post types [closed]
- How to Make a Custom Grid View
- How WordPress knows where to find locale files?
- Can wp_script_is used in pluginA check if a script is being enqueued/registered from pluginB?
- Reuse javascripts from plugins within the theme
- WP theme with Backbone
- $wpdb working with ajax but showing ajax error instead of success
- Inserting large amounts of data into a custom table during plugin install
- WP-Markdown treating java generics like HTML tags
- Can’t get title of latest post
- Display success message after wp_update_post
- Global variables during plugin activation , deactivation and uninstall operarations
- Need help restoring my WordPress blog
- Should I fetch the data managed by a plugin by using its APIs or WordPress APIs?
- Use translated taxonomy labels in plugin
- Hiding posts – WP Hide Post not working
- Plugin appends ugly URL string to index
- Scripts at the end of the page
- WSOD after upgrading to 3.1
- looking for navigation plugin (accordion) [closed]
- When using Simple Fields plugin, how do I pull the information out of the database to display on a page?
- White page by using filter template_include
- WordPress Keeps Logging Out – What Tests Can I Run to Solve This?
- How to use JSON data from URL into table on my wordpress website
- WordPress Payment gateway add on form , how to add form into list or else how to submit form to next step for payment
- How WordPress is able to change locale without using setlocale
- How to Create a shortcode to this php function
- I should enable automatic updates?
- Access a particular field in an array
- How to add CSS via custom plugin?
- How to add custom table style for table block in gutenberg editor
- plugin shortcode not working on ajax request call
- One sub site is slow while all others load fine, same theme & plugins [closed]
- Issues with a WP plugin menu system
- Affect on speed of wordpress membership plugins — currently trying s2member
- JQuery prepend a function
- How to check wp_options’s rewrite_rules if current and existing are the same before flush the rules?
- WordPress Ajax code is not Working
- Clear out old images, any advice?
- problem with sql query
- Add a “View all” button on WooCommerce product archives pages
- I am trying to make a field show and save from quickedit screen
- What goes into wp_postmeta and why?
- Woocommerce product info in a sidebar?
- output the debug lines to the end of the page
- A question of etiquette when forking a plugin? [closed]
- how to request a script more than once in wordpress
- WordPress Plugin for pastimes/participation in contest [closed]
- Plugin to create unlimited custom shortcodes?
- How do I create pages within a WordPress post?
- Gutenberg default attributes are empty when accessing in edit
- Ajax 400 error when used inside a plugin
- How to add custom plugin data to the cart in woocommerce using custom button on product page?
- How can I display selected content from a seperate database in an Activity style widget?
- how to show all posts of each category in pages
- Error thrown Call to a member function get() on null
- Allowed memory size of 134217728 … wp-includes/wp-db.php on line 1989
- Pricing Calculator – WordPress
- reminder wp_schedule_event
- Undefined offset: 0 in WordPress after latest version upgrade [closed]
- Make the product page as homepage WooCommerce
- Adding shortcodes to multiple pages with function
- Genesis Child Theme – Customize body
- Media Dialog CSS broken in WP v.5.3.2
- Multiple wordpress installations with same plugin folder (Apache Virtualhost)
- Slide through page effect?
- Get a list of Product Categories inside a loop
- How to update plugins in a distributed wordpress scenario?
- What’s the preferred method of writing AJAX-enabled plugins?
- WordPress API hook
- jquery conflict with widget page
- Automatically add child pages to menu
- Infinite Scroll plugin scrolling truly “infinitely” (i.e. does not recognize end of posts)
- Simple Data Table Update and Page Integration
- How to add a box for list items?
- wp_update_post call really slow when official Facebook plugin is installed
- Woocommerce custom fields
- This plugin throws error on the events page only [closed]
- White Screen When Includding A Folder With PHP Files
- making a simple plugin
- Is it possible to set different payment gateway on each Gravity Forms form? [closed]
- Custom single-product page for product from category x
- edit slider plugin capability for custom_role
- Plugin Block at the backend of every page or post
- Custom Login and Password Reset for BuddyPress Website
- How to add a react element into the DOM node (only on the user-interaction like on click) without using the state?