Rewrote a lot parts to extract 'payments' table (+ handling) into own extension:

[mailer.git] / inc / modules / admin / what-del_email.php

diff --git a/inc/modules/admin/what-del_email.php b/inc/modules/admin/what-del_email.php
index 1ffcee889cc0b3fc3cc9c9c002487c0481c507a5..60705d4ea662fe530f06f2ae96ac71c599faecc2 100644 (file)
--- a/inc/modules/admin/what-del_email.php
+++ b/inc/modules/admin/what-del_email.php
@@ -54,12 +54,9 @@ if ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (post
        // 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);
 
@@ -72,15 +69,15 @@ if ((isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (post
 
                // 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) {