WordPress.org

Ready to get started?Download WordPress

Forums

Email Users
[resolved] Need Database Support (6 posts)

  1. wbxpress
    Member
    Posted 1 year ago #

    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/

  2. Mike Walsh
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  3. wbxpress
    Member
    Posted 1 year ago #

    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.

  4. Mike Walsh
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  5. wbxpress
    Member
    Posted 1 year ago #

    Oh I got it.

    Actually I was missing the Settings UI to change the value.
    Its solved now. Thanks.

  6. Mike Walsh
    Member
    Plugin Author

    Posted 1 year ago #

    Excellent.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags