Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: getting users emails  (Read 3253 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.