Export Emails to csv

[steveeyes]

I use the 4images usergroup mod. It's great to be able to separate your usergroups and email them, etc.

However, as my memberships have grown, I have been forced to search out another way to email my members. The reason being is that my server only allows me to send 50 emails at a time -- and now it is taking too long to send out newsletters.

I thought at one time I saw this mod by V@NO but maybe I'm wrong. I searched but didn't find anything.

I'm hoping an expert could tell me the code to extract the emails by usergroups into csv format or another format that can be imported into a newsletter program.

I have two usergroups ... one called Ladies and the other Called Men

I would like to extract the Usergroup Ladies emails and then import them into a  mailing list that would also be called Ladies.

The same thing for the Men Usergroup -- extract emails from usergroup and import into mailing list called men

Any help would be appreciated.

Thanks
Steve

[steveeyes]

Any help, please

[TheOracle]

@Steveeyes:

Since yesterday, your MOD has been completely done and fully tested. You may PM me if you wish to have it.

Merry Christmas.

[steveeyes]

Thank you sir, thank you sir. Not sure if you got my PM, but your efforts are appreciated.

Merry Christmas
Steve

[TheOracle]

PM replied.

[impss]

TheOracle, I have the same problem

PM sent

[TheOracle]

PM Received.

[impss]

Can Anyone else make this mod? Maybe like a plugin for the Admin CP

thanks

[Acidgod]

Code: [Select]

<?php // PLUGIN_TITLE: email to csv
$nozip = 1;
define('IN_CP', 1);
define('ROOT_PATH', "./../../");
define('ROOT_PATH_ADMIN', "./../");
require(ROOT_PATH_ADMIN.'admin_global.php');


$anzahl = 0; 

global $site_db; 
$sql = "SELECT user_email, user_name
FROM ".USERS_TABLE."
WHERE user_allowemails=1"; 
$result = $site_db->query($sql);
$anz = mysql_num_rows ($result); 

$fp=fopen('emails/adressen.csv','w+'); 

while ($sql_array = mysql_fetch_array($result, MYSQL_NUM)) 
{ 
$text = implode(' ; ', $sql_array) . " ; \n"; 
fwrite($fp,$text); 
} 

fclose($fp); 

print "<a href=\"".ROOT_PATH_ADMIN."plugins/emails/adressen.csv\">Download</a>";

?>
create a folder emails with chmod 777  into the plugin folder...
after use you found a csv file in the folder with the emails form the users that allows mails from the admin...

[impss]

Thanks Acidgod

That worked perfectly 

U saved me a bunch of time not having to send 50 emails at a time

[Acidgod]

have make a littel modification, now there is a link to the csv file at the end of the script...

[impss]

Thats even better 

Thanks again

[Acidgod]

please rename the email folder or the cvs file in the plugin... 
or put a htaccess file in the email folder... (o:

Here:
$fp=fopen('emails/adressen.csv','w+');

And here:
print "<a href=\"".ROOT_PATH_ADMIN."plugins/emails/adressen.csv\">Download</a>";

otherwise anyone can grab the List of emails... (o:

[impss]

 

[TheOracle]

@Acidgod:

I just noticed some unusual codings in your plugin. Modifications has just been made as I hope you won't mind :

Code: [Select]


<?php // PLUGIN_TITLE: email to csv

$nozip = 1;
define('IN_CP', 1);
define('ROOT_PATH', "./../../");
define('ROOT_PATH_ADMIN', "./../");
require(ROOT_PATH_ADMIN.'admin_global.php');

show_admin_header();

$anzahl = 0; 

$sql = "

SELECT ".get_user_table_field("", "user_name"). get_user_table_field(", ", "user_email")."
FROM ".USERS_TABLE."
WHERE user_allowemails = '1'

"; 

$result = $site_db->query($sql);
$anz = $site_db->get_numrows($result); 

if ($anz) {

$fp = @fopen('emails/adressen.csv', 'w+'); 

while ($sql_array = $site_db->fetch_array($result, MYSQL_NUM)) { 
$text = implode(' ; ', $sql_array) . " ; \n"; 
@fwrite ($fp, $text); 
} ###### End of while statement.

@fclose($fp); 

echo "<a href=\"".$site_sess->url(ROOT_PATH_ADMIN."plugins/emails/adressen.csv")."\">".$lang['download']."</a>";

} ###### End of if statement.

show_admin_footer();
?>