How Do I generate an email list of new registrant this month?

You are not logged in. [Log In] UBB.threads Community » Forums » Managing & Customizing your Board » How do I? » How Do I generate an email list of new registrant this month?

Site Links

Top Posters (30 Days)

Latest Photos

Topic Options

Rate This Topic

#218466 - 10/27/08 07:19 PM How Do I generate an email list of new registrant this month?
24hourcampfire journeyman Registered: 11/02/06 Posts: 56	Hi Guys: I'm sending out a monthly newsletter using third-party software, and I'd like to generate a list of all new registrants for the month (since the last newsletter) so that I can add them to my sorted list. How To? Mysql command maybe? BTW, I'm running 7.1. Thanks! _________________________ Rick Bin 24hourcampfire.com http://www.24hourcampfire.com/ubbthreads/ubbthreads.php
Top

#218468 - 10/28/08 01:18 AM Re: How Do I generate an email list of new registrant this month? [Re: 24hourcampfire]
blaaskaak Registered: 08/30/06 Posts: 1316 Loc: Breda, NL	Method 1: Sql Query: SELECT USER_DISPLAY_NAME FROM ubbt_USERS WHERE USER_REGISTERED_ON >=1222560000 This works based on the date. You can calculate that date on this site. Method 2: I would prefer this one. Just make a note with each newsletter of the highest USER_ID and use this query: Sql Query: SELECT USER_DISPLAY_NAME FROM ubbt_USERS WHERE USER_ID >5000 _________________________
Top

#218472 - 10/28/08 07:35 AM Re: How Do I generate an email list of new registrant this month? [Re: blaaskaak]
driv Pooh-Bah Registered: 01/10/04 Posts: 1747 Loc: Essex, UK	Is there anyway that this could be tweaked to give a list of email addresses rather than usernames? _________________________ Oi Oi Saveloy! (Courtesy of Sd - well known Anglophile...!?!) My True star rating
Top

#218565 - 10/30/08 01:22 PM Re: How Do I generate an email list of new registrant this month? [Re: driv]
driv Pooh-Bah Registered: 01/10/04 Posts: 1747 Loc: Essex, UK	I guess I need this? SELECT USER_REAL_EMAIL FROM ubbt_USER_PROFILE but how do you tie it in with another table i.e. ubbt_USERS? SELECT USER_DISPLAY_NAME FROM ubbt_USERS WHERE USER_REGISTERED_ON >= ..... _________________________ Oi Oi Saveloy! (Courtesy of Sd - well known Anglophile...!?!) My True star rating
Top

#218568 - 10/30/08 01:42 PM Re: How Do I generate an email list of new registrant this month? [Re: driv]
blaaskaak Registered: 08/30/06 Posts: 1316 Loc: Breda, NL	Sql Query: SELECT t1.USER_DISPLAY_NAME,t2.USER_REAL_EMAIL FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2 WHERE t1.USER_ID=t2.USER_ID and t1.USER_ID >5000 Something like that, above is untested. _________________________
Top

Hop to:

Shout Box

Today's Birthdays