Shop Forums WordPress Plugins Reporting who has opted-out Reply To: Reporting who has opted-out

#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