* $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`
// Merge both arrays
$content = merge_array($content, $content2);
// Set default email
$content['email'] = '{--SPONSOR_NO_ADMIN--}';
// Merge both arrays
$content = merge_array($content, $content2);
// Set default email
$content['email'] = '{--SPONSOR_NO_ADMIN--}';
array($content['id']), __FILE__, __LINE__);
// Update, if applyable, referral count and points
array($content['id']), __FILE__, __LINE__);
// Update, if applyable, referral count and points
`{?_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
// Translate some data
$content['sponsor_created'] = generateDateTime($content['sponsor_created'], 2);
// Load row template and switch colors
// Translate some data
$content['sponsor_created'] = generateDateTime($content['sponsor_created'], 2);
// Load row template and switch colors