https://www.icyphoenix.com/viewtopic.php?f=35&t=2960
-----------------------------------
darkone
Fri 19 Oct, 2007 20:35

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

Re: Users Email Addresses And Retrieving Them
-----------------------------------
[quote user="darkone" post="20601"]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-[/quote]

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


-----------------------------------
Zuker
Tue 23 Oct, 2007 22:30

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

Re: Users Email Addresses And Retrieving Them
-----------------------------------
..


-----------------------------------
Mighty Gorgon
Sat 08 May, 2010 12:36

Re: Users Email Addresses And Retrieving Them
-----------------------------------
In phpMyAdmin you can just run this SQL:

[codeblock]SELECT user_id, username, user_email FROM `phpbb_users`[/codeblock]

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

Re: Users Email Addresses And Retrieving Them
-----------------------------------
A Up from 2007 by christmanrd ?


-----------------------------------
Lopalong
Sun 09 May, 2010 13:05

Re: Users Email Addresses And Retrieving Them
-----------------------------------
I already answered this here ->

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

[quote=Informpro] A Up from 2007 by christmanrd ?[/quote]

@ 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

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

Re: Users Email Addresses And Retrieving Them
-----------------------------------
Topic solved... and locked! :mricy:


