$orderStatus = $tmpOrderStatus; $comment = MODULE_PAYMENT_SOFORT_ERROR_UNEXPECTED_STATUS . " " . $status . " " . $statusReasonStr; $errUnexpected = true; echo MODULE_PAYMENT_SOFORT_ERROR_UNEXPECTED_STATUS; } if (!isset($errUnexpected) || isset($errUnexpected) && !$errUnexpected) { $comment = $statusReasonStr; echo MODULE_PAYMENT_SOFORT_SUCCESS_CALLBACK; } $tId = $transactionId; // Mandatory for replacement in following line $comment = preg_replace('#\\{\\{([a-zA-Z0-9_]+)\\}\\}#e', '$$1', $comment); // Set paymentMethod, tId and time $sofortNotificationStatus = $orderStatus; if ($orderStatus != $checkOrderStatus) { $allCurrentOrderStatus = HelperFunctions::getAllCurrentOrderStatus($xOrderId); if (!empty($allCurrentOrderStatus['sofortOrdersStatus']) && $allCurrentOrderStatus['sofortOrdersStatus'] != $allCurrentOrderStatus['coreStatus']) { $orderStatus = $allCurrentOrderStatus['coreStatus']; } } if ($_GET['action'] == 'ideal') { // iDeal: set transactionId to history $sqlDataArray = array('orders_id' => $xOrderId, 'orders_status_id' => $tmpOrderStatus, 'date_added' => 'sqlcommand:now()', 'customer_notified' => 0, 'comments' => MODULE_PAYMENT_SOFORT_MULTIPAY_TRANSACTION_ID . ': ' . $transactionId); xtc_db_query(HelperFunctions::getEscapedInsertInto(TABLE_ORDERS_STATUS_HISTORY, $sqlDataArray)); $sqlDataArray = array('orders_id' => $xOrderId, 'orders_status_id' => $orderStatus, 'date_added' => 'sqlcommand:now()', 'customer_notified' => 0, 'comments' => addslashes($comment)); xtc_db_query(HelperFunctions::getEscapedInsertInto(TABLE_ORDERS_STATUS_HISTORY, $sqlDataArray)); xtc_db_query("UPDATE " . HelperFunctions::escapeSql(TABLE_ORDERS) . " SET orders_status = '" . HelperFunctions::escapeSql($orderStatus) . "', last_modified = NOW() WHERE orders_id = '" . (int) $xOrderId . "'"); } else { $sqlDataArray = array('orders_id' => $xOrderId, 'orders_status_id' => $orderStatus, 'date_added' => 'sqlcommand:now()', 'customer_notified' => 0, 'comments' => addslashes($comment)); xtc_db_query(HelperFunctions::getEscapedInsertInto(TABLE_ORDERS_STATUS_HISTORY, $sqlDataArray)); xtc_db_query("UPDATE " . HelperFunctions::escapeSql(TABLE_ORDERS) . " SET orders_status = '" . HelperFunctions::escapeSql($orderStatus) . "', last_modified = NOW() WHERE orders_id = '" . (int) $xOrderId . "'");