Members E-mail List?

[Vixxxen]

Just wondering if there was any way (hack) to be able to get a list of all the members email addresses without having to look each member up one at a time.
I did a search for this topic and didn't come up with anything so any help would be appreciated.
Thanks.

[Tranz]

If you know mysql, you should be able to get it from the user table.

Here's the code:

Code Select Expand

SELECT user_name, user_email
FROM `cpgprefix_users`

[Nibbler]

http://coppermine-gallery.com/forum/index.php?topic=1228.msg58625#msg58625