Guest Posted February 17, 2005 Share Posted February 17, 2005 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><?phpif ($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 Sergelist ($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> <?phpif ($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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.