- // Load referal points
- $result_points = SQL_QUERY_ESC("SELECT points, locked_points FROM `{!_MYSQL_PREFIX!}_user_points` WHERE userid=%s AND ref_depth=%d LIMIT 1", array(getUserId(), bigintval($content['level'])), __FILE__, __LINE__);
+// Load ref levels
+while ($data = SQL_FETCHARRAY($result_depths)) {
+ // Init points and counter here
+ $content['counter'] = '0';
+ $content['points'] = '0.00000';
+ $content['order_points'] = '0.00000';
+ $content['locked_points'] = '0.00000';
+ $content['locked_order_points'] = '0.00000';
+
+ // Merge it together
+ $content = merge_array($content, $data);
+
+ // Default for referral level > 0
+ $depth = 'p.`ref_depth`=%s';
+ if (is_null($content['level'])) {
+ $depth = 'p.`ref_depth` IS NULL';
+ } // END - if
+
+ // Load referral points
+ $result_points = SQL_QUERY_ESC('SELECT
+ ' . getAllPointColumns('p.', ',') . '
+ r.`counter`
+FROM
+ `{?_MYSQL_PREFIX?}_user_points` AS p
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_refsystem` AS r
+ON
+ p.`userid`=r.`userid` AND
+ p.`ref_depth`=r.`level`
+WHERE
+ p.`userid`=%s AND
+ ' . $depth . '
+LIMIT 1',
+ array(
+ getMemberId(),
+ convertZeroToNull($content['level'])
+ ), __FILE__, __LINE__);
+
+ // Do we have an entry?