Filters for configurable userid exclusion added:

[mailer.git] / inc / wrapper-functions.php

diff --git a/inc/wrapper-functions.php b/inc/wrapper-functions.php
index db7fa084b3a6a2394fd907b56f365cf5bdfa156b..35af66dc4477c33836cfe9c47105bf21ee5b8b7e 100644 (file)
--- a/inc/wrapper-functions.php
+++ b/inc/wrapper-functions.php
@@ -3313,24 +3313,24 @@ function getUsersTotalLockedReferrals ($userid, $level = NULL) {
                // Is the not level NULL?
                if (!is_null($level)) {
                        // Then add referral level
-                       $add = ' AND r.`level`=' . bigintval($level);
+                       $add = ' AND `r`.`level`=' . bigintval($level);
                } // END - if
 
                // Check for all referrals
                $result = SQL_QUERY_ESC("SELECT
-       COUNT(d.`userid`) AS `cnt`
+       COUNT(`d`.`userid`) AS `cnt`
 FROM
-       `{?_MYSQL_PREFIX?}_user_data` AS d
+       `{?_MYSQL_PREFIX?}_user_data` AS `d`
 INNER JOIN
-       `{?_MYSQL_PREFIX?}_user_refs` AS r
+       `{?_MYSQL_PREFIX?}_user_refs` AS `r`
 ON
-       d.`userid`=r.`refid`
+       `d`.`userid`=`r`.`refid`
 WHERE
-       d.`status` != 'CONFIRMED' AND
-       r.`userid`=%s
+       `d`.`status` != 'CONFIRMED' AND
+       `r`.`userid`=%s
        " . $add . "
 ORDER BY
-       d.`userid` ASC
+       `d`.`userid` ASC
 LIMIT 1",
                        array(
                                $userid