Icy Phoenix

Old Support Topics - Users Email Addresses And Retrieving Them

darkone [ Fri 19 Oct, 2007 20:35 ]
Post subject: Users Email Addresses And Retrieving Them

Hey Everyone

I know ICY has emailing options for mailing all the users that are members. Is there a way to get just the emails of all the users and export them to a file? What would I have to do to get this information.

I wanted to get this list to send out emails to the user base that say my install is going to take longer or having issues with the provider that I can still send an email if I don't have access to ICY.

Thanks

-D1-

novice programmer [ Sat 20 Oct, 2007 12:19 ]
Post subject: Re: Users Email Addresses And Retrieving Them

darkone wrote: [View Post]
Hey Everyone

I know ICY has emailing options for mailing all the users that are members. Is there a way to get just the emails of all the users and export them to a file? What would I have to do to get this information.

I wanted to get this list to send out emails to the user base that say my install is going to take longer or having issues with the provider that I can still send an email if I don't have access to ICY.

Thanks

-D1-

Try to export the mails from the db with a sql db manager.

Zuker [ Tue 23 Oct, 2007 22:30 ]
Post subject: Re: Users Email Addresses And Retrieving Them

There it's a mod that export al mail adreses from users table in a .cvs file

i'm sure that this question was answered before and the mod it's posted in that topic

christmanrd [ Fri 23 Apr, 2010 21:25 ]
Post subject: Re: Users Email Addresses And Retrieving Them

Mighty Gorgon [ Sat 08 May, 2010 12:36 ]
Post subject: Re: Users Email Addresses And Retrieving Them

In phpMyAdmin you can just run this SQL:

Code: [Hide] [Select]

SELECT user_id, username, user_email FROM `phpbb_users`

Then at the bottom of the page you should have a command to export the result of the query...

Informpro [ Sat 08 May, 2010 19:17 ]
Post subject: Re: Users Email Addresses And Retrieving Them

A Up from 2007 by christmanrd ?

Lopalong [ Sun 09 May, 2010 13:05 ]
Post subject: Re: Users Email Addresses And Retrieving Them

I already answered this here ->

http://icyphoenix.com/viewtopic.php?p=48814#p48814

Informpro wrote:
A Up from 2007 by christmanrd ?

@ Informpro So what? - The question was there to be re-visited - Apparently your right hand doesn't know what your left hand is doing? So why not actually try to support what is being asked instead of submitting your own brand of useless or cryptic comments?

spydie [ Sun 09 May, 2010 13:21 ]
Post subject: Re: Users Email Addresses And Retrieving Them

IMHO.

It does´nt matter from when the post is, since this issue is not Version related.

means that it´s the same in all versions, only difference may be in the consult to run.

And it shows us antother thing aswell. He did use search option, to don´t double post the same issue

Mighty Gorgon [ Sun 09 May, 2010 20:42 ]
Post subject: Re: Users Email Addresses And Retrieving Them

Topic solved... and locked!