Extracting user emails

[KOREntertainment]

I did a search and the topics that I found did not help.  I am not that educated with pho so it's like another language to me.  How can I extract emails from all users.  The t

[Sami]

Why do you need user's email anyway ?

[Joachim Müller]

Describe in detail what you're up to. "Extract emails" is not a technical term. Do you want to use the email addresses of your users and use them on another page, or display them somewhere else? If yes, post details what you would like to do: where should they appear and for whom?

[KOREntertainment]

ok, my photo gallery has over 6,000 members, I am going to change servers but this time I am going to bridge my message board with my gallery and I will like to send everyone a detailed message as to what will be going on with the move and what they should do.

[Pascal YAP]

Morning,

If you want catch all of your users's emails, you can try to use this simple script.
Output email list is in text mode.
Copy and Past this code and name it with a nice name for you, expl "view-user-email.php"

Code Select Expand

<?php
define('IN_COPPERMINE', 1);
require 'include/init.inc.php';

$test = CPG_db_query("SELECT DISTINCT(user_email) FROM {$CONFIG['TABLE_USERS']} WHERE user_email <> ''");
while ($row = mysql_fetch_assoc($test))
echo $row['user_email'] . "<br />";
?>

PYAP

[KOREntertainment]

I'm sorry but can U be more specific?  I am not too familiar with php, I do html but where am I pasting it?  Am I pasting it in a plain php page and then what?

[Sami]

open notepad (for windows) or any simple text editor and put PYAP's code and save it to your gallery root and then run it

[Pascal YAP]

This script is a standalone file !
Copy my entire code, and past it in a blank new file.
Name this new file as you want. (if you want : view-user-email.php)
Place this new file on the Coppermine's root.
With your browser, type ht tp://your-gallery-url/view-user-email.php

If you have 6000 users, the output will have 6000 lines 
That's all.

PYAP

[KOREntertainment]

Wow it worked, I tried something like this before but I was not successful.  Thanks all I really appreciate it.

[Pascal YAP]

Thanks all I really appreciate it.

Happy for you 

And now, what are you doing with this TXT list ?
Do you want to use it with Excel or something like that ?

PYAP