[Invalid]: extract member emails

[KOREntertainment]

Hello everyone...
I have "Coppermine Photo Gallery v1.4.18:"  I have 2 seperate data bases.  I have the script to extract the emails from the 1st gallery but not from the second, can someone point me in the right direction?

The directory is www.korentertainment.net/gallery2

Thanks in advance

[phill104]

The first thing you need to do is upgrade to the latest revision

http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#upgrade_why

[KOREntertainment]

ok it is now updated.

[Stramm]

You need to change your script to use the database name/user/password of your second gallery

[KOREntertainment]

Ok I have no clue as to how to do that.
I do not know anything about php.

Can U pont out what I am to do?

[KOREntertainment]

This is all I see.

I have 2 galleries,
first one is http://korentertainment.net/gallery
Second one is http://korentertainment.net/gallery2

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

[Stramm]

copy the file into your 2nd galleries root and call it with your webbrowser... that should do

[KOREntertainment]

I did that long ago and it didn't work.

[KOREntertainment]

copy the file into your 2nd galleries root and call it with your webbrowser... that should do

This is the message I'm getting

Not in Coppermine...
Fatal error: Call to undefined function: cpg_db_query() in /home/content/a/r/w/arwilliams/html/gallery2/view-user-email.php on line 5

[Stramm]

try that

Code Select Expand

<?php
define('IN_COPPERMINE', true);
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 />";
?>

[KOREntertainment]

I tried that and it extracted one email address "admin@mail.com"

[Stramm]

Your code... I just changed the function name to a valid one (one that exists).

Nevertheless it works for me.

[Nibbler]

That gallery is bridged. You need to be extracting the emails from the forum not from Coppermine.

[KOREntertainment]

I'm assuming that I have to go to the support forum for my message board for that right?

[Joachim Müller]

Right.
Marking thread as "invalid".