function sendSesizareAlertaToUser($_SESIZARE, $_DESTINATAR_ALERTA)
{
global $config;
//check data
if (!is_array($_SESIZARE)) {
return false;
}
if (!is_array($_DESTINATAR_ALERTA)) {
return false;
}
//prepare data for emails
$_SESIZARE_ID = $_SESIZARE['sesizare_id'];
$sesizare_url = getSesizareURL($_SESIZARE_ID);
//from
$senderName = $config['smtpName'];
$senderEmail = $config['smtpEmail'];
//subject
$subject = 'Sesizare noua in Harta FreeEx';
//to
$email = $_DESTINATAR_ALERTA['alerta_email'];
$name = $_DESTINATAR_ALERTA['alerta_nume'];
//compose mail
$mailHtml = '';
$mailHtml .= '<p>O noua sesizare a fost adaugata in Harta FreeEx:</p>';
$mailHtml .= '<p><strong>"' . $_SESIZARE['sesizare_titlu'] . '"</strong><br /><strong>Click aici: </strong><a href="' . $sesizare_url . '" target="_blank">' . $sesizare_url . '</a></p>';
$mailHtml .= '<p> </p>';
$mailHtml .= '<p><em>Primiti acest e-mail deoarece v-ati abonat la primirea alertelor pe site-ul Harta FreeEx.<br />
Daca nu mai doriti primirea acestor mesaje, va rugam sa ne contactati la adresa office@activewatch.ro<br />
E-mail trimis automat. Nu dati Reply la acest e-mail.</em></p>';
$mailHtml .= '<p> </p>';
$mailHtml .= $config['mailSignature'];
//send mail
$mail = new PHPMailer();
$mail->isSMTP();
$mail->SMTPDebug = 0;
$mail->Debugoutput = 'html';
$mail->Host = $config['smtpServer'];
$mail->Port = $config['smtpPort'];
$mail->SMTPAuth = true;
$mail->CharSet = 'UTF-8';
$mail->Encoding = '8bit';
$mail->Timeout = 10;
$mail->addAddress($email, $name);
$mail->Subject = $subject;
$mail->AltBody = 'URL: ' . $validate_code_url;
$mail->Username = $config['smtpUser'];
$mail->Password = $config['smtpPass'];
$mail->setFrom($config['smtpEmail'], $config['smtpName']);
$mail->msgHTML($mailHtml);
$mail->IsHTML(true);
//send the message, check for errors
if (!$mail->send()) {
die($mail->ErrorInfo);
} else {
}
}
redirect(add_querystring_var($config['siteURL'], 'm', '102'));
}
$_CATEGORII_SESIZARE = getQueryInArray("SELECT c.* FROM mm_categs_sesizari mc JOIN categories c ON mc.categ_id = c.categ_id WHERE mc.sesizare_id = :sesizare_id", array('sesizare_id' => $sesizare_id));
$_LINKURI_SESIZARE = getQueryInArray("SELECT l.* FROM mm_sesizari_linkuri l WHERE l.sesizare_id = :sesizare_id AND l.link_sursa <> '' ", array('sesizare_id' => $sesizare_id));
$_IMAGINI_SESIZARE = getQueryInArray("SELECT i.* FROM mm_sesizari_images i WHERE i.sesizare_id = :sesizare_id ", array('sesizare_id' => $sesizare_id));
$_CODURI_EMBED = getQueryInArray("SELECT e.* FROM mm_sesizari_embeds e WHERE e.sesizare_id = :sesizare_id AND e.embed_sursa <> '' ", array('sesizare_id' => $sesizare_id));
$config['currentMenuSection'] = 'index';
$config['currentSubMenuSection'] = 'sesizare';
pageHeader();
?>
<div class="container_12">
<div class="grid_7">
<h1><?php
echo '<a href="' . getSesizareURL($_SESIZARE[0]['sesizare_id']) . '">' . $_SESIZARE[0]['sesizare_titlu'] . '</a>';
?>
</h1>
<div class="icon_time"></div><div class="sesizareMeta"><?php
echo getDataOraNice($_SESIZARE[0]['data_ora']);
?>
</div>
<div class="icon_location"></div><div class="sesizareMeta"><?php
echo getLocationNice($_SESIZARE[0]['location_search'], $_SESIZARE[0]['location_reverse']);
?>
</div>
<div class="clear"></div>
<br />
<h3>Categorii:</h3>
<div class="sesizareCategsList">
<?php
<?php
require_once 'includes/config.php';
//get params
$h = filter_var($_GET['h'], FILTER_SANITIZE_STRING);
if (!strlen($h)) {
redirect($config['siteURL']);
}
$_SESIZARE = getQueryInArray("SELECT * FROM sesizari WHERE deleted = 0 AND validation_code = :validation_code LIMIT 1", array('validation_code' => $h));
if (!count($_SESIZARE)) {
redirect(add_querystring_var($config['siteURL'], 'm', '103'));
}
if ($_SESIZARE[0]['validated'] == 1) {
redirect(add_querystring_var(getSesizareURL($_SESIZARE[0]['sesizare_id']), 'm', '104'));
} else {
//validare
$updateTableStr = "UPDATE sesizari SET validated = :validated WHERE sesizare_id = :sesizare_id ";
$updateTableArray = array('validated' => intval(1), 'sesizare_id' => $_SESIZARE[0]['sesizare_id']);
updateTable($updateTableStr, $updateTableArray);
//trimitere e-mail alerta catre abonati
sendAlertsForSesizare($_SESIZARE[0]);
//redirectare in pagina de sesizare + mesaj succes
redirect(add_querystring_var(getSesizareURL($_SESIZARE[0]['sesizare_id']), 'm', '105'));
}
