Filters for configurable userid exclusion added:

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

diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php
index fa35a95d92c0d6cc45e3be45bea8bf2e2893aa98..b5cbe201a128ab1c26912f89bd91df981141000d 100644 (file)
--- a/inc/modules/admin/what-unlock_sponsor.php
+++ b/inc/modules/admin/what-unlock_sponsor.php
@@ -77,19 +77,23 @@ LIMIT 1",
 
                                // Check for open payments and close them
                                $result = SQL_QUERY_ESC("SELECT
-       so.admin_id, so.pay_count,
-       UNIX_TIMESTAMP(so.pay_ordered) AS `pay_ordered`,
-       so.pay_status, sp.pay_name, sp.pay_rate, sp.pay_currency
+       `so`.`admin_id`,
+       `so`.`pay_count`,
+       UNIX_TIMESTAMP(`so`.`pay_ordered`) AS `pay_ordered`,
+       `so`.`pay_status`,
+       `sp`.`pay_name`,
+       `sp`.`pay_rate`,
+       `sp`.`pay_currency`
 FROM
-       `{?_MYSQL_PREFIX?}_sponsor_orders` AS so
+       `{?_MYSQL_PREFIX?}_sponsor_orders` AS `so`
 LEFT JOIN
-       `{?_MYSQL_PREFIX?}_sponsor_paytypes` AS sp
+       `{?_MYSQL_PREFIX?}_sponsor_paytypes` AS `sp`
 ON
-       sp.id=so.payment_id
+       `sp`.`id`=`so`.`payment_id`
 WHERE
-       so.sponsor_id=%s
+       `so`.`sponsor_id`=%s
 ORDER BY
-       sp.pay_name ASC",
+       `sp`.`pay_name` ASC",
                                        array($content['id']), __FILE__, __LINE__);
                                if (!SQL_HASZERONUMS($result)) {
                                        // Payment does exist