getting users emails getting users emails
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

getting users emails

Started by KOREntertainment, November 27, 2010, 02:13:14 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

KOREntertainment

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

Αndré

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

KOREntertainment

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

Αndré

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

KOREntertainment

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

KOREntertainment

Quote from: Αndré on November 27, 2010, 09:24:21 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.

Laicodc

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

Αndré

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.