forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 ecards & email => Topic started by: Visitors on December 04, 2007, 08:15:08 pm

Title: How to get e-mail addresses from coppermine script
Post by: Visitors on December 04, 2007, 08:15:08 pm

Hi.

I have 7000 registered users. I don't hvae admin massmail. Is there any way to get e-mail addresses from some txt file. Where is database with e-mails.

Thanks.

Title: Re: How to get e-mail addresses from coppermine script
Post by: Nibbler on December 04, 2007, 08:36:48 pm

http://forum.coppermine-gallery.net/index.php?topic=1228.msg58625#msg58625

Title: Re: How to get e-mail addresses from coppermine script
Post by: Visitors on December 05, 2007, 02:22:46 am

I make a page with this code bellow and I get this

http://www.prsata.com/mails.php

I still have problem.

<?php

define('IN_COPPERMINE', 1);
require 'include/init.inc.php';

$test = 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: How to get e-mail addresses from coppermine script
Post by: Nibbler on December 05, 2007, 02:26:07 am

Change db_query to cpg_db_query

Title: Re: How to get e-mail addresses from coppermine script
Post by: Visitors on December 05, 2007, 02:30:20 am

Thanks. That solved the problem.

Can script split registered users emails from inactive users emails, because I have a lot of unregistered or unconfirmed memberships.

And can script send me on email for example every week new emails.

Thanks again.

Title: Re: How to get e-mail addresses from coppermine script
Post by: Visitors on December 05, 2007, 02:32:03 am

Can I protect this file with password.

Title: Re: How to get e-mail addresses from coppermine script
Post by: Nibbler on December 05, 2007, 02:52:10 am

Quote from: Visitors on December 05, 2007, 02:32:03 am

Can I protect this file with password.

Add

Code: [Select]

if (!GALLERY_ADMIN_MODE) die('Access denied');
after

Code: [Select]

require 'include/init.inc.php';
That will make it admin only.

Quote from: Visitors on December 05, 2007, 02:30:20 am

Can script split registered users emails from inactive users emails, because I have a lot of unregistered or unconfirmed memberships.

And can script send me on email for example every week new emails.

Your karma is too low to expect custom coding...

Title: Re: How to get e-mail addresses from coppermine script
Post by: Visitors on December 05, 2007, 04:10:11 am

Thanks again.

But, why is my carma too low. How I can rase my carma.

Title: Re: How to get e-mail addresses from coppermine script
Post by: Joachim Müller on December 05, 2007, 08:54:23 am

Quote from: Visitors on December 05, 2007, 04:10:11 am

But, why is my carma too low.

Because you misbehaved in the past (by not respecting board rules). Respect board rules in the future to avoid your karma going down even further.

Quote from: Visitors on December 05, 2007, 04:10:11 am

How I can rase my carma.

There are several options to raise your karma: see We need your help (http://forum.coppermine-gallery.net/index.php?topic=14227.0). However, this should not be discussed further in this thread. As your initial question got solved I'm marking it accordingly.

Title: Re: How to get e-mail addresses from coppermine script
Post by: Visitors on December 05, 2007, 11:20:28 am

Ok. I have translated script for Serbian language.

I upload in attachment.

Title: Re: How to get e-mail addresses from coppermine script
Post by: Abbas Ali on December 05, 2007, 01:13:21 pm

You hardly translated 5% of the lang file. This is of no use to us. A real translation is where above 80% text is translated (preferably 100%).

Title: Re: How to get e-mail addresses from coppermine script
Post by: Visitors on December 05, 2007, 07:50:28 pm

I translated only user view options. For example - Menu on the left side, user control panel and everything about that - panel for upload pictures, to create albums, modificate album and pictures.

I use this translation on my site, you can see that almost nothing is on english language.

A couple of admin mods is on english because is easier to me to see english language on script.

http://www.prsata.com/index.php (adult site)