- $result = SQL_QUERY("SELECT DISTINCT COUNT(t.id), SUM(t.points)
-FROM `{!_MYSQL_PREFIX!}_user_transfers_in` AS t
-LEFT JOIN `{!_MYSQL_PREFIX!}_user_data` AS d
-ON t.userid=d.userid",
- __FILE__, __LINE__);
- list($count_in, $points_in) = SQL_FETCHROW($result);
- SQL_FREERESULT($result);
- if (empty($count_in)) $count_in = 0;
- if (empty($points_in)) $points_in = 0;
-
- $result = SQL_QUERY("SELECT DISTINCT COUNT(t.id), SUM(t.points)
-FROM `{!_MYSQL_PREFIX!}_user_transfers_out` AS t
-LEFT JOIN `{!_MYSQL_PREFIX!}_user_data` AS d
-ON t.userid=d.userid",
+ $result = sqlQuery("SELECT
+ COUNT(`t`.`id`) AS `cnt`,
+ SUM(`t`.`points`) AS `points`
+FROM
+ `{?_MYSQL_PREFIX?}_user_transfers_in` AS `t`
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_user_data` AS `d`
+ON
+ `t`.`userid`=`d`.`userid`
+" . runFilterChain('user_exclusion_sql', ''),
+ __FILE__, __LINE__);
+ list($count_in, $points_in) = sqlFetchRow($result);
+ sqlFreeResult($result);
+ if (empty($count_in)) $count_in = '0';
+ if (empty($points_in)) $points_in = '0';
+
+ $result = sqlQuery("SELECT
+ COUNT(`t`.`id`) AS `cnt`, SUM(`t`.`points`) AS `points`
+FROM
+ `{?_MYSQL_PREFIX?}_user_transfers_out` AS `t`
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_user_data` AS `d`
+ON
+ `t`.`userid`=`d`.`userid`
+" . runFilterChain('user_exclusion_sql', ''),