// Check for his payouts
$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`
+ `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`
+ `p`.`payout_id`=`t`.`id`
WHERE
- p.`userid` = %s
+ `p`.`userid`=%s
ORDER BY
- p.`payout_timestamp` DESC",
+ `p`.`payout_timestamp` DESC",
array(getMemberId()), __FILE__, __LINE__);
if (!SQL_HASZERONUMS($result_payouts)) {
// List all his requests
}
} else {
// Chedk if he can get paid by selected type
- $result = SQL_QUERY_ESC("SELECT `type`, `rate`, `min_points`, `allow_url` AS allow FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
+ $result = SQL_QUERY_ESC("SELECT `type`, `rate`, `min_points`, `allow_url` AS `allow` FROM `{?_MYSQL_PREFIX?}_payout_types` WHERE `id`=%s LIMIT 1",
array(bigintval(getRequestElement('payout'))), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {