Filters for configurable userid exclusion added:

[mailer.git] / inc / modules / member / what-unconfirmed.php

diff --git a/inc/modules/member/what-unconfirmed.php b/inc/modules/member/what-unconfirmed.php
index c648207612558461c92e5065d963d81e575c58f2..f64ae4ce2fe8c0fe80dd6bdfc2bb952b0cdd0127 100644 (file)
--- a/inc/modules/member/what-unconfirmed.php
+++ b/inc/modules/member/what-unconfirmed.php
@@ -105,13 +105,13 @@ LIMIT 1',
        $result_data = SQL_QUERY_ESC("SELECT
        s.`id`,
        s.`subject`,
-       p.`text`,
+       `p`.`text`,
        s.`timestamp_ordered` AS `timestamp`,
        s.`cat_id`,
        pay.`price` AS `points`,
-       p.`sender`,
+       `p`.`sender`,
        pay.`time`,
-       p.`data_type`
+       `p`.`data_type`
 FROM
        `{?_MYSQL_PREFIX?}_user_stats` AS `s`
 LEFT JOIN
@@ -121,7 +121,7 @@ ON
 LEFT JOIN
        `{?_MYSQL_PREFIX?}_payments` AS `pay`
 ON
-       p.`payment_id`=pay.`id`
+       `p`.`payment_id`=pay.`id`
 WHERE
        s.`id`=%s
 LIMIT 1",
@@ -189,13 +189,13 @@ if (!SQL_HASZERONUMS($result)) {
        s.`timestamp_ordered` AS `timestamp`,
        s.`cat_id`,
        s.`payment_id`,
-       p.`sender`
+       `p`.`sender`
 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.`id`=%s
 LIMIT 1",