How to get e-mail addresses from coppermine script

[Visitors]

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.

[Nibbler]

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

[Visitors]

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

?>

[Nibbler]

Change db_query to cpg_db_query

[Visitors]

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.

[Visitors]

Can I protect this file with password.

[Nibbler]

Can I protect this file with password.

Add

Code Select Expand

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

after

Code Select Expand

require 'include/init.inc.php';

That will make it admin only.

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...

[Visitors]

Thanks again.

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

[Joachim Müller]

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.

How I can rase my carma.

There are several options to raise your karma: see We need your help. However, this should not be discussed further in this thread. As your initial question got solved I'm marking it accordingly.

[Visitors]

Ok. I have translated script for Serbian language.

I upload in attachment.

[Abbas Ali]

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%).

[Visitors]

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)