Bulk email list program?

[mkx]

I need to send about 1000 emails to tell people my sites up again. Any quick way to do this without everyone seeing my list of emails?

[goodsites]

mail 50 emails every 8 seconds... call from your databse of emails.. you have to edit this query below to match your database or change it up to read in a text file

the db.php is the connection/login info for your db...


<?php
include('./db.php');

$count=1;
$result = mysql_query("SELECT `username`, `email` FROM `member` WHERE `active` = 1 and is_banned = 0");

while ($row=mysql_fetch_array($result)) {
$username = trim($row['username']);
$email = trim($row['email']);

echo "Email: $email\n";
if ($count == 50) {
echo "Count: $count\nSleeping for 8 seconds";
sleep(8);
$count = 0;
}

$fromaddress = "[email protected]";
$to = trim($email);
$subject = "Happy Easter From SOMEONE";

$headers="";
$headers .= "X-Sender: $to <$to>\n";
$headers .= "From: <$fromaddress>\n";
$headers .= "Reply-To: <$fromaddress>\n";
$headers .= "Date: ".date("r")."\n";
$headers .= "Message-ID: <".date("YmdHis")."noreply@".mydomain.com.">\n" ;
$headers .= "Subject: $subject\n";
$headers .= "Return-Path: $fromaddress <$fromaddress>\n";
$headers .= "Delivered-to: $fromaddress <$fromaddress>\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-type: text/html;charset=ISO-8859-9\n";
$headers .= "X-Priority: 1\n";
$headers .= "Importance: High\n";
$headers .= "X-MSMail-Priority: High\n";
$headers .= "X-Mailer: Msg Mailer\n";

$body = "Hello $username,<br />
<p>Greetings friends,
blah blah blah<br />


<p>Cya, Me<br />
<br />
";

mail($to, $subject, $body, $headers);
$count = $count +1;

}

exit;

?>

Enjoy

[mkx]

Thanks, so db.php should be a line by line list of the emails?

[goodsites]

db.cfg might be something like this.. edit it

<?php
$db=mysql_connect("localhost", "EDITUSERNAME", "EDITPASSWORD");
mysql_select_db("INSERTDBNAMEHERE",$db);
?>

[goodsites]

thats for reading from your mysql databse which you will have to know your username and email stuff and fixup the query.

If you want to just read in a line by line text file

remove the db stuff and do like

$emails = file('./emails.txt');

foreach ($emails as $email) {

..insert just the mailing code above here...

}

[grumpy]

this will get you on the spamlist in record time