/** * get and return the array with the sessionData - needed ONLY for insertion of the order by notification */ public function getSavedSessionData($transactionId, $paymentSecret) { // Notice: Sessiondata will be inserted into DB in callback/sofort/helperfunctions.php -> insertSofortOrder(); $query = xtc_db_query('SELECT serialized_session FROM sofort_orders WHERE payment_secret = "' . HelperFunctions::escapeSql($paymentSecret) . '" AND transaction_id = "' . HelperFunctions::escapeSql($transactionId) . '" AND data_acquired = "0"'); $result = xtc_db_fetch_array($query); if (isset($result['serialized_session']) && !empty($result['serialized_session'])) { xtc_db_query('UPDATE sofort_orders SET data_acquired = "1" WHERE payment_secret = "' . HelperFunctions::escapeSql($paymentSecret) . '" AND transaction_id = "' . HelperFunctions::escapeSql($transactionId) . '"'); HelperFunctions::includeOrderTotalFiles(); return unserialize($result['serialized_session']); } else { return false; } }