Filters for configurable userid exclusion added:

[mailer.git] / inc / libs / refback_functions.php

diff --git a/inc/libs/refback_functions.php b/inc/libs/refback_functions.php
index dcc7740a3244afb061737da102f605f83035465e..a7db2cba3eb7e5c45481860d273966436972ca01 100644 (file)
--- a/inc/libs/refback_functions.php
+++ b/inc/libs/refback_functions.php
@@ -216,26 +216,26 @@ function getArrayFromRefbackUserRefs ($userid, $level) {
 
        // Get refs from database
        $result = SQL_QUERY_ESC("SELECT
-       r.`id`,
-       r.`refid`,
-       r.`refback_percents`,
-       r.`refback_points`,
-       d.`status`,
-       d.`joined`,
-       d.`mails_confirmed`,
-       d.`emails_received`,
-       d.`refid` AS `level_refid`
+       `r`.`id`,
+       `r`.`refid`,
+       `r`.`refback_percents`,
+       `r`.`refback_points`,
+       `d`.`status`,
+       `d`.`joined`,
+       `d`.`mails_confirmed`,
+       `d`.`emails_received`,
+       `d`.`refid` AS `level_refid`
 FROM
-       `{?_MYSQL_PREFIX?}_user_refs` AS r
+       `{?_MYSQL_PREFIX?}_user_refs` AS `r`
 LEFT JOIN
-       `{?_MYSQL_PREFIX?}_user_data` AS d
+       `{?_MYSQL_PREFIX?}_user_data` AS `d`
 ON
-       r.`refid`=d.`userid`
+       `r`.`refid`=`d`.`userid`
 WHERE
-       r.`userid`=%s AND
-       r.`level`=%s
+       `r`.`userid`=%s AND
+       `r`.`level`=%s
 ORDER BY
-       r.`refid` ASC",
+       `r`.`refid` ASC",
                array(bigintval($userid), bigintval($level)), __FUNCTION__, __LINE__);
 
        // Are there some entries?