//header("Expires: Tue, 01 Jan 2000 00:00:00 GMT");
//header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
//header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0");
//header("Cache-Control: post-check=0, pre-check=0", false);
//header("Pragma: no-cache");
setlocale(LC_ALL, 'pl_PL');
?>
include("include/mysql_connect.php");
include('include/func.php');
if($_POST['email']){
// get code from datas
$sql = "SELECT * FROM codes WHERE active=1 LIMIT 1";
$result = $db->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$code = $row["code"];
$idcode = $row["id"];
}
}
//choose option
if(isset($_POST['choose1'])){
$choose = $_POST['choose1'];
}else if(isset($_POST['choose2'])){
$choose = $_POST['choose2'];
}else if(isset($_POST['choose3'])){
$choose = $_POST['choose3'];
}else{
$choose = 3;
}
$wynik = @$db -> query("INSERT INTO subscription (email, nazwa, data, choose, code, active) VALUES ('$_POST[email]', '$_POST[name]', NOW(), '$choose', '$code', '1')");
if ($wynik === false){
$message = 'Coś poszło nie tak.';
}else {
$message = '
Dziękujemy za zgłoszenie.
Kupon został wysłany na adres email.
Potwierdź go, aby dokończyć rejestrację
';
$idsql = $db->insert_id;
}
//update codes in sql
$sql2 = "UPDATE codes SET active='2', id_user='$idsql', data = NOW() WHERE id='$idcode'";
if(mysqli_query($db, $sql2)) {
}
$body2 = str_replace('!!!!!!!!!kod!!!!!', $code, file_get_contents("test.html"));
$body2 = str_replace('!id!', $idsql, $body2);
$body2 = str_replace('!token!', $code, $body2);
$body2 = str_replace('!email!', $_POST['email'], $body2);
date_default_timezone_set('Europe/Warsaw');
require 'plugins/phpmailer/PHPMailerAutoload.php';
$mail = new PHPMailer;
$mail->isSMTP();
$mail->SMTPDebug = 0;
$mail->CharSet = "UTF-8";
$mail->Debugoutput = 'html';
$mail->Host = "mail.olympiakids.pl";
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = 'admin@olympiakids.pl'; // SMTP username
$mail->Password = '[)t]aC_.VFSv'; // SMTP password
$mail->IsHTML(true);
$mail->setFrom('admin@olympiakids.pl', 'Olympia Kids Style');
$mail->addAddress($_POST['email'], 'Subskrybent');
$mail->Subject = 'Subskrypcja Olympia Kids Style';
$mail->AltBody = 'Twój kod rabatowy';
$mail->Body = $body2;
if (!$mail->send()) {
echo "Mailer Error: " . $mail->ErrorInfo;
}else{
$hidden = ' hiddenAll';
$show = 'showAll';
//$message = '