// Delete mail only once
if (SQL_NUMROWS($result) == 1) {
// Load data
+ // @TODO Unused: cat_id
$content = SQL_FETCHARRAY($result);
- // Get points we shall pay back per mail
- $content['price'] = getPaymentData($content['payment_id'], 'price');
- // @TODO Unused: cat_id, payment_id
-
// Prepare data for the template
$content['timestamp'] = generateDateTime($content['timestamp'], 0);
// Fetch right stats_id from pool
$result_pool = SQL_QUERY_ESC("SELECT
- s.`id`
+ `s`.`id`
FROM
`{?_MYSQL_PREFIX?}_user_stats` AS `s`
LEFT JOIN
`{?_MYSQL_PREFIX?}_pool` AS `p`
ON
- s.`pool_id`=`p`.`id`
+ `s`.`pool_id`=`p`.`id`
WHERE
- s.`pool_id`=%s
+ `s`.`pool_id`=%s
LIMIT 1",
array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);
if (SQL_NUMROWS($result_pool) == 1) {