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

__________________
Don't let greediness blur your vision | You gotta let some shit slide
icq - 441-456-888