* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
`id`, `gender`, `surname`, `family`, `email`, `remote_addr`,
UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`,
`points_amount`, `points_used`,
`id`, `gender`, `surname`, `family`, `email`, `remote_addr`,
UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`,
`points_amount`, `points_used`,
- $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
+ $result = sqlQueryEscaped("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`
// Update, if applyable, referral count and points
if ((isValidId($content['refid'])) && ($content['refid'] != $content['id'])) {
// Update referral account
// Update, if applyable, referral count and points
if ((isValidId($content['refid'])) && ($content['refid'] != $content['id'])) {
// Update referral account
`{?_MYSQL_PREFIX?}_sponsor_data`
SET
`points_amount`=`points_amount`+{?sponsor_ref_points?},
`{?_MYSQL_PREFIX?}_sponsor_data`
SET
`points_amount`=`points_amount`+{?sponsor_ref_points?},
array(bigintval($content['refid'])), __FILE__, __LINE__);
// Whas that update fine?
array(bigintval($content['refid'])), __FILE__, __LINE__);
// Whas that update fine?
`id`, `gender`, `surname`, `family`, `email`, `remote_addr`,
UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`
FROM
`id`, `gender`, `surname`, `family`, `email`, `remote_addr`,
UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`
FROM