-while (list($lvl, $per) = SQL_FETCHROW($result_depths))
-{
- // Initialize ref-count
- $REFS = "0";
-
- // Load referral points
- $result_points = SQL_QUERY_ESC("SELECT points, locked_points FROM "._MYSQL_PREFIX."_user_points WHERE userid=%d AND ref_depth='%s' LIMIT 1", array($GLOBALS['userid'], bigintval($lvl)), __FILE__, __LINE__);
- if (SQL_NUMROWS($result_points) == 1)
- {
- list($POINTS, $LOCKED) = SQL_FETCHROW($result_points);
- SQL_FREERESULT($result_points);
- // Also count locked points
- $TPTS += $POINTS; $TLOCK += $LOCKED;
- }
- else
- {
- $POINTS = "0.00000"; $LOCKED = "0.00000";
- }
-
- // Load referral counts
- $result_refs = SQL_QUERY_ESC("SELECT counter FROM "._MYSQL_PREFIX."_refsystem WHERE userid=%d AND level='%s' LIMIT 1", array($GLOBALS['userid'], bigintval($lvl)), __FILE__, __LINE__);
- if (SQL_NUMROWS($result_refs) == 1)
- {
- list($REFS) = SQL_FETCHROW($result_refs);
- SQL_FREERESULT($result_refs);
- $TREF += $REFS;
- }
- else
- {
- $REFS = "0";
- }
-
- // Transfer data to array for template
- $content = array(
- 'lvl' => $lvl,
- 'per' => $per,
- 'points' => TRANSLATE_COMMA($POINTS),
- 'refs' => $REFS,
- );
+while ($data = SQL_FETCHARRAY($result_depths)) {
+ // Merge it together
+ $content = merge_array($content, $data);
+
+ // Initialize array elements
+ $content['counter'] = '0';
+ $content['points'] = '0.00000';
+ $content['locked_points'] = '0.00000';
+
+ // Load referal points
+ $result_points = SQL_QUERY_ESC("SELECT `points`, `locked_points` FROM `{?_MYSQL_PREFIX?}_user_points` WHERE `userid`=%s AND `ref_depth`='%s' LIMIT 1",
+ array(
+ getMemberId(),
+ bigintval($content['level'])
+ ), __FILE__, __LINE__);
+
+ // Do we have an entry?
+ if (SQL_NUMROWS($result_points) == 1) {
+ // Load data
+ $content = merge_array($content, SQL_FETCHARRAY($result_points));
+
+ // Add both points
+ $totalPoints += $content['points'];
+ $totalLocked += $content['locked_points'];
+ } // END - if
+
+ // Free result
+ SQL_FREERESULT($result_points);
+
+ // Load referal counts
+ $result_refs = SQL_QUERY_ESC("SELECT `counter` FROM `{?_MYSQL_PREFIX?}_refsystem` WHERE `userid`=%s AND `level`='%s' LIMIT 1",
+ array(
+ getMemberId(),
+ bigintval($content['level'])
+ ), __FILE__, __LINE__);
+
+ // Do we have an entry?
+ if (SQL_NUMROWS($result_refs) == 1) {
+ // Load data
+ $content = merge_array($content, SQL_FETCHARRAY($result_refs));
+
+ // Add them to total refs
+ $totalReferals += $content['counter'];
+ } // END - if
+
+ // Free result
+ SQL_FREERESULT($result_refs);