PHP Decode

?><?php
//ini_set('max_execution_time', 600);
require_once("../includes/config.php");
require_once("../classes/class.db.php");
require_once("../includes/custom.php");
require_once('../classes/class.email.php');
require_once('../classes/class.phpmailer.php');
global $db;
date_default_timezone_set('Asia/Calcutta');
echo $email_query="select * from ".TABLE_EMAIL." where sent_status='0' and email_date='".date('Y-m-d')."' and HOUR(email_time)=".date("H")." and MINUTE(email_time)<=".date("i");
echo '******************'.$email_count=mysql_num_rows(mysql_query($email_query));
if($email_count > 0){
	$email_result=$db->get_results($email_query);
	foreach($email_result as $email_res){
		print_r($email_res);
		$result = ARRAY();
		$email_array = array();
		if($email_res->group_name=="contact_cat"){
			if($email_res->group_id=="all"){
				$sql1 = "SELECT full_name AS name,email AS email FROM ".TABLE_CONTACT." WHERE status=1 AND email!=''";
				$result1 = $db->get_results($sql1,ARRAY_A);
				$sql2 = "SELECT full_name AS name,email AS email FROM ".TABLE_USER." WHERE status=1 AND email!=''";
				$result2 = $db->get_results($sql2,ARRAY_A);
				$result =array_merge($result1, $result2);
			}else if($email_res->group_id=="user"){
				$sql = "SELECT full_name AS name,email AS email FROM ".TABLE_USER." WHERE status=1 AND email!=''";
				$result = $db->get_results($sql,ARRAY_A);
			}else{
				$sql = "SELECT full_name AS name,email AS email FROM ".TABLE_CONTACT." WHERE status=1 AND contact_category_id=".$email_res->group_id." AND email!=''";
				$result = $db->get_results($sql,ARRAY_A);
			}
		}else if($email_res->group_name=="company_cat"){
			$sql = "SELECT  full_name AS name,email AS email FROM ".TABLE_CONTACT." AS con,".TABLE_COMPANY." AS cmp ";
			$sql .= "WHERE cmp.company_id = con.company_id AND cmp.company_category_id=".$email_res->group_id." AND con.status=1 AND con.email!=''";
			$result = $db->get_results($sql,ARRAY_A);
		}else{
			$sql = "SELECT recipient_name AS name, recipient_email_id AS email FROM ".TABLE_EMAIL_RECIPIENT." WHERE email_object_id=".$email_res->email_object_id;
			$result = $db->get_results($sql,ARRAY_A);
			$email_array_count = count($email_array);
		}
		$result = array_map("unserialize", array_unique(array_map("serialize", $result)));
		print_r($result);
		foreach($result as $recipient){
			if(filter_var($recipient['email'], FILTER_VALIDATE_EMAIL)){ 
			$mail = new PHPMailer(true);
			$mail->IsSMTP();
			$mail->IsHTML(true);
			$mail->SMTPAuth = false;
			$mail->SMTPSecure = "";
			$mail->Host = "localhost";
			$mail->Port = 25;
			$mail->SMTPDebug = true;	
			$mail->From="[email protected]";
			$mail->FromName="Autocal";
			$mail->Subject=trim(stripslashes($email_res->subject));
			$sql = "SELECT * FROM ".TABLE_EMAIL_ATTACHMENT." WHERE email_object_id=".$email_res->email_object_id;
			$result = $db->get_results($sql,ARRAY_A);
			if(count($result) > 0){
				foreach($result AS $res){
					$file=$res['file_name'];
					$mail->AddAttachment("../email_attachments/".$file);	
				}
			}
			$recipient_name = ' '.$recipient['name'];
			$message = 'Dear'.$recipient_name.',<br>'.$email_res->message;
			$mail->Body=trim(stripslashes($message));
			$mail->AddAddress($recipient['email']);
			$mail->Send();
			}
		}
		echo $query2="update ".TABLE_EMAIL." set sent_status=1 where email_object_id=".$email_res->email_object_id;
		$db->query($query2);
	}
}