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')); }