Filters for configurable userid exclusion added:

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

diff --git a/inc/modules/admin/what-list_unconfirmed.php b/inc/modules/admin/what-list_unconfirmed.php
index 02479af987dbec95d27837c48284c8d0b90cac3c..53de7682da4a1022b4c0066103b0e2221ae083ac 100644 (file)
--- a/inc/modules/admin/what-list_unconfirmed.php
+++ b/inc/modules/admin/what-list_unconfirmed.php
@@ -58,15 +58,21 @@ $sql = '';
 if (isGetRequestElementSet('mid')) {
        // SQL query for mail data
        $sql = sprintf("SELECT
-       s.`id`, p.`sender`, p.`subject`, p.`text`, p.`url`, p.`timestamp`, s.`max_rec`
+       s.`id`,
+       `p`.`sender`,
+       `p`.`subject`,
+       `p`.`text`,
+       `p`.`url`,
+       `p`.`timestamp`,
+       s.`max_rec`
 FROM
-       `{?_MYSQL_PREFIX?}_pool` AS p
+       `{?_MYSQL_PREFIX?}_pool` AS `p`
 LEFT JOIN
-       `{?_MYSQL_PREFIX?}_user_stats` AS s
+       `{?_MYSQL_PREFIX?}_user_stats` AS `s`
 ON
-       p.id=s.pool_id
+       `p`.`id`=s.`pool_id`
 WHERE
-       p.`id`=%s
+       `p`.`id`=%s
 LIMIT 1",
                bigintval(getRequestElement('mid'))
        );
@@ -140,17 +146,17 @@ if (($listed === TRUE) && (!empty($sql))) {
                // accounts. So if you have delete one you did not see those links
                $result = SQL_QUERY_ESC("SELECT
        l.`userid`,
-       u.`status`,
-       u.`surname`,
-       u.`family`,
-       u.`gender`,
-       u.`email`
+       `u`.`status`,
+       `u`.`surname`,
+       `u`.`family`,
+       `u`.`gender`,
+       `u`.`email`
 FROM
        `{?_MYSQL_PREFIX?}_user_links` AS `l`
 LEFT JOIN
        `{?_MYSQL_PREFIX?}_user_data` AS `u`
 ON
-       l.`userid`=u.`userid`
+       l.`userid`=`u`.`userid`
 WHERE
        l.`%s`=%s
 ORDER BY