Right, I misspoke regarding the extra backslashes in the data. What you should be seeing in the comments field is:
Code:
Joe,
Have received your payment, thank you. The TEST ITEM will be shipping out tomorrow. The tracking number is sdfgskldfjsdlkfjsdlkfjsd654684.
Look forward to doing more business.
Thanks, Ted
where those \r\n sequences were converted to their CRLF equivalents.
I'm pretty sure that it's the edit_orders processing, as the built-in orders.php handling performs the database insert "directly" (i.e. using the $db->Execute function) while edit_orders uses the zen_db_perform function.
You might try editing your copy of edit_orders.php, changing this block:
Code:
$sql_data_array = array(
'orders_id' => (int)$oID,
'orders_status_id' => zen_db_input($status),
'date_added' => 'now()',
'customer_notified' => zen_db_input($customer_notified),
'comments' => zen_db_input($comments),
);
// BEGIN TY TRACKER 3 - INCLUDE DATABASE FIELDS IN STATUS UPDATE
foreach($track_id as $id => $track) {
$sql_data_array['track_id' . $id] = zen_db_input($track);
}
unset($id); unset($track);
// END TY TRACKER 3 - INCLUDE DATABASE FIELDS IN STATUS UPDATE
zen_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);
removing the calls to zen_db_input, as follows:
Code:
$sql_data_array = array(
'orders_id' => (int)$oID,
'orders_status_id' => $status,
'date_added' => 'now()',
'customer_notified' => $customer_notified,
'comments' => $comments,
);
// BEGIN TY TRACKER 3 - INCLUDE DATABASE FIELDS IN STATUS UPDATE
foreach($track_id as $id => $track) {
$sql_data_array['track_id' . $id] = $track;
}
unset($id); unset($track);
// END TY TRACKER 3 - INCLUDE DATABASE FIELDS IN STATUS UPDATE
zen_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);
Bookmarks