<?php
// functions.php

include_once 'class.phpmailer.php';
include 'db.php';

function createObject() {

$sqlFrom = mysql_query("SELECT * FROM `emailTemplates` WHERE id=5");
$fromDetails = "";

while ($row = mysql_fetch_array($sqlFrom)) {
$fromDetails = $row['type1'];
}

$detailsArr = explode(";", $fromDetails);

$mail = new PHPMailer();

$mail->SMTPAuth = true;
$mail->SMTPSecure = "tls";
$mail->Host = "sap.sapbrainsonline.com";
$mail->Port = 465;
$mail->IsHTML(true);
$mail->Username = "info@vodemosafe.com";
$mail->Password = "info@vodemosafe.com";
$mail->SetFrom('info@vodemosafe.com', 'Subscription Service');

$mail->Set("Organization" , SITE);
$mail->Set("Content-Transfer-encoding" , "8bit");
$mail->Set("Message-ID" , "<".md5(uniqid(time()))."@{$_SERVER['SERVER_NAME']}>");
$mail->Set("X-MSmail-Priority" , "High");
$mail->Set("X-Mailer" , "Microsoft Office Outlook, Build 11.0.5510");
$mail->Set("X-MimeOLE" , "Produced By Microsoft MimeOLE V6.00.2800.1441");
$mail->Set("X-Sender" , $mail->Sender);
$mail->Set("X-AntiAbuse" , "mail is a solicited email for - ".SITE." mailing list.");
$mail->Set("X-AntiAbuse" , "Servername - {$_SERVER['SERVER_NAME']}");

return $mail;
}

function sendEmail($data) {

$mail = createObject();

$sqlBody = mysql_query("SELECT * FROM `emailTemplates` WHERE id=1");
$sqlSub = mysql_query("SELECT * FROM `emailTemplates` WHERE id=2");
$sqlBcc = mysql_query("SELECT * FROM `emailTemplates` WHERE id=3");
$sqlAdmin = mysql_query("SELECT * FROM `emailTemplates` WHERE id=4");

$arrBody = array();
$arrSub = array();
$arrBcc = array();
$arrAdmin = array();

if ($data['pass'] == '') {
    $data['pass'] = '<i>unchanged</i>';
}

while ($row = mysql_fetch_array($sqlBcc)) {
array_push($arrBcc, $row['type1'], $row['type2'], $row['type3'], $row['type4'], $row['type5']);
}

while ($row = mysql_fetch_array($sqlBody)) {
array_push($arrBody, $row['type1'], $row['type2'], $row['type3'], $row['type4'], $row['type5']);
}

while ($row = mysql_fetch_array($sqlAdmin)) {
array_push($arrAdmin , $row['type1'], $row['type2'], $row['type3'], $row['type4'], $row['type5']);
}

while ($row = mysql_fetch_array($sqlSub)) {
array_push($arrSub , $row['type1'], $row['type2'], $row['type3'], $row['type4'], $row['type5']);
}

$old = array("FIRST_NAME", "LAST_NAME", "USERNAME", "PASSWORD" ,"SUBS_PERIOD", "PAYMENT_AMOUNT");
$new = array($data['first_name'], $data['last_name'], $data['userN'], $data['pass'], $data['subsPeriod'], abs($data['payment_amount']));

$bccs = explode(",", $arrBcc[$data['type']-1]);
$admins = explode(",", $arrAdmin[$data['type']-1]);

for ($i = 0; $i <= 4; $i++) {
    $arrSub[$i]=str_replace($old,$new,$arrSub[$i]);
    $arrBody[$i]=str_replace($old,$new,$arrBody[$i]);
}

static $bodyCon;
static $subCon;

$bodyCon = $arrBody[$data['type']-1];
$subCon = $arrSub[$data['type']-1];

$mail->Subject = $subCon;
$mail->Body = $bodyCon;

//$mail->AddCC("windows_ntuser@hotmail.com");

$mail->AltBody = strip_tags($arrBody[$data['type']-1]);

$geoArr = explode(";",$data['userIP']);

sendFromUserToAdmin($geoArr[1],$mail,$admins,$geoArr[2],$data['first_name'],$data['last_name']);

$mail->ClearAllRecipients();
$mail->ClearBCCs();

$mail->AddAddress($data['payer_email'], $data['first_name']." ".$data['last_name']);
$mail->AddReplyTo($data['payer_email'], $data['first_name']." ".$data['last_name']);

$mail->AddCustomHeader('BCC: '.$arrBcc[$data['type']-1]);
$mail->AddCC("");

foreach ($bccs as $value) {
    $mail->AddBCC($value);
}

$mail->Subject = $subCon;
$mail->Body = $bodyCon;

$mail->Send();

}

function sendFromUserToAdmin($state, $mailItem, $admins, $city, $fName, $lName) {

$mail = $mailItem;
$mail->ClearAllRecipients();
$mail->ClearBCCs();

foreach ($admins as $value) {
    $mail->AddAddress($value);
    $mail->AddReplyTo($value);
}

$cityFin = "";
if ($city == "") {
$cityFin = "/";
}
else
{
$cityFin = $city;
}

$mail->Subject = 'Admin message: '.$mail->Subject;
$mail->Body .= 'Country: '.$state.'<br>City: '.$cityFin.'<br><br>(originally sent to '.$fName.' '.$lName.')';
$mail->Send();
}

function sendToAddress($admins, $subject, $content) {

$mail = createObject();

$mail->AltBody = strip_tags($content);

foreach ($admins as $value) {
    $mail->AddAddress($value);
    $mail->AddReplyTo($value);
}

$mail->Subject = $subject;
$mail->Body = $content;

$mail->Send();
}

?>