$type = 'NEW';
} // END - if
- // Update sending pool
- SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_pool` SET `data_type`='%s' WHERE `id`=%s AND `sender`=%s AND `data_type`='TEMP' LIMIT 1",
- array(
- $type,
- bigintval(getRequestElement('order')),
- getMemberId()
- ), __FILE__, __LINE__);
-
- // Finally is the entry valid?
- if (!SQL_HASZEROAFFECTED()) {
- // @TODO Unused: 2,4
- // Load mail again... 0 1 2 3 4 5 6 7
- $result = SQL_QUERY_ESC("SELECT `subject`,`text`,`receivers`,`payment_id`,`timestamp`,`url`,`cat_id`,`target_send` FROM `{?_MYSQL_PREFIX?}_pool` WHERE `id`=%s AND `sender`=%s LIMIT 1",
- array(
- bigintval(getRequestElement('order')),
- getMemberId()
- ), __FILE__, __LINE__);
-
- // Merge arrays
- $content = merge_array($content, SQL_FETCHARRAY($result));
-
- // Free result
- SQL_FREERESULT($result);
+ // Update pool data and check if the entry is valid
+ if (!updatePoolDataById(getRequestElement('order'), 'data_type', $type, NULL, sprintf(" AND `sender`=%s AND `data_type`='TEMP'", getMemberId()))) {
+ // Merge array with pool data
+ // @TODO Unused: timestamp
+ $content = merge_array($content, getPoolDataFromId(getRequestElement('order'));
// Fix empty subject line
if (empty($content['subject'])) {
- $content['subject'] = '{--DEFAULT_SUBJECT_LINE--}';
+ $content['subject'] = '{--DEFAULT_SUBJECT--}';
} // END - if
// Calculate used points
- $content['payed_points'] = $content['target_send'] * getPaymentData($content['payment_id']);
+ $content['payed_points'] = $content['target_send'] * getPaymentPrice($content['payment_id']);
// Subtract them from the user's account and ignore return status
subtractPoints('order', getMemberId(), $content['payed_points']);