// Check for open payments and close them
$result = SQL_QUERY_ESC("SELECT
- so.admin_id, so.pay_count,
- UNIX_TIMESTAMP(so.pay_ordered) AS `pay_ordered`,
- so.pay_status, sp.pay_name, sp.pay_rate, sp.pay_currency
+ `so`.`admin_id`,
+ `so`.`pay_count`,
+ UNIX_TIMESTAMP(`so`.`pay_ordered`) AS `pay_ordered`,
+ `so`.`pay_status`,
+ `sp`.`pay_name`,
+ `sp`.`pay_rate`,
+ `sp`.`pay_currency`
FROM
- `{?_MYSQL_PREFIX?}_sponsor_orders` AS so
+ `{?_MYSQL_PREFIX?}_sponsor_orders` AS `so`
LEFT JOIN
- `{?_MYSQL_PREFIX?}_sponsor_paytypes` AS sp
+ `{?_MYSQL_PREFIX?}_sponsor_paytypes` AS `sp`
ON
- sp.id=so.payment_id
+ `sp`.`id`=`so`.`payment_id`
WHERE
- so.sponsor_id=%s
+ `so`.`sponsor_id`=%s
ORDER BY
- sp.pay_name ASC",
+ `sp`.`pay_name` ASC",
array($content['id']), __FILE__, __LINE__);
if (!SQL_HASZERONUMS($result)) {
// Payment does exist