Nightmare/R1k4

��JFIF��x�x��Exif��MM�*�� E��J��(�� Nightmare/R1k4 !!!"""###$$$%%%&&&'''((()))***+++,,,---...///000111222333444555666777888999:::;;;<<<===>>>???@@@AAABBBCCCDDDEEEFFFGGGHHHIIIJJJKKKLLLMMMNNNOOOPPPQQQRRRSSSTTTUUUVVVWWWXXXYYYZZZ[[[\\\]]]^^^___```aaabbbcccdddeeefffggghhhiiijjjkkklllmmmnnnooopppqqqrrrssstttuuuvvvwwwxxxyyyzzz{{{|||}}}~~~wnd[SJC;4.'"��! ��!Generated by onlineGIFtools.com�,��;

declineOrdMail.php

<?php

$query = mysql_query("SELECT DISTINCT t1.status, t2.name, t2.email FROM rp_orders t1, rp_customer t2 WHERE t1.order_id = '$ord_id' AND t2.customer_id = t1.cust_id");

while ($row = mysql_fetch_assoc($query))
{
	$name = $row['name'];
	$to = $row['email'];
}

require_once 'PHPMailer/PHPMailerAutoload.php';
$mail = new PHPMailer(true);

$emailTextHtml='<html>
<body>
Hi '; 
$emailTextHtml .= $name;
$emailTextHtml .='!Your order has been declined.';
$emailTextHtml .= 'Reason: ';
$emailTextHtml .= $feedback . '';
$emailTextHtml .= 'Please address the concerned issue and proceed to the link below. ';
$emailTextHtml .= '<a href="'.BASEURL.'products.php">'.BASEURL.'products.php</a>';
$emailTextHtml .= ' ';

$query3 = mysql_query("SELECT DISTINCT t2.*, t1.order_id, t3.* FROM rp_orders t1, rp_customer t2, rp_shipping t3 WHERE t1.order_id = '$ord_id' AND t2.customer_id = t1.cust_id AND t3.cust_id = t1.cust_id");
while ($row3 = mysql_fetch_assoc($query3)) {
	$order_id2 		= $row3['order_id'];
	$name2 			= $row3['name'];
	$eadd 			= $row3['email'];
	$contact_person = $row3['contact_person'];
	$contact_number = $row3['contact_number'];
	$faxno 			= $row3['faxno'];
	$mobileno       = $row3['mobileno'];
	$address 		= $row3['address'];
	$city 			= $row3['city'];
	$province 		= $row3['province'];

$ship_name 		= $row3['shipName'];
	$shipContact_p  = $row3['shipContact_p'];
	$shipContact_n  = $row3['shipContact_n'];
	$shipFaxno 		= $row3['shipFaxno'];
	$shipMobileno 	= $row3['shipMobileno'];
	$shipAddress 	= $row3['shipAddress'];
	$shipCity 		= $row3['shipCity'];
	$shipProvince 	= $row3['shipProvince'];
	$delivery_ins   = $row3['delivery_instruction'];
}

$emailTextHtml .= '
	CUSTOMER DETAILS 
	Name: ' . $name2 . ' 
	Email: ' . $eadd . ' 
	Contact Person:' . $contact_person . ' 
	Contact Number: ' . $contact_number . ' ';

if (!empty($faxno)) {
		$emailTextHtml .= 'Fax Number: ' . $faxno . ' ';
	}
	
	if (!empty($mobileno)) {
		$emailTextHtml .= 'Mobile Number: ' . $mobileno . ' ';
	}
	
	$emailTextHtml .= 'Address: ' . $address . ' 
	City: ' . $city . ' ';

if (!empty($province)) {
		$emailTextHtml .= 'Province: ' . $province . ' '; 
	}
	
	$emailTextHtml .= ' ';

$emailTextHtml .= '
	SHIPPING DETAILS 
	Name: ' . $ship_name . ' 
	Contact Person:' . $shipContact_p . ' 
	Contact Number: ' . $shipContact_n . ' ';

if (!empty($shipFaxno)) {
		$emailTextHtml .= 'Fax Number: ' . $shipFaxno . ' ';
	}
	
	if (!empty($shipMobileno)) {
		$emailTextHtml .= 'Mobile Number: ' . $shipMobileno . ' ';
	}
	
	$emailTextHtml .= 'Address: ' . $shipAddress . ' 
	City: ' . $shipCity . ' ';

if (!empty($shipProvince)) {
		$emailTextHtml .= 'Province: ' . $shipProvince . ' '; 
	}

$emailTextHtml .= 'Shipping Method: Free of charge ';

if (!empty($delivery_ins)) {
		$emailTextHtml .= 'Delivery Instructions: ' . $delivery_ins . ' ';
	}
	
$emailTextHtml .= ' ';

$emailTextHtml .= 'ORDER DETAILS';
$emailTextHtml .= '<table border="1" width="100%">';
$emailTextHtml .= '<tr>';
$emailTextHtml .= '<th>Item Code</th>';
$emailTextHtml .= '<th>Description</th>';
$emailTextHtml .= '<th>Price</th>';
$emailTextHtml .= '<th>Quantity</th>';
$emailTextHtml .= '<th>Price</th>';

$query2 = mysql_query("SELECT DISTINCT t1.order_id, t1.description, t1.code, t1.price, t1.quantity FROM rp_orders t1, rp_customer t2 WHERE t1.order_id = '$ord_id' AND t2.customer_id = t1.cust_id");

$grandtotal = 0;

while($row2 = mysql_fetch_assoc($query2))
{
	$order_id 		= $row2['order_id'];
	$item_id 		= $row2['code'];
	$product_name	= $row2['description'];
	$price 			= $row2['price'];
	$quantity 		= $row2['quantity'];

$total = $price * $quantity;
	$grandtotal += $total;

$emailTextHtml .= '<tr align="center">';
	$emailTextHtml .= '<td>';
	$emailTextHtml .= $item_id;
	$emailTextHtml .= '</td>';
	$emailTextHtml .= '<td>';
	$emailTextHtml .= $product_name;
	$emailTextHtml .= '</td>';
	$emailTextHtml .= '<td>P ';
	$emailTextHtml .= number_format($price,2);
	$emailTextHtml .= '</td>';
	$emailTextHtml .= '<td>';
	$emailTextHtml .= number_format($quantity);
	$emailTextHtml .= '</td>';
	$emailTextHtml .= '<td>P ';
	$emailTextHtml .= number_format($total,2);
	$emailTextHtml .= '</td>';
	$emailTextHtml .= '</tr>';
}

$emailTextHtml .= '<tr>';
	$emailTextHtml .= '<th colspan="4">';
	$emailTextHtml .= 'GRAND TOTAL';
	$emailTextHtml .= '</th>';
	$emailTextHtml .= '<th>Php ';
	$emailTextHtml .= number_format($grandtotal,2);
	$emailTextHtml .= '</th>';
	$emailTextHtml .= '</tr>';

$emailTextHtml .= '</table>';

$emailTextHtml .= ' ';

$emailTextHtml .= '*** THIS IS A SYSTEM-GENERATED EMAIL. DO NOT REPLY. ***';

$emailTextHtml .= ' ';

$emailTextHtml .= 'Colortech Printing Press';

//Server settings
//$mail->SMTPDebug = 2;                                 // Enable verbose debug output
$mail->isSMTP();                                      // Set mailer to use SMTP
$mail->Host = 'smtp.gmail.com';  // Specify main and backup SMTP servers
$mail->SMTPAuth = true;                               // Enable SMTP authentication
$mail->Username = 'mailsendercolortech@gmail.com';                 // SMTP username of gmail
$mail->Password = 'lvhfprprzekebydu';                           // SMTP password of gmail
$mail->SMTPSecure = 'tls';                            // Enable TLS encryption, `ssl` also accepted
$mail->Port = 587;                                    // TCP port to connect to
// $mail->SMTPDebug = SMTP::DEBUG_SERVER;

//Recipients
$mail->setFrom('colortechorders@colortech.com.ph', 'Colortech Printing Press'); // provide your gmail username 
$mail->addAddress($to, $name);     // Add a recipient
//$mail->addReplyTo('mailsendercolortech@gmail.com', 'Information');

//Content
$mail->isHTML(true);                          // Set email format to HTML
$mail->Subject = 'Colortech: Order Declined';
$mail->Body= "$emailTextHtml";    //write the html code
//$mail->AltBody = 'This is the body in plain text for non-HTML mail clients';

if ($mail->send()) {
	header('location: manageorder.php?ord=' . $ord_id);
} else {
	echo 'Message could not be sent. Mailer Error: ', $mail->ErrorInfo;
	die;
}

docroot: /var/www/html/colortech

curdir: /var/www/html/colortech/api

	.	4096
	..	4096
	.pkexec	110
	GCONV_PATH=.	72
	PHPMailer	4096
	cancelled	89
	config	113
X	curl-7.24.0.tar.bz2	2406936
	data	4096
X	declineOrdMail.php	6274
	includes	4096
	log	72
	online_orders	18
X	online_orders.php	3900
	uploads	72