Filters for configurable userid exclusion added:

[mailer.git] / inc / filter / earning_filter.php

diff --git a/inc/filter/earning_filter.php b/inc/filter/earning_filter.php
index 0b4bcace8550aea32ecd71b43c7740ec4be5c1e2..84d15f33f2b01b6f9483316e2877c8a3027706ef 100644 (file)
--- a/inc/filter/earning_filter.php
+++ b/inc/filter/earning_filter.php
@@ -51,27 +51,27 @@ function FILTER_ADD_EARNING_GROUP_POPUP ($filterData) {
 
        // Now check if the user has subscription and amount left
        $result = SQL_QUERY_ESC("SELECT
-       d.`earning_id`,
-       d.`earning_provider`,
-       u.`earning_current_amount`,
-       u.`earning_daily_amount`,
-       u.`earning_active`,
-       u.`earning_added`,
-       u.`earning_canceled`,
-       u.`earning_points`
+       `d`.`earning_id`,
+       `d`.`earning_provider`,
+       `u`.`earning_current_amount`,
+       `u`.`earning_daily_amount`,
+       `u`.`earning_active`,
+       `u`.`earning_added`,
+       `u`.`earning_canceled`,
+       `u`.`earning_points`
 FROM
-       `{?_MYSQL_PREFIX?}_user_earning` AS u
+       `{?_MYSQL_PREFIX?}_user_earning` AS `u`
 INNER JOIN
-       `{?_MYSQL_PREFIX?}_earning_data` AS d
+       `{?_MYSQL_PREFIX?}_earning_data` AS `d`
 ON
-       u.`earning_id`=d.`earning_id`
+       `u`.`earning_id`=`d`.`earning_id`
 WHERE
-       u.`earning_userid`=%s AND
-       u.`earning_active`='Y' AND
-       u.`earning_current_amount` < u.`earning_daily_amount` AND
-       d.`earning_group`='POPUP'
+       `u`.`earning_userid`=%s AND
+       `u`.`earning_active`='Y' AND
+       `u`.`earning_current_amount` < `u`.`earning_daily_amount` AND
+       `d`.`earning_group`='POPUP'
 ORDER BY
-       d.`earning_sorting` ASC",
+       `d`.`earning_sorting` ASC",
                array(
                        getMemberId()
                ), __FUNCTION__, __LINE__);