Home › Forums › WordPress Plugins › Reporting who has opted-out › Reply To: Reporting who has opted-out
December 20, 2016 at 8:37 am
#4880
vinny
Keymaster
Hi Genevieve,
Not at this time. I want to add it to version 2.0 which is coming, hopefully the first quarter of 2017. You can find out by running a DB query in phpMyAdmin or any other MySQL client. There’s even a plugin which is really handy: SQL Executioner.
This is the query:
select user_id, user_login from $wpdb->usermeta um join $wpdb->users u on (user_id = id) where meta_key = 'bbpnns_opted_out' and meta_value = 1
Just replace $wpdb->usermeta and $wpdb->users with the prefixed table names.
Cheers,
Vinny