// 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