forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: KOREntertainment on November 24, 2008, 06:44:11 pm

Title: [Invalid]: extract member emails
Post by: KOREntertainment on November 24, 2008, 06:44:11 pm

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

Title: Re: extract member emails
Post by: phill104 on November 24, 2008, 08:24:52 pm

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

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

Title: Re: extract member emails
Post by: KOREntertainment on January 15, 2009, 02:43:39 am

ok it is now updated.

Title: Re: extract member emails
Post by: Stramm on January 15, 2009, 09:38:00 am

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

Title: Re: extract member emails
Post by: KOREntertainment on January 16, 2009, 02:48:44 pm

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?

Title: Re: extract member emails
Post by: KOREntertainment on January 16, 2009, 02:53:28 pm

This is all I see.

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

Quote

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

Title: Re: extract member emails
Post by: Stramm on January 16, 2009, 03:00:29 pm

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

Title: Re: extract member emails
Post by: KOREntertainment on January 16, 2009, 09:27:33 pm

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

Title: Re: extract member emails
Post by: KOREntertainment on January 16, 2009, 09:29:34 pm

Quote from: Stramm on January 16, 2009, 03:00:29 pm

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

This is the message I'm getting

Quote

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

Title: Re: extract member emails
Post by: Stramm on January 16, 2009, 10:07:53 pm

try that

Code: [Select]

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

Title: Re: extract member emails
Post by: KOREntertainment on January 18, 2009, 12:00:56 am

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

Title: Re: extract member emails
Post by: Stramm on January 18, 2009, 10:59:33 am

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

Nevertheless it works for me.

Title: Re: extract member emails
Post by: Nibbler on January 18, 2009, 05:05:16 pm

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

Title: Re: extract member emails
Post by: KOREntertainment on January 21, 2009, 06:53:35 pm

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

Title: Re: extract member emails
Post by: Joachim Müller on January 23, 2009, 08:40:02 am

Right.
Marking thread as "invalid".