<?php
if($email_server){
if(!isset($_SESSION)){session_start();}
if(isset($_GET['page'])) {
if(isset($_SESSION['user_admin']) && checkInt($_SESSION['user_admin']) && $_SESSION['user_admin']>=0) { ?>
<div class="title">
<h4><?php include("./user/name_sv.php"); ?> - Schimbare adresă email</h4>
</div>
<div class="body">

<div class="section">
<?PHP
$x=1;
$changed=0;
if(isset($_POST['request']) && $_POST['request']=="Trimite" && isset($_POST['old']) && isset($_POST['new']) && filter_var($_POST['old'], FILTER_VALIDATE_EMAIL) && filter_var($_POST['new'], FILTER_VALIDATE_EMAIL)) {
$check = "SELECT * from account.account where id='".$_SESSION['user_id']."' and email = '" . $_POST['old'] . "'";
$query = mysqli_query($sqlServ, $check);
$num = mysqli_num_rows($query);

$check_email = "SELECT * FROM account.account WHERE email = '".$_POST['new']."'";
$check_email = $sqlServ->query($check_email);
$rows_email = $check_email->num_rows;

if($rows_email<1)
{
if($num>0){

$x=0;
$code = generateRandomString(32);
$passCmd = "UPDATE account.account SET new_email_change='".$_POST['new']."', new_email_change2='".$code."' WHERE id='".$_SESSION['user_id']."' LIMIT 1;";
$passUpdate = mysqli_query($sqlServ, $passCmd);

require 'user/mailer/PHPMailerAutoload.php';

$email_from = 'noreply@'.$_SERVER['SERVER_NAME'];
$mail = new PHPMailer(); // create a new object
$mail->IsSMTP(); // enable SMTP
$mail->SMTPDebug = 0; // debugging: 1 = errors and messages, 2 = messages only
$mail->SMTPAuth = true; // authentication enabled
$mail->SMTPSecure = $email_secure; // secure transfer enabled REQUIRED for Gmail
$mail->Host = $email_host;
$mail->Port = $email_port;
$mail->IsHTML(true);
$mail->Username = $email;
$mail->Password = $email_password;
$mail->Sender=$email_from;
$mail->SetFrom($email_from, 'Metin2 Shayne');
$mail->AddReplyTo($email_from, 'Metin2 Shayne');
$mail->Subject = 'Schimbare adresa email';
$mail->AddAddress($_SESSION['email']);//$_SESSION['email']

$url = $_SERVER['REQUEST_URI']; //returns the current URL
$parts = explode('/',$url);
$dir = $_SERVER['SERVER_NAME'];
for ($i = 0; $i < count($parts) - 1; $i++) {
$dir .= $parts[$i] . "/";
}

$mail->msgHTML(file_get_contents('ht tp://'.$dir.'user/email-content.php?name='.$_SESSION['id'].'&action=3&code='.$code), dirname(__FILE__));



if (!$mail->send()) {
echo '<div class="alert alert-red" role="alert">Eroare la trimiterea mail-ului.</div>';
}
else echo '<div class="alert alert-green" role="alert">Un email ce conține un link va fi trimis către dumneavoastra curând, cu acesta puteți să vă schimbați adresa email.</div>';


}
else {
echo'<div class="alert alert-red" role="alert">
Adresă de email incorectă!
</div>';
}
}
else {
echo'<div class="alert alert-red" role="alert">
Noua adresă de email este atașată altui cont.
</div>';
}
}
if(isset($_GET['code']) && strlen($_GET['code'])==32 && !$changed)
{
$code = sanitize(stripInput($_GET['code']));

$check = "SELECT * from account.account where id='".$_SESSION['user_id']."' and new_email_change2 = '" . $code . "'";
$query = mysqli_query($sqlServ, $check);
$num = mysqli_num_rows($query);

if($num > 0) {
$x = 0;
$passCmd = "UPDATE account.account SET email=new_email_change, new_email_change='1', new_email_change2='0' WHERE id='".$_SESSION['user_id']."' LIMIT 1;";
$passUpdate = mysqli_query($sqlServ, $passCmd);
echo'<div class="alert alert-green" role="alert">
Adresa de email a fost schimbată!
</div>';
echo "<meta ht tp-equiv='refresh' content='0; URL=index.php?page=logout'>";
}
else
{
echo'<div class="alert alert-red" role="alert">
Link-ul nu este corect. E&#351;ti sigur c&#259; ai copiat corect link-ul din e-mail?
</div>';
}
}
else if(isset($_GET['code']) && strlen($_GET['code'])!=32)
{
echo'<div class="alert alert-red" role="alert">
Link-ul nu este corect. E&#351;ti sigur c&#259; ai copiat corect link-ul din e-mail?
</div>';
}
if($x)
{
?>
<form name="request" id="request" action="index.php?page=email" method="POST">
<div>
<label for="email_old">Adres&#259; veche de e-mail: *
</label>
<input type="email" name="old" class="form-control input-lg" pattern=".{7,64}" maxlength="64"/>
</div>
<div>
<label for="email_new">Adres&#259; nou&#259; de e-mail: *
</label>
<input type="email" name="new" class="form-control input-lg" pattern=".{7,64}" maxlength="64"/>
</div>
</br>
<input type="submit" name="request" value="Trimite" class="button button-green"/>
</form>
<?php } ?>
</div>
</div>
<?PHP
}
else {
echo'
<div class="alert alert-red" role="alert">
<strong>Trebuie </strong> să fi logat pentru a accesa aceast&#259; zon&#259;.
</div>
';
}
}
else {
echo 'Nu ave&#355;i permisiunea s&#259; accesa&#355;i pagina direct!';
echo "<meta h ttp-equiv='refresh' content='0; URL=../index.php'>"; }
}
else
echo "<meta ht tp-equiv='refresh' content='0; URL=index.php?page=home'>";
?>

Mailer Error: Could not execute: /usr/sbin/sendmail -t -i