- $OUT .= LOAD_TEMPLATE("guest_top10_empty4", true, $content);
- $SW = 3 - $SW;
- }
-}
-define('__TOP_POINTS_ROWS', $OUT);
-
-//// TOP referal "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;
-
+ $OUT .= loadTemplate('guest_top10_empty4', TRUE, $content);
+ } // END - for
+} // END - if
+
+// Remember the rows in array
+$rows['points_out'] = $OUT;
+
+// Free result
+sqlFreeResult($result);
+
+// TOP referral "hunter"
+$result = sqlQuery("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'
+ " . runFilterChain('user_exclusion_sql', ' ') . "
+GROUP BY
+ `r`.`userid`
+ORDER BY
+ `refs` DESC,
+ `d`.`last_online` DESC
+LIMIT {?top10_max?}", __FILE__, __LINE__);
+
+$OUT = ''; $count = 1;
+while ($content = sqlFetchArray($result)) {