<?php //session_start();



include("lib/conn.php");

include "includes/libmail.php";

include ("functions.php");

if(isset($_POST)){

	

$email = $_POST['email'];

if($email!=''){

$sql = "select * from admin where email_address='".$email."'";

$qry = mysql_query($sql);

$row = mysql_num_rows($qry);

if($row > 0){
	$arr = mysql_fetch_assoc($qry);

	$id = $arr['id'];

	$name = $arr['username'];
	
	$password = rand(100000,500000);
	
	$update = mysql_query("update admin set password='".$password."' where id='".$id."'");
}else{
	$sql1 = "select * from sat_users where email='".$email."'";

	$qry1 = mysql_query($sql1);
	
	$row1 = mysql_num_rows($qry1);
	
	if($row1 > 0){
		$arr1 = mysql_fetch_assoc($qry1);

		$id = $arr1['user_id'];
	
		$name = $arr1['firstname']." ".$arr1['lastname'];
	
		$username = $arr1['username'];
	
		$password = rand(100000,500000);
		
		//$update = mysql_query("update sat_users set password='".md5($password)."' where user_id='".$id."'");
	}else{
		//header("location:forgotpass.php?error=2");
		echo '<script type="text/javascript">window.location="forgotpass.php?error=2";</script>';

		exit();
	}
}

if($row > 0 || $row1 > 0){
	
	$login_link = '<a href="http://' . $_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF']).'/" style=" font-family: Arial,Helvetica,sans-serif; font-size: 12px; text-decoration: none;">www.' . $_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF']).'/</a>';
	
	$getTemplate = check_null_value('body','sat_email_template','id','5');
	$getSubject = check_null_value('subject','sat_email_template','id','5');
	$templete_body = emailTempalte($getSubject,$getTemplate);
	
	$templete_body = str_replace("%%name%%",$name,$templete_body);
	$templete_body = str_replace("%%login_link%%",$login_link,$templete_body);
	$templete_body = str_replace("%%username%%",$username,$templete_body);
	$templete_body = str_replace("%%password%%",$password,$templete_body);
	
	/*----mail-----*/

		//$message = 'Please find the attachment file.';

		//$from_address = 'srabanti@infosolz.com';

		$from_address = 'qs@absi-usa.com';

		//$to="ABS <qs@absi-usa.com>";

		$to="ABS <".$email.">";

		//$to1="ABS <a.mitra@infosolz.com>";

		//$to1="ABS <dipanjan@infosolz.com>";

		$subject = 'Forgot Password - ABS';			

		$m= new Mail; // create the mail

		$m->From($from_address);

		$m->To($to);

		//$m->Bcc($userEmail.", ".$clientEmail.", ".$vendorEmail);

		$m->Subject($getSubject);			

		$m->Body($templete_body);	

		//$m->attach($dest);

		$m->Send();

		//exit("yes");

	/*-----end---------*/

		//echo "update sat_users set password='".md5($password)."' where id='".$id."'";

		//exit("yes");

		

		//exit("yes");
			//header("location:forgotpass.php?success=1");
			?><script>window.location.href='forgotpass.php?success=1';</script><?php
			//exit();
	}
}
}
else{
	header("location:forgotpass.php?error=1");
	exit();
}