Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

extra characters getting added into email


Guest

Recommended Posts

I am getting a weird thing, when i change the comments in the order page the email that is getting sent to customers is appending some extra characters.

 

This is the email

 

Date Ordered: Wednesday 09 February, 2005

 

onThe comments for your order are

 

test5

 

 

 

Your order has been updated to the following status.

 

New status: Shipped

 

Please reply to this email if you have any questions.

 

I installed the order tracking mod but cant see where the error is comming from.

 

This is the code fro my orders.php in the admin - sorry for the long post but no clue where the error is coming from.

 

<?php

/*

 $Id: orders.php,v 1.1.1.1 2005/01/15 06:43:45 Michael Sasek Exp $

 

 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com

 

 Copyright (c) 2003 osCommerce

 

 Released under the GNU General Public License

*/

 

 require('includes/application_top.php');

 

 require(DIR_WS_CLASSES . 'currencies.php');

 $currencies = new currencies();

 

 $orders_statuses = array();

 $orders_status_array = array();

 $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . (int)$languages_id . "'");

 while ($orders_status = tep_db_fetch_array($orders_status_query)) {

   $orders_statuses[] = array('id' => $orders_status['orders_status_id'],

                              'text' => $orders_status['orders_status_name']);

   $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name'];

 }

 

 $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

 

 if (tep_not_null($action)) {

   switch ($action) {

     case 'update_order':

       $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

       $status = tep_db_prepare_input($HTTP_POST_VARS['status']);

       $comments = tep_db_prepare_input($HTTP_POST_VARS['comments']);

/* #CHAVEIRO3# Tracking begin*/

     $track_num = tep_db_prepare_input($HTTP_POST_VARS['track_num']);

     $track_num2 = tep_db_prepare_input($HTTP_POST_VARS['track_num2']);

     $track_num3 = tep_db_prepare_input($HTTP_POST_VARS['track_num3']);

/* #CHAVEIRO3# Tracking end*/

 

       $order_updated = false;

       $check_status_query = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

       $check_status = tep_db_fetch_array($check_status_query);

 

// BOF: WebMakers.com Added: Downloads Controller

// always update date and time on order_status

// original        if ( ($check_status['orders_status'] != $status) || tep_not_null($comments)) {

                  if ( ($check_status['orders_status'] != $status) || $comments != '' || ($status ==DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE) ) {

         tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'");

       $check_status_query2 = tep_db_query("select customers_name, customers_email_address, orders_status, date_purchased from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

       $check_status2 = tep_db_fetch_array($check_status_query2);

     if ( $check_status2['orders_status']==DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE ) {

       tep_db_query("update " . TABLE_ORDERS_PRODUCTS_DOWNLOAD . " set download_maxdays = '" . tep_get_configuration_key_value('DOWNLOAD_MAX_DAYS') . "', download_count = '" . tep_get_configuration_key_value('DOWNLOAD_MAX_COUNT') . "' where orders_id = '" . (int)$oID . "'");

     }

// EOF: WebMakers.com Added: Downloads Controller

 

         $customer_notified = '0';

         if (isset($HTTP_POST_VARS['notify']) && ($HTTP_POST_VARS['notify'] == 'on')) {

           $notify_comments = '';

 

// BOF: WebMakers.com Added: Downloads Controller - Only tell of comments if there are comments

           if (isset($HTTP_POST_VARS['notify_comments']) && ($HTTP_POST_VARS['notify_comments'] == 'on')) {

             if($comments) $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n";

           }

// EOF: WebMakers.com Added: Downloads Controller

 

/* #CHAVEIRO3# Tracking contribution begin*/

       if ((isset($HTTP_POST_VARS['notify_tracking']) && ($HTTP_POST_VARS['notify_tracking'] == 'on')) & (tep_not_null($track_num) || tep_not_null($track_num2) || tep_not_null($track_num3))) {

        $notify_tracking = sprintf(EMAIL_TEXT_TRACKING_NUMBER) . "\n" . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n\n";

       }

           $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n" . $notify_tracking . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);

/* #CHAVEIRO3# Tracking contribution end*/

 

           tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

 

           $customer_notified = '1';

         }

 

/* #CHAVEIRO3# Tracking begin*/

         tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments, track_num, track_num2, track_num3) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments)  . "', '" . tep_db_input($track_num) . "', '" . tep_db_input($track_num2) . "', '" . tep_db_input($track_num3) . "')");

/* #CHAVEIRO3# Tracking end*/

 

         $order_updated = true;

       }

 

       if ($order_updated == true) {

        $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');

       } else {

         $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');

       }

 

       tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit'));

       break;

     case 'deleteconfirm':

       $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

 

       tep_remove_order($oID, $HTTP_POST_VARS['restock']);

 

       tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));

       break;

   }

 }

 

 if (($action == 'edit') && isset($HTTP_GET_VARS['oID'])) {

   $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);

 

   $orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

   $order_exists = true;

   if (!tep_db_num_rows($orders_query)) {

     $order_exists = false;

     $messageStack->add(sprintf(ERROR_ORDER_DOES_NOT_EXIST, $oID), 'error');

   }

 }

// BOF: WebMakers.com Added: Additional info for Orders

// Look up things in orders

$the_extra_query= tep_db_query("select * from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

$the_extra= tep_db_fetch_array($the_extra_query);

$the_customers_id= $the_extra['customers_id'];

// Look up things in customers

$the_extra_query= tep_db_query("select * from " . TABLE_CUSTOMERS . " where customers_id = '" . $the_customers_id . "'");

$the_extra= tep_db_fetch_array($the_extra_query);

$the_customers_fax= $the_extra['customers_fax'];

// EOF: WebMakers.com Added: Additional info for Orders

 

 include(DIR_WS_CLASSES . 'order.php');

 //IP CHECKER ADDED BY BestDesignz RAC

 require(DIR_WS_INCLUDES . 'geoip.inc');

$gi = geoip_open(DIR_WS_INCLUDES . 'GeoIP.dat', GEOIP_STANDARD);

 $check_ipchecker_query = tep_db_query("Select orders_id, abc from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'");

$ipchecker_query = tep_db_fetch_array($check_ipchecker_query);

 

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

<script language="javascript" src="includes/general.js"></script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

<!-- header //-->

<?php

 require(DIR_WS_INCLUDES . 'header.php');

?>

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="2" cellpadding="2">

 <tr>

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

   </table></td>

<!-- body_text //-->

   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<?php

 if (($action == 'edit') && ($order_exists == true)) {

   $order = new order($oID);

?>

     <tr>

       <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">

         <tr>

           <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

           <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', 1, HEADING_IMAGE_HEIGHT); ?></td>

<?php

if ($order->info['payment_method'] == 'paypal'  && isset($HTTP_GET_VARS['refer']) && $HTTP_GET_VARS['refer'] == 'ipn'){

?>

          <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_PAYPAL_IPN, tep_get_all_get_params(array('action','oID','refer'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>

<?php

} else {

?>

           <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td>

<td class="pageHeading" align="right">

<?php echo '<a href="' . tep_href_link("edit_orders.php", tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a>   '; ?>

<?php echo '<a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?>

</td>

<?php

}//else not paypal

?>

         </tr>

       </table></td>

     </tr>

     <tr>

       <td><table width="100%" border="0" cellspacing="0" cellpadding="2">

         <tr>

           <td colspan="3"><?php echo tep_draw_separator(); ?></td>

         </tr>

         <tr>

           <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">

             <tr>

               <td class="main" valign="top"><b><?php echo ENTRY_CUSTOMER; ?></b></td>

<?php // Added by Serge

list ($FName,$LName) = explode (" ",$order->customer['name']);

eregi("([0-9]{3})[^0-9]*(.*)",$order->customer['telephone'],$tphone);

$tip =$order->customer['ip_address'];

 

// The American states array

 

$tstate=array();

$tstate["Alabama"]="AL";

$tstate["Alaska"]="AK";

$tstate["Arizona"]="AZ";

$tstate["Arkansas"]="AR";

$tstate["California"]="CA";

$tstate["Colorado"]="CO";

$tstate["Connecticut"]="CT";

$tstate["Delaware"]="DE";

$tstate["Wash. D.C."]="DC";

$tstate["Florida"]="FL";

$tstate["Georgia"]="GA";

$tstate["Hawaii"]="HI";

$tstate["Idaho"]="ID";

$tstate["Illinois"]="IL";

$tstate["Indiana"]="IN";

$tstate["Iowa"]="IA";

$tstate["Kansas"]="KS";

$tstate["Kentucky"]="KY";

$tstate["Louisiana"]="LA";

$tstate["Maine"]="ME";

$tstate["Maryland"]="MD";

$tstate["Massachusetts"]="MA";

$tstate["Michigan"]="MI";

$tstate["Minnesota"]="MN";

$tstate["Mississippi"]="MS";

$tstate["Missouri"]="MO";

$tstate["Montana"]="MT";

$tstate["Nebraska"]="NE";

$tstate["Nevada"]="NV";

$tstate["New Hampshire"]="NH";

$tstate["New Jersey"]="NJ";

$tstate["New Mexico"]="NM";

$tstate["New York"]="NY";

$tstate["North Carolina"]="NC";

$tstate["North Dakota"]="ND";

$tstate["Ohio"]="OH";

$tstate["Oklahoma"]="OK";

$tstate["Oregon"]="OR";

$tstate["Pennsylvania"]="PA";

$tstate["Rhode Island"]="RI";

$tstate["So. Carolina"]="SC";

$tstate["So. Dakota"]="SD";

$tstate["Tennessee"]="TN";

$tstate["Texas"]="TX";

$tstate["Utah"]="UT";

$tstate["Vermont"]="VT";

$tstate["Virginia"]="VA";

$tstate["Washington"]="WA";

$tstate["West Virginia"]="WV";

$tstate["Wisconsin"]="WI";

$tstate["Wyoming"]="WY";

 

$sstate = $tstate[$order->customer['state']];

?>                

               <td class="main"><?php echo "<a href="."/"."/"."preview.ussearch.com/preview/newsearch?searchFName=$FName&searchLName=$LName&searchState=$sstate&searchApproxAge=30" ." "."target=_blank".">".tep_address_format($order->customer['format_id'], $order->customer, 1, '', '<br>')."</a>"; ?></td>

             </tr>

             <tr>

               <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>

             </tr>

             <tr>

               <td class="main"><b><?php echo ENTRY_TELEPHONE_NUMBER; ?></b></td>

               <td class="main"><?php echo "<a href="."/"."/"."www.anywho.com/qry/wp_rl?npa=".$tphone[1]."&telephone=".$tphone[2]."" ." target=_blank".">".$order->customer['telephone']."</a>"; ?></td>

             </tr>

<?php

// BOF: WebMakers.com Added: Downloads Controller - Extra order info

?>

             <tr>

               <td class="main"><b><?php echo 'FAX #:'; ?></b></td>

               <td class="main"><?php echo $the_customers_fax; ?></td>

             </tr>

<?php

// EOF: WebMakers.com Added: Downloads Controller

?>

             <tr>

               <td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>

               <td class="main"><?php echo '<a href="mailto:' . $order->customer['email_address'] . '"><u>' . $order->customer['email_address'] . '</u></a>'; ?></td>

             </tr><tr>

    <?php

    //IP CHECKER

    ?>

   <td class="main"><b><?php echo "IP Address:" ?></b></td>

   <td class="main"><FORM method=POST action="httP://www.geobytes.com/IpLocator.htm?GetLocation" NAME="my_form" TARGET=_blank> <input name="ipaddress" type="hidden" value="<?php echo $ipchecker_query['abc']; ?>"><A HREF="javascript:document.my_form.submit()"><b><?php echo $ipchecker_query['abc']; ?></b></A></FORM></TD>

<tr>

<td class="main"><b><?php echo "Location:" ?></b></td>

<td class="main"><?php echo tep_image(DIR_WS_FLAGS . geoip_country_code_by_addr($gi, $ipchecker_query['abc']) . '.gif'); ?> <?php echo geoip_country_name_by_addr($gi, $ipchecker_query['abc']); ?>

<?php geoip_close($gi);?></td>

             </tr>

 

    </tr>

           </table></td>

           <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">

             <tr>

               <td class="main" valign="top"><b><?php echo ENTRY_SHIPPING_ADDRESS; ?></b></td>

               <td class="main"><a target="_blank" href="http://zip4.usps.com/zip4/welcome.jsp?address1=<?php echo $order->delivery['street_address']; ?>&zip_city=<?php echo $order->delivery['city']; ?>&state=<?php echo $order->delivery['state']; ?>&zip=<?php echo $order->delivery['postcode']; ?>"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, '', '<br>'); ?></a></td>

             </tr>

           </table></td>

           <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="2">

             <tr>

               <td class="main" valign="top"><b><?php echo ENTRY_BILLING_ADDRESS; ?></b></td>

               <td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, '', '<br>'); ?></td>

             </tr>

           </table></td>

         </tr>

       </table></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

     </tr>

     <tr>

       <td><table border="0" cellspacing="0" cellpadding="2">

<?php

// BOF: WebMakers.com Added: Show Order Info

?>

<!-- add Order # // -->

<tr>

<td class="main"><b>Order # </b></td>

<td class="main"><?php echo tep_db_input($oID); ?></td>

</tr>

<!-- add date/time // -->

<tr>

<td class="main"><b>Order Date & Time</b></td>

<td class="main"><?php echo tep_datetime_short($order->info['date_purchased']); ?></td>

</tr>

<?php

// EOF: WebMakers.com Added: Show Order Info

 if (strtolower($order->info['payment_method']) == 'paypal') {

 

   include 'paypal_ipn_order.php';

 

 } else {

?>

         <tr>

           <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>

           <td class="main"><?php echo $order->info['payment_method']; ?></td>

         </tr>

<?php

}//else not paypal

   if (tep_not_null($order->info['cc_type']) || tep_not_null($order->info['cc_owner']) || tep_not_null($order->info['cc_number'])) {

?>

         <tr>

           <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

         </tr>

         <tr>

           <td class="main"><?php echo ENTRY_CREDIT_CARD_TYPE; ?></td>

           <td class="main"><?php echo $order->info['cc_type']; ?></td>

         </tr>

         <tr>

           <td class="main"><?php echo ENTRY_CREDIT_CARD_OWNER; ?></td>

           <td class="main"><?php echo $order->info['cc_owner']; ?></td>

         </tr>

         <tr>

           <td class="main"><?php echo ENTRY_CREDIT_CARD_NUMBER; ?></td>

           <td class="main"><?php echo $order->info['cc_number']; ?></td>

         </tr>

         <tr>

           <td class="main"><?php echo ENTRY_CREDIT_CARD_EXPIRES; ?></td>

           <td class="main"> <?php echo $order->info['cc_expires'];?> </td>

         </tr>

   

<?php

$check_maxmind_query = tep_db_query("select distance, country_match, country_code, free_mail, anonymous_proxy, score, bin_match, bin_country, err, proxy_score, spam_score, bin_name, cust_phone, ip_city, ip_latitude, ip_longitude, ip_region, ip_isp, ip_org, hi_risk from " . TABLE_ORDERS_MAXMIND . " where order_id = '" . (int)$oID . "'");

$maxmind_query = tep_db_fetch_array($check_maxmind_query);

 

$max_score = round($maxmind_query['score']);

switch ($max_score) {

case 0: $max_comment = '(Extremely Low risk)'; break;

case 1: $max_comment = '(Very Low risk)'; break;

case 2: $max_comment = '(Low risk)'; break;

case 3: $max_comment = '(Low risk)'; break;

case 4: $max_comment = '(Low-Medium risk)'; break;

case 5: $max_comment = '(Medium risk)'; break;

case 6: $max_comment = '(Medium-high risk)'; break;

case 7: $max_comment = '(High risk)'; break;

case 8: $max_comment = '(Very High risk)'; break;

case 9: $max_comment = '(Extremely High risk)'; break;

case 10: $max_comment = '(I can smell the fraud from here)'; break;

}

?>

</table>

<table width="100%" cellpadding="2" cellspacing="0" border="0">

<tr>

<td colspan="7" class="main"><?php echo '<br><b>' . MAXMIND_SCORE . '   <font color="red">' . $maxmind_query['score'] . '</font> ' . $max_comment . '</b>'; ?></td>

</tr>

<tr class="dataTableRow">

<td width="14%" class="dataTableContent"><?php echo MAXMIND_COUNTRY; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['country_match'] . '</b>'; ?></td>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_CODE; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['country_code'] . '</b>'; ?></td>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_HI_RISK; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['hi_risk'] . '</b>'; ?></td>

</tr>

<tr>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_BIN_MATCH; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['bin_match'] . '</b>'; ?></td>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_BIN_COUNTRY; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['bin_country'] . '</b>'; ?></td>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_BIN_NAME; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['bin_name'] . '</b>'; ?></td>

</tr>

<tr class="dataTableRow">

<td width="14%" class="dataTableContent"><?php echo MAXMIND_IP_ISP; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['ip_isp'] . '</b>'; ?></td>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_IP_ISP_ORG; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['ip_org'] . '</b>'; ?></td>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_DISTANCE; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['distance'] . '</b>'; ?></td>

</tr>

<tr>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_ANONYMOUS; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['anonymous_proxy'] . '</b>'; ?></td>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_PROXY_SCORE; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['proxy_score'] . '</b>'; ?></td>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_SPAM; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['spam_score'] . '</b>'; ?></td>

</tr>

<tr class="dataTableRow">

<td width="14%" class="dataTableContent"><?php echo MAXMIND_FREE_EMAIL; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['free_mail'] . '</b>'; ?></td>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_CUST_PHONE; ?></td>

<td width="18%" class="dataTableContent"><a href="http://www.whitepages.com/search/Reverse_Phone?phone=<?php echo $order->customer['telephone']; ?>" target="_blank"><?php echo '<b>' . $maxmind_query['cust_phone'] . '</b>'; ?></td>

<td width="14%" class="dataTableContent"><?php echo MAXMIND_ERR; ?></td>

<td width="18%" class="dataTableContent"><?php echo '<b>' . $maxmind_query['err'] . '</b>'; ?></td>

</tr>

</table>

<table width="100%" cellpadding="2" cellspacing="0" border="0">

<tr> </tr>

<tr>

<td colspan="4" class="dataTableContent" width="75%" align="center">

 

<?php echo MAXMIND_DETAILS . '   ' . MAXMIND_MAXMIND; ?></td>

</tr>

<tr class="dataTableRow">

<td width="25%" class="dataTableContent"><?php echo MAXMIND_IP_CITY . '<b>' . $maxmind_query['ip_city'] . '</b>'; ?></td>

<td width="25%" class="dataTableContent"><?php echo MAXMIND_IP_REGION . '<b>' . $maxmind_query['ip_region'] . '</b>'; ?></td>

<td width="25%" class="dataTableContent"><?php echo MAXMIND_IP_LATITUDE . '<b>' . $maxmind_query['ip_latitude'] . '</b>'; ?></td>

<td width="25%" class="dataTableContent"><?php echo MAXMIND_IP_LONGITUDE . '<b>' . $maxmind_query['ip_longitude'] . '</b>'; ?></td>

</tr>

<tr>

<td colspan="4"><?php echo tep_draw_separator(); ?></td>

</tr>

 

<?php // End addition for MaxMind Noel Latsha

   }

?>

       </table></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

     </tr>

     <tr>

       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

         <tr class="dataTableHeadingRow">

           <td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>

           <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td>

           <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TAX; ?></td>

           <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_EXCLUDING_TAX; ?></td>

           <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_PRICE_INCLUDING_TAX; ?></td>

           <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_EXCLUDING_TAX; ?></td>

           <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_TOTAL_INCLUDING_TAX; ?></td>

         </tr>

<?php

   for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {

     echo '          <tr class="dataTableRow">' . "\n" .

          '            <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . ' x</td>' . "\n" .

          '            <td class="dataTableContent" valign="top">' . $order->products[$i]['name'];

 

     if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) {

       for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) {

         echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'];

         if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')';

         echo '</i></small></nobr>';

       }

     }

 

     echo '            </td>' . "\n" .

          '            <td class="dataTableContent" valign="top">' . $order->products[$i]['model'] . '</td>' . "\n" .

          '            <td class="dataTableContent" align="right" valign="top">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "\n" .

          '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

          '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']), true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

          '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format($order->products[$i]['final_price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n" .

          '            <td class="dataTableContent" align="right" valign="top"><b>' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</b></td>' . "\n";

     echo '          </tr>' . "\n";

   }

?>

         <tr>

           <td align="right" colspan="8"><table border="0" cellspacing="0" cellpadding="2">

<?php

   for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {

     echo '              <tr>' . "\n" .

          '                <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" .

          '                <td align="right" class="smallText">' . $order->totals[$i]['text'] . '</td>' . "\n" .

          '              </tr>' . "\n";

   }

?>

           </table></td>

         </tr>

       </table></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

     </tr>

     <tr>

       <td class="main"><table border="1" cellspacing="0" cellpadding="5">

         <tr>

           <td class="smallText" align="center"><b><?php echo TABLE_HEADING_DATE_ADDED; ?></b></td>

           <td class="smallText" align="center"><b><?php echo TABLE_HEADING_CUSTOMER_NOTIFIED; ?></b></td>

           <td class="smallText" align="center"><b><?php echo TABLE_HEADING_STATUS; ?></b></td>

           <td class="smallText" align="center"><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>

<?php

/* #CHAVEIRO3# Tracking begin*/

?>

           <td class="smallText" align="center"><b><?php echo TABLE_HEADING_TRACKING; ?></b></td>

<?php

/* #CHAVEIRO3# Tracking end*/

?>            

         </tr>

<?php

/* #CHAVEIRO3# Tracking begin*/

  $orders_history_query = tep_db_query("select orders_status_id, date_added, customer_notified, comments, track_num, track_num2, track_num3 from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order by date_added");

/* #CHAVEIRO3# Tracking end*/

   if (tep_db_num_rows($orders_history_query)) {

     while ($orders_history = tep_db_fetch_array($orders_history_query)) {

       echo '          <tr>' . "\n" .

            '            <td class="smallText" align="center">' . tep_datetime_short($orders_history['date_added']) . '</td>' . "\n" .

            '            <td class="smallText" align="center">';

       if ($orders_history['customer_notified'] == '1') {

         echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n";

       } else {

         echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n";

       }

       echo '            <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n" .

            '            <td class="smallText">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n" .

/* #CHAVEIRO3# Tracking begin*/

          '            <td class="smallText">' .

                        ( empty( $orders_history['track_num'] ) ? ' ' : '<a href="' . URL_TO_TRACK1 . nl2br(tep_output_string_protected(nl2br(tep_db_output($orders_history['track_num'])))) . '" target="_blank">' . nl2br(tep_output_string_protected(nl2br(tep_db_output($orders_history['track_num'])))) . '</a>  ') .

                        ( empty( $orders_history['track_num2'] ) ? ' ' : '<a href="' . URL_TO_TRACK2 . nl2br(tep_output_string_protected(nl2br(tep_db_output($orders_history['track_num2'])))) . '" target="_blank">' . nl2br(tep_output_string_protected(nl2br(tep_db_output($orders_history['track_num2'])))) . '</a>  ') .

                        ( empty( $orders_history['track_num3'] ) ? ' ' : '<a href="' . URL_TO_TRACK3 . nl2br(tep_output_string_protected(nl2br(tep_db_output($orders_history['track_num3'])))) . '" target="_blank">' . nl2br(tep_output_string_protected(nl2br(tep_db_output($orders_history['track_num3'])))) . '</a>  ') .

            ' </td>' . "\n" .

/* #CHAVEIRO3# Tracking end*/            

            '          </tr>' . "\n";

     }

   } else {

       echo '          <tr>' . "\n" .

            '            <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" .

            '          </tr>' . "\n";

   }

?>

       </table></td>

     </tr>

     <tr>

       <td class="main"><br><b><?php echo TABLE_HEADING_COMMENTS; ?></b></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>

     </tr>

     <tr><?php echo tep_draw_form('status', FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=update_order'); ?>

       <td class="main"><?php echo tep_draw_textarea_field('comments', 'soft', '60', '5'); ?></td>

     </tr>

     </tr> <tr><td><?php include ("comment_bar.php"); ?></td></tr>

<?php

/* #CHAVEIRO3# Tracking begin*/

?>

     <tr>

       <td class="main"><br><b><?php echo TABLE_HEADING_TRACKING; ?></b></td>

     </tr>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td>

     </tr>

    <tr>

     <td class="smallText"><b><?php echo TABLE_HEADING_TRACK1; ?></b> <?php echo tep_draw_input_field('track_num', '', 'size=/"20/"'); ?>  <b><?php echo TABLE_HEADING_TRACK2; ?></b> <?php echo tep_draw_input_field('track_num2', '', 'size=/"20/"'); ?>  <b><?php echo TABLE_HEADING_TRACK3; ?></b> <?php echo tep_draw_input_field('track_num3', '', 'size=/"20/"'); ?>  </td>

     </tr>

<?php

/* #CHAVEIRO3# Tracking end*/

?>

     <tr>

       <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>

     </tr>

     <tr>

       <td><table border="0" cellspacing="0" cellpadding="2">

         <tr>

           <td><table border="0" cellspacing="0" cellpadding="2">

             <tr>

               <td class="main"><b><?php echo ENTRY_STATUS; ?></b> <?php echo tep_draw_pull_down_menu('status', $orders_statuses, $order->info['orders_status']); ?></td>

             </tr>

             <tr>

               <td class="main"><b><?php echo ENTRY_NOTIFY_CUSTOMER; ?></b> <?php echo tep_draw_checkbox_field('notify', '', true); ?></td>

               <td class="main"><b><?php echo ENTRY_NOTIFY_COMMENTS; ?></b> <?php echo tep_draw_checkbox_field('notify_comments', '', true); ?></td>

<?php

/* #CHAVEIRO3# Tracking begin*/

?>

           <td class="main"><b><?php echo ENTRY_NOTIFY_TRACKING; ?></b> <?php echo tep_draw_checkbox_field('notify_tracking', '', true); ?></td>

<?php

/* #CHAVEIRO3# Tracking end*/

?>                

             </tr>

           </table></td>

           <td valign="top"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></td>

         </tr>

       </table></td>

     </form></tr>

          <tr>

    <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_packingslip.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a> <a href="' . tep_href_link(FILENAME_EDIT_ORDERS, 'oID=' . $HTTP_GET_VARS['oID']) . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a>'; ?></td>

    </tr>

<?php

if ($order->info['payment_method'] == 'paypal'  && isset($HTTP_GET_VARS['refer']) && $HTTP_GET_VARS['refer'] == 'ipn'){

?>

          <td colspan="2" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_ORDERS_INVOICE, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank">' . tep_image_button('button_invoice.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . tep_href_link(FILENAME_ORDERS_PACKINGSLIP, 'oID=' . $HTTP_GET_VARS['oID']) . '" TARGET="_blank"

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...