Title: Need Database Support
Last modified: August 20, 2016

---

# Need Database Support

 *  Resolved [wbxpress](https://wordpress.org/support/users/wbxpress/)
 * (@wbxpress)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/need-database-support/)
 * I have installed this useful plugin.
 * In my blog there are 4000+ users.
    Is there any shortcut method to change user
   settings default notification ON from the database.
 * Which table, which field is to be edited?
 * N.B: I guess table is wp_usermeta
 * [http://wordpress.org/extend/plugins/email-users/](http://wordpress.org/extend/plugins/email-users/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Mike Walsh](https://wordpress.org/support/users/mpwalsh8/)
 * (@mpwalsh8)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/need-database-support/#post-3382074)
 * Yes, the user setting are stored as User Meta data. Each user has two values,
   one for Mass Email and one for Post/Page Notifications. When set to ‘true’ (the
   ascii string) the user will receive email.
 * You can use the User Settings menu under the Email Users tab on the Dashboard
   to bulk set your 4000+ users to a known state. By default only 20 users are displayed
   at a time but you can change the value on plugin settings page so you can operate
   on a larger group of users at one time. I have set as high as 500 and while the
   page is a little slow to load, it does load.
 * Alternative, if you know had to manipulate user meta data with SQL you could 
   do that but I don’t know the actual query off the top of my head, I’d have to
   play with it.
 *  Thread Starter [wbxpress](https://wordpress.org/support/users/wbxpress/)
 * (@wbxpress)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/need-database-support/#post-3382076)
 * If it is possible to make the changes from editing plugin files, then it would
   be better. Please let me know which file of the plugin is to be edited to change
   the value 20 to 500.
    Thanks for your early reply.
 *  Plugin Author [Mike Walsh](https://wordpress.org/support/users/mpwalsh8/)
 * (@mpwalsh8)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/need-database-support/#post-3382088)
 * Anything is possible if/when you want to hack the plugin. Not sure why it would
   be better that using the existing UI to change the setting that is explicitly
   for this purpose.
 * In the email-users.php file there is a function that defines the default plugin
   settings and returns them as an array. However, once the default setting is saved
   in the database, it will always override the default setting in the code. The
   easiest way to do what you want is to use the Settings UI to change the value.
 *  Thread Starter [wbxpress](https://wordpress.org/support/users/wbxpress/)
 * (@wbxpress)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/need-database-support/#post-3382091)
 * Oh I got it.
 * Actually I was missing the Settings UI to change the value.
    Its solved now. 
   Thanks.
 *  Plugin Author [Mike Walsh](https://wordpress.org/support/users/mpwalsh8/)
 * (@mpwalsh8)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/need-database-support/#post-3382093)
 * Excellent.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Need Database Support’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/email-users_a0e0cf.svg)
 * [Email Users](https://wordpress.org/plugins/email-users/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/email-users/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/email-users/)
 * [Active Topics](https://wordpress.org/support/plugin/email-users/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/email-users/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/email-users/reviews/)

## Tags

 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * 5 replies
 * 2 participants
 * Last reply from: [Mike Walsh](https://wordpress.org/support/users/mpwalsh8/)
 * Last activity: [13 years, 3 months ago](https://wordpress.org/support/topic/need-database-support/#post-3382093)
 * Status: resolved