Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Extracting user emails  (Read 3909 times)

0 Members and 1 Guest are viewing this topic.

KOREntertainment

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 72
Extracting user emails
« on: November 08, 2007, 06:44:48 am »

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
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Extracting user emails
« Reply #1 on: November 08, 2007, 08:18:36 am »

Why do you need user's email anyway ?
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Extracting user emails
« Reply #2 on: November 08, 2007, 08:31:58 am »

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?
Logged

KOREntertainment

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 72
Re: Extracting user emails
« Reply #3 on: November 15, 2007, 04:18:17 pm »

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.
Logged

Pascal YAP

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 13833
  • Hello World :-)
    • CPG 1.5.x ExperiMental website
Re: Extracting user emails
« Reply #4 on: November 15, 2007, 04:37:01 pm »

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]
<?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
Logged

KOREntertainment

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 72
Re: Extracting user emails
« Reply #5 on: November 15, 2007, 05:04:12 pm »

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?
« Last Edit: November 15, 2007, 05:38:50 pm by PYAP »
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Extracting user emails
« Reply #6 on: November 15, 2007, 05:33:56 pm »

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
« Last Edit: November 15, 2007, 05:36:46 pm by PYAP »
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Pascal YAP

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 13833
  • Hello World :-)
    • CPG 1.5.x ExperiMental website
Re: Extracting user emails
« Reply #7 on: November 15, 2007, 05:36:12 pm »

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  ;D
That's all.

PYAP
Logged

KOREntertainment

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 72
Re: Extracting user emails
« Reply #8 on: November 15, 2007, 06:14:41 pm »

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

Pascal YAP

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 13833
  • Hello World :-)
    • CPG 1.5.x ExperiMental website
Re: Extracting user emails
« Reply #9 on: November 15, 2007, 06:33:22 pm »

Quote
Thanks all I really appreciate it.
Happy for you  ;D

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

PYAP
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.