<?php include('../include/class.php');?>

<?php


$sql = array('table'=>'member','count'=>'COUNT(id) AS count_id','where'=>"mail = '". $_POST['email']."'");
$view_sql = $view_db->view($sql);
$row = $view_db->q($view_sql);
$count_id =  $row['count_id'];

if($count_id == 1)
{
	include("../include/mail.php");

	$sql_2 = array('table'=>'member','where'=>"mail = '". $_POST['email']."'");
	$view_sql2 = $view_db->view($sql_2);
	$row2 = $view_db->q($view_sql2);
	$id_memencode = base64_encode(base64_encode($row2['id']));
	$datetimeU = date('U');
	$text = $row2['id'].'//'.$datetimeU;
	$text_encode = base64_encode(base64_encode($text));


	$to = $_POST['email'];
	$from = '[email protected]';
	$sub = 'ลืมรหัสผ่าน';
	$msg = '<b>ลืมรหัสผ่าน</b><br>'.'กรุณาคลิ๊ก เพื่อสร้างรหัสผ่านใหม่ '.'<a href="http://localhost/kainumber/member/passwordnew.php?t='.$text_encode.'">คลิ๊ก!!</a>';

	//print_r($_POST);
	$body = $msg.$contact;
	//exit;
	$mail->SetFrom($from, $from);
	$mail->AddReplyTo($from, $from);



	$mail->MsgHTML($body);
	$mail->Subject = 'kainumber - เบอร์มงคล :: '.$sub;
	$mail->AddAddress($to); // ผู้รับ

	if(!$mail->Send())
	{
		//echo "<meta http-equiv=\"refresh\" content=\"0; url=../main/index.php?menu=7&&msg=2\">";
		//echo "<br> Mailer Error: " . $mail->ErrorInfo;
		//unset($_SESSION['er']);
		//exit();
		$er = 'false';
		echo "<meta http-equiv=\"refresh\" content=\"0; url=forgotpassword_true.php?er=".$er."\">";
	}
	else
	{
		$er = 'true';
		echo "<meta http-equiv=\"refresh\" content=\"0; url=forgotpassword_true.php?er=".$er."\">";
	}


}
?>
<?php
exit;
?>