$r = mysql_query($q);
while ($row = mysql_fetch_array($r)) {
echo "Fetching data from messages...\n";
$id = $row['message_id'];
$SenderName = $row['sender_name'];
$SenderEmail = $row['sender_email'];
print $SenderEmail;
$Hash_tmp = $row['hash'];
$Hash = preg_replace("/[^\\pL\\pN\\p{Zs}'-]/u", "", $Hash_tmp);
$To = $row['recipient_email'];
$Name = $row['recipient_name'];
$Facebook = $row['facebook_post'];
$CardId = $row['card_id'];
$Image = $row['image_name'];
$SendDate = $row['send_date'];
sendMailSent($To, $Name, $SenderName, $SenderEmail, $Hash, $id, $Facebook, $Image, $base_url, $SendDate, $today);
}
function sendMailSent($To, $Name, $SenderName, $SenderEmail, $Hash, $id, $Facebook, $Image, $base_url, $SendDate, $today)
{
if ($SendDate == $today) {
$send_msg = "<p>Your Robert Goulet electronic greeting has been sent to <a class=\"email\" href=\"mailto:{$To}\">{$To}</a></p>";
} else {
$newDate = date("m-d-Y", strtotime($SendDate));
$send_msg = "<p>Your Robert Goulet electronic greeting has been scheduled to be sent on {$newDate} to <a class='email' href='mailto:{$To}'>{$To}</a></p>";
}
# Let's valid the email address first
$validEmailResult = validEmail($To);
#echo "validEmailResult = " . $validEmailResult;
if ($validEmailResult == '1') {
echo "\nValid Email address found: " . $To . " Return Code for valid email is: " . $validEmailResult . "\n";
echo "Sending ecard sent email to " . $Name . "," . $To . "\n";
$Body = '';
$file_handle = fopen($file_name, "r");
while (!feof($file_handle)) {
$line = fgets($file_handle);
if (strpos($line, '@ACHM3NT:') !== false) {
$attachment = str_replace('@ACHM3NT:', '', $line);
$attachment = preg_replace('~[\\r\\n]+~', '', $attachment);
$attachments[] = $attachment;
echo $attachment;
} else {
#echo $line;
$Body .= $line . "\n";
}
}
fclose($file_handle);
sendMailSent($To, $From_Name, $From, $Body, $Subject, $CC_Arr, $attachments, $today);
function sendMailSent($To, $From_Name, $From, $Body, $Subject, $CC_Arr, $attachments, $today)
{
# Let's valid the email address first
#$validEmailResult = validEmail($To);
#echo "validEmailResult = " . $validEmailResult;
#echo "\nValid Email address found: " . $To . " Return Code for valid email is: " . $validEmailResult . "\n";
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = "mail.2gdigital.com";
$mail->SMTPAuth = false;
$mail->From = $From;
$mail->FromName = $From_Name;
$mail->AddAddress($To);
foreach ($CC_Arr as $CC_dude) {
if ($CC_dude != $To) {
