• 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?

caliman

Active member
#1
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
 
S

Syndol

Guest
#2
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:

caliman

Active member
#3
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.