- }
-}
-define('__TOP_POINTS_ROWS', $OUT);
-
-//// TOP referral "hunter"
-$result = SQL_QUERY_ESC("SELECT DISTINCT r.userid, d.".$ADD.", SUM(r.counter) AS refs, d.last_online
-FROM "._MYSQL_PREFIX."_refsystem AS r
-LEFT JOIN "._MYSQL_PREFIX."_user_data AS d
-ON r.userid=d.userid
-WHERE r.counter > 0 AND d.status='CONFIRMED'
-GROUP BY r.userid
-ORDER BY refs DESC, d.last_online DESC
-LIMIT %s",
- array($CONFIG['top10_max']), __FILE__, __LINE__);
-
-$OUT = ""; $SW = 2; $cnt = 1;
-while(list($uid, $nick, $refs, $last) = SQL_FETCHROW($result))
-{
- $nick2 = "---";
- if (($nick != $uid) && (!empty($nick))) $nick2 = $nick;
+ } // END - for
+} // END - if
+
+// Remember the rows in array
+$rows['points_out'] = $OUT;
+
+// Free result
+SQL_FREERESULT($result);
+
+//// TOP referal "hunter"
+$result = SQL_QUERY("SELECT
+ d.userid,
+ SUM(r.counter) AS refs,
+ d.last_online
+FROM
+ `{?_MYSQL_PREFIX?}_user_data` AS d
+LEFT JOIN
+ {?_MYSQL_PREFIX?}_refsystem AS r
+ON
+ r.userid=d.userid
+WHERE
+ r.counter > 0 AND
+ d.`status`='CONFIRMED'
+GROUP BY
+ r.userid
+ORDER BY
+ refs DESC,
+ d.last_online DESC
+LIMIT {?top10_max?}", __FILE__, __LINE__);
+
+$OUT = ''; $SW = 2; $cnt = 1;
+while ($content = SQL_FETCHARRAY($result)) {
+ // Init nickname
+ $content['nickname'] = '---';
+
+ // Get nickname
+ if (isExtensionActive('nickname')) $content['nickname'] = getNickname($content['userid']);