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: getting users emails  (Read 3290 times)

0 Members and 1 Guest are viewing this topic.

KOREntertainment

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 72
getting users emails
« on: November 27, 2010, 02:13:14 am »

I have a script for my 2009 gallery that extracted my members emails, I would like one for my 2010 gallery.  Thanks in advance.

http://korentertainment.net/gallery2/index.html
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: getting users emails
« Reply #1 on: November 27, 2010, 08:18:54 am »

Attach that script, so we don't have to start from scratch.
Logged

KOREntertainment

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 72
Re: getting users emails
« Reply #2 on: November 27, 2010, 09:23:21 am »

<?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 />";
?>
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: getting users emails
« Reply #3 on: November 27, 2010, 09:24:21 am »

What exactly doesn't work when you copy that script to your new gallery?
Logged

KOREntertainment

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 72
Re: getting users emails
« Reply #4 on: November 27, 2010, 09:25:54 am »

For some strange reason after all this time, I ran the script and it actually worked.
Logged

KOREntertainment

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 72
Re: getting users emails
« Reply #5 on: November 27, 2010, 09:29:51 am »

What exactly doesn't work when you copy that script to your new gallery?
I use to get an error message, I don't recall what it said, it's been a while but it's working now.  smh thanks.
Logged

Laicodc

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: getting users emails
« Reply #6 on: December 20, 2010, 08:36:04 pm »

How do you add that script so you can download the user emails?  Which file and what location. Thanks in advance.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: getting users emails
« Reply #7 on: December 20, 2010, 08:55:30 pm »

Copy the code to some text file and rename it to whatever.php. Then upload it to your gallery root and open it with your web browser.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.