1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL select to grab emails of members registered after x date?

Discussion in 'General PHP and MySQL Discussions' started by caliman, Jun 15, 2014.

  1. caliman

    caliman Active Member

    I used to be able to do this with vB. Not sure how to do this with xF yet.

    SQL select to grab emails of members registered after x date?

    I would like to do the above - excluding banned members + members with < 1 post...

    and export to a text file. This is all via command line.

    Thanks in advance. This would be a big time saver for me.

    matt
     
  2. Syndol

    Syndol Guest

    Why not use the ACP function 'Email Users' to generate a mailing list?
    That form allows you to select registration date and post count.

    Edit:
    SELECT email FROM xf_user WHERE message_count > 1 AND is_banned = 0 AND register_date > UNIX_TIMESTAMP('2014-03-15 09:00:00')

    Change the date as required.
     
    Last edited by a moderator: Jun 15, 2014
  3. caliman

    caliman Active Member

    Thanks and thanks!
    Can you tell I am a newbie that just turned my site on recently? lol
    I had no idea I could do that in the admin panel. That worked great. Thanks again.
     
    Syndol likes this.

Share This Page