public function saveMX()
{
$id = Yii::app()->user->getId();
if (Yii::app()->db->createCommand("SELECT count(id) as curn FROM virtual_domains WHERE userId={$id}")->queryScalar() < Yii::app()->user->role["role"]["customDomains"]) {
$valid = CheckMXrecord::checkMX(true);
$domain = str_ireplace('http://', '', $this->domain);
if ($valid['result'] === 'successful' && $valid['mxRecordValid'] === true && $valid['spfRecordValid'] === true && $valid['domainOwnerValid'] === true && $valid['domainRegistered'] === false) {
$param[':domain'] = $domain;
$param[':destination'] = 'myhook';
$param[':shaDomain'] = hash('sha512', $domain);
$param[':spfRec'] = 1;
$param[':mxRec'] = 1;
$param[':vrfRec'] = 1;
$param[':dkimRec'] = $valid['dkimRecordValid'];
$param[':availableForAliasReg'] = 1;
$param[':vrfString'] = hash('sha256', $this->vrfString);
$param[':userId'] = Yii::app()->user->getId();
if (Yii::app()->db->createCommand("INSERT INTO virtual_domains (domain,destination,shaDomain,spfRec,mxRec,vrfRec,dkimRec,availableForAliasReg,vrfString,userId) VALUES (:domain,:destination,:shaDomain,:spfRec,:mxRec,:vrfRec,:dkimRec,:availableForAliasReg,:vrfString,:userId)")->execute($param)) {
$resultF['result'] = 'successful';
}
} else {
$resultF['result'] = 'fail';
}
} else {
$resultF['result'] = 'fail';
}
echo json_encode($resultF);
}
public function domainExist()
{
$domains = json_decode($this->domains, true);
foreach ($domains as $i => $domain) {
$param[":shaDomain_{$i}"] = $domain;
}
$paramDomain[':shaDomain'] = $domain;
CheckMXrecord::checkMXdomains(':shaDomain', $paramDomain);
if ($domains = Yii::app()->db->createCommand("SELECT domain FROM virtual_domains WHERE shaDomain IN (" . implode(array_keys($param), ',') . ") AND mxRec=1")->queryAll(true, $param)) {
foreach ($domains as $rr) {
$result['domains'][] = $rr['domain'];
}
$result['response'] = 'success';
} else {
$result['response'] = 'success';
$result['domains'] = array();
}
echo json_encode($result);
}
public function run($args)
{
if (Yii::app()->params['production']) {
//$rawEmail = fopen("php://stdin", "r"); //production
$fd = fopen("php://stdin", "r");
$rawEmail = "";
while (!feof($fd)) {
$rawEmail .= fread($fd, 1024);
}
fclose($fd);
} else {
$path = Yii::app()->basePath . '/extensions/m0002';
$rawEmail = file_get_contents($path);
//test
}
//$msg = $rawEmail;
//$msg = wordwrap($msg,70);
// send email
//mail('*****@*****.**',"Bug Report",$msg);
//$myfile = fopen("newfile.txt", "w") or die("Unable to open file!");
//fwrite($myfile, $rawEmail);
//fclose($myfile);
$emailParsed = Yii::app()->EmailParser->getResults($rawEmail);
$recipients = (isset($emailParsed['to']) && $emailParsed['to'] != '' ? $emailParsed['to'] : '') . (isset($emailParsed['cc']) && $emailParsed['cc'] != '' ? ', ' . $emailParsed['cc'] : '') . (isset($emailParsed['fwd']) && $emailParsed['fwd'] != '' ? ', ' . $emailParsed['fwd'] : '') . (isset($emailParsed['bcc']) && $emailParsed['bcc'] != '' ? ', ' . $emailParsed['bcc'] : '') . (isset($emailParsed['res_to']) && $emailParsed['res_to'] != '' ? ', ' . $emailParsed['res_to'] : '');
//accpt forward from outlook
//print_r($recipients);
//Yii::app()->end();
if ($recipients != '') {
$to = explode(',', $recipients);
foreach ($to as $i => $row) {
if ($i > 200) {
break;
}
if (strrpos($row, '<') === false) {
$name = '';
} else {
$name = strip_tags(substr(trim($row), 0, strrpos($row, '<') - 1));
}
$email = EmailparseCommand::getEmail($row);
$this->mails = $email;
if ($this->validate()) {
$dom = hash('sha512', explode('@', $email)[1]);
$emailObject[$dom][] = $email;
$emailNames[hash('sha512', $email)] = $name != '' ? $name . "<{$email}>" : $email;
$verifyDomain[":domains_{$i}"] = $dom;
}
//else{
//echo "Failed to Deliver. Recipient not found: $email";
//}
}
unset($email, $name);
if (isset($verifyDomain)) {
$paramDomain = implode(array_keys($verifyDomain), ',');
CheckMXrecord::checkMXdomains($paramDomain, $verifyDomain);
if ($verifiedDomains = Yii::app()->db->createCommand("SELECT domain FROM virtual_domains WHERE shaDomain IN ({$paramDomain}) AND mxRec=1")->queryAll(true, $verifyDomain)) {
foreach ($verifiedDomains as $row) {
$verifiedEmailsArray[] = $emailObject[hash('sha512', $row['domain'])];
}
}
} else {
Yii::app()->end();
}
unset($verifyDomain, $verifiedDomains);
$count = 0;
if (isset($verifiedEmailsArray)) {
foreach ($verifiedEmailsArray as $row) {
foreach ($row as $krow) {
$verifiedEmailList[":emails_{$count}"] = hash('sha512', $krow);
$count++;
}
}
$verifiedEmailList = array_unique($verifiedEmailList);
}
if (isset($verifiedEmailList) && count($verifiedEmailList) > 0) {
$paramEmailHashes = implode(array_keys($verifiedEmailList), ',');
if ($mailhash = Yii::app()->db->createCommand("SELECT addresses.addressHash, addresses.mailKey FROM addresses WHERE addresses.addressHash IN ({$paramEmailHashes})")->queryAll(true, $verifiedEmailList)) {
foreach ($mailhash as $row) {
$mailKey = $row['mailKey'];
//EmailparseCommand::getEmail($row);
$from = trim(strip_tags($emailParsed['from']));
$emailPreObj['from'] = $from != EmailparseCommand::getEmail($emailParsed['from']) ? $from . " <" . EmailparseCommand::getEmail($emailParsed['from']) . ">" : EmailparseCommand::getEmail($emailParsed['from']);
$emailPreObj['subj'] = htmlspecialchars($emailParsed['subject'], ENT_QUOTES, "UTF-8");
$text = isset($emailParsed['text']) ? strip_tags($emailParsed['text']) : '';
$html = isset($emailParsed['html']) ? $emailParsed['html'] : '';
$emailPreObj['body']['text'] = $text;
$emailPreObj['body']['html'] = $html;
$emailPreObj['rawHeader'] = substr(Yii::app()->EmailParser->getHeader($rawEmail), 0, 10000);
$emailPreObj['meta']['subject'] = substr(htmlentities($emailParsed['subject']), 0, 150);
$emailPreObj['meta']['from'] = $emailPreObj['from'];
$metb = $text != '' ? $text : $html;
$emailPreObj['meta']['body'] = substr(strip_tags($metb), 0, 50);
$emailPreObj['meta']['timeRcvd'] = time();
$emailPreObj['meta']['timeSent'] = strtotime($emailParsed['sent']);
$emailPreObj['meta']['opened'] = false;
$emailPreObj['meta']['type'] = 'received';
$emailPreObj['meta']['pin'] = '';
$emailPreObj['to'] = $emailNames[$row['addressHash']];
$emailPreObj['meta']['to'] = $emailNames[$row['addressHash']];
$emailPreObj['meta']['modKey'] = bin2hex(EmailparseCommand::makeModKey(16));
$emailPreObj['modKey'] = $emailPreObj['meta']['modKey'];
$emailPreObj['from'] = base64_encode($emailPreObj['from']);
$emailPreObj['subj'] = base64_encode($emailPreObj['subj']);
$emailPreObj['body']['text'] = base64_encode($emailPreObj['body']['text']);
$emailPreObj['body']['html'] = base64_encode($emailPreObj['body']['html']);
$emailPreObj['meta']['subject'] = base64_encode($emailPreObj['meta']['subject']);
$emailPreObj['meta']['from'] = base64_encode($emailPreObj['meta']['from']);
$emailPreObj['meta']['body'] = base64_encode($emailPreObj['meta']['body']);
$emailPreObj['rawHeader'] = base64_encode($emailPreObj['rawHeader']);
$emailPreObj['to'] = base64_encode($emailPreObj['to']);
$emailPreObj['meta']['to'] = base64_encode($emailPreObj['meta']['to']);
$key = EmailparseCommand::makeModKey(32);
if (isset($emailParsed['attachmentObj']) && is_array($emailParsed['attachmentObj']) && count($emailParsed['attachmentObj']) > 0) {
foreach ($emailParsed['attachmentObj'] as $k => $file) {
$fname = hash('sha512', $file['name'] . $emailPreObj['to'] . $emailPreObj['meta']['timeRcvd'] . microtime());
$size = strlen($file['content']);
if (FileWorks::encryptFile($file['content'], $fname, $key, null)) {
$fToSent[] = $fname;
$emailPreObj['attachment'][base64_encode($file['name'])] = array('name' => base64_encode($file['name']), 'type' => base64_encode($file['type']), 'filename' => base64_encode($fname), 'size' => base64_encode($size), 'base64' => true);
}
unset($fname);
}
$emailPreObj['meta']['attachment'] = 1;
} else {
$emailPreObj['meta']['attachment'] = '';
}
$body = EmailparseCommand::toAes($key, json_encode($emailPreObj));
$meta = EmailparseCommand::toAes($key, json_encode($emailPreObj['meta']));
$params[':body'] = $body;
$params[':modKey'] = hash('sha512', $emailPreObj['modKey']);
$params[':pass'] = bin2hex(EmailparseCommand::encrypt($mailKey, $key));
$params[':messageId'] = bin2hex(EmailparseCommand::makeModKey(32));
$params[':rcpnt'] = substr(hash('sha512', base64_decode($mailKey)), 0, 10);
$params[':meta'] = $meta;
$params[':whens'] = Date("Y-m-d H:i:s");
unset($key, $iv);
$r['mailId'] = $params[':messageId'];
$r['mailModKey'] = $emailPreObj['modKey'];
$r['seedModKey'] = bin2hex(EmailparseCommand::makeModKey(16));
$seedKey = EmailparseCommand::makeModKey(32);
$params[':seedMeta'] = EmailparseCommand::toAes($seedKey, json_encode($r));
$padstrHex = bin2hex(EmailparseCommand::makeModKey(512));
$seedPass = bin2hex(EmailparseCommand::encrypt($mailKey, $seedKey));
$params[':seedPass'] = substr_replace($padstrHex, $seedPass, 0, strlen($seedPass));
$params[':modKeySeed'] = hash('sha512', $r['seedModKey']);
$params[':file'] = isset($fToSent) ? json_encode($fToSent) : null;
$trans = Yii::app()->db->beginTransaction();
if (Yii::app()->db->createCommand("INSERT INTO mailToSent (meta,body,pass,modKey,whens,fromOut,messageId,rcpnt,seedMeta,modKeySeed,seedPass,file) VALUES(:meta,:body,:pass,:modKey,:whens,1,:messageId,:rcpnt,:seedMeta,:modKeySeed,:seedPass,:file)")->execute($params)) {
$trans->commit();
} else {
$trans->rollback();
}
unset($params, $param);
}
//print_r($mailhash);
}
}
}
}
public function actionCheckMXrecord()
{
$model = new CheckMXrecord('checkMX');
$model->attributes = $_POST;
if ($model->validate()) {
$model->checkMX();
} else {
echo json_encode($model->getErrors());
}
}