Announcement

Collapse
No announcement yet.

Exporting emails

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Exporting emails

    How do I query the database and take the emails from the users table, but excluding those that checked the option to not allow admin to send emails?

    Also, how do I via a query check or uncheck that option for a user?

    Reason I ask, is that I need to setup an form that allows for signup and removal from a newsletter without having to be logged in. Just to signup or remove the email from future sendings.

  • #2
    Are you refering to vB when you mention the "option to not allow admin to send emails"?
    while(true){
    if(
    $someone->needsHelp() && $i->canHelp()) $post->help();
    if(
    $i->findBug()) $post->bug();
    }

    Comment


    • #3
      All Users with accept admin Mails on:
      Code:
      select email from user where (options & 16) != 0
      toggle for an email:
      Code:
      update user SET options=(options^16) where email="[email protected]"
      on:
      toggle for an email:
      Code:
      update user SET options=(options|16) where email="[email protected]"
      off:
      toggle for an email:
      Code:
      update user SET options=(options&~16) where email="[email protected]"
      Im not sure if this works, so u should be careful with this!

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X