- $result_payouts = SQL_QUERY_ESC("SELECT DISTINCT p.id, p.payout_total, p.target_account, p.target_bank, t.type, p.payout_timestamp, p.status, t.allow_url AS allow, p.target_url AS url, p.link_text AS alt, p.banner_url AS banner
-FROM `{!_MYSQL_PREFIX!}_user_payouts` AS p
-LEFT JOIN `{!_MYSQL_PREFIX!}_payout_types` AS t
-ON p.payout_id = t.id
-WHERE p.userid = %s
-ORDER BY p.payout_timestamp DESC",
- array(getUserId()), __FILE__, __LINE__);
- if (SQL_NUMROWS($result_payouts) > 0) {
+ $result_payouts = SQL_QUERY_ESC("SELECT
+ `p`.`id`,
+ `p`.`payout_total`,
+ `p`.`target_account`,
+ `p`.`target_bank`,
+ `t`.`type`,
+ `p`.`payout_timestamp`,
+ `p`.`status`,
+ `t`.`allow_url` AS `allow`,
+ `p`.`target_url` AS `url`,
+ `p`.`link_text`,
+ `p`.`banner_url` AS `banner`
+FROM
+ `{?_MYSQL_PREFIX?}_user_payouts` AS `p`
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_payout_types` AS `t`
+ON
+ `p`.`payout_id`=`t`.`id`
+WHERE
+ `p`.`userid`=%s
+ORDER BY
+ `p`.`payout_timestamp` DESC",
+ array(getMemberId()), __FILE__, __LINE__);
+ if (!SQL_HASZERONUMS($result_payouts)) {